2025-08-07 18:00:01 执行时长：6.46秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.touserid=b.userid where fromuserid=@userID and isactivity=1 and startdate<='2025-08-07 17:59:54' 2025-08-07 18:00:04 执行时长：5.29秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.fromuserid=b.userid where touserid=@userID and isactivity=1 and startdate<='2025-08-07 17:59:59' 2025-08-07 18:00:05 执行时长：21.92秒 sql: SELECT DISTINCT 审核计划.ID as ID FROM GB_ProjectPlan 审核计划 with(nolock) 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 datediff(day,'2025-08-07',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') and ( [审核计划].org ='25' or [审核计划].org ='2501' )) 2025-08-07 18:00:10 执行时长：8.84秒 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='004003' 2025-08-07 18:00:11 执行时长：9.58秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.fromuserid=b.userid where touserid=@userID and isactivity=1 and startdate<='2025-08-07 18:00:02' 2025-08-07 18:00:12 执行时长：8.47秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.touserid=b.userid where fromuserid=@userID and isactivity=1 and startdate<='2025-08-07 18:00:03' 2025-08-07 18:00:14 执行时长：8.56秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.touserid=b.userid where fromuserid=@userID and isactivity=1 and startdate<='2025-08-07 18:00:06' 2025-08-07 18:00:16 执行时长：7.17秒 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<='2025-08-07 18:00:08' 2025-08-07 18:00:16 执行时长：11.73秒 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 2025-08-07 18:00:17 执行时长：15.82秒 sql:select distinct a.id as id,alertname,condition,a.bizentityid as bizentityid,a.message from base_bizalert a left join base_roleright b on a.bizentityid=b.bizentityid left join base_userrole c on b.roleid=c.roleid where c.userid='liudajun' and (allowread=1 or allowadd=1 or allowedit=1 or allowdelete=1) 2025-08-07 18:00:17 执行时长：15.01秒 sql: SELECT DISTINCT 审核计划.ID as ID FROM GB_ProjectPlan 审核计划 with(nolock) 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 datediff(day,'2025-08-07',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') and ( [审核计划].org ='21' or [审核计划].org ='2101' or [审核计划].org ='2102' or [审核计划].org ='2103' )) 2025-08-07 18:00:19 执行时长：9.76秒 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='021008' order by a.displayno,a.id 2025-08-07 18:00:24 执行时长：7.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='008001' order by a.displayno,a.id 2025-08-07 18:00:25 执行时长：6.1秒 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 2025-08-07 18:00:25 执行时长：12.04秒 sql: SELECT DISTINCT 审核计划.ID as ID FROM GB_ProjectPlan 审核计划 with(nolock) 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 [审核计划].[PlanStatus]='11' and ([审核计划].[PlanStatus] > '10' AND [审核类别_审核类别].[ClassName] <> '一阶段' and ( [审核计划].org ='0001' or [审核计划].org ='01' or [审核计划].org ='02' or [审核计划].org ='03' or [审核计划].org ='04' or [审核计划].org ='05' or [审核计划].org ='20' or [审核计划].org ='21' or [审核计划].org ='2101' or [审核计划].org ='2102' or [审核计划].org ='2103' or [审核计划].org ='22' or [审核计划].org ='23' or [审核计划].org ='25' or [审核计划].org ='2501' or [审核计划].org ='26' or [审核计划].org ='27' or [审核计划].org ='29' or [审核计划].org ='30' or [审核计划].org ='301' or [审核计划].org ='302' or [审核计划].org ='303' or [审核计划].org ='304' or [审核计划].org ='305' or [审核计划].org ='306' or [审核计划].org ='307' or [审核计划].org ='308' or [审核计划].org ='309' or [审核计划].org ='31' or [审核计划].org ='310' or [审核计划].org ='311' or [审核计划].org ='312' or [审核计划].org ='313' or [审核计划].org ='315' or [审核计划].org ='316' or [审核计划].org ='32' or [审核计划].org ='40' or [审核计划].org ='41' or [审核计划].org ='42' or [审核计划].org ='43' or [审核计划].org ='4301' or [审核计划].org ='4302' or [审核计划].org ='4303' or [审核计划].org ='44' or [审核计划].org ='45' or [审核计划].org ='46' or [审核计划].org ='48' or [审核计划].org ='49' or [审核计划].org ='50' )) 2025-08-07 18:00:30 执行时长：5.13秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.fromuserid=b.userid where touserid=@userID and isactivity=1 and startdate<='2025-08-07 18:00:25' 2025-08-07 18:00:33 执行时长：6.54秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-08-07 18:00:34 执行时长：9.03秒 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='001031003' order by a.displayno,a.id 2025-08-07 18:00:35 执行时长：7.29秒 sql:select userid,username from base_roleaccredit a left join base_user b on a.fromuserid=b.userid where touserid=@userID and isactivity=1 and startdate<='2025-08-07 18:00:27' 2025-08-07 18:00:37 执行时长：10.19秒 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='001031003' order by a.displayno,a.id 2025-08-07 18:00:40 执行时长：9.74秒 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 2025-08-07 18:00:42 执行时长：7.82秒 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 2025-08-07 18:00:47 执行时长：8.12秒 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='001031031' order by a.displayno,a.id 2025-08-07 18:00:48 执行时长：7.69秒 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 2025-08-07 18:00:49 执行时长：5.98秒 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' 2025-08-07 18:00:49 执行时长：6.59秒 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 2025-08-07 18:00:52 执行时长：5.06秒 sql:SELECT distinct ShortcutNo,BizEntityName ,a.BizEntityID ,BizClass FROM Base_Shortcut a LEFT JOIN Base_BizEntity b ON a.BizEntity = b.ID WHERE(a.IsPrivate = 0 OR a.Createby = '杜杏') order by ShortcutNo 2025-08-07 18:02:39 执行时长：7.64秒 sql: SELECT DISTINCT 审核计划.ID as ID FROM GB_ProjectPlan 审核计划 with(nolock) 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 datediff(day,'2025-08-07',[审核计划].[SuperviseEndDate]) BETWEEN 1 AND 60 and exists(select id from GB_ProjectPlanCerti b where 审核计划.PlanNo=b.PlanNo and CertifacateStatus='01' ) and ([计划状态_计划状态].[StatusName] in ('待联系','退回') )