Time: 0.023925065994263 -- 26-01-01 00:10:08[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227973%22}&event=&offwork_id=7973 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 = 7973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034689903259277 -- 26-01-01 00:10:08[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227973%22}&event=&offwork_id=7973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016425132751465 -- 26-01-01 00:10:15[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026224136352539 -- 26-01-01 00:10:15[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227973%22}&event=&offwork_id=7973 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 = 7973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031628608703613 -- 26-01-01 00:10:15[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227973%22}&event=&offwork_id=7973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018009185791016 -- 26-01-01 00:10:20[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227972%22}&event=&offwork_id=7972 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 = 7972 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031888484954834 -- 26-01-01 00:10:20[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227972%22}&event=&offwork_id=7972 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016194105148315 -- 26-01-01 00:10:26[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7972 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015853881835938 -- 26-01-01 00:10:26[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227972%22}&event=&offwork_id=7972 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 = 7972 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031530857086182 -- 26-01-01 00:10:26[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227972%22}&event=&offwork_id=7972 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017093896865845 -- 26-01-01 00:10:31[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227971%22}&event=&offwork_id=7971 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 = 7971 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030770301818848 -- 26-01-01 00:10:31[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227971%22}&event=&offwork_id=7971 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01791787147522 -- 26-01-01 00:10:37[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227970%22}&event=&offwork_id=7970 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 = 7970 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031499862670898 -- 26-01-01 00:10:37[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227970%22}&event=&offwork_id=7970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018943071365356 -- 26-01-01 00:10:43[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227969%22}&event=&offwork_id=7969 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 = 7969 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034098625183105 -- 26-01-01 00:10:43[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227969%22}&event=&offwork_id=7969 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016515970230103 -- 26-01-01 00:10:50[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7969 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023583173751831 -- 26-01-01 00:10:50[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227969%22}&event=&offwork_id=7969 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 = 7969 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00319504737854 -- 26-01-01 00:10:50[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227969%22}&event=&offwork_id=7969 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022465944290161 -- 26-01-01 00:10:57[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227968%22}&event=&offwork_id=7968 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 = 7968 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034148693084717 -- 26-01-01 00:10:57[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227968%22}&event=&offwork_id=7968 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015807151794434 -- 26-01-01 00:11:01[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7968 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022878885269165 -- 26-01-01 00:11:02[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227968%22}&event=&offwork_id=7968 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 = 7968 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033028125762939 -- 26-01-01 00:11:02[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227968%22}&event=&offwork_id=7968 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018659114837646 -- 26-01-01 00:11:11[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227967%22}&event=&offwork_id=7967 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 = 7967 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034730434417725 -- 26-01-01 00:11:11[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227967%22}&event=&offwork_id=7967 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01751184463501 -- 26-01-01 00:11:38[张志强-319] -- /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 = 319 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037112236022949 -- 26-01-01 00:11:38[张志强-319] -- /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 = 319 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036718845367432 -- 26-01-01 00:11:38[张志强-319] -- /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 = 319 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036551952362061 -- 26-01-01 00:11:38[张志强-319] -- /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 = 319 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036871433258057 -- 26-01-01 00:11:38[张志强-319] -- /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 = 319 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036978721618652 -- 26-01-01 00:11:38[张志强-319] -- /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 = 319 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021481990814209 -- 26-01-01 00:11:41[张志强-319] -- /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 = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040779113769531 -- 26-01-01 00:11:41[张志强-319] -- /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 = 9 AND c.cont_id = 319 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043120384216309 -- 26-01-01 00:11:41[张志强-319] -- /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 = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020624160766602 -- 26-01-01 00:13:00[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016177892684937 -- 26-01-01 07:07:12 -- /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.018033981323242 -- 26-01-01 07:07:12[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048129558563232 -- 26-01-01 07:07:12[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045440196990967 -- 26-01-01 07:07:12[罗育胜-374] -- /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 = 374 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012480974197388 -- 26-01-01 07:07:12[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045261383056641 -- 26-01-01 07:07:12[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005000114440918 -- 26-01-01 07:07:12[罗育胜-374] -- /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 = 374 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019335031509399 -- 26-01-01 07:07:15[罗育胜-374] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7965 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010623931884766 -- 26-01-01 07:07:15[罗育胜-374] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7965 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 = 7965 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-01 07:07:15[罗育胜-374] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7965 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 374 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016609907150269 -- 26-01-01 07:07:30[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003633975982666 -- 26-01-01 07:07:30[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003587007522583 -- 26-01-01 07:07:30[罗育胜-374] -- /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 = 374 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037739276885986 -- 26-01-01 07:07:30[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035700798034668 -- 26-01-01 07:07:30[罗育胜-374] -- /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 = 374 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035710334777832 -- 26-01-01 07:07:30[罗育胜-374] -- /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 = 374 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015821933746338 -- 26-01-01 08:10:38 -- /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.0032072067260742 -- 26-01-01 08:10:38 -- /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.0037140846252441 -- 26-01-01 08:10:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuZhanRu' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00351881980896 -- 26-01-01 08:10:38[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018052101135254 -- 26-01-01 08:10:41[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040509700775146 -- 26-01-01 08:10:41[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003986120223999 -- 26-01-01 08:10:41[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1710 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074629783630371 -- 26-01-01 08:10:41[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039510726928711 -- 26-01-01 08:10:41[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1710 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003943920135498 -- 26-01-01 08:10:41[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1710 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028449058532715 -- 26-01-01 08:10:42[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059311389923096 -- 26-01-01 08:10:42[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7951 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034980773925781 -- 26-01-01 08:10:42[吴展如-1710] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7951 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015488147735596 -- 26-01-01 10:04:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015344858169556 -- 26-01-01 10:04:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002979040145874 -- 26-01-01 10:04:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004148006439209 -- 26-01-01 10:04:14 -- /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='YuanQunYing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-01 10:04:14[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017863035202026 -- 26-01-01 10:04:15[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003957986831665 -- 26-01-01 10:04:15[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039119720458984 -- 26-01-01 10:04:15[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089099407196045 -- 26-01-01 10:04:15[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039517879486084 -- 26-01-01 10:04:15[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038511753082275 -- 26-01-01 10:04:15[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016799926757812 -- 26-01-01 10:04:22[袁群英-668] -- /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 = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047500133514404 -- 26-01-01 10:04:22[袁群英-668] -- /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 = 9 AND c.cont_id = 668 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042638778686523 -- 26-01-01 10:04:22[袁群英-668] -- /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 = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016067981719971 -- 26-01-01 10:06:50[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 668 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024049997329712 -- 26-01-01 10:07:05[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039288997650146 -- 26-01-01 10:07:05[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004040002822876 -- 26-01-01 10:07:05[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039911270141602 -- 26-01-01 10:07:05[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038738250732422 -- 26-01-01 10:07:05[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038678646087646 -- 26-01-01 10:07:05[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016952991485596 -- 26-01-01 10:07:08[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7975 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053820610046387 -- 26-01-01 10:07:08[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7975 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 = 7975 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031330585479736 -- 26-01-01 10:07:08[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7975 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 668 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022377014160156 -- 26-01-01 10:07:11[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037450790405273 -- 26-01-01 10:07:11[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037288665771484 -- 26-01-01 10:07:11[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035359859466553 -- 26-01-01 10:07:11[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036940574645996 -- 26-01-01 10:07:11[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036928653717041 -- 26-01-01 10:07:11[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017637968063354 -- 26-01-01 13:31:12 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034551620483398 -- 26-01-01 13:31:12 -- /buz/hr/index.php/hrmgmt/hr_approval_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.0045700073242188 -- 26-01-01 13:31:12 -- /buz/hr/index.php/hrmgmt/hr_approval_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='MaiSuiErShi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037682056427002 -- 26-01-01 13:31:12[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016112089157104 -- 26-01-01 13:31:13[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018128871917725 -- 26-01-01 13:31:16[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7968 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 = 7968 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031411647796631 -- 26-01-01 13:31:16[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7968 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016691923141479 -- 26-01-01 13:31:19[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7968 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017310857772827 -- 26-01-01 13:31:19[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.036931991577148 -- 26-01-01 13:31:20[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7969 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 = 7969 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032200813293457 -- 26-01-01 13:31:20[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7969 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028160810470581 -- 26-01-01 13:31:22[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7969 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017052888870239 -- 26-01-01 13:31:22[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021454811096191 -- 26-01-01 13:31:23[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7972 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 = 7972 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031630992889404 -- 26-01-01 13:31:23[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7972 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016710996627808 -- 26-01-01 13:31:25[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7972 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016649007797241 -- 26-01-01 13:31:25[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018347024917603 -- 26-01-01 13:31:26[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7973 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 = 7973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034129619598389 -- 26-01-01 13:31:26[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023864984512329 -- 26-01-01 13:31:28[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025406837463379 -- 26-01-01 13:31:29[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018317937850952 -- 26-01-01 13:31:30[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7974 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 = 7974 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031619071960449 -- 26-01-01 13:31:30[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7974 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017688989639282 -- 26-01-01 13:31:33[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7974 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022000789642334 -- 26-01-01 13:31:33[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022578001022339 -- 26-01-01 13:31:40[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018528938293457 -- 26-01-01 17:01:02[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227965%22}&event=&offwork_id=7965 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 = 7965 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003303050994873 -- 26-01-01 17:01:02[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227965%22}&event=&offwork_id=7965 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025738954544067 -- 26-01-01 17:01:19[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227967%22}&event=&offwork_id=7967 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 = 7967 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032069683074951 -- 26-01-01 17:01:19[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227967%22}&event=&offwork_id=7967 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018163204193115 -- 26-01-01 17:01:29[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227968%22}&event=&offwork_id=7968 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 = 7968 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033068656921387 -- 26-01-01 17:01:29[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227968%22}&event=&offwork_id=7968 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030912160873413 -- 26-01-01 17:01:34[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227969%22}&event=&offwork_id=7969 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 = 7969 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034689903259277 -- 26-01-01 17:01:34[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227969%22}&event=&offwork_id=7969 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018005847930908 -- 26-01-01 17:01:41[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227970%22}&event=&offwork_id=7970 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 = 7970 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003119945526123 -- 26-01-01 17:01:41[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227970%22}&event=&offwork_id=7970 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017024040222168 -- 26-01-01 17:01:46[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227971%22}&event=&offwork_id=7971 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 = 7971 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032320022583008 -- 26-01-01 17:01:46[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227971%22}&event=&offwork_id=7971 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020308017730713 -- 26-01-01 17:02:00[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227972%22}&event=&offwork_id=7972 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 = 7972 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033948421478271 -- 26-01-01 17:02:00[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227972%22}&event=&offwork_id=7972 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020478963851929 -- 26-01-01 17:02:13[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227973%22}&event=&offwork_id=7973 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 = 7973 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034189224243164 -- 26-01-01 17:02:13[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227973%22}&event=&offwork_id=7973 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016010046005249 -- 26-01-01 17:09:24 -- /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.0032219886779785 -- 26-01-01 17:09:24 -- /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.0037639141082764 -- 26-01-01 17:09:24 -- /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='FuYou' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035579204559326 -- 26-01-01 17:09:24[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017706155776978 -- 26-01-01 17:09:29[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039019584655762 -- 26-01-01 17:09:29[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038619041442871 -- 26-01-01 17:09:29[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038950443267822 -- 26-01-01 17:09:29[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038230419158936 -- 26-01-01 17:09:29[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039072036743164 -- 26-01-01 17:09:29[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01805591583252 -- 26-01-01 17:09:38[符金辉-380] -- /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 = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003662109375 -- 26-01-01 17:09:38[符金辉-380] -- /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 = 9 AND c.cont_id = 380 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045120716094971 -- 26-01-01 17:09:38[符金辉-380] -- /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 = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01690411567688 -- 26-01-01 17:12:29[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025830030441284 -- 26-01-01 17:12:47[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037479400634766 -- 26-01-01 17:12:47[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036609172821045 -- 26-01-01 17:12:47[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034401416778564 -- 26-01-01 17:12:47[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035908222198486 -- 26-01-01 17:12:47[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036499500274658 -- 26-01-01 17:12:47[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022356986999512 -- 26-01-01 17:12:48[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039529800415039 -- 26-01-01 17:12:48[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 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 = 7976 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032141208648682 -- 26-01-01 17:12:48[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015966892242432 -- 26-01-01 17:12:52[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031630992889404 -- 26-01-01 17:12:52[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031869411468506 -- 26-01-01 17:12:52[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033168792724609 -- 26-01-01 17:12:52[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031437873840332 -- 26-01-01 17:12:52[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031478404998779 -- 26-01-01 17:12:52[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016582012176514 -- 26-01-01 17:13:23[符金辉-380] -- /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 = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035619735717773 -- 26-01-01 17:13:23[符金辉-380] -- /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 = 9 AND c.cont_id = 380 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040490627288818 -- 26-01-01 17:13:23[符金辉-380] -- /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 = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015619039535522 -- 26-01-01 17:14:28[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016260862350464 -- 26-01-01 17:14:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035479068756104 -- 26-01-01 17:14:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035169124603271 -- 26-01-01 17:14:39[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003324031829834 -- 26-01-01 17:14:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034840106964111 -- 26-01-01 17:14:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034911632537842 -- 26-01-01 17:14:39[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027421951293945 -- 26-01-01 17:14:41[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7977 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024280071258545 -- 26-01-01 17:14:41[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7977 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 = 7977 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032510757446289 -- 26-01-01 17:14:41[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7977 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027443170547485 -- 26-01-01 17:14:43[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039172172546387 -- 26-01-01 17:14:43[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038700103759766 -- 26-01-01 17:14:43[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 26-01-01 17:14:43[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038599967956543 -- 26-01-01 17:14:43[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038521289825439 -- 26-01-01 17:14:43[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022459030151367 -- 26-01-01 17:14:43[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050499439239502 -- 26-01-01 17:14:43[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 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 = 7976 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033950805664062 -- 26-01-01 17:14:43[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016376972198486 -- 26-01-01 17:14:45[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032389163970947 -- 26-01-01 17:14:45[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032649040222168 -- 26-01-01 17:14:45[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042710304260254 -- 26-01-01 17:14:45[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032689571380615 -- 26-01-01 17:14:45[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032968521118164 -- 26-01-01 17:14:45[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019124031066895 -- 26-01-01 17:27:52[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227977%22}&event=&offwork_id=7977 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 = 7977 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034739971160889 -- 26-01-01 17:27:52[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227977%22}&event=&offwork_id=7977 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017396211624146 -- 26-01-01 17:27:58[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7977 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023095846176147 -- 26-01-01 17:27:58[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227977%22}&event=&offwork_id=7977 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 = 7977 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033049583435059 -- 26-01-01 17:27:58[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227977%22}&event=&offwork_id=7977 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029789209365845 -- 26-01-01 17:28:10[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227976%22}&event=&offwork_id=7976 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 = 7976 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032308101654053 -- 26-01-01 17:28:10[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227976%22}&event=&offwork_id=7976 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017186880111694 -- 26-01-01 17:28:15[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7976 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028090953826904 -- 26-01-01 17:28:15[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227976%22}&event=&offwork_id=7976 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 = 7976 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003087043762207 -- 26-01-01 17:28:15[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227976%22}&event=&offwork_id=7976 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016069173812866 -- 26-01-01 17:48:36 -- /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.0032098293304443 -- 26-01-01 17:48:36 -- /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.0040688514709473 -- 26-01-01 17:48:36 -- /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='ZhangZhaoXia' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034520626068115 -- 26-01-01 17:48:36[张昭霞-2107] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017544984817505 -- 26-01-01 17:48:38[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004004955291748 -- 26-01-01 17:48:38[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038859844207764 -- 26-01-01 17:48:38[张昭霞-2107] -- /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 = 2107 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039570331573486 -- 26-01-01 17:48:38[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038261413574219 -- 26-01-01 17:48:38[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038621425628662 -- 26-01-01 17:48:38[张昭霞-2107] -- /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 = 2107 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018087863922119 -- 26-01-01 17:48:43[张昭霞-2107] -- /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 = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046360492706299 -- 26-01-01 17:48:43[张昭霞-2107] -- /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 = 9 AND c.cont_id = 2107 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044870376586914 -- 26-01-01 17:48:43[张昭霞-2107] -- /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 = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016297101974487 -- 26-01-01 17:49:49[张昭霞-2107] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016321897506714 -- 26-01-01 17:50:02[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035820007324219 -- 26-01-01 17:50:02[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003511905670166 -- 26-01-01 17:50:02[张昭霞-2107] -- /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 = 2107 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035290718078613 -- 26-01-01 17:50:02[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034928321838379 -- 26-01-01 17:50:02[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035221576690674 -- 26-01-01 17:50:02[张昭霞-2107] -- /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 = 2107 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017143964767456 -- 26-01-01 17:50:52 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017168998718262 -- 26-01-01 17:50:55 -- /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.016123056411743 -- 26-01-01 17:50:55[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036678314208984 -- 26-01-01 17:50:55[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036342144012451 -- 26-01-01 17:50:55[邓薇-553] -- /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 = 553 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043270587921143 -- 26-01-01 17:50:55[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035128593444824 -- 26-01-01 17:50:55[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035150051116943 -- 26-01-01 17:50:55[邓薇-553] -- /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 = 553 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018687963485718 -- 26-01-01 17:50:56[邓薇-553] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7963 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051329135894775 -- 26-01-01 17:50:56[邓薇-553] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7963 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 = 7963 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017419815063477 -- 26-01-01 21:38:26[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038919448852539 -- 26-01-01 21:38:26[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038731098175049 -- 26-01-01 21:38:26[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046548843383789 -- 26-01-01 21:38:26[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038011074066162 -- 26-01-01 21:38:26[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038101673126221 -- 26-01-01 21:38:26[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027526140213013 -- 26-01-01 21:38:27[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7977 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056998729705811 -- 26-01-01 21:38:27[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7977 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 = 7977 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003507137298584 -- 26-01-01 21:38:27[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7977 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015622138977051 -- 26-01-01 21:38:32[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034239292144775 -- 26-01-01 21:38:32[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033690929412842 -- 26-01-01 21:38:32[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004054069519043 -- 26-01-01 21:38:32[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033791065216064 -- 26-01-01 21:38:32[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034401416778564 -- 26-01-01 21:38:32[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027650117874146 -- 26-01-01 21:38:33[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049920082092285 -- 26-01-01 21:38:33[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 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 = 7976 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030431747436523 -- 26-01-01 21:38:33[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7976 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016520977020264 -- 26-01-01 21:38:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035951137542725 -- 26-01-01 21:38:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035789012908936 -- 26-01-01 21:38:39[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003795862197876 -- 26-01-01 21:38:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035710334777832 -- 26-01-01 21:38:39[符金辉-380] -- /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 = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035479068756104 -- 26-01-01 21:38:39[符金辉-380] -- /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 = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017698049545288 -- 26-01-01 22:21:43 -- /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.0035018920898438 -- 26-01-01 22:21:43 -- /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.0040779113769531 -- 26-01-01 22:21:43 -- /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='ZhangGuangWei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037438869476318 -- 26-01-01 22:21:43[张光伟-2596] -- /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.017138957977295 -- 26-01-01 22:21:44[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00376296043396 -- 26-01-01 22:21:44[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036928653717041 -- 26-01-01 22:21:44[张光伟-2596] -- /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 = 2596 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042400360107422 -- 26-01-01 22:21:44[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036609172821045 -- 26-01-01 22:21:44[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036420822143555 -- 26-01-01 22:21:44[张光伟-2596] -- /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 = 2596 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02197790145874 -- 26-01-01 22:21:45[张光伟-2596] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7964 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.0048749446868896 -- 26-01-01 22:21:45[张光伟-2596] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7964 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 = 7964 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033841133117676 -- 26-01-01 22:21:45[张光伟-2596] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7964 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2596 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027433156967163 -- 26-01-01 22:21:50[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038189888000488 -- 26-01-01 22:21:50[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037870407104492 -- 26-01-01 22:21:50[张光伟-2596] -- /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 = 2596 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038139820098877 -- 26-01-01 22:21:50[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037510395050049 -- 26-01-01 22:21:50[张光伟-2596] -- /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 = 2596 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037610530853271 -- 26-01-01 22:21:50[张光伟-2596] -- /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 = 2596 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------