2025-10-17 11:00:29 执行时长：5.19秒 sql:exec [GB_AuditorSchedule] '2025-10-01','','','','','','','0.5','ISCSCB'

2025-10-17 11:02:37 执行时长：26.1秒 sql:select count(distinct a.auditorcode) from GB_ProjectPlanTeam a   inner join GB_ProjectPlan b on a.taskno=b.taskno  inner join (select a.OrgID from View_Org a left join base_user b on a.P_orgID=b.OrgID  where UserID='ISC-93566') c  on b.org=c.orgid and c.orgid<>''  where b.begindate>='2025-10-01'  and b.begindate<'2025-11-01'  and a.techlevel<>'04' 

2025-10-17 11:06:11 执行时长：6.19秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-10-17 11:14:11 执行时长：5.03秒 sql:exec [GB_AuditorSchedule] '2025-10-01','','','','','','','0.5','ISCSCB'