2026-03-19 19:08:50 执行时长：15.99秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-19 19:08:51 执行时长：19.89秒 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 19:08:53 执行时长：21.35秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-24421') AND ([审核计划].BeginDate>='2026-03-01 00:00') ) as CurrentCount

2026-03-19 19:09:06 执行时长：13秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CertiInfo] AS [证书信息],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-24421'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-24421'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'')'

2026-03-19 19:09:09 执行时长：30.54秒 sql:select * from base_bizalert where alertname=@name

2026-03-19 19:09:13 执行时长：5.37秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-24421') AND ([审核计划].BeginDate>='2026-03-01 00:00') ) as CurrentCount

2026-03-19 19:09:21 执行时长：13.65秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and  1=1  and PlanSendDate<=@endDate 

2026-03-19 19:09:23 执行时长：18.34秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-24421') AND ([审核计划].BeginDate>='2026-03-01 00:00') ) as CurrentCount

2026-03-19 19:09:42 执行时长：8.75秒 sql:SELECT * FROM  base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id

2026-03-19 19:09:42 执行时长：8.73秒 sql:INSERT INTO Base_Log(id,username,logdate,modulename,operatetype,remark,ipaddress) values  ('h8cqBReU2ki2RaKjB1VTjQ', @userName,@logDate,@moduleName,@OperateType,@remark,@ip )

2026-03-19 19:09:49 执行时长：26.61秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CertiInfo] AS [证书信息],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-24421'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-24421'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'')'

2026-03-19 19:10:21 执行时长：9.15秒 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 

2026-03-19 19:10:29 执行时长：8.36秒 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 19:10:34 执行时长：6.59秒 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 19:10:40 执行时长：6.92秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:10:43 执行时长：9.64秒 sql:SELECT MAX(ID) FROM GB_ProjectPlan WHERE id>='523000000' and id<='523999999' and len(id)>=9  

2026-03-19 19:10:43 执行时长：6.27秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:10:47 执行时长：20.55秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] 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 [计划状态_计划状态].[StatusName] in ('案卷评议中')  AND [审核计划].[IsReform] =1 and (([阅卷人员_登录用户].[UserID] = 'ISC-24421'  OR 'ISC-24421'='admin')  AND [审核计划].[PlanStatus] >= '12' )

2026-03-19 19:10:55 执行时长：10.63秒 sql:select count(*) from ( SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like '%江西省润泉水表检测有限公司%' ) as CurrentCount

2026-03-19 19:10:56 执行时长：7.83秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:10:56 执行时长：16.5秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='040031' and datacolumnid='003536'

2026-03-19 19:10:57 执行时长：12.57秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:11:01 执行时长：6.73秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:11:03 执行时长：6.34秒 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='gouxiao')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='gouxiao'))  and (a.org='' or a.org='0001')

2026-03-19 19:11:04 执行时长：6.28秒 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 19:11:05 执行时长：6.31秒 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 19:10:59'

2026-03-19 19:11:07 执行时长：11.37秒 sql:select * from Base_BizentityCustom where BizEntityID='040031' and UserID='' and propertyname='ListWithSubData'

2026-03-19 19:11:10 执行时长：11.78秒 sql:select count(*) from ( SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like '%江西省润泉水表检测有限公司%' ) as CurrentCount

2026-03-19 19:11:14 执行时长：18.96秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:11:17 执行时长：8.05秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:11:17 执行时长：6.22秒 sql:SELECT * FROM Base_querysolution where bizentityid=@bizEntityID and isdefault=1 and ((isprivate=1 and userid='ISC-434234') or isprivate=0) order by isprivate desc

2026-03-19 19:11:18 执行时长：6.97秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:11:23 执行时长：5.14秒 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='0338' and b.datacolumncode<>''  order by ordernumber

2026-03-19 19:11:24 执行时长：13.87秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:11:24 执行时长：5.21秒 sql:select count(*) from ( SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like '%江西省润泉水表检测有限公司%' ) as CurrentCount

2026-03-19 19:11:27 执行时长：22.36秒 sql:select id,orgname from base_org where orgid='0001'

2026-03-19 19:11:27 执行时长：22.4秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:11:27 执行时长：18.62秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:11:31 执行时长：6.77秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:11:34 执行时长：14.5秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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 [计划状态_计划状态].[StatusName] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-24421')

2026-03-19 19:11:34 执行时长：10.36秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:11:42 执行时长：11.26秒 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 19:11:43 执行时长：7.28秒 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='0338' and b.datacolumncode<>''  order by ordernumber

2026-03-19 19:11:45 执行时长：17.33秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:11:54 执行时长：6.91秒 sql:select a.id as datacolumnid ,a.dataentityid as dataentityid, d.bizentityid as bizentityid,allowread,allowwrite,datacolumnname,c.id as bizcolumnid from base_datacolumn a left join base_bizcolumn c on a.id=c.datacolumnid left join base_bizdata d on c.bizdataid=d.id left join base_roledataright e  on a.dataentityid=e.dataentityid and a.id=e.columnid and d.bizentityid=e.bizentityid  and roleid=@roleID  where useright=1  order  by d.bizentityid,a.dataentityid 

2026-03-19 19:12:01 执行时长：16.28秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID WHERE [组织名称_组织信息].[CorpName] like ''%江西省润泉水表检测有限公司%'''

2026-03-19 19:12:01 执行时长：16.15秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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 1=1 and ([审核计划].[PlanStatus] >='11'   AND [审核组组成].[AuditorCode] = 'ISC-24421'  AND [评定状态_评定状态].[StatusName] = '问题档'   AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190')

2026-03-19 19:12:23 执行时长：9.37秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-434234') AND ([审核计划].BeginDate>='2026-03-01 00:00' and [计划状态_计划状态].[StatusName] = '已批准' and [审核计划].[EndDate] >=getdate()) ) as CurrentCount

2026-03-19 19:12:35 执行时长：12.07秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CertiInfo] AS [证书信息],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-434234'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'' and [计划状态_计划状态].[StatusName] = ''已批准'' and [审核计划].[EndDate] >=getdate()) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-434234'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'' and [计划状态_计划状态].[StatusName] = ''已批准'' and [审核计划].[EndDate] >=getdate())'

2026-03-19 19:12:38 执行时长：22.07秒 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 

2026-03-19 19:12:45 执行时长：5.98秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] 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 [计划状态_计划状态].[StatusName] in ('案卷评议中')  AND [审核计划].[IsReform] =1 and (([阅卷人员_登录用户].[UserID] = 'ISC-24421'  OR 'ISC-24421'='admin')  AND [审核计划].[PlanStatus] >= '12' )

2026-03-19 19:13:00 执行时长：8.95秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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 [计划状态_计划状态].[StatusName] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-24421')

2026-03-19 19:14:04 执行时长：5.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-244982' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-19 19:14:10 执行时长：6.45秒 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-244982' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-19 19:14:11 执行时长：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='ISC-244982' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-19 19:14:16 执行时长：5.58秒 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-244982' 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-244982' 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-244982')  and h.id is null  order by b.startdate desc 

2026-03-19 19:14:16 执行时长：10.3秒 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 

2026-03-19 19:14:43 执行时长：8.04秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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 [计划状态_计划状态].[StatusName] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-244982')

2026-03-19 19:14:56 执行时长：5.43秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_AuditProblem [审议问题] ON 审核计划.TaskNo = [审议问题].TaskNo LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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 1=1 and ([审核计划].[PlanStatus] >='11'   AND [审核组组成].[AuditorCode] = 'ISC-244982'  AND [评定状态_评定状态].[StatusName] = '问题档'   AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190')

2026-03-19 19:15:20 执行时长：7.35秒 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-244982')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC-244982'))  and (a.org='' or a.org='45')

2026-03-19 19:15:49 执行时长：27.84秒 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 

2026-03-19 19:15:51 执行时长：12.15秒 sql: SELECT DISTINCT  审核计划.ID as ID  FROM GB_ProjectPlan 审核计划 with(nolock)  LEFT JOIN GB_ProjectPlanCombine [计划结合安排] ON 审核计划.TaskNo = [计划结合安排].TaskNo LEFT JOIN GB_InvalidDoc [不符合报告] ON 审核计划.TaskNo = [不符合报告].TaskNo LEFT JOIN GB_ProjectPlanTeam [审核组组成] 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 [计划状态_计划状态].[StatusName] = '已批准' and [审核计划].[EndDate] >=getdate() and ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-244982')

2026-03-19 19:16:12 执行时长：9.88秒 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 19:16:24 执行时长：5.55秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,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 left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2026-03-19 19:20:41 执行时长：7.73秒 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 19:20:49 执行时长：10.63秒 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[S]0402' where (e.roleid in ('06') or b.operatorid='ISC[S]0402') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0402')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC[S]0402' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-19 19:20:52 执行时长：13.37秒 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[S]0402' where (e.roleid in ('06') or b.operatorid='ISC[S]0402') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0402')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC[S]0402' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-19 19:20:52 执行时长：5.64秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-495970') AND ([审核计划].BeginDate>='2026-03-01 00:00') ) as CurrentCount

2026-03-19 19:20:53 执行时长：8.52秒 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[S]0402')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC[S]0402'))  and (a.org='' or a.org='0001')

2026-03-19 19:20:53 执行时长：12.03秒 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='ISC0042' where (e.roleid in ('05','04','25') or b.operatorid='ISC0042') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0042')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0042' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-19 19:20:53 执行时长：11.51秒 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='ISC0042' where (e.roleid in ('05','04','25') or b.operatorid='ISC0042') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0042')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0042' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-19 19:20:55 执行时长：12.55秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-19 19:20:59 执行时长：9.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='ISC[S]0402' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC[S]0402') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-19 19:21:04 执行时长：9.71秒 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[S]0402' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-19 19:21:05 执行时长：11.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,  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='ISC0042' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-19 19:21:05 执行时长：11.07秒 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='ISC0042' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=0

2026-03-19 19:21:10 执行时长：9.16秒 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[S]0402' where Bizflowstate=1 and Bizflowactionstate=0  and RoleFromBizEntity<>'' and roleFormIsUser=1  and e.roleid in ('06') 

2026-03-19 19:21:13 执行时长：6.19秒 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='ISC0042'  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='ISC0042'  

2026-03-19 19:21:13 执行时长：7.31秒 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='ISC0042'  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='ISC0042'  

2026-03-19 19:21:13 执行时长：9.29秒 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[S]0402' 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[S]0402' 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[S]0402')  and h.id is null  order by b.startdate desc 

2026-03-19 19:21:15 执行时长：19.27秒 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 

2026-03-19 19:21:18 执行时长：7.07秒 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[S]0402'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC[S]0402'' 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[S]0402'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC[S]0402'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) '

2026-03-19 19:21:18 执行时长：7.26秒 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=''ISC0042'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC0042'' 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=''ISC0042'')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = ''ISC0042'' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid=''0001'') ) '

2026-03-19 19:21:19 执行时长：8.44秒 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[S]0402' 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[S]0402' 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[S]0402')  and h.id is null  order by b.startdate desc 

2026-03-19 19:21:19 执行时长：5.81秒 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[S]0402'  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[S]0402'  

2026-03-19 19:21:20 执行时长：7.13秒 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='ISC0042' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC0042') and (deliverby<>'' or deliverby is not null)

2026-03-19 19:21:22 执行时长：8.84秒 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='ISC0042' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC0042') and (deliverby<>'' or deliverby is not null)

2026-03-19 19:21:26 执行时长：6.71秒 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[S]0402' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC[S]0402') and (deliverby<>'' or deliverby is not null)

2026-03-19 19:21:27 执行时长：6.04秒 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[S]0402' where workflowstate=1 and workflowactionstate=0  and  operatorid in ('ISC[S]0402') and (deliverby<>'' or deliverby is not null)

2026-03-19 19:21:42 执行时长：21.45秒 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 

2026-03-19 19:21:45 执行时长：5.72秒 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 19:21:46 执行时长：53.95秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CertiInfo] AS [证书信息],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-495970'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_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 LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-495970'') AND ([审核计划].BeginDate>=''2026-03-01 00:00'')'

2026-03-19 19:21:46 执行时长：8.61秒 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[S]0400' where (e.roleid in ('06') or b.operatorid='ISC[S]0400') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC[S]0400')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC[S]0400' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-19 19:21:47 执行时长：8.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  ,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='ISC0042' where (e.roleid in ('05','04','25') or b.operatorid='ISC0042') and Bizflowstate=1 and Bizflowactionstate=0  and (b.operatorid is null or b.operatorid='' or b.operatorid='ISC0042')  and  b.Bizflowinstanceid+b.Bizflowactionid not in  (select Bizflowinstanceid+Bizflowactionid from wf_Bizflowinstancedetail WITH(NOLOCK) where operatorid='ISC0042' and (Bizflowactionstate=1 and Bizflowactionstate=2)) and RoleFromBizEntity='' order by b.startdate desc

2026-03-19 19:21:51 执行时长：8.96秒 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[S]0400' where Bizflowstate=1 and Bizflowactionstate=0  and  operatorid in ('ISC[S]0400') and (deliverby<>'' or deliverby is not null) and RoleFromBizEntity=''

2026-03-19 19:21:51 执行时长：6.3秒 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[S]0400')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC[S]0400'))  and (a.org='' or a.org='45')

2026-03-19 19:22:01 执行时长：5.7秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[CertiInfo] AS [证书信息],审核计划.[AuditTeam] AS [审核组],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[ProfessionalCode] AS [专业代码],[审核方式_审核方式].ApproveMode AS [审核方式],[省份_省份].Province AS [省份],审核计划.[CertiQty] AS [体系人数],审核计划.[IssuesToBeNoted] AS [审核需关注问题],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'''

2026-03-19 19:57:52 执行时长：12.41秒 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 19:58:05 执行时长：9.48秒 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='002001' order by a.displayno,a.id

2026-03-19 19:58:13 执行时长：8.33秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id

2026-03-19 19:58:16 执行时长：6.16秒 sql:select * from Base_MessageServerPara WITH(NOLOCK) 

2026-03-19 19:58:21 执行时长：7.94秒 sql:SELECT 组织信息.ID as [~ID~] ,组织信息.[EngName] AS [英文名称],组织信息.[OriginalName] AS [组织原名],组织信息.[Website] AS [网址],组织信息.[BizAddress] AS [生产经营地址],组织信息.[RegisterPC] AS [注册地址邮编],组织信息.[PostCode] AS [通讯地址邮编],组织信息.[ProductPC] AS [生产地址邮编],[城市_城市表].CityCode AS [城市_Value],[城市_城市表].City AS [城市],[生产地址所在省份_省份].ProvinceCode AS [生产地址所在省份_Value],[生产地址所在省份_省份].Province AS [生产地址所在省份],[生产地址所在城市_城市表].CityCode AS [生产地址所在城市_Value],[生产地址所在城市_城市表].City AS [生产地址所在城市],[生产地址所在地区_所在地区].AreaCode AS [生产地址所在地区_Value],[生产地址所在地区_所在地区].AreaName AS [生产地址所在地区],组织信息.[BizInfo] AS [经营范围],组织信息.[RegisterCapital] AS [注册资本],[注册资本币种_币种].CurrencyCode AS [注册资本币种_Value],[注册资本币种_币种].CurrencyName AS [注册资本币种],组织信息.[ArtificialPerson] AS [法人代表],组织信息.[Contactor] AS [联系人],组织信息.[ContactPost] AS [联系人职务],组织信息.[Tel] AS [电话],组织信息.[Mobile] AS [手机],组织信息.[Email] AS [Email],[开票类型_代码表].CodeID AS [开票类型_Value],[开票类型_代码表].CodeName AS [开票类型],组织信息.[BankNo] AS [开户行及账号],组织信息.[AddressTel] AS [地址及电话],组织信息.[Remark] AS [备注],组织信息.[AccountID] AS [登录账号],[组织运作状况_代码表].CodeID AS [组织运作状况_Value],[组织运作状况_代码表].CodeName AS [组织运作状况],组织信息.[CorpName] AS [组织名称],[合同来源_合同来源].Org AS [合同来源_Value],[合同来源_合同来源].OrgName AS [合同来源],组织信息.[OrgCode] AS [统一信用代码],组织信息.[Address] AS [通讯地址],[省份_省份].ProvinceCode AS [省份_Value],[省份_省份].Province AS [省份],组织信息.[CooperativeUnits] AS [合作方],组织信息.[InputBy] AS [录入人],[所在地区_所在地区].AreaCode AS [所在地区_Value],[所在地区_所在地区].AreaName AS [所在地区],组织信息.[CorpID] AS [组织编号],组织信息.[RegisterAddress] AS [注册地址],组织信息.[StaffQty] AS [组织人数],组织信息.[SocialSecurity] AS [社保人数],[企业性质_企业类型].Code AS [企业性质_Value],[企业性质_企业类型].Name AS [企业性质],组织信息.[Tradecode] AS [经济行业代码],组织信息.[ID] AS [系统主键],组织信息.[UpdateVersion] AS [修改版本],组织信息.[Createby] AS [创建者],组织信息.[CreateOn] AS [创建时间],组织信息.[Updateby] AS [修改者],组织信息.[UpdateOn] AS [修改时间],组织信息.[ApproveBy] AS [审核者],组织信息.[ApproveOn] AS [审核时间] FROM GB_Corp 组织信息 WITH(NOLOCK)  LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 组织信息.City = [城市_城市表].CityCode LEFT JOIN Pub_Province [生产地址所在省份_省份] WITH(NOLOCK) ON 组织信息.ProductProvince = [生产地址所在省份_省份].ProvinceCode LEFT JOIN Pub_City [生产地址所在城市_城市表] WITH(NOLOCK) ON 组织信息.ProductCity = [生产地址所在城市_城市表].CityCode LEFT JOIN Pub_Area [生产地址所在地区_所在地区] WITH(NOLOCK) ON 组织信息.ProductArea = [生产地址所在地区_所在地区].AreaCode LEFT JOIN Pub_CurrencyType [注册资本币种_币种] WITH(NOLOCK) ON 组织信息.CapitalCurrType = [注册资本币种_币种].CurrencyCode LEFT JOIN Pub_Code [开票类型_代码表] WITH(NOLOCK) ON 组织信息.InvoiceType = [开票类型_代码表].CodeID LEFT JOIN Pub_Code [组织运作状况_代码表] WITH(NOLOCK) ON 组织信息.CorpStatus = [组织运作状况_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 组织信息.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 组织信息.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 组织信息.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_CorpType [企业性质_企业类型] WITH(NOLOCK) ON 组织信息.CorpType = [企业性质_企业类型].Code where 组织信息.id=''

2026-03-19 19:58:23 执行时长：6.47秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id

2026-03-19 19:58:23 执行时长：7.31秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and  1=1  and PlanSendDate<=@endDate 

2026-03-19 19:58:31 执行时长：6.13秒 sql:select BizEntityID +  '_'+ DataColumnID , bizdefaultvalue  from Base_BizColumn a left join Base_BizData b on a.BizDataID=b.ID  where bizdefaultvalue<>''

2026-03-19 19:58:37 执行时长：6.38秒 sql:select CurrencyName from Pub_CurrencyType  WITH(NOLOCK) WHERE CurrencyCode='人民币'

2026-03-19 19:58:47 执行时长：9.82秒 sql:select CurrencyCode from Pub_CurrencyType  WITH(NOLOCK) WHERE CurrencyName='人民币'

2026-03-19 19:58:58 执行时长：9.35秒 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.ID=@id

2026-03-19 19:59:01 执行时长：10.5秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-19 19:59:06 执行时长：5.05秒 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 19:59:19 执行时长：5.37秒 sql:SELECT id from Base_BizColumnCustom a  where bizentityid=@BizEntityID and  userid=@userID

2026-03-19 19:59:37 执行时长：7.06秒 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 19:59:39 执行时长：32.1秒 sql:select a.*,dataentityname,dataentitycode from base_bizdata a inner join base_bizentity b on a.bizentityid=b.id  inner join base_dataentity c on a.dataentityid=c.id  where (isprimary=1 or b.bizclass=0) and a.dataentityid='001002' order by isprimary desc,b.id asc 

2026-03-19 19:59:40 执行时长：17.04秒 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 19:59:43 执行时长：6.26秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='020006' and datacolumnid='001589'

2026-03-19 19:59:48 执行时长：7.79秒 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 19:59:49 执行时长：6.33秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='020006' and datacolumnid='001584'

2026-03-19 19:59:57 执行时长：5.46秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U'

2026-03-19 19:59:58 执行时长：7.62秒 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'