Time: 0.01641583442688 -- 26-01-03 09:55:21[刘文帅-1735] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1735 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022458076477051 -- 26-01-03 09:55:21[刘文帅-1735] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1735 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016387939453125 -- 26-01-03 09:55:22[刘文帅-1735] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1735 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016617059707642 -- 26-01-03 09:55:29[刘文帅-1735] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1735 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016474008560181 -- 26-01-03 09:55:29[刘文帅-1735] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1735 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015841007232666 -- 26-01-03 09:55:31[刘文帅-1735] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1735 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015592813491821 -- 26-01-03 10:02:10[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017489910125732 -- 26-01-03 10:02:10[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016780138015747 -- 26-01-03 10:02:14[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016417980194092 -- 26-01-03 10:02:17[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026551008224487 -- 26-01-03 10:02:17[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017244100570679 -- 26-01-03 10:02:23[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023075103759766 -- 26-01-03 10:03:59[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025432825088501 -- 26-01-03 10:03:59[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024925947189331 -- 26-01-03 10:04:01[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021116018295288 -- 26-01-03 10:04:07[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017055988311768 -- 26-01-03 10:04:07[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016888856887817 -- 26-01-03 10:04:10[孙忠磊-379] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017180204391479 -- 26-01-03 13:17:56[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033900737762451 -- 26-01-03 13:17:56[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012109994888306 -- 26-01-03 13:17:56[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 70268 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019355058670044 -- 26-01-03 13:18:01[吴海红-2505] -- /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.017386198043823 -- 26-01-03 13:18:11[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033760070800781 -- 26-01-03 13:18:11[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017297983169556 -- 26-01-03 13:18:37[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033860206604004 -- 26-01-03 13:18:37[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051090717315674 -- 26-01-03 13:18:37[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 70268 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049099922180176 -- 26-01-03 13:18:37[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 2415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023273944854736 -- 26-01-03 13:18:39[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033438205718994 -- 26-01-03 13:18:40[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046110153198242 -- 26-01-03 13:18:40[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 70268 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044209957122803 -- 26-01-03 13:18:40[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 2415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016078948974609 -- 26-01-03 13:18:40[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016568899154663 -- 26-01-03 13:20:55[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032389163970947 -- 26-01-03 13:20:55[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045459270477295 -- 26-01-03 13:20:55[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 70269 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016639947891235 -- 26-01-03 13:20:58[吴海红-2505] -- /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.026608943939209 -- 26-01-03 13:21:08[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003446102142334 -- 26-01-03 13:21:08[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017238855361938 -- 26-01-03 13:21:33[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032711029052734 -- 26-01-03 13:21:33[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046820640563965 -- 26-01-03 13:21:33[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 70269 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049550533294678 -- 26-01-03 13:21:33[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 2416 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016378879547119 -- 26-01-03 13:21:34[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032029151916504 -- 26-01-03 13:21:34[吴海红-2505] -- /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 = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004734992980957 -- 26-01-03 13:21:34[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 70269 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048530101776123 -- 26-01-03 13:21:34[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 2416 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017167091369629 -- 26-01-03 13:21:35[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015866994857788 -- 26-01-03 13:36:31 -- /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.003108024597168 -- 26-01-03 13:36:31 -- /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.0039889812469482 -- 26-01-03 13:36:31 -- /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.0033020973205566 -- 26-01-03 13:36:31[张体海-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.015734910964966 -- 26-01-03 13:36:31 -- /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.016200065612793 -- 26-01-03 13:36:32[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016769886016846 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 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 = 115795 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035839080810547 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select payment_id from dbthird.thd_payment where oa_payment_id = 115795 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003770112991333 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 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 = 133183 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035932064056396 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 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 = 5857817 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030949115753174 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032351016998291 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select * from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032100677490234 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857817 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030739307403564 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030710697174072 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003122091293335 -- 26-01-03 13:36:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115795 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016341209411621 -- 26-01-03 13:36:37[张体海-1176] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=115795 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022233009338379 -- 26-01-03 13:36:37[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017632007598877 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 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 = 115794 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037469863891602 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select payment_id from dbthird.thd_payment where oa_payment_id = 115794 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038199424743652 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 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 = 133182 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037670135498047 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 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 = 5857816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032510757446289 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033009052276611 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select * from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034041404724121 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032830238342285 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032641887664795 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033249855041504 -- 26-01-03 13:36:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016743898391724 -- 26-01-03 13:36:39[张体海-1176] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=115794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027945995330811 -- 26-01-03 13:36:40[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023782014846802 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70188 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038368701934814 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 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 = 70188 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037839412689209 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70188 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044190883636475 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 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 = 70188 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032618045806885 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032780170440674 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034282207489014 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5851996 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032877922058105 -- 26-01-03 13:36:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70188 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022815942764282 -- 26-01-03 13:36:42[张体海-1176] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70188 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015204906463623 -- 26-01-03 13:36:42[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021749019622803 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70187 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034010410308838 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 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 = 70187 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037429332733154 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70187 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044419765472412 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 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 = 70187 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031881332397461 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032210350036621 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033359527587891 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5851990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032010078430176 -- 26-01-03 13:36:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70187 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016601800918579 -- 26-01-03 13:36:44[张体海-1176] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70187 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01816987991333 -- 26-01-03 13:36:45[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017692089080811 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70186 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036270618438721 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 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 = 70186 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039401054382324 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70186 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041220188140869 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 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 = 70186 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034048557281494 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034241676330566 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035238265991211 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5851987 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033788681030273 -- 26-01-03 13:36:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70186 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016036987304688 -- 26-01-03 13:36:46[张体海-1176] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70186 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022740840911865 -- 26-01-03 13:36:47[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017359972000122 -- 26-01-03 13:48:20 -- /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.0033969879150391 -- 26-01-03 13:48:20 -- /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.0042810440063477 -- 26-01-03 13:48:20 -- /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='DengWei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037209987640381 -- 26-01-03 13:48:20[邓薇-553] -- /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= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022562026977539 -- 26-01-03 13:48:21[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01672101020813 -- 26-01-03 13:48:23[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 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 = 43293 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037810802459717 -- 26-01-03 13:48:23[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43293 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037171840667725 -- 26-01-03 13:48:23[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 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 = 5853575 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031919479370117 -- 26-01-03 13:48:23[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033700466156006 -- 26-01-03 13:48:23[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5853575 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031940937042236 -- 26-01-03 13:48:23[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018209934234619 -- 26-01-03 13:48:34[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01612114906311 -- 26-01-03 13:50:10[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031399726867676 -- 26-01-03 13:50:10[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015705823898315 -- 26-01-03 13:50:13[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 26-01-03 13:50:13[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01598596572876 -- 26-01-03 13:50:14[周庭龙-2420] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016443014144897 -- 26-01-03 13:51:20[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032238960266113 -- 26-01-03 13:51:21[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016883134841919 -- 26-01-03 13:51:21[周庭龙-2420] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016277074813843 -- 26-01-03 13:54:19[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031630992889404 -- 26-01-03 13:54:20[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046579837799072 -- 26-01-03 13:54:20[周庭龙-2420] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2420,updatedby_id = 2420 where extrafareApply_id = 70270 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016618013381958 -- 26-01-03 13:55:44[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032570362091064 -- 26-01-03 13:55:44[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050489902496338 -- 26-01-03 13:55:45[周庭龙-2420] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2420,updatedby_id = 2420 where extrafareApply_id = 70270 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049710273742676 -- 26-01-03 13:55:45[周庭龙-2420] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2420,updatedby_id = 2420 where otherfee_id = 2417 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015902996063232 -- 26-01-03 13:57:25[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031211376190186 -- 26-01-03 13:57:25[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045640468597412 -- 26-01-03 13:57:25[周庭龙-2420] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2420,updatedby_id = 2420 where extrafareApply_id = 70274 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022184133529663 -- 26-01-03 14:06:43[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22}&event=edit_fareApply&fareApply_id=43238 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 = 43238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033438205718994 -- 26-01-03 14:06:43[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22}&event=edit_fareApply&fareApply_id=43238 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43238 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039238929748535 -- 26-01-03 14:06:43[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22}&event=edit_fareApply&fareApply_id=43238 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 = 5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032660961151123 -- 26-01-03 14:06:43[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22}&event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 26-01-03 14:06:43[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22}&event=edit_fareApply&fareApply_id=43238 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032010078430176 -- 26-01-03 14:06:43[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22}&event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016677141189575 -- 26-01-03 14:09:30[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70271 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036768913269043 -- 26-01-03 14:09:30[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 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 = 70271 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035879611968994 -- 26-01-03 14:09:30[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70271 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 26-01-03 14:09:30[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 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 = 70271 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032241344451904 -- 26-01-03 14:09:30[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032050609588623 -- 26-01-03 14:09:30[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032861232757568 -- 26-01-03 14:09:31[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860356 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031299591064453 -- 26-01-03 14:09:31[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015929937362671 -- 26-01-03 14:09:36[肖超-483] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017630100250244 -- 26-01-03 14:09:37[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025381803512573 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70277 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033588409423828 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 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 = 70277 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032579898834229 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70277 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034101009368896 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 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 = 70277 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031249523162842 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031599998474121 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032901763916016 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860372 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031328201293945 -- 26-01-03 14:09:38[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016891002655029 -- 26-01-03 14:09:40[肖超-483] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015841007232666 -- 26-01-03 14:09:40[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017080068588257 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70276 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037949085235596 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 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 = 70276 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036652088165283 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70276 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037558078765869 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 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 = 70276 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032410621643066 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860370 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031769275665283 -- 26-01-03 14:09:41[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017560958862305 -- 26-01-03 14:09:42[肖超-483] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015666007995605 -- 26-01-03 14:09:43[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017147064208984 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70275 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003432035446167 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 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 = 70275 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037040710449219 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70275 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034480094909668 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 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 = 70275 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031969547271729 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032501220703125 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860368 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031859874725342 -- 26-01-03 14:09:44[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016985893249512 -- 26-01-03 14:09:45[肖超-483] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016459941864014 -- 26-01-03 14:09:46[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0293869972229 -- 26-01-03 14:09:46[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70273 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034799575805664 -- 26-01-03 14:09:46[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 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 = 70273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037131309509277 -- 26-01-03 14:09:46[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70273 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038459300994873 -- 26-01-03 14:09:46[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 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 = 70273 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032238960266113 -- 26-01-03 14:09:46[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032191276550293 -- 26-01-03 14:09:47[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033650398254395 -- 26-01-03 14:09:47[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860360 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 26-01-03 14:09:47[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01665210723877 -- 26-01-03 14:09:48[肖超-483] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017542123794556 -- 26-01-03 14:09:49[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025442838668823 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70272 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 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 = 70272 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037860870361328 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70272 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039150714874268 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 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 = 70272 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031609535217285 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031611919403076 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032961368560791 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860358 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031909942626953 -- 26-01-03 14:09:50[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0191490650177 -- 26-01-03 14:09:52[肖超-483] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023066997528076 -- 26-01-03 14:09:52[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025733947753906 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70272 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030839443206787 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 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 = 70272 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030529499053955 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70272 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030820369720459 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 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 = 70272 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030350685119629 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030841827392578 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031089782714844 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860358 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030388832092285 -- 26-01-03 14:09:53[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70272 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027631998062134 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023241996765137 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70273 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035269260406494 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 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 = 70273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035572052001953 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70273 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035262107849121 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 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 = 70273 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034871101379395 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035231113433838 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035629272460938 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860360 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035221576690674 -- 26-01-03 14:09:54[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70273 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015660047531128 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016719818115234 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70275 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032820701599121 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 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 = 70275 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70275 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032579898834229 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 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 = 70275 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032639503479004 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032799243927002 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860368 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032351016998291 -- 26-01-03 14:09:55[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70275 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017275094985962 -- 26-01-03 14:09:56[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021262884140015 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70276 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003281831741333 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 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 = 70276 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032341480255127 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70276 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032699108123779 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 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 = 70276 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032331943511963 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032699108123779 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032649040222168 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860370 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032570362091064 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70276 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017502069473267 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017180919647217 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70277 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033957958221436 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 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 = 70277 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033679008483887 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70277 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033628940582275 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 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 = 70277 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033400058746338 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033819675445557 -- 26-01-03 14:09:57[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033998489379883 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860372 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033500194549561 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70277 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024479866027832 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017296075820923 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70271 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036449432373047 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 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 = 70271 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70271 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034070014953613 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 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 = 70271 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033650398254395 -- 26-01-03 14:09:58[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034189224243164 -- 26-01-03 14:09:59[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 26-01-03 14:09:59[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860356 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033388137817383 -- 26-01-03 14:09:59[肖超-483] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270271%22}&event=edit_extrafareApply&extrafareApply_id=70271 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 483 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018358945846558 -- 26-01-03 14:38:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 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 = 43238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039010047912598 -- 26-01-03 14:38:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43238 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038418769836426 -- 26-01-03 14:38:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 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 = 5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032761096954346 -- 26-01-03 14:38:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034151077270508 -- 26-01-03 14:38:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032360553741455 -- 26-01-03 14:38:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027107954025269 -- 26-01-03 14:39:11 -- /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.025851964950562 -- 26-01-03 14:39:11[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01661205291748 -- 26-01-03 14:39:12[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 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 = 43293 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-03 14:39:12[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43293 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037820339202881 -- 26-01-03 14:39:12[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 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 = 5853575 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032191276550293 -- 26-01-03 14:39:12[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 26-01-03 14:39:12[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5853575 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032169818878174 -- 26-01-03 14:39:12[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43293 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017765045166016 -- 26-01-03 14:39:50[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066359043121338 -- 26-01-03 14:39:50[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063838958740234 -- 26-01-03 14:39:50[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041899681091309 -- 26-01-03 14:39:50[邓薇-553] -- /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 = 553 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045149326324463 -- 26-01-03 14:39:50[邓薇-553] -- /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= 553 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016156911849976 -- 26-01-03 14:39:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 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 = 43238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035781860351562 -- 26-01-03 14:39:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43238 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042648315429688 -- 26-01-03 14:39:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 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 = 5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031261444091797 -- 26-01-03 14:39:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032031536102295 -- 26-01-03 14:39:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003026008605957 -- 26-01-03 14:39:58[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243238%22%7D&event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016633987426758 -- 26-01-03 14:41:44[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016656875610352 -- 26-01-03 14:41:45[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 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 = 43238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033018589019775 -- 26-01-03 14:41:45[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43238 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037500858306885 -- 26-01-03 14:41:45[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 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 = 5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031819343566895 -- 26-01-03 14:41:45[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 26-01-03 14:41:46[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031859874725342 -- 26-01-03 14:41:46[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016458988189697 -- 26-01-03 14:41:48[邓薇-553] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015844821929932 -- 26-01-03 14:41:48[邓薇-553] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 553 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022440910339355 -- 26-01-03 15:46:37 -- /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.025936126708984 -- 26-01-03 15:46:38[张体海-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018303871154785 -- 26-01-03 15:53:06 -- /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.003587007522583 -- 26-01-03 15:53:06 -- /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.0043199062347412 -- 26-01-03 15:53:06 -- /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='ZhangYong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003899097442627 -- 26-01-03 15:53:06[张勇-2549] -- /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= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016568899154663 -- 26-01-03 15:53:07[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026278972625732 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 69937 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033619403839111 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 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 = 69937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032260417938232 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 69937 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039410591125488 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 69937 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031321048736572 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031368732452393 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020790100097656 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5829965 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031168460845947 -- 26-01-03 15:53:18[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69937 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021316051483154 -- 26-01-03 15:53:21[张勇-2549] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=69937 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026344060897827 -- 26-01-03 15:53:22[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017713069915771 -- 26-01-03 15:53:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 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 = 43233 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038669109344482 -- 26-01-03 15:53:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43233 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039818286895752 -- 26-01-03 15:53:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 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 = 5845738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033109188079834 -- 26-01-03 15:53:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035078525543213 -- 26-01-03 15:53:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003309965133667 -- 26-01-03 15:53:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01725697517395 -- 26-01-03 15:53:43[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016291856765747 -- 26-01-03 15:53:45[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 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 = 43233 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030720233917236 -- 26-01-03 15:53:45[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43233 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031108856201172 -- 26-01-03 15:53:45[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 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 = 5845738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030760765075684 -- 26-01-03 15:53:45[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031111240386963 -- 26-01-03 15:53:45[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030310153961182 -- 26-01-03 15:53:45[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027407884597778 -- 26-01-03 15:53:46[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016069173812866 -- 26-01-03 15:53:46[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017253875732422 -- 26-01-03 15:53:47[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 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 = 43232 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036938190460205 -- 26-01-03 15:53:47[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43232 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037000179290771 -- 26-01-03 15:53:47[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 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 = 5845673 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032010078430176 -- 26-01-03 15:53:47[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034081935882568 -- 26-01-03 15:53:47[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845673 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032029151916504 -- 26-01-03 15:53:47[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026288986206055 -- 26-01-03 15:53:53[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43232 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016629934310913 -- 26-01-03 15:53:53[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026546955108643 -- 26-01-03 15:53:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 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 = 43217 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037240982055664 -- 26-01-03 15:53:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037200450897217 -- 26-01-03 15:53:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 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 = 5844615 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031919479370117 -- 26-01-03 15:53:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033588409423828 -- 26-01-03 15:53:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844615 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032188892364502 -- 26-01-03 15:53:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015965938568115 -- 26-01-03 15:53:59[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020104885101318 -- 26-01-03 15:53:59[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017776966094971 -- 26-01-03 15:54:02[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 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 = 43214 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039970874786377 -- 26-01-03 15:54:02[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43214 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003964900970459 -- 26-01-03 15:54:02[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 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 = 5841303 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003399133682251 -- 26-01-03 15:54:02[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035889148712158 -- 26-01-03 15:54:02[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5841303 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034117698669434 -- 26-01-03 15:54:02[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016674995422363 -- 26-01-03 15:54:37[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01665210723877 -- 26-01-03 15:54:38[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 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 = 43214 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003216028213501 -- 26-01-03 15:54:38[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43214 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032639503479004 -- 26-01-03 15:54:38[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 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 = 5841303 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032811164855957 -- 26-01-03 15:54:38[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032680034637451 -- 26-01-03 15:54:39[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5841303 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032119750976562 -- 26-01-03 15:54:39[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020105123519897 -- 26-01-03 15:54:40[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017442941665649 -- 26-01-03 15:54:40[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017236232757568 -- 26-01-03 15:54:41[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 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 = 43205 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034360885620117 -- 26-01-03 15:54:41[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43205 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034470558166504 -- 26-01-03 15:54:41[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 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 = 5840217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032939910888672 -- 26-01-03 15:54:41[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-03 15:54:41[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5840217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003277063369751 -- 26-01-03 15:54:41[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02295994758606 -- 26-01-03 15:54:51[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015884160995483 -- 26-01-03 15:54:52[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 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 = 43205 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030820369720459 -- 26-01-03 15:54:52[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43205 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030758380889893 -- 26-01-03 15:54:52[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 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 = 5840217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030620098114014 -- 26-01-03 15:54:52[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 26-01-03 15:54:52[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5840217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030789375305176 -- 26-01-03 15:54:52[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01609992980957 -- 26-01-03 15:54:53[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017807960510254 -- 26-01-03 15:54:53[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017076969146729 -- 26-01-03 15:54:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 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 = 43141 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003849983215332 -- 26-01-03 15:54:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43141 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037949085235596 -- 26-01-03 15:54:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 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 = 5834501 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033011436462402 -- 26-01-03 15:54:54[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 26-01-03 15:54:55[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5834501 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032942295074463 -- 26-01-03 15:54:55[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020795106887817 -- 26-01-03 15:54:57[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43141 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016062021255493 -- 26-01-03 15:54:57[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017667055130005 -- 26-01-03 15:54:59[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7242 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034849643707275 -- 26-01-03 15:54:59[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select org_id,org_name from dbsys.sys_org where corp_acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032589435577393 -- 26-01-03 15:54:59[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034098625183105 -- 26-01-03 15:54:59[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860195 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003262996673584 -- 26-01-03 15:54:59[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019554138183594 -- 26-01-03 15:55:07[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016721963882446 -- 26-01-03 15:55:07[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017577886581421 -- 26-01-03 15:55:08[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7242 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035779476165771 -- 26-01-03 15:55:08[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select org_id,org_name from dbsys.sys_org where corp_acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033628940582275 -- 26-01-03 15:55:08[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035369396209717 -- 26-01-03 15:55:08[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860195 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033760070800781 -- 26-01-03 15:55:08[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7242 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026968002319336 -- 26-01-03 15:55:09[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017623901367188 -- 26-01-03 15:55:10[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 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 = 43141 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003511905670166 -- 26-01-03 15:55:10[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43141 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035269260406494 -- 26-01-03 15:55:10[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 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 = 5834501 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033750534057617 -- 26-01-03 15:55:10[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035538673400879 -- 26-01-03 15:55:10[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5834501 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033779144287109 -- 26-01-03 15:55:10[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43141 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016897916793823 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017528057098389 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 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 = 43205 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034868717193604 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43205 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035049915313721 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 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 = 5840217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033679008483887 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035359859466553 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5840217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033559799194336 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43205 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016870021820068 -- 26-01-03 15:55:11[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028883934020996 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 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 = 43214 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038130283355713 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43214 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037598609924316 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 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 = 5841303 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032479763031006 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5841303 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032389163970947 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43214 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016672849655151 -- 26-01-03 15:55:12[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01714015007019 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 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 = 43217 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038909912109375 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43217 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038111209869385 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 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 = 5844615 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034699440002441 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844615 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43217 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025068998336792 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016630887985229 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 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 = 43232 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037260055541992 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43232 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037128925323486 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 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 = 5845673 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032320022583008 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033869743347168 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845673 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032031536102295 -- 26-01-03 15:55:13[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43232 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026977062225342 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027998924255371 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 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 = 43233 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035321712493896 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43233 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035438537597656 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 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 = 5845738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033841133117676 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003532886505127 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033857822418213 -- 26-01-03 15:55:14[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43233 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025753021240234 -- 26-01-03 16:10:05[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243312%22%7D&event=edit_fareApply&fareApply_id=43312 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 = 43312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035920143127441 -- 26-01-03 16:10:05[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243312%22%7D&event=edit_fareApply&fareApply_id=43312 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43312 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036840438842773 -- 26-01-03 16:10:05[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243312%22%7D&event=edit_fareApply&fareApply_id=43312 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 = 5860477 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031750202178955 -- 26-01-03 16:10:05[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243312%22%7D&event=edit_fareApply&fareApply_id=43312 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032401084899902 -- 26-01-03 16:10:05[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243312%22%7D&event=edit_fareApply&fareApply_id=43312 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5860477 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030539035797119 -- 26-01-03 16:10:06[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243312%22%7D&event=edit_fareApply&fareApply_id=43312 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016976118087769 -- 26-01-03 16:10:11[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43312 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015671968460083 -- 26-01-03 16:10:12[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024655103683472 -- 26-01-03 16:24:11 -- /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.0031559467315674 -- 26-01-03 16:24:11 -- /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.0038521289825439 -- 26-01-03 16:24:11 -- /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='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034620761871338 -- 26-01-03 16:24:11[高祥-33] -- /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= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01746678352356 -- 26-01-03 16:24:12[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018188953399658 -- 26-01-03 16:36:26[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1705797,1705783,1704365&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%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 = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035948753356934 -- 26-01-03 16:36:26[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1705797,1705783,1704365&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%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.0034821033477783 -- 26-01-03 16:36:26[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1705797,1705783,1704365&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037319660186768 -- 26-01-03 16:36:26[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1705797,1705783,1704365&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%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 (1705797,1705783,1704365) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023097991943359 -- 26-01-03 16:36:26[彭铸-825] -- /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.01664400100708 -- 26-01-03 16:36:27[彭铸-825] -- /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.017091035842896 -- 26-01-03 16:36:27[彭铸-825] -- /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.020503044128418 -- 26-01-03 16:36:36[彭铸-825] -- /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.01593279838562 -- 26-01-03 16:36:47[彭铸-825] -- /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.017753124237061 -- 26-01-03 16:38:10[彭铸-825] -- /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.01649284362793 -- 26-01-03 16:38:44[彭铸-825] -- /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.0032739639282227 -- 26-01-03 16:38:44[彭铸-825] -- /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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033779144287109 -- 26-01-03 16:38:44[彭铸-825] -- /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 (1705797,1705783,1704365) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033409595489502 -- 26-01-03 16:38:44[彭铸-825] -- /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 = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051839351654053 -- 26-01-03 16:38:44[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 70286 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047721862792969 -- 26-01-03 16:38:44[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016350030899048 -- 26-01-03 16:38:46[彭铸-825] -- /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.0031919479370117 -- 26-01-03 16:38:46[彭铸-825] -- /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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032048225402832 -- 26-01-03 16:38:46[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016999006271362 -- 26-01-03 16:38:47[彭铸-825] -- /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.0032811164855957 -- 26-01-03 16:38:47[彭铸-825] -- /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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033340454101562 -- 26-01-03 16:38:47[彭铸-825] -- /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 = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004647970199585 -- 26-01-03 16:38:47[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 70286 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045919418334961 -- 26-01-03 16:38:47[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023939847946167 -- 26-01-03 16:38:48[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025251150131226 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70286 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033481121063232 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 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 = 70286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036299228668213 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70286 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037589073181152 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 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 = 70286 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032150745391846 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031650066375732 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033068656921387 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5861157 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031518936157227 -- 26-01-03 16:40:54[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270286%22%7D&event=edit_extrafareApply&extrafareApply_id=70286 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021893978118896 -- 26-01-03 16:46:31[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00313401222229 -- 26-01-03 16:46:31[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045480728149414 -- 26-01-03 16:46:31[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2507,updatedby_id = 2507 where extrafareApply_id = 70287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018082141876221 -- 26-01-03 16:49:08[刘强-2507] -- /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 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017218112945557 -- 26-01-03 16:49:13[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003389835357666 -- 26-01-03 16:49:13[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028308153152466 -- 26-01-03 16:49:44[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031430721282959 -- 26-01-03 16:49:44[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016692876815796 -- 26-01-03 16:49:44[刘强-2507] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015837907791138 -- 26-01-03 16:49:52[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031018257141113 -- 26-01-03 16:49:52[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046417713165283 -- 26-01-03 16:49:52[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2507,updatedby_id = 2507 where extrafareApply_id = 70288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017551898956299 -- 26-01-03 16:50:14[刘强-2507] -- /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.017603874206543 -- 26-01-03 16:50:22[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034301280975342 -- 26-01-03 16:50:22[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02887487411499 -- 26-01-03 16:51:17[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032150745391846 -- 26-01-03 16:51:18[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046029090881348 -- 26-01-03 16:51:18[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2507,updatedby_id = 2507 where extrafareApply_id = 70288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051329135894775 -- 26-01-03 16:51:18[刘强-2507] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2507,updatedby_id = 2507 where otherfee_id = 2448 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016823053359985 -- 26-01-03 16:51:18[刘强-2507] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017295837402344 -- 26-01-03 17:57:58 -- /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.016525030136108 -- 26-01-03 17:57:59 -- /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.0038931369781494 -- 26-01-03 17:57:59 -- /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.0039150714874268 -- 26-01-03 17:57:59 -- /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='ShenLiYun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035171508789062 -- 26-01-03 17:57:59[沈丽云-2156] -- /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= 43 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017054080963135 -- 26-01-03 17:58:00[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017388820648193 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70296 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036001205444336 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 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 = 70296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035128593444824 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70296 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036451816558838 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 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 = 70296 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00331711769104 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033841133117676 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035538673400879 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5861479 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033409595489502 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033409595489502 -- 26-01-03 17:58:01[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027387142181396 -- 26-01-03 17:58:04[沈丽云-2156] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025608777999878 -- 26-01-03 17:58:05[沈丽云-2156] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2156 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016225099563599 -- 26-01-03 18:42: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.003148078918457 -- 26-01-03 18:42: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.0040268898010254 -- 26-01-03 18:42: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='LiuXiaoJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032830238342285 -- 26-01-03 18:42:28[刘晓进-2544] -- /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= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017529964447021 -- 26-01-03 18:42:28[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017565965652466 -- 26-01-03 18:42:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70267 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035851001739502 -- 26-01-03 18:42:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 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 = 70267 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 26-01-03 18:42:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70267 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036640167236328 -- 26-01-03 18:42:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70267 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033540725708008 -- 26-01-03 18:42:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00337815284729 -- 26-01-03 18:42:31[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035400390625 -- 26-01-03 18:42:31[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5859852 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00335693359375 -- 26-01-03 18:42:31[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016508102416992 -- 26-01-03 18:43:21[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015555858612061 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70267 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032908916473389 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 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 = 70267 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030181407928467 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70267 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030460357666016 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70267 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030169486999512 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030481815338135 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031030178070068 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5859852 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030109882354736 -- 26-01-03 18:43:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026428937911987 -- 26-01-03 18:43:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01701021194458 -- 26-01-03 18:43:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017045021057129 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70267 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033659934997559 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 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 = 70267 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033791065216064 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70267 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033800601959229 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70267 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033469200134277 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033328533172607 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033810138702393 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5859852 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003338098526001 -- 26-01-03 18:43:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70267 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020138025283813 -- 26-01-03 18:43:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028093099594116 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70266 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032749176025391 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 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 = 70266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031368732452393 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70266 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037789344787598 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70266 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003054141998291 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030789375305176 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003248929977417 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5859835 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003054141998291 -- 26-01-03 18:43:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018530130386353 -- 26-01-03 18:43:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02026891708374 -- 26-01-03 18:43:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01570987701416 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70266 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030601024627686 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 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 = 70266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030150413513184 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70266 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030529499053955 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70266 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030159950256348 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030720233917236 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030598640441895 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5859835 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030398368835449 -- 26-01-03 18:43:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70266 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016078948974609 -- 26-01-03 18:43:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023200035095215 -- 26-01-03 23:50:19[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017145872116089 -- 26-01-03 23:50:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 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 = 43238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038080215454102 -- 26-01-03 23:50:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43238 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038139820098877 -- 26-01-03 23:50:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 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 = 5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031788349151611 -- 26-01-03 23:50:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033679008483887 -- 26-01-03 23:50:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5848049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031719207763672 -- 26-01-03 23:50:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015229940414429 -- 26-01-03 23:50:36[肖飞飞-477] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025704860687256 -- 26-01-03 23:50:37[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016448974609375 -- 26-01-03 23:53:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1696961&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032510757446289 -- 26-01-03 23:53:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1696961&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%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.0031349658966064 -- 26-01-03 23:53:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1696961&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00331711769104 -- 26-01-03 23:53:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1696961&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%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 (1696961) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.059414863586426 -- 26-01-03 23:53:54[吴文超-755] -- /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 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026896953582764 -- 26-01-03 23:53:54[吴文超-755] -- /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.016584873199463 -- 26-01-03 23:53:54[吴文超-755] -- /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.016255855560303 -- 26-01-03 23:57:35[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1677615&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032918453216553 -- 26-01-03 23:57:35[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1677615&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%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.0032570362091064 -- 26-01-03 23:57:35[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1677615&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033681392669678 -- 26-01-03 23:57:35[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1677615&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%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 (1677615) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020040035247803 -- 26-01-03 23:57:36[吴文超-755] -- /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 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017669916152954 -- 26-01-03 23:57:36[吴文超-755] -- /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.016050815582275 -- 26-01-03 23:57:36[吴文超-755] -- /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.01980185508728 -- 26-01-03 23:57:41[吴文超-755] -- /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.016475915908813 -- 26-01-03 23:57:50[吴文超-755] -- /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.017117977142334 -- 26-01-03 23:58:18[吴文超-755] -- /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.016374826431274 -- 26-01-03 23:59:14[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033419132232666 -- 26-01-03 23:59:14[吴文超-755] -- /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 (1677615) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032029151916504 -- 26-01-03 23:59:14[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017055034637451 -- 26-01-03 23:59:16[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031299591064453 -- 26-01-03 23:59:16[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016196966171265 -- 26-01-03 23:59:21[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031659603118896 -- 26-01-03 23:59:21[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027422904968262 -- 26-01-03 23:59:22[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032351016998291 -- 26-01-03 23:59:22[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016609907150269 -- 26-01-03 23:59:22[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016740083694458 -- 26-01-03 23:59:24[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 26-01-03 23:59:24[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01642894744873 -- 26-01-03 23:59:25[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032680034637451 -- 26-01-03 23:59:25[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016483783721924 -- 26-01-03 23:59:25[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016560077667236 -- 26-01-03 23:59:26[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032510757446289 -- 26-01-03 23:59:26[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016855001449585 -- 26-01-03 23:59:27[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033130645751953 -- 26-01-03 23:59:27[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01599907875061 -- 26-01-03 23:59:27[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019314050674438 -- 26-01-03 23:59:28[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031099319458008 -- 26-01-03 23:59:28[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016371011734009 -- 26-01-03 23:59:29[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003209114074707 -- 26-01-03 23:59:29[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017371892929077 -- 26-01-03 23:59:30[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016751050949097 -- 26-01-03 23:59:34[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032699108123779 -- 26-01-03 23:59:35[吴文超-755] -- /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 = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016620874404907 -- 26-01-03 23:59:35[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------