Time: 0.023875951766968 -- 25-07-18 01:31:01 -- /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.019329071044922 -- 25-07-18 01:31:02[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054430961608887 -- 25-07-18 01:31:02[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050477981567383 -- 25-07-18 01:31:02[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012197017669678 -- 25-07-18 01:31:02[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048611164093018 -- 25-07-18 01:31:02[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057919025421143 -- 25-07-18 01:31:02[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025709867477417 -- 25-07-18 01:31:07[吴建威-387] -- /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 = 387 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050280094146729 -- 25-07-18 01:31:07[吴建威-387] -- /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.017618179321289 -- 25-07-18 01:31:43[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 387 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027902126312256 -- 25-07-18 01:31:48[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043098926544189 -- 25-07-18 01:31:48[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043039321899414 -- 25-07-18 01:31:48[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044839382171631 -- 25-07-18 01:31:48[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043017864227295 -- 25-07-18 01:31:48[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043008327484131 -- 25-07-18 01:31:48[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026010036468506 -- 25-07-18 01:31:49[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6855 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 = 6855 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047760009765625 -- 25-07-18 01:31:49[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 387 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017683029174805 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037250518798828 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037260055541992 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035219192504883 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037059783935547 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037112236022949 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028904914855957 -- 25-07-18 01:31:55[吴建威-387] -- /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 = 387 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040068626403809 -- 25-07-18 01:31:55[吴建威-387] -- /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.019956111907959 -- 25-07-18 07:55:08 -- /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.0040640830993652 -- 25-07-18 07:55:08 -- /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.0044801235198975 -- 25-07-18 07:55:08 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042309761047363 -- 25-07-18 07:55:08[吴凌刚-279] -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022787809371948 -- 25-07-18 07:55:09[吴凌刚-279] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025384187698364 -- 25-07-18 07:55:14[吴凌刚-279] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22edit_recruits%22,%22recruitApply_id%22:%22257%22}&event=edit_recruits&recruitApply_id=257 SELECT ra.*,org.org_name apply_org,job.job_name apply_job,cont.cont_name apply_agent, DATE_FORMAT(ra.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ra.onduty_date,'%Y-%m-%d') onduty_date, a_p.appr_proc_name,itv_cont.cont_name interview_contact,depart.org_name apply_department FROM dbhr.hr_recruitApply ra LEFT JOIN dbhr.hr_job job ON job.job_id = ra.apply_job_id LEFT JOIN dbsys.sys_org org ON org.org_id = ra.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ra.apply_department_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = ra.apply_agent_id LEFT JOIN dbsys.sys_contact itv_cont ON itv_cont.cont_id = ra.interview_cont_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = ra.appr_proc_id WHERE ra.recruitApply_id = 257 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045030117034912 -- 25-07-18 07:55:14[吴凌刚-279] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22edit_recruits%22,%22recruitApply_id%22:%22257%22}&event=edit_recruits&recruitApply_id=257 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031893014907837 -- 25-07-18 08:16:54[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 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 = 6855 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048129558563232 -- 25-07-18 08:16:54[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019251108169556 -- 25-07-18 08:16:58[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019370794296265 -- 25-07-18 08:16:58[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023940086364746 -- 25-07-18 08:17:04[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 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 = 6855 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043799877166748 -- 25-07-18 08:17:04[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018090009689331 -- 25-07-18 10:07:34 -- /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.025675058364868 -- 25-07-18 10:07:35[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056369304656982 -- 25-07-18 10:07:35[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058689117431641 -- 25-07-18 10:07:35[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065619945526123 -- 25-07-18 10:07:35[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056850910186768 -- 25-07-18 10:07:35[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056929588317871 -- 25-07-18 10:07:35[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020211935043335 -- 25-07-18 10:07:38[毕莹-1261] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1261 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021635055541992 -- 25-07-18 10:07:44[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046529769897461 -- 25-07-18 10:07:44[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045819282531738 -- 25-07-18 10:07:44[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046770572662354 -- 25-07-18 10:07:44[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004612922668457 -- 25-07-18 10:07:44[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046088695526123 -- 25-07-18 10:07:44[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022414922714233 -- 25-07-18 10:07:46[毕莹-1261] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 1261 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020586967468262 -- 25-07-18 10:07:48[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044100284576416 -- 25-07-18 10:07:48[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044469833374023 -- 25-07-18 10:07:48[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044519901275635 -- 25-07-18 10:07:48[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043361186981201 -- 25-07-18 10:07:48[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044031143188477 -- 25-07-18 10:07:48[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014885902404785 -- 25-07-18 10:07:50[毕莹-1261] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 1261 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01572585105896 -- 25-07-18 10:07:53[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034360885620117 -- 25-07-18 10:07:53[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034070014953613 -- 25-07-18 10:07:53[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036120414733887 -- 25-07-18 10:07:53[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034148693084717 -- 25-07-18 10:07:53[毕莹-1261] -- /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 = 1261 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033988952636719 -- 25-07-18 10:07:53[毕莹-1261] -- /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 = 1261 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021119832992554 -- 25-07-18 10:21:14[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226607%22}&event=edit_offwork&offwork_id=6607 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 = 6607 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003654956817627 -- 25-07-18 10:21:14[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22edit_offwork%22,%22offwork_id%22:%226607%22}&event=edit_offwork&offwork_id=6607 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 387 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020849943161011 -- 25-07-18 10:21:28[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042400360107422 -- 25-07-18 10:21:28[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041909217834473 -- 25-07-18 10:21:28[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004734992980957 -- 25-07-18 10:21:29[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041618347167969 -- 25-07-18 10:21:29[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042359828948975 -- 25-07-18 10:21:29[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015707015991211 -- 25-07-18 10:21:38[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034210681915283 -- 25-07-18 10:21:38[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033929347991943 -- 25-07-18 10:21:38[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037469863891602 -- 25-07-18 10:21:38[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033659934997559 -- 25-07-18 10:21:38[吴建威-387] -- /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 = 387 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033900737762451 -- 25-07-18 10:21:38[吴建威-387] -- /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 = 387 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019646883010864 -- 25-07-18 10:21:38[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6855 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 = 6855 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038731098175049 -- 25-07-18 10:21:38[吴建威-387] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 387 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019181966781616 -- 25-07-18 11:19:01 -- /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.0037600994110107 -- 25-07-18 11:19:01 -- /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.0049707889556885 -- 25-07-18 11:19:01 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='e80495db5092294c03792c584e7e829b' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042848587036133 -- 25-07-18 11:19:01[麦浩升-364] -- /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.02969217300415 -- 25-07-18 11:19:02[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042018890380859 -- 25-07-18 11:19:02[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041210651397705 -- 25-07-18 11:19:02[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041759014129639 -- 25-07-18 11:19:02[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040130615234375 -- 25-07-18 11:19:02[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040509700775146 -- 25-07-18 11:19:02[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026556968688965 -- 25-07-18 11:19:04[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6782 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 = 6782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017390012741089 -- 25-07-18 11:19:14[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037860870361328 -- 25-07-18 11:19:14[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037510395050049 -- 25-07-18 11:19:14[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038750171661377 -- 25-07-18 11:19:14[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037569999694824 -- 25-07-18 11:19:14[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037319660186768 -- 25-07-18 11:19:14[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0211021900177 -- 25-07-18 11:19:16[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6782 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 = 6782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023249864578247 -- 25-07-18 11:19:18[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049030780792236 -- 25-07-18 11:19:18[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049178600311279 -- 25-07-18 11:19:18[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049951076507568 -- 25-07-18 11:19:18[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048470497131348 -- 25-07-18 11:19:18[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048768520355225 -- 25-07-18 11:19:18[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026015043258667 -- 25-07-18 11:19:19[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6782 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 = 6782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02329421043396 -- 25-07-18 11:19:21[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=delete_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019953012466431 -- 25-07-18 11:19:22[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043020248413086 -- 25-07-18 11:19:22[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042860507965088 -- 25-07-18 11:19:22[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043809413909912 -- 25-07-18 11:19:22[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042698383331299 -- 25-07-18 11:19:22[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042788982391357 -- 25-07-18 11:19:22[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023518085479736 -- 25-07-18 11:19:24[麦浩升-364] -- /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 = 364 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054900646209717 -- 25-07-18 11:19:24[麦浩升-364] -- /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.017036914825439 -- 25-07-18 11:20:15[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026458978652954 -- 25-07-18 11:20:26 -- /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.020819187164307 -- 25-07-18 11:20:26 -- /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.02295994758606 -- 25-07-18 11:20:26[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040488243103027 -- 25-07-18 11:20:26[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040438175201416 -- 25-07-18 11:20:26[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041310787200928 -- 25-07-18 11:20:26[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040340423583984 -- 25-07-18 11:20:26[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004011869430542 -- 25-07-18 11:20:26[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0241379737854 -- 25-07-18 11:20:27[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6858 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 = 6858 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043561458587646 -- 25-07-18 11:20:27[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023457050323486 -- 25-07-18 11:20:28[李明娥-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.029036998748779 -- 25-07-18 11:20:29[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6854 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 = 6854 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044891834259033 -- 25-07-18 11:20:29[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6854 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024044990539551 -- 25-07-18 11:20:33[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6854 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018938064575195 -- 25-07-18 11:20:33[李明娥-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.023983001708984 -- 25-07-18 11:20:34[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6835 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 = 6835 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039021968841553 -- 25-07-18 11:20:34[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6835 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030606031417847 -- 25-07-18 11:20:38[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6835 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026952028274536 -- 25-07-18 11:20:39[李明娥-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.018969058990479 -- 25-07-18 11:20:40[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6834 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 = 6834 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029020309448242 -- 25-07-18 11:20:40[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6834 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023394107818604 -- 25-07-18 11:20:44[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6834 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029967069625854 -- 25-07-18 11:20:45[李明娥-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.028212070465088 -- 25-07-18 11:20:46[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6807 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 = 6807 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037989616394043 -- 25-07-18 11:20:46[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6807 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016380071640015 -- 25-07-18 11:20:49[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6807 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019191026687622 -- 25-07-18 11:20:50[李明娥-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.017723083496094 -- 25-07-18 11:20:58[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035750865936279 -- 25-07-18 11:20:58[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035638809204102 -- 25-07-18 11:20:58[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036659240722656 -- 25-07-18 11:20:58[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035309791564941 -- 25-07-18 11:20:58[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003532886505127 -- 25-07-18 11:20:58[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018465995788574 -- 25-07-18 11:21:00[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6858 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 = 6858 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033278465270996 -- 25-07-18 11:21:00[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018496990203857 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039551258087158 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039360523223877 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037131309509277 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039329528808594 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039160251617432 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017421960830688 -- 25-07-18 11:21:15[麦浩升-364] -- /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 = 364 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041420459747314 -- 25-07-18 11:21:15[麦浩升-364] -- /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.023654937744141 -- 25-07-18 11:21:16[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034499168395996 -- 25-07-18 11:21:16[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035109519958496 -- 25-07-18 11:21:16[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032179355621338 -- 25-07-18 11:21:16[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034677982330322 -- 25-07-18 11:21:16[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034310817718506 -- 25-07-18 11:21:16[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015673160552979 -- 25-07-18 11:21:16[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6782 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 = 6782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022413969039917 -- 25-07-18 11:21:25[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045111179351807 -- 25-07-18 11:21:25[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044901371002197 -- 25-07-18 11:21:25[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046029090881348 -- 25-07-18 11:21:26[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045228004455566 -- 25-07-18 11:21:26[麦浩升-364] -- /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 = 364 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044851303100586 -- 25-07-18 11:21:26[麦浩升-364] -- /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 = 364 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022596836090088 -- 25-07-18 11:21:26[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6858 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 = 6858 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032532215118408 -- 25-07-18 11:21:26[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017257928848267 -- 25-07-18 11:25:24[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226858%22}&event=&offwork_id=6858 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 = 6858 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030009746551514 -- 25-07-18 11:25:24[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226858%22}&event=&offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02171516418457 -- 25-07-18 11:25:33[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018188953399658 -- 25-07-18 11:25:33[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019441843032837 -- 25-07-18 12:04:58[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226807%22}&event=&offwork_id=6807 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 = 6807 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003244161605835 -- 25-07-18 12:04:58[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226807%22}&event=&offwork_id=6807 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020215034484863 -- 25-07-18 12:05:02[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6807 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020792007446289 -- 25-07-18 12:05:02[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018789052963257 -- 25-07-18 12:05:03[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6834 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 = 6834 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034618377685547 -- 25-07-18 12:05:03[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6834 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02039909362793 -- 25-07-18 12:05:06[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6834 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015374898910522 -- 25-07-18 12:05:11[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6834 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032049894332886 -- 25-07-18 12:05:11[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026841163635254 -- 25-07-18 12:05:16[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6636 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 = 6636 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035190582275391 -- 25-07-18 12:05:16[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6636 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01511812210083 -- 25-07-18 12:05:18[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6636 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029138088226318 -- 25-07-18 12:05:18[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019464015960693 -- 25-07-18 12:05:19[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6636 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 = 6636 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037009716033936 -- 25-07-18 12:05:19[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6636 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034415006637573 -- 25-07-18 13:07:47[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 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 = 6855 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044620037078857 -- 25-07-18 13:07:47[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026131153106689 -- 25-07-18 13:07:50[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025142192840576 -- 25-07-18 13:07:51[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020689010620117 -- 25-07-18 13:07:52[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6858 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 = 6858 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037910938262939 -- 25-07-18 13:07:52[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029179096221924 -- 25-07-18 13:07:54[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032971858978271 -- 25-07-18 13:07:54[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015161037445068 -- 25-07-18 13:07:55[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6858 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 = 6858 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029339790344238 -- 25-07-18 13:07:55[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=6858 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020701169967651 -- 25-07-18 13:07:56[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026082038879395 -- 25-07-18 13:08:13[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 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 = 6855 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047922134399414 -- 25-07-18 13:08:13[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%226855%22}&event=&offwork_id=6855 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017868041992188 -- 25-07-18 14:08:40 -- /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.003572940826416 -- 25-07-18 14:08:40 -- /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.0040631294250488 -- 25-07-18 14:08:40 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='MiaoZhiPei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038471221923828 -- 25-07-18 14:08:40[苗志培-653] -- /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= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022802114486694 -- 25-07-18 14:08:40[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049228668212891 -- 25-07-18 14:08:40[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048871040344238 -- 25-07-18 14:08:40[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055019855499268 -- 25-07-18 14:08:40[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048699378967285 -- 25-07-18 14:08:40[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048868656158447 -- 25-07-18 14:08:40[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023818016052246 -- 25-07-18 14:08:42[苗志培-653] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6781 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 = 6781 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043408870697021 -- 25-07-18 14:08:42[苗志培-653] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6781 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022528171539307 -- 25-07-18 14:08:49[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048868656158447 -- 25-07-18 14:08:49[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048720836639404 -- 25-07-18 14:08:49[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049030780792236 -- 25-07-18 14:08:49[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048360824584961 -- 25-07-18 14:08:49[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048139095306396 -- 25-07-18 14:08:49[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027312040328979 -- 25-07-18 14:08:51[苗志培-653] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6781 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 = 6781 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030090808868408 -- 25-07-18 14:08:51[苗志培-653] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6781 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017648935317993 -- 25-07-18 14:08:54[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038869380950928 -- 25-07-18 14:08:54[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038719177246094 -- 25-07-18 14:08:54[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039160251617432 -- 25-07-18 14:08:54[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038180351257324 -- 25-07-18 14:08:54[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038261413574219 -- 25-07-18 14:08:54[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033149003982544 -- 25-07-18 14:08:55[苗志培-653] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6781 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 = 6781 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045549869537354 -- 25-07-18 14:08:55[苗志培-653] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=6781 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017174005508423 -- 25-07-18 14:08:56[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037188529968262 -- 25-07-18 14:08:56[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036981105804443 -- 25-07-18 14:08:56[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037610530853271 -- 25-07-18 14:08:56[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036590099334717 -- 25-07-18 14:08:56[苗志培-653] -- /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 = 653 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036618709564209 -- 25-07-18 14:08:56[苗志培-653] -- /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 = 653 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015361070632935 -- 25-07-18 14:12:11 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029659271240234 -- 25-07-18 14:12:11 -- /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.0038149356842041 -- 25-07-18 14:12:11 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='YuanQunYing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 25-07-18 14:12:11[袁群英-668] -- /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.019549131393433 -- 25-07-18 14:12:11 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021759033203125 -- 25-07-18 14:12:12[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047528743743896 -- 25-07-18 14:12:12[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004709005355835 -- 25-07-18 14:12:12[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004770040512085 -- 25-07-18 14:12:12[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046980381011963 -- 25-07-18 14:12:12[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046761035919189 -- 25-07-18 14:12:12[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025087833404541 -- 25-07-18 14:12:16[袁群英-668] -- /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 = 668 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051140785217285 -- 25-07-18 14:12:16[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022659063339233 -- 25-07-18 14:13:44[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048599243164062 -- 25-07-18 14:13:44[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048618316650391 -- 25-07-18 14:13:44[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049240589141846 -- 25-07-18 14:13:44[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004828929901123 -- 25-07-18 14:13:44[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048420429229736 -- 25-07-18 14:13:44[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018136978149414 -- 25-07-18 14:18:37[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040931701660156 -- 25-07-18 14:18:37[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040609836578369 -- 25-07-18 14:18:37[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041329860687256 -- 25-07-18 14:18:37[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039880275726318 -- 25-07-18 14:18:37[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039939880371094 -- 25-07-18 14:18:37[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024586915969849 -- 25-07-18 14:18:40[袁群英-668] -- /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 = 668 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053181648254395 -- 25-07-18 14:18:40[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022072076797485 -- 25-07-18 14:19:24[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 668 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022817850112915 -- 25-07-18 14:19:31[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042469501495361 -- 25-07-18 14:19:31[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042178630828857 -- 25-07-18 14:19:31[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042979717254639 -- 25-07-18 14:19:31[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041890144348145 -- 25-07-18 14:19:31[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042049884796143 -- 25-07-18 14:19:31[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022250890731812 -- 25-07-18 14:19:34[袁群英-668] -- /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 = 668 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052919387817383 -- 25-07-18 14:19:34[袁群英-668] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 151 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030157089233398 -- 25-07-18 14:19:35[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053689479827881 -- 25-07-18 14:19:35[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053699016571045 -- 25-07-18 14:19:35[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054631233215332 -- 25-07-18 14:19:35[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053081512451172 -- 25-07-18 14:19:35[袁群英-668] -- /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 = 668 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053269863128662 -- 25-07-18 14:19:35[袁群英-668] -- /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 = 668 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027431011199951 -- 25-07-18 15:20:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039029121398926 -- 25-07-18 15:20:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048270225524902 -- 25-07-18 15:20:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='427' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041961669921875 -- 25-07-18 15:20:38[霍一帆-1751] -- /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.016998052597046 -- 25-07-18 15:20:40[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038418769836426 -- 25-07-18 15:20:40[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038161277770996 -- 25-07-18 15:20:40[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039310455322266 -- 25-07-18 15:20:40[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037820339202881 -- 25-07-18 15:20:40[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037789344787598 -- 25-07-18 15:20:40[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025168895721436 -- 25-07-18 15:20:55[霍一帆-1751] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull SELECT e.employee_id,e.employee_no,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name, DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time,e_s.sum_pay FROM dbhr.hr_employee e LEFT JOIN dbhr.hr_employee_salary e_s on e_s.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 e.acct_id = 15 AND e.cont_id = 1751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056750774383545 -- 25-07-18 15:20:55[霍一帆-1751] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 230 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 6 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016736030578613 -- 25-07-18 15:21: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.02608585357666 -- 25-07-18 15:21:01[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042300224304199 -- 25-07-18 15:21:01[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041840076446533 -- 25-07-18 15:21:01[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042059421539307 -- 25-07-18 15:21:01[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041751861572266 -- 25-07-18 15:21:01[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004162073135376 -- 25-07-18 15:21:01[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01679801940918 -- 25-07-18 15:21:06[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036709308624268 -- 25-07-18 15:21:06[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036380290985107 -- 25-07-18 15:21:06[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036599636077881 -- 25-07-18 15:21:06[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 25-07-18 15:21:06[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036060810089111 -- 25-07-18 15:21:06[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03334903717041 -- 25-07-18 15:21:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044639110565186 -- 25-07-18 15:21:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049281120300293 -- 25-07-18 15:21:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='y' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030288934707642 -- 25-07-18 15:21:48[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079538822174072 -- 25-07-18 15:21:48[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064971446990967 -- 25-07-18 15:21:48[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041160583496094 -- 25-07-18 15:21:48[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029814004898071 -- 25-07-18 15:21:48[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040419101715088 -- 25-07-18 15:21:48[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019189834594727 -- 25-07-18 15:22:20[霍一帆-1751] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull SELECT e.employee_id,e.employee_no,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name, DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time,e_s.sum_pay FROM dbhr.hr_employee e LEFT JOIN dbhr.hr_employee_salary e_s on e_s.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 e.acct_id = 15 AND e.cont_id = 1751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045139789581299 -- 25-07-18 15:22:20[霍一帆-1751] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 230 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 6 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028700828552246 -- 25-07-18 15:22:27[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035629272460938 -- 25-07-18 15:22:27[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034959316253662 -- 25-07-18 15:22:27[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035111904144287 -- 25-07-18 15:22:27[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034799575805664 -- 25-07-18 15:22:27[霍一帆-1751] -- /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 = 1751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034470558166504 -- 25-07-18 15:22:27[霍一帆-1751] -- /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 = 1751 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024955034255981 -- 25-07-18 15:22:27[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042798519134521 -- 25-07-18 15:22:27[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042440891265869 -- 25-07-18 15:22:27[高原-2278] -- /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 = 2278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042331218719482 -- 25-07-18 15:22:27[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004213809967041 -- 25-07-18 15:22:27[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042500495910645 -- 25-07-18 15:22:27[高原-2278] -- /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 = 2278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016741991043091 -- 25-07-18 15:22:36[高原-2278] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull SELECT e.employee_id,e.employee_no,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name, DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time,e_s.sum_pay FROM dbhr.hr_employee e LEFT JOIN dbhr.hr_employee_salary e_s on e_s.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 e.acct_id = 15 AND e.cont_id = 2278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003493070602417 -- 25-07-18 15:22:36[高原-2278] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 223 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 6 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019246101379395 -- 25-07-18 15:48:08[高原-2278] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=save_turnfull select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02296781539917 -- 25-07-18 15:48:13[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048751831054688 -- 25-07-18 15:48:13[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049979686737061 -- 25-07-18 15:48:13[高原-2278] -- /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 = 2278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049707889556885 -- 25-07-18 15:48:13[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049190521240234 -- 25-07-18 15:48:13[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049898624420166 -- 25-07-18 15:48:13[高原-2278] -- /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 = 2278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021360874176025 -- 25-07-18 15:57:42[高原-2278] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull SELECT e.employee_id,e.employee_no,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name, DATE_FORMAT(e.entry_time,'%Y-%m-%d') entry_time,e_s.sum_pay FROM dbhr.hr_employee e LEFT JOIN dbhr.hr_employee_salary e_s on e_s.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 e.acct_id = 15 AND e.cont_id = 2278 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043199062347412 -- 25-07-18 15:57:42[高原-2278] -- /buz/hr/index.php/hrmgmt/hr_turnfull?event=edit_turnfull select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 223 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 6 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021300077438354 -- 25-07-18 15:57:43[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046460628509521 -- 25-07-18 15:57:43[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045998096466064 -- 25-07-18 15:57:43[高原-2278] -- /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 = 2278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046441555023193 -- 25-07-18 15:57:43[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045619010925293 -- 25-07-18 15:57:43[高原-2278] -- /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 = 2278 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045909881591797 -- 25-07-18 15:57:43[高原-2278] -- /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 = 2278 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021142959594727 -- 25-07-18 16:01:10 -- /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.004270076751709 -- 25-07-18 16:01:10 -- /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.0047140121459961 -- 25-07-18 16:01:10 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='AMeng' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045199394226074 -- 25-07-18 16:01:10[李明娥-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.0190269947052 -- 25-07-18 16:01:10 -- /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.02074408531189 -- 25-07-18 16:01:10[李明娥-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.025102138519287 -- 25-07-18 16:01:12[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=224 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id where turnfull_id = 224 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047030448913574 -- 25-07-18 16:01:12[李明娥-478] -- /buz/hr/index.php/hrmgmt/hr_turnfull?turnfull_id=224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017423868179321 -- 25-07-18 16:40: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.026407957077026 -- 25-07-18 17:17:17 -- /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.0051882266998291 -- 25-07-18 17:17:17 -- /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.0056710243225098 -- 25-07-18 17:17:17 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiZhenHan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054459571838379 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015946865081787 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035591125488281 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036048889160156 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035209655761719 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035610198974609 -- 25-07-18 17:17:17[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018532037734985 -- 25-07-18 17:17:21[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 1423 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042080879211426 -- 25-07-18 17:17:21[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030051946640015 -- 25-07-18 17:17:53[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1423 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016537189483643 -- 25-07-18 17:17:58[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035948753356934 -- 25-07-18 17:17:58[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003554105758667 -- 25-07-18 17:17:58[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036079883575439 -- 25-07-18 17:17:58[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035221576690674 -- 25-07-18 17:17:58[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035469532012939 -- 25-07-18 17:17:58[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020950078964233 -- 25-07-18 17:23:39 -- /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.017953157424927 -- 25-07-18 17:24:17 -- /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.0035829544067383 -- 25-07-18 17:24:17 -- /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.0045030117034912 -- 25-07-18 17:24:17 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='nevermore.' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019567012786865 -- 25-07-18 17:25: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.0038421154022217 -- 25-07-18 17:25:09 -- /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.0046858787536621 -- 25-07-18 17:25:09 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='nevermore.' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019663095474243 -- 25-07-18 17:53:32 -- /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.0039739608764648 -- 25-07-18 17:53:32 -- /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.0044529438018799 -- 25-07-18 17:53:32 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='FeiLiShiXianDaiKeFuCaoZhiXiong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042119026184082 -- 25-07-18 17:53:32[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027721166610718 -- 25-07-18 17:53:33[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036771297454834 -- 25-07-18 17:53:33[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036561489105225 -- 25-07-18 17:53:33[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003709077835083 -- 25-07-18 17:53:33[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035841464996338 -- 25-07-18 17:53:33[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036270618438721 -- 25-07-18 17:53:33[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017951011657715 -- 25-07-18 17:53:44[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 822 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042929649353027 -- 25-07-18 17:53:44[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019418954849243 -- 25-07-18 17:54:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041599273681641 -- 25-07-18 17:54:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041561126708984 -- 25-07-18 17:54:07[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042319297790527 -- 25-07-18 17:54:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041549205780029 -- 25-07-18 17:54:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041019916534424 -- 25-07-18 17:54:07[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024638891220093 -- 25-07-18 17:54:21[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 822 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053470134735107 -- 25-07-18 17:54:21[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015298128128052 -- 25-07-18 18:13: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.018841028213501 -- 25-07-18 18:13: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.020220994949341 -- 25-07-18 18:13:02[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039858818054199 -- 25-07-18 18:13:02[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044760704040527 -- 25-07-18 18:13:02[蔡江波-625] -- /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 = 625 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050148963928223 -- 25-07-18 18:13:02[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043990612030029 -- 25-07-18 18:13:02[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043890476226807 -- 25-07-18 18:13:02[蔡江波-625] -- /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 = 625 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016561985015869 -- 25-07-18 18:13:06[蔡江波-625] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 625 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040881633758545 -- 25-07-18 18:13:06[蔡江波-625] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015820026397705 -- 25-07-18 18:13:19[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034291744232178 -- 25-07-18 18:13:19[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034248828887939 -- 25-07-18 18:13:19[蔡江波-625] -- /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 = 625 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035841464996338 -- 25-07-18 18:13:19[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034120082855225 -- 25-07-18 18:13:19[蔡江波-625] -- /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 = 625 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033769607543945 -- 25-07-18 18:13:19[蔡江波-625] -- /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 = 625 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019170045852661 -- 25-07-18 18:20:53[李明娥-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.020789861679077 -- 25-07-18 18:25:27[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para={%22event%22:%22%22,%22turnfull_id%22:%22224%22}&event=&turnfull_id=224 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id where turnfull_id = 224 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039398670196533 -- 25-07-18 18:25:27[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para={%22event%22:%22%22,%22turnfull_id%22:%22224%22}&event=&turnfull_id=224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015033006668091 -- 25-07-18 18:25:36[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024636030197144 -- 25-07-18 18:25:42[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para={%22event%22:%22%22,%22turnfull_id%22:%22224%22}&event=&turnfull_id=224 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id where turnfull_id = 224 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048439502716064 -- 25-07-18 18:25:42[石远龙-484] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para={%22event%22:%22%22,%22turnfull_id%22:%22224%22}&event=&turnfull_id=224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029317855834961 -- 25-07-18 19:11:42 -- /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.0039360523223877 -- 25-07-18 19:11:42 -- /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.0049068927764893 -- 25-07-18 19:11:42 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='TangZiJi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042071342468262 -- 25-07-18 19:11:42[唐梓基-2005] -- /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.018556118011475 -- 25-07-18 19:11:42[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041141510009766 -- 25-07-18 19:11:42[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040650367736816 -- 25-07-18 19:11:42[唐梓基-2005] -- /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 = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041041374206543 -- 25-07-18 19:11:42[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040318965911865 -- 25-07-18 19:11:42[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040359497070312 -- 25-07-18 19:11:42[唐梓基-2005] -- /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 = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018805027008057 -- 25-07-18 19:11:45[唐梓基-2005] -- /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 = 2005 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045521259307861 -- 25-07-18 19:11:45[唐梓基-2005] -- /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.020662069320679 -- 25-07-18 19:11:47[唐梓基-2005] -- /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 = 2005 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004054069519043 -- 25-07-18 19:11:47[唐梓基-2005] -- /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.01752781867981 -- 25-07-18 19:11:48[唐梓基-2005] -- /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 = 2005 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034260749816895 -- 25-07-18 19:11:48[唐梓基-2005] -- /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.017541885375977 -- 25-07-18 19:12:02[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2005 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030587911605835 -- 25-07-18 19:12:10[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043790340423584 -- 25-07-18 19:12:10[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042650699615479 -- 25-07-18 19:12:10[唐梓基-2005] -- /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 = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042998790740967 -- 25-07-18 19:12:10[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042200088500977 -- 25-07-18 19:12:10[唐梓基-2005] -- /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 = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042190551757812 -- 25-07-18 19:12:10[唐梓基-2005] -- /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 = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01565408706665 -- 25-07-18 19:29:16 -- /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.003148078918457 -- 25-07-18 19:29:16 -- /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.0036261081695557 -- 25-07-18 19:29:16 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LinYaNan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034160614013672 -- 25-07-18 19:29:16[林雅楠-2180] -- /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.018846035003662 -- 25-07-18 19:29:16 -- /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.019385099411011 -- 25-07-18 19:29:16 -- /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.0038158893585205 -- 25-07-18 19:29:16 -- /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.004486083984375 -- 25-07-18 19:29:16 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoRong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042529106140137 -- 25-07-18 19:29:16[高蓉-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.015956878662109 -- 25-07-18 19:29:17[林雅楠-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.0034420490264893 -- 25-07-18 19:29:17[林雅楠-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.0034120082855225 -- 25-07-18 19:29:17[林雅楠-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.0034728050231934 -- 25-07-18 19:29:17[林雅楠-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.0033800601959229 -- 25-07-18 19:29:17[林雅楠-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.0033829212188721 -- 25-07-18 19:29:17[林雅楠-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.022769927978516 -- 25-07-18 19:29:18[高蓉-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.0042619705200195 -- 25-07-18 19:29:18[高蓉-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.0042479038238525 -- 25-07-18 19:29:18[高蓉-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.0048749446868896 -- 25-07-18 19:29:18[高蓉-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.0042068958282471 -- 25-07-18 19:29:18[高蓉-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.0042099952697754 -- 25-07-18 19:29:18[高蓉-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.018274068832397 -- 25-07-18 19:29:20[林雅楠-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.0043990612030029 -- 25-07-18 19:29:20[林雅楠-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.029916048049927 -- 25-07-18 19:29:23[高蓉-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.0035829544067383 -- 25-07-18 19:29:23[高蓉-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.01821494102478 -- 25-07-18 19:29:38[林雅楠-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.015376091003418 -- 25-07-18 19:29:39[高蓉-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.016879081726074 -- 25-07-18 19:29:44[高蓉-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.00335693359375 -- 25-07-18 19:29:44[高蓉-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.0033748149871826 -- 25-07-18 19:29:44[高蓉-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.0034639835357666 -- 25-07-18 19:29:44[高蓉-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.0033590793609619 -- 25-07-18 19:29:44[高蓉-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.0033249855041504 -- 25-07-18 19:29:44[高蓉-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.023630142211914 -- 25-07-18 19:29:45[林雅楠-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.0039470195770264 -- 25-07-18 19:29:45[林雅楠-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.0039229393005371 -- 25-07-18 19:29:45[林雅楠-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.003687858581543 -- 25-07-18 19:29:45[林雅楠-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.0039088726043701 -- 25-07-18 19:29:45[林雅楠-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.0039119720458984 -- 25-07-18 19:29:45[林雅楠-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.030187845230103 -- 25-07-18 19:29:45[高蓉-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.0036749839782715 -- 25-07-18 19:29:45[高蓉-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.020021915435791 -- 25-07-18 19:29:46[林雅楠-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.0038950443267822 -- 25-07-18 19:29:46[林雅楠-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.024081945419312 -- 25-07-18 19:29:47[高蓉-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.0050771236419678 -- 25-07-18 19:29:47[高蓉-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.0050618648529053 -- 25-07-18 19:29:47[高蓉-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.0051949024200439 -- 25-07-18 19:29:47[高蓉-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.0050089359283447 -- 25-07-18 19:29:47[高蓉-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.0050280094146729 -- 25-07-18 19:29:47[高蓉-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.028317928314209 -- 25-07-18 19:29:47[林雅楠-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.0052709579467773 -- 25-07-18 19:29:47[林雅楠-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.0052220821380615 -- 25-07-18 19:29:47[林雅楠-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.0052340030670166 -- 25-07-18 19:29:47[林雅楠-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.0051398277282715 -- 25-07-18 19:29:47[林雅楠-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.0051450729370117 -- 25-07-18 19:29:47[林雅楠-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.018180131912231 -- 25-07-18 20:31:17 -- /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.0035440921783447 -- 25-07-18 20:31:17 -- /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.0044350624084473 -- 25-07-18 20:31:17 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='OuYangAiPing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003709077835083 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 43 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01911997795105 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042269229888916 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041768550872803 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /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 = 2157 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040910243988037 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041961669921875 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041980743408203 -- 25-07-18 20:31:17[欧阳爱萍-2157] -- /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 = 2157 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017615079879761 -- 25-07-18 20:31:21[欧阳爱萍-2157] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 43 AND c.cont_id = 2157 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042622089385986 -- 25-07-18 20:31:21[欧阳爱萍-2157] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 475 and acct_id = 43 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0242760181427 -- 25-07-18 20:32:09[欧阳爱萍-2157] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2157 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020117998123169 -- 25-07-18 20:32:13[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040700435638428 -- 25-07-18 20:32:13[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 25-07-18 20:32:13[欧阳爱萍-2157] -- /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 = 2157 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042400360107422 -- 25-07-18 20:32:13[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039830207824707 -- 25-07-18 20:32:13[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004040002822876 -- 25-07-18 20:32:13[欧阳爱萍-2157] -- /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 = 2157 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023263931274414 -- 25-07-18 20:32:16[欧阳爱萍-2157] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 43 AND c.cont_id = 2157 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045962333679199 -- 25-07-18 20:32:16[欧阳爱萍-2157] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=3 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 475 and acct_id = 43 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021360874176025 -- 25-07-18 20:32:18[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045359134674072 -- 25-07-18 20:32:18[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045320987701416 -- 25-07-18 20:32:18[欧阳爱萍-2157] -- /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 = 2157 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045268535614014 -- 25-07-18 20:32:18[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044870376586914 -- 25-07-18 20:32:18[欧阳爱萍-2157] -- /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 = 2157 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044958591461182 -- 25-07-18 20:32:18[欧阳爱萍-2157] -- /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 = 2157 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034171104431152 -- 25-07-18 20:52:24 -- /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.0045971870422363 -- 25-07-18 20:52:24 -- /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.0054728984832764 -- 25-07-18 20:52:24 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='FeiLiShiXianDaiKeFuCaoZhiXiong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048370361328125 -- 25-07-18 20:52:24[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021367073059082 -- 25-07-18 20:52:25[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047478675842285 -- 25-07-18 20:52:25[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004688024520874 -- 25-07-18 20:52:25[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047760009765625 -- 25-07-18 20:52:25[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046219825744629 -- 25-07-18 20:52:25[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046389102935791 -- 25-07-18 20:52:25[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022834062576294 -- 25-07-18 20:52:28[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 822 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055217742919922 -- 25-07-18 20:52:28[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021751165390015 -- 25-07-18 22:02:58 -- /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.021206855773926 -- 25-07-18 22:02:58 -- /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.018212080001831 -- 25-07-18 22:03:01[欧阳丹-286] -- /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 = 286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040199756622314 -- 25-07-18 22:03:01[欧阳丹-286] -- /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 = 286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039799213409424 -- 25-07-18 22:03:01[欧阳丹-286] -- /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 = 286 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048270225524902 -- 25-07-18 22:03:01[欧阳丹-286] -- /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 = 286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039098262786865 -- 25-07-18 22:03:01[欧阳丹-286] -- /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 = 286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039429664611816 -- 25-07-18 22:03:01[欧阳丹-286] -- /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 = 286 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018181085586548 -- 25-07-18 22:03:04[欧阳丹-286] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 286 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043480396270752 -- 25-07-18 22:03:04[欧阳丹-286] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019234895706177 -- 25-07-18 22:03:41[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 822 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020163059234619 -- 25-07-18 22:04:12[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004298210144043 -- 25-07-18 22:04:12[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042610168457031 -- 25-07-18 22:04:12[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040409564971924 -- 25-07-18 22:04:12[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042591094970703 -- 25-07-18 22:04:12[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042319297790527 -- 25-07-18 22:04:12[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02530312538147 -- 25-07-18 22:05:06[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 822 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057899951934814 -- 25-07-18 22:05:06[曹志雄-822] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022646903991699 -- 25-07-18 22:05:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048179626464844 -- 25-07-18 22:05:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048131942749023 -- 25-07-18 22:05:07[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048818588256836 -- 25-07-18 22:05:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047938823699951 -- 25-07-18 22:05:07[曹志雄-822] -- /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 = 822 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047800540924072 -- 25-07-18 22:05:07[曹志雄-822] -- /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 = 822 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.049521923065186 -- 25-07-18 22:17:46[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para={%22event%22:%22%22,%22turnfull_id%22:%22224%22}&event=&turnfull_id=224 select t.*,corporate.org_name corporate,depart.org_name department,j.job_name trial_job, DATE_FORMAT(t.entry_time,'%Y-%m-%d') entry_time, 6 appr_type_id from dbhr.hr_turnfull t left join dbsys.sys_org depart on t.department_id = depart.org_id left join dbsys.sys_org corporate on depart.parent_id = corporate.org_id left join dbhr.hr_job j on t.trial_job_id = j.job_id where turnfull_id = 224 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030901432037354 -- 25-07-18 22:17:46[关云-169] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para={%22event%22:%22%22,%22turnfull_id%22:%22224%22}&event=&turnfull_id=224 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017094135284424 -- 25-07-18 22:17:58[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021354913711548 -- 25-07-18 23:21:27 -- /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.01937198638916 -- 25-07-18 23:21:29[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042989253997803 -- 25-07-18 23:21:29[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042498111724854 -- 25-07-18 23:21:29[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042388439178467 -- 25-07-18 23:21:29[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042638778686523 -- 25-07-18 23:21:29[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1656 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042259693145752 -- 25-07-18 23:21:29[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1656 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019020080566406 -- 25-07-18 23:21:37[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 1656 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046060085296631 -- 25-07-18 23:21:37[唐美-1656] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------