Time: 0.014530897140503 -- 2026-06-24 10:15:40.580[高祥-33] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22%22,%22offwork_id%22:%228975%22%7D&event=&offwork_id=8975 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 8975 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013339519500732 -- 2026-06-24 10:15:40.581[高祥-33] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22%22,%22offwork_id%22:%228975%22%7D&event=&offwork_id=8975 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018234014511108 -- 2026-06-24 10:41:50.659 -- /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.0017940998077393 -- 2026-06-24 10:41:50.662 -- /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.0027518272399902 -- 2026-06-24 10:41:50.665 -- /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='LiuJiNan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020439624786377 -- 2026-06-24 10:41:50.668[刘暨楠-2274] -- /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.0094771385192871 -- 2026-06-24 10:41:56.093[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039298534393311 -- 2026-06-24 10:41:56.097[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002039909362793 -- 2026-06-24 10:41:56.100[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008065938949585 -- 2026-06-24 10:41:56.108[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029070377349854 -- 2026-06-24 10:41:56.111[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 2026-06-24 10:41:56.114[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010128974914551 -- 2026-06-24 10:41:56.794[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 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.0036180019378662 -- 2026-06-24 10:41:56.798[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 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 = 8970 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018308162689209 -- 2026-06-24 10:41:56.800[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2274 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017616987228394 -- 2026-06-24 10:42:02.685[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022890567779541 -- 2026-06-24 10:42:02.687[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022571086883545 -- 2026-06-24 10:42:02.690[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025930404663086 -- 2026-06-24 10:42:02.693[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022108554840088 -- 2026-06-24 10:42:02.695[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021989345550537 -- 2026-06-24 10:42:02.697[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082659721374512 -- 2026-06-24 10:42:04.196[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 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.0015978813171387 -- 2026-06-24 10:42:04.197[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 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 = 8970 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016989707946777 -- 2026-06-24 10:42:04.200[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2274 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085620880126953 -- 2026-06-24 10:42:16.696[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017499923706055 -- 2026-06-24 10:42:16.698[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016970634460449 -- 2026-06-24 10:42:16.700[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018160343170166 -- 2026-06-24 10:42:16.702[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016751289367676 -- 2026-06-24 10:42:16.703[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001662015914917 -- 2026-06-24 10:42:16.705[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094599723815918 -- 2026-06-24 10:44:32.078[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018610954284668 -- 2026-06-24 10:44:32.080[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018510818481445 -- 2026-06-24 10:44:32.082[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020861625671387 -- 2026-06-24 10:44:32.084[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018339157104492 -- 2026-06-24 10:44:32.086[刘暨楠-2274] -- /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 = 2274 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018429756164551 -- 2026-06-24 10:44:32.088[刘暨楠-2274] -- /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 = 2274 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099351406097412 -- 2026-06-24 10:44:32.849[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 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.0033299922943115 -- 2026-06-24 10:44:32.852[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 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 = 8970 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001823902130127 -- 2026-06-24 10:44:32.855[刘暨楠-2274] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2274 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096940994262695 -- 2026-06-24 16:03:40.758 -- /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.0018620491027832 -- 2026-06-24 16:03:40.762 -- /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.0027289390563965 -- 2026-06-24 16:03:40.764 -- /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='WuHuiJu' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020310878753662 -- 2026-06-24 16:03:40.767[吴慧菊-2611] -- /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= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099589824676514 -- 2026-06-24 16:03:41.155[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024130344390869 -- 2026-06-24 16:03:41.157[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023410320281982 -- 2026-06-24 16:03:41.160[吴慧菊-2611] -- /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 = 2611 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00313401222229 -- 2026-06-24 16:03:41.163[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022838115692139 -- 2026-06-24 16:03:41.166[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022909641265869 -- 2026-06-24 16:03:41.168[吴慧菊-2611] -- /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 = 2611 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014434099197388 -- 2026-06-24 16:03:42.734[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002331018447876 -- 2026-06-24 16:03:42.736[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022709369659424 -- 2026-06-24 16:03:42.739[吴慧菊-2611] -- /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 = 2611 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002310037612915 -- 2026-06-24 16:03:42.741[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022819042205811 -- 2026-06-24 16:03:42.744[吴慧菊-2611] -- /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 = 2611 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022590160369873 -- 2026-06-24 16:03:42.746[吴慧菊-2611] -- /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 = 2611 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091559886932373 -- 2026-06-24 16:03:43.695[吴慧菊-2611] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8813 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '47' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037300586700439 -- 2026-06-24 16:03:43.699[吴慧菊-2611] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8813 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 = 8813 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016839504241943 -- 2026-06-24 16:03:43.701[吴慧菊-2611] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8813 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2611 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016664981842041 -- 2026-06-24 18:05:50.772[余泽旭-927] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010390043258667 -- 2026-06-24 18:05:51.748[余泽旭-927] -- /buz/hr/index.php/hrmgmt/hr_quit?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.0017800331115723 -- 2026-06-24 18:05:51.750[余泽旭-927] -- /buz/hr/index.php/hrmgmt/hr_quit?quit_id=354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022194862365723 -- 2026-06-24 18:05:55.334[余泽旭-927] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081260204315186 -- 2026-06-24 19:48:05.595 -- /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.0095131397247314 -- 2026-06-24 19:48:14.365[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023059844970703 -- 2026-06-24 19:48:14.368[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025379657745361 -- 2026-06-24 19:48:14.370[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037829875946045 -- 2026-06-24 19:48:14.374[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022408962249756 -- 2026-06-24 19:48:14.377[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023529529571533 -- 2026-06-24 19:48:14.379[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097451210021973 -- 2026-06-24 19:48:16.425[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00313401222229 -- 2026-06-24 19:48:16.428[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 498 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027370452880859 -- 2026-06-24 19:48:16.431[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01869797706604 -- 2026-06-24 19:48:17.769[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085330009460449 -- 2026-06-24 19:48:19.704[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077688694000244 -- 2026-06-24 19:48:19.848[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088269710540771 -- 2026-06-24 19:48:20.079[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097699165344238 -- 2026-06-24 19:48:20.240[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019337892532349 -- 2026-06-24 19:48:20.934[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091779232025146 -- 2026-06-24 19:48:20.991[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077090263366699 -- 2026-06-24 19:48:21.058[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089969635009766 -- 2026-06-24 19:48:21.129[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073220729827881 -- 2026-06-24 19:48:21.383[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090160369873047 -- 2026-06-24 19:48:21.444[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008929967880249 -- 2026-06-24 19:48:21.500[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079069137573242 -- 2026-06-24 19:48:21.567[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079059600830078 -- 2026-06-24 19:48:21.630[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010678052902222 -- 2026-06-24 19:48:21.689[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075979232788086 -- 2026-06-24 19:48:22.024[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008289098739624 -- 2026-06-24 19:48:22.079[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086228847503662 -- 2026-06-24 19:48:22.148[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091259479522705 -- 2026-06-24 19:48:22.211[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086390972137451 -- 2026-06-24 19:48:22.267[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094470977783203 -- 2026-06-24 19:48:22.335[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092411041259766 -- 2026-06-24 19:48:22.500[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077610015869141 -- 2026-06-24 19:48:22.555[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064778327941895 -- 2026-06-24 19:48:22.618[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088260173797607 -- 2026-06-24 19:48:22.674[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096349716186523 -- 2026-06-24 19:48:22.744[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009598970413208 -- 2026-06-24 19:48:22.801[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014153957366943 -- 2026-06-24 19:48:23.209[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079360008239746 -- 2026-06-24 19:48:23.265[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088531970977783 -- 2026-06-24 19:48:23.439[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094809532165527 -- 2026-06-24 19:48:23.989[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080890655517578 -- 2026-06-24 19:48:24.084[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064749717712402 -- 2026-06-24 19:48:24.156[高蓉-498] -- /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 = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084810256958008 -- 2026-06-24 19:48:33.028[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010190010070801 -- 2026-06-24 19:48:42.649[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002269983291626 -- 2026-06-24 19:48:42.652[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002255916595459 -- 2026-06-24 19:48:42.654[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027608871459961 -- 2026-06-24 19:48:42.657[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022270679473877 -- 2026-06-24 19:48:42.659[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022289752960205 -- 2026-06-24 19:48:42.662[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086638927459717 -- 2026-06-24 19:48:53.129[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020430088043213 -- 2026-06-24 19:48:53.131[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020301342010498 -- 2026-06-24 19:48:53.133[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026578903198242 -- 2026-06-24 19:48:53.136[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019640922546387 -- 2026-06-24 19:48:53.138[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019650459289551 -- 2026-06-24 19:48:53.140[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093438625335693 -- 2026-06-24 19:48:54.239[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8978 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.003687858581543 -- 2026-06-24 19:48:54.243[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8978 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 = 8978 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017669200897217 -- 2026-06-24 19:48:54.245[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8978 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020334959030151 -- 2026-06-24 19:48:55.840[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020279884338379 -- 2026-06-24 19:48:55.843[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019819736480713 -- 2026-06-24 19:48:55.845[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024700164794922 -- 2026-06-24 19:48:55.847[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019528865814209 -- 2026-06-24 19:48:55.849[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001964807510376 -- 2026-06-24 19:48:55.852[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083549022674561 -- 2026-06-24 22:50:27.662[肖春-283] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096778869628906 -- 2026-06-24 22:50:29.183[肖春-283] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8970 SELECT ow.*,e.employee_name,depart.org_name department,corporate.org_name corporate,job.job_name, DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date,DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, 8 appr_type_id, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON ow.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON ow.job_id = job.job_id LEFT JOIN dbsys.sys_org depart ON ow.department_id = depart.org_id LEFT JOIN dbsys.sys_org corporate ON depart.parent_id = corporate.org_id WHERE ow.offwork_id = 8970 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014729499816895 -- 2026-06-24 22:50:29.185[肖春-283] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014309883117676 -- 2026-06-24 22:50:38.677[肖春-283] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088410377502441 -- 2026-06-24 22:50:39.115[肖春-283] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------