2025-07-24 17:07:18 执行时长：5.62秒 sql:exec [GB_AuditorSchedule] '2025-07-01','','','','','','123','0.5','ISC0042'

2025-07-24 17:21:44 执行时长：6.46秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''25''  or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and ([组织名称_组织信息].[CorpName] like ''%沈阳%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''25''  or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and ([组织名称_组织信息].[CorpName] like ''%沈阳%''))'

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

2025-07-24 17:33:22 执行时长：13.07秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2025-07-24 17:33:22 执行时长：9.32秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,e.bizdefaultvalue,scancodeinput  FROM Base_DataColumn a left join base_dataentity b on a.rsentity=b.id left join base_datacolumn c on a.rscolumn=c.id left join base_datacolumn d on a.rsdisplaycolumn=d.id left join Base_BizColumn e on a.id=e.datacolumnid and bizDataID=@id   left join base_bizdata f on a.dataentityid=f.dataentityid left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2025-07-24 17:33:37 执行时长：15.49秒 sql:SELECT DISTINCT 审核计划.ID  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID 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_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] ON 审核计划.TaskNo = [审核组组成].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_AuditorContactRecord [审核员联系记录] ON 审核计划.TaskNo = [审核员联系记录].TaskNo WHERE  1=2  or 审核组组成.[AuditorName] like '%QEOFH%'  or 审核组组成.[StandardCode] like '%QEOFH%'  or 审核组组成.[Duty] like '%QEOFH%'  or 审核组组成.[ApproveMode] like '%QEOFH%'  or 审核组组成.[WitnessSituation] like '%QEOFH%'  or 审核组组成.[TechLevel] like '%QEOFH%'  or 审核组组成.[Org] like '%QEOFH%'  or 审核组组成.[ProfessionalCode] like '%QEOFH%'  or 审核组组成.[AuditorCode] like '%QEOFH%'  or 审核组组成.[Gender] like '%QEOFH%'  or 审核组组成.[RegCertiNo] like '%QEOFH%'  or 审核组组成.[TaskNo] like '%QEOFH%' 

2025-07-24 17:33:43 执行时长：6.69秒 sql:SELECT DISTINCT 审核计划.ID  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID 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_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] ON 审核计划.TaskNo = [审核组组成].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_AuditorContactRecord [审核员联系记录] ON 审核计划.TaskNo = [审核员联系记录].TaskNo WHERE  1=2  or 计划结合安排.[TaskNo] like '%QEOFH%'  or 计划结合安排.[ProjectNo] like '%QEOFH%'  or 计划结合安排.[StandardCode] like '%QEOFH%'  or 计划结合安排.[ApproveDays] like '%QEOFH%'  or 计划结合安排.[ApproveClass] like '%QEOFH%'  or 计划结合安排.[ProfessionalCode] like '%QEOFH%'  or 计划结合安排.[BasicDays] like '%QEOFH%'  or 计划结合安排.[TotalDays] like '%QEOFH%'  or 计划结合安排.[FirstOffSiteHumanDays] like '%QEOFH%'  or 计划结合安排.[FirstStageOnsiteDays] like '%QEOFH%'  or 计划结合安排.[SecondStageDays] like '%QEOFH%'  or 计划结合安排.[SupervisoryDays] like '%QEOFH%'  or 计划结合安排.[CombinedPlan] like '%QEOFH%' 

2025-07-24 17:43:08 执行时长：8.28秒 sql:exec GB_PartnerBizStatistics '2025','ISC0601'

2025-07-24 17:49:58 执行时长：8.28秒 sql:exec [GB_AuditorSchedule] '2025-07-01','2025-07-31','','','','','','0.5','ISC-247783'