2025-08-22 09:03:53 执行时长：5.17秒 sql:select * from GB_ProjectPlan  WITH(NOLOCK) where id='507002325'

2025-08-22 09:03:59 执行时长：5.55秒 sql:select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类  from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID   left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode   left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode   left join Pub_Province e on a.Province=e.ProvinceCode   left join Base_Org f on a.Org=f.OrgID   left join Pub_Code g on a.WorkType=g.CodeID  left join  GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-08-22' and IsEffective='27'   left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode   left join Pub_ProfessionalCode j on i.professionalcode=j.id   where 1=1  and a.AuditorCode in (SELECT AuditorCode  FROM GB_AuditorRegister  WHERE StandardCode IN('57','58','72') and IsEffective = '27'  GROUP BY AuditorCode  HAVING COUNT(DISTINCT StandardCode) >= 3)  and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join   Base_OrgV b on a.OrgID=b.Org where P_orgID='23') or a.ispublic=1 ) and a.auditorcode in  (  SELECT auditorcode  FROM GB_AuditorProfessional a left join Pub_ProfessionalCode b on a.ProfessionalCode=b.id  WHERE b.ProfessionalCode IN( '17.06.01'  ,'17.12.03' ) and b.FieldCode='E'  GROUP BY auditorcode  HAVING COUNT(DISTINCT b.ProfessionalCode) >= 2) and a.auditorcode in  (  SELECT auditorcode  FROM GB_AuditorProfessional a left join Pub_ProfessionalCode b on a.ProfessionalCode=b.id  WHERE b.ProfessionalCode IN( '17.06.01'  ,'17.12.03' ) and b.FieldCode='Q'  GROUP BY auditorcode  HAVING COUNT(DISTINCT b.ProfessionalCode) >= 2) and a.auditorcode in  (  SELECT auditorcode  FROM GB_AuditorProfessional a left join Pub_ProfessionalCode b on a.ProfessionalCode=b.id  WHERE b.ProfessionalCode IN( '17.06.01'  ,'17.12.03' ) and b.FieldCode='O'  GROUP BY auditorcode  HAVING COUNT(DISTINCT b.ProfessionalCode) >= 2)  group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName,  a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount

2025-08-22 09:03:59 执行时长：5.62秒 sql:INSERT INTO Base_Log(id,username,logdate,modulename,operatetype,remark,ipaddress) values  ('eb3594c607e1c87c', @userName,@logDate,@moduleName,@OperateType,@remark,@ip )

2025-08-22 09:41:58 执行时长：9.03秒 sql:exec [GB_AuditorSchedule] '','','','','','','','','ISC-418501'