Time: 0.016480922698975 -- 26-01-08 10:20:26[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0054349899291992 -- 26-01-08 10:20:26[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
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 = 7861 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031559467315674 -- 26-01-08 10:20:26[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016889095306396 -- 26-01-08 10:22:53[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0053989887237549 -- 26-01-08 10:22:53[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
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 = 7861 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032839775085449 -- 26-01-08 10:22:53[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015820980072021 -- 26-01-08 10:23:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0045461654663086 -- 26-01-08 10:23:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
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 = 7861 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030560493469238 -- 26-01-08 10:23:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?para=%7B%22event%22:%22edit_offwork%22,%22offwork_id%22:%227861%22%7D&event=edit_offwork&offwork_id=7861
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018864870071411 -- 26-01-08 10:30:44[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0051300525665283 -- 26-01-08 10:30:44[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044798851013184 -- 26-01-08 10:30:44[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043962001800537 -- 26-01-08 10:30:44[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0053157806396484 -- 26-01-08 10:30:44[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0058231353759766 -- 26-01-08 10:30:44[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018126010894775 -- 26-01-08 10:30:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039689540863037 -- 26-01-08 10:30:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003931999206543 -- 26-01-08 10:30:49[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )AND status_id = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003943920135498 -- 26-01-08 10:30:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003889799118042 -- 26-01-08 10:30:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039119720458984 -- 26-01-08 10:30:49[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )AND status_id = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016526937484741 -- 26-01-08 10:30:52[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036959648132324 -- 26-01-08 10:30:52[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036280155181885 -- 26-01-08 10:30:52[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036239624023438 -- 26-01-08 10:30:52[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035970211029053 -- 26-01-08 10:30:52[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035779476165771 -- 26-01-08 10:30:52[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01698112487793 -- 26-01-08 10:30:55[袁星嵘-2330] -- /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 = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038881301879883 -- 26-01-08 10:30:55[袁星嵘-2330] -- /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 = 15 AND c.cont_id = 2330 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042259693145752 -- 26-01-08 10:30:55[袁星嵘-2330] -- /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 = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023849964141846 -- 26-01-08 10:31:40[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025017976760864 -- 26-01-08 10:32:15[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037310123443604 -- 26-01-08 10:32:15[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036599636077881 -- 26-01-08 10:32:15[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036630630493164 -- 26-01-08 10:32:15[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036368370056152 -- 26-01-08 10:32:15[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036439895629883 -- 26-01-08 10:32:15[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016322135925293 -- 26-01-08 10:32:19[袁星嵘-2330] -- /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 = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036990642547607 -- 26-01-08 10:32:19[袁星嵘-2330] -- /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 = 15 AND c.cont_id = 2330 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041460990905762 -- 26-01-08 10:32:19[袁星嵘-2330] -- /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 = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019647121429443 -- 26-01-08 10:33:13[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017116069793701 -- 26-01-08 10:33:22[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037181377410889 -- 26-01-08 10:33:22[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003713846206665 -- 26-01-08 10:33:22[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003371000289917 -- 26-01-08 10:33:22[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037229061126709 -- 26-01-08 10:33:22[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036909580230713 -- 26-01-08 10:33:22[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.027010917663574 -- 26-01-08 10:35:14[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228058%22}&event=&offwork_id=8058
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 = 8058 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035231113433838 -- 26-01-08 10:35:14[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228058%22}&event=&offwork_id=8058
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016292095184326 -- 26-01-08 10:35:17[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8058
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.028799057006836 -- 26-01-08 10:35:18[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228058%22}&event=&offwork_id=8058
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 = 8058 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034270286560059 -- 26-01-08 10:35:18[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228058%22}&event=&offwork_id=8058
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01823616027832 -- 26-01-08 10:35:21[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032820701599121 -- 26-01-08 10:35:21[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015583992004395 -- 26-01-08 10:35:25[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.02109694480896 -- 26-01-08 10:35:25[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00337815284729 -- 26-01-08 10:35:25[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019551992416382 -- 26-01-08 10:35:28[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228058%22}&event=&offwork_id=8058
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 = 8058 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035159587860107 -- 26-01-08 10:35:28[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228058%22}&event=&offwork_id=8058
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022670030593872 -- 26-01-08 10:35:32[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030758380889893 -- 26-01-08 10:35:32[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016411066055298 -- 26-01-08 10:35:33[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025718927383423 -- 26-01-08 10:35:33[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030879974365234 -- 26-01-08 10:35:33[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017557144165039 -- 26-01-08 10:35:36[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031130313873291 -- 26-01-08 10:35:36[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017379999160767 -- 26-01-08 10:35:37[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023988008499146 -- 26-01-08 10:35:37[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032119750976562 -- 26-01-08 10:35:37[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021767139434814 -- 26-01-08 10:35:40[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003007173538208 -- 26-01-08 10:35:40[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015578985214233 -- 26-01-08 10:35:41[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017257928848267 -- 26-01-08 10:35:42[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033588409423828 -- 26-01-08 10:35:42[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026407957077026 -- 26-01-08 10:35:44[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228048%22}&event=&offwork_id=8048
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 = 8048 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032398700714111 -- 26-01-08 10:35:44[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228048%22}&event=&offwork_id=8048
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017420053482056 -- 26-01-08 10:35:52 -- /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.0034110546112061 -- 26-01-08 10:35:52 -- /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.0040600299835205 -- 26-01-08 10:35:52 -- /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='YuanXingRong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037810802459717 -- 26-01-08 10:35:52[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022020101547241 -- 26-01-08 10:35:53[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038080215454102 -- 26-01-08 10:35:53[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003803014755249 -- 26-01-08 10:35:53[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003352165222168 -- 26-01-08 10:35:53[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038051605224609 -- 26-01-08 10:35:53[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038549900054932 -- 26-01-08 10:35:53[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017620086669922 -- 26-01-08 10:35:54[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041348934173584 -- 26-01-08 10:35:54[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033841133117676 -- 26-01-08 10:35:54[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017984867095947 -- 26-01-08 10:36:00[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039529800415039 -- 26-01-08 10:36:00[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039281845092773 -- 26-01-08 10:36:00[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003568172454834 -- 26-01-08 10:36:00[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038800239562988 -- 26-01-08 10:36:00[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038559436798096 -- 26-01-08 10:36:00[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017046928405762 -- 26-01-08 10:36:02[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8058
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.004802942276001 -- 26-01-08 10:36:02[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8058
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 = 8058 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032138824462891 -- 26-01-08 10:36:02[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8058
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01807689666748 -- 26-01-08 10:36:10[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039141178131104 -- 26-01-08 10:36:10[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038762092590332 -- 26-01-08 10:36:10[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035400390625 -- 26-01-08 10:36:10[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038340091705322 -- 26-01-08 10:36:10[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038719177246094 -- 26-01-08 10:36:10[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.028630018234253 -- 26-01-08 10:36:20 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033550262451172 -- 26-01-08 10:36:20 -- /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.0038471221923828 -- 26-01-08 10:36:20 -- /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='YuanXingRong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036067962646484 -- 26-01-08 10:36:20[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016949892044067 -- 26-01-08 10:36:20[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034441947937012 -- 26-01-08 10:36:20[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034677982330322 -- 26-01-08 10:36:20[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034759044647217 -- 26-01-08 10:36:20[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034439563751221 -- 26-01-08 10:36:20[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034239292144775 -- 26-01-08 10:36:20[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01776385307312 -- 26-01-08 10:36:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038180351257324 -- 26-01-08 10:36:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031468868255615 -- 26-01-08 10:36:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015805959701538 -- 26-01-08 10:37:06 -- /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.0030858516693115 -- 26-01-08 10:37:06 -- /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.0039629936218262 -- 26-01-08 10:37:06 -- /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='YuanXingRong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033450126647949 -- 26-01-08 10:37:06[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024940967559814 -- 26-01-08 10:37:07[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033721923828125 -- 26-01-08 10:37:07[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033321380615234 -- 26-01-08 10:37:07[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033578872680664 -- 26-01-08 10:37:07[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033318996429443 -- 26-01-08 10:37:07[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033109188079834 -- 26-01-08 10:37:07[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018754005432129 -- 26-01-08 10:37:07[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042488574981689 -- 26-01-08 10:37:08[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036470890045166 -- 26-01-08 10:37:08[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017225027084351 -- 26-01-08 10:41:21 -- /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.003385066986084 -- 26-01-08 10:41:21 -- /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.0042929649353027 -- 26-01-08 10:41:21 -- /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='YuanXingRong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036718845367432 -- 26-01-08 10:41:21[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01664400100708 -- 26-01-08 10:41:21[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037190914154053 -- 26-01-08 10:41:21[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037109851837158 -- 26-01-08 10:41:21[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036289691925049 -- 26-01-08 10:41:21[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037081241607666 -- 26-01-08 10:41:21[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037200450897217 -- 26-01-08 10:41:21[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016751050949097 -- 26-01-08 10:41:22[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0048239231109619 -- 26-01-08 10:41:22[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032689571380615 -- 26-01-08 10:41:22[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016373157501221 -- 26-01-08 10:42:22 -- /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.0032479763031006 -- 26-01-08 10:42:22 -- /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.0042951107025146 -- 26-01-08 10:42:22 -- /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='SongYueYang' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003619909286499 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01713490486145 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003687858581543 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037178993225098 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003662109375 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036830902099609 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003676176071167 -- 26-01-08 10:42:22[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017822980880737 -- 26-01-08 10:42:25[宋玥瑒-2340] -- /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 = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043771266937256 -- 26-01-08 10:42:25[宋玥瑒-2340] -- /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 = 15 AND c.cont_id = 2340 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017174959182739 -- 26-01-08 10:47:00 -- /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.016496181488037 -- 26-01-08 10:47:01[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036990642547607 -- 26-01-08 10:47:01[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036880970001221 -- 26-01-08 10:47:01[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036671161651611 -- 26-01-08 10:47:01[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00364089012146 -- 26-01-08 10:47:01[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036709308624268 -- 26-01-08 10:47:01[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017811059951782 -- 26-01-08 10:47:03[宋玥瑒-2340] -- /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 = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0045230388641357 -- 26-01-08 10:47:03[宋玥瑒-2340] -- /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 = 15 AND c.cont_id = 2340 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017434120178223 -- 26-01-08 10:47:06[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037980079650879 -- 26-01-08 10:47:06[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038049221038818 -- 26-01-08 10:47:06[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037670135498047 -- 26-01-08 10:47:06[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037648677825928 -- 26-01-08 10:47:06[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037851333618164 -- 26-01-08 10:47:06[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015839099884033 -- 26-01-08 10:49:26 -- /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.016338109970093 -- 26-01-08 10:49:39[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035769939422607 -- 26-01-08 10:49:39[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035581588745117 -- 26-01-08 10:49:39[张孝然-2181] -- /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 = 2181 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0048317909240723 -- 26-01-08 10:49:39[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035810470581055 -- 26-01-08 10:49:39[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035688877105713 -- 26-01-08 10:49:39[张孝然-2181] -- /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 = 2181 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022616863250732 -- 26-01-08 10:49:43[张孝然-2181] -- /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 = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044169425964355 -- 26-01-08 10:49:43[张孝然-2181] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 15 AND c.cont_id = 2181 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043208599090576 -- 26-01-08 10:49:43[张孝然-2181] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016853094100952 -- 26-01-08 10:50:53[张孝然-2181] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2181 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020792961120605 -- 26-01-08 10:51:20[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003849983215332 -- 26-01-08 10:51:20[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038299560546875 -- 26-01-08 10:51:20[张孝然-2181] -- /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 = 2181 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035169124603271 -- 26-01-08 10:51:20[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038039684295654 -- 26-01-08 10:51:20[张孝然-2181] -- /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 = 2181 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003788948059082 -- 26-01-08 10:51:20[张孝然-2181] -- /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 = 2181 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016263008117676 -- 26-01-08 10:54:42 -- /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.017359018325806 -- 26-01-08 10:54:42 -- /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.0040299892425537 -- 26-01-08 10:54:42 -- /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.0044081211090088 -- 26-01-08 10:54:42 -- /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='AMeng' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037739276885986 -- 26-01-08 10:54:42[李明娥-478] -- /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.016411781311035 -- 26-01-08 10:54:42[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023355960845947 -- 26-01-08 10:54:49[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003122091293335 -- 26-01-08 10:54:49[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017234086990356 -- 26-01-08 10:54:54[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017200946807861 -- 26-01-08 10:54:54[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.029000997543335 -- 26-01-08 10:54:56[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033450126647949 -- 26-01-08 10:54:56[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015411853790283 -- 26-01-08 10:55:03[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015531063079834 -- 26-01-08 10:55:03[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019184827804565 -- 26-01-08 10:55:04[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034060478210449 -- 26-01-08 10:55:04[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016571998596191 -- 26-01-08 10:55:07[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016456842422485 -- 26-01-08 10:55:07[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026977062225342 -- 26-01-08 10:55:08[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032310485839844 -- 26-01-08 10:55:08[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020679950714111 -- 26-01-08 10:55:16[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015748977661133 -- 26-01-08 10:55:17[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 478 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015934944152832 -- 26-01-08 10:55:22 -- /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.017260789871216 -- 26-01-08 10:55:24[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037589073181152 -- 26-01-08 10:55:24[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003748893737793 -- 26-01-08 10:55:24[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033559799194336 -- 26-01-08 10:55:24[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037040710449219 -- 26-01-08 10:55:24[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037240982055664 -- 26-01-08 10:55:24[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016661167144775 -- 26-01-08 10:55:25[宋玥瑒-2340] -- /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 = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036880970001221 -- 26-01-08 10:55:25[宋玥瑒-2340] -- /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 = 15 AND c.cont_id = 2340 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023063898086548 -- 26-01-08 10:55:28[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003803014755249 -- 26-01-08 10:55:28[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036771297454834 -- 26-01-08 10:55:28[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033340454101562 -- 26-01-08 10:55:28[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00370192527771 -- 26-01-08 10:55:28[宋玥瑒-2340] -- /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 = 2340 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036449432373047 -- 26-01-08 10:55:28[宋玥瑒-2340] -- /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 = 2340 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017863988876343 -- 26-01-08 11:00:46[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228059%22}&event=&offwork_id=8059
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 = 8059 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032169818878174 -- 26-01-08 11:00:46[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228059%22}&event=&offwork_id=8059
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017048835754395 -- 26-01-08 11:00:53[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8059
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018274068832397 -- 26-01-08 11:00:53[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228059%22}&event=&offwork_id=8059
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 = 8059 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033130645751953 -- 26-01-08 11:00:53[罗霞-481] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228059%22}&event=&offwork_id=8059
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 481 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017564058303833 -- 26-01-08 11:06:42[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032098293304443 -- 26-01-08 11:06:42[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016646146774292 -- 26-01-08 11:06:50[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016618967056274 -- 26-01-08 11:06:50[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032389163970947 -- 26-01-08 11:06:50[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017313003540039 -- 26-01-08 11:06:54[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031430721282959 -- 26-01-08 11:06:54[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016178131103516 -- 26-01-08 11:06:59[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018752813339233 -- 26-01-08 11:06:59[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033600330352783 -- 26-01-08 11:06:59[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0211501121521 -- 26-01-08 11:07:04[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031399726867676 -- 26-01-08 11:07:04[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017374992370605 -- 26-01-08 11:07:13[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023282051086426 -- 26-01-08 11:07:13[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003277063369751 -- 26-01-08 11:07:13[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018433094024658 -- 26-01-08 11:07:19[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033140182495117 -- 26-01-08 11:07:19[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016516923904419 -- 26-01-08 11:07:31[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019771099090576 -- 26-01-08 11:07:31[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030300617218018 -- 26-01-08 11:07:31[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015947103500366 -- 26-01-08 11:07:38[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030989646911621 -- 26-01-08 11:07:38[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018011093139648 -- 26-01-08 11:07:52[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032010078430176 -- 26-01-08 11:07:52[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228055%22}&event=&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018410921096802 -- 26-01-08 11:07:59[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030829906463623 -- 26-01-08 11:07:59[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228057%22}&event=&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021830081939697 -- 26-01-08 11:08:02[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033531188964844 -- 26-01-08 11:08:02[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228054%22}&event=&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018695831298828 -- 26-01-08 11:08:06[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
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 = 8053 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034141540527344 -- 26-01-08 11:08:06[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228053%22}&event=&offwork_id=8053
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016921997070312 -- 26-01-08 11:08:13[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228048%22}&event=&offwork_id=8048
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 = 8048 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032589435577393 -- 26-01-08 11:08:13[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228048%22}&event=&offwork_id=8048
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 484 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016577959060669 -- 26-01-08 12:10:40[肖飞飞-477] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 477 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015901803970337 -- 26-01-08 12:59:15 -- /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.0031301975250244 -- 26-01-08 12:59:15 -- /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.0036988258361816 -- 26-01-08 12:59:15 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='FuYou' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035030841827393 -- 26-01-08 12:59:15[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018113851547241 -- 26-01-08 13:00:14[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type 
 FROM dbhr.hr_recruitapply 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039842128753662 -- 26-01-08 13:00:14[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type 
 FROM dbhr.hr_turnfull 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039939880371094 -- 26-01-08 13:00:14[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type 
 FROM dbhr.hr_change 
WHERE createdby_id = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0048480033874512 -- 26-01-08 13:00:14[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type 
 FROM dbhr.hr_offwork 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038518905639648 -- 26-01-08 13:00:14[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type 
 FROM dbhr.hr_quit 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038480758666992 -- 26-01-08 13:00:14[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type 
 FROM dbhr.hr_fired 
WHERE createdby_id = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020104169845581 -- 26-01-08 13:00:18[符金辉-380] -- /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.0045359134674072 -- 26-01-08 13:00:18[符金辉-380] -- /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 = 380 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.004439115524292 -- 26-01-08 13:00:18[符金辉-380] -- /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.021111011505127 -- 26-01-08 13:00:20[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type 
 FROM dbhr.hr_recruitapply 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034141540527344 -- 26-01-08 13:00:20[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type 
 FROM dbhr.hr_turnfull 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034029483795166 -- 26-01-08 13:00:20[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type 
 FROM dbhr.hr_change 
WHERE createdby_id = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0040090084075928 -- 26-01-08 13:00:20[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type 
 FROM dbhr.hr_offwork 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003371000289917 -- 26-01-08 13:00:20[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type 
 FROM dbhr.hr_quit 
WHERE createdby_id = 380 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003371000289917 -- 26-01-08 13:00:20[符金辉-380] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query
SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type 
 FROM dbhr.hr_fired 
WHERE createdby_id = 380 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017219066619873 -- 26-01-08 13:05:58 -- /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.01734185218811 -- 26-01-08 13:19: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.016618967056274 -- 26-01-08 13:19:56[卓锡定-2096] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2096 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020830154418945 -- 26-01-08 14:50:35 -- /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.003364086151123 -- 26-01-08 14:50:35 -- /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.0042448043823242 -- 26-01-08 14:50:35 -- /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='YuanXingRong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036308765411377 -- 26-01-08 14:50:35[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017275094985962 -- 26-01-08 14:50:35[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037260055541992 -- 26-01-08 14:50:35[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037071704864502 -- 26-01-08 14:50:35[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037248134613037 -- 26-01-08 14:50:35[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036959648132324 -- 26-01-08 14:50:35[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036900043487549 -- 26-01-08 14:50:35[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016536951065063 -- 26-01-08 14:50:36[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0051419734954834 -- 26-01-08 14:50:36[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
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 = 8057 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031790733337402 -- 26-01-08 14:50:36[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8057
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017899036407471 -- 26-01-08 14:50:41[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039279460906982 -- 26-01-08 14:50:41[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00388503074646 -- 26-01-08 14:50:41[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039131641387939 -- 26-01-08 14:50:41[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038809776306152 -- 26-01-08 14:50:41[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038549900054932 -- 26-01-08 14:50:41[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018832921981812 -- 26-01-08 14:50:42[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8058
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038580894470215 -- 26-01-08 14:50:42[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8058
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 = 8058 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030410289764404 -- 26-01-08 14:50:42[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8058
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017752885818481 -- 26-01-08 14:50:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038700103759766 -- 26-01-08 14:50:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038788318634033 -- 26-01-08 14:50:49[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038561820983887 -- 26-01-08 14:50:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038039684295654 -- 26-01-08 14:50:49[袁星嵘-2330] -- /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 = 2330 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038101673126221 -- 26-01-08 14:50:49[袁星嵘-2330] -- /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 = 2330 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017390966415405 -- 26-01-08 19:51:16[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para=%7B%22event%22:%22edit_turnfull%22,%22turnfull_id%22:%22276%22%7D&event=edit_turnfull&turnfull_id=276
SELECT tf.turnfull_id,tf.turnfull_no,tf.owner_id,tf.status_id,tf.employee_id,tf.employee_name,tf.employee_no,tf.department_id, 
DATE_FORMAT(tf.entry_time,'%Y-%m-%d') entry_time,tf.createdon,tf.updatedon,tf.trial_job_id,tf.trial_salary,tf.firstMonth_assess, 
tf.secondMonth_assess,tf.thirdMonth_assess,tf.trial_goodresult,tf.trial_ability,tf.brief_summary,tf.self_evaluation, 
DATE_FORMAT(tf.apply_date,'%Y-%m-%d') apply_date,tf.appr_proc_id,tf.cur_appr_id_str,org.org_name department, 
apro.appr_proc_name,job.job_name trial_job,IFNULL(DATE_FORMAT(tf.effective_date,'%Y-%m-%d'),'') effective_date, 
IFNULL(turnfull_job.job_name,'') turnfull_job,IFNULL(tf.turnfull_salary,'') turnfull_salary 
FROM dbhr.hr_turnfull tf 
LEFT JOIN dboa.oa_appr_process apro ON tf.appr_proc_id = apro.appr_proc_id 
LEFT JOIN dbhr.hr_job job ON tf.trial_job_id = job.job_id 
LEFT JOIN dbhr.hr_job turnfull_job ON tf.turnfull_job_id = turnfull_job.job_id 
LEFT JOIN dbsys.sys_org org ON tf.department_id = org.org_id 
WHERE tf.turnfull_id = 276 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030748844146729 -- 26-01-08 19:51:16[袁星嵘-2330] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para=%7B%22event%22:%22edit_turnfull%22,%22turnfull_id%22:%22276%22%7D&event=edit_turnfull&turnfull_id=276
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2330 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016723155975342 -- 26-01-08 20:07:08 -- /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.0033221244812012 -- 26-01-08 20:07:08 -- /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.0043299198150635 -- 26-01-08 20:07:08 -- /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='ZhengJiaLin' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036289691925049 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017228126525879 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038471221923828 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038421154022217 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037961006164551 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037510395050049 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037429332733154 -- 26-01-08 20:07:08[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018041849136353 -- 26-01-08 20:07:11[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044958591461182 -- 26-01-08 20:07:11[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 15 AND c.cont_id = 2346 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0043978691101074 -- 26-01-08 20:07:11[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017689943313599 -- 26-01-08 20:07:29[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2346 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017193078994751 -- 26-01-08 20:07:47[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037901401519775 -- 26-01-08 20:07:47[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037269592285156 -- 26-01-08 20:07:47[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033791065216064 -- 26-01-08 20:07:47[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036869049072266 -- 26-01-08 20:07:47[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036849975585938 -- 26-01-08 20:07:47[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024497985839844 -- 26-01-08 20:07:48[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8060
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0055210590362549 -- 26-01-08 20:07:48[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8060
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 = 8060 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032010078430176 -- 26-01-08 20:07:48[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8060
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2346 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01795220375061 -- 26-01-08 20:07:56[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039088726043701 -- 26-01-08 20:07:56[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039560794830322 -- 26-01-08 20:07:56[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035779476165771 -- 26-01-08 20:07:56[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038800239562988 -- 26-01-08 20:07:56[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038628578186035 -- 26-01-08 20:07:56[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019388914108276 -- 26-01-08 20:07:57[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8054
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0047910213470459 -- 26-01-08 20:07:57[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003065824508667 -- 26-01-08 20:07:57[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2346 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017114877700806 -- 26-01-08 20:08:00[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00376296043396 -- 26-01-08 20:08:00[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003687858581543 -- 26-01-08 20:08:00[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037221908569336 -- 26-01-08 20:08:00[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003654956817627 -- 26-01-08 20:08:00[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036590099334717 -- 26-01-08 20:08:00[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017149925231934 -- 26-01-08 20:08:01[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8060
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033600330352783 -- 26-01-08 20:08:01[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8060
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 = 8060 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032720565795898 -- 26-01-08 20:08:01[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8060
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2346 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017258167266846 -- 26-01-08 20:08:03[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037190914154053 -- 26-01-08 20:08:03[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037059783935547 -- 26-01-08 20:08:03[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034101009368896 -- 26-01-08 20:08:03[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036649703979492 -- 26-01-08 20:08:03[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036680698394775 -- 26-01-08 20:08:03[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.026295900344849 -- 26-01-08 20:08:06[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8054
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003342866897583 -- 26-01-08 20:08:06[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8054
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 = 8054 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033061504364014 -- 26-01-08 20:08:06[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8054
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2346 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015436887741089 -- 26-01-08 20:08:09[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031468868255615 -- 26-01-08 20:08:09[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030930042266846 -- 26-01-08 20:08:09[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0031580924987793 -- 26-01-08 20:08:09[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0030708312988281 -- 26-01-08 20:08:09[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.003061056137085 -- 26-01-08 20:08:09[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018225908279419 -- 26-01-08 20:08:10[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8048
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0048909187316895 -- 26-01-08 20:08:10[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8048
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 = 8048 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033180713653564 -- 26-01-08 20:08:10[郑嘉琳-2346] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8048
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2346 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017024040222168 -- 26-01-08 20:08:12[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034439563751221 -- 26-01-08 20:08:12[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034029483795166 -- 26-01-08 20:08:12[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034439563751221 -- 26-01-08 20:08:12[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034041404724121 -- 26-01-08 20:08:12[郑嘉琳-2346] -- /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 = 2346 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033941268920898 -- 26-01-08 20:08:12[郑嘉琳-2346] -- /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 = 2346 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024381875991821 -- 26-01-08 20:23: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.015583038330078 -- 26-01-08 20:23: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.003309965133667 -- 26-01-08 20:23: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.0038788318634033 -- 26-01-08 20:23: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='GaoRong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035810470581055 -- 26-01-08 20:23:29[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017357110977173 -- 26-01-08 20:23:29[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038158893585205 -- 26-01-08 20:23:29[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038301944732666 -- 26-01-08 20:23:29[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0058939456939697 -- 26-01-08 20:23:29[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037992000579834 -- 26-01-08 20:23:29[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038049221038818 -- 26-01-08 20:23:29[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017853021621704 -- 26-01-08 20:23:31[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0045170783996582 -- 26-01-08 20:23:31[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 15 AND c.cont_id = 498 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044651031494141 -- 26-01-08 20:23:31[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016411066055298 -- 26-01-08 20:23:50[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 498 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01623797416687 -- 26-01-08 20:23:59[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035159587860107 -- 26-01-08 20:23:59[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035190582275391 -- 26-01-08 20:23:59[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0038800239562988 -- 26-01-08 20:23:59[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00347900390625 -- 26-01-08 20:23:59[高蓉-498] -- /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 = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034689903259277 -- 26-01-08 20:23:59[高蓉-498] -- /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 = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020283937454224 -- 26-01-08 20:24:00[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8061
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0054750442504883 -- 26-01-08 20:24:00[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8061
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 = 8061 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034549236297607 -- 26-01-08 20:24:00[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8061
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 498 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01575493812561 -- 26-01-08 20:44:09 -- /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.017091989517212 -- 26-01-08 20:44:12[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037829875946045 -- 26-01-08 20:44:12[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037469863891602 -- 26-01-08 20:44:12[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0045959949493408 -- 26-01-08 20:44:12[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0037698745727539 -- 26-01-08 20:44:12[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036289691925049 -- 26-01-08 20:44:12[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015989780426025 -- 26-01-08 20:44:14[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041978359222412 -- 26-01-08 20:44:14[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays 
 FROM dbsys.`sys_contact` c
left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id 
 LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id 
 LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id 
 WHERE c.acct_id = 15 AND c.cont_id = 2180 AND c.`cont_name`=e.employee_name 
and e.onjob_status_id=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0041289329528809 -- 26-01-08 20:44:14[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5
select appr_proc_id,appr_proc_name  
from dboa.oa_appr_process 
where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016314029693604 -- 26-01-08 20:44:35[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2180 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025640964508057 -- 26-01-08 20:44:43[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035200119018555 -- 26-01-08 20:44:43[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0035078525543213 -- 26-01-08 20:44:43[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033910274505615 -- 26-01-08 20:44:43[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036280155181885 -- 26-01-08 20:44:43[林雅楠-2180] -- /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 = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034699440002441 -- 26-01-08 20:44:43[林雅楠-2180] -- /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 = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() )
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017596006393433 -- 26-01-08 20:44:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8055
SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' 
  AND DATE_FORMAT(rest_date,'%Y') > 2025
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.005450963973999 -- 26-01-08 20:44:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8055
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 = 8055 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034408569335938 -- 26-01-08 20:44:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8055
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2180 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------