2025-08-07 01:56:05 执行时长：17.4秒 sql:select * from base_syspara order by paragroup

2025-08-07 01:56:11 执行时长：7.6秒 sql:select * from base_syspara order by paragroup

2025-08-07 01:56:11 执行时长：5.41秒 sql:select distinct a.Bizflowid,Bizflowname,messagedesc,a.bizentityid,a.id as Bizflowinstanceid,b.id as Bizflowinstancedetailid,a.rowid,b.Bizflowactionid,actionname,accredituser,f.username as accreditusername ,g.orgsecurity,e.roleid,b.deliverby,b.operatorid,b.StartDate,b.TimeLimitMessageSent,BizflowMessage,  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-287023' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2025-08-07 01:56:11 执行时长：6.38秒 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