2025-12-18 10:19:45 执行时长：5.4秒 sql:exec [GB_AuditorSchedule] '2025-12-14','','','','','','','0.5','ISC1604'

2025-12-18 10:32:55 执行时长：5.34秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0020'

2025-12-18 10:39:39 执行时长：5.15秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC0020'

2025-12-18 10:43:01 执行时长：5.88秒 sql:exec [GB_AuditorSchedule] '2025-12-07','','','','','','','0.5','ISC1604'

2025-12-18 10:50:40 执行时长：5.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='ISC0044' where (e.roleid in ('08','09','24','06') or b.operatorid='ISC0044') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0044')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0044' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2025-12-18 10:50:40 执行时长：5.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='ISC0044' where (e.roleid in ('08','09','24','06') or b.operatorid='ISC0044') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0044')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0044' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc