Time: 0.031771898269653 -- 26-01-24 10:07:46[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052869319915771 -- 26-01-24 10:07:46[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054628849029541 -- 26-01-24 10:07:46[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066919326782227 -- 26-01-24 10:07:46[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051760673522949 -- 26-01-24 10:07:46[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063240528106689 -- 26-01-24 10:07:46[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024873018264771 -- 26-01-24 10:07:47[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 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 = 328 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040769577026367 -- 26-01-24 10:07:47[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1790 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022257089614868 -- 26-01-24 10:43:16[陈梓豪-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.0043721199035645 -- 26-01-24 10:43:16[陈梓豪-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.0043129920959473 -- 26-01-24 10:43:16[陈梓豪-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.016265153884888 -- 26-01-24 10:43:16[陈梓豪-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.0042788982391357 -- 26-01-24 10:43:16[陈梓豪-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.0042550563812256 -- 26-01-24 10:43:16[陈梓豪-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.019051074981689 -- 26-01-24 10:43:19[陈梓豪-660] -- /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 = '14' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052831172943115 -- 26-01-24 10:43:19[陈梓豪-660] -- /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 = 14 AND c.cont_id = 660 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046091079711914 -- 26-01-24 10:43:19[陈梓豪-660] -- /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 = 184 and acct_id = 14 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017673015594482 -- 26-01-24 10:44:49[陈梓豪-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.0034711360931396 -- 26-01-24 10:44:49[陈梓豪-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.0034739971160889 -- 26-01-24 10:44:49[陈梓豪-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.0038719177246094 -- 26-01-24 10:44:49[陈梓豪-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.0034458637237549 -- 26-01-24 10:44:49[陈梓豪-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.0034289360046387 -- 26-01-24 10:44:49[陈梓豪-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.015841960906982 -- 26-01-24 10:44:54[陈梓豪-660] -- /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 = '14' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038621425628662 -- 26-01-24 10:44:54[陈梓豪-660] -- /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 = 14 AND c.cont_id = 660 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036711692810059 -- 26-01-24 10:44:54[陈梓豪-660] -- /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 = 184 and acct_id = 14 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018543004989624 -- 26-01-24 10:46:02[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 660 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017368793487549 -- 26-01-24 10:46:23[陈梓豪-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.0037598609924316 -- 26-01-24 10:46:23[陈梓豪-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.0037791728973389 -- 26-01-24 10:46:23[陈梓豪-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.0040161609649658 -- 26-01-24 10:46:23[陈梓豪-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.0037710666656494 -- 26-01-24 10:46:23[陈梓豪-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.0037291049957275 -- 26-01-24 10:46:23[陈梓豪-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.025211095809937 -- 26-01-24 10:46:25[陈梓豪-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.0037579536437988 -- 26-01-24 10:46:25[陈梓豪-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.0037610530853271 -- 26-01-24 10:46:25[陈梓豪-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.0037460327148438 -- 26-01-24 10:46:25[陈梓豪-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.0037310123443604 -- 26-01-24 10:46:25[陈梓豪-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.003741979598999 -- 26-01-24 10:46:25[陈梓豪-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.01988697052002 -- 26-01-24 10:46:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8103 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '14' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049669742584229 -- 26-01-24 10:46:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8103 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 = 8103 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-24 10:46:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8103 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 660 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028784990310669 -- 26-01-24 12:38:49[吴凌刚-279] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021876096725464 -- 26-01-24 15:38:57[郭荣波-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.021628141403198 -- 26-01-24 18:01: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.0042519569396973 -- 26-01-24 18:01: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.0047879219055176 -- 26-01-24 18:01: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='LiJinXuan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044529438018799 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027371168136597 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040779113769531 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040218830108643 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039949417114258 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040380954742432 -- 26-01-24 18:01:33[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018734931945801 -- 26-01-24 18:01:35[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 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 = 328 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033659934997559 -- 26-01-24 18:01:35[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1790 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020340919494629 -- 26-01-24 19:00:32[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 SELECT c.*,date_format(c.createdon,'%Y-%m-%d') apply_date, date_format(c.new_work_date,'%Y-%m-%d') new_work_date,date_format(c.old_work_date,'%Y-%m-%d') old_work_date, date_format(c.last_adjsalary_date,'%Y-%m-%d') last_adjsalary_date,date_format(c.effective_date,'%Y-%m-%d') effective_date, e.employee_name,o_j.job_name old_job,n_j.job_name new_job,o_d.org_name old_department,n_d.org_name new_department, c.old_sum_pay,c.before_last_sum_pay,cb.cont_name createdby,ub.cont_name updatedby,apr.appr_proc_name FROM dbhr.hr_change c left join dbhr.hr_employee e on c.employee_id = e.employee_id left join dbhr.hr_job o_j on c.old_job_id = o_j.job_id left join dbhr.hr_job n_j on c.new_job_id = n_j.job_id left join dbsys.sys_org o_d on c.old_department_id = o_d.org_id left join dbsys.sys_org n_d on c.new_department_id = n_d.org_id left join dbsys.sys_contact cb on c.createdby_id = cb.cont_id left join dbsys.sys_contact ub on c.updatedby_id = ub.cont_id left join dboa.oa_appr_process apr on c.appr_proc_id = apr.appr_proc_id where change_id = 123 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035839080810547 -- 26-01-24 19:00:32[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027807950973511 -- 26-01-24 19:00:44[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 SELECT c.*,date_format(c.createdon,'%Y-%m-%d') apply_date, date_format(c.new_work_date,'%Y-%m-%d') new_work_date,date_format(c.old_work_date,'%Y-%m-%d') old_work_date, date_format(c.last_adjsalary_date,'%Y-%m-%d') last_adjsalary_date,date_format(c.effective_date,'%Y-%m-%d') effective_date, e.employee_name,o_j.job_name old_job,n_j.job_name new_job,o_d.org_name old_department,n_d.org_name new_department, c.old_sum_pay,c.before_last_sum_pay,cb.cont_name createdby,ub.cont_name updatedby,apr.appr_proc_name FROM dbhr.hr_change c left join dbhr.hr_employee e on c.employee_id = e.employee_id left join dbhr.hr_job o_j on c.old_job_id = o_j.job_id left join dbhr.hr_job n_j on c.new_job_id = n_j.job_id left join dbsys.sys_org o_d on c.old_department_id = o_d.org_id left join dbsys.sys_org n_d on c.new_department_id = n_d.org_id left join dbsys.sys_contact cb on c.createdby_id = cb.cont_id left join dbsys.sys_contact ub on c.updatedby_id = ub.cont_id left join dboa.oa_appr_process apr on c.appr_proc_id = apr.appr_proc_id where change_id = 123 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034050941467285 -- 26-01-24 19:00:44[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019102096557617 -- 26-01-24 19:01:28[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038609504699707 -- 26-01-24 19:01:28[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037548542022705 -- 26-01-24 19:01:28[史登学-278] -- /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 = 278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051710605621338 -- 26-01-24 19:01:28[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038270950317383 -- 26-01-24 19:01:28[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038549900054932 -- 26-01-24 19:01:28[史登学-278] -- /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 = 278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01841402053833 -- 26-01-24 19:01:29[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 SELECT c.*,date_format(c.createdon,'%Y-%m-%d') apply_date, date_format(c.new_work_date,'%Y-%m-%d') new_work_date,date_format(c.old_work_date,'%Y-%m-%d') old_work_date, date_format(c.last_adjsalary_date,'%Y-%m-%d') last_adjsalary_date,date_format(c.effective_date,'%Y-%m-%d') effective_date, e.employee_name,o_j.job_name old_job,n_j.job_name new_job,o_d.org_name old_department,n_d.org_name new_department, c.old_sum_pay,c.before_last_sum_pay,cb.cont_name createdby,ub.cont_name updatedby,apr.appr_proc_name FROM dbhr.hr_change c left join dbhr.hr_employee e on c.employee_id = e.employee_id left join dbhr.hr_job o_j on c.old_job_id = o_j.job_id left join dbhr.hr_job n_j on c.new_job_id = n_j.job_id left join dbsys.sys_org o_d on c.old_department_id = o_d.org_id left join dbsys.sys_org n_d on c.new_department_id = n_d.org_id left join dbsys.sys_contact cb on c.createdby_id = cb.cont_id left join dbsys.sys_contact ub on c.updatedby_id = ub.cont_id left join dboa.oa_appr_process apr on c.appr_proc_id = apr.appr_proc_id where change_id = 123 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035779476165771 -- 26-01-24 19:01:29[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019038915634155 -- 26-01-24 19:01:57[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040960311889648 -- 26-01-24 19:01:57[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004086971282959 -- 26-01-24 19:01:57[史登学-278] -- /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 = 278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046820640563965 -- 26-01-24 19:01:57[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040547847747803 -- 26-01-24 19:01:57[史登学-278] -- /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 = 278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004033088684082 -- 26-01-24 19:01:57[史登学-278] -- /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 = 278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024805068969727 -- 26-01-24 19:01:58[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 SELECT c.*,date_format(c.createdon,'%Y-%m-%d') apply_date, date_format(c.new_work_date,'%Y-%m-%d') new_work_date,date_format(c.old_work_date,'%Y-%m-%d') old_work_date, date_format(c.last_adjsalary_date,'%Y-%m-%d') last_adjsalary_date,date_format(c.effective_date,'%Y-%m-%d') effective_date, e.employee_name,o_j.job_name old_job,n_j.job_name new_job,o_d.org_name old_department,n_d.org_name new_department, c.old_sum_pay,c.before_last_sum_pay,cb.cont_name createdby,ub.cont_name updatedby,apr.appr_proc_name FROM dbhr.hr_change c left join dbhr.hr_employee e on c.employee_id = e.employee_id left join dbhr.hr_job o_j on c.old_job_id = o_j.job_id left join dbhr.hr_job n_j on c.new_job_id = n_j.job_id left join dbsys.sys_org o_d on c.old_department_id = o_d.org_id left join dbsys.sys_org n_d on c.new_department_id = n_d.org_id left join dbsys.sys_contact cb on c.createdby_id = cb.cont_id left join dbsys.sys_contact ub on c.updatedby_id = ub.cont_id left join dboa.oa_appr_process apr on c.appr_proc_id = apr.appr_proc_id where change_id = 123 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034739971160889 -- 26-01-24 19:01:58[史登学-278] -- /buz/hr/index.php/hrmgmt/hr_change?para={%22event%22:%22edit_change%22,%22change_id%22:%22123%22}&event=edit_change&change_id=123 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020153999328613 -- 26-01-24 21:06:11[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043540000915527 -- 26-01-24 21:06:11[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042829513549805 -- 26-01-24 21:06:11[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043771266937256 -- 26-01-24 21:06:11[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043220520019531 -- 26-01-24 21:06:11[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042469501495361 -- 26-01-24 21:06:11[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021075010299683 -- 26-01-24 21:06:12[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 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 = 328 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035481452941895 -- 26-01-24 21:06:12[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1790 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02798318862915 -- 26-01-24 21:06:16[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042929649353027 -- 26-01-24 21:06:16[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042738914489746 -- 26-01-24 21:06:16[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043041706085205 -- 26-01-24 21:06:16[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042929649353027 -- 26-01-24 21:06:16[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004256010055542 -- 26-01-24 21:06:16[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018209934234619 -- 26-01-24 21:06:23[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039229393005371 -- 26-01-24 21:06:23[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038919448852539 -- 26-01-24 21:06:23[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038762092590332 -- 26-01-24 21:06:23[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039138793945312 -- 26-01-24 21:06:23[李瑾萱-1790] -- /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 = 1790 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038690567016602 -- 26-01-24 21:06:23[李瑾萱-1790] -- /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 = 1790 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021047115325928 -- 26-01-24 21:06:24[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 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 = 328 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041439533233643 -- 26-01-24 21:06:24[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1790 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024675846099854 -- 26-01-24 21:06:32[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22edit_quit%22,%22quit_id%22:%22327%22}&event=edit_quit&quit_id=327 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 = 327 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004288911819458 -- 26-01-24 21:06:32[李瑾萱-1790] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22edit_quit%22,%22quit_id%22:%22327%22}&event=edit_quit&quit_id=327 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1790 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------