Time: 0.017833948135376 -- 26-01-19 07:55:56 -- /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.0035641193389893 -- 26-01-19 07:55:56 -- /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.0040249824523926 -- 26-01-19 07:55:56 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='LiZhenHan' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037350654602051 -- 26-01-19 07:55:56[李振撼-1423] -- /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= 5
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01826000213623 -- 26-01-19 07:56:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044159889221191 -- 26-01-19 07:56:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0046019554138184 -- 26-01-19 07:56:00[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011768102645874 -- 26-01-19 07:56:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043730735778809 -- 26-01-19 07:56:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0046601295471191 -- 26-01-19 07:56:00[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018462896347046 -- 26-01-19 07:56:03[李振撼-1423] -- /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 = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0094521045684814 -- 26-01-19 07:56:03[李振撼-1423] -- /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 = 5 AND c.cont_id = 1423 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0057451725006104 -- 26-01-19 07:56:03[李振撼-1423] -- /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 = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017644882202148 -- 26-01-19 07:56:32[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023468017578125 -- 26-01-19 07:56:47[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037229061126709 -- 26-01-19 07:56:47[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037140846252441 -- 26-01-19 07:56:47[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038011074066162 -- 26-01-19 07:56:47[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036561489105225 -- 26-01-19 07:56:47[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036649703979492 -- 26-01-19 07:56:47[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015849828720093 -- 26-01-19 07:56:48[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044820308685303 -- 26-01-19 07:56:48[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
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 = 8094 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030789375305176 -- 26-01-19 07:56:48[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01669979095459 -- 26-01-19 07:57:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00370192527771 -- 26-01-19 07:57:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036120414733887 -- 26-01-19 07:57:05[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037331581115723 -- 26-01-19 07:57:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036129951477051 -- 26-01-19 07:57:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036258697509766 -- 26-01-19 07:57:05[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019116878509521 -- 26-01-19 07:57:07[李振撼-1423] -- /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 = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042409896850586 -- 26-01-19 07:57:07[李振撼-1423] -- /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 = 5 AND c.cont_id = 1423 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044209957122803 -- 26-01-19 07:57:07[李振撼-1423] -- /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 = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.028880834579468 -- 26-01-19 07:57:21[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01813006401062 -- 26-01-19 07:57:30[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003925085067749 -- 26-01-19 07:57:30[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039041042327881 -- 26-01-19 07:57:30[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040099620819092 -- 26-01-19 07:57:30[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039119720458984 -- 26-01-19 07:57:30[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038859844207764 -- 26-01-19 07:57:30[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017051219940186 -- 26-01-19 07:57:31[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0049939155578613 -- 26-01-19 07:57:31[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
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 = 8094 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003352165222168 -- 26-01-19 07:57:31[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026895046234131 -- 26-01-19 07:57:34[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036699771881104 -- 26-01-19 07:57:34[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036699771881104 -- 26-01-19 07:57:34[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038950443267822 -- 26-01-19 07:57:34[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003654956817627 -- 26-01-19 07:57:34[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036518573760986 -- 26-01-19 07:57:34[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01688289642334 -- 26-01-19 07:57:35[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8095
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0048770904541016 -- 26-01-19 07:57:35[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8095
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 = 8095 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017632007598877 -- 26-01-19 07:57:37[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038540363311768 -- 26-01-19 07:57:37[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038118362426758 -- 26-01-19 07:57:37[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039160251617432 -- 26-01-19 07:57:37[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038020610809326 -- 26-01-19 07:57:37[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037899017333984 -- 26-01-19 07:57:37[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.027055025100708 -- 26-01-19 07:57:39[李振撼-1423] -- /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 = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032880306243896 -- 26-01-19 07:57:39[李振撼-1423] -- /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 = 5 AND c.cont_id = 1423 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032389163970947 -- 26-01-19 07:57:39[李振撼-1423] -- /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 = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017229080200195 -- 26-01-19 07:57:51[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016921043395996 -- 26-01-19 07:58:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036730766296387 -- 26-01-19 07:58:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036289691925049 -- 26-01-19 07:58:00[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034720897674561 -- 26-01-19 07:58:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036740303039551 -- 26-01-19 07:58:00[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036129951477051 -- 26-01-19 07:58:00[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017914056777954 -- 26-01-19 07:58:01[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8096
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0049240589141846 -- 26-01-19 07:58:01[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8096
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 = 8096 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032150745391846 -- 26-01-19 07:58:01[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8096
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018501996994019 -- 26-01-19 07:58:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039830207824707 -- 26-01-19 07:58:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040121078491211 -- 26-01-19 07:58:05[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040328502655029 -- 26-01-19 07:58:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003899097442627 -- 26-01-19 07:58:05[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039131641387939 -- 26-01-19 07:58:05[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017230987548828 -- 26-01-19 07:58:05[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8095
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044479370117188 -- 26-01-19 07:58:05[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8095
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 = 8095 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017729043960571 -- 26-01-19 07:58:08[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038409233093262 -- 26-01-19 07:58:08[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003831148147583 -- 26-01-19 07:58:08[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039238929748535 -- 26-01-19 07:58:08[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038049221038818 -- 26-01-19 07:58:08[李振撼-1423] -- /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 = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037720203399658 -- 26-01-19 07:58:08[李振撼-1423] -- /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 = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017600059509277 -- 26-01-19 07:58:09[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0047469139099121 -- 26-01-19 07:58:09[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
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 = 8094 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033819675445557 -- 26-01-19 07:58:09[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8094
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1423 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017457962036133 -- 26-01-19 08:00:20 -- /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.017577886581421 -- 26-01-19 08:00:21[肖春-283] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 283 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020449876785278 -- 26-01-19 08:55:18[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228076%22}&event=&offwork_id=8076
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 = 8076 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033829212188721 -- 26-01-19 08:55:18[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228076%22}&event=&offwork_id=8076
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 319 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017576932907104 -- 26-01-19 14:51:47 -- /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.018126964569092 -- 26-01-19 14:51: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.019232988357544 -- 26-01-19 14:51:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8052
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 = 8052 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033969879150391 -- 26-01-19 14:51:49[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8052
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026505947113037 -- 26-01-19 14:51:52[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8052
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022506952285767 -- 26-01-19 14:51: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.027707099914551 -- 26-01-19 14:51:53[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7997
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 = 7997 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033438205718994 -- 26-01-19 14:51:53[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7997
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017016172409058 -- 26-01-19 14:51:55[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7997
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016821146011353 -- 26-01-19 14:51:55[关云-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.017173051834106 -- 26-01-19 14:51:56[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7996
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 = 7996 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032999515533447 -- 26-01-19 14:51:56[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7996
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024285078048706 -- 26-01-19 14:51:58[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7996
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015748023986816 -- 26-01-19 14:51:59[关云-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.017358064651489 -- 26-01-19 14:51:59[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7995
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 = 7995 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032079219818115 -- 26-01-19 14:51:59[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7995
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018202066421509 -- 26-01-19 14:52:01[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7995
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016384840011597 -- 26-01-19 14:52:01[关云-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.024615049362183 -- 26-01-19 14:52:02[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7994
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 = 7994 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033400058746338 -- 26-01-19 14:52:02[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7994
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.027719974517822 -- 26-01-19 14:52:04[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7994
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015859127044678 -- 26-01-19 14:52: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.018440008163452 -- 26-01-19 14:52:05[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7992
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 = 7992 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032830238342285 -- 26-01-19 14:52:05[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7992
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015906810760498 -- 26-01-19 14:52:12[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7992
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016720056533813 -- 26-01-19 14:52:13[关云-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.016229152679443 -- 26-01-19 14:52:13[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7991
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 = 7991 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031218528747559 -- 26-01-19 14:52:13[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7991
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016919136047363 -- 26-01-19 14:52:15[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7991
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022442102432251 -- 26-01-19 14:52:15[关云-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.022860050201416 -- 26-01-19 14:52:16[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7990
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 = 7990 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031290054321289 -- 26-01-19 14:52:16[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7990
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015428066253662 -- 26-01-19 14:52:17[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7990
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01662802696228 -- 26-01-19 14:52:18[关云-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.020370006561279 -- 26-01-19 14:52:18[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7989
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 = 7989 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032579898834229 -- 26-01-19 14:52:18[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7989
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017527103424072 -- 26-01-19 14:52:20[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7989
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018360137939453 -- 26-01-19 14:52:21[关云-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.017646074295044 -- 26-01-19 14:52:21[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7988
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 = 7988 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032310485839844 -- 26-01-19 14:52:21[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7988
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017088890075684 -- 26-01-19 14:52:23[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7988
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.02007794380188 -- 26-01-19 14:52: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.048022031784058 -- 26-01-19 14:52:24[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7982
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 = 7982 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032269954681396 -- 26-01-19 14:52:24[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7982
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017928838729858 -- 26-01-19 14:52:26[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7982
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 169 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01724100112915 -- 26-01-19 14:52:26[关云-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.01601505279541 -- 26-01-19 14:55:31[郭荣波-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.020093202590942 -- 26-01-19 14:55:32[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7990
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 = 7990 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035781860351562 -- 26-01-19 14:55:32[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=7990
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 35 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023438930511475 -- 26-01-19 14:55:34[郭荣波-35] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=7990
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 35 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015722990036011 -- 26-01-19 14:55:34[郭荣波-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.017438173294067 -- 26-01-19 17:54:24 -- /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.0034258365631104 -- 26-01-19 17:54:24 -- /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.004345178604126 -- 26-01-19 17:54:24 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='SongYueYang' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037078857421875 -- 26-01-19 17:54:24[宋玥瑒-2340] -- /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= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017936944961548 -- 26-01-19 17:54:24[宋玥瑒-2340] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2340 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021927118301392 -- 26-01-19 21:02:22[李贵-641] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227891%22}&event=edit_offwork&offwork_id=7891
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010928153991699 -- 26-01-19 21:02:22[李贵-641] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227891%22}&event=edit_offwork&offwork_id=7891
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 = 7891 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033760070800781 -- 26-01-19 21:02:22[李贵-641] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227891%22}&event=edit_offwork&offwork_id=7891
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 641 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019260168075562 -- 26-01-19 21:02:35[李贵-641] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227891%22}&event=edit_offwork&offwork_id=7891
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032889842987061 -- 26-01-19 21:02:35[李贵-641] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227891%22}&event=edit_offwork&offwork_id=7891
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 = 7891 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032479763031006 -- 26-01-19 21:02:35[李贵-641] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%227891%22}&event=edit_offwork&offwork_id=7891
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 641 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------