2026-01-30 11:00:44 执行时长：12.21秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaffQty] AS [组织人数],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE ([项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001'' or [认证申请].org =''01'' or [认证申请].org =''02'' or [认证申请].org =''03'' or [认证申请].org =''04'' or [认证申请].org =''05'' or [认证申请].org =''20'' or [认证申请].org =''21'' or [认证申请].org =''2101'' or [认证申请].org =''2102'' or [认证申请].org =''2103'' or [认证申请].org =''22'' or [认证申请].org =''23'' or [认证申请].org =''25'' or [认证申请].org =''2501'' or [认证申请].org =''26'' or [认证申请].org =''27'' or [认证申请].org =''29'' or [认证申请].org =''30'' or [认证申请].org =''301'' or [认证申请].org =''302'' or [认证申请].org =''303'' or [认证申请].org =''304'' or [认证申请].org =''305'' or [认证申请].org =''306'' or [认证申请].org =''307'' or [认证申请].org =''308'' or [认证申请].org =''309'' or [认证申请].org =''31'' or [认证申请].org =''310'' or [认证申请].org =''311'' or [认证申请].org =''312'' or [认证申请].org =''313'' or [认证申请].org =''315'' or [认证申请].org =''316'' or [认证申请].org =''32'' or [认证申请].org =''40'' or [认证申请].org =''41'' or [认证申请].org =''42'' or [认证申请].org =''43'' or [认证申请].org =''4301'' or [认证申请].org =''4302'' or [认证申请].org =''4303'' or [认证申请].org =''44'' or [认证申请].org =''45'' or [认证申请].org =''46'' or [认证申请].org =''48'' or [认证申请].org =''49'' or [认证申请].org =''50'' or [认证申请].org =''51'' )) AND ([项目状态_项目状态].[Name] =''已评审'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE ([项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001'' or [认证申请].org =''01'' or [认证申请].org =''02'' or [认证申请].org =''03'' or [认证申请].org =''04'' or [认证申请].org =''05'' or [认证申请].org =''20'' or [认证申请].org =''21'' or [认证申请].org =''2101'' or [认证申请].org =''2102'' or [认证申请].org =''2103'' or [认证申请].org =''22'' or [认证申请].org =''23'' or [认证申请].org =''25'' or [认证申请].org =''2501'' or [认证申请].org =''26'' or [认证申请].org =''27'' or [认证申请].org =''29'' or [认证申请].org =''30'' or [认证申请].org =''301'' or [认证申请].org =''302'' or [认证申请].org =''303'' or [认证申请].org =''304'' or [认证申请].org =''305'' or [认证申请].org =''306'' or [认证申请].org =''307'' or [认证申请].org =''308'' or [认证申请].org =''309'' or [认证申请].org =''31'' or [认证申请].org =''310'' or [认证申请].org =''311'' or [认证申请].org =''312'' or [认证申请].org =''313'' or [认证申请].org =''315'' or [认证申请].org =''316'' or [认证申请].org =''32'' or [认证申请].org =''40'' or [认证申请].org =''41'' or [认证申请].org =''42'' or [认证申请].org =''43'' or [认证申请].org =''4301'' or [认证申请].org =''4302'' or [认证申请].org =''4303'' or [认证申请].org =''44'' or [认证申请].org =''45'' or [认证申请].org =''46'' or [认证申请].org =''48'' or [认证申请].org =''49'' or [认证申请].org =''50'' or [认证申请].org =''51'' )) AND ([项目状态_项目状态].[Name] =''已评审'')' 2026-01-30 11:27:14 执行时长：5.01秒 sql:select c.CorpName,d.OrgName,b.ProjectNo ,ClassName as ApproveClass,b.begindate,b.enddate ,b.AuditTeam from GB_ProjectPlanTeam a left join GB_ProjectPlan b on a.taskno = b.taskno and a.StandardCode=b.StandardCode left join GB_Corp c on b.Corp = c.corpid left join Base_OrgV d on c.Org = d.Org left join Pub_ApproveClass e on b.ApproveClass = e.ClassCode where a.AuditorCode = 'ISC[S]0402' and begindate<= '2026-02-07 23:59' and EndDate >= '2026-02-07' 2026-01-30 11:27:16 执行时长：7.08秒 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-334652' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-334652') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2026-01-30 11:27:19 执行时长：10.19秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2026-01-30 11:27:22 执行时长：6.78秒 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-334652' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2026-01-30 11:27:25 执行时长：15.24秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id, e.readonly,visibleInList,visibleInCard,orderColumn,height,width,e.orderno,orderNumber,listWidth,orderoption,pagegroup,sumtocolumn,navigatecolumn,e.ordernoinlist,e.bizdefaultvalue,scancodeinput FROM Base_DataColumn a left join base_dataentity b on a.rsentity=b.id left join base_datacolumn c on a.rscolumn=c.id left join base_datacolumn d on a.rsdisplaycolumn=d.id left join Base_BizColumn e on a.id=e.datacolumnid and bizDataID=@id left join base_bizdata f on a.dataentityid=f.dataentityid where f.id=@id order by e.orderno,a.DisplayNo,a.id 2026-01-30 11:27:26 执行时长：9.04秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2026-01-30 11:27:29 执行时长：5.98秒 sql:SELECT 合同管理.ID as [~ID~] ,[合同来源_合同来源].Org AS [合同来源_Value],[合同来源_合同来源].OrgName AS [合同来源],[合作单位_合作单位].PartnerID AS [合作单位_Value],[合作单位_合作单位].PartnerName AS [合作单位],合同管理.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpID AS [组织名称_Value],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassCode AS [审核类别_Value],[审核类别_审核类别].ClassName AS [审核类别],合同管理.[Volume] AS [合同金额],合同管理.[ReceiveVolume] AS [到账金额],合同管理.[UnReceiveVolume] AS [未到账金额],合同管理.[BeginDate] AS [审核开始日期],合同管理.[EndDate] AS [审核结束日期],合同管理.[DecideOn] AS [认证决定日期],[计划编号_审核计划].PlanNo AS [计划编号_Value],[计划编号_审核计划].PlanNo AS [计划编号],[计划状态_计划状态].StatusCode AS [计划状态_Value],[计划状态_计划状态].StatusName AS [计划状态],合同管理.[ID] AS [系统主键],合同管理.[UpdateVersion] AS [修改版本],合同管理.[Createby] AS [创建者],合同管理.[CreateOn] AS [创建时间],合同管理.[Updateby] AS [修改者],合同管理.[UpdateOn] AS [修改时间],合同管理.[ApproveBy] AS [审核者],合同管理.[ApproveOn] AS [审核时间],[项目编号_认证项目].ProjectNo AS [项目编号_Value],[项目编号_认证项目].ProjectNo AS [项目编号],合同管理.[TaskNo] AS [任务编号] FROM FI_Contract 合同管理 WITH(NOLOCK) LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 合同管理.Org = [合同来源_合同来源].Org LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 合同管理.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 合同管理.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 合同管理.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 合同管理.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 合同管理.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 合同管理.ProjectNo = [项目编号_认证项目].ProjectNo where 合同管理.id='512000581ISC2103' 2026-01-30 11:27:30 执行时长：8.02秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage, 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-334652' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2026-01-30 11:27:31 执行时长：8.17秒 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-334652' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2026-01-30 11:27:32 执行时长：9秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage, d.RoleFromBizEntity,d.RoleFromColumn,d.RoleFromCondition ,h.status from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflowinstancedetail b WITH(NOLOCK) on a.id=b.Bizflowinstanceid inner join wf_Bizflow c on a.Bizflowid=c.id inner join wf_Bizflowaction d on b.Bizflowactionid=d.id left join wf_Bizflowactionrole e on d.id=e.Bizflowactionid left join base_user f on b.accredituser=f.userid left join base_roleright g on a.bizentityid=g.bizentityid and e.roleid=g.roleid left join Base_BizEntityStatus h on b.ID=h.id and h.BizEntityID='BFID' and h.userid='ISC-334652' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2026-01-30 11:27:33 执行时长：9.64秒 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 2026-01-30 11:27:38 执行时长：8.37秒 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-334652' 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-334652' 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-334652') and h.id is null order by b.startdate desc 2026-01-30 11:27:39 执行时长：8.19秒 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-334652' 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-334652' 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-334652') and h.id is null order by b.startdate desc 2026-01-30 11:27:40 执行时长：8.43秒 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-334652' 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-334652' 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-334652') and h.id is null order by b.startdate desc 2026-01-30 11:27:40 执行时长：7.83秒 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-334652') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-334652')) and (a.org='' or a.org='0001') 2026-01-30 11:27:41 执行时长：10.02秒 sql:SELECT MAX(ID) FROM GB_ProjectPlan WHERE id>='521000000' and id<='521999999' and len(id)>=9 2026-01-30 11:27:46 执行时长：6.3秒 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-334652' 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-334652' 2026-01-30 11:27:46 执行时长：7.6秒 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-334652' 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-334652' 2026-01-30 11:27:46 执行时长：5.61秒 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-334652' 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-334652' 2026-01-30 11:27:46 执行时长：7.36秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename from Base_BizEntityFilter a left join base_user b on a.userid=b.userid left join base_role c on a.roleid=c.roleid left join base_org d on a.org=d.orgid where bizentityid=@BizEntityID and (a.userid='' or a.userid='ISC[S]0211') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC[S]0211')) and (a.org='' or a.org='30') 2026-01-30 11:27:52 执行时长：5.55秒 sql:exec [GB_AuditorSchedule] '2026-02-01','','','黄','','','','0.5','ISC1604' 2026-01-30 11:27:54 执行时长：5.11秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[AcceptDate] AS [受理日期],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],审核计划.[DispatchBy] AS [审核派遣人],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],(case 审核计划.[IsReceive] when 1 then ''√'' else '''' end) AS [是否到账],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''30'' )) AND (( [计划状态_计划状态].[StatusName] = ''已安排'') and ([组织名称_组织信息].[CorpName] like ''%新亚光%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''30'' )) AND (( [计划状态_计划状态].[StatusName] = ''已安排'') and ([组织名称_组织信息].[CorpName] like ''%新亚光%''))' 2026-01-30 11:27:54 执行时长：7.57秒 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='000007' order by a.displayno,a.id