2025-08-26 15:30:00 执行时长：5.37秒 sql:exec GB_PartnerBizStatistics '2025','ISC[S]0044'

2025-08-26 15:33:35 执行时长：9.46秒 sql:SELECT 受理及评审文档.ID as [~ID~] ,[申请单号_认证申请].ApplyNo AS [申请单号_Value],case when [申请单号_认证申请].ApplyNo is not null then [申请单号_认证申请].ApplyNo else cast(受理及评审文档.[ApplyNo] as varchar(200)) end  AS [申请单号],[组织名称_组织信息].CorpID AS [组织名称_Value],case when [组织名称_组织信息].CorpName is not null then [组织名称_组织信息].CorpName else cast(受理及评审文档.[Corp] as varchar(200)) end  AS [组织名称],受理及评审文档.[SerialNo] AS [文档序号],[文档类型_受理及评审文档类型].ClassCode AS [文档类型_Value],case when [文档类型_受理及评审文档类型].DocumentType is not null then [文档类型_受理及评审文档类型].DocumentType else cast(受理及评审文档.[DocumentType] as varchar(200)) end  AS [文档类型],(case 受理及评审文档.[IsMust] when 1 then '√' else '' end) AS [必须上传],受理及评审文档.[FileName] AS [文件名称],[上传人_用户].UserID AS [上传人_Value],case when [上传人_用户].UserName is not null then [上传人_用户].UserName else cast(受理及评审文档.[UploadBy] as varchar(200)) end  AS [上传人],受理及评审文档.[UploadOn] AS [上传时间],(case 受理及评审文档.[NotAddPackage] when 1 then '√' else '' end) AS [不加入文件包] FROM GB_CertiApplyApproveDoc 受理及评审文档 WITH(NOLOCK)  LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 受理及评审文档.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 受理及评审文档.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ProjectDocType [文档类型_受理及评审文档类型] WITH(NOLOCK) ON 受理及评审文档.DocumentType = [文档类型_受理及评审文档类型].ClassCode LEFT JOIN Base_User [上传人_用户] WITH(NOLOCK) ON 受理及评审文档.UploadBy = [上传人_用户].UserID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 受理及评审文档.ApproveClass = [审核类别_审核类别].ClassCode WHERE [受理及评审文档].ApplyNo='11550' order by [受理及评审文档].[SerialNo] ASC