2025-07-24 14:21:56 执行时长：5.57秒 sql:exec [GB_AuditorSchedule] '2025-07-01','','','','','','123','0.5','ISC0042'

2025-07-24 14:28:48 执行时长：5.19秒 sql:exec GB_RecentlyCerti 'ISC[S]0044'

2025-07-24 14:31:09 执行时长：5.02秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,人员专业能力.[AuditorName] AS [人员姓名],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期],[风险等级_代码表].CodeName AS [风险等级],[组织机构_组织机构].OrgName AS [组织机构] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding WHERE ([人员编号_人员信息表].[StaffStatus] = '127') AND ( [人员专业能力].AuditorName like '%文平%' and ([认证领域_认证领域].[FieldName] like '%质量管理体系%') and [专业代码_专业代码库].[ProfessionalCode] like '%34.06.00%') ) as CurrentCount

2025-07-24 14:52:01 执行时长：8.42秒 sql:exec GB_PartnerBizStatistics '2025','ISC[S]0044'

2025-07-24 14:53:37 执行时长：5.06秒 sql:exec [GB_SuperRateStatistics] '2025','ISC[S]0044'