Time: 0.020390033721924 -- 25-06-01 16:37:05 -- /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.0041470527648926 -- 25-06-01 16:37:05 -- /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.0046188831329346 -- 25-06-01 16:37:05 -- /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='AMeng' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043909549713135 -- 25-06-01 16:37:05[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014976024627686 -- 25-06-01 16:37:07[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016757011413574 -- 25-06-01 16:37:08[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5746 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 5746 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031070709228516 -- 25-06-01 16:37:08[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5746 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029819011688232 -- 25-06-01 16:37:08[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5746 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031769275665283 -- 25-06-01 16:37:08[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5746 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 = 4721433 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030150413513184 -- 25-06-01 16:37:08[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5746 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02116584777832 -- 25-06-01 16:37:14[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029253005981445 -- 25-06-01 16:37:15[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017307996749878 -- 25-06-01 16:40:19[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225746%22}&event=edit_officialSeals&officialSeals_id=5746 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 5746 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032179355621338 -- 25-06-01 16:40:19[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225746%22}&event=edit_officialSeals&officialSeals_id=5746 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031840801239014 -- 25-06-01 16:40:19[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225746%22}&event=edit_officialSeals&officialSeals_id=5746 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033559799194336 -- 25-06-01 16:40:19[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225746%22}&event=edit_officialSeals&officialSeals_id=5746 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 = 4721433 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031280517578125 -- 25-06-01 16:40:19[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225746%22}&event=edit_officialSeals&officialSeals_id=5746 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015881061553955 -- 25-06-01 16:40:24[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017182111740112 -- 25-06-01 16:40:25[石远龙-484] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 484 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018779993057251 -- 25-06-01 17:12:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037338733673096 -- 25-06-01 17:12:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036189556121826 -- 25-06-01 17:12:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038440227508545 -- 25-06-01 17:12:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1396805) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031529903411865 -- 25-06-01 17:12:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select 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.021362066268921 -- 25-06-01 17:12:54[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016103982925415 -- 25-06-01 17:12:54[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019387006759644 -- 25-06-01 17:12:54[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020941019058228 -- 25-06-01 17:12:59[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =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.030847072601318 -- 25-06-01 17:13:08[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019680023193359 -- 25-06-01 17:13:20[吴文超-755] -- /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.021760940551758 -- 25-06-01 17:15:31[吴文超-755] -- /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.0043098926544189 -- 25-06-01 17:15:31[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043790340423584 -- 25-06-01 17:15:31[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1396805) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043408870697021 -- 25-06-01 17:15:31[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062599182128906 -- 25-06-01 17:15:32[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61989 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057408809661865 -- 25-06-01 17:15:32[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64043 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024770021438599 -- 25-06-01 17:15:34[吴文超-755] -- /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.0028750896453857 -- 25-06-01 17:15:34[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029520988464355 -- 25-06-01 17:15:34[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019880056381226 -- 25-06-01 17:15:52[吴文超-755] -- /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.0030460357666016 -- 25-06-01 17:15:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030910968780518 -- 25-06-01 17:15:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046250820159912 -- 25-06-01 17:15:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61989 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044269561767578 -- 25-06-01 17:15:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64043 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018058061599731 -- 25-06-01 17:15:53[吴文超-755] -- /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.0035622119903564 -- 25-06-01 17:15:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035858154296875 -- 25-06-01 17:15:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049011707305908 -- 25-06-01 17:15:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61989 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00465989112854 -- 25-06-01 17:15:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64043 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018387079238892 -- 25-06-01 17:15:53[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016838788986206 -- 25-06-01 17:16:20[吴文超-755] -- /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%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=61989 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 = 61989 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029349327087402 -- 25-06-01 17:16:20[吴文超-755] -- /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%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=61989 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029640197753906 -- 25-06-01 17:16:20[吴文超-755] -- /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%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=61989 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030961036682129 -- 25-06-01 17:16:20[吴文超-755] -- /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%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=61989 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 = 4721486 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029129981994629 -- 25-06-01 17:16:20[吴文超-755] -- /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%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=61989 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027063846588135 -- 25-06-01 17:16:20[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =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.017454147338867 -- 25-06-01 17:16:20[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016669988632202 -- 25-06-01 17:16:20[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01787805557251 -- 25-06-01 17:16:34[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036709308624268 -- 25-06-01 17:16:34[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 25-06-01 17:16:34[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-06-01 17:16:34[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1396805) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026798009872437 -- 25-06-01 17:16:34[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1396805&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select 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.027549028396606 -- 25-06-01 17:16:35[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01558780670166 -- 25-06-01 17:16:35[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025201082229614 -- 25-06-01 17:16:35[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016425132751465 -- 25-06-01 17:22:04[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032517910003662 -- 25-06-01 17:22:04[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031299591064453 -- 25-06-01 17:22:04[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033068656921387 -- 25-06-01 17:22:04[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1403804) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026095867156982 -- 25-06-01 17:22:04[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select 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.034301042556763 -- 25-06-01 17:22:04[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020561933517456 -- 25-06-01 17:22:05[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03553581237793 -- 25-06-01 17:22:05[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021255016326904 -- 25-06-01 17:22:09[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =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.018242835998535 -- 25-06-01 17:22:15[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018321990966797 -- 25-06-01 17:22:22[吴文超-755] -- /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.017918109893799 -- 25-06-01 17:24:05[吴文超-755] -- /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.0035369396209717 -- 25-06-01 17:24:06[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036420822143555 -- 25-06-01 17:24:06[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1403804) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035858154296875 -- 25-06-01 17:24:06[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004680871963501 -- 25-06-01 17:24:06[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044500827789307 -- 25-06-01 17:24:06[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64044 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01612401008606 -- 25-06-01 17:24:11[吴文超-755] -- /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.0031611919403076 -- 25-06-01 17:24:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031781196594238 -- 25-06-01 17:24:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044028759002686 -- 25-06-01 17:24:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041630268096924 -- 25-06-01 17:24:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64044 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021394968032837 -- 25-06-01 17:24:14[吴文超-755] -- /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.0042140483856201 -- 25-06-01 17:24:14[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042600631713867 -- 25-06-01 17:24:14[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019829034805298 -- 25-06-01 17:24:20[吴文超-755] -- /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.0038478374481201 -- 25-06-01 17:24:20[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038938522338867 -- 25-06-01 17:24:20[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051290988922119 -- 25-06-01 17:24:20[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049240589141846 -- 25-06-01 17:24:20[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64044 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017859935760498 -- 25-06-01 17:24:21[吴文超-755] -- /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.0034661293029785 -- 25-06-01 17:24:21[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 25-06-01 17:24:21[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046100616455078 -- 25-06-01 17:24:21[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044069290161133 -- 25-06-01 17:24:21[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64044 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01901388168335 -- 25-06-01 17:24:21[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017759799957275 -- 25-06-01 17:24:54[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035140514373779 -- 25-06-01 17:24:54[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034439563751221 -- 25-06-01 17:24:54[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003587007522583 -- 25-06-01 17:24:54[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1403804) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019886016845703 -- 25-06-01 17:24:54[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1403804&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select 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.021461009979248 -- 25-06-01 17:24:55[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020183086395264 -- 25-06-01 17:24:55[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026062965393066 -- 25-06-01 17:24:55[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017359972000122 -- 25-06-01 18:01:27[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034658908843994 -- 25-06-01 18:01:27[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033249855041504 -- 25-06-01 18:01:27[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035510063171387 -- 25-06-01 18:01:28[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1409727,1409724) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022268056869507 -- 25-06-01 18:01:28[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select 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.029276847839355 -- 25-06-01 18:01:28[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028345108032227 -- 25-06-01 18:01:28[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016049861907959 -- 25-06-01 18:01:28[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020699977874756 -- 25-06-01 18:01:32[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =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.022742033004761 -- 25-06-01 18:01:39[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017259120941162 -- 25-06-01 18:01:51[吴文超-755] -- /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.015856981277466 -- 25-06-01 18:04:35[吴文超-755] -- /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.0031349658966064 -- 25-06-01 18:04:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032498836517334 -- 25-06-01 18:04:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1409727,1409724) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00319504737854 -- 25-06-01 18:04:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042910575866699 -- 25-06-01 18:04:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61991 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044348239898682 -- 25-06-01 18:04:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64045 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020736932754517 -- 25-06-01 18:04:37[吴文超-755] -- /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.0040509700775146 -- 25-06-01 18:04:37[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004072904586792 -- 25-06-01 18:04:37[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020771980285645 -- 25-06-01 18:04:50[吴文超-755] -- /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.0040519237518311 -- 25-06-01 18:04:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040960311889648 -- 25-06-01 18:04:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056521892547607 -- 25-06-01 18:04:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61991 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053761005401611 -- 25-06-01 18:04:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64045 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030866861343384 -- 25-06-01 18:04:52[吴文超-755] -- /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-06-01 18:04:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037951469421387 -- 25-06-01 18:04:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049681663513184 -- 25-06-01 18:04:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 61991 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078918933868408 -- 25-06-01 18:04:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 64045 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019612073898315 -- 25-06-01 18:04:52[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027906894683838 -- 25-06-01 18:05:41[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003180980682373 -- 25-06-01 18:05:41[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030498504638672 -- 25-06-01 18:05:41[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032830238342285 -- 25-06-01 18:05:41[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1409727,1409724) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034358501434326 -- 25-06-01 18:05:41[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1409727,1409724&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select 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.028239011764526 -- 25-06-01 18:05:41[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020559072494507 -- 25-06-01 18:05:42[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030391931533813 -- 25-06-01 18:05:42[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026737928390503 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004364013671875 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043020248413086 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037741661071777 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037400722503662 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039060115814209 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 4711919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037100315093994 -- 25-06-01 19:54:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018413066864014 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039620399475098 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004040002822876 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035059452056885 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034561157226562 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036370754241943 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 4712702 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034561157226562 -- 25-06-01 20:17:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01879096031189 -- 25-06-01 20:18:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261818%22}&event=edit_extrafareApply&extrafareApply_id=61818 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 = 61818 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032570362091064 -- 25-06-01 20:18:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261818%22}&event=edit_extrafareApply&extrafareApply_id=61818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032711029052734 -- 25-06-01 20:18:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261818%22}&event=edit_extrafareApply&extrafareApply_id=61818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034050941467285 -- 25-06-01 20:18:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261818%22}&event=edit_extrafareApply&extrafareApply_id=61818 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 = 4699778 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032429695129395 -- 25-06-01 20:18:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261818%22}&event=edit_extrafareApply&extrafareApply_id=61818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024301052093506 -- 25-06-01 20:18:01[张昭霞-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.01983904838562 -- 25-06-01 20:18:01[张昭霞-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.015947103500366 -- 25-06-01 20:18:01[张昭霞-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.027459859848022 -- 25-06-01 21:44:10[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select p.*,c.cont_name apply_cont,org.org_name department,date_format(p.purch_plan_date,'%Y-%m-%d') purch_plan_date, 2 appr_type_id,a.appr_proc_name from dbpurc.purc_purcplan p LEFT JOIN dbsys.sys_contact c ON p.purcplan_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON p.purcplan_department_id = org.org_id LEFT JOIN dboa.oa_appr_process a ON a.appr_proc_id = p.appr_proc_id where p.purcplan_id = 3527 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003248929977417 -- 25-06-01 21:44:10[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select * from dbpurc.purc_purcplan_product where purcplan_id = 3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003216028213501 -- 25-06-01 21:44:10[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select p.*,c.cust_name supplier from dbpurc.purc_purcplan_supplier p left join dbsys.sys_customer c on p.supplier_id = c.customer_id where purcplan_id = 3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032980442047119 -- 25-06-01 21:44:10[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033369064331055 -- 25-06-01 21:44:10[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3527 and plan_quote.status_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031130313873291 -- 25-06-01 21:44:10[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019471883773804 -- 25-06-01 21:44:18[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018352031707764 -- 25-06-01 21:44:19[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02147102355957 -- 25-06-01 21:44:21[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5745 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 5745 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041720867156982 -- 25-06-01 21:44:21[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5745 select org_id,org_name from dbsys.sys_org where corp_acct_id = 14 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040080547332764 -- 25-06-01 21:44:21[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5745 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042531490325928 -- 25-06-01 21:44:21[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5745 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 = 4715330 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040230751037598 -- 25-06-01 21:44:21[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5745 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017135858535767 -- 25-06-01 22:38:57[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 25-06-01 22:38:57[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.0033259391784668 -- 25-06-01 22:38:57[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003558874130249 -- 25-06-01 22:38:57[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 (1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0068099498748779 -- 25-06-01 22:38:57[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.026323795318604 -- 25-06-01 22:38:57[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018833160400391 -- 25-06-01 22:38:58[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%彭宗平%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01904296875 -- 25-06-01 22:38:58[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%济南办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02082896232605 -- 25-06-01 22:39:25[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040898323059082 -- 25-06-01 22:39:25[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.0040810108184814 -- 25-06-01 22:39:25[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041470527648926 -- 25-06-01 22:39:25[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 (1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081651210784912 -- 25-06-01 22:39:25[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.017827987670898 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034668445587158 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.0034921169281006 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038490295410156 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 (1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035140514373779 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.021389007568359 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017424821853638 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%彭宗平%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017776012420654 -- 25-06-01 22:40:09[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%济南办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020117998123169 -- 25-06-01 22:40:15[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%济%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018203973770142 -- 25-06-01 22:40:27[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017581939697266 -- 25-06-01 22:40:37[彭宗平-508] -- /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.01860785484314 -- 25-06-01 22:43:56[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038559436798096 -- 25-06-01 22:43:56[彭宗平-508] -- /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 (1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036258697509766 -- 25-06-01 22:43:56[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023347139358521 -- 25-06-01 22:44:01[彭宗平-508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039198398590088 -- 25-06-01 22:44:01[彭宗平-508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018582820892334 -- 25-06-01 22:44:06[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036530494689941 -- 25-06-01 22:44:06[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018616914749146 -- 25-06-01 22:44:06[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016323089599609 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032448768615723 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.0031929016113281 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 (1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034818649291992 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1421231,1421230,1421229,1421228,1421227,1421226,1421225,1421224,1421223,1421222,1421221,1421220,1421219,1421218,1421217,1421216,1421215,1421214&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.022481203079224 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024693012237549 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%彭宗平%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026816844940186 -- 25-06-01 22:50:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%济南办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018431901931763 -- 25-06-01 23:06:24 -- /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.003680944442749 -- 25-06-01 23:06:24 -- /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.0041589736938477 -- 25-06-01 23:06:24 -- /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='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038750171661377 -- 25-06-01 23:06:24[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021184921264648 -- 25-06-01 23:06:24[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019152879714966 -- 25-06-01 23:06:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcPlan&purcplan_id=3527 select p.*,c.cont_name apply_cont,org.org_name department,date_format(p.purch_plan_date,'%Y-%m-%d') purch_plan_date, 2 appr_type_id,a.appr_proc_name from dbpurc.purc_purcplan p LEFT JOIN dbsys.sys_contact c ON p.purcplan_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON p.purcplan_department_id = org.org_id LEFT JOIN dboa.oa_appr_process a ON a.appr_proc_id = p.appr_proc_id where p.purcplan_id = 3527 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041518211364746 -- 25-06-01 23:06:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcPlan&purcplan_id=3527 select * from dbpurc.purc_purcplan_product where purcplan_id = 3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041229724884033 -- 25-06-01 23:06:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcPlan&purcplan_id=3527 select p.*,c.cust_name supplier from dbpurc.purc_purcplan_supplier p left join dbsys.sys_customer c on p.supplier_id = c.customer_id where purcplan_id = 3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042500495910645 -- 25-06-01 23:06:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcPlan&purcplan_id=3527 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037839412689209 -- 25-06-01 23:06:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcPlan&purcplan_id=3527 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3527 and plan_quote.status_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035469532012939 -- 25-06-01 23:06:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcPlan&purcplan_id=3527 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019559860229492 -- 25-06-01 23:06:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01976203918457 -- 25-06-01 23:06:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018605947494507 -- 25-06-01 23:12:07[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select p.*,c.cont_name apply_cont,org.org_name department,date_format(p.purch_plan_date,'%Y-%m-%d') purch_plan_date, 2 appr_type_id,a.appr_proc_name from dbpurc.purc_purcplan p LEFT JOIN dbsys.sys_contact c ON p.purcplan_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON p.purcplan_department_id = org.org_id LEFT JOIN dboa.oa_appr_process a ON a.appr_proc_id = p.appr_proc_id where p.purcplan_id = 3527 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041821002960205 -- 25-06-01 23:12:07[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select * from dbpurc.purc_purcplan_product where purcplan_id = 3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044758319854736 -- 25-06-01 23:12:07[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select p.*,c.cust_name supplier from dbpurc.purc_purcplan_supplier p left join dbsys.sys_customer c on p.supplier_id = c.customer_id where purcplan_id = 3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043740272521973 -- 25-06-01 23:12:07[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3527 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039219856262207 -- 25-06-01 23:12:07[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3527 and plan_quote.status_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037178993225098 -- 25-06-01 23:12:07[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223527%22%7D&event=edit_purcPlan&purcplan_id=3527 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 172 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018148183822632 -- 25-06-01 23:12:11[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223524%22%7D&event=edit_purcPlan&purcplan_id=3524 select p.*,c.cont_name apply_cont,org.org_name department,date_format(p.purch_plan_date,'%Y-%m-%d') purch_plan_date, 2 appr_type_id,a.appr_proc_name from dbpurc.purc_purcplan p LEFT JOIN dbsys.sys_contact c ON p.purcplan_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON p.purcplan_department_id = org.org_id LEFT JOIN dboa.oa_appr_process a ON a.appr_proc_id = p.appr_proc_id where p.purcplan_id = 3524 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036530494689941 -- 25-06-01 23:12:11[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223524%22%7D&event=edit_purcPlan&purcplan_id=3524 select * from dbpurc.purc_purcplan_product where purcplan_id = 3524 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036818981170654 -- 25-06-01 23:12:11[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223524%22%7D&event=edit_purcPlan&purcplan_id=3524 select p.*,c.cust_name supplier from dbpurc.purc_purcplan_supplier p left join dbsys.sys_customer c on p.supplier_id = c.customer_id where purcplan_id = 3524 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038118362426758 -- 25-06-01 23:12:11[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223524%22%7D&event=edit_purcPlan&purcplan_id=3524 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3524 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003788948059082 -- 25-06-01 23:12:11[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223524%22%7D&event=edit_purcPlan&purcplan_id=3524 SELECT customer.cust_name,customer.customer_id,plan_prd.*,plan_quote.it_price,plan_quote.tax_bill_price,plan_quote.it_amount,plan_quote.tax_bill_amount,plan_quote.notes as quote_notes,plan_quote.quote_prd_id,plan_quote.status_id FROM dbpurc.purc_purcplan_product plan_prd LEFT JOIN dbpurc.purc_purcplan_supplier pupsu on pupsu.purcplan_id = plan_prd.purcplan_id LEFT JOIN dbpurc.purc_quote_product plan_quote on plan_quote.product_id = plan_prd.purcplan_prd_id AND plan_quote.supplier_id = pupsu.supplier_id LEFT JOIN dbsys.sys_customer customer on customer.customer_id = pupsu.supplier_id WHERE plan_prd.purcplan_id=3524 and plan_quote.status_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035290718078613 -- 25-06-01 23:12:11[马绍凤-172] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_purcPlan%22,%22purcplan_id%22:%223524%22%7D&event=edit_purcPlan&purcplan_id=3524 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 172 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016030073165894 -- 25-06-01 23:20:18 -- /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.0032029151916504 -- 25-06-01 23:20:18 -- /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.0037012100219727 -- 25-06-01 23:20:18 -- /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='FeiFei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034711360931396 -- 25-06-01 23:20:18[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018886089324951 -- 25-06-01 23:20:19[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022958993911743 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 96099 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004202127456665 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select payment_id from dbthird.thd_payment where oa_payment_id = 96099 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046901702880859 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 114621 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043058395385742 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 4698173 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036439895629883 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038399696350098 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select * from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 4698173 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036380290985107 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036170482635498 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036749839782715 -- 25-06-01 23:20:20[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025141954421997 -- 25-06-01 23:20:23[肖飞飞-477] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024805784225464 -- 25-06-01 23:20:23[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019413948059082 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 95990 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040609836578369 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select payment_id from dbthird.thd_payment where oa_payment_id = 95990 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041439533233643 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 114511 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040550231933594 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 4694718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035839080810547 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036079883575439 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select * from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 4694718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035591125488281 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035679340362549 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035970211029053 -- 25-06-01 23:20:25[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017369985580444 -- 25-06-01 23:20:29[肖飞飞-477] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017191886901855 -- 25-06-01 23:20:29[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018263101577759 -- 25-06-01 23:25:32[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017295122146606 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 96099 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034270286560059 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select payment_id from dbthird.thd_payment where oa_payment_id = 96099 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039258003234863 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 114621 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038189888000488 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 4698173 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033209323883057 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024159908294678 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select * from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035290718078613 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 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 = 4698173 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033450126647949 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003324031829834 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033490657806396 -- 25-06-01 23:25:33[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024971961975098 -- 25-06-01 23:25:34[高祥-33] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96099 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025893926620483 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018283843994141 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 95990 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040068626403809 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select payment_id from dbthird.thd_payment where oa_payment_id = 95990 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040249824523926 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 114511 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039849281311035 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 4694718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003450870513916 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018334150314331 -- 25-06-01 23:25:35[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select * from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036160945892334 -- 25-06-01 23:25:36[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 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 = 4694718 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034439563751221 -- 25-06-01 23:25:36[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034589767456055 -- 25-06-01 23:25:36[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035078525543213 -- 25-06-01 23:25:36[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025644063949585 -- 25-06-01 23:25:36[高祥-33] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=95990 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017503023147583 -- 25-06-01 23:25:37[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------