Time: 0.017163991928101 -- 25-05-05 11:22:11 -- /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.0034909248352051 -- 25-05-05 11:22:12 -- /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.0039408206939697 -- 25-05-05 11:22:12 -- /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='JiaoWoAiTa' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036818981170654 -- 25-05-05 11:22:12[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0292809009552 -- 25-05-05 11:22:13[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042870044708252 -- 25-05-05 11:22:13[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043041706085205 -- 25-05-05 11:22:13[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0050270557403564 -- 25-05-05 11:22:13[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041990280151367 -- 25-05-05 11:22:13[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.004223108291626 -- 25-05-05 11:22:13[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.028530120849609 -- 25-05-05 11:22:14[郝豪-624] -- /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 = 624 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0048990249633789 -- 25-05-05 11:22:14[郝豪-624] -- /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 = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015791893005371 -- 25-05-05 11:22:21[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00343918800354 -- 25-05-05 11:22:21[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034430027008057 -- 25-05-05 11:22:21[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035080909729004 -- 25-05-05 11:22:21[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033998489379883 -- 25-05-05 11:22:21[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034110546112061 -- 25-05-05 11:22:21[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025659084320068 -- 25-05-05 11:54:55[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226029%22}&event=edit_offwork&offwork_id=6029
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 = 6029 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041317939758301 -- 25-05-05 11:54:55[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226029%22}&event=edit_offwork&offwork_id=6029
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01972508430481 -- 25-05-05 11:55:00[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226171%22}&event=edit_offwork&offwork_id=6171
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 = 6171 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037639141082764 -- 25-05-05 11:55:00[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226171%22}&event=edit_offwork&offwork_id=6171
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017696142196655 -- 25-05-05 11:55:02 -- /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.016382932662964 -- 25-05-05 11:55:04[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031909942626953 -- 25-05-05 11:55:04[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035150051116943 -- 25-05-05 11:55:04[刘云恒-1723] -- /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 = 1723 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039448738098145 -- 25-05-05 11:55:04[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034799575805664 -- 25-05-05 11:55:04[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035078525543213 -- 25-05-05 11:55:04[刘云恒-1723] -- /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 = 1723 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021543979644775 -- 25-05-05 11:55:06[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226186%22}&event=edit_offwork&offwork_id=6186
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 = 6186 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034799575805664 -- 25-05-05 11:55:06[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226186%22}&event=edit_offwork&offwork_id=6186
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019701957702637 -- 25-05-05 11:55:09[刘云恒-1723] -- /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 = 1723 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.004734992980957 -- 25-05-05 11:55:09[刘云恒-1723] -- /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 = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025352954864502 -- 25-05-05 11:55:09[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
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 = 6199 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031440258026123 -- 25-05-05 11:55:09[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019397020339966 -- 25-05-05 11:55:12[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
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 = 6220 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034282207489014 -- 25-05-05 11:55:12[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020076036453247 -- 25-05-05 11:55:22[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037169456481934 -- 25-05-05 11:55:22[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036358833312988 -- 25-05-05 11:55:22[刘云恒-1723] -- /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 = 1723 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033409595489502 -- 25-05-05 11:55:22[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036420822143555 -- 25-05-05 11:55:22[刘云恒-1723] -- /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 = 1723 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036330223083496 -- 25-05-05 11:55:22[刘云恒-1723] -- /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 = 1723 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.029310941696167 -- 25-05-05 11:55:22[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
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 = 6199 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034019947052002 -- 25-05-05 11:55:22[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019091844558716 -- 25-05-05 11:55:31[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
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 = 6220 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037751197814941 -- 25-05-05 11:55:31[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.030275106430054 -- 25-05-05 11:55:38[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
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 = 6220 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040328502655029 -- 25-05-05 11:55:38[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023006916046143 -- 25-05-05 11:55:43[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
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 = 6199 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031659603118896 -- 25-05-05 11:55:43[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017494916915894 -- 25-05-05 11:55:52[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
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 = 6220 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034182071685791 -- 25-05-05 11:55:52[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226220%22}&event=edit_offwork&offwork_id=6220
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024399995803833 -- 25-05-05 11:56:02[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
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 = 6199 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036671161651611 -- 25-05-05 11:56:02[郝豪-624] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226199%22}&event=edit_offwork&offwork_id=6199
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 624 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016435146331787 -- 25-05-05 11:56:22[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035710334777832 -- 25-05-05 11:56:22[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035650730133057 -- 25-05-05 11:56:23[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033278465270996 -- 25-05-05 11:56:23[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036258697509766 -- 25-05-05 11:56:23[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035488605499268 -- 25-05-05 11:56:23[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.02051305770874 -- 25-05-05 11:56:42[郝豪-624] -- /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 = 624 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0046079158782959 -- 25-05-05 11:56:42[郝豪-624] -- /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 = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01947808265686 -- 25-05-05 11:57:04[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041539669036865 -- 25-05-05 11:57:04[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041630268096924 -- 25-05-05 11:57:04[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042359828948975 -- 25-05-05 11:57:04[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040960311889648 -- 25-05-05 11:57:04[郝豪-624] -- /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 = 624 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041179656982422 -- 25-05-05 11:57:04[郝豪-624] -- /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 = 624 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0190269947052 -- 25-05-05 15:09:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037930011749268 -- 25-05-05 15:09:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p 
where p.appid='ww5262fb147810c303' and isenable=1  and publicno_type_id=2 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043320655822754 -- 25-05-05 15:09:38 -- /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='LiZhenFeng' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040378570556641 -- 25-05-05 15:09:38[李振凤-1163] -- /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= 11
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026376008987427 -- 25-05-05 15:09:39[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type 
 FROM dbhr.hr_recruitapply 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043950080871582 -- 25-05-05 15:09:39[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type 
 FROM dbhr.hr_turnfull 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043270587921143 -- 25-05-05 15:09:39[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type 
 FROM dbhr.hr_change 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00490403175354 -- 25-05-05 15:09:39[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type 
 FROM dbhr.hr_offwork 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043370723724365 -- 25-05-05 15:09:39[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type 
 FROM dbhr.hr_quit 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042910575866699 -- 25-05-05 15:09:39[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type 
 FROM dbhr.hr_fired 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021385192871094 -- 25-05-05 15:09:41[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6247
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 = 6247 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036139488220215 -- 25-05-05 15:09:41[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6247
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1163 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01820707321167 -- 25-05-05 15:09:46[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type 
 FROM dbhr.hr_recruitapply 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039160251617432 -- 25-05-05 15:09:46[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type 
 FROM dbhr.hr_turnfull 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038909912109375 -- 25-05-05 15:09:46[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type 
 FROM dbhr.hr_change 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039770603179932 -- 25-05-05 15:09:46[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type 
 FROM dbhr.hr_offwork 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003870964050293 -- 25-05-05 15:09:46[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type 
 FROM dbhr.hr_quit 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00384521484375 -- 25-05-05 15:09:46[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type 
 FROM dbhr.hr_fired 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018094062805176 -- 25-05-05 17:17:44[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type 
 FROM dbhr.hr_recruitapply 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037081241607666 -- 25-05-05 17:17:44[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type 
 FROM dbhr.hr_turnfull 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035779476165771 -- 25-05-05 17:17:44[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type 
 FROM dbhr.hr_change 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003605842590332 -- 25-05-05 17:17:44[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type 
 FROM dbhr.hr_offwork 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003493070602417 -- 25-05-05 17:17:44[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type 
 FROM dbhr.hr_quit 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035450458526611 -- 25-05-05 17:17:44[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type 
 FROM dbhr.hr_fired 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017193794250488 -- 25-05-05 17:17:49[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 11 AND c.cont_id = 1163 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040419101715088 -- 25-05-05 17:17:49[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 160 and acct_id = 11 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021633863449097 -- 25-05-05 17:18:01[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type 
 FROM dbhr.hr_recruitapply 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034070014953613 -- 25-05-05 17:18:01[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type 
 FROM dbhr.hr_turnfull 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034129619598389 -- 25-05-05 17:18:01[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type 
 FROM dbhr.hr_change 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035538673400879 -- 25-05-05 17:18:01[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type 
 FROM dbhr.hr_offwork 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033960342407227 -- 25-05-05 17:18:01[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type 
 FROM dbhr.hr_quit 
WHERE createdby_id = 1163 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034351348876953 -- 25-05-05 17:18:01[李振凤-1163] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type 
 FROM dbhr.hr_fired 
WHERE createdby_id = 1163 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016638040542603 -- 25-05-05 21:17:49 -- /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.0032520294189453 -- 25-05-05 21:17:49 -- /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.0040240287780762 -- 25-05-05 21:17:49 -- /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.0035388469696045 -- 25-05-05 21:17:49[唐美-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.017109155654907 -- 25-05-05 21:17:50[唐美-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.0038008689880371 -- 25-05-05 21:17:50[唐美-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.0037839412689209 -- 25-05-05 21:17:50[唐美-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.0037839412689209 -- 25-05-05 21:17:50[唐美-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.003741979598999 -- 25-05-05 21:17:50[唐美-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.0037648677825928 -- 25-05-05 21:17:50[唐美-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.025714874267578 -- 25-05-05 21:17:52[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 15 AND c.cont_id = 1656 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044829845428467 -- 25-05-05 21:17:52[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.027416944503784 -- 25-05-05 21:18:52[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1656 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023661136627197 -- 25-05-05 21:19:11[唐美-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.0034060478210449 -- 25-05-05 21:19:11[唐美-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.0033540725708008 -- 25-05-05 21:19:11[唐美-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.0033659934997559 -- 25-05-05 21:19:11[唐美-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.0033209323883057 -- 25-05-05 21:19:11[唐美-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.0033209323883057 -- 25-05-05 21:19:11[唐美-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.022094011306763 -- 25-05-05 21:19:13[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6252
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 = 6252 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039339065551758 -- 25-05-05 21:19:13[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6252
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1656 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018368005752563 -- 25-05-05 21:19:54[唐美-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.0036661624908447 -- 25-05-05 21:19:54[唐美-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.0036609172821045 -- 25-05-05 21:19:54[唐美-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.0036888122558594 -- 25-05-05 21:19:54[唐美-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.0036420822143555 -- 25-05-05 21:19:54[唐美-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.0036449432373047 -- 25-05-05 21:19:54[唐美-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.019998788833618 -- 25-05-05 21:19:55[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 15 AND c.cont_id = 1656 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033159255981445 -- 25-05-05 21:19:55[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025793075561523 -- 25-05-05 21:36:49[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226252%22}&event=&offwork_id=6252
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 = 6252 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037460327148438 -- 25-05-05 21:36:49[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226252%22}&event=&offwork_id=6252
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018779039382935 -- 25-05-05 21:36:53[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6252
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020303010940552 -- 25-05-05 21:36:54[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023214817047119 -- 25-05-05 21:36:55[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226252%22}&event=&offwork_id=6252
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 = 6252 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030360221862793 -- 25-05-05 21:36:55[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226252%22}&event=&offwork_id=6252
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019896984100342 -- 25-05-05 21:36:59[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226252%22}&event=&offwork_id=6252
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 = 6252 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039050579071045 -- 25-05-05 21:36:59[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226252%22}&event=&offwork_id=6252
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017723083496094 -- 25-05-05 21:40:11[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226252%22}&event=edit_offwork&offwork_id=6252
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 = 6252 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033159255981445 -- 25-05-05 21:40:11[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226252%22}&event=edit_offwork&offwork_id=6252
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1656 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------