2025-09-18 09:17:34 执行时长：11.98秒 sql:EXEC dbo.p_show @QueryStr = N' select a.* from (SELECT DISTINCT 超时任务.ID as [~ID~] ,[任务名称_任务时长设置].TaskName AS [任务名称],[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],超时任务.[DocNo] AS [申请单号/计划编号],超时任务.[BeginDate] AS [任务开始日期],超时任务.[EndDate] AS [任务完成日期],超时任务.[OverTimes] AS [超时天数],(case 超时任务.[Finished] when 1 then ''√'' else '''' end) AS [已完成] FROM GB_OvertimesTask 超时任务 WITH(NOLOCK)  LEFT JOIN Pub_TaskTimes [任务名称_任务时长设置] WITH(NOLOCK) ON 超时任务.TaskName = [任务名称_任务时长设置].TaskCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 超时任务.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 超时任务.Org = [合同来源_合同来源].Org) a inner join (SELECT GB_OvertimesTask.ID FROM GB_OvertimesTask Left join Pub_TaskTimes on GB_OvertimesTask.TaskName=Pub_TaskTimes.TaskCode WHERE  1=1  and Pub_TaskTimes.TaskName = ''06-认证决定'') b  on a.[~ID~]=b.id  ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[任务完成日期] asc'

2025-09-18 09:18:57 执行时长：5.52秒 sql:exec [GB_AuditorSchedule] '2025-09-01','','','','','','123','0.5','ISC-418501'

2025-09-18 09:19:10 执行时长：19.64秒 sql:EXEC dbo.p_show @QueryStr = N' select a.* from (SELECT DISTINCT 超时任务.ID as [~ID~] ,[任务名称_任务时长设置].TaskName AS [任务名称],[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],超时任务.[DocNo] AS [申请单号/计划编号],超时任务.[BeginDate] AS [任务开始日期],超时任务.[EndDate] AS [任务完成日期],超时任务.[OverTimes] AS [超时天数],(case 超时任务.[Finished] when 1 then ''√'' else '''' end) AS [已完成] FROM GB_OvertimesTask 超时任务 WITH(NOLOCK)  LEFT JOIN Pub_TaskTimes [任务名称_任务时长设置] WITH(NOLOCK) ON 超时任务.TaskName = [任务名称_任务时长设置].TaskCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 超时任务.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 超时任务.Org = [合同来源_合同来源].Org) a inner join (SELECT GB_OvertimesTask.ID FROM GB_OvertimesTask Left join Pub_TaskTimes on GB_OvertimesTask.TaskName=Pub_TaskTimes.TaskCode WHERE  1=1  and Pub_TaskTimes.TaskName = ''06-认证决定'') b  on a.[~ID~]=b.id  ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[任务开始日期] asc'

2025-09-18 09:32:15 执行时长：5.89秒 sql:exec [GB_AuditorSchedule] '2025-09-01','','','','','','123','0.5','ISC0601'

2025-09-18 09:39:15 执行时长：13.52秒 sql:exec [GB_PartnerCertiStatistics]

2025-09-18 09:39:15 执行时长：13.81秒 sql:exec [GB_PartnerCertiStatistics]

2025-09-18 09:39:35 执行时长：6.7秒 sql:exec GB_PartnerBizStatistics '2025','ISC[S]0044'