2025-12-10 14:31:40 执行时长：5.66秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ([证书状态_证书状态].[StatusName] like ''%有效%'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ([证书状态_证书状态].[StatusName] like ''%有效%'')'

2025-12-10 14:33:40 执行时长：5.19秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','123','0.5','ISC[S]0044'

2025-12-10 14:34:45 执行时长：13.33秒 sql:exec [GB_AuditorSchedule] '2025-12-01','','','','','','122','0.5','ISC[S]0044'