Time: 0.020075798034668 -- 25-05-25 00:23:50[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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 = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040140151977539 -- 25-05-25 00:23:50[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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.0039589405059814 -- 25-05-25 00:23:50[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040900707244873 -- 25-05-25 00:23:50[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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 (1405076,1405075,1403809,1403802) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005267858505249 -- 25-05-25 00:23:50[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026424169540405 -- 25-05-25 00:23:50[谢凯-826] -- /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.016855955123901 -- 25-05-25 00:23:50[谢凯-826] -- /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.030813217163086 -- 25-05-25 00:23:50[谢凯-826] -- /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.032414197921753 -- 25-05-25 00:23:58[谢凯-826] -- /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.01784610748291 -- 25-05-25 00:24:03[谢凯-826] -- /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.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019622087478638 -- 25-05-25 00:24:22[谢凯-826] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017171859741211 -- 25-05-25 00:24:43[谢凯-826] -- /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.0034148693084717 -- 25-05-25 00:24:43[谢凯-826] -- /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.0035040378570557 -- 25-05-25 00:24:43[谢凯-826] -- /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 (1405076,1405075,1403809,1403802) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00335693359375 -- 25-05-25 00:24:43[谢凯-826] -- /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 = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004863977432251 -- 25-05-25 00:24:43[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 826,updatedby_id = 826 where extrafareApply_id = 61717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046749114990234 -- 25-05-25 00:24:43[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 826,updatedby_id = 826 where otherfee_id = 63772 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018586874008179 -- 25-05-25 00:24:47[谢凯-826] -- /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.0032029151916504 -- 25-05-25 00:24:47[谢凯-826] -- /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.0032579898834229 -- 25-05-25 00:24:47[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031335115432739 -- 25-05-25 00:24:58[谢凯-826] -- /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.0031850337982178 -- 25-05-25 00:24:58[谢凯-826] -- /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.0032298564910889 -- 25-05-25 00:24:58[谢凯-826] -- /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 = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043010711669922 -- 25-05-25 00:24:58[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 826,updatedby_id = 826 where extrafareApply_id = 61717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040881633758545 -- 25-05-25 00:24:58[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 826,updatedby_id = 826 where otherfee_id = 63772 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019371032714844 -- 25-05-25 00:24:59[谢凯-826] -- /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.0037670135498047 -- 25-05-25 00:24:59[谢凯-826] -- /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.0037908554077148 -- 25-05-25 00:24:59[谢凯-826] -- /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 = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049707889556885 -- 25-05-25 00:24:59[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 826,updatedby_id = 826 where extrafareApply_id = 61717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050699710845947 -- 25-05-25 00:24:59[谢凯-826] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 826,updatedby_id = 826 where otherfee_id = 63772 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016433000564575 -- 25-05-25 00:24:59[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017684936523438 -- 25-05-25 00:25:05[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=61717 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 61717 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031049251556396 -- 25-05-25 00:25:05[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031678676605225 -- 25-05-25 00:25:05[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032858848571777 -- 25-05-25 00:25:05[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=61717 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4685451 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031330585479736 -- 25-05-25 00:25:05[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031061172485352 -- 25-05-25 00:25:05[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033311128616333 -- 25-05-25 00:25:06[谢凯-826] -- /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.015944004058838 -- 25-05-25 00:25:06[谢凯-826] -- /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.015873908996582 -- 25-05-25 00:25:06[谢凯-826] -- /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.017586946487427 -- 25-05-25 00:25:13[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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 = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034720897674561 -- 25-05-25 00:25:13[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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.0034549236297607 -- 25-05-25 00:25:13[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 826 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035121440887451 -- 25-05-25 00:25:13[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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 (1405076,1405075,1403809,1403802) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038831233978271 -- 25-05-25 00:25:13[谢凯-826] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1405076,1405075,1403809,1403802&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021615982055664 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 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 = 61717 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041499137878418 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043399333953857 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 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 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 = 61717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036630630493164 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036158561706543 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037879943847656 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4685451 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035629272460938 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035970211029053 -- 25-05-25 00:27:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261717%22}&event=edit_extrafareApply&extrafareApply_id=61717 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027141094207764 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 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 = 61714 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034990310668945 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61714 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 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 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 = 61714 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002924919128418 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030069351196289 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031218528747559 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4685357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029411315917969 -- 25-05-25 00:27:22[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02042293548584 -- 25-05-25 13:44:56 -- /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.0039811134338379 -- 25-05-25 13:44:56 -- /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.0048229694366455 -- 25-05-25 13:44:56 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='KouBinNan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042078495025635 -- 25-05-25 13:44:56[寇彬楠-1097] -- /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.02975606918335 -- 25-05-25 13:44:57[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02393102645874 -- 25-05-25 13:45:00[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36135 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 = 36135 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037999153137207 -- 25-05-25 13:45:00[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36135 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36135 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00518798828125 -- 25-05-25 13:45:00[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36135 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 = 4686336 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037541389465332 -- 25-05-25 13:45:00[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36135 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038890838623047 -- 25-05-25 13:45:00[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36135 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4686336 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037031173706055 -- 25-05-25 13:45:00[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36135 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016376972198486 -- 25-05-25 13:45:03[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36135 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018930912017822 -- 25-05-25 13:45:04[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021625995635986 -- 25-05-25 20:42:25 -- /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.0043330192565918 -- 25-05-25 20:42:25 -- /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.0048298835754395 -- 25-05-25 20:42:25 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045809745788574 -- 25-05-25 20:42:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016572952270508 -- 25-05-25 20:42:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023615121841431 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 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 = 95731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042719841003418 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select payment_id from dbthird.thd_payment where oa_payment_id = 95731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041768550872803 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 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 = 114256 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042188167572021 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 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 = 4682074 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036098957061768 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038259029388428 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select * from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003770112991333 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4682074 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036261081695557 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035891532897949 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036439895629883 -- 25-05-25 20:42:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017361879348755 -- 25-05-25 20:42:29[吴凌刚-279] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=95731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02615213394165 -- 25-05-25 20:42:29[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019174098968506 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 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 = 95730 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040421485900879 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select payment_id from dbthird.thd_payment where oa_payment_id = 95730 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040860176086426 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 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 = 114255 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004133939743042 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 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 = 4682071 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003572940826416 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036270618438721 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select * from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037338733673096 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4682071 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035810470581055 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035750865936279 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036239624023438 -- 25-05-25 20:42:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019636869430542 -- 25-05-25 20:42:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=95730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02312707901001 -- 25-05-25 20:42:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018749952316284 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037250518798828 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003734827041626 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037851333618164 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1406636) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042440891265869 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025035858154297 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /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.020764827728271 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /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.016079902648926 -- 25-05-25 20:57:06[秦学习-南京办-1240] -- /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.019579887390137 -- 25-05-25 20:57:17[秦学习-南京办-1240] -- /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.016983985900879 -- 25-05-25 20:57:27[秦学习-南京办-1240] -- /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.016801118850708 -- 25-05-25 20:57:50[秦学习-南京办-1240] -- /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.00335693359375 -- 25-05-25 20:57:50[秦学习-南京办-1240] -- /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.00347900390625 -- 25-05-25 20:57:50[秦学习-南京办-1240] -- /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 (1406636) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033910274505615 -- 25-05-25 20:57:50[秦学习-南京办-1240] -- /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 = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045318603515625 -- 25-05-25 20:57:50[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004849910736084 -- 25-05-25 20:57:50[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 63773 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019956111907959 -- 25-05-25 20:58:41[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 and extrafare_name like '%中建材%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014662027359009 -- 25-05-25 21:00:05[秦学习-南京办-1240] -- /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.0029089450836182 -- 25-05-25 21:00:05[秦学习-南京办-1240] -- /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.0071430206298828 -- 25-05-25 21:00:05[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0191650390625 -- 25-05-25 21:00:07[秦学习-南京办-1240] -- /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.0037441253662109 -- 25-05-25 21:00:07[秦学习-南京办-1240] -- /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.0038199424743652 -- 25-05-25 21:00:07[秦学习-南京办-1240] -- /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 = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005012035369873 -- 25-05-25 21:00:07[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047860145568848 -- 25-05-25 21:00:07[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 63773 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.25847697257996 -- 25-05-25 21:00:35[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_order_item SELECT o.order_id,o.order_no,o.owner_id FROM dbthird.thd_order o left join dbthird.thd_order_extend o_e on o_e.order_id = o.order_id WHERE o.acct_id = 9 AND o.order_no like '%5210048%' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029325008392334 -- 25-05-25 21:00:40[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033650398254395 -- 25-05-25 21:00:40[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034000873565674 -- 25-05-25 21:00:40[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021454095840454 -- 25-05-25 21:00:42[秦学习-南京办-1240] -- /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.0035839080810547 -- 25-05-25 21:00:42[秦学习-南京办-1240] -- /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.0036611557006836 -- 25-05-25 21:00:42[秦学习-南京办-1240] -- /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 = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047829151153564 -- 25-05-25 21:00:42[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046191215515137 -- 25-05-25 21:00:42[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 63773 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021618127822876 -- 25-05-25 21:00:52[秦学习-南京办-1240] -- /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.0031981468200684 -- 25-05-25 21:00:52[秦学习-南京办-1240] -- /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.0032310485839844 -- 25-05-25 21:00:52[秦学习-南京办-1240] -- /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 = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052249431610107 -- 25-05-25 21:00:52[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045740604400635 -- 25-05-25 21:00:52[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 63773 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016708135604858 -- 25-05-25 21:00:55[秦学习-南京办-1240] -- /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.0032429695129395 -- 25-05-25 21:00:55[秦学习-南京办-1240] -- /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.0032980442047119 -- 25-05-25 21:00:55[秦学习-南京办-1240] -- /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 = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050091743469238 -- 25-05-25 21:00:55[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046617984771729 -- 25-05-25 21:00:55[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 63773 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016427040100098 -- 25-05-25 21:00:55[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025530099868774 -- 25-05-25 21:01:00[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031859874725342 -- 25-05-25 21:01:00[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030651092529297 -- 25-05-25 21:01:00[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032389163970947 -- 25-05-25 21:01:00[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1406636) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034439563751221 -- 25-05-25 21:01:00[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1406636&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030581951141357 -- 25-05-25 21:01:00[秦学习-南京办-1240] -- /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.017315864562988 -- 25-05-25 21:01:01[秦学习-南京办-1240] -- /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.028291940689087 -- 25-05-25 21:01:01[秦学习-南京办-1240] -- /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.017337083816528 -- 25-05-25 21:35:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 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 = 61718 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039839744567871 -- 25-05-25 21:35:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039610862731934 -- 25-05-25 21:35:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 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 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 = 61718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034661293029785 -- 25-05-25 21:35:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033888816833496 -- 25-05-25 21:35:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035419464111328 -- 25-05-25 21:35:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4686733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 25-05-25 21:35:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 25-05-25 21:35:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261718%22}&event=edit_extrafareApply&extrafareApply_id=61718 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020705938339233 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 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 = 61714 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046751499176025 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61714 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046629905700684 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 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 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 = 61714 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040240287780762 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040531158447266 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042209625244141 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4685357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040218830108643 -- 25-05-25 21:35:51[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018074989318848 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 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 = 61714 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003903865814209 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61714 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039811134338379 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 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 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 = 61714 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034940242767334 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034430027008057 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036220550537109 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4685357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033891201019287 -- 25-05-25 21:37:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261714%22}&event=edit_extrafareApply&extrafareApply_id=61714 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------