2025-12-18 09:23:02 执行时长：9.58秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','liudajun'

2025-12-18 09:24:12 执行时长：6.58秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','','0.5','ISC0601'

2025-12-18 09:28:21 执行时长：5.99秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0602'

2025-12-18 09:28:31 执行时长：6.79秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISCSCB'

2025-12-18 09:29:43 执行时长：15.59秒 sql:exec [GB_AuditorSchedule] '','','','','','','','','ISCSCB'

2025-12-18 09:32:34 执行时长：5.1秒 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-12-18 09:32:44 执行时长：15.26秒 sql:exec [GB_AuditorSchedule] '2025-12-01','2026-01-28','','','','','123','0.5','ISC0601'

2025-12-18 09:32:54 执行时长：24.41秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISCTY'

2025-12-18 09:33:10 执行时长：8.01秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','23','','0.5','ISC0603'

2025-12-18 09:33:21 执行时长：49.13秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','','0.5','ISCTY'

2025-12-18 09:33:23 执行时长：23.96秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC-M-01'

2025-12-18 09:33:33 执行时长：6.54秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISCTY'

2025-12-18 09:37:39 执行时长：12.69秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','122','0.5','ISC-M-01'

2025-12-18 09:39:46 执行时长：17.26秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','0001','122','0.5','ISCTY'

2025-12-18 09:41:29 执行时长：6.08秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0031'