Time: 0.018419027328491 -- 26-04-10 09:09:23 -- /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.0016040802001953 -- 26-04-10 09:09:23 -- /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.0021541118621826 -- 26-04-10 09:09:23 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='FeiLiShiWuLiuKeFuZhuYan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018959045410156 -- 26-04-10 09:09:23[朱燕-1279] -- /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.013354063034058 -- 26-04-10 09:09:24[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003389835357666 -- 26-04-10 09:09:24[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036778450012207 -- 26-04-10 09:09:24[朱燕-1279] -- /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 = 1279 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012017965316772 -- 26-04-10 09:09:24[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032491683959961 -- 26-04-10 09:09:24[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003788948059082 -- 26-04-10 09:09:24[朱燕-1279] -- /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 = 1279 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097520351409912 -- 26-04-10 09:09:25[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048549175262451 -- 26-04-10 09:09:26[朱燕-1279] -- /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 = 1279 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027229785919189 -- 26-04-10 09:09:26[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012691974639893 -- 26-04-10 09:09:28[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01039981842041 -- 26-04-10 09:09:29[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009213924407959 -- 26-04-10 09:09:31[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015524864196777 -- 26-04-10 09:09:31[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078070163726807 -- 26-04-10 09:09:31[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070970058441162 -- 26-04-10 09:09:31[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02813196182251 -- 26-04-10 09:09:31[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015536069869995 -- 26-04-10 09:09:33[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01157808303833 -- 26-04-10 09:09:33[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016010999679565 -- 26-04-10 09:09:35[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079958438873291 -- 26-04-10 09:09:35[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015406131744385 -- 26-04-10 09:09:35[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084969997406006 -- 26-04-10 09:09:35[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021123170852661 -- 26-04-10 09:09:35[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020869970321655 -- 26-04-10 09:09:36[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069549083709717 -- 26-04-10 09:09:36[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067949295043945 -- 26-04-10 09:09:36[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00807785987854 -- 26-04-10 09:09:36[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020879983901978 -- 26-04-10 09:10:15[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014534950256348 -- 26-04-10 09:10:19[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089330673217773 -- 26-04-10 09:10:38[朱燕-1279] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093059539794922 -- 26-04-10 09:10:43[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018820762634277 -- 26-04-10 09:10:43[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018441677093506 -- 26-04-10 09:10:43[朱燕-1279] -- /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 = 1279 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019290447235107 -- 26-04-10 09:10:43[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018210411071777 -- 26-04-10 09:10:43[朱燕-1279] -- /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 = 1279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00180983543396 -- 26-04-10 09:10:43[朱燕-1279] -- /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 = 1279 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082528591156006 -- 26-04-10 10:32:02 -- /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.0015430450439453 -- 26-04-10 10:32:02 -- /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.0024778842926025 -- 26-04-10 10:32:02 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='DongGuanFeiLiShiZhouYuGuang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001856803894043 -- 26-04-10 10:32:02[周玉广-847] -- /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= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023409128189087 -- 26-04-10 10:32:04[周玉广-847] -- /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 = 847 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025689601898193 -- 26-04-10 10:32:04[周玉广-847] -- /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 = 847 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025260448455811 -- 26-04-10 10:32:04[周玉广-847] -- /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 = 847 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 26-04-10 10:32:04[周玉广-847] -- /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 = 847 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024819374084473 -- 26-04-10 10:32:04[周玉广-847] -- /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 = 847 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025410652160645 -- 26-04-10 10:32:04[周玉广-847] -- /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 = 847 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015297174453735 -- 26-04-10 10:32:05[周玉广-847] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8614 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038130283355713 -- 26-04-10 10:32:05[周玉广-847] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8614 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 = 8614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022978782653809 -- 26-04-10 10:32:05[周玉广-847] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013644933700562 -- 26-04-10 12:02:43 -- /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.0018758773803711 -- 26-04-10 12:02:43 -- /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.0027689933776855 -- 26-04-10 12:02:43 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuangLei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020630359649658 -- 26-04-10 12:02:43[黄磊-1260] -- /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.021862030029297 -- 26-04-10 12:02:44[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020740032196045 -- 26-04-10 12:02:44[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019659996032715 -- 26-04-10 12:02:44[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020899772644043 -- 26-04-10 12:02:44[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019500255584717 -- 26-04-10 12:02:44[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019769668579102 -- 26-04-10 12:02:44[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024442911148071 -- 26-04-10 12:02:51[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030560493469238 -- 26-04-10 12:02:51[黄磊-1260] -- /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 = 1260 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030019283294678 -- 26-04-10 12:02:51[黄磊-1260] -- /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.016350984573364 -- 26-04-10 12:02:53[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016150951385498 -- 26-04-10 12:02:55[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018310070037842 -- 26-04-10 12:02:56[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075030326843262 -- 26-04-10 12:02:59[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018379688262939 -- 26-04-10 12:02:59[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017690658569336 -- 26-04-10 12:02:59[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018560886383057 -- 26-04-10 12:02:59[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017349720001221 -- 26-04-10 12:02:59[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017178058624268 -- 26-04-10 12:02:59[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096390247344971 -- 26-04-10 12:03:05[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002068042755127 -- 26-04-10 12:03:05[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020201206207275 -- 26-04-10 12:03:05[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021169185638428 -- 26-04-10 12:03:05[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002047061920166 -- 26-04-10 12:03:05[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019659996032715 -- 26-04-10 12:03:05[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010786056518555 -- 26-04-10 12:03:07[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8389 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029239654541016 -- 26-04-10 12:03:07[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8389 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 = 8389 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020442008972168 -- 26-04-10 12:03:07[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8389 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018479108810425 -- 26-04-10 12:03:09[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022768974304199 -- 26-04-10 12:03:09[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021710395812988 -- 26-04-10 12:03:09[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023021697998047 -- 26-04-10 12:03:09[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021369457244873 -- 26-04-10 12:03:09[黄磊-1260] -- /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 = 1260 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021450519561768 -- 26-04-10 12:03:09[黄磊-1260] -- /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 = 1260 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019927978515625 -- 26-04-10 12:03:12[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016610622406006 -- 26-04-10 12:03:12[黄磊-1260] -- /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 = 1260 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001633882522583 -- 26-04-10 12:03:12[黄磊-1260] -- /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.019899129867554 -- 26-04-10 12:03:13[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021831035614014 -- 26-04-10 12:03:14[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078780651092529 -- 26-04-10 12:03:14[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094900131225586 -- 26-04-10 12:03:14[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084471702575684 -- 26-04-10 12:03:14[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014462947845459 -- 26-04-10 12:03:29[黄磊-1260] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1260 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012694120407104 -- 26-04-10 15:07: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.0016140937805176 -- 26-04-10 15:07: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.0025591850280762 -- 26-04-10 15:07:38 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='e80495db5092294c03792c584e7e829b' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019118785858154 -- 26-04-10 15:07:38[麦浩升-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.0091719627380371 -- 26-04-10 15:07:38[麦浩升-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.0022361278533936 -- 26-04-10 15:07:38[麦浩升-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.0022130012512207 -- 26-04-10 15:07:38[麦浩升-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.0027499198913574 -- 26-04-10 15:07:38[麦浩升-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.0021581649780273 -- 26-04-10 15:07:38[麦浩升-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.0021598339080811 -- 26-04-10 15:07:38[麦浩升-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.0086700916290283 -- 26-04-10 15:07:40[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025858879089355 -- 26-04-10 15:07:40[麦浩升-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.0022099018096924 -- 26-04-10 15:07:40[麦浩升-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.0088961124420166 -- 26-04-10 15:07:41[麦浩升-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.0020279884338379 -- 26-04-10 15:07:41[麦浩升-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.0020251274108887 -- 26-04-10 15:07:41[麦浩升-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.0022139549255371 -- 26-04-10 15:07:41[麦浩升-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.0019729137420654 -- 26-04-10 15:07:41[麦浩升-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.0019559860229492 -- 26-04-10 15:07:41[麦浩升-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.01100492477417 -- 26-04-10 15:10:54[刘伍-933] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22299%22}&event=&recruitApply_id=299 SELECT r.*,job.job_name apply_job,cont.cont_name apply_agent,org.org_name apply_org,depart.org_name apply_department,job.job_name apply_job, DATE_FORMAT(r.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(r.onduty_date,'%Y-%m-%d') onduty_date,5 appr_type_id FROM dbhr.hr_recruitapply r LEFT JOIN dbsys.sys_org org ON org.org_id = r.apply_org_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = r.apply_department_id LEFT JOIN dbhr.hr_job job ON job.job_id = r.apply_job_id LEFT JOIN dbsys.sys_contact cont ON cont.cont_id = r.apply_agent_id WHERE recruitApply_id = 299 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017459392547607 -- 26-04-10 15:10:54[刘伍-933] -- /buz/hr/index.php/hrmgmt/hr_recruits?para={%22event%22:%22%22,%22recruitApply_id%22:%22299%22}&event=&recruitApply_id=299 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099079608917236 -- 26-04-10 15:12:32[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002608060836792 -- 26-04-10 15:12:32[麦浩升-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.0027179718017578 -- 26-04-10 15:12:32[麦浩升-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.015279054641724 -- 26-04-10 15:12:34[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011882781982422 -- 26-04-10 15:12:37[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097920894622803 -- 26-04-10 15:12:37[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010107040405273 -- 26-04-10 15:12:38[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0153648853302 -- 26-04-10 15:12:39[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010947227478027 -- 26-04-10 15:12:39[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082371234893799 -- 26-04-10 15:12:40[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01494312286377 -- 26-04-10 15:12:40[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012654781341553 -- 26-04-10 15:12:40[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080389976501465 -- 26-04-10 15:12:40[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011801958084106 -- 26-04-10 15:12:41[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088160037994385 -- 26-04-10 15:12:41[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013372898101807 -- 26-04-10 15:12:41[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010138034820557 -- 26-04-10 15:12:41[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093200206756592 -- 26-04-10 15:12:42[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010246992111206 -- 26-04-10 15:12:42[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092260837554932 -- 26-04-10 15:12:42[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019393920898438 -- 26-04-10 15:12:43[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014750003814697 -- 26-04-10 15:12:43[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016765117645264 -- 26-04-10 15:12:43[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020884037017822 -- 26-04-10 15:12:43[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010473966598511 -- 26-04-10 15:12:44[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007922887802124 -- 26-04-10 15:12:44[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090818405151367 -- 26-04-10 15:12:45[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020485162734985 -- 26-04-10 15:12:45[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016401052474976 -- 26-04-10 15:12:46[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010241985321045 -- 26-04-10 15:12:46[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017890930175781 -- 26-04-10 15:12:47[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012877941131592 -- 26-04-10 15:12:48[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013115882873535 -- 26-04-10 15:12:48[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020773887634277 -- 26-04-10 15:12:48[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090360641479492 -- 26-04-10 15:12:48[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098669528961182 -- 26-04-10 15:12:49[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010612964630127 -- 26-04-10 15:12:49[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010668992996216 -- 26-04-10 15:12:49[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011965036392212 -- 26-04-10 15:13:10[麦浩升-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010365009307861 -- 26-04-10 15:13:32[麦浩升-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.0023760795593262 -- 26-04-10 15:13:32[麦浩升-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.0023961067199707 -- 26-04-10 15:13:32[麦浩升-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.0020699501037598 -- 26-04-10 15:13:32[麦浩升-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.0023419857025146 -- 26-04-10 15:13:32[麦浩升-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.0024118423461914 -- 26-04-10 15:13:32[麦浩升-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.016965866088867 -- 26-04-10 15:13:33[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8618 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029299259185791 -- 26-04-10 15:13:33[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8618 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 = 8618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013890266418457 -- 26-04-10 15:13:33[麦浩升-364] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023380994796753 -- 26-04-10 15:14:05[麦浩升-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.0022499561309814 -- 26-04-10 15:14:05[麦浩升-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.0022099018096924 -- 26-04-10 15:14:05[麦浩升-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.0020029544830322 -- 26-04-10 15:14:05[麦浩升-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.0021848678588867 -- 26-04-10 15:14:05[麦浩升-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.0021660327911377 -- 26-04-10 15:14:05[麦浩升-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.0097060203552246 -- 26-04-10 15:18:43[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 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 = 8618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015408992767334 -- 26-04-10 15:18:43[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010748147964478 -- 26-04-10 15:18:48[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010718107223511 -- 26-04-10 15:18:48[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 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 = 8618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020668506622314 -- 26-04-10 15:18:48[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012337923049927 -- 26-04-10 15:29:07[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 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 = 8618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015161037445068 -- 26-04-10 15:29:07[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010804891586304 -- 26-04-10 15:29:12[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012301921844482 -- 26-04-10 15:29:13[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 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 = 8618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021510124206543 -- 26-04-10 15:29:13[石绍云-369] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228618%22}&event=&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 369 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019676923751831 -- 26-04-10 15:29:17 -- /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.015681982040405 -- 26-04-10 15:29:17[石绍云-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015939950942993 -- 26-04-10 15:29:36 -- /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.023951053619385 -- 26-04-10 15:29:38[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025289058685303 -- 26-04-10 15:29:38[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024540424346924 -- 26-04-10 15:29:38[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026519298553467 -- 26-04-10 15:29:38[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024819374084473 -- 26-04-10 15:29:38[李晓庆-370] -- /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 = 370 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024361610412598 -- 26-04-10 15:29:38[李晓庆-370] -- /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 = 370 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030173063278198 -- 26-04-10 15:29:41[李晓庆-370] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00394606590271 -- 26-04-10 15:29:41[李晓庆-370] -- /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 = 370 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.042883157730103 -- 26-04-10 15:29:41[李晓庆-370] -- /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.0094840526580811 -- 26-04-10 16:32:23[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228370%22}&event=&offwork_id=8370 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 = 8370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015349388122559 -- 26-04-10 16:32:23[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228370%22}&event=&offwork_id=8370 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01160192489624 -- 26-04-10 16:32:42[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228370%22}&event=&offwork_id=8370 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 = 8370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020139217376709 -- 26-04-10 16:32:42[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228370%22}&event=&offwork_id=8370 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012332916259766 -- 26-04-10 16:32:54[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228315%22}&event=&offwork_id=8315 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 = 8315 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021429061889648 -- 26-04-10 16:32:54[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228315%22}&event=&offwork_id=8315 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021023988723755 -- 26-04-10 16:37:33[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228357%22}&event=&offwork_id=8357 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 = 8357 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024428367614746 -- 26-04-10 16:37:33[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228357%22}&event=&offwork_id=8357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099408626556396 -- 26-04-10 16:40:24[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228505%22}&event=&offwork_id=8505 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 = 8505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016241073608398 -- 26-04-10 16:40:24[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228505%22}&event=&offwork_id=8505 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085141658782959 -- 26-04-10 16:40:31[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228503%22}&event=&offwork_id=8503 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 = 8503 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013799667358398 -- 26-04-10 16:40:31[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228503%22}&event=&offwork_id=8503 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023092985153198 -- 26-04-10 16:40:38[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228480%22}&event=&offwork_id=8480 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 = 8480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021438598632812 -- 26-04-10 16:40:38[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228480%22}&event=&offwork_id=8480 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022118091583252 -- 26-04-10 16:40:44[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228472%22}&event=&offwork_id=8472 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 = 8472 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019121170043945 -- 26-04-10 16:40:44[张志强-319] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228472%22}&event=&offwork_id=8472 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087358951568604 -- 26-04-10 17:03:17 -- /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.012104988098145 -- 26-04-10 17:03:17 -- /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.0029518604278564 -- 26-04-10 17:03:17 -- /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.0033559799194336 -- 26-04-10 17:03:17 -- /buz/hr/index.php/hrmgmt/hr_approval_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GuanGuan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026419162750244 -- 26-04-10 17:03:17[关云-169] -- /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= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010890007019043 -- 26-04-10 17:03:18[关云-169] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010907888412476 -- 26-04-10 17:03:24[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8618 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 = 8618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001723051071167 -- 26-04-10 17:03:24[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013962030410767 -- 26-04-10 17:03:27[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008882999420166 -- 26-04-10 17:03:27[关云-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089590549468994 -- 26-04-10 17:03:28[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8613 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 = 8613 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014050006866455 -- 26-04-10 17:03:28[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8613 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012469053268433 -- 26-04-10 17:03:29[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8613 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084109306335449 -- 26-04-10 17:03:30[关云-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018099069595337 -- 26-04-10 17:03:30[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8612 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 = 8612 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019590854644775 -- 26-04-10 17:03:30[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?offwork_id=8612 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011335134506226 -- 26-04-10 17:03:31[关云-169] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8612 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010632991790771 -- 26-04-10 17:03:32[关云-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011045932769775 -- 26-04-10 18:10:46 -- /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.011745929718018 -- 26-04-10 18:10:47[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002626895904541 -- 26-04-10 18:10:47[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026230812072754 -- 26-04-10 18:10:47[廖茂玲-289] -- /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 = 289 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00335693359375 -- 26-04-10 18:10:47[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026450157165527 -- 26-04-10 18:10:47[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025818347930908 -- 26-04-10 18:10:47[廖茂玲-289] -- /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 = 289 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01993989944458 -- 26-04-10 18:10:50[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031020641326904 -- 26-04-10 18:10:50[廖茂玲-289] -- /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 = 289 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027642250061035 -- 26-04-10 18:10:50[廖茂玲-289] -- /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.020824193954468 -- 26-04-10 18:10:52[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024049282073975 -- 26-04-10 18:10:52[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00242018699646 -- 26-04-10 18:10:52[廖茂玲-289] -- /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 = 289 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025451183319092 -- 26-04-10 18:10:52[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024240016937256 -- 26-04-10 18:10:52[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023758411407471 -- 26-04-10 18:10:52[廖茂玲-289] -- /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 = 289 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017147064208984 -- 26-04-10 18:10:55[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017409324645996 -- 26-04-10 18:10:55[廖茂玲-289] -- /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 = 289 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017259120941162 -- 26-04-10 18:10:55[廖茂玲-289] -- /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.011928081512451 -- 26-04-10 18:11:00[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018913984298706 -- 26-04-10 18:11:02[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011619806289673 -- 26-04-10 18:11:02[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017123937606812 -- 26-04-10 18:11:02[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013403177261353 -- 26-04-10 18:11:02[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016784906387329 -- 26-04-10 18:11:02[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012871980667114 -- 26-04-10 18:11:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096559524536133 -- 26-04-10 18:11:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011667013168335 -- 26-04-10 18:11:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083119869232178 -- 26-04-10 18:11:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021072149276733 -- 26-04-10 18:11:04[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020661115646362 -- 26-04-10 18:11:04[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021071910858154 -- 26-04-10 18:11:04[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074079036712646 -- 26-04-10 18:11:04[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084841251373291 -- 26-04-10 18:11:04[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00850510597229 -- 26-04-10 18:11:05[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013972997665405 -- 26-04-10 18:11:05[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099599361419678 -- 26-04-10 18:11:05[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014575958251953 -- 26-04-10 18:11:05[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017791986465454 -- 26-04-10 18:11:05[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01114296913147 -- 26-04-10 18:11:05[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016138076782227 -- 26-04-10 18:11:06[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016296863555908 -- 26-04-10 18:11:06[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076310634613037 -- 26-04-10 18:11:07[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008228063583374 -- 26-04-10 18:11:44[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007922887802124 -- 26-04-10 18:11:48[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01661205291748 -- 26-04-10 18:12:01[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024549961090088 -- 26-04-10 18:12:01[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002471923828125 -- 26-04-10 18:12:01[廖茂玲-289] -- /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 = 289 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025720596313477 -- 26-04-10 18:12:01[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024590492248535 -- 26-04-10 18:12:01[廖茂玲-289] -- /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 = 289 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023880004882812 -- 26-04-10 18:12:01[廖茂玲-289] -- /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 = 289 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015167951583862 -- 26-04-10 18:12:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8619 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035412311553955 -- 26-04-10 18:12:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8619 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 = 8619 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017099380493164 -- 26-04-10 18:12:03[廖茂玲-289] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025348901748657 -- 26-04-10 20:45:18 -- /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.0023720264434814 -- 26-04-10 20:45:18 -- /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.0032589435577393 -- 26-04-10 20:45:18 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoRong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026359558105469 -- 26-04-10 20:45:18[高蓉-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.012156963348389 -- 26-04-10 20:45:26[高蓉-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.0024230480194092 -- 26-04-10 20:45:26[高蓉-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.002324104309082 -- 26-04-10 20:45:26[高蓉-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.0032539367675781 -- 26-04-10 20:45:26[高蓉-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.0022971630096436 -- 26-04-10 20:45:26[高蓉-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.0022799968719482 -- 26-04-10 20:45:26[高蓉-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.0097839832305908 -- 26-04-10 20:45:28[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028529167175293 -- 26-04-10 20:45:28[高蓉-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.0028419494628906 -- 26-04-10 20:45:28[高蓉-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.012737989425659 -- 26-04-10 20:45:29[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090780258178711 -- 26-04-10 20:45:30[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010937929153442 -- 26-04-10 20:45:30[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0102858543396 -- 26-04-10 20:45:30[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016026973724365 -- 26-04-10 20:45:50[高蓉-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.0026481151580811 -- 26-04-10 20:45:50[高蓉-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.0026509761810303 -- 26-04-10 20:45:50[高蓉-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.0029580593109131 -- 26-04-10 20:45:50[高蓉-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.0025880336761475 -- 26-04-10 20:45:50[高蓉-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.0026259422302246 -- 26-04-10 20:45:50[高蓉-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.0078389644622803 -- 26-04-10 20:46:00[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001615047454834 -- 26-04-10 20:46:00[高蓉-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.0021460056304932 -- 26-04-10 20:46:00[高蓉-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.011897087097168 -- 26-04-10 20:46:01[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011465072631836 -- 26-04-10 20:46:02[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01031494140625 -- 26-04-10 20:46:03[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085999965667725 -- 26-04-10 20:46:03[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010507106781006 -- 26-04-10 20:46:03[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010361909866333 -- 26-04-10 20:46:03[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093419551849365 -- 26-04-10 20:46:03[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011558055877686 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012977123260498 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076460838317871 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075950622558594 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012112855911255 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010345935821533 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019908905029297 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019544839859009 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071489810943604 -- 26-04-10 20:46:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006854772567749 -- 26-04-10 20:46:05[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090250968933105 -- 26-04-10 20:46:05[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088720321655273 -- 26-04-10 20:46:05[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080859661102295 -- 26-04-10 20:46:05[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016712188720703 -- 26-04-10 20:46:12[高蓉-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010846853256226 -- 26-04-10 20:46:24[高蓉-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.0024158954620361 -- 26-04-10 20:46:24[高蓉-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.002446174621582 -- 26-04-10 20:46:24[高蓉-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.0024349689483643 -- 26-04-10 20:46:24[高蓉-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.0023660659790039 -- 26-04-10 20:46:24[高蓉-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.0023660659790039 -- 26-04-10 20:46:24[高蓉-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.0082039833068848 -- 26-04-10 20:53:53 -- /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.0016140937805176 -- 26-04-10 20:53:53 -- /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.0021469593048096 -- 26-04-10 20:53:53 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiaoYuBin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018410682678223 -- 26-04-10 20:53:53[廖雨滨-2785] -- /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.0099189281463623 -- 26-04-10 20:53:54[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023610591888428 -- 26-04-10 20:53:54[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023050308227539 -- 26-04-10 20:53:54[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023610591888428 -- 26-04-10 20:53:54[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022590160369873 -- 26-04-10 20:53:54[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022420883178711 -- 26-04-10 20:53:54[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010818958282471 -- 26-04-10 20:54:28[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024580955505371 -- 26-04-10 20:54:28[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002399206161499 -- 26-04-10 20:54:28[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023791790008545 -- 26-04-10 20:54:28[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023789405822754 -- 26-04-10 20:54:28[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023930072784424 -- 26-04-10 20:54:28[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018554925918579 -- 26-04-10 20:54:31[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030500888824463 -- 26-04-10 20:54:31[廖雨滨-2785] -- /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 = 2785 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030341148376465 -- 26-04-10 20:54:31[廖雨滨-2785] -- /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 = 182 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013143062591553 -- 26-04-10 20:54:35[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017665863037109 -- 26-04-10 20:54:40[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011842966079712 -- 26-04-10 20:54:41[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007378101348877 -- 26-04-10 20:54:41[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074288845062256 -- 26-04-10 20:54:41[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011245012283325 -- 26-04-10 20:54:42[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017381191253662 -- 26-04-10 20:54:42[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010217905044556 -- 26-04-10 20:54:43[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010724067687988 -- 26-04-10 20:54:43[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011799097061157 -- 26-04-10 20:54:43[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080339908599854 -- 26-04-10 20:54:44[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023303985595703 -- 26-04-10 20:54:44[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027463912963867 -- 26-04-10 20:54:45[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020719051361084 -- 26-04-10 20:54:45[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011749982833862 -- 26-04-10 20:54:45[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024140119552612 -- 26-04-10 20:54:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067861080169678 -- 26-04-10 20:54:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076620578765869 -- 26-04-10 20:54:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095419883728027 -- 26-04-10 20:54:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01191782951355 -- 26-04-10 20:54:47[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008634090423584 -- 26-04-10 20:54:48[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083341598510742 -- 26-04-10 20:54:48[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016654014587402 -- 26-04-10 20:54:48[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017185926437378 -- 26-04-10 20:54:49[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084080696105957 -- 26-04-10 20:54:49[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099670886993408 -- 26-04-10 20:54:49[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010040998458862 -- 26-04-10 20:54:49[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090110301971436 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010639905929565 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091409683227539 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071969032287598 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020601987838745 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093519687652588 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012833833694458 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010128021240234 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069820880889893 -- 26-04-10 20:54:50[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010120868682861 -- 26-04-10 20:54:51[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01210618019104 -- 26-04-10 20:54:51[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018594026565552 -- 26-04-10 20:54:51[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01214599609375 -- 26-04-10 20:54:51[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021790027618408 -- 26-04-10 20:54:51[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096421241760254 -- 26-04-10 20:54:52[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01111102104187 -- 26-04-10 20:54:52[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072410106658936 -- 26-04-10 20:54:52[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010555982589722 -- 26-04-10 20:54:52[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010078191757202 -- 26-04-10 20:54:54[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096859931945801 -- 26-04-10 20:54:54[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080020427703857 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089640617370605 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095560550689697 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073399543762207 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075910091400146 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086619853973389 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022971868515015 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020368099212646 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085699558258057 -- 26-04-10 20:54:55[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016481876373291 -- 26-04-10 20:55:01[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01565408706665 -- 26-04-10 20:55:01[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009080171585083 -- 26-04-10 20:55:02[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011012077331543 -- 26-04-10 20:55:02[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012765884399414 -- 26-04-10 20:55:03[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097160339355469 -- 26-04-10 20:56:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019581317901611 -- 26-04-10 20:56:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019378662109375 -- 26-04-10 20:56:49[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018990039825439 -- 26-04-10 20:56:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018699169158936 -- 26-04-10 20:56:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018999576568604 -- 26-04-10 20:56:49[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021923065185547 -- 26-04-10 20:56:53[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025780200958252 -- 26-04-10 20:56:53[廖雨滨-2785] -- /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 = 2785 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026319026947021 -- 26-04-10 20:56:53[廖雨滨-2785] -- /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 = 182 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074648857116699 -- 26-04-10 20:56:59[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020207166671753 -- 26-04-10 20:57:16[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017323017120361 -- 26-04-10 20:57:17[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017241954803467 -- 26-04-10 20:57:18[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099480152130127 -- 26-04-10 20:57:22[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076711177825928 -- 26-04-10 20:57:22[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070071220397949 -- 26-04-10 20:57:22[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016456127166748 -- 26-04-10 20:57:22[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022639989852905 -- 26-04-10 20:57:22[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019120931625366 -- 26-04-10 20:57:23[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092329978942871 -- 26-04-10 20:57:24[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018406867980957 -- 26-04-10 20:57:24[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090048313140869 -- 26-04-10 20:57:24[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0123450756073 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079421997070312 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072031021118164 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071001052856445 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010347127914429 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020380973815918 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021533966064453 -- 26-04-10 20:57:25[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021721124649048 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084102153778076 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090148448944092 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086719989776611 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010430097579956 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089671611785889 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01697301864624 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090479850769043 -- 26-04-10 20:57:26[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=calc_annualLeave_balance select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011437892913818 -- 26-04-10 20:59:34[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080869197845459 -- 26-04-10 20:59:58[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019011497497559 -- 26-04-10 20:59:58[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019190311431885 -- 26-04-10 20:59:58[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018777847290039 -- 26-04-10 20:59:58[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018248558044434 -- 26-04-10 20:59:58[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018439292907715 -- 26-04-10 20:59:58[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01810097694397 -- 26-04-10 20:59:59[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033259391784668 -- 26-04-10 20:59:59[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017378330230713 -- 26-04-10 20:59:59[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095610618591309 -- 26-04-10 21:00:42[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021898746490479 -- 26-04-10 21:00:42[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021770000457764 -- 26-04-10 21:00:42[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021698474884033 -- 26-04-10 21:00:42[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021250247955322 -- 26-04-10 21:00:42[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021390914916992 -- 26-04-10 21:00:42[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008558988571167 -- 26-04-10 21:02:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019850730895996 -- 26-04-10 21:02:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001967191696167 -- 26-04-10 21:02:22[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019650459289551 -- 26-04-10 21:02:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019259452819824 -- 26-04-10 21:02:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019400119781494 -- 26-04-10 21:02:22[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020603179931641 -- 26-04-10 21:02:23[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029160976409912 -- 26-04-10 21:02:23[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019550323486328 -- 26-04-10 21:02:23[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011098146438599 -- 26-04-10 21:07:55[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024869441986084 -- 26-04-10 21:07:55[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024600028991699 -- 26-04-10 21:07:55[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021431446075439 -- 26-04-10 21:07:55[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024449825286865 -- 26-04-10 21:07:55[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024490356445312 -- 26-04-10 21:07:55[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078239440917969 -- 26-04-10 21:07:56[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032310485839844 -- 26-04-10 21:07:56[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015039443969727 -- 26-04-10 21:07:56[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019280910491943 -- 26-04-10 21:12:18[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228621%22}&event=&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021641254425049 -- 26-04-10 21:12:18[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228621%22}&event=&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022990942001343 -- 26-04-10 21:12:20[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=approve_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022325038909912 -- 26-04-10 21:12:20[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228621%22}&event=&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017049312591553 -- 26-04-10 21:12:20[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228621%22}&event=&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010228872299194 -- 26-04-10 21:14:03[高蓉-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.0022759437561035 -- 26-04-10 21:14:03[高蓉-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.0022649765014648 -- 26-04-10 21:14:03[高蓉-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.0026218891143799 -- 26-04-10 21:14:03[高蓉-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.0022180080413818 -- 26-04-10 21:14:03[高蓉-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.0022220611572266 -- 26-04-10 21:14:03[高蓉-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.012911081314087 -- 26-04-10 21:14:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8620 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022380352020264 -- 26-04-10 21:14:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8620 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 = 8620 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016570091247559 -- 26-04-10 21:14:04[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8620 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010066986083984 -- 26-04-10 21:30:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023941993713379 -- 26-04-10 21:30:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023260116577148 -- 26-04-10 21:30:16[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002316951751709 -- 26-04-10 21:30:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022890567779541 -- 26-04-10 21:30:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022881031036377 -- 26-04-10 21:30:16[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083029270172119 -- 26-04-10 21:30:16[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039029121398926 -- 26-04-10 21:30:16[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015020370483398 -- 26-04-10 21:30:16[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082769393920898 -- 26-04-10 21:30:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021159648895264 -- 26-04-10 21:30:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019137859344482 -- 26-04-10 21:30:22[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019040107727051 -- 26-04-10 21:30:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018630027770996 -- 26-04-10 21:30:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019829273223877 -- 26-04-10 21:30:22[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011471033096313 -- 26-04-10 21:30:45[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025408267974854 -- 26-04-10 21:30:45[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025241374969482 -- 26-04-10 21:30:45[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024890899658203 -- 26-04-10 21:30:45[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024800300598145 -- 26-04-10 21:30:45[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024669170379639 -- 26-04-10 21:30:45[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015093088150024 -- 26-04-10 21:30:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015499591827393 -- 26-04-10 21:30:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016360282897949 -- 26-04-10 21:30:46[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02034592628479 -- 26-04-10 21:30:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020101070404053 -- 26-04-10 21:30:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019681453704834 -- 26-04-10 21:30:49[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016300678253174 -- 26-04-10 21:30:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019500255584717 -- 26-04-10 21:30:49[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019400119781494 -- 26-04-10 21:30:49[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010858058929443 -- 26-04-10 21:35:23[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021958351135254 -- 26-04-10 21:35:23[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021960735321045 -- 26-04-10 21:35:23[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021688938140869 -- 26-04-10 21:35:23[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021500587463379 -- 26-04-10 21:35:23[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021491050720215 -- 26-04-10 21:35:23[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080389976501465 -- 26-04-10 21:35:24[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031909942626953 -- 26-04-10 21:35:24[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014808177947998 -- 26-04-10 21:35:24[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012742042541504 -- 26-04-10 22:02:51[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228621%22}&event=&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021138191223145 -- 26-04-10 22:02:51[肖超-483] -- /buz/hr/index.php/hrmgmt/hr_offwork?para={%22event%22:%22%22,%22offwork_id%22:%228621%22}&event=&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085878372192383 -- 26-04-10 22:36:15 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016210079193115 -- 26-04-10 22:36:15 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021560192108154 -- 26-04-10 22:36:15 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiaoYuBin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018579959869385 -- 26-04-10 22:36:15[廖雨滨-2785] -- /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.0091979503631592 -- 26-04-10 22:36:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023040771484375 -- 26-04-10 22:36:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023500919342041 -- 26-04-10 22:36:16[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022079944610596 -- 26-04-10 22:36:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021419525146484 -- 26-04-10 22:36:16[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00211501121521 -- 26-04-10 22:36:16[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011601209640503 -- 26-04-10 22:36:17[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2025 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038728713989258 -- 26-04-10 22:36:17[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 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 = 8621 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002126932144165 -- 26-04-10 22:36:17[廖雨滨-2785] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=8621 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2785 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014663934707642 -- 26-04-10 22:36:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020179748535156 -- 26-04-10 22:36:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00201416015625 -- 26-04-10 22:36:22[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019981861114502 -- 26-04-10 22:36:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019822120666504 -- 26-04-10 22:36:22[廖雨滨-2785] -- /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 = 2785 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019891262054443 -- 26-04-10 22:36:22[廖雨滨-2785] -- /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 = 2785 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------