2025-12-24 16:01:14 执行时长：13.3秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC-73544'

2025-12-24 16:01:29 执行时长：20.13秒 sql:exec GB_PartnerBizStatistics '2025','ISC0601'

2025-12-24 16:24:33 执行时长：5.67秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] 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_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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 GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 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 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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-205805'') AND ([审核计划].BeginDate>=''2025-12-01 00:00'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName 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_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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 GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 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 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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-205805'') AND ([审核计划].BeginDate>=''2025-12-01 00:00'')'

2025-12-24 16:25:02 执行时长：6.41秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo 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 [计划状态_计划状态].[StatusName] in ('案卷评议中')  AND [审核计划].[IsReform] =1 and (([阅卷人员_登录用户].[UserID] = 'ISC0066'  OR 'ISC0066'='admin')  AND [审核计划].[PlanStatus] >= '12' )

2025-12-24 16:25:05 执行时长：8.58秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect  from base_bizcolumn a left join base_datacolumn b on a.datacolumnid=b.id  left join base_bizdata c on a.bizdataid=c.id  left join base_dataentity d on c.dataentityid=d.id  left join base_dataentity e on b.rsentity=e.id  left join base_datacolumn f on b.RsDisplayColumn=f.id  where ordercolumn=1 and orderoption<>'' and VisibleInList=1 and a.bizdataid='0095' and b.datacolumncode<>''  order by ordernumber

2025-12-24 16:25:07 执行时长：11.02秒 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-12-24 16:25:29 执行时长：6.22秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id

2025-12-24 16:25:33 执行时长：8.76秒 sql:select owner,viewer from wf_Bizflowaction a left join wf_Bizflowright b on a.Bizflowid=b.Bizflowid  where bizentityid=@bizEntityID and roleid=@roleid

2025-12-24 16:25:33 执行时长：8.76秒 sql:select owner,viewer from wf_Bizflowaction a left join wf_Bizflowright b on a.Bizflowid=b.Bizflowid  where bizentityid=@bizEntityID and roleid=@roleid

2025-12-24 16:25:33 执行时长：10.23秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect  from base_bizcolumn a left join base_datacolumn b on a.datacolumnid=b.id  left join base_bizdata c on a.bizdataid=c.id  left join base_dataentity d on c.dataentityid=d.id  left join base_dataentity e on b.rsentity=e.id  left join base_datacolumn f on b.RsDisplayColumn=f.id  where ordercolumn=1 and orderoption<>'' and VisibleInList=1 and a.bizdataid='0047' and b.datacolumncode<>''  order by ordernumber

2025-12-24 16:25:33 执行时长：10.23秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName   FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.id=@id

2025-12-24 16:25:33 执行时长：9.78秒 sql:select c.CorpName,d.OrgName,b.ProjectNo ,ClassName as ApproveClass,b.begindate,b.enddate ,b.AuditTeam  from GB_ProjectPlanTeam a left join GB_ProjectPlan b on a.taskno = b.taskno and a.StandardCode=b.StandardCode  left join GB_Corp c on b.Corp = c.corpid  left join Base_OrgV d on c.Org = d.Org  left join Pub_ApproveClass e on b.ApproveClass = e.ClassCode  where a.AuditorCode = 'ISC-244880' and begindate<= '2025-12-25 23:59' and EndDate >= '2025-12-25'

2025-12-24 16:27:27 执行时长：19.21秒 sql:exec [GB_AuditorSchedule] '','','','','','','','','ISC-418501'

2025-12-24 16:28:46 执行时长：5.75秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo 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 [计划状态_计划状态].[StatusName] in ('案卷评议中')  AND [审核计划].[IsReform] =1 and ((([审核计划].[PlanStatus] >= '12')))

2025-12-24 16:29:24 执行时长：17.25秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0042'

2025-12-24 16:32:42 执行时长：10秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC-418501'

2025-12-24 16:35:16 执行时长：10.8秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC-418501'

2025-12-24 16:36:38 执行时长：12.99秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0042'

2025-12-24 16:44:13 执行时长：6.51秒 sql:exec [GB_SuperRateStatistics] '2025','ISC0601'

2025-12-24 16:44:37 执行时长：5.92秒 sql:exec [GB_SuperRateStatistics] '2025','ISC0601'

2025-12-24 16:46:56 执行时长：6.76秒 sql:select count(*) from ( SELECT DISTINCT 项目进度查询.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],项目进度查询.[ToScheduleDate] AS [转计调日期],项目进度查询.[PlanCommitDate] AS [计划提交时间],项目进度查询.[CommitDate] AS [审核员交卷日期],项目进度查询.[RetrivalDate] AS [分卷时间],项目进度查询.[ReviewDate] AS [阅卷完成时间],项目进度查询.[CertiCompletionDate] AS [证书完成日期],项目进度查询.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName AS [合同来源],项目进度查询.[PlanNo] AS [计划编号] FROM GB_ProjectSchedule 项目进度查询 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org WHERE [审核类别_审核类别].[ClassName] <> '一阶段' AND [计划状态_计划状态].[StatusName] <> '待联系' and ( [项目进度查询].org ='23' ) ) as CurrentCount

2025-12-24 16:47:00 执行时长：16.81秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC-418501'

2025-12-24 16:47:08 执行时长：22.41秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','','0.5','ISC-418501'

2025-12-24 16:47:10 执行时长：13.83秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 项目进度查询.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],项目进度查询.[ToScheduleDate] AS [转计调日期],项目进度查询.[PlanCommitDate] AS [计划提交时间],项目进度查询.[CommitDate] AS [审核员交卷日期],项目进度查询.[RetrivalDate] AS [分卷时间],项目进度查询.[ReviewDate] AS [阅卷完成时间],项目进度查询.[CertiCompletionDate] AS [证书完成日期],项目进度查询.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName AS [合同来源],项目进度查询.[PlanNo] AS [计划编号] FROM GB_ProjectSchedule 项目进度查询 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org WHERE [审核类别_审核类别].[ClassName] <> ''一阶段'' AND [计划状态_计划状态].[StatusName] <> ''待联系'' and ( [项目进度查询].org =''23'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC,[组织名称] DESC,[审核类别] DESC,[计划状态] ASC',@OnlyID = N' SELECT DISTINCT 项目进度查询.ID as [~ID~] ,项目进度查询.[DecideOn] AS [认证决定日期],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[计划状态_计划状态].StatusName AS [计划状态] FROM GB_ProjectSchedule 项目进度查询 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org WHERE [审核类别_审核类别].[ClassName] <> ''一阶段'' AND [计划状态_计划状态].[StatusName] <> ''待联系'' and ( [项目进度查询].org =''23'' )'

2025-12-24 16:47:20 执行时长：37.99秒 sql:exec [GB_SuperRateStatistics] '2025','ISC0601'

2025-12-24 16:55:58 执行时长：9.57秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0042'