Time: 0.01993203163147 -- 25-11-16 15:16:21[梁汉东-1251] -- /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%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67877 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 = 67877 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 25-11-16 15:16:21[梁汉东-1251] -- /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%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 25-11-16 15:16:21[梁汉东-1251] -- /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%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035550594329834 -- 25-11-16 15:16:21[梁汉东-1251] -- /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%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67877 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 = 5574430 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033729076385498 -- 25-11-16 15:16:21[梁汉东-1251] -- /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%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00335693359375 -- 25-11-16 15:16:21[梁汉东-1251] -- /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%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020250082015991 -- 25-11-16 15:16:22[梁汉东-1251] -- /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.016042947769165 -- 25-11-16 15:16:22[梁汉东-1251] -- /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.02184796333313 -- 25-11-16 15:16:22[梁汉东-1251] -- /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.017634868621826 -- 25-11-16 15:16:57[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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 = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035331249237061 -- 25-11-16 15:16:57[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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.0033910274505615 -- 25-11-16 15:16:57[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035748481750488 -- 25-11-16 15:16:57[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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 (1635701) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050950050354004 -- 25-11-16 15:16:57[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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.026778936386108 -- 25-11-16 15:16:58[梁汉东-1251] -- /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.019025802612305 -- 25-11-16 15:16:58[梁汉东-1251] -- /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.017398834228516 -- 25-11-16 15:16:58[梁汉东-1251] -- /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.020627975463867 -- 25-11-16 15:17:04[梁汉东-1251] -- /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.017770051956177 -- 25-11-16 15:17:21[梁汉东-1251] -- /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.020960092544556 -- 25-11-16 15:19:53[梁汉东-1251] -- /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.016392946243286 -- 25-11-16 15:20:24[梁汉东-1251] -- /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.0032389163970947 -- 25-11-16 15:20:24[梁汉东-1251] -- /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.0032889842987061 -- 25-11-16 15:20:25[梁汉东-1251] -- /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 (1635701) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032970905303955 -- 25-11-16 15:20:25[梁汉东-1251] -- /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 = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046160221099854 -- 25-11-16 15:20:25[梁汉东-1251] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1251,updatedby_id = 1251 where extrafareApply_id = 67914 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044980049133301 -- 25-11-16 15:20:25[梁汉东-1251] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1251,updatedby_id = 1251 where otherfee_id = 69504 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029198884963989 -- 25-11-16 15:20:45[梁汉东-1251] -- /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.003425121307373 -- 25-11-16 15:20:45[梁汉东-1251] -- /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.0034260749816895 -- 25-11-16 15:20:45[梁汉东-1251] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029007911682129 -- 25-11-16 15:20:50[梁汉东-1251] -- /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.0033650398254395 -- 25-11-16 15:20:50[梁汉东-1251] -- /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.0034410953521729 -- 25-11-16 15:20:50[梁汉东-1251] -- /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 = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050570964813232 -- 25-11-16 15:20:50[梁汉东-1251] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1251,updatedby_id = 1251 where extrafareApply_id = 67914 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050339698791504 -- 25-11-16 15:20:50[梁汉东-1251] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1251,updatedby_id = 1251 where otherfee_id = 69504 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016617059707642 -- 25-11-16 15:20:50[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01833701133728 -- 25-11-16 15:22:08[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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 = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 25-11-16 15:22:08[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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.0036580562591553 -- 25-11-16 15:22:08[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037450790405273 -- 25-11-16 15:22:08[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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 (1635701) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040409564971924 -- 25-11-16 15:22:08[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1635701&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%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.0349440574646 -- 25-11-16 15:22:08[梁汉东-1251] -- /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.016450881958008 -- 25-11-16 15:22:08[梁汉东-1251] -- /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.022725105285645 -- 25-11-16 15:22:08[梁汉东-1251] -- /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.017477035522461 -- 25-11-16 18:24:48[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016574144363403 -- 25-11-16 18:24:48[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018877029418945 -- 25-11-16 18:25:10[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023994922637939 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 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 = 67914 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046460628509521 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67914 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004213809967041 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 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 = 67914 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036039352416992 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003748893737793 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 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 = 5580487 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035419464111328 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035538673400879 -- 25-11-16 23:46:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018625020980835 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 67893 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039849281311035 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040450096130371 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 67893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003493070602417 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035140514373779 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036377906799316 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 5576013 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003483772277832 -- 25-11-16 23:47:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025593996047974 -- 25-11-16 23:47:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017147064208984 -- 25-11-16 23:47:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016978979110718 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 67893 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033128261566162 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033168792724609 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 67893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033152103424072 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033500194549561 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033419132232666 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 5576013 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032927989959717 -- 25-11-16 23:47:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016828060150146 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 67782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042769908905029 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67782 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034451484680176 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 67782 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032291412353516 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032610893249512 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033879280090332 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 5569895 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032260417938232 -- 25-11-16 23:47:24[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018193006515503 -- 25-11-16 23:47:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016411066055298 -- 25-11-16 23:47:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029973030090332 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 67782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035090446472168 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67782 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035219192504883 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 67782 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034990310668945 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035300254821777 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035791397094727 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 5569895 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035018920898438 -- 25-11-16 23:47:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018109083175659 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 67779 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035998821258545 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037450790405273 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 67779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034871101379395 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035409927368164 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036568641662598 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 5569872 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003486156463623 -- 25-11-16 23:47:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016804933547974 -- 25-11-16 23:47:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01619815826416 -- 25-11-16 23:47:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017100095748901 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 67779 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033009052276611 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 67779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033271312713623 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032939910888672 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033559799194336 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 5569872 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003309965133667 -- 25-11-16 23:47:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016963958740234 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 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 = 67914 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033090114593506 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67914 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033118724822998 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 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 = 67914 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033020973205566 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033068656921387 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033578872680664 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 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 = 5580487 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032789707183838 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032858848571777 -- 25-11-16 23:48:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267914%22}&event=edit_extrafareApply&extrafareApply_id=67914 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016339063644409 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 67893 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031599998474121 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 67893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031640529632568 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032010078430176 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 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 = 5576013 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031528472900391 -- 25-11-16 23:48:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267893%22}&event=edit_extrafareApply&extrafareApply_id=67893 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017983913421631 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 67782 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034918785095215 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67782 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003525972366333 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 67782 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034909248352051 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035228729248047 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035440921783447 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 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 = 5569895 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034668445587158 -- 25-11-16 23:48:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267782%22}&event=edit_extrafareApply&extrafareApply_id=67782 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019087076187134 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 67779 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037341117858887 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037460327148438 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 67779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037190914154053 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037178993225098 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037801265716553 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 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 = 5569872 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037219524383545 -- 25-11-16 23:48:17[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267779%22}&event=edit_extrafareApply&extrafareApply_id=67779 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019171953201294 -- 25-11-16 23:48:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267699%22}&event=edit_extrafareApply&extrafareApply_id=67699 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 = 67699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033829212188721 -- 25-11-16 23:48:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267699%22}&event=edit_extrafareApply&extrafareApply_id=67699 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003413200378418 -- 25-11-16 23:48:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267699%22}&event=edit_extrafareApply&extrafareApply_id=67699 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035669803619385 -- 25-11-16 23:48:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267699%22}&event=edit_extrafareApply&extrafareApply_id=67699 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 = 5558923 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034110546112061 -- 25-11-16 23:48:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267699%22}&event=edit_extrafareApply&extrafareApply_id=67699 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023730039596558 -- 25-11-16 23:48:29[张昭霞-2107] -- /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.017136812210083 -- 25-11-16 23:48:29[张昭霞-2107] -- /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.017669200897217 -- 25-11-16 23:48:29[张昭霞-2107] -- /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.017774820327759 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 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 = 67633 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045840740203857 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67633 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036308765411377 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 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 = 67633 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034229755401611 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034291744232178 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035881996154785 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 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 = 5551796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033969879150391 -- 25-11-16 23:48:37[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267633%22}&event=edit_extrafareApply&extrafareApply_id=67633 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01714301109314 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 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 = 67575 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037021636962891 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67575 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037970542907715 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 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 = 67575 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031669139862061 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003183126449585 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033831596374512 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 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 = 5542106 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031678676605225 -- 25-11-16 23:48:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267575%22}&event=edit_extrafareApply&extrafareApply_id=67575 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------