Time: 0.0095181465148926 -- 2026-06-22 01:40:21.820 -- /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.0018899440765381 -- 2026-06-22 01:40:21.823 -- /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.0028078556060791 -- 2026-06-22 01:40:21.827 -- /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='AiZaiXinZhong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020668506622314 -- 2026-06-22 01:40:21.829[石常发-629] -- /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.012830018997192 -- 2026-06-22 01:40:26.420[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042178630828857 -- 2026-06-22 01:40:26.425[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064730644226074 -- 2026-06-22 01:40:26.431[石常发-629] -- /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 = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016891002655029 -- 2026-06-22 01:40:26.448[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003432035446167 -- 2026-06-22 01:40:26.452[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044209957122803 -- 2026-06-22 01:40:26.456[石常发-629] -- /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 = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010807991027832 -- 2026-06-22 01:40:28.483[石常发-629] -- /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 = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079901218414307 -- 2026-06-22 01:40:28.492[石常发-629] -- /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 = 5 AND c.cont_id = 629 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049309730529785 -- 2026-06-22 01:40:28.497[石常发-629] -- /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 = 336 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091049671173096 -- 2026-06-22 01:41:19.082[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019681453704834 -- 2026-06-22 01:41:19.084[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019960403442383 -- 2026-06-22 01:41:19.086[石常发-629] -- /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 = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00205397605896 -- 2026-06-22 01:41:19.088[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019128322601318 -- 2026-06-22 01:41:19.090[石常发-629] -- /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 = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018839836120605 -- 2026-06-22 01:41:19.092[石常发-629] -- /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 = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014041900634766 -- 2026-06-22 09:55:46.495[张莉-1395] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22354%22}&event=&quit_id=354 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 = 354 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015418529510498 -- 2026-06-22 09:55:46.497[张莉-1395] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22354%22}&event=&quit_id=354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1395 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010470867156982 -- 2026-06-22 12:11:16.894[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 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 = 353 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003040075302124 -- 2026-06-22 12:11:16.898[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067172050476074 -- 2026-06-22 12:11:30.036[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 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 = 353 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012490749359131 -- 2026-06-22 12:11:30.038[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010804891586304 -- 2026-06-22 14:43:25.114[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 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 = 353 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013470649719238 -- 2026-06-22 14:43:25.116[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079400539398193 -- 2026-06-22 14:49:54.761 -- /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.0015809535980225 -- 2026-06-22 14:49:54.765 -- /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.0025131702423096 -- 2026-06-22 14:49:54.767 -- /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='ChenLingFei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017600059509277 -- 2026-06-22 14:49:54.769[陈灵飞-2368] -- /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.009268045425415 -- 2026-06-22 14:49:55.009 -- /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.010385036468506 -- 2026-06-22 14:49:55.166[陈灵飞-2368] -- /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 = 2368 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034041404724121 -- 2026-06-22 14:49:55.170[陈灵飞-2368] -- /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 = 2368 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040948390960693 -- 2026-06-22 14:49:55.174[陈灵飞-2368] -- /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 = 2368 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033478736877441 -- 2026-06-22 14:49:55.178[陈灵飞-2368] -- /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 = 2368 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026249885559082 -- 2026-06-22 14:49:55.181[陈灵飞-2368] -- /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 = 2368 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039091110229492 -- 2026-06-22 14:49:55.185[陈灵飞-2368] -- /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 = 2368 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011667966842651 -- 2026-06-22 14:49:56.703[陈灵飞-2368] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=354 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 = 354 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001723051071167 -- 2026-06-22 14:49:56.728[陈灵飞-2368] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2368 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018241882324219 -- 2026-06-22 15:44:36.251 -- /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.0016579627990723 -- 2026-06-22 15:44:36.255 -- /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.0022029876708984 -- 2026-06-22 15:44:36.257 -- /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='JiangHuaQiong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001924991607666 -- 2026-06-22 15:44:36.259[蒋华琼-649] -- /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= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01473593711853 -- 2026-06-22 15:44:36.597[蒋华琼-649] -- /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 = 649 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023651123046875 -- 2026-06-22 15:44:36.600[蒋华琼-649] -- /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 = 649 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023291110992432 -- 2026-06-22 15:44:36.602[蒋华琼-649] -- /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 = 649 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030028820037842 -- 2026-06-22 15:44:36.605[蒋华琼-649] -- /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 = 649 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023660659790039 -- 2026-06-22 15:44:36.608[蒋华琼-649] -- /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 = 649 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022931098937988 -- 2026-06-22 15:44:36.610[蒋华琼-649] -- /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 = 649 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090799331665039 -- 2026-06-22 17:01:55.802[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.047225952148438 -- 2026-06-22 17:02:10.893[关云-169] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 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 = 353 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019760131835938 -- 2026-06-22 17:02:10.896[关云-169] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22353%22}&event=&quit_id=353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018602132797241 -- 2026-06-22 17:38:58.143 -- /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.015419960021973 -- 2026-06-22 17:38:58.298 -- /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.0091629028320312 -- 2026-06-22 17:39:00.372[朱燕-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.0022768974304199 -- 2026-06-22 17:39:00.375[朱燕-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.00217604637146 -- 2026-06-22 17:39:00.377[朱燕-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.0027058124542236 -- 2026-06-22 17:39:00.380[朱燕-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.0021369457244873 -- 2026-06-22 17:39:00.382[朱燕-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.0021331310272217 -- 2026-06-22 17:39:00.384[朱燕-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.01204514503479 -- 2026-06-22 17:39:03.880[朱燕-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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002802848815918 -- 2026-06-22 17:39:03.883[朱燕-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.0023269653320312 -- 2026-06-22 17:39:03.886[朱燕-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.016016960144043 -- 2026-06-22 17:39:07.439[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021460056304932 -- 2026-06-22 17:39:09.884[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079848766326904 -- 2026-06-22 17:39:09.940[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071349143981934 -- 2026-06-22 17:39:09.995[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008882999420166 -- 2026-06-22 17:39:10.062[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081701278686523 -- 2026-06-22 17:39:10.250[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008821964263916 -- 2026-06-22 17:39:10.317[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096261501312256 -- 2026-06-22 17:39:10.993[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091519355773926 -- 2026-06-22 17:39:11.732[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086450576782227 -- 2026-06-22 17:39:11.790[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008774995803833 -- 2026-06-22 17:39:11.846[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079829692840576 -- 2026-06-22 17:39:12.052[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086531639099121 -- 2026-06-22 17:39:12.111[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087630748748779 -- 2026-06-22 17:39:12.178[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012835025787354 -- 2026-06-22 17:39:12.376[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086040496826172 -- 2026-06-22 17:39:12.434[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063769817352295 -- 2026-06-22 17:39:12.507[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095319747924805 -- 2026-06-22 17:39:12.753[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012126922607422 -- 2026-06-22 17:39:12.910[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078458786010742 -- 2026-06-22 17:39:13.351[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086269378662109 -- 2026-06-22 17:39:13.417[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081961154937744 -- 2026-06-22 17:39:13.590[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098950862884521 -- 2026-06-22 17:39:13.993[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014380931854248 -- 2026-06-22 17:39:55.745[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083930492401123 -- 2026-06-22 17:40:15.768[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099380016326904 -- 2026-06-22 17:42:02.868[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01500678062439 -- 2026-06-22 17:42:15.033[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021871089935303 -- 2026-06-22 17:42:22.842[朱燕-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.0021371841430664 -- 2026-06-22 17:42:22.844[朱燕-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.0020990371704102 -- 2026-06-22 17:42:22.846[朱燕-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.0020170211791992 -- 2026-06-22 17:42:22.848[朱燕-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.0020210742950439 -- 2026-06-22 17:42:22.850[朱燕-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.002028226852417 -- 2026-06-22 17:42:22.853[朱燕-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.0087227821350098 -- 2026-06-22 18:37:55.121 -- /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.0016300678253174 -- 2026-06-22 18:37:55.124 -- /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.0025320053100586 -- 2026-06-22 18:37:55.127 -- /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='ZhengJiaLin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019669532775879 -- 2026-06-22 18:37:55.129[郑嘉琳-2346] -- /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.010544061660767 -- 2026-06-22 18:37:55.539[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025019645690918 -- 2026-06-22 18:37:55.541[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024402141571045 -- 2026-06-22 18:37:55.544[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025448799133301 -- 2026-06-22 18:37:55.546[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002377986907959 -- 2026-06-22 18:37:55.549[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002392053604126 -- 2026-06-22 18:37:55.552[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014139890670776 -- 2026-06-22 18:37:58.436[郑嘉琳-2346] -- /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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028069019317627 -- 2026-06-22 18:37:58.439[郑嘉琳-2346] -- /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 = 2346 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023930072784424 -- 2026-06-22 18:37:58.441[郑嘉琳-2346] -- /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.0087900161743164 -- 2026-06-22 18:37:59.441[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011918067932129 -- 2026-06-22 18:38:00.819[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076391696929932 -- 2026-06-22 18:38:00.885[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009627103805542 -- 2026-06-22 18:38:01.042[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009774923324585 -- 2026-06-22 18:38:01.322[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094330310821533 -- 2026-06-22 18:38:01.656[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020668029785156 -- 2026-06-22 18:38:02.544[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085160732269287 -- 2026-06-22 18:38:02.612[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075359344482422 -- 2026-06-22 18:38:02.667[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089318752288818 -- 2026-06-22 18:38:02.901[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093750953674316 -- 2026-06-22 18:38:02.972[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090000629425049 -- 2026-06-22 18:38:03.216[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011003971099854 -- 2026-06-22 18:38:03.798[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087049007415771 -- 2026-06-22 18:38:14.585[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098659992218018 -- 2026-06-22 18:38:25.702[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022580623626709 -- 2026-06-22 18:38:25.705[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021421909332275 -- 2026-06-22 18:38:25.707[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022759437561035 -- 2026-06-22 18:38:25.710[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021097660064697 -- 2026-06-22 18:38:25.712[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021209716796875 -- 2026-06-22 18:38:25.714[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080718994140625 -- 2026-06-22 18:38:26.535[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034339427947998 -- 2026-06-22 18:38:26.539[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 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 = 8962 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001514196395874 -- 2026-06-22 18:38:26.541[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016747951507568 -- 2026-06-22 18:38:30.359[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020439624786377 -- 2026-06-22 18:38:30.361[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020060539245605 -- 2026-06-22 18:38:30.363[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021350383758545 -- 2026-06-22 18:38:30.366[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019538402557373 -- 2026-06-22 18:38:30.368[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019550323486328 -- 2026-06-22 18:38:30.370[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015733957290649 -- 2026-06-22 18:38:31.158[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015919208526611 -- 2026-06-22 18:38:31.160[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 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 = 8962 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001539945602417 -- 2026-06-22 18:38:31.162[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019976854324341 -- 2026-06-22 18:38:33.667[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018668174743652 -- 2026-06-22 18:38:33.669[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018179416656494 -- 2026-06-22 18:38:33.671[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019619464874268 -- 2026-06-22 18:38:33.673[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00177001953125 -- 2026-06-22 18:38:33.675[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001784086227417 -- 2026-06-22 18:38:33.677[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086338520050049 -- 2026-06-22 18:38:34.326[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 2026-06-22 18:38:34.329[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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 = 8973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016019344329834 -- 2026-06-22 18:38:34.331[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008059024810791 -- 2026-06-22 18:39:38.118[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016038417816162 -- 2026-06-22 18:39:38.120[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015869140625 -- 2026-06-22 18:39:38.122[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016989707946777 -- 2026-06-22 18:39:38.124[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001533031463623 -- 2026-06-22 18:39:38.125[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015521049499512 -- 2026-06-22 18:39:38.127[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018628835678101 -- 2026-06-22 18:39:41.244[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022540092468262 -- 2026-06-22 18:39:41.246[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022211074829102 -- 2026-06-22 18:39:41.249[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002324104309082 -- 2026-06-22 18:39:41.251[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021770000457764 -- 2026-06-22 18:39:41.253[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021510124206543 -- 2026-06-22 18:39:41.256[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087780952453613 -- 2026-06-22 18:39:42.544[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028021335601807 -- 2026-06-22 18:39:42.547[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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 = 8973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016250610351562 -- 2026-06-22 18:39:42.549[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009119987487793 -- 2026-06-22 18:39:47.399[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001838207244873 -- 2026-06-22 18:39:47.401[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018250942230225 -- 2026-06-22 18:39:47.403[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019400119781494 -- 2026-06-22 18:39:47.405[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017721652984619 -- 2026-06-22 18:39:47.407[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017709732055664 -- 2026-06-22 18:39:47.409[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092170238494873 -- 2026-06-22 18:39:49.695[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001802921295166 -- 2026-06-22 18:39:49.697[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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 = 8973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017199516296387 -- 2026-06-22 18:39:49.699[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017251014709473 -- 2026-06-22 18:39:56.984[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020530223846436 -- 2026-06-22 18:39:56.987[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020210742950439 -- 2026-06-22 18:39:56.989[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021510124206543 -- 2026-06-22 18:39:56.991[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019819736480713 -- 2026-06-22 18:39:56.993[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020139217376709 -- 2026-06-22 18:39:56.995[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090970993041992 -- 2026-06-22 18:39:57.556[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036070346832275 -- 2026-06-22 18:39:57.560[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 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 = 8962 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016779899597168 -- 2026-06-22 18:39:57.562[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8962 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018379926681519 -- 2026-06-22 18:39:58.865[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018241405487061 -- 2026-06-22 18:39:58.867[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017900466918945 -- 2026-06-22 18:39:58.869[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019168853759766 -- 2026-06-22 18:39:58.871[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017337799072266 -- 2026-06-22 18:39:58.873[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017600059509277 -- 2026-06-22 18:39:58.875[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089778900146484 -- 2026-06-22 18:39:59.221[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017509460449219 -- 2026-06-22 18:39:59.223[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 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 = 8973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016839504241943 -- 2026-06-22 18:39:59.225[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2346 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022307872772217 -- 2026-06-22 18:40:00.669[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022289752960205 -- 2026-06-22 18:40:00.671[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021460056304932 -- 2026-06-22 18:40:00.674[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019760131835938 -- 2026-06-22 18:40:00.676[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021328926086426 -- 2026-06-22 18:40:00.678[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021271705627441 -- 2026-06-22 18:40:00.680[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077660083770752 -- 2026-06-22 19:00:10.600 -- /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.010019063949585 -- 2026-06-22 23:01:59.827[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%228878%22}&event=edit_offwork&offwork_id=8878 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '11' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040221214294434 -- 2026-06-22 23:01:59.832[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%228878%22}&event=edit_offwork&offwork_id=8878 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 = 8878 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018730163574219 -- 2026-06-22 23:01:59.834[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%228878%22}&event=edit_offwork&offwork_id=8878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1163 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019098997116089 -- 2026-06-22 23:02:11.998[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023679733276367 -- 2026-06-22 23:02:12.001[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022709369659424 -- 2026-06-22 23:02:12.003[李振凤-1163] -- /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 = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023438930511475 -- 2026-06-22 23:02:12.006[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022439956665039 -- 2026-06-22 23:02:12.008[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023109912872314 -- 2026-06-22 23:02:12.011[李振凤-1163] -- /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 = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084359645843506 -- 2026-06-22 23:02:14.145[李振凤-1163] -- /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 = '11' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024271011352539 -- 2026-06-22 23:02:14.147[李振凤-1163] -- /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 = 11 AND c.cont_id = 1163 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025110244750977 -- 2026-06-22 23:02:14.150[李振凤-1163] -- /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 = 160 and acct_id = 11 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010524988174438 -- 2026-06-22 23:02:19.910[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023798942565918 -- 2026-06-22 23:02:19.913[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024490356445312 -- 2026-06-22 23:02:19.915[李振凤-1163] -- /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 = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024750232696533 -- 2026-06-22 23:02:19.918[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023429393768311 -- 2026-06-22 23:02:19.920[李振凤-1163] -- /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 = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023419857025146 -- 2026-06-22 23:02:19.923[李振凤-1163] -- /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 = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------