Time: 0.021097898483276 -- 25-08-09 01:07:49[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227169%22}&event=edit_offwork&offwork_id=7169 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') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013021945953369 -- 25-08-09 01:07:49[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227169%22}&event=edit_offwork&offwork_id=7169 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 = 7169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003727912902832 -- 25-08-09 01:07:49[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227169%22}&event=edit_offwork&offwork_id=7169 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017941951751709 -- 25-08-09 01:07:59[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227168%22}&event=edit_offwork&offwork_id=7168 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') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053670406341553 -- 25-08-09 01:07:59[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227168%22}&event=edit_offwork&offwork_id=7168 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 = 7168 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003507137298584 -- 25-08-09 01:07:59[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227168%22}&event=edit_offwork&offwork_id=7168 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022627830505371 -- 25-08-09 01:08:15[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056278705596924 -- 25-08-09 01:08:15[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055949687957764 -- 25-08-09 01:08:15[王元-300] -- /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 = 300 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081918239593506 -- 25-08-09 01:08:15[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005486011505127 -- 25-08-09 01:08:15[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00531005859375 -- 25-08-09 01:08:15[王元-300] -- /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 = 300 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019450187683105 -- 25-08-09 01:08:22[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7169 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') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038630962371826 -- 25-08-09 01:08:22[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7169 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 = 7169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-08-09 01:08:22[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7169 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022983074188232 -- 25-08-09 01:08:26[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037248134613037 -- 25-08-09 01:08:26[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003680944442749 -- 25-08-09 01:08:26[王元-300] -- /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 = 300 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039210319519043 -- 25-08-09 01:08:26[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-08-09 01:08:26[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036468505859375 -- 25-08-09 01:08:26[王元-300] -- /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 = 300 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022374153137207 -- 25-08-09 01:08:26[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7168 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') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00543212890625 -- 25-08-09 01:08:26[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7168 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 = 7168 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034830570220947 -- 25-08-09 01:08:26[王元-300] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7168 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022039175033569 -- 25-08-09 01:08:31[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033690929412842 -- 25-08-09 01:08:31[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033321380615234 -- 25-08-09 01:08:31[王元-300] -- /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 = 300 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032949447631836 -- 25-08-09 01:08:31[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 25-08-09 01:08:31[王元-300] -- /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 = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033128261566162 -- 25-08-09 01:08:31[王元-300] -- /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 = 300 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032879114151001 -- 25-08-09 07:09:37[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227223%22}&event=&offwork_id=7223 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 = 7223 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039069652557373 -- 25-08-09 07:09:37[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227223%22}&event=&offwork_id=7223 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015228986740112 -- 25-08-09 07:09:40[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7223 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027177810668945 -- 25-08-09 07:09:40[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227223%22}&event=&offwork_id=7223 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 = 7223 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033168792724609 -- 25-08-09 07:09:40[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227223%22}&event=&offwork_id=7223 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018364906311035 -- 25-08-09 07:09:43[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227225%22}&event=&offwork_id=7225 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 = 7225 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032188892364502 -- 25-08-09 07:09:43[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227225%22}&event=&offwork_id=7225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025675058364868 -- 25-08-09 07:09:47[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024889945983887 -- 25-08-09 07:09:47[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227225%22}&event=&offwork_id=7225 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 = 7225 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036759376525879 -- 25-08-09 07:09:47[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227225%22}&event=&offwork_id=7225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018566131591797 -- 25-08-09 07:56:31 -- /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.0036492347717285 -- 25-08-09 07:56:31 -- /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.0045528411865234 -- 25-08-09 07:56:31 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='DuLi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038330554962158 -- 25-08-09 07:56:31[杜丽-1648] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0171799659729 -- 25-08-09 07:56:33[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038230419158936 -- 25-08-09 07:56:33[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037951469421387 -- 25-08-09 07:56:33[杜丽-1648] -- /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 = 1648 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004295825958252 -- 25-08-09 07:56:33[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037679672241211 -- 25-08-09 07:56:33[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037760734558105 -- 25-08-09 07:56:33[杜丽-1648] -- /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 = 1648 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027673959732056 -- 25-08-09 07:56:36[杜丽-1648] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '23' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047860145568848 -- 25-08-09 07:56:36[杜丽-1648] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 23 AND c.cont_id = 1648 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043561458587646 -- 25-08-09 07:56:36[杜丽-1648] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 368 and acct_id = 23 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015894889831543 -- 25-08-09 07:56:46[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034589767456055 -- 25-08-09 07:56:46[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034480094909668 -- 25-08-09 07:56:46[杜丽-1648] -- /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 = 1648 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033998489379883 -- 25-08-09 07:56:46[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033979415893555 -- 25-08-09 07:56:46[杜丽-1648] -- /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 = 1648 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003389835357666 -- 25-08-09 07:56:46[杜丽-1648] -- /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 = 1648 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019874095916748 -- 25-08-09 08:20:04[高祥-33] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22%22,%22offwork_id%22:%226985%22%7D&event=&offwork_id=6985 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 = 6985 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032920837402344 -- 25-08-09 08:20:04[高祥-33] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22%22,%22offwork_id%22:%226985%22%7D&event=&offwork_id=6985 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028519868850708 -- 25-08-09 09:39:03[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227224%22}&event=&offwork_id=7224 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 = 7224 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034689903259277 -- 25-08-09 09:39:03[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227224%22}&event=&offwork_id=7224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019689798355103 -- 25-08-09 09:39:15[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227222%22}&event=&offwork_id=7222 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 = 7222 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035088062286377 -- 25-08-09 09:39:15[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227222%22}&event=&offwork_id=7222 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018846988677979 -- 25-08-09 09:40:14[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226945%22}&event=&offwork_id=6945 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 = 6945 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034530162811279 -- 25-08-09 09:40:14[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226945%22}&event=&offwork_id=6945 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020295858383179 -- 25-08-09 09:51:44 -- /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.003507137298584 -- 25-08-09 09:51:44 -- /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.0043368339538574 -- 25-08-09 09:51:44 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZaiYiCiXinTiao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00382399559021 -- 25-08-09 09:51:44[李晓庆-370] -- /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.026784896850586 -- 25-08-09 09:51:45[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040311813354492 -- 25-08-09 09:51:45[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039730072021484 -- 25-08-09 09:51:45[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041229724884033 -- 25-08-09 09:51:45[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003978967666626 -- 25-08-09 09:51:45[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039968490600586 -- 25-08-09 09:51:45[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018701076507568 -- 25-08-09 09:51:51[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047640800476074 -- 25-08-09 09:51:51[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 9 AND c.cont_id = 370 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004284143447876 -- 25-08-09 09:51:51[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017333030700684 -- 25-08-09 09:53:09[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016197919845581 -- 25-08-09 09:53:16[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034918785095215 -- 25-08-09 09:53:16[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035121440887451 -- 25-08-09 09:53:16[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00357985496521 -- 25-08-09 09:53:16[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034699440002441 -- 25-08-09 09:53:16[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003471851348877 -- 25-08-09 09:53:16[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018848896026611 -- 25-08-09 09:53:18[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7226 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039288997650146 -- 25-08-09 09:53:18[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7226 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 = 7226 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029301643371582 -- 25-08-09 09:53:18[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7226 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018481969833374 -- 25-08-09 09:53:24[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039830207824707 -- 25-08-09 09:53:24[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039830207824707 -- 25-08-09 09:53:24[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040438175201416 -- 25-08-09 09:53:24[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003593921661377 -- 25-08-09 09:53:24[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039160251617432 -- 25-08-09 09:53:24[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024720907211304 -- 25-08-09 09:53:26[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038859844207764 -- 25-08-09 09:53:26[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 9 AND c.cont_id = 370 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039281845092773 -- 25-08-09 09:53:26[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017925024032593 -- 25-08-09 09:53:27[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035638809204102 -- 25-08-09 09:53:27[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035648345947266 -- 25-08-09 09:53:27[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036771297454834 -- 25-08-09 09:53:27[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035569667816162 -- 25-08-09 09:53:27[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035438537597656 -- 25-08-09 09:53:27[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017735958099365 -- 25-08-09 09:55:04 -- /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.0036051273345947 -- 25-08-09 09:55:04 -- /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.0040578842163086 -- 25-08-09 09:55:04 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiaoTianLun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037848949432373 -- 25-08-09 09:55:04[廖天伦-2150] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027644872665405 -- 25-08-09 09:55:04[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035810470581055 -- 25-08-09 09:55:04[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035369396209717 -- 25-08-09 09:55:04[廖天伦-2150] -- /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 = 2150 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 25-08-09 09:55:04[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034971237182617 -- 25-08-09 09:55:04[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035219192504883 -- 25-08-09 09:55:04[廖天伦-2150] -- /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 = 2150 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021216869354248 -- 25-08-09 09:55:05[廖天伦-2150] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull&turnfull_id=255 SELECT tf.turnfull_id,tf.turnfull_no,tf.owner_id,tf.status_id,tf.employee_id,tf.employee_name,tf.employee_no,tf.department_id, DATE_FORMAT(tf.entry_time,'%Y-%m-%d') entry_time,tf.createdon,tf.updatedon,tf.trial_job_id,tf.trial_salary,tf.firstMonth_assess, tf.secondMonth_assess,tf.thirdMonth_assess,tf.trial_goodresult,tf.trial_ability,tf.brief_summary,tf.self_evaluation, DATE_FORMAT(tf.apply_date,'%Y-%m-%d') apply_date,tf.appr_proc_id,tf.cur_appr_id_str,org.org_name department, apro.appr_proc_name,job.job_name trial_job,IFNULL(DATE_FORMAT(tf.effective_date,'%Y-%m-%d'),'') effective_date, IFNULL(turnfull_job.job_name,'') turnfull_job,IFNULL(tf.turnfull_salary,'') turnfull_salary FROM dbhr.hr_turnfull tf LEFT JOIN dboa.oa_appr_process apro ON tf.appr_proc_id = apro.appr_proc_id LEFT JOIN dbhr.hr_job job ON tf.trial_job_id = job.job_id LEFT JOIN dbhr.hr_job turnfull_job ON tf.turnfull_job_id = turnfull_job.job_id LEFT JOIN dbsys.sys_org org ON tf.department_id = org.org_id WHERE tf.turnfull_id = 255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039951801300049 -- 25-08-09 09:55:05[廖天伦-2150] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull&turnfull_id=255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2150 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020895957946777 -- 25-08-09 09:55:10[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041940212249756 -- 25-08-09 09:55:10[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041639804840088 -- 25-08-09 09:55:10[廖天伦-2150] -- /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 = 2150 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041348934173584 -- 25-08-09 09:55:10[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041139125823975 -- 25-08-09 09:55:10[廖天伦-2150] -- /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 = 2150 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042281150817871 -- 25-08-09 09:55:10[廖天伦-2150] -- /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 = 2150 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017240047454834 -- 25-08-09 10:57:23 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019137144088745 -- 25-08-09 10:57:23[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042099952697754 -- 25-08-09 10:57:23[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041840076446533 -- 25-08-09 10:57:23[龚俊凯-846] -- /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 = 846 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048360824584961 -- 25-08-09 10:57:23[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041289329528809 -- 25-08-09 10:57:23[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041148662567139 -- 25-08-09 10:57:23[龚俊凯-846] -- /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 = 846 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027000904083252 -- 25-08-09 10:57:26[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044460296630859 -- 25-08-09 10:57:26[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 9 AND c.cont_id = 846 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042710304260254 -- 25-08-09 10:57:26[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028235912322998 -- 25-08-09 10:58:29[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 846 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015143156051636 -- 25-08-09 10:58:39[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033128261566162 -- 25-08-09 10:58:39[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033290386199951 -- 25-08-09 10:58:39[龚俊凯-846] -- /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 = 846 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034840106964111 -- 25-08-09 10:58:39[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032780170440674 -- 25-08-09 10:58:39[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033469200134277 -- 25-08-09 10:58:39[龚俊凯-846] -- /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 = 846 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027268886566162 -- 25-08-09 10:58:41[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7227 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050590038299561 -- 25-08-09 10:58:41[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033349990844727 -- 25-08-09 10:58:41[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 846 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017632007598877 -- 25-08-09 10:58:43[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038549900054932 -- 25-08-09 10:58:43[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003838062286377 -- 25-08-09 10:58:43[龚俊凯-846] -- /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 = 846 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040590763092041 -- 25-08-09 10:58:43[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038299560546875 -- 25-08-09 10:58:43[龚俊凯-846] -- /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 = 846 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038249492645264 -- 25-08-09 10:58:43[龚俊凯-846] -- /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 = 846 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018673181533813 -- 25-08-09 11:00:44[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034449100494385 -- 25-08-09 11:00:44[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020555019378662 -- 25-08-09 11:00:53[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017235994338989 -- 25-08-09 11:00:53[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030410289764404 -- 25-08-09 11:00:53[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018753051757812 -- 25-08-09 11:05:49[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034489631652832 -- 25-08-09 11:05:50[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028449058532715 -- 25-08-09 11:06:31[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023172855377197 -- 25-08-09 11:06:32[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029511451721191 -- 25-08-09 11:06:32[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227227%22}&event=&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019528865814209 -- 25-08-09 11:12:48 -- /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.0038211345672607 -- 25-08-09 11:12:48 -- /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.0043098926544189 -- 25-08-09 11:12:48 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangMeiFen' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040218830108643 -- 25-08-09 11:12:48[张美芬-2158] -- /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= 43 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018666982650757 -- 25-08-09 11:12:48[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040900707244873 -- 25-08-09 11:12:48[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040788650512695 -- 25-08-09 11:12:48[张美芬-2158] -- /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 = 2158 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040650367736816 -- 25-08-09 11:12:48[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040340423583984 -- 25-08-09 11:12:48[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040500164031982 -- 25-08-09 11:12:48[张美芬-2158] -- /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 = 2158 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018671989440918 -- 25-08-09 11:12:51[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '43' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046060085296631 -- 25-08-09 11:12:51[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 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 = 43 AND c.cont_id = 2158 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045139789581299 -- 25-08-09 11:12:51[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 475 and acct_id = 43 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019730091094971 -- 25-08-09 11:13:01[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2158 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018238067626953 -- 25-08-09 11:13:04[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039379596710205 -- 25-08-09 11:13:04[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039269924163818 -- 25-08-09 11:13:04[张美芬-2158] -- /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 = 2158 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039329528808594 -- 25-08-09 11:13:04[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038771629333496 -- 25-08-09 11:13:04[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038769245147705 -- 25-08-09 11:13:04[张美芬-2158] -- /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 = 2158 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032837867736816 -- 25-08-09 11:13:05[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '43' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034198760986328 -- 25-08-09 11:13:05[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 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 = 43 AND c.cont_id = 2158 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033969879150391 -- 25-08-09 11:13:05[张美芬-2158] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 475 and acct_id = 43 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016595125198364 -- 25-08-09 11:13:07[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034728050231934 -- 25-08-09 11:13:07[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034289360046387 -- 25-08-09 11:13:07[张美芬-2158] -- /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 = 2158 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034811496734619 -- 25-08-09 11:13:07[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 25-08-09 11:13:07[张美芬-2158] -- /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 = 2158 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034310817718506 -- 25-08-09 11:13:07[张美芬-2158] -- /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 = 2158 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020128965377808 -- 25-08-09 11:39:41[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030781030654907 -- 25-08-09 11:39:42[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?recruitApply_id=265 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 265 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036718845367432 -- 25-08-09 11:39:42[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?recruitApply_id=265 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028666019439697 -- 25-08-09 11:39:50[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017480850219727 -- 25-08-09 11:39:58[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22265%22}&event=&recruitApply_id=265 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 265 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032021999359131 -- 25-08-09 11:39:58[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22265%22}&event=&recruitApply_id=265 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017961978912354 -- 25-08-09 11:40:03[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22265%22}&event=&recruitApply_id=265 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 265 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035238265991211 -- 25-08-09 11:40:03[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22265%22}&event=&recruitApply_id=265 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026368141174316 -- 25-08-09 11:40:44[沈丽云-2156] -- /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 = 2156 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034570693969727 -- 25-08-09 11:40:44[沈丽云-2156] -- /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 = 2156 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034530162811279 -- 25-08-09 11:40:44[沈丽云-2156] -- /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 = 2156 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034701824188232 -- 25-08-09 11:40:44[沈丽云-2156] -- /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 = 2156 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033619403839111 -- 25-08-09 11:40:44[沈丽云-2156] -- /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 = 2156 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033938884735107 -- 25-08-09 11:40:44[沈丽云-2156] -- /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 = 2156 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028125047683716 -- 25-08-09 11:40:46[沈丽云-2156] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017030954360962 -- 25-08-09 11:40:47[沈丽云-2156] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7228 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 = 7228 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030949115753174 -- 25-08-09 11:40:47[沈丽云-2156] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7228 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015072107315063 -- 25-08-09 11:40:50[沈丽云-2156] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7228 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027598142623901 -- 25-08-09 11:40:53[沈丽云-2156] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015886783599854 -- 25-08-09 12:58:20 -- /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.018511056900024 -- 25-08-09 12:58:22[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037720203399658 -- 25-08-09 12:58:22[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037288665771484 -- 25-08-09 12:58:22[唐俊宇-848] -- /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 = 848 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037980079650879 -- 25-08-09 12:58:22[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037009716033936 -- 25-08-09 12:58:22[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037190914154053 -- 25-08-09 12:58:22[唐俊宇-848] -- /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 = 848 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017712116241455 -- 25-08-09 12:58:25[唐俊宇-848] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044651031494141 -- 25-08-09 12:58:25[唐俊宇-848] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 9 AND c.cont_id = 848 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044071674346924 -- 25-08-09 12:58:25[唐俊宇-848] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016425132751465 -- 25-08-09 12:58:58[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035560131072998 -- 25-08-09 12:58:58[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035459995269775 -- 25-08-09 12:58:58[唐俊宇-848] -- /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 = 848 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035851001739502 -- 25-08-09 12:58:58[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035028457641602 -- 25-08-09 12:58:58[唐俊宇-848] -- /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 = 848 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035889148712158 -- 25-08-09 12:58:58[唐俊宇-848] -- /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 = 848 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022609949111938 -- 25-08-09 14:42:57 -- /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.0044598579406738 -- 25-08-09 14:42:57 -- /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.0052862167358398 -- 25-08-09 14:42:57 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='230b8a056ec86d847a2fcba4edb75259' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047228336334229 -- 25-08-09 14:42:57[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023031949996948 -- 25-08-09 14:42:57[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049710273742676 -- 25-08-09 14:42:57[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049288272857666 -- 25-08-09 14:42:57[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049998760223389 -- 25-08-09 14:42:57[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004957914352417 -- 25-08-09 14:42:57[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049300193786621 -- 25-08-09 14:42:57[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024436950683594 -- 25-08-09 14:42:59[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7150 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005216121673584 -- 25-08-09 14:42:59[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7150 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 = 7150 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019783973693848 -- 25-08-09 14:43:03[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=delete_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1656 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025254964828491 -- 25-08-09 14:43:04[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037291049957275 -- 25-08-09 14:43:04[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037369728088379 -- 25-08-09 14:43:04[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037331581115723 -- 25-08-09 14:43:04[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003713846206665 -- 25-08-09 14:43:04[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037100315093994 -- 25-08-09 14:43:04[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024412155151367 -- 25-08-09 14:43:07[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004194974899292 -- 25-08-09 14:43:07[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041790008544922 -- 25-08-09 14:43:07[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042049884796143 -- 25-08-09 14:43:07[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041909217834473 -- 25-08-09 14:43:07[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041570663452148 -- 25-08-09 14:43:07[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019649982452393 -- 25-08-09 14:43:09[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6959 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055968761444092 -- 25-08-09 14:43:09[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6959 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 = 6959 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037338733673096 -- 25-08-09 14:43:09[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6959 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1656 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030900001525879 -- 25-08-09 14:43:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045311450958252 -- 25-08-09 14:43:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045051574707031 -- 25-08-09 14:43:12[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042078495025635 -- 25-08-09 14:43:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045340061187744 -- 25-08-09 14:43:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044810771942139 -- 25-08-09 14:43:12[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022807121276855 -- 25-08-09 14:43:16[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name FROM dbsys.`sys_contact` c LEFT JOIN dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 1656 and c.`cont_name`=e.employee_name limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043599605560303 -- 25-08-09 14:43:16[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024293899536133 -- 25-08-09 14:44:04[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1656 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021612167358398 -- 25-08-09 14:44:24[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047290325164795 -- 25-08-09 14:44:24[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046670436859131 -- 25-08-09 14:44:24[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046811103820801 -- 25-08-09 14:44:24[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047070980072021 -- 25-08-09 14:44:24[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046501159667969 -- 25-08-09 14:44:24[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025819063186646 -- 25-08-09 14:44:25[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=308 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 308 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041909217834473 -- 25-08-09 14:44:25[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=308 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1656 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015848159790039 -- 25-08-09 14:44:40[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034830570220947 -- 25-08-09 14:44:40[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034821033477783 -- 25-08-09 14:44:40[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003493070602417 -- 25-08-09 14:44:40[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031969547271729 -- 25-08-09 14:44:40[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034751892089844 -- 25-08-09 14:44:40[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023755073547363 -- 25-08-09 14:44:43[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=308 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 308 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03354811668396 -- 25-08-09 14:44:55[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1656 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021599054336548 -- 25-08-09 14:45:05[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045850276947021 -- 25-08-09 14:45:05[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045690536499023 -- 25-08-09 14:45:05[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042331218719482 -- 25-08-09 14:45:05[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046780109405518 -- 25-08-09 14:45:05[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046770572662354 -- 25-08-09 14:45:05[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021673917770386 -- 25-08-09 14:45:06[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=308 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 308 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040559768676758 -- 25-08-09 14:45:06[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=308 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1656 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01784086227417 -- 25-08-09 14:45:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036859512329102 -- 25-08-09 14:45:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036189556121826 -- 25-08-09 14:45:12[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00364089012146 -- 25-08-09 14:45:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033450126647949 -- 25-08-09 14:45:12[唐美-1656] -- /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 = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036368370056152 -- 25-08-09 14:45:12[唐美-1656] -- /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 = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030748128890991 -- 25-08-09 14:50:37[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227225%22}&event=&offwork_id=7225 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 = 7225 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040349960327148 -- 25-08-09 14:50:37[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%227225%22}&event=&offwork_id=7225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 481 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027607917785645 -- 25-08-09 14:50:46[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22308%22}&event=&quit_id=308 SELECT q.*,e.employee_name,org.org_name department,job.job_name,e.employee_no,9 appr_type_id, DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time, DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e ON q.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON e.job_id = job.job_id LEFT JOIN dbsys.sys_org org ON e.department_id = org.org_id WHERE q.quit_id = 308 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044817924499512 -- 25-08-09 14:50:46[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22308%22}&event=&quit_id=308 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 481 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019716024398804 -- 25-08-09 14:50:53[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22308%22}&event=&quit_id=308 SELECT q.*,e.employee_name,org.org_name department,job.job_name,e.employee_no,9 appr_type_id, DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time, DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e ON q.employee_id = e.employee_id LEFT JOIN dbhr.hr_job job ON e.job_id = job.job_id LEFT JOIN dbsys.sys_org org ON e.department_id = org.org_id WHERE q.quit_id = 308 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038280487060547 -- 25-08-09 14:50:53[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_quit?para={%22event%22:%22%22,%22quit_id%22:%22308%22}&event=&quit_id=308 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 481 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020187854766846 -- 25-08-09 15:10:38 -- /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.030972957611084 -- 25-08-09 15:10:38 -- /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.0034539699554443 -- 25-08-09 15:10:38 -- /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.0043158531188965 -- 25-08-09 15:10:38 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GuanGuan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035660266876221 -- 25-08-09 15:10:38[关云-169] -- /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= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019218921661377 -- 25-08-09 15:10:45[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018918037414551 -- 25-08-09 15:10:46[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7228 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 = 7228 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 25-08-09 15:10:46[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7228 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021533012390137 -- 25-08-09 15:10:48[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7228 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021410942077637 -- 25-08-09 15:10:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025583028793335 -- 25-08-09 15:10:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047750473022461 -- 25-08-09 15:10:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020421981811523 -- 25-08-09 15:10:56[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015087127685547 -- 25-08-09 15:10:57[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030139207839966 -- 25-08-09 15:10:58[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7225 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 = 7225 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036652088165283 -- 25-08-09 15:10:58[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025250911712646 -- 25-08-09 15:10:59[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020437002182007 -- 25-08-09 15:11:00[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021049976348877 -- 25-08-09 15:11:01[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7224 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 = 7224 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038950443267822 -- 25-08-09 15:11:01[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018042087554932 -- 25-08-09 15:11:03[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018499851226807 -- 25-08-09 15:11:04[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023247003555298 -- 25-08-09 15:11:04[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7223 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 = 7223 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043821334838867 -- 25-08-09 15:11:04[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7223 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019659042358398 -- 25-08-09 15:11:06[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7223 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 = 7223 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038290023803711 -- 25-08-09 15:11:06[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7223 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02078914642334 -- 25-08-09 15:11:09[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7223 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020015954971313 -- 25-08-09 15:11:09[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031444072723389 -- 25-08-09 15:11:10[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7222 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 = 7222 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041840076446533 -- 25-08-09 15:11:10[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7222 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017364025115967 -- 25-08-09 15:11:12[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7222 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019484996795654 -- 25-08-09 15:11:12[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021650075912476 -- 25-08-09 15:11:13[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7221 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 = 7221 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040140151977539 -- 25-08-09 15:11:13[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7221 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017565011978149 -- 25-08-09 15:11:17[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7221 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016385078430176 -- 25-08-09 15:11:17[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022487878799438 -- 25-08-09 15:11:18[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7220 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 = 7220 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040957927703857 -- 25-08-09 15:11:18[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7220 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018476963043213 -- 25-08-09 15:11:20[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7220 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028849124908447 -- 25-08-09 15:11:20[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020664930343628 -- 25-08-09 15:11:21[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7219 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 = 7219 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039730072021484 -- 25-08-09 15:11:21[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7219 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02069616317749 -- 25-08-09 15:11:22[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7219 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018070936203003 -- 25-08-09 15:11:23[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024483919143677 -- 25-08-09 15:11:29[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7218 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 = 7218 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035419464111328 -- 25-08-09 15:11:29[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7218 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018014907836914 -- 25-08-09 15:11:32[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7218 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030142068862915 -- 25-08-09 15:11:33[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034664154052734 -- 25-08-09 15:11:34[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7217 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 = 7217 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045690536499023 -- 25-08-09 15:11:34[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024856090545654 -- 25-08-09 15:11:35[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017971992492676 -- 25-08-09 15:11:36[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018146991729736 -- 25-08-09 15:11:36[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7214 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 = 7214 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034351348876953 -- 25-08-09 15:11:36[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026514768600464 -- 25-08-09 15:11:38[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025979042053223 -- 25-08-09 15:11:38[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021071910858154 -- 25-08-09 15:11:39[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7213 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 = 7213 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003931999206543 -- 25-08-09 15:11:39[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7213 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020027875900269 -- 25-08-09 15:11:40[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7213 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023269176483154 -- 25-08-09 15:11:41[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017640829086304 -- 25-08-09 15:11:42[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7212 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 = 7212 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032219886779785 -- 25-08-09 15:11:42[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7212 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017815113067627 -- 25-08-09 15:11:43[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7212 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017714977264404 -- 25-08-09 15:11:43[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025516986846924 -- 25-08-09 15:11:44[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7209 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 = 7209 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036869049072266 -- 25-08-09 15:11:44[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7209 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026336908340454 -- 25-08-09 15:11:45[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7209 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018164157867432 -- 25-08-09 15:11:45[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017964124679565 -- 25-08-09 15:11:46[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7205 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 = 7205 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 25-08-09 15:11:46[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018846988677979 -- 25-08-09 15:11:47[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023226022720337 -- 25-08-09 15:11:48[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025963068008423 -- 25-08-09 15:11:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7203 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 = 7203 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036060810089111 -- 25-08-09 15:11:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7203 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031378984451294 -- 25-08-09 15:11:50[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7203 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018533945083618 -- 25-08-09 15:11:51[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02904200553894 -- 25-08-09 15:11:51[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7165 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 = 7165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032291412353516 -- 25-08-09 15:11:51[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7165 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019268035888672 -- 25-08-09 15:11:53[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7165 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017611026763916 -- 25-08-09 15:11:53[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02152681350708 -- 25-08-09 15:11:54[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=212 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 212 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029001235961914 -- 25-08-09 15:11:54[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=212 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022558927536011 -- 25-08-09 15:12:02[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033859968185425 -- 25-08-09 15:12:04[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016587018966675 -- 25-08-09 15:12:10[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021229028701782 -- 25-08-09 15:12:19[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=212 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 212 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037941932678223 -- 25-08-09 15:12:19[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=212 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020899057388306 -- 25-08-09 15:13:08[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020401954650879 -- 25-08-09 15:13:08[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=212 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job,IFNULL(turnfull_job.job_name,'') turnfull_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time,DATE_FORMAT(t.effective_date,'%Y-%m-%d') effective_date, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id LEFT JOIN dbhr.hr_job turnfull_job ON t.turnfull_job_id = turnfull_job.job_id where turnfull_id = 212 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039510726928711 -- 25-08-09 15:13:08[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=212 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016937017440796 -- 25-08-09 15:42:56[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227227%22}&event=edit_offwork&offwork_id=7227 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050680637359619 -- 25-08-09 15:42:56[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227227%22}&event=edit_offwork&offwork_id=7227 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 = 7227 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032949447631836 -- 25-08-09 15:42:56[龚俊凯-846] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227227%22}&event=edit_offwork&offwork_id=7227 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 846 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026388883590698 -- 25-08-09 17:34:37 -- /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.023440837860107 -- 25-08-09 17:34:39[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050539970397949 -- 25-08-09 17:34:39[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050790309906006 -- 25-08-09 17:34:39[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055959224700928 -- 25-08-09 17:34:39[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049891471862793 -- 25-08-09 17:34:39[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050048828125 -- 25-08-09 17:34:39[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021868944168091 -- 25-08-09 17:34:49[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051949024200439 -- 25-08-09 17:34:49[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 629 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050930976867676 -- 25-08-09 17:34:49[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 336 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030795812606812 -- 25-08-09 17:35:07[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046930313110352 -- 25-08-09 17:35:07[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046770572662354 -- 25-08-09 17:35:07[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047838687896729 -- 25-08-09 17:35:07[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046567916870117 -- 25-08-09 17:35:07[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 629 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046710968017578 -- 25-08-09 17:35:07[石常发-629] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 629 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------