2025-07-09 16:22:47 执行时长：5.96秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-07-09 16:22:54 执行时长：8.23秒 sql:select datatype,DataColumnName,DateFormat from Base_DataColumn where DataType in (3,1) and SysColumn=0 and dataentityid='003001' 2025-07-09 16:23:02 执行时长：9.06秒 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 left join base_dataentity e on a.dataentityid=e.id where e.dataentityname = '证书信息' and a.formula like '%{证书信息}.[[]组织名称]%' order by a.displayno 2025-07-09 16:23:12 执行时长：6.25秒 sql:select year('2025-07-09') 2025-07-09 16:23:23 执行时长：10.79秒 sql:select month('2025-07-09') 2025-07-09 16:23:23 执行时长：21.1秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-07-09 16:23:24 执行时长：19.39秒 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 2025-07-09 16:23:25 执行时长：22.18秒 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 left join base_dataentity e on a.dataentityid=e.id where e.dataentityname = '证书信息' and a.rsfilter like '%.[[]组织名称]%' 2025-07-09 16:23:26 执行时长：11.4秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.id=@id 2025-07-09 16:23:32 执行时长：8.81秒 sql:select day('2025-07-09') 2025-07-09 16:23:32 执行时长：8.29秒 sql:select * from Base_MessageServerPara WITH(NOLOCK) 2025-07-09 16:23:32 执行时长：8.66秒 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='0055' and b.datacolumncode<>'' order by ordernumber 2025-07-09 16:23:36 执行时长：43.48秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:23:39 执行时长：7.31秒 sql:select datediff(yy,'2025-07-10','2025-07-09') 2025-07-09 16:23:41 执行时长：7.82秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and 1=1 and PlanSendDate<=@endDate 2025-07-09 16:23:50 执行时长：13.29秒 sql:select * from base_syspara order by paragroup 2025-07-09 16:23:51 执行时长：62.3秒 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 [合同来源],[审核方式_审核方式].ApproveMode AS [审核方式],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] 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] <> ''变更'') AND (( [计划状态_计划状态].[StatusName] = ''已安排'') and (([合同来源_合同来源].[OrgName] like ''%市场部%'') and [审核计划].BeginDate>=''2025-07-09 00:00'' and [审核计划].BeginDate<=''2025-07-18 23:59'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo 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] <> ''变更'') AND (( [计划状态_计划状态].[StatusName] = ''已安排'') and (([合同来源_合同来源].[OrgName] like ''%市场部%'') and [审核计划].BeginDate>=''2025-07-09 00:00'' and [审核计划].BeginDate<=''2025-07-18 23:59''))' 2025-07-09 16:23:54 执行时长：14.63秒 sql:select year('2025-07-10') 2025-07-09 16:23:57 执行时长：10.07秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-07-09 16:23:59 执行时长：19.3秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:24:00 执行时长：9.36秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:24:02 执行时长：35.72秒 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 2025-07-09 16:24:03 执行时长：9.24秒 sql:select month('2025-07-10') 2025-07-09 16:24:03 执行时长：12.35秒 sql:SELECT MAX(ID) FROM GB_ProjectPlan WHERE id>='507000000' and id<='507999999' and len(id)>=9 2025-07-09 16:24:05 执行时长：39.73秒 sql:SELECT distinct 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 left join base_dataentity e on a.dataentityid=e.id left join base_DataColumnCodeRule f on a.id=f.datacolumnid where e.dataentityname = '证书信息' and (f.segvalue = '组织名称' or f.segvalue like '组织名称.%') 2025-07-09 16:24:05 执行时长：6.29秒 sql:select * from base_syspara order by paragroup 2025-07-09 16:24:06 执行时长：8.7秒 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 left join base_dataentity e on a.dataentityid=e.id where e.dataentityname = '组织信息' and a.formula like '%{组织信息}.[[]组织名称]%' order by a.displayno 2025-07-09 16:24:06 执行时长：5.7秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:24:08 执行时长：41.74秒 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 2025-07-09 16:24:12 执行时长：6.58秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:24:18 执行时长：6.97秒 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-07-09 16:24:11' 2025-07-09 16:24:20 执行时长：7.78秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-07-09 16:24:20 执行时长：42.26秒 sql:select count(*) from ( 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 [合同来源],[审核方式_审核方式].ApproveMode AS [审核方式],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] 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] <> '变更') AND (( [计划状态_计划状态].[StatusName] = '已安排') and ([审核计划].BeginDate>='2025-07-09 00:00' and [审核计划].BeginDate<='2025-07-18 23:59')) ) as CurrentCount 2025-07-09 16:24:20 执行时长：5.34秒 sql:select day('2025-07-11') 2025-07-09 16:24:21 执行时长：7.11秒 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-07-09 16:24:14' 2025-07-09 16:24:22 执行时长：8.02秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-07-09 16:24:28 执行时长：6.12秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:24:29 执行时长：11.75秒 sql:SELECT ID as [~ID~] ,[OrganizationName] AS [组织名称],[StandardCode] AS [标准代码],[CertiNo] AS [证书编号],[MainCerti] AS [主证书],[CertiClass] AS [证书类别],[CertifacateStatus] AS [证书状态],[FirstCertiDate] AS [初次获证日期],[RegiDate] AS [有效期起],[RegiToDate] AS [有效期至],[ChangeReason] AS [换证原因],[Org] AS [合同来源],[ChangeDate] AS [换证日期],[StandardName] AS [标准名称],[CorpID] AS [组织编号] FROM [GB_ProjectPlanCerti] AS [证书信息] WITH(NOLOCK) WHERE ProjectNo='10814-2025-EOEnMS-O' order by [证书信息].ID 2025-07-09 16:24:29 执行时长：7.2秒 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 2025-07-09 16:24:30 执行时长：5.48秒 sql:SELECT DataColumnCode FROM Base_DataColumn where id=@id 2025-07-09 16:24:33 执行时长：7.46秒 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 2025-07-09 16:24:40 执行时长：8.7秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:24:41 执行时长：7.29秒 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-07-09 16:24:33' 2025-07-09 16:24:43 执行时长：93.93秒 sql:select * from wf_Bizflowaction where id=@id 2025-07-09 16:24:44 执行时长：15.07秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.id=@id 2025-07-09 16:24:46 执行时长：12.54秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:24:47 执行时长：11.71秒 sql:SELECT DataColumnCode FROM Base_DataColumn where id=@id 2025-07-09 16:24:47 执行时长：17.08秒 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-07-09 16:24:30' 2025-07-09 16:24:48 执行时长：7.68秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:24:48 执行时长：5.46秒 sql:select roleid from wf_Bizflowactionrole where Bizflowactionid='0003' 2025-07-09 16:24:50 执行时长：5.47秒 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='008022' order by a.displayno,a.id 2025-07-09 16:24:50 执行时长：8.73秒 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-07-09 16:24:42' 2025-07-09 16:24:53 执行时长：5.25秒 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 2025-07-09 16:24:53 执行时长：5.47秒 sql:select id from sysObjects where id = object_id(N'Base_Trigger') and xtype = 'U' 2025-07-09 16:24:56 执行时长：8.69秒 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-07-09 16:24:47' 2025-07-09 16:24:56 执行时长：6.23秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove, relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,dataentitycode, notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull, displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.bizdataname FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where bizEntityID=@bizEntityID and isprimary=1 2025-07-09 16:24:56 执行时长：6.22秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:25:02 执行时长：33.98秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:25:02 执行时长：6.14秒 sql:select ProjectNo from GB_ProjectPlan WITH(NOLOCK) where ID='506002182' 2025-07-09 16:25:02 执行时长：11.78秒 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-07-09 16:25:02 执行时长：5.9秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:25:03 执行时长：9.57秒 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-07-09 16:24:53' 2025-07-09 16:25:04 执行时长：6.69秒 sql:select * from wf_Bizflowaction where id=@id 2025-07-09 16:25:05 执行时长：6.69秒 sql:SELECT * FROM Base_querysolution where QuerySolutionid=@id 2025-07-09 16:25:07 执行时长：5.07秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:25:07 执行时长：5.05秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:25:13 执行时长：6.13秒 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 2025-07-09 16:25:13 执行时长：26.26秒 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 2025-07-09 16:25:18 执行时长：6.25秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:25:20 执行时长：5.13秒 sql:select * from wf_Bizflowaction where id=@id 2025-07-09 16:25:23 执行时长：14.28秒 sql:SELECT ID as [~ID~] ,[Corp] AS [组织名称],[ApproveType] AS [审核类型],[FileName] AS [文件名称],[UploadBy] AS [上传人],[UploadOn] AS [上传时间],[CorpCanDownload] AS [企业可下载] FROM [GB_CertiDoc] AS [证书文件] WITH(NOLOCK) WHERE ProjectNo='10814-2025-EOEnMS-O' order by [证书文件].ID 2025-07-09 16:25:23 执行时长：70.98秒 sql:SELECT 审核计划.ID as [~ID~] ,审核计划.[BizAddress] AS [生产经营地址],审核计划.[CheckDate] AS [评审通过时间],审核计划.[AcceptDate] AS [受理日期],审核计划.[CertiQty] AS [体系人数],[评定状态_评定状态].StatusCode AS [评定状态_Value],[评定状态_评定状态].StatusName AS [评定状态],[批准结论_批准结论].ResultCode AS [批准结论_Value],[批准结论_批准结论].ResultName AS [批准结论],审核计划.[SuperNoticeDate] AS [监督通知时间],审核计划.[SuperCommitDate] AS [监督维护提交时间],[组织名称_组织信息].CorpID AS [组织名称_Value],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertificateUrgent] AS [证书加急],审核计划.[UrgentReason] AS [加急说明],审核计划.[IsReform] AS [已整改],审核计划.[ReformDate] AS [整改完成日期],[标准代码_认证标准].ID AS [标准代码_Value],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeCode AS [审核类型_Value],[审核类型_审核类型].TypeName AS [审核类型],[审核类别_审核类别].ClassCode AS [审核类别_Value],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[DecideOn] AS [认证决定日期],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],[认可标志_认可标志].RecogCode AS [认可标志_Value],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[SupportBy] AS [支持人员],[计划状态_计划状态].StatusCode AS [计划状态_Value],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[PlanNo] AS [计划编号],审核计划.[TaskNo] AS [任务编号],审核计划.[FollowUpTracking] AS [案卷后续跟踪],[跟踪结果_跟踪结果].StatusCode AS [跟踪结果_Value],[跟踪结果_跟踪结果].StatusName AS [跟踪结果],[阅卷人员_登录用户].UserID AS [阅卷人员_Value],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserID AS [评定人员_Value],[评定人员_登录用户].UserName AS [评定人员],审核计划.[DocReceiveBy] AS [档案受理人],审核计划.[ScopeOfEvaluation] AS [评定范围],[项目分级_案卷质量].LevelCode AS [项目分级_Value],[项目分级_案卷质量].LevelName AS [项目分级],[组长分级_案卷质量].LevelCode AS [组长分级_Value],[组长分级_案卷质量].LevelName AS [组长分级],[案卷质量_案卷质量].LevelCode AS [案卷质量_Value],[案卷质量_案卷质量].LevelName AS [案卷质量],审核计划.[ProfessionalEvaluation] AS [评定专业],[申请单号_认证申请].ApplyNo AS [申请单号_Value],[申请单号_认证申请].ApplyNo AS [申请单号],[项目编号_认证项目].ProjectNo AS [项目编号_Value],[项目编号_认证项目].ProjectNo AS [项目编号],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].Org AS [合同来源_Value],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].ProvinceCode AS [省份_Value],[省份_省份].Province AS [省份],审核计划.[StandardName] AS [标准名称],[认证领域_认证领域].FieldCode AS [认证领域_Value],[认证领域_认证领域].FieldName AS [认证领域],审核计划.[FeeDate] AS [计费日期],审核计划.[ChangeInfo] AS [变更描述],审核计划.[SuperQty] AS [监督周期],审核计划.[ReviewRemarks] AS [审议备注],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[ApproveRange] AS [认证范围],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],[风险等级_代码表].CodeID AS [风险等级_Value],[风险等级_代码表].CodeName AS [风险等级],审核计划.[TotalDays] AS [现场总人日],审核计划.[ApproveDays] AS [审核天数],[审核方式_审核方式].ApproveModeCode AS [审核方式_Value],[审核方式_审核方式].ApproveMode AS [审核方式],审核计划.[ReportDate] AS [已上报日期],审核计划.[CertiFee] AS [证书费],审核计划.[IssuesToBeNoted] AS [审核需关注问题],审核计划.[PlanRemarks] AS [计划备注],审核计划.[ReturnDate] AS [退回日期],审核计划.[ReasonForReturn] AS [退回理由],审核计划.[DispatchBy] AS [审核派遣人],审核计划.[RetrivalDate] AS [分卷时间],审核计划.[DispatchDate] AS [派组日期],审核计划.[Approver] AS [审批人],审核计划.[ApproveDate] AS [审批日期],审核计划.[ReceiveDate] AS [接卷日期],审核计划.[DistributeOn] AS [分发评定老师时间],审核计划.[ReasonsForAuditFailure] AS [现场审核不通过理由],审核计划.[AcceptanceEvaluationTime] AS [受理评定时间],审核计划.[PlanCommitDate] AS [计划提交时间],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[ReviewDate] AS [阅卷完成时间],审核计划.[DocReturnDate] AS [审核员回卷时间],审核计划.[ReturnContractQty] AS [合同数量],审核计划.[ReturnDoc] AS [纸质案卷],审核计划.[ReturnContract] AS [纸质合同],审核计划.[ReturnApply] AS [认证申请],审核计划.[ReturnContractTransfer] AS [合同移交],审核计划.[DocReceiveRemark] AS [资料回收备注],审核计划.[ReturnReason] AS [退回原因],审核计划.[UnPassReason] AS [未通过原因],审核计划.[ProcessResult] AS [处理结果],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PauseNotice] AS [暂停通知],审核计划.[SuperNoticeSent] AS [监审通知],审核计划.[NextApproveType] AS [下次审核类型],审核计划.[NextApproveDate] AS [下次审核最迟日期],审核计划.[NextPlanCreated] AS [下次计划已生成],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[NonCompliantTerms] AS [本次审核部门及不符合条款],审核计划.[NextAuditAdvice] AS [下次审核部门建议],审核计划.[NextAuditFocus] AS [下次审核关注点],审核计划.[DocUploaded] AS [资料上传完成],审核计划.[PlanApproveDate] AS [预计审核日期],[联系结果_联系结果].ResultCode AS [联系结果_Value],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],审核计划.[ToSchedule] AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] AS [传计调信息],审核计划.[FromChangeNo] AS [来源变更单号],审核计划.[ReceiveDateI] AS [合同申请接收时间],[合同申请接收人_登录用户].UserID AS [合同申请接收人_Value],[合同申请接收人_登录用户].UserName AS [合同申请接收人],审核计划.[MoveDate] AS [移交时间],审核计划.[HandOverBy] AS [交接人],审核计划.[MailingInformation] AS [审核老师确认邮寄信息],审核计划.[HasPause] AS [已办暂停],审核计划.[ID] AS [系统主键],审核计划.[UpdateVersion] AS [修改版本],审核计划.[Createby] AS [创建者],审核计划.[CreateOn] AS [创建时间],审核计划.[Updateby] AS [修改者],审核计划.[UpdateOn] AS [修改时间],审核计划.[ApproveBy] AS [审核者],审核计划.[ApproveOn] AS [审核时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode 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 GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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 Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID where 审核计划.id='46570' 2025-07-09 16:25:28 执行时长：5.47秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:25:33 执行时长：10.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-07-09 16:25:37 执行时长：41.56秒 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-07-09 16:25:38 执行时长：6.34秒 sql:select * from wf_BizflowactionOperator where Bizflowactionid='0003' 2025-07-09 16:25:38 执行时长：5.15秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:25:39 执行时长：5.21秒 sql:select distinct orgid from View_OrgUser where p_orgid in (select orgid from base_usermanagingorg where datasecurity=1 and userid='ISC0042' ) 2025-07-09 16:25:40 执行时长：15.27秒 sql:SELECT DISTINCT 认证项目.ID as [~ID~] ,认证项目.[ProjectNo] AS [项目编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],认证项目.[CertiQty] AS [体系人数],认证项目.[ProfessionalCode] AS [专业代码],认证项目.[BasicDays] AS [基础人日],认证项目.[UnrecognizedProfession] AS [未认可专业],[风险等级_代码表].CodeName AS [风险等级],[认可标志_认可标志].RecogName AS [认可标志],认证项目.[ReCertiQty] AS [再认证次数],认证项目.[TotalDays] AS [现场总人日],认证项目.[FixedMultiLocation] AS [固定多场所数],认证项目.[TempMultiLocation] AS [临时多场所数],[一阶段实施类型_代码表].CodeName AS [一阶段实施类型],认证项目.[ApproveRange] AS [评审范围],[认证领域_认证领域].FieldName AS [认证领域],[审核类别说明_代码表].CodeName AS [审核类别说明] FROM GB_CertificationProject 认证项目 WITH(NOLOCK) LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 认证项目.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 认证项目.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 认证项目.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 认证项目.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_Code [一阶段实施类型_代码表] WITH(NOLOCK) ON 认证项目.FirstClass = [一阶段实施类型_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 认证项目.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证项目.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证项目.Org = [合同来源_合同来源].Org LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 认证项目.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [审核类别说明_代码表] WITH(NOLOCK) ON 认证项目.ExplanationOfAuditCategory = [审核类别说明_代码表].CodeID WHERE [认证项目].ApplyNo='2025070105' order by [认证项目].ID 2025-07-09 16:25:46 执行时长：6.83秒 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='003001' 2025-07-09 16:25:47 执行时长：5.59秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:25:50 执行时长：89.66秒 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 [合同来源],[审核方式_审核方式].ApproveMode AS [审核方式],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] 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] <> ''变更'') AND (( [计划状态_计划状态].[StatusName] = ''已安排'') and ([审核计划].BeginDate>=''2025-07-09 00:00'' and [审核计划].BeginDate<=''2025-07-18 23:59'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo 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] <> ''变更'') AND (( [计划状态_计划状态].[StatusName] = ''已安排'') and ([审核计划].BeginDate>=''2025-07-09 00:00'' and [审核计划].BeginDate<=''2025-07-18 23:59''))' 2025-07-09 16:25:52 执行时长：6.63秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:25:53 执行时长：6.13秒 sql:SELECT DataColumnCode FROM Base_DataColumn where id=@id 2025-07-09 16:25:53 执行时长：6.55秒 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='001031034' order by a.displayno,a.id 2025-07-09 16:25:58 执行时长：7.33秒 sql:select owner,viewer from wf_workflow a left join wf_workflowright b on a.id=b.workflowid where bizentityid=@bizEntityID and roleid='05' 2025-07-09 16:25:58 执行时长：5.18秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:25:58 执行时长：12.26秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:25:58 执行时长：6.55秒 sql:select * from base_syspara order by paragroup 2025-07-09 16:25:59 执行时长：6.52秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id 2025-07-09 16:25:59 执行时长：5.7秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-07-09 16:26:02 执行时长：13.86秒 sql:select a.*,b.dataentityname,c.datacolumnname from wf_BizflowactionRight a left join base_dataentity b on a.dataentityid=b.id left join base_datacolumn c on a.datacolumnid=c.id where bizflowactionid='0003' 2025-07-09 16:26:03 执行时长：5.99秒 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 2025-07-09 16:26:06 执行时长：7.99秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:26:07 执行时长：6.78秒 sql:select [评定状态].[StatusCode] as [代码],[评定状态].[StatusName] as [名称] FROM Pub_AssessStatus 评定状态 WITH(NOLOCK) where 1=1 2025-07-09 16:26:09 执行时长：8.75秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:26:10 执行时长：6.36秒 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 2025-07-09 16:26:12 执行时长：5.92秒 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 2025-07-09 16:26:12 执行时长：6.08秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-07-09 16:26:13 执行时长：9.52秒 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-07-09 16:26:03' 2025-07-09 16:26:14 执行时长：6.22秒 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 2025-07-09 16:26:14 执行时长：7.59秒 sql:select * from wf_bizflowinstancedetail WITH(NOLOCK) where bizflowinstanceid='507000109ISC0019' and bizflowactionstate=1 2025-07-09 16:26:16 执行时长：6.5秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:26:16 执行时长：7.2秒 sql:select * from Base_BizentityCustom where BizEntityID='003001' and UserID='' and propertyname='ListWithSubData' 2025-07-09 16:26:16 执行时长：6.82秒 sql:select owner,viewer from wf_Bizflowaction a left join wf_Bizflowright b on a.Bizflowid=b.Bizflowid where bizentityid=@bizEntityID and roleid=@roleid 2025-07-09 16:26:18 执行时长：9.32秒 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 2025-07-09 16:26:21 执行时长：9.58秒 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-07-09 16:26:12' 2025-07-09 16:26:23 执行时长：6.9秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:26:23 执行时长：6.7秒 sql:SELECT id from Base_BizColumnCustom a where bizentityid=@BizEntityID and userid=@userID 2025-07-09 16:26:24 执行时长：14.19秒 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-07-09 16:26:10' 2025-07-09 16:26:26 执行时长：12.75秒 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-07-09 16:26:14' 2025-07-09 16:26:27 执行时长：7.76秒 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-07-09 16:26:20' 2025-07-09 16:26:29 执行时长：6.18秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id 2025-07-09 16:26:30 执行时长：5.42秒 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 2025-07-09 16:26:32 执行时长：10.86秒 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 2025-07-09 16:26:35 执行时长：8.54秒 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='003001' order by a.displayno,a.id 2025-07-09 16:26:36 执行时长：8.55秒 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-07-09 16:26:27' 2025-07-09 16:26:36 执行时长：5.44秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:26:37 执行时长：6.34秒 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 2025-07-09 16:26:38 执行时长：11.46秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect,c.bizdataname 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='0328' and b.datacolumncode<>'' order by ordernumber 2025-07-09 16:26:38 执行时长：7.77秒 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-07-09 16:26:31' 2025-07-09 16:26:40 执行时长：5.96秒 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-07-09 16:26:41 执行时长：8.25秒 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 2025-07-09 16:26:42 执行时长：55.53秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.bizentityid=@bizEntityID order by a.orderno,a.id 2025-07-09 16:26:43 执行时长：7.89秒 sql:SELECT 认证申请.ID as [~ID~] ,认证申请.[ID] AS [系统主键],认证申请.[UpdateVersion] AS [修改版本],认证申请.[Createby] AS [创建者],认证申请.[CreateOn] AS [创建时间],认证申请.[Updateby] AS [修改者],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者],认证申请.[ApproveOn] AS [审核时间],认证申请.[ApplyNo] AS [申请单号],[申请人_登录用户].UserName AS [申请人],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[SystemRunningTime] AS [体系运行时间],认证申请.[ManualVersion] AS [手册版本],认证申请.[ProjectLeader] AS [项目负责人],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaCodes] AS [标准代码],认证申请.[TempContractNo] AS [临时合同编号],认证申请.[FirstApproveDate] AS [一阶段审核预期],认证申请.[SendApproveDate] AS [二阶段审核预期],认证申请.[EconomicIndustry] AS [经济行业],认证申请.[StaffQty] AS [组织人数],认证申请.[TotalFee] AS [管理费合计],认证申请.[CertiFee] AS [认证费],认证申请.[SupervisionFee] AS [监督费],认证申请.[Remark] AS [备注],认证申请.[OrgCode] AS [统一信用代码],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[Contactor] AS [联系人],[项目状态_项目状态].Name AS [项目状态],认证申请.[ContractNo] AS [合同编号],认证申请.[Mobile] AS [手机],认证申请.[OtherPartner] AS [合作方],认证申请.[SupportPersonnel] AS [支持人员],认证申请.[CheckDate] AS [评审通过时间],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[BackReason] AS [合评问题记录] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID where 认证申请.id='505000193ISC0019' 2025-07-09 16:26:43 执行时长：6.33秒 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-07-09 16:26:37' 2025-07-09 16:26:44 执行时长：7.62秒 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-07-09 16:26:45 执行时长：21.94秒 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 2025-07-09 16:26:45 执行时长：7.11秒 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-07-09 16:26:38' 2025-07-09 16:26:48 执行时长：7.05秒 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 2025-07-09 16:26:49 执行时长：5.52秒 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-07-09 16:26:43' 2025-07-09 16:26:54 执行时长：7.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='003001' order by a.displayno,a.id 2025-07-09 16:26:56 执行时长：10.92秒 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-07-09 16:26:57 执行时长：8.28秒 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-07-09 16:27:02 执行时长：7.73秒 sql:SELECT 认证申请.ID as [~ID~] ,认证申请.[ID] AS [系统主键],认证申请.[UpdateVersion] AS [修改版本],认证申请.[Createby] AS [创建者],认证申请.[CreateOn] AS [创建时间],认证申请.[Updateby] AS [修改者],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者],认证申请.[ApproveOn] AS [审核时间],认证申请.[ApplyNo] AS [申请单号],[申请人_登录用户].UserName AS [申请人],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[SystemRunningTime] AS [体系运行时间],认证申请.[ManualVersion] AS [手册版本],认证申请.[ProjectLeader] AS [项目负责人],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaCodes] AS [标准代码],认证申请.[TempContractNo] AS [临时合同编号],认证申请.[FirstApproveDate] AS [一阶段审核预期],认证申请.[SendApproveDate] AS [二阶段审核预期],认证申请.[EconomicIndustry] AS [经济行业],认证申请.[StaffQty] AS [组织人数],认证申请.[TotalFee] AS [管理费合计],认证申请.[CertiFee] AS [认证费],认证申请.[SupervisionFee] AS [监督费],认证申请.[Remark] AS [备注],认证申请.[OrgCode] AS [统一信用代码],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[Contactor] AS [联系人],[项目状态_项目状态].Name AS [项目状态],认证申请.[ContractNo] AS [合同编号],认证申请.[Mobile] AS [手机],认证申请.[OtherPartner] AS [合作方],认证申请.[SupportPersonnel] AS [支持人员],认证申请.[CheckDate] AS [评审通过时间],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[BackReason] AS [合评问题记录] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID where 认证申请.id='505000193ISC0019' 2025-07-09 16:27:06 执行时长：17.84秒 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 2025-07-09 16:27:08 执行时长：7.06秒 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-07-09 16:27:01' 2025-07-09 16:27:10 执行时长：7.75秒 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='003000' 2025-07-09 16:27:10 执行时长：10.18秒 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 2025-07-09 16:27:13 执行时长：6.92秒 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-07-09 16:27:06' 2025-07-09 16:27:14 执行时长：36.06秒 sql:SELECT DISTINCT 组织信息文档.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[申请单号_认证申请].ApplyNo AS [申请单号],组织信息文档.[SerialNo] AS [文档序号],[文档类型_组织信息文档类型].Name AS [文档类型],(case 组织信息文档.[IsMust] when 1 then '√' else '' end) AS [必须上传],组织信息文档.[FileName] AS [文件名称],[上传人_用户].UserName AS [上传人],组织信息文档.[UploadOn] AS [上传时间],(case 组织信息文档.[NotAddPackage] when 1 then '√' else '' end) AS [不加入文件包] FROM GB_CertiApplyCorpDoc 组织信息文档 WITH(NOLOCK) LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 组织信息文档.Corp = [组织名称_组织信息].CorpID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 组织信息文档.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_OrgDocType [文档类型_组织信息文档类型] WITH(NOLOCK) ON 组织信息文档.DocumentType = [文档类型_组织信息文档类型].Code LEFT JOIN Base_User [上传人_用户] WITH(NOLOCK) ON 组织信息文档.UploadBy = [上传人_用户].UserID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 组织信息文档.ApproveClass = [审核类别_审核类别].ClassCode WHERE [组织信息文档].Corp='5103' order by [组织信息文档].[SerialNo] ASC 2025-07-09 16:27:15 执行时长：36.62秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-07-09 16:27:17 执行时长：6.68秒 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 2025-07-09 16:27:20 执行时长：7.77秒 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-07-09 16:27:13' 2025-07-09 16:27:25 执行时长：7.44秒 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-07-09 16:27:17' 2025-07-09 16:27:32 执行时长：7.51秒 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-07-09 16:27:25' 2025-07-09 16:27:33 执行时长：12.57秒 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-07-09 16:27:34 执行时长：7.92秒 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-07-09 16:27:26' 2025-07-09 16:27:35 执行时长：34.27秒 sql:select count(*) from ( SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[ApplyNo] AS [申请单号],[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[StaCodes] AS [标准代码],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[CheckDate] AS [评审通过时间],认证申请.[StaffQty] AS [组织人数],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID WHERE ([项目状态_项目状态].[Name] in ('已提交','已评审','已退回') 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 ='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' )) AND ([项目状态_项目状态].[Name] = '已提交' ) ) as CurrentCount 2025-07-09 16:27:36 执行时长：6.33秒 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-07-09 16:27:29' 2025-07-09 16:27:37 执行时长：11.61秒 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-07-09 16:27:25' 2025-07-09 16:27:43 执行时长：5.13秒 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 2025-07-09 16:27:44 执行时长：8.49秒 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-07-09 16:27:35' 2025-07-09 16:27:44 执行时长：11.44秒 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-07-09 16:27:44 执行时长：5.7秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:27:45 执行时长：5.46秒 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 2025-07-09 16:27:46 执行时长：6.19秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:27:46 执行时长：13.12秒 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-07-09 16:27:47 执行时长：6.79秒 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 2025-07-09 16:27:48 执行时长：21.65秒 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 2025-07-09 16:27:50 执行时长：5.71秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-07-09 16:27:51 执行时长：6.21秒 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 2025-07-09 16:27:53 执行时长：10.46秒 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 2025-07-09 16:27:54 执行时长：5.31秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:27:55 执行时长：7.55秒 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='003001' order by a.displayno,a.id 2025-07-09 16:27:56 执行时长：17.32秒 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 2025-07-09 16:27:56 执行时长：9秒 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-07-09 16:27:47' 2025-07-09 16:27:57 执行时长：6.61秒 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 2025-07-09 16:28:01 执行时长：12.25秒 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 2025-07-09 16:28:01 执行时长：5.67秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:01 执行时长：5.3秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id 2025-07-09 16:28:05 执行时长：18.38秒 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-07-09 16:28:06 执行时长：6.71秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:28:06 执行时长：5.16秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:07 执行时长：11.02秒 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='003013' order by a.displayno,a.id 2025-07-09 16:28:09 执行时长：15.91秒 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 2025-07-09 16:28:10 执行时长：10.89秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:11 执行时长：10.13秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.bizentityid=@bizEntityID order by a.orderno,a.id 2025-07-09 16:28:13 执行时长：55.72秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1 2025-07-09 16:28:15 执行时长：8.65秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:28:15 执行时长：17.94秒 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 2025-07-09 16:28:16 执行时长：5.5秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.id=@id 2025-07-09 16:28:16 执行时长：9.46秒 sql:SELECT DataEntityCode FROM Base_DataEntity where id=@id 2025-07-09 16:28:16 执行时长：19.69秒 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-07-09 16:27:56' 2025-07-09 16:28:17 执行时长：7.29秒 sql:SELECT * FROM Base_ExtendComponent WHERE BizEntityID=@bizEntityID 2025-07-09 16:28:17 执行时长：7.16秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:17 执行时长：5.2秒 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-07-09 16:28:12' 2025-07-09 16:28:18 执行时长：13.67秒 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-07-09 16:28:20 执行时长：8.03秒 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 2025-07-09 16:28:21 执行时长：7.98秒 sql:select * from Base_MessageServerPara WITH(NOLOCK) 2025-07-09 16:28:22 执行时长：7.24秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-07-09 16:28:25 执行时长：8.36秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-07-09 16:28:25 执行时长：7.9秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:33 执行时长：18.04秒 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-07-09 16:28:15' 2025-07-09 16:28:34 执行时长：16.85秒 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-07-09 16:28:17' 2025-07-09 16:28:37 执行时长：12.05秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-07-09 16:28:37 执行时长：12.04秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:41 执行时长：21.25秒 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 2025-07-09 16:28:43 执行时长：22.01秒 sql:SELECT top 100 * FROM MSG_MessageSend with(nolock) where MessageType =0 and 1=1 and PlanSendDate<=@endDate 2025-07-09 16:28:45 执行时长：22.77秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:28:49 执行时长：12.65秒 sql:SELECT DataColumnCode FROM Base_DataColumn where id=@id 2025-07-09 16:28:50 执行时长：12.66秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:28:54 执行时长：20.91秒 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-07-09 16:28:33' 2025-07-09 16:28:58 执行时长：13.32秒 sql:select * from base_syspara order by paragroup 2025-07-09 16:28:58 执行时长：8.66秒 sql:SELECT DataColumnCode FROM Base_DataColumn where id=@id 2025-07-09 16:29:03 执行时长：13.85秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:29:04 执行时长：29.68秒 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-07-09 16:29:05 执行时长：22.48秒 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-07-09 16:28:43' 2025-07-09 16:29:09 执行时长：24.06秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE a.username=@username 2025-07-09 16:29:10 执行时长：11.9秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID 2025-07-09 16:29:10 执行时长：27.14秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:29:11 执行时长：13.07秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id 2025-07-09 16:29:11 执行时长：7.86秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 2025-07-09 16:29:11 执行时长：94.2秒 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 2025-07-09 16:29:13 执行时长：7.05秒 sql:select id,orgname from base_org where orgid='0001' 2025-07-09 16:29:15 执行时长：96.98秒 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 2025-07-09 16:29:15 执行时长：20.61秒 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-07-09 16:29:15 执行时长：8.03秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:29:17 执行时长：5.14秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.bizentityid=@bizEntityID order by a.orderno,a.id 2025-07-09 16:29:18 执行时长：61.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-07-09 16:29:19 执行时长：62.32秒 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 2025-07-09 16:29:20 执行时长：11.12秒 sql:SELECT * FROM base_user a left join base_org b on a.orgid=b.orgid WHERE userid=@id 2025-07-09 16:29:20 执行时长：5.22秒 sql:SELECT DataColumnCode FROM Base_DataColumn where id=@id 2025-07-09 16:41:00 执行时长：6.73秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[IssuesToBeNoted] AS [审核需关注问题],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CertiInfo] 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org 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] <> ''变更'') AND ([组织名称_组织信息].[CorpName] like ''%邯郸市利瑞电动三轮车制造有限公司%'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org 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] <> ''变更'') AND ([组织名称_组织信息].[CorpName] like ''%邯郸市利瑞电动三轮车制造有限公司%'')' 2025-07-09 16:41:00 执行时长：6.34秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[AcceptDate] AS [受理日期],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] 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_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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] <> ''变更'' and ( [审核计划].org =''45'' )) AND ( ( [计划状态_计划状态].[StatusName] = ''待安排'') ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] 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_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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] <> ''变更'' and ( [审核计划].org =''45'' )) AND ( ( [计划状态_计划状态].[StatusName] = ''待安排'') )' 2025-07-09 16:41:31 执行时长：6.03秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] 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_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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org 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_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] <> ''变更'' and ( [审核计划].org =''25'' or [审核计划].org =''2501'' )) AND (([省份_省份].[Province] like ''%四川省%'') and [审核计划].[PlanStatus]=''03'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] 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_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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org 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_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] <> ''变更'' and ( [审核计划].org =''25'' or [审核计划].org =''2501'' )) AND (([省份_省份].[Province] like ''%四川省%'') and [审核计划].[PlanStatus]=''03'')' 2025-07-09 16:41:31 执行时长：5.46秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[StaffQty] AS [组织人数],认证申请.[AcceptDate] AS [受理日期],认证申请.[ApplyNo] AS [申请单号],认证申请.[ProjectLeader] AS [项目负责人],认证申请.[CheckDate] AS [评审通过时间],[项目状态_项目状态].Name AS [项目状态],认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID WHERE (( [认证申请].org =''25'' or [认证申请].org =''2501'' )) AND ([组织名称_组织信息].[CorpName] like ''%唐山圣尔雅职业服装有限公司%'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK) LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID WHERE (( [认证申请].org =''25'' or [认证申请].org =''2501'' )) AND ([组织名称_组织信息].[CorpName] like ''%唐山圣尔雅职业服装有限公司%'')'