2025-11-24 23:02:48 执行时长：7.29秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:02:41' 2025-11-24 23:02:59 执行时长：10.82秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-11-24 23:03:02 执行时长：5.42秒 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-11-24 23:03:05 执行时长：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-22868' 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-22868' 2025-11-24 23:03:06 执行时长：6.92秒 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-22868' 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-22868' 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-22868') and h.id is null order by b.startdate desc 2025-11-24 23:03:07 执行时长：5.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-11-24 23:03:08 执行时长：5.31秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-11-24 23:03:09 执行时长：6秒 sql:select * from GB_ProjectPlan WITH(NOLOCK) where id='56116' 2025-11-24 23:03:10 执行时长：6.31秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:03:10 执行时长：5.11秒 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-22868' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) 2025-11-24 23:03:12 执行时长：5.23秒 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-22868' 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-22868' 2025-11-24 23:03:13 执行时长：6.04秒 sql:select * from GB_ProjectPlan WITH(NOLOCK) where id='56116' 2025-11-24 23:03:14 执行时长：6.18秒 sql:select * from Base_MessageServerPara WITH(NOLOCK) 2025-11-24 23:03:15 执行时长：6.85秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:03:25 执行时长：16.57秒 sql:select a.id,a.FileName as DocFile,'https://oa.china-isc.org.cn/bizattach'+'/GB_CertiApplyCorpDoc/'+ a.ID +'/002153/'+a.FileName as Url from GB_CertiApplyCorpDoc a where a.corp = '6707' and NotAddPackage = 0 and a.FileName<>'' 2025-11-24 23:03:26 执行时长：16.83秒 sql:select * from Base_BizentityCustom where BizEntityID='000004' and UserID='' and propertyname='ListWithSubData' 2025-11-24 23:03:27 执行时长：29.22秒 sql:select * from Base_BizentityCustom where BizEntityID='000004' and UserID='' and propertyname='ListWithSubData' 2025-11-24 23:03:27 执行时长：16.83秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:03:10' 2025-11-24 23:03:30 执行时长：16.89秒 sql:select a.id,a.FileName as DocFile,'https://oa.china-isc.org.cn/bizattach'+'/GB_CertiApplyCorpDoc/'+ a.ID +'/002153/'+a.FileName as Url from GB_CertiApplyCorpDoc a where a.corp = '6707' and NotAddPackage = 0 and a.FileName<>'' 2025-11-24 23:03:31 执行时长：16.95秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and 1=1 and PlanSendDate<=@endDate 2025-11-24 23:03:32 执行时长：17.11秒 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.id=@id 2025-11-24 23:03:33 执行时长：6.78秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2025-11-24 23:03:34 执行时长：7.6秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2025-11-24 23:03:35 执行时长：8秒 sql:select * from base_message WITH(NOLOCK) where userid=@userID and (HaveRead=0 or haveread is null) order by messagedate desc 2025-11-24 23:03:36 执行时长：24.1秒 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-22868' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) 2025-11-24 23:03:37 执行时长：7.84秒 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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:03:39 执行时长：51.05秒 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 23:03:40 执行时长：7.3秒 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-11-24 23:03:42 执行时长：8.16秒 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-11-24 23:03:44 执行时长：8.61秒 sql:select distinct a.id as id,alertname,condition,a.bizentityid as bizentityid,a.message from base_bizalert a left join base_roleright b on a.bizentityid=b.bizentityid left join base_userrole c on b.roleid=c.roleid where c.userid='ISC-22868' and (allowread=1 or allowadd=1 or allowedit=1 or allowdelete=1) 2025-11-24 23:03:45 执行时长：9.36秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:03:36' 2025-11-24 23:03:45 执行时长：13.42秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:03:46 执行时长：9.36秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:03:46 执行时长：5.71秒 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-11-24 23:03:47 执行时长：6.43秒 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-11-24 23:03:48 执行时长：5.01秒 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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:03:51 执行时长：5.31秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:03:51 执行时长：5.29秒 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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:03:51 执行时长：21.78秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-11-24 23:03:52 执行时长：5.48秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:03:46' 2025-11-24 23:03:52 执行时长：5.94秒 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-22868') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-22868' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='0001') ) ) as CurrentCount 2025-11-24 23:03:52 执行时长：5.32秒 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-22868') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-22868' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='0001') ) ) as CurrentCount 2025-11-24 23:03:54 执行时长：5.73秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:03:55 执行时长：5.61秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.touserid=b.userid where fromuserid=@userID and isactivity=1 and startdate<='2025-11-24 23:03:49' 2025-11-24 23:03:56 执行时长：5.35秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:03:56 执行时长：5.41秒 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-11-24 23:03:58 执行时长：6.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, 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:04:05 执行时长：12.63秒 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-22868'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-22868'' 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=''ISC-22868'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-22868'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) ' 2025-11-24 23:04:05 执行时长：12.23秒 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-22868'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-22868'' 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=''ISC-22868'') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC-22868'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) ' 2025-11-24 23:04:06 执行时长：12.94秒 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-11-24 23:04:06 执行时长：11.91秒 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-11-24 23:04:06 执行时长：12.54秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:03:54' 2025-11-24 23:04:07 执行时长：11.82秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:07 执行时长：11.18秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:03:56' 2025-11-24 23:04:07 执行时长：11.17秒 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-11-24 23:04:08 执行时长：10.31秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-11-24 23:04:09 执行时长：22.12秒 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-11-24 23:04:15 执行时长：5.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-22868') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-22868')) and (a.org='' or a.org='0001') 2025-11-24 23:04:16 执行时长：5.35秒 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-11-24 23:04:17 执行时长：102.47秒 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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:17 执行时长：5.19秒 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-22868') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-22868')) and (a.org='' or a.org='0001') 2025-11-24 23:04:18 执行时长：6.15秒 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-22868' 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-22868' 2025-11-24 23:04:19 执行时长：5.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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:20 执行时长：5.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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:20 执行时长：5.01秒 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-11-24 23:04:21 执行时长：5.59秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-11-24 23:04:22 执行时长：5.17秒 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='000004' 2025-11-24 23:04:23 执行时长：5.53秒 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-11-24 23:04:24 执行时长：5.54秒 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-22868' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) 2025-11-24 23:04:24 执行时长：5.97秒 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='ISC0031' where (e.roleid in ('103','04','05','25') or b.operatorid='ISC0031') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0031') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0031' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:24 执行时长：5.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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:25 执行时长：5.8秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:25 执行时长：5.55秒 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.id=@id 2025-11-24 23:04:25 执行时长：5.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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:26 执行时长：5.59秒 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-22868' 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-22868' 2025-11-24 23:04:26 执行时长：6.26秒 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-11-24 23:04:27 执行时长：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 ,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='ISC0031' where (e.roleid in ('103','04','05','25') or b.operatorid='ISC0031') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0031') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0031' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:27 执行时长：6.17秒 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='006002' 2025-11-24 23:04:27 执行时长：5.97秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:21' 2025-11-24 23:04:28 执行时长：5.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-11-24 23:04:28 执行时长：21.81秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:04:28 执行时长：6.02秒 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.id=@id 2025-11-24 23:04:29 执行时长：5.28秒 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.id=@id 2025-11-24 23:04:29 执行时长：6.18秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-11-24 23:04:30 执行时长：5.91秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:24' 2025-11-24 23:04:30 执行时长：6.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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC0031') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:31 执行时长：6.4秒 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.id=@id 2025-11-24 23:04:31 执行时长：6.4秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:25' 2025-11-24 23:04:32 执行时长：7.55秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:33 执行时长：11.55秒 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-11-24 23:04:33 执行时长：7.43秒 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-22868' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) 2025-11-24 23:04:33 执行时长：6.97秒 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.id=@id 2025-11-24 23:04:33 执行时长：9.88秒 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-11-24 23:04:34 执行时长：7.06秒 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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC0031') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:34 执行时长：6.87秒 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-11-24 23:04:35 执行时长：6.7秒 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-11-24 23:04:35 执行时长：7.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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:04:36 执行时长：7.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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-11-24 23:04:36 执行时长：7.81秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:37 执行时长：8.29秒 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 left join base_dataentity e on a.dataentityid=e.id WHERE a.datacolumnname=@columnName and e.dataentityname=@entityName 2025-11-24 23:04:37 执行时长：9.09秒 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='ISC0031' where (e.roleid in ('103','04','05','25') or b.operatorid='ISC0031') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0031') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0031' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:38 执行时长：11.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-11-24 23:04:38 执行时长：9.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-11-24 23:04:38 执行时长：11.04秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:39 执行时长：9.09秒 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='ISC-22868' where (officeflowstate=2 or officeflowstate=3) and officeflowactionstate=0 and OperatorID='ISC-22868' order by a.id desc 2025-11-24 23:04:39 执行时长：9.1秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-11-24 23:04:40 执行时长：8.68秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:40 执行时长：9.56秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:04:41 执行时长：8.81秒 sql:select * from Base_BizentityCustom where BizEntityID='000004' and UserID='' and propertyname='ListWithSubData' 2025-11-24 23:04:41 执行时长：8.46秒 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-11-24 23:04:42 执行时长：8.73秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:33' 2025-11-24 23:04:42 执行时长：9.14秒 sql:select CodeName from Pub_Code WITH(NOLOCK) WHERE CodeID='209' 2025-11-24 23:04:43 执行时长：9.36秒 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-11-24 23:04:44 执行时长：13.69秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:30' 2025-11-24 23:04:44 执行时长：10.9秒 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-11-24 23:04:44 执行时长：10.41秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:34' 2025-11-24 23:04:46 执行时长：12.34秒 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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:47 执行时长：11.85秒 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-11-24 23:04:47 执行时长：11.89秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-11-24 23:04:48 执行时长：12.07秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-11-24 23:04:48 执行时长：12.89秒 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-22868' where (e.roleid in ('06') or b.operatorid='ISC-22868') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC-22868') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC-22868' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:49 执行时长：14.92秒 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-11-24 23:04:49 执行时长：12.9秒 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-22868' 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-22868' 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-22868') and h.id is null order by b.startdate desc 2025-11-24 23:04:50 执行时长：13.4秒 sql:select * from Base_BizentityCustom where BizEntityID='000004' and UserID='' and propertyname='ListWithSubData' 2025-11-24 23:04:50 执行时长：12.1秒 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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC0031') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:50 执行时长：12.43秒 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-11-24 23:04:51 执行时长：12.42秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='103' 2025-11-24 23:04:51 执行时长：12.67秒 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-22868') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-22868')) and (a.org='' or a.org='0001') 2025-11-24 23:04:52 执行时长：13.32秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.touserid=b.userid where fromuserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:39' 2025-11-24 23:04:52 执行时长：13.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-11-24 23:04:52 执行时长：22.33秒 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='ISC0031' where (e.roleid in ('103','04','05','25') or b.operatorid='ISC0031') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0031') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0031' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2025-11-24 23:04:53 执行时长：13.62秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:04:53 执行时长：12.74秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('06') 2025-11-24 23:04:54 执行时长：12.73秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2025-11-24 23:04:55 执行时长：17.52秒 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 left join base_dataentity e on a.dataentityid=e.id where e.dataentityname = '组织信息文档' and a.formula like '%{组织信息文档}.[[]文件名称]%' order by a.displayno 2025-11-24 23:04:55 执行时长：13.09秒 sql:select CodeName from Pub_Code WITH(NOLOCK) WHERE CodeID='209' 2025-11-24 23:04:55 执行时长：12.63秒 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-11-24 23:04:56 执行时长：12.1秒 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-11-24 23:04:57 执行时长：10.97秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:58 执行时长：16.71秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2025-11-24 23:04:58 执行时长：13.58秒 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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:04:58 执行时长：11.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-11-24 23:04:59 执行时长：11.01秒 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-11-24 23:04:59 执行时长：10.5秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:04:59 执行时长：10.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-11-24 23:05:00 执行时长：11.02秒 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-22868' 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-22868' 2025-11-24 23:05:00 执行时长：10.84秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2025-11-24 23:05:01 执行时长：11.36秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:50' 2025-11-24 23:05:01 执行时长：10.87秒 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-11-24 23:05:02 执行时长：11.3秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='04' 2025-11-24 23:05:02 执行时长：10.88秒 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='006002' 2025-11-24 23:05:03 执行时长：10.26秒 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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISC0031') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2025-11-24 23:05:03 执行时长：10.07秒 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-11-24 23:05:03 执行时长：15.86秒 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-22868' 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-22868' 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-22868') and h.id is null order by b.startdate desc 2025-11-24 23:05:03 执行时长：9.97秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:05:03 执行时长：9.99秒 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-22868' 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-22868' 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-22868') and h.id is null order by b.startdate desc 2025-11-24 23:05:04 执行时长：20.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, 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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:05:04 执行时长：8.65秒 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-11-24 23:05:04 执行时长：9.8秒 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-11-24 23:05:05 执行时长：8.45秒 sql:select c.AuditorName from GB_ProjectPlan a left join GB_ProjectPlanteam b on a.taskno=b.taskno and a.standardcode=b.standardcode left join gb_auditor c on b.auditorcode = c.auditorcode where b.Duty = '190' and a.id = '511001361' 2025-11-24 23:05:05 执行时长：7.92秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:57' 2025-11-24 23:05:06 执行时长：8.35秒 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-11-24 23:05:06 执行时长：8.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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('103','04','05','25') 2025-11-24 23:05:06 执行时长：10.12秒 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-11-24 23:05:06 执行时长：12.41秒 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-22868') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-22868')) and (a.org='' or a.org='0001') 2025-11-24 23:05:07 执行时长：8.45秒 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-11-24 23:05:07 执行时长：8.69秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-11-24 23:05:07 执行时长：8.36秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-11-24 23:05:07 执行时长：8.41秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:04:59' 2025-11-24 23:05:08 执行时长：8.21秒 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-11-24 23:05:08 执行时长：9.13秒 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-11-24 23:05:08 执行时长：8.11秒 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-22868' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISC-22868') and (deliverby<>'' or deliverby is not null) 2025-11-24 23:05:08 执行时长：7.04秒 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-11-24 23:05:08 执行时长：7.5秒 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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2025-11-24 23:05:09 执行时长：6.6秒 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.id=@id 2025-11-24 23:05:09 执行时长：7.05秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-11-24 23:05:09 执行时长：6.43秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2025-11-24 23:05:09 执行时长：6.64秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2025-11-24 23:05:03' 2025-11-24 23:05:10 执行时长：9.26秒 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-11-24 23:05:10 执行时长：6.53秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-11-24 23:05:10 执行时长：8.4秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='05' 2025-11-24 23:05:10 执行时长：6.99秒 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-22868' 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-22868' 2025-11-24 23:05:10 执行时长：6.44秒 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-11-24 23:05:10 执行时长：7.44秒 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-22868' 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-22868' 2025-11-24 23:05:10 执行时长：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='ISC0031' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('103','04','05','25') 2025-11-24 23:05:11 执行时长：5.35秒 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-22868' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0