2025-09-10 17:05:36 执行时长：9.86秒 sql:SELECT DISTINCT 审核计划.ID  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode 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 GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo WHERE ((( [审核计划].[PlanStatus] >= '13'  and [审核类别_审核类别].[ClassName] in ('二阶段','监查1','监查2','监督3','监督4','再认证','补充','变更')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = '合格档'or [评定状态_评定状态].[StatusName] = '问题档' OR [审核计划].[IsReform] =1)))) AND ( 1=2  or 审核计划.[BizAddress] like '%M%'  or 审核计划.[AcceptDate] like '%M%'  or 审核计划.[CertiQty] like '%M%'  or 审核计划.[FeeDays] like '%M%'  or 审核计划.[CheckDate] like '%M%'  or [评定状态_评定状态].StatusName like '%M%' or [批准结论_批准结论].ResultName like '%M%' or 审核计划.[SuperNoticeDate] like '%M%'  or 审核计划.[SuperCommitDate] like '%M%'  or [组织名称_组织信息].CorpName like '%M%' or 审核计划.[UrgentReason] like '%M%'  or 审核计划.[ReformDate] like '%M%'  or [标准代码_认证标准].StandardCode like '%M%' or [审核类型_审核类型].TypeName like '%M%' or [审核类别_审核类别].ClassName like '%M%' or 审核计划.[DecideOn] like '%M%'  or 审核计划.[AuditTeam] like '%M%'  or 审核计划.[BeginDate] like '%M%'  or 审核计划.[EndDate] like '%M%'  or [认可标志_认可标志].RecogName like '%M%' or 审核计划.[SupportBy] like '%M%'  or [计划状态_计划状态].StatusName like '%M%' or 审核计划.[PlanNo] like '%M%'  or 审核计划.[TaskNo] like '%M%'  or 审核计划.[FollowUpTracking] like '%M%'  or [跟踪结果_跟踪结果].StatusName like '%M%' or [阅卷人员_登录用户].UserName like '%M%' or [评定人员_登录用户].UserName like '%M%' or 审核计划.[DocReceiveBy] like '%M%'  or 审核计划.[ScopeOfEvaluation] like '%M%'  or [项目分级_案卷质量].LevelName like '%M%' or [组长分级_案卷质量].LevelName like '%M%' or [案卷质量_案卷质量].LevelName like '%M%' or 审核计划.[ProfessionalEvaluation] like '%M%'  or [申请单号_认证申请].ApplyNo like '%M%' or [项目编号_认证项目].ProjectNo like '%M%' or 审核计划.[ContractNo] like '%M%'  or [合同来源_合同来源].OrgName like '%M%' or [省份_省份].Province like '%M%' or 审核计划.[StandardName] like '%M%'  or [认证领域_认证领域].FieldName like '%M%' or 审核计划.[FeeDate] like '%M%'  or 审核计划.[ChangeInfo] like '%M%'  or 审核计划.[SuperQty] like '%M%'  or 审核计划.[ReviewRemarks] like '%M%'  or 审核计划.[ReCertiQty] like '%M%'  or 审核计划.[ProfessionalCode] like '%M%'  or 审核计划.[ApproveRange] like '%M%'  or 审核计划.[BasicDays] like '%M%'  or 审核计划.[FirstOffSiteHumanDays] like '%M%'  or 审核计划.[FirstStageOnsiteDays] like '%M%'  or 审核计划.[SecondStageDays] like '%M%'  or 审核计划.[SupervisoryDays] like '%M%'  or 审核计划.[ReexaminationDays] like '%M%'  or [风险等级_代码表].CodeName like '%M%' or 审核计划.[TotalDays] like '%M%'  or 审核计划.[ApproveDays] like '%M%'  or [审核方式_审核方式].ApproveMode like '%M%' or 审核计划.[ReportDate] like '%M%'  or 审核计划.[CertiFee] like '%M%'  or 审核计划.[IssuesToBeNoted] like '%M%'  or 审核计划.[PlanRemarks] like '%M%'  or 审核计划.[ReturnDate] like '%M%'  or 审核计划.[ReasonForReturn] like '%M%'  or 审核计划.[DispatchBy] like '%M%'  or 审核计划.[RetrivalDate] like '%M%'  or 审核计划.[DispatchDate] like '%M%'  or 审核计划.[Approver] like '%M%'  or 审核计划.[ApproveDate] like '%M%'  or 审核计划.[ReceiveDate] like '%M%'  or 审核计划.[DistributeOn] like '%M%'  or 审核计划.[ReasonsForAuditFailure] like '%M%'  or 审核计划.[AcceptanceEvaluationTime] like '%M%'  or 审核计划.[PlanCommitDate] like '%M%'  or 审核计划.[CommitDate] like '%M%'  or 审核计划.[ReviewDate] like '%M%'  or 审核计划.[DocReturnDate] like '%M%'  or 审核计划.[ReturnContractQty] like '%M%'  or 审核计划.[DocReceiveRemark] like '%M%'  or 审核计划.[ReturnReason] like '%M%'  or 审核计划.[UnPassReason] like '%M%'  or 审核计划.[ProcessResult] like '%M%'  or 审核计划.[SuperviseEndDate] like '%M%'  or 审核计划.[NextApproveType] like '%M%'  or 审核计划.[NextApproveDate] like '%M%'  or 审核计划.[CertiInfo] like '%M%'  or 审核计划.[CertiAcceptanceDate] like '%M%'  or 审核计划.[CertiCompletionDate] like '%M%'  or 审核计划.[NonCompliantTerms] like '%M%'  or 审核计划.[NextAuditAdvice] like '%M%'  or 审核计划.[NextAuditFocus] like '%M%'  or 审核计划.[PlanApproveDate] like '%M%'  or [联系结果_联系结果].ResultName like '%M%' or 审核计划.[ToScheduleDate] like '%M%'  or 审核计划.[ProjectLeader] like '%M%'  or 审核计划.[PlanReturnReason] like '%M%'  or 审核计划.[ToScheduleInfo] like '%M%'  or 审核计划.[FromChangeNo] like '%M%'  or 审核计划.[ReceiveDateI] like '%M%'  or [合同申请接收人_登录用户].UserName like '%M%' or 审核计划.[MoveDate] like '%M%'  or 审核计划.[HandOverBy] like '%M%'  or 审核计划.[MailingInformation] like '%M%' )

2025-09-10 17:07:11 执行时长：6.09秒 sql:SELECT DISTINCT 审核计划.ID  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode 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 GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo WHERE ((( [审核计划].[PlanStatus] >= '13'  and [审核类别_审核类别].[ClassName] in ('二阶段','监查1','监查2','监督3','监督4','再认证','补充','变更')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = '合格档'or [评定状态_评定状态].[StatusName] = '问题档' OR [审核计划].[IsReform] =1)))) AND ( 1=2  or 审核计划.[BizAddress] like '%M%'  or 审核计划.[AcceptDate] like '%M%'  or 审核计划.[CertiQty] like '%M%'  or 审核计划.[FeeDays] like '%M%'  or 审核计划.[CheckDate] like '%M%'  or [评定状态_评定状态].StatusName like '%M%' or [批准结论_批准结论].ResultName like '%M%' or 审核计划.[SuperNoticeDate] like '%M%'  or 审核计划.[SuperCommitDate] like '%M%'  or [组织名称_组织信息].CorpName like '%M%' or 审核计划.[UrgentReason] like '%M%'  or 审核计划.[ReformDate] like '%M%'  or [标准代码_认证标准].StandardCode like '%M%' or [审核类型_审核类型].TypeName like '%M%' or [审核类别_审核类别].ClassName like '%M%' or 审核计划.[DecideOn] like '%M%'  or 审核计划.[AuditTeam] like '%M%'  or 审核计划.[BeginDate] like '%M%'  or 审核计划.[EndDate] like '%M%'  or [认可标志_认可标志].RecogName like '%M%' or 审核计划.[SupportBy] like '%M%'  or [计划状态_计划状态].StatusName like '%M%' or 审核计划.[PlanNo] like '%M%'  or 审核计划.[TaskNo] like '%M%'  or 审核计划.[FollowUpTracking] like '%M%'  or [跟踪结果_跟踪结果].StatusName like '%M%' or [阅卷人员_登录用户].UserName like '%M%' or [评定人员_登录用户].UserName like '%M%' or 审核计划.[DocReceiveBy] like '%M%'  or 审核计划.[ScopeOfEvaluation] like '%M%'  or [项目分级_案卷质量].LevelName like '%M%' or [组长分级_案卷质量].LevelName like '%M%' or [案卷质量_案卷质量].LevelName like '%M%' or 审核计划.[ProfessionalEvaluation] like '%M%'  or [申请单号_认证申请].ApplyNo like '%M%' or [项目编号_认证项目].ProjectNo like '%M%' or 审核计划.[ContractNo] like '%M%'  or [合同来源_合同来源].OrgName like '%M%' or [省份_省份].Province like '%M%' or 审核计划.[StandardName] like '%M%'  or [认证领域_认证领域].FieldName like '%M%' or 审核计划.[FeeDate] like '%M%'  or 审核计划.[ChangeInfo] like '%M%'  or 审核计划.[SuperQty] like '%M%'  or 审核计划.[ReviewRemarks] like '%M%'  or 审核计划.[ReCertiQty] like '%M%'  or 审核计划.[ProfessionalCode] like '%M%'  or 审核计划.[ApproveRange] like '%M%'  or 审核计划.[BasicDays] like '%M%'  or 审核计划.[FirstOffSiteHumanDays] like '%M%'  or 审核计划.[FirstStageOnsiteDays] like '%M%'  or 审核计划.[SecondStageDays] like '%M%'  or 审核计划.[SupervisoryDays] like '%M%'  or 审核计划.[ReexaminationDays] like '%M%'  or [风险等级_代码表].CodeName like '%M%' or 审核计划.[TotalDays] like '%M%'  or 审核计划.[ApproveDays] like '%M%'  or [审核方式_审核方式].ApproveMode like '%M%' or 审核计划.[ReportDate] like '%M%'  or 审核计划.[CertiFee] like '%M%'  or 审核计划.[IssuesToBeNoted] like '%M%'  or 审核计划.[PlanRemarks] like '%M%'  or 审核计划.[ReturnDate] like '%M%'  or 审核计划.[ReasonForReturn] like '%M%'  or 审核计划.[DispatchBy] like '%M%'  or 审核计划.[RetrivalDate] like '%M%'  or 审核计划.[DispatchDate] like '%M%'  or 审核计划.[Approver] like '%M%'  or 审核计划.[ApproveDate] like '%M%'  or 审核计划.[ReceiveDate] like '%M%'  or 审核计划.[DistributeOn] like '%M%'  or 审核计划.[ReasonsForAuditFailure] like '%M%'  or 审核计划.[AcceptanceEvaluationTime] like '%M%'  or 审核计划.[PlanCommitDate] like '%M%'  or 审核计划.[CommitDate] like '%M%'  or 审核计划.[ReviewDate] like '%M%'  or 审核计划.[DocReturnDate] like '%M%'  or 审核计划.[ReturnContractQty] like '%M%'  or 审核计划.[DocReceiveRemark] like '%M%'  or 审核计划.[ReturnReason] like '%M%'  or 审核计划.[UnPassReason] like '%M%'  or 审核计划.[ProcessResult] like '%M%'  or 审核计划.[SuperviseEndDate] like '%M%'  or 审核计划.[NextApproveType] like '%M%'  or 审核计划.[NextApproveDate] like '%M%'  or 审核计划.[CertiInfo] like '%M%'  or 审核计划.[CertiAcceptanceDate] like '%M%'  or 审核计划.[CertiCompletionDate] like '%M%'  or 审核计划.[NonCompliantTerms] like '%M%'  or 审核计划.[NextAuditAdvice] like '%M%'  or 审核计划.[NextAuditFocus] like '%M%'  or 审核计划.[PlanApproveDate] like '%M%'  or [联系结果_联系结果].ResultName like '%M%' or 审核计划.[ToScheduleDate] like '%M%'  or 审核计划.[ProjectLeader] like '%M%'  or 审核计划.[PlanReturnReason] like '%M%'  or 审核计划.[ToScheduleInfo] like '%M%'  or 审核计划.[FromChangeNo] like '%M%'  or 审核计划.[ReceiveDateI] like '%M%'  or [合同申请接收人_登录用户].UserName like '%M%' or 审核计划.[MoveDate] like '%M%'  or 审核计划.[HandOverBy] like '%M%'  or 审核计划.[MailingInformation] like '%M%' )

2025-09-10 17:16:40 执行时长：5.2秒 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