2026-03-19 20:00:05 执行时长：13.46秒 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='ISCDX' where (e.roleid in ('04','05','25') or b.operatorid='ISCDX') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCDX') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISCDX' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2026-03-19 20:00:08 执行时长：14.08秒 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 2026-03-19 20:00:11 执行时长：14.59秒 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 2026-03-19 20:00:12 执行时长：18.9秒 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='ISCDX') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISCDX')) and (a.org='' or a.org='0001') 2026-03-19 20:00:15 执行时长：16.61秒 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 2026-03-19 20:00:16 执行时长：11.3秒 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='ISCDX' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISCDX') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2026-03-19 20:00:17 执行时长：9.76秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2026-03-19 20:00:18 执行时长：10.74秒 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 2026-03-19 20:00:21 执行时长：8.45秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove, relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,dataentitycode, notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull, displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.bizdataname FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where bizEntityID=@bizEntityID and isprimary=1 2026-03-19 20:00:22 执行时长：9.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='020006' 2026-03-19 20:00:23 执行时长：8.23秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:00:25 执行时长：9.05秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2026-03-19 20:00:16' 2026-03-19 20:00:25 执行时长：7.85秒 sql:select * from Base_MessageServerPara WITH(NOLOCK) 2026-03-19 20:00:27 执行时长：6.31秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2026-03-19 20:00:29 执行时长：7.12秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:00:30 执行时长：6.92秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:00:32 执行时长：6.94秒 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='ISCDX' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2026-03-19 20:00:33 执行时长：7.8秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and 1=1 and PlanSendDate<=@endDate 2026-03-19 20:00:35 执行时长：5.76秒 sql:select * from Base_BizentityCustom where BizEntityID='020006' and UserID='' and propertyname='ListWithSubData' 2026-03-19 20:00:38 执行时长：10.68秒 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='ISCDX') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISCDX')) and (a.org='' or a.org='0001') 2026-03-19 20:00:38 执行时长：7.75秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:00:39 执行时长：6.92秒 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='ISCDX' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=1 and e.roleid in ('04','05','25') 2026-03-19 20:00:40 执行时长：5.1秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2026-03-19 20:00:44 执行时长：6.07秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:00:44 执行时长：6.07秒 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' 2026-03-19 20:00:45 执行时长：5.91秒 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='ISCDX' 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='ISCDX' where (e.roleid in ('04','05','25') or b.operatorid<>'') and workflowstate=1 and b.workflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCDX') and h.id is null order by b.startdate desc 2026-03-19 20:00:52 执行时长：6.92秒 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='ISCDX' 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='ISCDX' 2026-03-19 20:00:54 执行时长：6.92秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2026-03-19 20:00:56 执行时长：76.3秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id, e.readonly,visibleInList,visibleInCard,orderColumn,height,width,e.orderno,orderNumber,listWidth,orderoption,pagegroup,sumtocolumn,navigatecolumn,e.ordernoinlist,e.bizdefaultvalue,scancodeinput FROM Base_DataColumn a left join base_dataentity b on a.rsentity=b.id left join base_datacolumn c on a.rscolumn=c.id left join base_datacolumn d on a.rsdisplaycolumn=d.id left join Base_BizColumn e on a.id=e.datacolumnid and bizDataID=@id left join base_bizdata f on a.dataentityid=f.dataentityid where f.id=@id order by e.orderno,a.DisplayNo,a.id 2026-03-19 20:00:56 执行时长：11.34秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,人员专业能力.[AuditorName] AS [人员姓名] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK) LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID WHERE ([人员编号_人员信息表].[StaffStatus] = '127') AND (([认证领域_认证领域].[FieldName] like '%环境管理体系%' or [认证领域_认证领域].[FieldName] like '%职业健康安全管理体系%' or [认证领域_认证领域].[FieldName] like '%质量管理体系%') and [专业代码_专业代码库].[ProfessionalCode] like '%14.02.04%') ) as CurrentCount 2026-03-19 20:00:57 执行时长：10.14秒 sql: SELECT DISTINCT 审核计划.ID as ID FROM GB_ProjectPlan 审核计划 with(nolock) LEFT JOIN GB_ProjectPlanTeam [审核组组成] ON 审核计划.TaskNo = [审核组组成].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_AuditorContactRecord [审核员联系记录] ON 审核计划.TaskNo = [审核员联系记录].TaskNo LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [审核计划].[PlanStatus]='03' and ([审核计划].[PlanStatus] > '02' AND [审核类型_审核类型].[TypeName] <> '变更') 2026-03-19 20:00:58 执行时长：8.8秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:00:58 执行时长：5.83秒 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='ISCDX' where workflowstate=1 and workflowactionstate=0 and operatorid in ('ISCDX') and (deliverby<>'' or deliverby is not null) 2026-03-19 20:01:01 执行时长：5.82秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode FROM Base_DataColumn a left join base_dataentity b on a.rsentity=b.id left join base_datacolumn c on a.rscolumn=c.id left join base_datacolumn d on a.rsdisplaycolumn=d.id WHERE a.dataEntityID='001002' order by a.displayno,a.id 2026-03-19 20:01:03 执行时长：79.43秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2026-03-19 20:01:03 执行时长：5.04秒 sql:SELECT fromuserid FROM base_roleaccredit where touserid=@userID and isactivity=1 and startdate<='2026-03-19 20:00:58' 2026-03-19 20:01:06 执行时长：7.65秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2026-03-19 20:01:06 执行时长：6.33秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2026-03-19 20:01:06 执行时长：5.29秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2026-03-19 20:01:06 执行时长：10.23秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[TechField] AS [技术领域],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],人员专业能力.[SourceOfAbility] AS [能力来源],人员专业能力.[ByDate] AS [通过日期],人员专业能力.[Remark] AS [备注] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK) LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'') AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%'' or [认证领域_认证领域].[FieldName] like ''%职业健康安全管理体系%'' or [认证领域_认证领域].[FieldName] like ''%质量管理体系%'') and [专业代码_专业代码库].[ProfessionalCode] like ''%14.02.04%'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[人员姓名] asc',@OnlyID = N' SELECT DISTINCT 人员专业能力.ID as [~ID~] ,人员专业能力.[AuditorName] AS [人员姓名] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK) LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'') AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%'' or [认证领域_认证领域].[FieldName] like ''%职业健康安全管理体系%'' or [认证领域_认证领域].[FieldName] like ''%质量管理体系%'') and [专业代码_专业代码库].[ProfessionalCode] like ''%14.02.04%'')' 2026-03-19 20:01:08 执行时长：6.19秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id 2026-03-19 20:01:10 执行时长：7.33秒 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 2026-03-19 20:01:13 执行时长：9.94秒 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='ISCDX' where (officeflowstate=2 or officeflowstate=3) and officeflowactionstate=0 and OperatorID='ISCDX' order by a.id desc 2026-03-19 20:01:14 执行时长：6.79秒 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='001002' 2026-03-19 20:01:15 执行时长：5.98秒 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 2026-03-19 20:01:16 执行时长：6.23秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='020006' and datacolumnid='001589' 2026-03-19 20:01:17 执行时长：6.64秒 sql:SELECT distinct b.id,a.sysfunctionid,AllowWrite,allowread FROM Base_sysfunction a left join Base_RolesysRight b on a.sysfunctionid=b.sysfunctionid and roleid=@roleID 2026-03-19 20:01:17 执行时长：6.02秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:01:18 执行时长：6.6秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='05' 2026-03-19 20:01:19 执行时长：6.6秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2026-03-19 20:01:20 执行时长：7.2秒 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<='2026-03-19 20:01:13' 2026-03-19 20:01:20 执行时长：7.21秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and 1=1 and PlanSendDate<=@endDate 2026-03-19 20:01:21 执行时长：6.57秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2026-03-19 20:01:22 执行时长：7.19秒 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 2026-03-19 20:01:23 执行时长：6.58秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='020006' and datacolumnid='001584' 2026-03-19 20:01:25 执行时长：7.73秒 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='ISCDX') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISCDX')) and (a.org='' or a.org='0001') 2026-03-19 20:01:25 执行时长：8.36秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a ,Base_UserRole b ,base_roleaccredit c where a.roleid=b.roleid and b.userid=c.fromuserid and touserid=@userID and isactivity=1 and startdate<='2026-03-19 20:01:17' 2026-03-19 20:01:26 执行时长：8.54秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='25' 2026-03-19 20:01:27 执行时长：8.49秒 sql:select * from base_syspara order by paragroup 2026-03-19 20:01:28 执行时长：8.64秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2026-03-19 20:01:28 执行时长：8.02秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2026-03-19 20:01:29 执行时长：19.88秒 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='ISCDX' where (e.roleid in ('04','05','25') or b.operatorid='ISCDX') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCDX') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISCDX' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2026-03-19 20:01:30 执行时长：9.1秒 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='ISC6401') and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC6401')) and (a.org='' or a.org='315') 2026-03-19 20:01:30 执行时长：7.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 2026-03-19 20:01:32 执行时长：6.68秒 sql:select id,orgname from base_org where orgid='315' 2026-03-19 20:01:32 执行时长：7.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='003002' 2026-03-19 20:01:32 执行时长：9.71秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID 2026-03-19 20:01:32 执行时长：26.18秒 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 2026-03-19 20:01:33 执行时长：6.61秒 sql:select owner,viewer from wf_Bizflowaction a left join wf_Bizflowright b on a.Bizflowid=b.Bizflowid where bizentityid=@bizEntityID and roleid=@roleid 2026-03-19 20:01:33 执行时长：6.4秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2026-03-19 20:01:34 执行时长：5.32秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2026-03-19 20:01:34 执行时长：5.68秒 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='ISCDX' where Bizflowstate=1 and Bizflowactionstate=0 and operatorid in ('ISCDX') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity='' 2026-03-19 20:01:36 执行时长：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=@id 2026-03-19 20:01:39 执行时长：5.57秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2026-03-19 20:01:41 执行时长：5.72秒 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 2026-03-19 20:01:42 执行时长：9.86秒 sql:SELECT distinct b.id,a.id as BizEntityID,AllowAdd,allowread,orgsecurity,rolesecurity,usersecurity,allowdelete,allowedit,allowapprove,uidesign,allowoutput,updateFromExcel,importfromexcel,outputtoexcel FROM Base_bizentity a left join Base_RoleRight b on a.id=b.bizentityid and roleid=@roleID where a.id not like '000%' or a.id in ('000004','000010') order by a.id 2026-03-19 20:01:42 执行时长：5.4秒 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='001002' 2026-03-19 20:01:42 执行时长：5.21秒 sql:select owner,viewer from wf_Bizflowaction a left join wf_Bizflowright b on a.Bizflowid=b.Bizflowid where bizentityid=@bizEntityID and roleid=@roleid 2026-03-19 20:01:45 执行时长：10.44秒 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='ISCDX' where (e.roleid in ('04','05','25') or b.operatorid='ISCDX') and Bizflowstate=1 and Bizflowactionstate=0 and (b.operatorid is null or b.operatorid='' or b.operatorid='ISCDX') and b.Bizflowinstanceid+b.Bizflowactionid not in (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISCDX' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc 2026-03-19 20:01:45 执行时长：6.91秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2026-03-19 20:01:45 执行时长：8.23秒 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='020006' 2026-03-19 20:01:46 执行时长：8.67秒 sql:select count(*) from ( 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='ISCDX') AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISCDX' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='0001') ) ) as CurrentCount 2026-03-19 20:01:46 执行时长：7.3秒 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='ISCDX' where Bizflowstate=1 and Bizflowactionstate=0 and RoleFromBizEntity<>'' and roleFormIsUser=0 2026-03-19 20:01:46 执行时长：5.44秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2026-03-19 20:01:46 执行时长：8.07秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2026-03-19 20:01:47 执行时长：7.76秒 sql:SELECT distinct b.id,a.sysfunctionid,AllowWrite,allowread FROM Base_sysfunction a left join Base_RolesysRight b on a.sysfunctionid=b.sysfunctionid and roleid=@roleID 2026-03-19 20:01:47 执行时长：6.54秒 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 2026-03-19 20:01:48 执行时长：5.78秒 sql:SELECT MAX(ID) FROM GB_AuditorProfessional WHERE id>='523000000' and id<='523999999' and len(id)>=9 2026-03-19 20:01:49 执行时长：7.19秒 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<='2026-03-19 20:01:42' 2026-03-19 20:01:50 执行时长：5.04秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2026-03-19 20:01:50 执行时长：7.88秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect,bizdataname 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='0004' and b.datacolumncode<>'' order by ordernumber 2026-03-19 20:01:53 执行时长：5.88秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a ,Base_UserRole b ,base_roleaccredit c where a.roleid=b.roleid and b.userid=c.fromuserid and touserid=@userID and isactivity=1 and startdate<='2026-03-19 20:01:47' 2026-03-19 20:46:48 执行时长：7.35秒 sql:exec [GB_PartnerCertiStatistics] 2026-03-19 20:46:49 执行时长：7.62秒 sql:exec [GB_PartnerCertiStatistics] 2026-03-19 20:48:03 执行时长：8.42秒 sql:exec [GB_PartnerCertiStatistics] 2026-03-19 20:48:03 执行时长：8.47秒 sql:exec [GB_PartnerCertiStatistics]