Time: 0.016595125198364 -- 26-01-02 12:38:14 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017185926437378 -- 26-01-02 12:38:29 -- /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.0035910606384277 -- 26-01-02 12:38:29 -- /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.0045349597930908 -- 26-01-02 12:38:29 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='DuoYuDeAn' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037782192230225 -- 26-01-02 12:38:29[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.031338930130005 -- 26-01-02 12:38:36[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044760704040527 -- 26-01-02 12:38:36[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0053040981292725 -- 26-01-02 12:38:36[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013998985290527 -- 26-01-02 12:38:36[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0047328472137451 -- 26-01-02 12:38:36[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0052762031555176 -- 26-01-02 12:38:36[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.03022313117981 -- 26-01-02 12:38:41[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0065679550170898 -- 26-01-02 12:38:41[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 9 AND c.cont_id = 383 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043849945068359 -- 26-01-02 12:38:41[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026792049407959 -- 26-01-02 12:38:46[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035970211029053 -- 26-01-02 12:38:46[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035710334777832 -- 26-01-02 12:38:46[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038149356842041 -- 26-01-02 12:38:46[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035178661346436 -- 26-01-02 12:38:46[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035331249237061 -- 26-01-02 12:38:46[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017547130584717 -- 26-01-02 12:38:48[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7972
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081019401550293 -- 26-01-02 12:38:48[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7972
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 = 7972 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035378932952881 -- 26-01-02 12:38:48[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7972
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 383 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017191171646118 -- 26-01-02 12:38:53[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037229061126709 -- 26-01-02 12:38:53[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037040710449219 -- 26-01-02 12:38:53[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041429996490479 -- 26-01-02 12:38:53[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036759376525879 -- 26-01-02 12:38:53[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036489963531494 -- 26-01-02 12:38:53[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016793012619019 -- 26-01-02 12:38:54[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7973
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0055408477783203 -- 26-01-02 12:38:54[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7973
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 = 7973 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032720565795898 -- 26-01-02 12:38:54[陈浩平-383] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7973
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 383 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018908023834229 -- 26-01-02 12:38:57[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040647983551025 -- 26-01-02 12:38:57[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040261745452881 -- 26-01-02 12:38:57[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043630599975586 -- 26-01-02 12:38:57[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040240287780762 -- 26-01-02 12:38:57[陈浩平-383] -- /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 = 383 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040309429168701 -- 26-01-02 12:38:57[陈浩平-383] -- /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 = 383 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------