2026-03-20 07:06:37 执行时长：7.9秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-20 07:06:43 执行时长：7.86秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC0001' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('11') 

2026-03-20 07:06:57 执行时长：5.01秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC0001')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC0001'))  and (a.org='' or a.org='303')

2026-03-20 07:07:38 执行时长：12.52秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:07:57 执行时长：31.79秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:08:11 执行时长：6.96秒 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 1=1 and ([计划状态_计划状态].[StatusName] in  ( '待确认'))

2026-03-20 07:08:27 执行时长：12.53秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC0001')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC0001'))  and (a.org='' or a.org='303')

2026-03-20 07:08:30 执行时长：11.85秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC0001' where (e.roleid in ('11') or b.operatorid='ISC0001') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0001')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0001' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:08:58 执行时长：6.33秒 sql: SELECT DISTINCT  人员信息表.ID as ID  FROM GB_Auditor 人员信息表 with(nolock)  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 LEFT JOIN GB_AuditHistry [审核经历] ON 人员信息表.AuditorCode = [审核经历].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 人员信息表.City = [城市_城市表].CityCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN GB_PersonnelAffiliation [人员归属_领域归属] WITH(NOLOCK) ON 人员信息表.PersonnelAffiliation = [人员归属_领域归属].PriceCode LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_Code [合同类型_代码表] WITH(NOLOCK) ON 人员信息表.ContractType = [合同类型_代码表].CodeID WHERE datediff(day,'2026-03-20',[人员信息表].[ContractEndDate]) < 90  AND [聘用状态_代码表].[CodeName] = '在聘' and  1=1 

2026-03-20 07:09:09 执行时长：11.19秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:09:15 执行时长：12.53秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:09:55 执行时长：35.87秒 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 [计划状态_计划状态].[StatusName] in ('待安排','已安排','待联系','退回')  AND datediff(day,'2026-03-20',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') )

2026-03-20 07:11:24 执行时长：37.9秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:11:50 执行时长：5.59秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC0001')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC0001'))  and (a.org='' or a.org='303')

2026-03-20 07:12:48 执行时长：5.11秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.fromuserid=b.userid where touserid=@userID and isactivity=1 and startdate<='2026-03-20 07:12:43'

2026-03-20 07:12:50 执行时长：17.41秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where (e.roleid in ('06') or b.operatorid='ISC-59498') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-59498')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-59498' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:12:50 执行时长：18.02秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where (e.roleid in ('06') or b.operatorid='ISC-59498') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-59498')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-59498' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:12:53 执行时长：20.03秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-20 07:12:54 执行时长：6.1秒 sql:select a.id as datacolumnid ,a.dataentityid as dataentityid, d.bizentityid as bizentityid,allowread,allowwrite,datacolumnname,c.id as bizcolumnid from base_datacolumn a left join base_bizcolumn c on a.id=c.datacolumnid left join base_bizdata d on c.bizdataid=d.id left join base_roledataright e  on a.dataentityid=e.dataentityid and a.id=e.columnid and d.bizentityid=e.bizentityid  and roleid=@roleID  where useright=1  order  by d.bizentityid,a.dataentityid 

2026-03-20 07:12:57 执行时长：16.03秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where (e.roleid in ('06') or b.operatorid='ISC-59498') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-59498')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-59498' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:13:01 执行时长：10.95秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC-59498') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:13:07 执行时长：16.84秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC-59498') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:13:08 执行时长：17.03秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:13:11 执行时长：13.82秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC-59498') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:13:17 执行时长：16.22秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC-59498')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-59498'))  and (a.org='' or a.org='45')

2026-03-20 07:13:18 执行时长：16秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC-59498')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-59498'))  and (a.org='' or a.org='45')

2026-03-20 07:13:23 执行时长：14.76秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:13:31 执行时长：26.74秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:13:32 执行时长：18.97秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:13:34 执行时长：10.8秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-20 07:13:35 执行时长：13.04秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:13:36 执行时长：20.38秒 sql:SELECT * FROM  base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id

2026-03-20 07:13:38 执行时长：54.17秒 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 [计划状态_计划状态].[StatusName] in ('待安排','已安排','待联系','退回')  AND datediff(day,'2026-03-20',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') )

2026-03-20 07:13:43 执行时长：11.74秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-59498' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-20 07:13:45 执行时长：10.29秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISC-59498' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC-59498' where (e.roleid in ('06') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-59498')  and h.id is null  order by b.startdate desc 

2026-03-20 07:13:45 执行时长：11.09秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISC-59498' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC-59498' where (e.roleid in ('06') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-59498')  and h.id is null  order by b.startdate desc 

2026-03-20 07:13:45 执行时长：8.12秒 sql:select count(*) from ( SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status='hide' and userid='ISC-59498')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-59498' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='45') )  ) as CurrentCount

2026-03-20 07:13:49 执行时长：6.99秒 sql:select count(*) from ( SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status='hide' and userid='ISC-59498')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-59498' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='45') )  ) as CurrentCount

2026-03-20 07:13:51 执行时长：6.19秒 sql:select d.username from base_user a   left join base_usermanagingorg c on a.userid=c.userid   left join View_OrgUser d on c.orgid=d.p_orgid  where a.userid='ISC-59498'  and c.floworgsecurity=1 union  select d.username from base_user a   left join View_OrgUser d on a.orgid=d.p_orgid  where a.userid='ISC-59498'  

2026-03-20 07:13:51 执行时长：5.85秒 sql:select d.username from base_user a   left join base_usermanagingorg c on a.userid=c.userid   left join View_OrgUser d on c.orgid=d.p_orgid  where a.userid='ISC-59498'  and c.floworgsecurity=1 union  select d.username from base_user a   left join View_OrgUser d on a.orgid=d.p_orgid  where a.userid='ISC-59498'  

2026-03-20 07:13:52 执行时长：6.65秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 公告.ID as [~ID~] ,公告.[Subject] AS [主题],公告.[Createby] AS [创建者],公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status=''hide'' and userid=''ISC-59498'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-59498'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''45'') )  ',@PageSize = 10, @PageCurrent = 1, @FdShow = '',@FdOrder = '[创建时间] DESC',@OnlyID = N' SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status=''hide'' and userid=''ISC-59498'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-59498'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''45'') ) '

2026-03-20 07:13:53 执行时长：9.77秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISC-59498' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC-59498' where (e.roleid in ('06') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-59498')  and h.id is null  order by b.startdate desc 

2026-03-20 07:13:56 执行时长：6.15秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 公告.ID as [~ID~] ,公告.[Subject] AS [主题],公告.[Createby] AS [创建者],公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status=''hide'' and userid=''ISC-59498'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-59498'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''45'') )  ',@PageSize = 10, @PageCurrent = 1, @FdShow = '',@FdOrder = '[创建时间] DESC',@OnlyID = N' SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status=''hide'' and userid=''ISC-59498'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-59498'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''45'') ) '

2026-03-20 07:13:58 执行时长：6.51秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id inner join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC-59498' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC-59498') and (deliverby<>'' or deliverby is not null)

2026-03-20 07:13:58 执行时长：6.12秒 sql: SELECT DISTINCT  证书信息查询.ID as ID  FROM GB_CertiView 证书信息查询 with(nolock)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 证书信息查询.CorpID = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息查询.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 证书信息查询.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息查询.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 证书信息查询.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 证书信息查询.City = [城市_城市表].CityCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 证书信息查询.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 证书信息查询.RiskLevel = [风险等级_代码表].CodeID WHERE [证书状态_证书状态].[StatusName] = '有效'  AND datediff(day,'2026-03-20',[证书信息查询].[RegiToDate]) < 60 and ([证书状态_证书状态].[StatusName] in ('有效','暂停'))

2026-03-20 07:13:59 执行时长：8.36秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id inner join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC-59498' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC-59498') and (deliverby<>'' or deliverby is not null)

2026-03-20 07:14:01 执行时长：6.65秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id inner join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC-59498' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC-59498') and (deliverby<>'' or deliverby is not null)

2026-03-20 07:14:29 执行时长：9.55秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:14:33 执行时长：15.91秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-59498')

2026-03-20 07:14:34 执行时长：16.78秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-59498')

2026-03-20 07:14:39 执行时长：14.72秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-59498')

2026-03-20 07:14:54 执行时长：9.66秒 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 GB_ProjectPlanTeam [审核组组成] 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 1=1 and ([审核计划].[PlanStatus] >='11'   AND [审核组组成].[AuditorCode] = 'ISC-59498'  AND [评定状态_评定状态].[StatusName] = '问题档'   AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190')

2026-03-20 07:14:58 执行时长：10.89秒 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 GB_ProjectPlanTeam [审核组组成] 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 1=1 and ([审核计划].[PlanStatus] >='11'   AND [审核组组成].[AuditorCode] = 'ISC-59498'  AND [评定状态_评定状态].[StatusName] = '问题档'   AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190')

2026-03-20 07:15:07 执行时长：20.43秒 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 GB_ProjectPlanTeam [审核组组成] 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 1=1 and ([审核计划].[PlanStatus] >='11'   AND [审核组组成].[AuditorCode] = 'ISC-59498'  AND [评定状态_评定状态].[StatusName] = '问题档'   AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190')

2026-03-20 07:15:43 执行时长：11.37秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  e.readonly,visibleInList,visibleInCard,orderColumn,height,width,e.orderno,orderNumber,listWidth,orderoption,pagegroup,sumtocolumn,navigatecolumn,e.ordernoinlist,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 where f.id=@id order by e.orderno,a.DisplayNo,a.id

2026-03-20 07:15:59 执行时长：8.11秒 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

2026-03-20 07:16:18 执行时长：10.91秒 sql:select count(*) from ( 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-59498') AND ([审核计划].BeginDate>='2026-03-01 00:00') ) as CurrentCount

2026-03-20 07:16:41 执行时长：22.14秒 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 [评定人员],审核计划.[CertiInfo] 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-59498'') AND ([审核计划].BeginDate>=''2026-03-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-59498'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'')'

2026-03-20 07:19:48 执行时长：8.39秒 sql:SELECT 审核组组成.ID as [~ID~] ,[标准代码_认证标准].ID AS [标准代码_Value],case when [标准代码_认证标准].StandardCode is not null then [标准代码_认证标准].StandardCode else cast(审核组组成.[StandardCode] as varchar(200)) end  AS [标准代码],[人员编号_人员信息表].AuditorCode AS [人员编号_Value],case when [人员编号_人员信息表].AuditorCode is not null then [人员编号_人员信息表].AuditorCode else cast(审核组组成.[AuditorCode] as varchar(200)) end  AS [人员编号],审核组组成.[AuditorName] AS [姓名],[性别_代码表].CodeID AS [性别_Value],case when [性别_代码表].CodeName is not null then [性别_代码表].CodeName else cast(审核组组成.[Gender] as varchar(200)) end  AS [性别],[组内职责_代码表].CodeID AS [组内职责_Value],case when [组内职责_代码表].CodeName is not null then [组内职责_代码表].CodeName else cast(审核组组成.[Duty] as varchar(200)) end  AS [组内职责],(case 审核组组成.[DocumentReview] when 1 then '√' else '' end) AS [文审],[审核方式_审核方式].ApproveModeCode AS [审核方式_Value],case when [审核方式_审核方式].ApproveMode is not null then [审核方式_审核方式].ApproveMode else cast(审核组组成.[ApproveMode] as varchar(200)) end  AS [审核方式],[见证情况_见证情况].WitnessCode AS [见证情况_Value],case when [见证情况_见证情况].WitnessName is not null then [见证情况_见证情况].WitnessName else cast(审核组组成.[WitnessSituation] as varchar(200)) end  AS [见证情况],[注册级别_人员资质类型].QCCode AS [注册级别_Value],case when [注册级别_人员资质类型].QCName is not null then [注册级别_人员资质类型].QCName else cast(审核组组成.[TechLevel] as varchar(200)) end  AS [注册级别],审核组组成.[RegCertiNo] AS [注册证书号],(case 审核组组成.[ProfessionalReview] when 1 then '√' else '' end) AS [承担专业审核],审核组组成.[ProfessionalCode] AS [专业小类],(case 审核组组成.[Fulltime] when 1 then '√' else '' end) AS [专职],[人员来源_合同来源].Org AS [人员来源_Value],case when [人员来源_合同来源].OrgName is not null then [人员来源_合同来源].OrgName else cast(审核组组成.[Org] as varchar(200)) end  AS [人员来源] FROM GB_ProjectPlanTeam 审核组组成 WITH(NOLOCK)  LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核组组成.StandardCode = [标准代码_认证标准].ID LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 审核组组成.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 审核组组成.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 审核组组成.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核组组成.ApproveMode = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 审核组组成.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 审核组组成.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Base_OrgV [人员来源_合同来源] WITH(NOLOCK) ON 审核组组成.Org = [人员来源_合同来源].Org WHERE [审核组组成].TaskNo='202505094983' order by [组内职责_代码表].[CodeName] ASC,[审核组组成].[AuditorName] ASC

2026-03-20 07:23:50 执行时长：8.31秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC0001' where (e.roleid in ('11') or b.operatorid='ISC0001') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0001')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0001' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:24:03 执行时长：13.78秒 sql:select * from GB_AuditorContactRecord  WITH(NOLOCK) where TaskNo='202505094983'

2026-03-20 07:24:15 执行时长：9.33秒 sql:   select distinct a.id, CodeName as DocumentType,FileName,c.username as UploadBy,UploadOn, 'https://oa.china-isc.org.cn/bizattach'+'/GB_PlanDoc/' + a.id + '/002202/'+a.FileName as Url,a.DocumentType, 'https://oa.china-isc.org.cn/bizattach'+'/GB_PlanDoc/' + a.id + '/002202/'+a.FileName as weburl,case when a.IsHistry=1 then '√' else '' end as IsHistry  from GB_PlanDoc a left join Pub_Code b on a.DocumentType = b.CodeID left join Base_UserV c on a.uploadby = c.UserID where a.taskno = '202505094983'  order by a.DocumentType 

2026-03-20 07:24:34 执行时长：9.48秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:24:40 执行时长：16.6秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:25:51 执行时长：15.29秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-20 07:25:58 执行时长：23.47秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where (e.roleid in ('11') or b.operatorid='ISCSCB') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCSCB')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISCSCB' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:26:02 执行时长：25.9秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where (e.roleid in ('11') or b.operatorid='ISCSCB') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCSCB')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISCSCB' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:26:09 执行时长：11.31秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISCSCB') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:26:12 执行时长：56.4秒 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 [计划状态_计划状态].[StatusName] in ('待安排','已安排','待联系','退回')  AND datediff(day,'2026-03-20',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') )

2026-03-20 07:26:13 执行时长：11.31秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISCSCB') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:26:24 执行时长：12.36秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:26:27 执行时长：13.18秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:26:37 执行时长：12.84秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('11') 

2026-03-20 07:26:38 执行时长：18.59秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:26:40 执行时长：12.64秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISCSCB' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('11') 

2026-03-20 07:26:40 执行时长：12.25秒 sql: SELECT DISTINCT  证书信息查询.ID as ID  FROM GB_CertiView 证书信息查询 with(nolock)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 证书信息查询.CorpID = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息查询.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 证书信息查询.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息查询.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 证书信息查询.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 证书信息查询.City = [城市_城市表].CityCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 证书信息查询.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 证书信息查询.RiskLevel = [风险等级_代码表].CodeID WHERE [证书状态_证书状态].[StatusName] = '有效'  AND datediff(day,'2026-03-20',[证书信息查询].[RegiToDate]) < 60 and ([证书状态_证书状态].[StatusName] in ('有效','暂停'))

2026-03-20 07:26:47 执行时长：10.24秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISCSCB' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISCSCB' where (e.roleid in ('11') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCSCB')  and h.id is null  order by b.startdate desc 

2026-03-20 07:26:49 执行时长：8.85秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISCSCB' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISCSCB' where (e.roleid in ('11') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCSCB')  and h.id is null  order by b.startdate desc 

2026-03-20 07:26:52 执行时长：5.07秒 sql:select d.username from base_user a   left join base_usermanagingorg c on a.userid=c.userid   left join View_OrgUser d on c.orgid=d.p_orgid  where a.userid='ISCSCB'  and c.floworgsecurity=1 union  select d.username from base_user a   left join View_OrgUser d on a.orgid=d.p_orgid  where a.userid='ISCSCB'  

2026-03-20 07:26:54 执行时长：5.18秒 sql:select d.username from base_user a   left join base_usermanagingorg c on a.userid=c.userid   left join View_OrgUser d on c.orgid=d.p_orgid  where a.userid='ISCSCB'  and c.floworgsecurity=1 union  select d.username from base_user a   left join View_OrgUser d on a.orgid=d.p_orgid  where a.userid='ISCSCB'  

2026-03-20 07:27:49 执行时长：8.58秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:29:05 执行时长：7.19秒 sql: SELECT DISTINCT  证书信息查询.ID as ID  FROM GB_CertiView 证书信息查询 with(nolock)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 证书信息查询.CorpID = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息查询.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 证书信息查询.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息查询.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 证书信息查询.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 证书信息查询.City = [城市_城市表].CityCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 证书信息查询.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 证书信息查询.RiskLevel = [风险等级_代码表].CodeID WHERE [证书状态_证书状态].[StatusName] = '有效'  AND datediff(day,'2026-03-20',[证书信息查询].[RegiToDate]) < 60 and ([证书状态_证书状态].[StatusName] in ('有效','暂停'))

2026-03-20 07:30:37 执行时长：10.7秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:33:19 执行时长：24.82秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:33:34 执行时长：29.26秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1

2026-03-20 07:33:45 执行时长：21.25秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0176' where (e.roleid in ('06') or b.operatorid='ISC[S]0176') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0176')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC[S]0176' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:33:53 执行时长：8.27秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0176' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC[S]0176') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:33:55 执行时长：20.83秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID=@id

2026-03-20 07:34:01 执行时长：6.8秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0176' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:34:11 执行时长：9.66秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0176' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-20 07:34:15 执行时长：6.42秒 sql:select count(*) from ( SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status='hide' and userid='ISC[S]0176')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC[S]0176' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='43') )  ) as CurrentCount

2026-03-20 07:34:22 执行时长：6.73秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 公告.ID as [~ID~] ,公告.[Subject] AS [主题],公告.[Createby] AS [创建者],公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status=''hide'' and userid=''ISC[S]0176'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC[S]0176'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''43'') )  ',@PageSize = 10, @PageCurrent = 1, @FdShow = '',@FdOrder = '[创建时间] DESC',@OnlyID = N' SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].AnnounceID LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status=''hide'' and userid=''ISC[S]0176'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC[S]0176'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''43'') ) '

2026-03-20 07:34:22 执行时长：11.54秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISC[S]0176' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC[S]0176' where (e.roleid in ('06') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0176')  and h.id is null  order by b.startdate desc 

2026-03-20 07:34:32 执行时长：5.43秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id inner join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC[S]0176' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC[S]0176') and (deliverby<>'' or deliverby is not null)

2026-03-20 07:34:54 执行时长：8.85秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC[S]0176')

2026-03-20 07:35:14 执行时长：10.11秒 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 GB_ProjectPlanTeam [审核组组成] 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 1=1 and ([审核计划].[PlanStatus] >='11'   AND [审核组组成].[AuditorCode] = 'ISC[S]0176'  AND [评定状态_评定状态].[StatusName] = '问题档'   AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190')

2026-03-20 07:38:17 执行时长：5.6秒 sql:select distinct grade,a.id as officeflowid,b.id as officeflowinstancedetailid,b.officeflowactionid,actionname,accredituser,f.username as accreditusername ,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,a.createby,a.createon,title,a.content  ,h.status from wf_officeflow a inner join wf_officeflowdetail b on a.id=b.officeflowid  left join wf_officeflowaction d on b.officeflowactionid=d.id  left join base_user f on b.accredituser=f.userid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='OFID' and h.userid='ISC[S]0176' where (officeflowstate=2 or officeflowstate=3) and officeflowactionstate=0  and OperatorID='ISC[S]0176' order by a.id desc

2026-03-20 07:38:29 执行时长：18.35秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:38:53 执行时长：5.05秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC[S]0176')

2026-03-20 07:44:35 执行时长：7.47秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0044' where (e.roleid in ('01','24') or b.operatorid='ISC[S]0044') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0044')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC[S]0044' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:44:36 执行时长：8.06秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:44:37 执行时长：10.4秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0044' where (e.roleid in ('01','24') or b.operatorid='ISC[S]0044') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0044')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC[S]0044' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:44:51 执行时长：6.05秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0044' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('01','24') 

2026-03-20 07:44:52 执行时长：5.85秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:44:52 执行时长：6.29秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0044' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC[S]0044') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:44:53 执行时长：12.42秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC[S]0044' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:44:56 执行时长：23.24秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-20 07:44:58 执行时长：6.76秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,b.accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity,a.createby  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id left join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join wf_workflowinstancedetail h on b.workflowinstanceid=h.workflowinstanceid and b.workflowactionid=h.workflowactionid and  h.operatorid='ISC[S]0044' and (h.workflowactionstate=1 or h.workflowactionstate=2) left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC[S]0044' where (e.roleid in ('01','24') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0044')  and h.id is null  order by b.startdate desc 

2026-03-20 07:45:04 执行时长：5.7秒 sql:select d.username from base_user a   left join base_usermanagingorg c on a.userid=c.userid   left join View_OrgUser d on c.orgid=d.p_orgid  where a.userid='ISC[S]0044'  and c.floworgsecurity=1 union  select d.username from base_user a   left join View_OrgUser d on a.orgid=d.p_orgid  where a.userid='ISC[S]0044'  

2026-03-20 07:45:10 执行时长：10.05秒 sql:select d.username from base_user a   left join base_usermanagingorg c on a.userid=c.userid   left join View_OrgUser d on c.orgid=d.p_orgid  where a.userid='ISC[S]0044'  and c.floworgsecurity=1 union  select d.username from base_user a   left join View_OrgUser d on a.orgid=d.p_orgid  where a.userid='ISC[S]0044'  

2026-03-20 07:45:12 执行时长：19.89秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-20 07:45:13 执行时长：9.49秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id inner join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC[S]0044' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC[S]0044') and (deliverby<>'' or deliverby is not null)

2026-03-20 07:45:16 执行时长：10.07秒 sql:select distinct a.workflowid,workflowname,messagedesc,a.bizentityid,a.id as workflowinstanceid,b.id as workflowinstancedetailid,rowid,b.workflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,WorkflowMessage,d.orgsecurity as ActionOrgSecurity  ,j.status from wf_workflowinstance a left join wf_workflowinstancedetail b on a.id=b.workflowinstanceid  inner join wf_workflow c on a.workflowid=c.id inner join wf_workflowaction d on b.workflowactionid=d.id  left join wf_workflowactionrole e on d.id=e.workflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus j on b.ID=j.id and j.BizEntityID='WFID' and j.userid='ISC[S]0044' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC[S]0044') and (deliverby<>'' or deliverby is not null)

2026-03-20 07:45:20 执行时长：12.41秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC[S]0044')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC[S]0044'))  and (a.org='' or a.org='0001')

2026-03-20 07:45:28 执行时长：9.36秒 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.bizentityid=@bizEntityID order by a.orderno,a.id

2026-03-20 07:46:05 执行时长：11.58秒 sql:SELECT * FROM  base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id

2026-03-20 07:46:14 执行时长：10.96秒 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='0017' and b.datacolumncode<>''  order by ordernumber

2026-03-20 07:46:22 执行时长：6.92秒 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 [审核计划].[PlanStatus]='13' and ([批准结论_批准结论].[ResultName] is null  OR [批准结论_批准结论].[ResultName] = '待定')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = '合格档'  OR [审核计划].[IsReform] =1)  and ((( [审核计划].[PlanStatus] >= '13'  and [审核类别_审核类别].[ClassName] in ('二阶段','监查1','监查2','监督3','监督4','再认证','补充','变更')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = '合格档'or [评定状态_评定状态].[StatusName] = '问题档' OR [审核计划].[IsReform] =1))))

2026-03-20 07:46:26 执行时长：12.37秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:46:38 执行时长：13.68秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:46:42 执行时长：19.55秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:46:51 执行时长：15.12秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:46:52 执行时长：12.54秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:46:53 执行时长：16.63秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:46:57 执行时长：12.98秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:46:59 执行时长：6.31秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC[S]0176')

2026-03-20 07:47:04 执行时长：8.39秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC[S]0176')

2026-03-20 07:47:09 执行时长：18.79秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:47:15 执行时长：23.73秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:47:18 执行时长：20.17秒 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  [审核计划].[ReturnDoc] =0 and ([审核计划].[PlanStatus] >='03'  AND [审核类别_审核类别].[ClassName] <> '一阶段'  )

2026-03-20 07:47:30 执行时长：12.54秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-366543' where (e.roleid in ('06') or b.operatorid='ISC-366543') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-366543')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-366543' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-20 07:47:34 执行时长：19.96秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource  FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2026-03-20 07:47:37 执行时长：7.03秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-366543' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC-366543') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-20 07:47:42 执行时长：5.51秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC[S]0176')

2026-03-20 07:47:43 执行时长：8.8秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC[S]0044')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC[S]0044'))  and (a.org='' or a.org='0001')

2026-03-20 07:47:46 执行时长：9.2秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC[S]0044')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC[S]0044'))  and (a.org='' or a.org='0001')

2026-03-20 07:47:47 执行时长：9秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-366543' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-20 07:47:48 执行时长：24.59秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:47:51 执行时长：24.05秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2026-03-20 07:47:54 执行时长：7.23秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition  ,h.status  from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid  inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id  left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid  left join base_user f on b.accredituser=f.userid  left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid  left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-366543' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06')