2025-08-29 15:09:17 执行时长：56.17秒 sql:SELECT case isnull(人员信息表.[ID],'') when  '' then '<未填>' else 人员信息表.[ID] end AS [系统主键], count(distinct 人员信息表.id) as 数量 FROM GB_Auditor 人员信息表 WITH(NOLOCK)  LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN GB_PersonnelAffiliation [人员归属_领域归属] WITH(NOLOCK) ON 人员信息表.PersonnelAffiliation = [人员归属_领域归属].PriceCode LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN Pub_Code [合同类型_代码表] WITH(NOLOCK) ON 人员信息表.ContractType = [合同类型_代码表].CodeID LEFT JOIN GB_AuditorRegister [注册与保持] ON 人员信息表.AuditorCode = [注册与保持].AuditorCode LEFT JOIN GB_AuditorProfessional [人员专业能力] ON 人员信息表.AuditorCode = [人员专业能力].AuditorCode LEFT JOIN GB_AuditorEducation [教育经历] ON 人员信息表.AuditorCode = [教育经历].AuditorCode LEFT JOIN GB_AuditorTrainning [入职培训] ON 人员信息表.AuditorCode = [入职培训].AuditorCode LEFT JOIN GB_Complaint [审核员投诉记录] ON 人员信息表.AuditorCode = [审核员投诉记录].AuditorCode LEFT JOIN GB_AuditorHis [人员简历] ON 人员信息表.AuditorCode = [人员简历].AuditorCode where ([专兼职_代码表].[CodeName] like '%专职%') and ([聘用状态_代码表].[CodeName] like '%在聘%') group by 人员信息表.[ID] order by count(人员信息表.id) desc

2025-08-29 15:43:33 执行时长：5.51秒 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-08-29 15:50:07 执行时长：5.66秒 sql:exec [GB_AuditorSchedule] '2025-08-01','2025-09-10','','','','','','0.5','ISC0601'