2025-09-15 14:04:02 执行时长：6.34秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ( [审核计划].[DocReturnDate] = '' or  [审核计划].[DocReturnDate] is null)  AND [审核计划].[CommitDate] > '2025-01-01' and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2025-09-15 14:05:17 执行时长：193.01秒 sql:SELECT case isnull(人员信息表.[AuditorName],'') when  '' then '<未填>' else 人员信息表.[AuditorName] 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 '%在聘%') group by 人员信息表.[AuditorName] order by count(人员信息表.id) desc