Time: 0.017065048217773 -- 25-11-22 09:20:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033547878265381 -- 25-11-22 09:20:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003821849822998 -- 25-11-22 09:20:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiYaLi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035488605499268 -- 25-11-22 09:20:14[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016407012939453 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041320323944092 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047271251678467 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044331550598145 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038471221923828 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046830177307129 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030217885971069 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091021060943604 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034201145172119 -- 25-11-22 09:20:15[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2086 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017396211624146 -- 25-11-22 09:20:28[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037448406219482 -- 25-11-22 09:20:28[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00376296043396 -- 25-11-22 09:20:28[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037350654602051 -- 25-11-22 09:20:28[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037050247192383 -- 25-11-22 09:20:28[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 25-11-22 09:20:28[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019297122955322 -- 25-11-22 09:20:29[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038259029388428 -- 25-11-22 09:20:29[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037679672241211 -- 25-11-22 09:20:29[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2086 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019582986831665 -- 25-11-22 09:20:40[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22edit_quit%22,%22quit_id%22:%22320%22}&event=edit_quit&quit_id=320 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 320 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037209987640381 -- 25-11-22 09:20:40[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22edit_quit%22,%22quit_id%22:%22320%22}&event=edit_quit&quit_id=320 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2086 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018938064575195 -- 25-11-22 09:20:44[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227690%22}&event=edit_offwork&offwork_id=7690 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054290294647217 -- 25-11-22 09:20:44[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227690%22}&event=edit_offwork&offwork_id=7690 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7690 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035660266876221 -- 25-11-22 09:20:44[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227690%22}&event=edit_offwork&offwork_id=7690 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2086 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018216848373413 -- 25-11-22 09:21:24[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037250518798828 -- 25-11-22 09:21:24[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036799907684326 -- 25-11-22 09:21:24[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036728382110596 -- 25-11-22 09:21:24[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036358833312988 -- 25-11-22 09:21:24[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036430358886719 -- 25-11-22 09:21:24[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017333984375 -- 25-11-22 10:41:52[刘春明-305] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227487%22}&event=edit_offwork&offwork_id=7487 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063920021057129 -- 25-11-22 10:41:52[刘春明-305] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227487%22}&event=edit_offwork&offwork_id=7487 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033299922943115 -- 25-11-22 10:41:52[刘春明-305] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227487%22}&event=edit_offwork&offwork_id=7487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 305 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028815984725952 -- 25-11-22 10:43:41[刘春明-305] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227487%22}&event=edit_offwork&offwork_id=7487 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052781105041504 -- 25-11-22 10:43:41[刘春明-305] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227487%22}&event=edit_offwork&offwork_id=7487 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034630298614502 -- 25-11-22 10:43:41[刘春明-305] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227487%22}&event=edit_offwork&offwork_id=7487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 305 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022170066833496 -- 25-11-22 12:59:26[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048329830169678 -- 25-11-22 12:59:26[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047590732574463 -- 25-11-22 12:59:26[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047399997711182 -- 25-11-22 12:59:26[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047600269317627 -- 25-11-22 12:59:26[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047681331634521 -- 25-11-22 12:59:26[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021358013153076 -- 25-11-22 12:59:27[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059328079223633 -- 25-11-22 12:59:27[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041041374206543 -- 25-11-22 12:59:27[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2086 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01882791519165 -- 25-11-22 16:59:13[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041511058807373 -- 25-11-22 16:59:13[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040879249572754 -- 25-11-22 16:59:13[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004133939743042 -- 25-11-22 16:59:13[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004094123840332 -- 25-11-22 16:59:13[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2086 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040879249572754 -- 25-11-22 16:59:13[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2086 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021440982818604 -- 25-11-22 16:59:14[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062069892883301 -- 25-11-22 16:59:14[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041041374206543 -- 25-11-22 16:59:14[李雅丽-2086] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2086 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------