2025-11-24 16:56:21 执行时长：16.29秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','余','','','','0.5','ISC-418501'

2025-11-24 16:56:25 执行时长：7.84秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[ApplyNo] AS [申请单号],[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[StaCodes] AS [标准代码],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[CheckDate] AS [评审通过时间],认证申请.[StaffQty] AS [组织人数],认证申请.[CertiFee] AS [认证费],认证申请.[SupervisionFee] AS [监督费],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID 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 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'' )) 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 Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID 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 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'' )) AND ([项目状态_项目状态].[Name] = ''已提交''   )'

2025-11-24 16:56:25 执行时长：8.42秒 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-11-24 16:56:26 执行时长：10.63秒 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-11-24 16:56:26 执行时长：10.12秒 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-238331' where (e.roleid in ('06') or b.operatorid='ISC-238331') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-238331')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-238331' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc