2025-09-02 12:28:36 执行时长：6.05秒 sql:select filename from base_bizcolumnattach WITH(NOLOCK) where accesspath='GB_CertiApplyCorpDoc' and keyvalue='508001271ISC1603' and datacolumnid='002153' 2025-09-02 12:29:02 执行时长：7.68秒 sql:select filename from base_bizcolumnattach WITH(NOLOCK) where accesspath='GB_CertiApplyCorpDoc' and keyvalue='508001348ISC1603' and datacolumnid='002153' 2025-09-02 12:29:08 执行时长：14.54秒 sql:select count(*) from ( 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 [审核天数],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK) ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10' AND [审核组组成].[AuditorCode] = 'ISC-202976') AND ([审核计划].BeginDate>='2025-07-01 00:00') ) as CurrentCount 2025-09-02 12:29:25 执行时长：5.21秒 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 2025-09-02 12:30:01 执行时长：52.8秒 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 [审核天数],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK) ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10'' AND [审核组组成].[AuditorCode] = ''ISC-202976'') AND ([审核计划].BeginDate>=''2025-07-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-202976'') AND ([审核计划].BeginDate>=''2025-07-01 00:00'')' 2025-09-02 12:30:11 执行时长：5.82秒 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 2025-09-02 12:30:17 执行时长：15.01秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-09-02 12:30:30 执行时长：10.07秒 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='ISC0042' where (e.roleid in ('05','04','25') or b.operatorid='ISC0042') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0042') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0042' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:30:34 执行时长：9.61秒 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 2025-09-02 12:30:39 执行时长：20.75秒 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='ISC0042' where (e.roleid in ('05','04','25') or b.operatorid='ISC0042') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0042') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0042' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:30:41 执行时长：21.06秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:30:50 执行时长：6.89秒 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 2025-09-02 12:30:51 执行时长：7.11秒 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 2025-09-02 12:30:54 执行时长：5.22秒 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='ISC0042' where (officeflowstate=2 or officeflowstate=3) and officeflowactionstate=0 and OperatorID='ISC0042' order by a.id desc 2025-09-02 12:30:56 执行时长：13.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-267598' where (e.roleid in ('06') or b.operatorid='ISC-267598') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-267598') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-267598' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:31:00 执行时长：17.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 ,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-267598' where (e.roleid in ('06') or b.operatorid='ISC-267598') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-267598') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-267598' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:31:00 执行时长：16.97秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:31:04 执行时长：5.41秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-09-02 12:31:10 执行时长：10.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 2025-09-02 12:31:10 执行时长：5.78秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-09-02 12:31:04' 2025-09-02 12:31:10 执行时长：13.18秒 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 2025-09-02 12:31:11 执行时长：7.69秒 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-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:31:12 执行时长：6.02秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2025-09-02 12:31:15 执行时长：6.87秒 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-267598') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-267598')) and (a.org='' or a.org='46') 2025-09-02 12:31:16 执行时长：5.09秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a ,Base_UserRole b ,base_roleaccredit c where a.roleid=b.roleid and b.userid=c.fromuserid and touserid=@userID and isactivity=1 and startdate<='2025-09-02 12:31:11' 2025-09-02 12:31:17 执行时长：5.79秒 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-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:31:17 执行时长：5.99秒 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-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:31:18 执行时长：6.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-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:31:22 执行时长：5.22秒 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-267598' 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-267598' 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-267598') and h.id is null order by b.startdate desc 2025-09-02 12:31:23 执行时长：6.05秒 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-267598' 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-267598' 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-267598') and h.id is null order by b.startdate desc 2025-09-02 12:31:23 执行时长：20.61秒 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-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:31:25 执行时长：27.08秒 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 2025-09-02 12:31:28 执行时长：6.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-267598' 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-267598' 2025-09-02 12:31:29 执行时长：6.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-267598' 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-267598' 2025-09-02 12:31:30 执行时长：6.91秒 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-267598' 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-267598' 2025-09-02 12:31:30 执行时长：5.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-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:31:31 执行时长：5.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='ISC-267598' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:31:35 执行时长：6.67秒 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-267598' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-267598') and (deliverby<>'' or deliverby is not null) 2025-09-02 12:31:35 执行时长：5.83秒 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-267598' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-267598') and (deliverby<>'' or deliverby is not null) 2025-09-02 12:31:36 执行时长：10.5秒 sql:select count(*) from ( 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='ISC0042') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC0042' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='0001') ) ) as CurrentCount 2025-09-02 12:31:38 执行时长：5.42秒 sql:select count(*) from ( 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-267598') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-267598' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='46') ) ) as CurrentCount 2025-09-02 12:31:38 执行时长：6.05秒 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-267598' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-267598') and (deliverby<>'' or deliverby is not null) 2025-09-02 12:31:40 执行时长：16.9秒 sql:select * from Base_BizentityCustom where BizEntityID='000004' and UserID='' and propertyname='ListWithSubData' 2025-09-02 12:31:41 执行时长：10.8秒 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-267598' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-267598') and (deliverby<>'' or deliverby is not null) 2025-09-02 12:31:49 执行时长：13.57秒 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=''ISC0042'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC0042'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) ',@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=''ISC0042'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC0042'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) ' 2025-09-02 12:31:53 执行时长：17.06秒 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-267598' 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-267598' 2025-09-02 12:31:54 执行时长：73.93秒 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,'2025-09-02',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') ) 2025-09-02 12:31:56 执行时长：17.88秒 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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ',@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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ' 2025-09-02 12:32:01 执行时长：10.89秒 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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ',@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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ' 2025-09-02 12:32:03 执行时长：9.88秒 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 2025-09-02 12:32:04 执行时长：16.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 ,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='ISC0042' where (e.roleid in ('05','04','25') or b.operatorid='ISC0042') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0042') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0042' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:32:09 执行时长：10.97秒 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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ',@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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ' 2025-09-02 12:32:11 执行时长：14.36秒 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 2025-09-02 12:32:14 执行时长：12.78秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-09-02 12:32:26 执行时长：12.88秒 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 2025-09-02 12:32:30 执行时长：9.51秒 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 2025-09-02 12:32:31 执行时长：11.08秒 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=''ISC0042'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC0042'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) ',@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=''ISC0042'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC0042'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) ' 2025-09-02 12:32:32 执行时长：6.38秒 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,'2025-09-02',[证书信息查询].[RegiToDate]) < 60 and ([证书状态_证书状态].[StatusName] in ('有效','暂停')) 2025-09-02 12:32:33 执行时长：9.93秒 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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ',@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-267598'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-267598'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''46'') ) ' 2025-09-02 12:32:43 执行时长：28.6秒 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-267598') 2025-09-02 12:32:44 执行时长：11.62秒 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 2025-09-02 12:32:44 执行时长：29.43秒 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-267598') 2025-09-02 12:32:46 执行时长：26.19秒 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-267598') 2025-09-02 12:32:48 执行时长：11.86秒 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 2025-09-02 12:32:51 执行时长：21.43秒 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-267598') 2025-09-02 12:33:18 执行时长：26.87秒 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-267598' AND [评定状态_评定状态].[StatusName] = '问题档' AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190') 2025-09-02 12:33:21 执行时长：10.94秒 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-330572') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-330572')) and (a.org='' or a.org='43') 2025-09-02 12:33:21 执行时长：15.49秒 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-330572' where (e.roleid in ('06') or b.operatorid='ISC-330572') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-330572') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-330572' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:33:22 执行时长：29.54秒 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-267598' AND [评定状态_评定状态].[StatusName] = '问题档' AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190') 2025-09-02 12:33:25 执行时长：21秒 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-330572' where (e.roleid in ('06') or b.operatorid='ISC-330572') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-330572') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-330572' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:33:30 执行时长：32.97秒 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-267598' AND [评定状态_评定状态].[StatusName] = '问题档' AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190') 2025-09-02 12:33:32 执行时长：19.45秒 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-330572' where (e.roleid in ('06') or b.operatorid='ISC-330572') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-330572') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-330572' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:33:37 执行时长：11.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 ,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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-330572') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-09-02 12:33:38 执行时长：9.53秒 sql:SELECT distinct ShortcutNo,BizEntityName ,a.BizEntityID ,BizClass FROM Base_Shortcut a LEFT JOIN Base_BizEntity b ON a.BizEntity = b.ID WHERE(a.IsPrivate = 0 OR a.Createby = '李洪国') order by ShortcutNo 2025-09-02 12:33:39 执行时长：17.39秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-330572') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-09-02 12:33:39 执行时长：25.96秒 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-330572' where (e.roleid in ('06') or b.operatorid='ISC-330572') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-330572') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-330572' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:33:43 执行时长：5.3秒 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 2025-09-02 12:33:45 执行时长：12.55秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-330572') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-09-02 12:33:45 执行时长：9.11秒 sql:select count(*) from ( 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-330572') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-330572' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='43') ) ) as CurrentCount 2025-09-02 12:33:45 执行时长：5.25秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:33:45 执行时长：5.06秒 sql:SELECT distinct ShortcutNo,BizEntityName ,a.BizEntityID ,BizClass FROM Base_Shortcut a LEFT JOIN Base_BizEntity b ON a.BizEntity = b.ID WHERE(a.IsPrivate = 0 OR a.Createby = '李洪国') order by ShortcutNo 2025-09-02 12:33:46 执行时长：5.19秒 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 2025-09-02 12:33:46 执行时长：5.55秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-09-02 12:33:40' 2025-09-02 12:33:47 执行时长：5.23秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove, relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,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 bizEntityID=@bizEntityID and isprimary=1 2025-09-02 12:33:51 执行时长：8.85秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode 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 WHERE a.dataEntityID='008001' order by a.displayno,a.id 2025-09-02 12:33:54 执行时长：61.48秒 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-267598' AND [评定状态_评定状态].[StatusName] = '问题档' AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190') 2025-09-02 12:33:57 执行时长：5.56秒 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-330572') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-330572')) and (a.org='' or a.org='43') 2025-09-02 12:33:57 执行时长：7.27秒 sql: SELECT DISTINCT 注册与保持.ID as ID FROM GB_AuditorRegister 注册与保持 with(nolock) LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 注册与保持.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 注册与保持.Org = [合同来源_合同来源].Org LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 注册与保持.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 注册与保持.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 注册与保持.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [是否有效_代码表] WITH(NOLOCK) ON 注册与保持.IsEffective = [是否有效_代码表].CodeID LEFT JOIN Pub_Code [是否见证_代码表] WITH(NOLOCK) ON 注册与保持.IsWitness = [是否见证_代码表].CodeID WHERE datediff(day,'2025-09-02',[注册与保持].[EndDate]) < 90 AND [注册与保持].[IsEffective] = '27' and ([人员编号_人员信息表].[StaffStatus] = '127' AND [注册级别_人员资质类型].[QCName] <> '技术专家') 2025-09-02 12:33:58 执行时长：6.92秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2025-09-02 12:33:59 执行时长：6.89秒 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 2025-09-02 12:33:59 执行时长：6.54秒 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 2025-09-02 12:34:00 执行时长：7.07秒 sql:select a.ID,a.BizEntityID,TriggerName,TriggerTiming,SQLExpression,NeedConfirm, b.Condition,b.CheckRuleExpression,b.Message,b.DataEntityID,a.InUse,a.CloseCard,a.SaveCard from Base_Trigger a left join Base_CheckRules b on a.CheckRuleName=b.id where a.BizEntityID=@beid and TriggerTiming=@TriggerTiming and a.InUse=1 2025-09-02 12:34:00 执行时长：6.93秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id 2025-09-02 12:34:00 执行时长：7.14秒 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-330572' where (e.roleid in ('06') or b.operatorid='ISC-330572') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-330572') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-330572' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:34:00 执行时长：6.34秒 sql:SELECT DISTINCT FirstPageNo AS 序号,BizEntityName AS 业务实体,BizEntityID AS 实体编码,BizClass,GraphType FROM Base_FirstPage a LEFT JOIN Base_BizEntity b ON a.BizEntity = b.ID WHERE IsPrivate = 0 OR a.Createby = '冉景洲' order by FirstPageNo 2025-09-02 12:34:01 执行时长：6.74秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode 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 WHERE a.ID=@id 2025-09-02 12:34:02 执行时长：6.74秒 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 2025-09-02 12:34:02 执行时长：7.24秒 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-330572' where (e.roleid in ('06') or b.operatorid='ISC-330572') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-330572') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-330572' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:34:02 执行时长：7.83秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:34:02 执行时长：19.38秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:03 执行时长：18.59秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:03 执行时长：6.56秒 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 2025-09-02 12:34:03 执行时长：24.38秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:04 执行时长：7.24秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:34:04 执行时长：7.57秒 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 2025-09-02 12:34:05 执行时长：7.43秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode 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 WHERE a.dataEntityID='020003' order by a.displayno,a.id 2025-09-02 12:34:05 执行时长：6.39秒 sql:select d.DataColumnCode,d.DataColumnName,c.DataEntityCode,c.DataEntityName,IsPrimary,RsEntity,RsMultiSelect,b.BizDataName from Base_BizColumn a left join Base_BizData b on a.BizDataID=b.ID left join Base_DataEntity c on b.DataEntityID=c.ID left join Base_DataColumn d on a.DataColumnID=d.ID where BizEntityID='006001' 2025-09-02 12:34:05 执行时长：5.83秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove, relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,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 bizEntityID=@bizEntityID and isprimary=1 2025-09-02 12:34:05 执行时长：6.2秒 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 2025-09-02 12:34:06 执行时长：6.24秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='06' 2025-09-02 12:34:06 执行时长：6秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-330572') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-09-02 12:34:06 执行时长：18.48秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:06 执行时长：6.52秒 sql:SELECT MAX(ID) FROM GB_ProjectPlan WHERE id>='509000000' and id<='509999999' and len(id)>=9 2025-09-02 12:34:06 执行时长：5.21秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode 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 WHERE a.ID=@id 2025-09-02 12:34:07 执行时长：5.33秒 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 2025-09-02 12:34:07 执行时长：21.52秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:07 执行时长：5.3秒 sql:select a.ID,a.BizEntityID,TriggerName,TriggerTiming,SQLExpression,NeedConfirm, b.Condition,b.CheckRuleExpression,b.Message,b.DataEntityID,a.InUse,a.CloseCard,a.SaveCard from Base_Trigger a left join Base_CheckRules b on a.CheckRuleName=b.id where a.BizEntityID=@beid and TriggerTiming=@TriggerTiming and a.InUse=1 2025-09-02 12:34:07 执行时长：5.17秒 sql:SELECT MAX(ID) FROM GB_ProjectPlan WHERE id>='509000000' and id<='509999999' and len(id)>=9 2025-09-02 12:34:08 执行时长：6.26秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-09-02 12:34:08 执行时长：5.16秒 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 2025-09-02 12:34:09 执行时长：5.21秒 sql:select a.ID,a.BizEntityID,TriggerName,TriggerTiming,SQLExpression,NeedConfirm, b.Condition,b.CheckRuleExpression,b.Message,b.DataEntityID,a.InUse,a.CloseCard,a.SaveCard from Base_Trigger a left join Base_CheckRules b on a.CheckRuleName=b.id where a.BizEntityID=@beid and TriggerTiming=@TriggerTiming and a.InUse=1 2025-09-02 12:34:09 执行时长：21.28秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:10 执行时长：5.21秒 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-267598') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-267598')) and (a.org='' or a.org='46') 2025-09-02 12:34:10 执行时长：5.3秒 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 2025-09-02 12:34:11 执行时长：25.36秒 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 2025-09-02 12:34:12 执行时长：5.18秒 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 2025-09-02 12:34:12 执行时长：5.74秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:34:13 执行时长：34.48秒 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 2025-09-02 12:34:13 执行时长：5.56秒 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 2025-09-02 12:34:13 执行时长：5.71秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-09-02 12:34:14 执行时长：5.92秒 sql:select * from Base_MessageServerPara WITH(NOLOCK) 2025-09-02 12:34:14 执行时长：5.21秒 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 2025-09-02 12:34:14 执行时长：6.11秒 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 2025-09-02 12:34:14 执行时长：5.43秒 sql:select d.DataColumnCode,d.DataColumnName,c.DataEntityCode,c.DataEntityName,IsPrimary,RsEntity,RsMultiSelect,b.BizDataName from Base_BizColumn a left join Base_BizData b on a.BizDataID=b.ID left join Base_DataEntity c on b.DataEntityID=c.ID left join Base_DataColumn d on a.DataColumnID=d.ID where BizEntityID='020008' 2025-09-02 12:34:15 执行时长：5.8秒 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 2025-09-02 12:34:15 执行时长：5.73秒 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-341707') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-341707')) and (a.org='' or a.org='46') 2025-09-02 12:34:16 执行时长：5.35秒 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 2025-09-02 12:34:16 执行时长：30.71秒 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-330572'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-330572'' 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-330572'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-330572'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''43'') ) ' 2025-09-02 12:34:16 执行时长：6.13秒 sql:select d.DataColumnCode,d.DataColumnName,c.DataEntityCode,c.DataEntityName,IsPrimary,RsEntity,RsMultiSelect,b.BizDataName from Base_BizColumn a left join Base_BizData b on a.BizDataID=b.ID left join Base_DataEntity c on b.DataEntityID=c.ID left join Base_DataColumn d on a.DataColumnID=d.ID where BizEntityID='006001' 2025-09-02 12:34:16 执行时长：5.64秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-09-02 12:34:16 执行时长：5.46秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-09-02 12:34:16 执行时长：25.77秒 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-330572'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-330572'' 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-330572'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-330572'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''43'') ) ' 2025-09-02 12:34:16 执行时长：13.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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:34:16 执行时长：13.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, 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:34:17 执行时长：5.36秒 sql:select a.*,dataentityname,dataentitycode from base_bizdata a inner join base_bizentity b on a.bizentityid=b.id inner join base_dataentity c on a.dataentityid=c.id where (isprimary=1 or b.bizclass=0) and a.dataentityid='001031031' order by isprimary desc,b.id asc 2025-09-02 12:34:17 执行时长：5.61秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-09-02 12:34:17 执行时长：21.21秒 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-341707' where (e.roleid in ('06') or b.operatorid='ISC-341707') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-341707') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-341707' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:34:17 执行时长：14.14秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:34:17 执行时长：20.43秒 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-341707' where (e.roleid in ('06') or b.operatorid='ISC-341707') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-341707') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-341707' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-09-02 12:34:17 执行时长：10.59秒 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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:34:17 执行时长：9.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='ISC-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:34:17 执行时长：7.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-330572' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-09-02 12:34:24 执行时长：5.92秒 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,'2025-09-02',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') )