Time: 0.01631498336792 -- 25-12-29 07:39:21 -- /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.0034029483795166 -- 25-12-29 07:39:21 -- /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.003838062286377 -- 25-12-29 07:39:21 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='FeiLiShiWuLiuKeFuZhuYan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035791397094727 -- 25-12-29 07:39:21[朱燕-1279] -- /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= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01829195022583 -- 25-12-29 07:39:22[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042669773101807 -- 25-12-29 07:39:22[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046110153198242 -- 25-12-29 07:39:22[朱燕-1279] -- /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 = 1279 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011191844940186 -- 25-12-29 07:39:22[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044131278991699 -- 25-12-29 07:39:22[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045950412750244 -- 25-12-29 07:39:22[朱燕-1279] -- /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 = 1279 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017110824584961 -- 25-12-29 07:39:24[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086359977722168 -- 25-12-29 07:39:24[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 1279 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047369003295898 -- 25-12-29 07:39:24[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015597820281982 -- 25-12-29 08:35:33 -- /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.017419099807739 -- 25-12-29 08:35:33 -- /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.0040290355682373 -- 25-12-29 08:35:33 -- /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.0040559768676758 -- 25-12-29 08:35:33 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuZhanRu' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038988590240479 -- 25-12-29 08:35:33[吴展如-1710] -- /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= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016963005065918 -- 25-12-29 08:35:33[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036740303039551 -- 25-12-29 08:35:33[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003756046295166 -- 25-12-29 08:35:33[吴展如-1710] -- /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 = 1710 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089230537414551 -- 25-12-29 08:35:33[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036520957946777 -- 25-12-29 08:35:33[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037410259246826 -- 25-12-29 08:35:33[吴展如-1710] -- /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 = 1710 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020346879959106 -- 25-12-29 08:35:34[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088400840759277 -- 25-12-29 08:35:34[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 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 = 7951 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01900315284729 -- 25-12-29 08:35:52[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040929317474365 -- 25-12-29 08:35:52[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040450096130371 -- 25-12-29 08:35:52[吴展如-1710] -- /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 = 1710 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037431716918945 -- 25-12-29 08:35:52[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00400710105896 -- 25-12-29 08:35:52[吴展如-1710] -- /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 = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040249824523926 -- 25-12-29 08:35:52[吴展如-1710] -- /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 = 1710 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017410039901733 -- 25-12-29 08:35:54[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005465030670166 -- 25-12-29 08:35:54[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 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 = 7951 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 25-12-29 08:35:54[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017819881439209 -- 25-12-29 09:21:33[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039398670196533 -- 25-12-29 09:21:33[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039088726043701 -- 25-12-29 09:21:33[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010276079177856 -- 25-12-29 09:21:33[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039308071136475 -- 25-12-29 09:21:33[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039761066436768 -- 25-12-29 09:21:33[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019264936447144 -- 25-12-29 11:25:39[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?wxMenu_id=1&event=edit_quit&quit_id=324¶={%22event%22:%22edit_quit%22,%22quit_id%22:%22324%22} 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 = 324 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 25-12-29 11:25:39[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?wxMenu_id=1&event=edit_quit&quit_id=324¶={%22event%22:%22edit_quit%22,%22quit_id%22:%22324%22} select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019076108932495 -- 25-12-29 11:38:21[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?wxMenu_id=1&event=edit_quit&quit_id=324¶={%22event%22:%22edit_quit%22,%22quit_id%22:%22324%22} 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 = 324 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034542083740234 -- 25-12-29 11:38:21[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?wxMenu_id=1&event=edit_quit&quit_id=324¶={%22event%22:%22edit_quit%22,%22quit_id%22:%22324%22} select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016531944274902 -- 25-12-29 11:38:27[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036869049072266 -- 25-12-29 11:38:27[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036578178405762 -- 25-12-29 11:38:27[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041811466217041 -- 25-12-29 11:38:27[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035331249237061 -- 25-12-29 11:38:27[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036020278930664 -- 25-12-29 11:38:27[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028461933135986 -- 25-12-29 11:38:30[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name FROM dbsys.`sys_contact` c LEFT JOIN dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 2303 and c.`cont_name`=e.employee_name limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039129257202148 -- 25-12-29 11:38:30[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02665901184082 -- 25-12-29 11:38:50[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015779972076416 -- 25-12-29 11:39:08[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016708850860596 -- 25-12-29 11:39:34[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016907930374146 -- 25-12-29 11:39:45[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038020610809326 -- 25-12-29 11:39:45[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037310123443604 -- 25-12-29 11:39:45[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003741979598999 -- 25-12-29 11:39:45[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036280155181885 -- 25-12-29 11:39:45[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003709077835083 -- 25-12-29 11:39:45[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021279096603394 -- 25-12-29 11:39:47[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 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 = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016611814498901 -- 25-12-29 11:39:54[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 25-12-29 11:39:54[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035791397094727 -- 25-12-29 11:39:54[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035967826843262 -- 25-12-29 11:39:54[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003587007522583 -- 25-12-29 11:39:54[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035490989685059 -- 25-12-29 11:39:54[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017781019210815 -- 25-12-29 11:39:55[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 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 = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019855976104736 -- 25-12-29 11:39:56[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024858951568604 -- 25-12-29 11:40:09[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036768913269043 -- 25-12-29 11:40:09[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036909580230713 -- 25-12-29 11:40:09[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-12-29 11:40:09[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033478736877441 -- 25-12-29 11:40:09[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003687858581543 -- 25-12-29 11:40:09[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01782488822937 -- 25-12-29 11:40:10[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 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 = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032069683074951 -- 25-12-29 11:40:10[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016499042510986 -- 25-12-29 11:41:55[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035860538482666 -- 25-12-29 11:41:55[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035829544067383 -- 25-12-29 11:41:55[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036160945892334 -- 25-12-29 11:41:55[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032610893249512 -- 25-12-29 11:41:55[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035579204559326 -- 25-12-29 11:41:55[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017094135284424 -- 25-12-29 11:41:56[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 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 = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031468868255615 -- 25-12-29 11:41:56[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016698122024536 -- 25-12-29 11:47:25[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-12-29 11:47:25[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036489963531494 -- 25-12-29 11:47:25[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033860206604004 -- 25-12-29 11:47:25[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036499500274658 -- 25-12-29 11:47:25[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035970211029053 -- 25-12-29 11:47:25[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017802953720093 -- 25-12-29 11:47:26[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 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 = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035021305084229 -- 25-12-29 11:47:26[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017133951187134 -- 25-12-29 13:26:26[陈梓豪-660] -- /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 = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038042068481445 -- 25-12-29 13:26:26[陈梓豪-660] -- /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 = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037758350372314 -- 25-12-29 13:26:26[陈梓豪-660] -- /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 = 660 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048189163208008 -- 25-12-29 13:26:26[陈梓豪-660] -- /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 = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003741979598999 -- 25-12-29 13:26:26[陈梓豪-660] -- /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 = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038740634918213 -- 25-12-29 13:26:26[陈梓豪-660] -- /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 = 660 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01583194732666 -- 25-12-29 14:48:39[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022221088409424 -- 25-12-29 14:48:41[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7945 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7945 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031387805938721 -- 25-12-29 14:48:41[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7945 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016012907028198 -- 25-12-29 14:48:48[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7945 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027337074279785 -- 25-12-29 14:48:48[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01847505569458 -- 25-12-29 14:48:49[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7804 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7804 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032589435577393 -- 25-12-29 14:48:49[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7804 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016640186309814 -- 25-12-29 14:49:12[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016939878463745 -- 25-12-29 14:49:13[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7804 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7804 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003101110458374 -- 25-12-29 14:49:13[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7804 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016459941864014 -- 25-12-29 14:49:14[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7804 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017374038696289 -- 25-12-29 14:49:14[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021586894989014 -- 25-12-29 14:49:15[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7800 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7800 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003248929977417 -- 25-12-29 14:49:15[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023373126983643 -- 25-12-29 14:49:17[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015909194946289 -- 25-12-29 14:49:18[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027087926864624 -- 25-12-29 14:49:18[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7799 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7799 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031499862670898 -- 25-12-29 14:49:18[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7799 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020621776580811 -- 25-12-29 14:49:21[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7799 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016304969787598 -- 25-12-29 14:49:21[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024854898452759 -- 25-12-29 14:49:22[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=289 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 25-12-29 14:49:22[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01758885383606 -- 25-12-29 14:49:28[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016090869903564 -- 25-12-29 14:49:30[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031118392944336 -- 25-12-29 14:49:30[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027860164642334 -- 25-12-29 14:49:34[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029371976852417 -- 25-12-29 14:49:34[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=285 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 285 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032839775085449 -- 25-12-29 14:49:34[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=285 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01688289642334 -- 25-12-29 14:49:37[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016695976257324 -- 25-12-29 14:49:37[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=289 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032098293304443 -- 25-12-29 14:49:37[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016458988189697 -- 25-12-29 14:49:40[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017268896102905 -- 25-12-29 14:49:41[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 25-12-29 14:49:41[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016144990921021 -- 25-12-29 14:49:55[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026440143585205 -- 25-12-29 14:49:56[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030388832092285 -- 25-12-29 14:49:56[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016330003738403 -- 25-12-29 14:49:59[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023041009902954 -- 25-12-29 14:50:02[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017454147338867 -- 25-12-29 14:50:03[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 25-12-29 14:50:03[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01661205291748 -- 25-12-29 14:50:07[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017647981643677 -- 25-12-29 14:50:08[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=285 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 285 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031688213348389 -- 25-12-29 14:50:08[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=285 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016465902328491 -- 25-12-29 14:50:09[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028754949569702 -- 25-12-29 15:07:17[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227953%22}&event=&offwork_id=7953 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7953 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 25-12-29 15:07:17[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227953%22}&event=&offwork_id=7953 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016389131546021 -- 25-12-29 15:07:26[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7953 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016708850860596 -- 25-12-29 15:07:27[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227953%22}&event=&offwork_id=7953 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7953 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029771327972412 -- 25-12-29 15:07:27[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227953%22}&event=&offwork_id=7953 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01866602897644 -- 25-12-29 15:07:31[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227815%22}&event=&offwork_id=7815 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7815 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033400058746338 -- 25-12-29 15:07:31[黄亮-456] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227815%22}&event=&offwork_id=7815 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016196966171265 -- 25-12-29 15:34:45[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017561912536621 -- 25-12-29 15:34:46[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7953 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7953 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00307297706604 -- 25-12-29 15:34:46[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7953 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031515836715698 -- 25-12-29 15:34:48[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22295%22}&event=&recruitApply_id=295 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 295 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032320022583008 -- 25-12-29 15:34:48[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22295%22}&event=&recruitApply_id=295 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 708 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016525030136108 -- 25-12-29 15:34:52[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22295%22}&event=&recruitApply_id=295 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 295 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032269954681396 -- 25-12-29 15:34:52[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22295%22}&event=&recruitApply_id=295 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 708 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017706155776978 -- 25-12-29 15:34:54[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22296%22}&event=&recruitApply_id=296 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003342866897583 -- 25-12-29 15:34:54[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22296%22}&event=&recruitApply_id=296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 708 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017256021499634 -- 25-12-29 15:34:55[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22296%22}&event=&recruitApply_id=296 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033469200134277 -- 25-12-29 15:34:55[熊亚娜-708] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22296%22}&event=&recruitApply_id=296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 708 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016020059585571 -- 25-12-29 15:35:00[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7953 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017319917678833 -- 25-12-29 15:35:00[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022845983505249 -- 25-12-29 15:35:02[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?recruitApply_id=296 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034430027008057 -- 25-12-29 15:35:02[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?recruitApply_id=296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015339851379395 -- 25-12-29 15:35:06[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016597032546997 -- 25-12-29 15:35:07[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?recruitApply_id=295 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 295 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030989646911621 -- 25-12-29 15:35:07[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?recruitApply_id=295 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017344951629639 -- 25-12-29 15:35:12[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018704175949097 -- 25-12-29 15:38:23 -- /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.0036079883575439 -- 25-12-29 15:38:23 -- /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.0045201778411865 -- 25-12-29 15:38:23 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='YiChengAn' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038578510284424 -- 25-12-29 15:38:23[易承安-2303] -- /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.017719984054565 -- 25-12-29 15:38:26[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040771961212158 -- 25-12-29 15:38:26[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040898323059082 -- 25-12-29 15:38:26[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039570331573486 -- 25-12-29 15:38:26[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004047155380249 -- 25-12-29 15:38:26[易承安-2303] -- /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 = 2303 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039031505584717 -- 25-12-29 15:38:26[易承安-2303] -- /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 = 2303 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017858982086182 -- 25-12-29 15:38:27[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 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 = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032260417938232 -- 25-12-29 15:38:27[易承安-2303] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=326 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2303 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016816139221191 -- 25-12-29 16:36:46[肖飞飞-477] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01826286315918 -- 25-12-29 16:36:47[肖飞飞-477] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7935 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7935 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032110214233398 -- 25-12-29 16:36:47[肖飞飞-477] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7935 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017293930053711 -- 25-12-29 16:36:48[肖飞飞-477] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7935 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020473957061768 -- 25-12-29 16:36:49[肖飞飞-477] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017276048660278 -- 25-12-29 16:48:55 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015780925750732 -- 25-12-29 16:48:56[张进-414] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019834041595459 -- 25-12-29 16:48:57[张进-414] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7949 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, 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 ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 7949 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035619735717773 -- 25-12-29 16:48:57[张进-414] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7949 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021915912628174 -- 25-12-29 16:48:58[张进-414] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7949 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016323089599609 -- 25-12-29 16:48:59[张进-414] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020891904830933 -- 25-12-29 16:48:59[张进-414] -- /buz/hr/index.php/hrmgmt/hr_quit?quit_id=326 SELECT q.*,e.employee_name,org.org_name department,job.job_name,e.employee_no,9 appr_type_id, DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time, DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e ON q.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON e.job_id = job.job_id LEFT JOIN dbsys.sys_org org ON e.department_id = org.org_id WHERE q.quit_id = 326 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033500194549561 -- 25-12-29 16:48:59[张进-414] -- /buz/hr/index.php/hrmgmt/hr_quit?quit_id=326 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022375106811523 -- 25-12-29 16:49:03[张进-414] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017287015914917 -- 25-12-29 19:42:13 -- /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.01730489730835 -- 25-12-29 19:42:13 -- /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.0035700798034668 -- 25-12-29 19:42:13 -- /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.0040421485900879 -- 25-12-29 19:42:13 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoRong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037989616394043 -- 25-12-29 19:42:13[高蓉-498] -- /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= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016511917114258 -- 25-12-29 19:42:15[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 25-12-29 19:42:15[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036571025848389 -- 25-12-29 19:42:15[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004763126373291 -- 25-12-29 19:42:15[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036020278930664 -- 25-12-29 19:42:15[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036389827728271 -- 25-12-29 19:42:15[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017350912094116 -- 25-12-29 19:42:17[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043609142303467 -- 25-12-29 19:42:17[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 498 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039608478546143 -- 25-12-29 19:42:17[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020786046981812 -- 25-12-29 19:42:30[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017499923706055 -- 25-12-29 19:42:39[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003709077835083 -- 25-12-29 19:42:39[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036880970001221 -- 25-12-29 19:42:39[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039968490600586 -- 25-12-29 19:42:39[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036709308624268 -- 25-12-29 19:42:39[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036470890045166 -- 25-12-29 19:42:39[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016190052032471 -- 25-12-29 19:42:40[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7954 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048129558563232 -- 25-12-29 19:42:40[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7954 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 = 7954 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003148078918457 -- 25-12-29 19:42:40[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7954 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027176856994629 -- 25-12-29 19:42:42[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037548542022705 -- 25-12-29 19:42:42[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037531852722168 -- 25-12-29 19:42:42[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040459632873535 -- 25-12-29 19:42:42[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037131309509277 -- 25-12-29 19:42:42[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037169456481934 -- 25-12-29 19:42:42[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015347957611084 -- 25-12-29 19:42:43[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7948 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049200057983398 -- 25-12-29 19:42:43[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7948 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 = 7948 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030081272125244 -- 25-12-29 19:42:43[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7948 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021054983139038 -- 25-12-29 19:42:45[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003572940826416 -- 25-12-29 19:42:45[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035779476165771 -- 25-12-29 19:42:45[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038800239562988 -- 25-12-29 19:42:45[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035450458526611 -- 25-12-29 19:42:45[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035011768341064 -- 25-12-29 19:42:45[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01701807975769 -- 25-12-29 21:26:52 -- /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.017274141311646 -- 25-12-29 21:26:55[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038399696350098 -- 25-12-29 21:26:55[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038049221038818 -- 25-12-29 21:26:55[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045790672302246 -- 25-12-29 21:26:55[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037322044372559 -- 25-12-29 21:26:55[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038049221038818 -- 25-12-29 21:26:55[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016848087310791 -- 25-12-29 21:26:57[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006072998046875 -- 25-12-29 21:26:57[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 2180 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041661262512207 -- 25-12-29 21:26:57[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016595840454102 -- 25-12-29 21:27:09[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2180 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017206907272339 -- 25-12-29 21:27:17[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037760734558105 -- 25-12-29 21:27:17[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003734827041626 -- 25-12-29 21:27:17[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039689540863037 -- 25-12-29 21:27:17[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 25-12-29 21:27:17[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00370192527771 -- 25-12-29 21:27:17[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------