Time: 0.0092480182647705 -- 26-06-07 01:06:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017769336700439 -- 26-06-07 01:06:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037081241607666 -- 26-06-07 01:06:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2500,updatedby_id = 2500 where extrafareApply_id = 78939 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02473521232605 -- 26-06-07 01:06:24[唐桂-2500] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015630006790161 -- 26-06-07 01:06:35[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016710758209229 -- 26-06-07 01:06:35[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015169143676758 -- 26-06-07 01:07:11[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017659664154053 -- 26-06-07 01:07:11[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031559467315674 -- 26-06-07 01:07:11[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2500,updatedby_id = 2500 where extrafareApply_id = 78939 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045149326324463 -- 26-06-07 01:07:11[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2500,updatedby_id = 2500 where otherfee_id = 13333 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013190031051636 -- 26-06-07 01:07:14[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017528533935547 -- 26-06-07 01:07:15[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038530826568604 -- 26-06-07 01:07:15[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2500,updatedby_id = 2500 where extrafareApply_id = 78939 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029129981994629 -- 26-06-07 01:07:15[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2500,updatedby_id = 2500 where otherfee_id = 13333 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019446849822998 -- 26-06-07 01:07:15[唐桂-2500] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083022117614746 -- 26-06-07 01:50:18[曾璟洋-2988] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009652853012085 -- 26-06-07 09:02:08[杨林-2511] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0068650245666504 -- 26-06-07 09:02:18[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013070106506348 -- 26-06-07 09:02:18[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002777099609375 -- 26-06-07 09:02:18[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 78940 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091469287872314 -- 26-06-07 09:03:24[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017399787902832 -- 26-06-07 09:03:24[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077500343322754 -- 26-06-07 09:03:27[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015239715576172 -- 26-06-07 09:03:27[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029950141906738 -- 26-06-07 09:03:27[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 78940 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032680034637451 -- 26-06-07 09:03:27[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2511,updatedby_id = 2511 where otherfee_id = 13334 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012564897537231 -- 26-06-07 09:03:27[杨林-2511] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011337041854858 -- 26-06-07 09:58:37[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016548633575439 -- 26-06-07 09:58:37[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032339096069336 -- 26-06-07 09:58:37[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2500,updatedby_id = 2500 where extrafareApply_id = 78942 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021302938461304 -- 26-06-07 09:58:42[唐桂-2500] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088238716125488 -- 26-06-07 09:59:00[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017421245574951 -- 26-06-07 09:59:00[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083329677581787 -- 26-06-07 10:00:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015151500701904 -- 26-06-07 10:00:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028989315032959 -- 26-06-07 10:00:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2500,updatedby_id = 2500 where extrafareApply_id = 78942 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031650066375732 -- 26-06-07 10:00:19[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2500,updatedby_id = 2500 where otherfee_id = 13335 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090739727020264 -- 26-06-07 10:00:21[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015408992767334 -- 26-06-07 10:00:21[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028870105743408 -- 26-06-07 10:00:21[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2500,updatedby_id = 2500 where extrafareApply_id = 78942 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031630992889404 -- 26-06-07 10:00:21[唐桂-2500] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2500,updatedby_id = 2500 where otherfee_id = 13335 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016813039779663 -- 26-06-07 10:00:22[唐桂-2500] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020722150802612 -- 26-06-07 10:23:13 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014970302581787 -- 26-06-07 10:23:13 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 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.0024452209472656 -- 26-06-07 10:23:13 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='AMeng' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017330646514893 -- 26-06-07 10:23:13[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01387882232666 -- 26-06-07 10:23:15[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.044546127319336 -- 26-06-07 10:32:55[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032029151916504 -- 26-06-07 10:32:55[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032331943511963 -- 26-06-07 10:32:55[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030980110168457 -- 26-06-07 10:32:55[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003079891204834 -- 26-06-07 10:32:55[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082509517669678 -- 26-06-07 10:33:23 -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015590190887451 -- 26-06-07 10:33:23 -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 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.0024449825286865 -- 26-06-07 10:33:23 -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 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='ZongHeGuanLiBuLiuLiYan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017459392547607 -- 26-06-07 10:33:23[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001533031463623 -- 26-06-07 10:33:23[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002622127532959 -- 26-06-07 10:33:23[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select count(1) cnt from dbsys.sys_contact c left join dbsys.sys_acct a on c.acct_id = a.acct_id where c.parent_cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015430450439453 -- 26-06-07 10:33:23[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select a.root_acct_id, a.acct_id from dbsys.sys_contact c left join dbsys.sys_acct a on c.acct_id = a.acct_id where c.cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015339851379395 -- 26-06-07 10:33:23[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select ap.para_value from dbsys.sys_acct_para ap left join dbsys.sys_para a on ap.para_id = a.para_id where ap.acct_id in (2) and a.tag = 'base_multiAccount_switchModeId' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014369487762451 -- 26-06-07 10:33:23[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select ap.para_value from dbsys.sys_acct_para ap left join dbsys.sys_para a on ap.para_id = a.para_id where ap.acct_id in (2) and a.tag = 'base_multiAccount_switchModeId' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010164022445679 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 131381 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014650821685791 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select payment_id from dbthird.thd_payment where oa_payment_id = 131381 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019772052764893 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 144320 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018751621246338 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6613955 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001410961151123 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014889240264893 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select * from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014631748199463 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6613955 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013289451599121 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013430118560791 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001413106918335 -- 26-06-07 11:08:33[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%22131381%22}&event=edit_payment&payment_id=131381 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079391002655029 -- 26-06-07 12:42:03 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015561580657959 -- 26-06-07 12:42:03 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 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.002147912979126 -- 26-06-07 12:42:03 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 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='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017769336700439 -- 26-06-07 12:42:03[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094020366668701 -- 26-06-07 12:42:04[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010340929031372 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 131457 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022339820861816 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select payment_id from dbthird.thd_payment where oa_payment_id = 131457 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023910999298096 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 144387 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019009113311768 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6619397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017139911651611 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018999576568604 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select * from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018601417541504 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6619397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017361640930176 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017259120941162 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017640590667725 -- 26-06-07 12:42:05[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=131457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086681842803955 -- 26-06-07 12:42:06[张体海-1176] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=131457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01866602897644 -- 26-06-07 12:42:06[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011101961135864 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 78518 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018360614776611 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 78518 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021588802337646 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 78518 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022499561309814 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 78518 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001615047454834 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016751289367676 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017859935760498 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6585676 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016219615936279 -- 26-06-07 12:42:07[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78518 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076539516448975 -- 26-06-07 12:42:08[张体海-1176] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=78518 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017683982849121 -- 26-06-07 12:42:09[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090699195861816 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50041 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 50041 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021369457244873 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50041 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 50041 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001784086227417 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50041 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6619723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016210079193115 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50041 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001816987991333 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50041 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6619723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016059875488281 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50041 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010998964309692 -- 26-06-07 12:42:10[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=50041 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076858997344971 -- 26-06-07 12:42:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089759826660156 -- 26-06-07 12:42:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50040 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 50040 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022149085998535 -- 26-06-07 12:42:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50040 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 50040 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002133846282959 -- 26-06-07 12:42:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50040 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6619639 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016300678253174 -- 26-06-07 12:42:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50040 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001816987991333 -- 26-06-07 12:42:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50040 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6619639 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001615047454834 -- 26-06-07 12:42:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50040 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092191696166992 -- 26-06-07 12:42:13[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=50040 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021916151046753 -- 26-06-07 12:42:13[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015122890472412 -- 26-06-07 12:42:14[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50039 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 50039 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021250247955322 -- 26-06-07 12:42:14[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50039 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 50039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020949840545654 -- 26-06-07 12:42:14[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50039 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6619631 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016071796417236 -- 26-06-07 12:42:14[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018050670623779 -- 26-06-07 12:42:14[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50039 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6619631 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016739368438721 -- 26-06-07 12:42:14[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009242057800293 -- 26-06-07 12:42:15[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=50039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013524055480957 -- 26-06-07 12:42:15[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083110332489014 -- 26-06-07 12:42:16[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50038 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 50038 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020840167999268 -- 26-06-07 12:42:16[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50038 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 50038 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016560554504395 -- 26-06-07 12:42:16[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50038 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6619580 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014841556549072 -- 26-06-07 12:42:16[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50038 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016579627990723 -- 26-06-07 12:42:16[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50038 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6619580 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014979839324951 -- 26-06-07 12:42:16[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50038 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01362419128418 -- 26-06-07 12:42:17[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=50038 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012302875518799 -- 26-06-07 12:42:17[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092589855194092 -- 26-06-07 12:42:18[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50037 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 50037 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022640228271484 -- 26-06-07 12:42:18[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50037 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 50037 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021898746490479 -- 26-06-07 12:42:18[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50037 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6619468 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016651153564453 -- 26-06-07 12:42:18[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50037 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018999576568604 -- 26-06-07 12:42:18[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50037 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6619468 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016660690307617 -- 26-06-07 12:42:18[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50037 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011927843093872 -- 26-06-07 12:42:19[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=50037 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078041553497314 -- 26-06-07 12:42:19[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086889266967773 -- 26-06-07 14:06:29[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016758441925049 -- 26-06-07 14:06:29[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003119945526123 -- 26-06-07 14:06:29[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 3003,updatedby_id = 3003 where extrafareApply_id = 78963 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01954197883606 -- 26-06-07 14:06:31[陈伦建-3003] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090949535369873 -- 26-06-07 14:06:37[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017750263214111 -- 26-06-07 14:06:37[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081219673156738 -- 26-06-07 14:07:17[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015671253204346 -- 26-06-07 14:07:17[陈伦建-3003] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016406059265137 -- 26-06-07 14:07:17[陈伦建-3003] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011247158050537 -- 26-06-07 15:03:45[胡晓露-2526] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086159706115723 -- 26-06-07 15:03:55[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015192031860352 -- 26-06-07 15:03:55[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028438568115234 -- 26-06-07 15:03:55[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2526,updatedby_id = 2526 where extrafareApply_id = 78964 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013089895248413 -- 26-06-07 15:03:56[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001392126083374 -- 26-06-07 15:03:56[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079300403594971 -- 26-06-07 15:07:21[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014989376068115 -- 26-06-07 15:07:22[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010640859603882 -- 26-06-07 15:07:27[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015048980712891 -- 26-06-07 15:07:27[胡晓露-2526] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014739036560059 -- 26-06-07 15:07:28[胡晓露-2526] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087928771972656 -- 26-06-07 15:24:02 -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016789436340332 -- 26-06-07 15:24:02 -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 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.0022850036621094 -- 26-06-07 15:24:02 -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 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='ZongHeGuanLiBuLiuLiYan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018630027770996 -- 26-06-07 15:24:02[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016531944274902 -- 26-06-07 15:24:02[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027391910552979 -- 26-06-07 15:24:02[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select count(1) cnt from dbsys.sys_contact c left join dbsys.sys_acct a on c.acct_id = a.acct_id where c.parent_cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016469955444336 -- 26-06-07 15:24:02[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select a.root_acct_id, a.acct_id from dbsys.sys_contact c left join dbsys.sys_acct a on c.acct_id = a.acct_id where c.cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016679763793945 -- 26-06-07 15:24:02[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select ap.para_value from dbsys.sys_acct_para ap left join dbsys.sys_para a on ap.para_id = a.para_id where ap.acct_id in (2) and a.tag = 'base_multiAccount_switchModeId' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015490055084229 -- 26-06-07 15:24:02[刘丽艳-347] -- /buz/oa/index.php/oamgmt/change_isSwitchAcct?appid=ww5262fb147810c303&agentid=1000022 select ap.para_value from dbsys.sys_acct_para ap left join dbsys.sys_para a on ap.para_id = a.para_id where ap.acct_id in (2) and a.tag = 'base_multiAccount_switchModeId' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081729888916016 -- 26-06-07 16:08:43[杨志涛-2609] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01515793800354 -- 26-06-07 16:08:55[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016770362854004 -- 26-06-07 16:08:55[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030438899993896 -- 26-06-07 16:08:55[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2609,updatedby_id = 2609 where extrafareApply_id = 78965 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069770812988281 -- 26-06-07 16:08:56[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013809204101562 -- 26-06-07 16:08:56[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012456893920898 -- 26-06-07 16:09:29[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015192031860352 -- 26-06-07 16:09:29[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002938985824585 -- 26-06-07 16:09:29[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2609,updatedby_id = 2609 where extrafareApply_id = 78965 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026960372924805 -- 26-06-07 16:09:29[杨志涛-2609] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2609,updatedby_id = 2609 where otherfee_id = 13345 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008397102355957 -- 26-06-07 16:09:30[杨志涛-2609] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018378973007202 -- 26-06-07 17:29:49[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016880035400391 -- 26-06-07 17:29:49[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035400390625 -- 26-06-07 17:29:49[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78967 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008141040802002 -- 26-06-07 17:29:59[李星-2417] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016349077224731 -- 26-06-07 17:30:14[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017590522766113 -- 26-06-07 17:30:14[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093610286712646 -- 26-06-07 17:35:55[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017759799957275 -- 26-06-07 17:35:55[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034198760986328 -- 26-06-07 17:35:55[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78967 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003000020980835 -- 26-06-07 17:35:55[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2417,updatedby_id = 2417 where otherfee_id = 13350 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013983964920044 -- 26-06-07 17:35:59[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016229152679443 -- 26-06-07 17:35:59[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034549236297607 -- 26-06-07 17:35:59[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78967 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030701160430908 -- 26-06-07 17:35:59[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2417,updatedby_id = 2417 where otherfee_id = 13350 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088331699371338 -- 26-06-07 17:36:00[李星-2417] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095970630645752 -- 26-06-07 17:37:08[李星-2417] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016812086105347 -- 26-06-07 17:37:30[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017690658569336 -- 26-06-07 17:37:30[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035309791564941 -- 26-06-07 17:37:30[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78968 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078401565551758 -- 26-06-07 17:37:36[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015029907226562 -- 26-06-07 17:37:36[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085709095001221 -- 26-06-07 17:37:41[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016520023345947 -- 26-06-07 17:37:41[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029449462890625 -- 26-06-07 17:37:41[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78968 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027999877929688 -- 26-06-07 17:37:41[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2417,updatedby_id = 2417 where otherfee_id = 13351 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071558952331543 -- 26-06-07 17:40:20[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014050006866455 -- 26-06-07 17:40:20[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027229785919189 -- 26-06-07 17:40:20[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78968 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025999546051025 -- 26-06-07 17:40:20[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2417,updatedby_id = 2417 where otherfee_id = 13351 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020846128463745 -- 26-06-07 17:40:23[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012459754943848 -- 26-06-07 17:40:23[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026900768280029 -- 26-06-07 17:40:24[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2417,updatedby_id = 2417 where extrafareApply_id = 78968 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027079582214355 -- 26-06-07 17:40:24[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2417,updatedby_id = 2417 where otherfee_id = 13351 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021522045135498 -- 26-06-07 17:40:24[李星-2417] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079720020294189 -- 26-06-07 17:41:42[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015308856964111 -- 26-06-07 17:41:42[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077130794525146 -- 26-06-07 17:41:47[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014948844909668 -- 26-06-07 17:41:47[李星-2417] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2417 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098090171813965 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78555 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016160011291504 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015029907226562 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016341209411621 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6587341 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001460075378418 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014939308166504 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011329889297485 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087990760803223 -- 26-06-07 18:38:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016144037246704 -- 26-06-07 18:38:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022779941558838 -- 26-06-07 19:31:08[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1885701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2803 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018329620361328 -- 26-06-07 19:31:08[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1885701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016989707946777 -- 26-06-07 19:31:08[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1885701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018510818481445 -- 26-06-07 19:31:08[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1885701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1885701) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021023988723755 -- 26-06-07 19:31:09[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085279941558838 -- 26-06-07 19:31:09[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085132122039795 -- 26-06-07 19:31:09[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%南京办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026803970336914 -- 26-06-07 19:31:15[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080239772796631 -- 26-06-07 19:31:34[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082130432128906 -- 26-06-07 19:32:29[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016701221466064 -- 26-06-07 19:32:29[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017049312591553 -- 26-06-07 19:32:30[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1885701) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017020702362061 -- 26-06-07 19:32:30[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029540061950684 -- 26-06-07 19:32:30[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030660629272461 -- 26-06-07 19:32:30[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022059917449951 -- 26-06-07 19:32:30[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017340183258057 -- 26-06-07 19:32:30[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001755952835083 -- 26-06-07 19:32:31[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032250881195068 -- 26-06-07 19:32:31[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033328533172607 -- 26-06-07 19:32:31[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015532970428467 -- 26-06-07 19:32:31[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014870166778564 -- 26-06-07 19:32:31[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015299320220947 -- 26-06-07 19:32:31[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033650398254395 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026810169219971 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077261924743652 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001474142074585 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001474142074585 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033559799194336 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034680366516113 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071280002593994 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013480186462402 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001399040222168 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027179718017578 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024669170379639 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091650485992432 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017309188842773 -- 26-06-07 19:32:32[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017709732055664 -- 26-06-07 19:32:33[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030889511108398 -- 26-06-07 19:32:33[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029199123382568 -- 26-06-07 19:32:33[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020160913467407 -- 26-06-07 19:32:44[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 and e.extrafare_name like '%中建材%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091111660003662 -- 26-06-07 19:34:22[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016689300537109 -- 26-06-07 19:34:22[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016908645629883 -- 26-06-07 19:34:22[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.30825114250183 -- 26-06-07 19:34:33[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_order_item SELECT o.order_id,o.order_no,o.owner_id FROM dbthird.thd_order o left join dbthird.thd_order_extend o_e on o_e.order_id = o.order_id WHERE o.acct_id = 9 AND o.order_no like '%010018%' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007282018661499 -- 26-06-07 19:34:36[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013518333435059 -- 26-06-07 19:34:36[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013787746429443 -- 26-06-07 19:34:36[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066728591918945 -- 26-06-07 19:34:48[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012240409851074 -- 26-06-07 19:34:48[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012879371643066 -- 26-06-07 19:34:48[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033302307128906 -- 26-06-07 19:34:48[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026490688323975 -- 26-06-07 19:34:48[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078699588775635 -- 26-06-07 19:34:49[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014691352844238 -- 26-06-07 19:34:49[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015170574188232 -- 26-06-07 19:34:49[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031249523162842 -- 26-06-07 19:34:49[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027070045471191 -- 26-06-07 19:34:49[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091361999511719 -- 26-06-07 19:34:50[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017240047454834 -- 26-06-07 19:34:50[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017499923706055 -- 26-06-07 19:34:50[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030429363250732 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027749538421631 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085868835449219 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015919208526611 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016520023345947 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028350353240967 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031938552856445 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091729164123535 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017490386962891 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017671585083008 -- 26-06-07 19:34:51[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031700134277344 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031759738922119 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011435031890869 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016169548034668 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016520023345947 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003075122833252 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 26-06-07 19:34:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009289026260376 -- 26-06-07 19:34:53[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017499923706055 -- 26-06-07 19:34:53[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017809867858887 -- 26-06-07 19:34:53[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031259059906006 -- 26-06-07 19:34:53[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2803,updatedby_id = 2803 where extrafareApply_id = 78969 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028879642486572 -- 26-06-07 19:34:53[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2803,updatedby_id = 2803 where otherfee_id = 75458 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018249034881592 -- 26-06-07 19:34:53[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010112047195435 -- 26-06-07 19:55:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78555 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016248226165771 -- 26-06-07 19:55:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016210079193115 -- 26-06-07 19:55:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018091201782227 -- 26-06-07 19:55:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6587341 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016119480133057 -- 26-06-07 19:55:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015871524810791 -- 26-06-07 19:55:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2278555%22%7D&event=edit_extrafareApply&extrafareApply_id=78555 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012145042419434 -- 26-06-07 19:55:03[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019299983978271 -- 26-06-07 19:55:03[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021905899047852 -- 26-06-07 19:55:03[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098791122436523 -- 26-06-07 19:57:19[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014710426330566 -- 26-06-07 19:57:19[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014750957489014 -- 26-06-07 19:57:19[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016391277313232 -- 26-06-07 19:57:19[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6578727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014770030975342 -- 26-06-07 19:57:19[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014438629150391 -- 26-06-07 19:57:19[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017087936401367 -- 26-06-07 19:57:20[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017205953598022 -- 26-06-07 19:57:20[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090370178222656 -- 26-06-07 19:57:20[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012346982955933 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017390251159668 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017478466033936 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017540454864502 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6578727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017299652099609 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017149448394775 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083081722259521 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020352125167847 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017425060272217 -- 26-06-07 19:58:05[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011852979660034 -- 26-06-07 19:58:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016360282897949 -- 26-06-07 19:58:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092041492462158 -- 26-06-07 19:58:59[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017650127410889 -- 26-06-07 19:58:59[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073120594024658 -- 26-06-07 19:59:00[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014150142669678 -- 26-06-07 19:59:00[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024418115615845 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016510486602783 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089378356933594 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017719268798828 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014539957046509 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015060901641846 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024917840957642 -- 26-06-07 19:59:01[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017168521881104 -- 26-06-07 19:59:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085330009460449 -- 26-06-07 19:59:02[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016210079193115 -- 26-06-07 19:59:03[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083138942718506 -- 26-06-07 19:59:04[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016260147094727 -- 26-06-07 19:59:04[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078580379486084 -- 26-06-07 19:59:04[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093448162078857 -- 26-06-07 20:00:39[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017991065979004 -- 26-06-07 20:00:39[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021879911422729 -- 26-06-07 20:00:50[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016069412231445 -- 26-06-07 20:00:50[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008620023727417 -- 26-06-07 20:00:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016398429870605 -- 26-06-07 20:00:57[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090110301971436 -- 26-06-07 20:01:28 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018110275268555 -- 26-06-07 20:01:28 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 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.0027980804443359 -- 26-06-07 20:01:28 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 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='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020289421081543 -- 26-06-07 20:01:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081551074981689 -- 26-06-07 20:01:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022593021392822 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 78941 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019190311431885 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 78941 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021941661834717 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 78941 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018980503082275 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 78941 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016701221466064 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017099380493164 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018100738525391 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6620134 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017149448394775 -- 26-06-07 20:01:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=78941 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013556957244873 -- 26-06-07 20:01:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=78941 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020088911056519 -- 26-06-07 20:01:40[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088739395141602 -- 26-06-07 20:01:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50024 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 50024 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017638206481934 -- 26-06-07 20:01:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50024 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 50024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017600059509277 -- 26-06-07 20:01:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50024 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 6617995 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015997886657715 -- 26-06-07 20:01:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50024 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017838478088379 -- 26-06-07 20:01:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50024 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6617995 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001629114151001 -- 26-06-07 20:01:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=50024 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015103101730347 -- 26-06-07 20:01:44[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=50024 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089380741119385 -- 26-06-07 20:01:44[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080502033233643 -- 26-06-07 20:04:20[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014951229095459 -- 26-06-07 20:04:20[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010159015655518 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015990734100342 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016350746154785 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00177001953125 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6578727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001572847366333 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015530586242676 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011389970779419 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010442018508911 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018831968307495 -- 26-06-07 20:04:54[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079860687255859 -- 26-06-07 20:06:26[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=undoSubmit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010143995285034 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015912055969238 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016300678253174 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017979145050049 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6578727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015749931335449 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011883974075317 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023101806640625 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018460035324097 -- 26-06-07 20:06:52[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016380071640015 -- 26-06-07 20:07:03[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015408992767334 -- 26-06-07 20:07:03[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011101007461548 -- 26-06-07 20:07:07[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017340183258057 -- 26-06-07 20:07:07[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087270736694336 -- 26-06-07 20:07:08[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017330646514893 -- 26-06-07 20:07:08[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076611042022705 -- 26-06-07 20:07:09[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015301704406738 -- 26-06-07 20:07:09[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089631080627441 -- 26-06-07 20:07:12[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017321109771729 -- 26-06-07 20:07:12[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074379444122314 -- 26-06-07 20:07:12[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014135122299194 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017290115356445 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017368793487549 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018739700317383 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6578727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017130374908447 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017030239105225 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087990760803223 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008922815322876 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00895094871521 -- 26-06-07 20:08:56[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018238067626953 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 78487 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012228488922119 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012369155883789 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001244068145752 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6578727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012249946594238 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012199878692627 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=78487 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2803 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013953924179077 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%南京办-秦湖%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012035131454468 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%秦湖-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094649791717529 -- 26-06-07 20:08:58[秦湖-南京办-2803] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094192028045654 -- 26-06-07 22:58:09[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089678764343262 -- 26-06-07 22:58:09[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065920352935791 -- 26-06-07 22:58:10[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------