2025-11-19 17:12:34 执行时长：7.87秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'218451-2025-Q-Q') delete from  GB_CertiDoc where ProjectNo = N'218451-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'218451-2025-Q-Q-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'218451-2025-Q-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_AuditProblem where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_AuditProblem where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_InvalidDoc where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_AuditorContactRecord where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_AuditProblem where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_AuditorContactRecord where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanCombine where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c') delete from  GB_ProjectPlanTeam where TaskNo = N'097e1ec9dea2451cbe07fc87e57dbf9c' DELETE FROM GB_ProjectPlan WHERE ID='511001524' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511001524' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511001524' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511001524' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511001524') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511001524' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511001524') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511001524'

2025-11-19 17:12:43 执行时长：9.05秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'218451-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'218451-2025-Q-Q') delete from  GB_CertiDoc where ProjectNo = N'218451-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'218451-2025-Q-Q-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'218451-2025-Q-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_AuditProblem where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_AuditProblem where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_InvalidDoc where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_AuditorContactRecord where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_AuditProblem where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_AuditorContactRecord where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanCombine where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd') delete from  GB_ProjectPlanTeam where TaskNo = N'a32ee57937dc4e8f97225384118591dd' DELETE FROM GB_ProjectPlan WHERE ID='511001523' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511001523' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511001523' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511001523' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511001523') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511001523' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511001523') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511001523'

2025-11-19 17:14:41 执行时长：5.81秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-11-19 17:19:54 执行时长：6.48秒 sql:exec [GB_AuditorSchedule] '2025-11-01','','','','','','123','0.5','ISC0063'

2025-11-19 17:28:35 执行时长：8.58秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-11-19 17:31:23 执行时长：8.21秒 sql:exec GB_PartnerBizStatistics '2025','ISCSCB'

2025-11-19 17:33:00 执行时长：6.33秒 sql:exec GB_PartnerBizStatistics '2025','ISCSCB'