2025-08-22 14:31:54 执行时长：6.72秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] 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 LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-08-22 14:32:08 执行时长：5.51秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID

2025-08-22 14:32:15 执行时长：6.6秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and  1=1  and PlanSendDate<=@endDate 

2025-08-22 14:32:15 执行时长：6.61秒 sql:SELECT MAX(ID) FROM GB_PlanDoc WHERE id>='508000000' and id<='508999999' and len(id)>=9  

2025-08-22 14:32:15 执行时长：6.62秒 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-08-22 14:32:15 执行时长：6.62秒 sql:SELECT id from Base_BizColumnCustom a  where bizentityid=@BizEntityID and  userid=@userID

2025-08-22 14:32:15 执行时长：6.77秒 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.rsfilter like '%.[[]组织名称]%'