Time: 0.025604963302612 -- 25-05-01 08:24:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381243&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035099983215332 -- 25-05-01 08:24:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381243&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.0033838748931885 -- 25-05-01 08:24:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381243&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035860538482666 -- 25-05-01 08:24:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381243&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 (1381243) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041429996490479 -- 25-05-01 08:24:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381243&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.021659135818481 -- 25-05-01 08:24:18[李丹-751] -- /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.020109891891479 -- 25-05-01 08:24:18[李丹-751] -- /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.016523838043213 -- 25-05-01 08:24:18[李丹-751] -- /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.02106499671936 -- 25-05-01 08:24:21[李丹-751] -- /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.023629188537598 -- 25-05-01 08:24:25[李丹-751] -- /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.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01658821105957 -- 25-05-01 08:24:41[李丹-751] -- /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.01784610748291 -- 25-05-01 08:24:48[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036120414733887 -- 25-05-01 08:24:48[李丹-751] -- /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 (1381243) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035011768341064 -- 25-05-01 08:24:49[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014665126800537 -- 25-05-01 08:24:50[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028738975524902 -- 25-05-01 08:24:50[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018329858779907 -- 25-05-01 08:24:51[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032508373260498 -- 25-05-01 08:24:51[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015357971191406 -- 25-05-01 08:24:52[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030300617218018 -- 25-05-01 08:24:52[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0191810131073 -- 25-05-01 08:24:54[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037720203399658 -- 25-05-01 08:24:54[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027773857116699 -- 25-05-01 08:24:55[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014888048171997 -- 25-05-01 08:28:46[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029771327972412 -- 25-05-01 08:28:46[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.0028781890869141 -- 25-05-01 08:28:46[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030539035797119 -- 25-05-01 08:28:46[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 (1381668) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025929927825928 -- 25-05-01 08:28:46[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.026968955993652 -- 25-05-01 08:28:47[李丹-751] -- /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.017035007476807 -- 25-05-01 08:28:47[李丹-751] -- /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.019994020462036 -- 25-05-01 08:28:47[李丹-751] -- /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.032389879226685 -- 25-05-01 08:28:50[李丹-751] -- /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.019032955169678 -- 25-05-01 08:28:53[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015850067138672 -- 25-05-01 08:29:16[李丹-751] -- /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.01894998550415 -- 25-05-01 08:29:29[李丹-751] -- /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.0037510395050049 -- 25-05-01 08:29:29[李丹-751] -- /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.0038509368896484 -- 25-05-01 08:29:29[李丹-751] -- /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 (1381668) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036659240722656 -- 25-05-01 08:29:29[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048060417175293 -- 25-05-01 08:29:29[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 751,updatedby_id = 751 where extrafareApply_id = 61209 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046501159667969 -- 25-05-01 08:29:29[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 751,updatedby_id = 751 where otherfee_id = 63320 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018944025039673 -- 25-05-01 08:29:30[李丹-751] -- /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.0035121440887451 -- 25-05-01 08:29:30[李丹-751] -- /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.0035231113433838 -- 25-05-01 08:29:30[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017796039581299 -- 25-05-01 08:29:32[李丹-751] -- /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.0034840106964111 -- 25-05-01 08:29:32[李丹-751] -- /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.0035319328308105 -- 25-05-01 08:29:32[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047659873962402 -- 25-05-01 08:29:32[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 751,updatedby_id = 751 where extrafareApply_id = 61209 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048007965087891 -- 25-05-01 08:29:32[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 751,updatedby_id = 751 where otherfee_id = 63320 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019057989120483 -- 25-05-01 08:29:33[李丹-751] -- /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.0033299922943115 -- 25-05-01 08:29:33[李丹-751] -- /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.0033900737762451 -- 25-05-01 08:29:33[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043740272521973 -- 25-05-01 08:29:33[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 751,updatedby_id = 751 where extrafareApply_id = 61209 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004227876663208 -- 25-05-01 08:29:33[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 751,updatedby_id = 751 where otherfee_id = 63320 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019592046737671 -- 25-05-01 08:29:33[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016630887985229 -- 25-05-01 08:39:07[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032939910888672 -- 25-05-01 08:39:07[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.003180980682373 -- 25-05-01 08:39:07[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033910274505615 -- 25-05-01 08:39:07[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 (1381668) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035519599914551 -- 25-05-01 08:39:07[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1381668&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.029927968978882 -- 25-05-01 08:39:07[李丹-751] -- /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.018866062164307 -- 25-05-01 08:39:07[李丹-751] -- /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.01662015914917 -- 25-05-01 08:39:07[李丹-751] -- /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.018164873123169 -- 25-05-01 09:53:34 -- /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.0036330223083496 -- 25-05-01 09:53:34 -- /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.0041320323944092 -- 25-05-01 09:53:34 -- /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='GuaiJiao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038540363311768 -- 25-05-01 09:53:34[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026489019393921 -- 25-05-01 09:53:35[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018293857574463 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003558874130249 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select payment_id from dbthird.thd_payment where oa_payment_id = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036640167236328 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 112051 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041120052337646 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034449100494385 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036139488220215 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select * from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036091804504395 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003464937210083 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034539699554443 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034780502319336 -- 25-05-01 09:53:38[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017714023590088 -- 25-05-01 09:54:04[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01861310005188 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036070346832275 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select payment_id from dbthird.thd_payment where oa_payment_id = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036189556121826 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 112051 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036079883575439 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035979747772217 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036871433258057 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select * from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036070346832275 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003619909286499 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003615140914917 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036349296569824 -- 25-05-01 09:54:05[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017565011978149 -- 25-05-01 09:54:06[朱玲-297] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019103050231934 -- 25-05-01 09:54:07[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025038003921509 -- 25-05-01 09:54:08[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35452 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35452 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054171085357666 -- 25-05-01 09:54:08[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35452 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35452 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041220188140869 -- 25-05-01 09:54:08[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35452 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 = 4589386 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036649703979492 -- 25-05-01 09:54:08[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037839412689209 -- 25-05-01 09:54:08[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35452 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 = 4589386 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003593921661377 -- 25-05-01 09:54:08[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015429019927979 -- 25-05-01 09:54:13[朱玲-297] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016388177871704 -- 25-05-01 09:54:13[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016972064971924 -- 25-05-01 09:54:14[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35451 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35451 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003403902053833 -- 25-05-01 09:54:14[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35451 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35451 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033788681030273 -- 25-05-01 09:54:14[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35451 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 = 4589380 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032389163970947 -- 25-05-01 09:54:14[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35451 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034050941467285 -- 25-05-01 09:54:14[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35451 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 = 4589380 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032339096069336 -- 25-05-01 09:54:14[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35451 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018777847290039 -- 25-05-01 09:54:18[朱玲-297] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35451 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028928995132446 -- 25-05-01 09:54:19[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017974853515625 -- 25-05-01 09:54:20[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35450 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35450 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039818286895752 -- 25-05-01 09:54:20[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35450 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35450 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039420127868652 -- 25-05-01 09:54:20[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35450 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 = 4589344 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034279823303223 -- 25-05-01 09:54:20[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35450 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035891532897949 -- 25-05-01 09:54:20[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35450 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 = 4589344 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003432035446167 -- 25-05-01 09:54:20[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35450 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020653009414673 -- 25-05-01 09:54:22[朱玲-297] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35450 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025949001312256 -- 25-05-01 09:54:22[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024394035339355 -- 25-05-01 09:54:23[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35404 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35404 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039119720458984 -- 25-05-01 09:54:23[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35404 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35404 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039379596710205 -- 25-05-01 09:54:23[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35404 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 = 4579484 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033791065216064 -- 25-05-01 09:54:23[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35404 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035839080810547 -- 25-05-01 09:54:23[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35404 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 = 4579484 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033948421478271 -- 25-05-01 09:54:23[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35404 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019092082977295 -- 25-05-01 09:54:31[朱玲-297] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35404 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014959096908569 -- 25-05-01 09:54:32[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023667097091675 -- 25-05-01 09:54:33[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35396 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35396 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033690929412842 -- 25-05-01 09:54:33[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35396 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35396 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033788681030273 -- 25-05-01 09:54:33[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35396 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 = 4578545 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028409957885742 -- 25-05-01 09:54:33[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35396 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030701160430908 -- 25-05-01 09:54:33[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35396 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 = 4578545 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028648376464844 -- 25-05-01 09:54:33[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35396 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031748056411743 -- 25-05-01 09:54:55[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020592927932739 -- 25-05-01 09:54:56[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35208 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35208 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040900707244873 -- 25-05-01 09:54:56[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35208 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35208 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041050910949707 -- 25-05-01 09:54:56[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35208 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 = 4563007 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039629936218262 -- 25-05-01 09:54:56[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35208 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041530132293701 -- 25-05-01 09:54:56[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35208 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 = 4563007 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039589405059814 -- 25-05-01 09:54:56[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35208 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023146867752075 -- 25-05-01 09:55:04[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027085065841675 -- 25-05-01 10:23:15[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35452 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042960643768311 -- 25-05-01 10:23:15[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35452 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042190551757812 -- 25-05-01 10:23:15[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 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 = 4589386 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037851333618164 -- 25-05-01 10:23:15[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038831233978271 -- 25-05-01 10:23:15[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 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 = 4589386 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037338733673096 -- 25-05-01 10:23:15[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017158031463623 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 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 = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036790370941162 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 select payment_id from dbthird.thd_payment where oa_payment_id = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034229755401611 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 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 = 112051 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037128925323486 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031919479370117 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024884939193726 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 select * from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033459663391113 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031778812408447 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003148078918457 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032360553741455 -- 25-05-01 10:23:22[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2293456%22%7D&event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018647909164429 -- 25-05-01 10:23:31[李晓瑜-298] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0194411277771 -- 25-05-01 10:23:31[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019517183303833 -- 25-05-01 10:23:44[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35452 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032310485839844 -- 25-05-01 10:23:44[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35452 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034279823303223 -- 25-05-01 10:23:44[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 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 = 4589386 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032331943511963 -- 25-05-01 10:23:44[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034010410308838 -- 25-05-01 10:23:44[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 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 = 4589386 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032029151916504 -- 25-05-01 10:23:44[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235452%22%7D&event=edit_fareApply&fareApply_id=35452 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019859075546265 -- 25-05-01 10:32:25 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039639472961426 -- 25-05-01 10:32:25 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044398307800293 -- 25-05-01 10:32:25 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041408538818359 -- 25-05-01 10:32:25[高祥-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.01685094833374 -- 25-05-01 10:32:25[高祥-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.025038003921509 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033938884735107 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select payment_id from dbthird.thd_payment where oa_payment_id = 93456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 112051 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030128955841064 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028769969940186 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003026008605957 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select * from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030138492584229 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 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 = 4579184 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028669834136963 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028691291809082 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029239654541016 -- 25-05-01 10:32:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016252040863037 -- 25-05-01 10:32:29[高祥-33] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=93456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020355224609375 -- 25-05-01 10:32:30[高祥-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.021907091140747 -- 25-05-01 10:37:22 -- /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.0037720203399658 -- 25-05-01 10:37:22 -- /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.0042638778686523 -- 25-05-01 10:37:22 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040760040283203 -- 25-05-01 10:37:22[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022575855255127 -- 25-05-01 10:37:23[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019446849822998 -- 25-05-01 10:37:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35455 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35455 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038778781890869 -- 25-05-01 10:37:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35455 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35455 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039019584655762 -- 25-05-01 10:37:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35455 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 = 4589404 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037069320678711 -- 25-05-01 10:37:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35455 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039041042327881 -- 25-05-01 10:37:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35455 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 = 4589404 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037062168121338 -- 25-05-01 10:37:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35455 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018866062164307 -- 25-05-01 10:37:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35455 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026085138320923 -- 25-05-01 10:37:27[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020843982696533 -- 25-05-01 10:37:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35454 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35454 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045809745788574 -- 25-05-01 10:37:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35454 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35454 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041790008544922 -- 25-05-01 10:37:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35454 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 = 4589400 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040209293365479 -- 25-05-01 10:37:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35454 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041911602020264 -- 25-05-01 10:37:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35454 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 = 4589400 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039939880371094 -- 25-05-01 10:37:28[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35454 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01521897315979 -- 25-05-01 10:37:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35454 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014886140823364 -- 25-05-01 10:37:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017593860626221 -- 25-05-01 10:37:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35453 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35453 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036039352416992 -- 25-05-01 10:37:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35453 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35453 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035381317138672 -- 25-05-01 10:37:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35453 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 = 4589397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033769607543945 -- 25-05-01 10:37:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35453 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035438537597656 -- 25-05-01 10:37:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35453 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 = 4589397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033681392669678 -- 25-05-01 10:37:31[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35453 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030766010284424 -- 25-05-01 10:37:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35453 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016423940658569 -- 25-05-01 10:37:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020586013793945 -- 25-05-01 16:11:34 -- /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.0033309459686279 -- 25-05-01 16:11:34 -- /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.0038011074066162 -- 25-05-01 16:11:34 -- /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='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035359859466553 -- 25-05-01 16:11:34[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016152143478394 -- 25-05-01 16:11:35[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019721031188965 -- 25-05-01 16:11:37[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35456 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35456 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044059753417969 -- 25-05-01 16:11:37[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35456 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35456 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044381618499756 -- 25-05-01 16:11:37[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35456 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 = 4589437 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037698745727539 -- 25-05-01 16:11:37[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039820671081543 -- 25-05-01 16:11:37[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35456 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 = 4589437 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037891864776611 -- 25-05-01 16:11:37[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016511917114258 -- 25-05-01 16:11:39[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35456 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030478954315186 -- 25-05-01 16:11:39[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031427145004272 -- 25-05-01 16:11:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35457 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044069290161133 -- 25-05-01 16:11:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35457 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044040679931641 -- 25-05-01 16:11:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 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 = 4589500 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039069652557373 -- 25-05-01 16:11:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041148662567139 -- 25-05-01 16:11:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 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 = 4589500 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039148330688477 -- 25-05-01 16:11:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017305850982666 -- 25-05-01 16:12:09[张体海-1176] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=35457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015756130218506 -- 25-05-01 16:12:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017812013626099 -- 25-05-01 16:12:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35457 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035338401794434 -- 25-05-01 16:12:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35457 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034987926483154 -- 25-05-01 16:12:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 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 = 4589500 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 25-05-01 16:12:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003525972366333 -- 25-05-01 16:12:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 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 = 4589500 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034658908843994 -- 25-05-01 16:12:11[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=35457 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018479824066162 -- 25-05-01 16:12:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01830792427063 -- 25-05-01 17:09:51 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035560131072998 -- 25-05-01 17:09:51 -- /buz/oa/index.php/oamgmt/oa_application?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.004403829574585 -- 25-05-01 17:09:51 -- /buz/oa/index.php/oamgmt/oa_application?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='ZongHeGuanLiBuLiuLiYan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037519931793213 -- 25-05-01 17:09:51[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029535055160522 -- 25-05-01 17:09:52[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046780109405518 -- 25-05-01 17:09:52[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041420459747314 -- 25-05-01 17:09:52[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057752132415771 -- 25-05-01 17:09:52[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044970512390137 -- 25-05-01 17:09:52[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016727924346924 -- 25-05-01 17:09:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals 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 = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034210681915283 -- 25-05-01 17:09:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023229122161865 -- 25-05-01 17:10:06[刘丽艳-347] -- /buz/oa/index.php/oamgmt/get_company_item select root_acct_id from dbsys.sys_acct where acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038061141967773 -- 25-05-01 17:10:06[刘丽艳-347] -- /buz/oa/index.php/oamgmt/get_company_item SELECT o.org_id ,o.org_name FROM dbsys.sys_org o WHERE o.acct_id = 2 and isenable = 1 and o.is_corporate = 1 LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014697074890137 -- 25-05-01 17:10:16[刘丽艳-347] -- /buz/oa/index.php/oamgmt/get_company_item select root_acct_id from dbsys.sys_acct where acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033230781555176 -- 25-05-01 17:10:16[刘丽艳-347] -- /buz/oa/index.php/oamgmt/get_company_item SELECT o.org_id ,o.org_name FROM dbsys.sys_org o WHERE o.acct_id = 2 and isenable = 1 and o.is_corporate = 1 AND o.org_name like '%深圳市飞力士现代物流有限公司%' LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027846097946167 -- 25-05-01 17:11:13[刘丽艳-347] -- /buz/oa/index.php/oamgmt/officialSeals_application?event=save_officialSeals_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016085147857666 -- 25-05-01 17:11:31[刘丽艳-347] -- /buz/oa/index.php/oamgmt/officialSeals_application?event=save_officialSeals_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014833927154541 -- 25-05-01 17:11:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/officialSeals_application?event=is_upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021121978759766 -- 25-05-01 17:11:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020814895629883 -- 25-05-01 17:11:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019037008285522 -- 25-05-01 17:11:36[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027066946029663 -- 25-05-01 17:11:36[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036089420318604 -- 25-05-01 17:11:36[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035688877105713 -- 25-05-01 17:11:36[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047621726989746 -- 25-05-01 17:11:36[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035920143127441 -- 25-05-01 17:11:36[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019329071044922 -- 25-05-01 17:11:39[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037238597869873 -- 25-05-01 17:11:39[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035700798034668 -- 25-05-01 17:11:39[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035569667816162 -- 25-05-01 17:11:39[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018770933151245 -- 25-05-01 17:11:42[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=undoSubmit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016901016235352 -- 25-05-01 17:11:43[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003741979598999 -- 25-05-01 17:11:43[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032968521118164 -- 25-05-01 17:11:43[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047919750213623 -- 25-05-01 17:11:43[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-05-01 17:11:43[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01971697807312 -- 25-05-01 17:11:45[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035920143127441 -- 25-05-01 17:11:45[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035450458526611 -- 25-05-01 17:11:45[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017966985702515 -- 25-05-01 17:11:47[刘丽艳-347] -- /buz/oa/index.php/oamgmt/officialSeals_application?event=is_upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017925977706909 -- 25-05-01 17:11:47[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019562005996704 -- 25-05-01 17:11:47[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021743059158325 -- 25-05-01 17:11:49[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016057968139648 -- 25-05-01 17:11:49[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036101341247559 -- 25-05-01 17:11:49[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 25-05-01 17:11:49[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037591457366943 -- 25-05-01 17:11:49[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035321712493896 -- 25-05-01 17:11:49[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018272876739502 -- 25-05-01 17:11:51[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029370784759521 -- 25-05-01 17:11:51[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028970241546631 -- 25-05-01 17:11:51[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029001235961914 -- 25-05-01 17:11:51[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030411958694458 -- 25-05-01 17:12:24[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004004955291748 -- 25-05-01 17:12:24[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035569667816162 -- 25-05-01 17:12:24[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044481754302979 -- 25-05-01 17:12:24[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039551258087158 -- 25-05-01 17:12:24[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021543979644775 -- 25-05-01 17:12:25[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 25-05-01 17:12:25[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034050941467285 -- 25-05-01 17:12:25[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034048557281494 -- 25-05-01 17:12:25[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021298170089722 -- 25-05-01 17:12:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036849975585938 -- 25-05-01 17:12:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036740303039551 -- 25-05-01 17:12:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039041042327881 -- 25-05-01 17:12:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-05-01 17:12:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02079701423645 -- 25-05-01 17:12:30[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040218830108643 -- 25-05-01 17:12:30[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040469169616699 -- 25-05-01 17:12:30[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040140151977539 -- 25-05-01 17:12:30[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018697023391724 -- 25-05-01 17:12:31[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038039684295654 -- 25-05-01 17:12:31[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037519931793213 -- 25-05-01 17:12:31[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042681694030762 -- 25-05-01 17:12:32[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037591457366943 -- 25-05-01 17:12:32[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017933130264282 -- 25-05-01 17:12:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034520626068115 -- 25-05-01 17:12:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034499168395996 -- 25-05-01 17:12:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003450870513916 -- 25-05-01 17:12:35[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016159057617188 -- 25-05-01 17:13:11 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030369758605957 -- 25-05-01 17:13:11 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035560131072998 -- 25-05-01 17:13:11 -- /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='GuanGuan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032238960266113 -- 25-05-01 17:13:11[关云-169] -- /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.029956102371216 -- 25-05-01 17:13:11[关云-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.017337083816528 -- 25-05-01 17:13:12[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037951469421387 -- 25-05-01 17:13:12[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037088394165039 -- 25-05-01 17:13:12[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003917932510376 -- 25-05-01 17:13:12[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003715991973877 -- 25-05-01 17:13:12[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018050909042358 -- 25-05-01 17:13:13[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035228729248047 -- 25-05-01 17:13:13[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035338401794434 -- 25-05-01 17:13:13[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003507137298584 -- 25-05-01 17:13:13[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018790006637573 -- 25-05-01 17:13:15[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038118362426758 -- 25-05-01 17:13:15[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037460327148438 -- 25-05-01 17:13:15[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047571659088135 -- 25-05-01 17:13:15[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041220188140869 -- 25-05-01 17:13:15[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02557897567749 -- 25-05-01 17:13:16[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals 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 = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031499862670898 -- 25-05-01 17:13:16[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019926071166992 -- 25-05-01 17:14:04[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003821849822998 -- 25-05-01 17:14:04[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00360107421875 -- 25-05-01 17:14:04[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036330223083496 -- 25-05-01 17:14:04[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00360107421875 -- 25-05-01 17:14:04[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016602039337158 -- 25-05-01 17:14:47[关云-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.017865896224976 -- 25-05-01 17:14:48[关云-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.042608976364136 -- 25-05-01 17:38:36[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030770301818848 -- 25-05-01 17:38:36[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029499530792236 -- 25-05-01 17:38:36[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030629634857178 -- 25-05-01 17:38:37[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028738975524902 -- 25-05-01 17:38:37[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015678882598877 -- 25-05-01 17:39:41[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017634153366089 -- 25-05-01 17:39:41[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019251823425293 -- 25-05-01 17:39:43[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5528 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 = 5528 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036449432373047 -- 25-05-01 17:39:43[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5528 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034408569335938 -- 25-05-01 17:39:43[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5528 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036768913269043 -- 25-05-01 17:39:43[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5528 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 = 4588583 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034658908843994 -- 25-05-01 17:39:43[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5528 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018484115600586 -- 25-05-01 17:39:54 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037519931793213 -- 25-05-01 17:39:54 -- /buz/oa/index.php/oamgmt/oa_application?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.0042140483856201 -- 25-05-01 17:39:54 -- /buz/oa/index.php/oamgmt/oa_application?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='ZongHeGuanLiBuLiuLiYan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038981437683105 -- 25-05-01 17:39:54[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018738031387329 -- 25-05-01 17:39:54[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004119873046875 -- 25-05-01 17:39:54[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040209293365479 -- 25-05-01 17:39:54[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045340061187744 -- 25-05-01 17:39:54[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040180683135986 -- 25-05-01 17:39:54[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019905805587769 -- 25-05-01 17:39:56[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037729740142822 -- 25-05-01 17:39:56[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037038326263428 -- 25-05-01 17:39:56[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035960674285889 -- 25-05-01 17:39:56[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020900964736938 -- 25-05-01 17:40:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004194974899292 -- 25-05-01 17:40:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00412917137146 -- 25-05-01 17:40:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004734992980957 -- 25-05-01 17:40:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 347 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041859149932861 -- 25-05-01 17:40:29[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 347 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020646095275879 -- 25-05-01 18:51:38[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923&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.0041220188140869 -- 25-05-01 18:51:38[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923&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.0039918422698975 -- 25-05-01 18:51:38[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923&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.0042948722839355 -- 25-05-01 18:51:38[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923&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 (1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083370208740234 -- 25-05-01 18:51:38[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923&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.02095103263855 -- 25-05-01 18:51:38[彭宗平-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.020171880722046 -- 25-05-01 18:51:39[彭宗平-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.019810914993286 -- 25-05-01 18:51:39[彭宗平-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.027615070343018 -- 25-05-01 18:51:46[彭宗平-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.015645027160645 -- 25-05-01 18:52:56[彭宗平-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.019394874572754 -- 25-05-01 18:53:00[彭宗平-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.016093015670776 -- 25-05-01 18:54:39[彭宗平-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.0033180713653564 -- 25-05-01 18:54:39[彭宗平-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 (1386937,1386936,1386935,1386934,1386933,1386932,1386931,1386930,1386929,1386928,1386927,1386926,1386925,1386924,1386923) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030760765075684 -- 25-05-01 18:54:39[彭宗平-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.017168998718262 -- 25-05-01 18:54:42[彭宗平-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.0033550262451172 -- 25-05-01 18:54:42[彭宗平-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.026108980178833 -- 25-05-01 18:54:51[彭宗平-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.0036871433258057 -- 25-05-01 18:54:51[彭宗平-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.017928838729858 -- 25-05-01 18:54:51[彭宗平-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.016821146011353 -- 25-05-01 18:54:52[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021759033203125 -- 25-05-01 18:55:06[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22%7D&event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040779113769531 -- 25-05-01 18:55:06[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22%7D&event=edit_officialSeals&officialSeals_id=5529 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003931999206543 -- 25-05-01 18:55:06[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22%7D&event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040590763092041 -- 25-05-01 18:55:06[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22%7D&event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038530826568604 -- 25-05-01 18:55:06[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22%7D&event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020354986190796 -- 25-05-01 18:55:16[彭宗平-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.0040280818939209 -- 25-05-01 18:55:16[彭宗平-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.030529022216797 -- 25-05-01 18:55:16[彭宗平-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.028791904449463 -- 25-05-01 18:55:16[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017455101013184 -- 25-05-01 18:55:20[彭宗平-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.01816987991333 -- 25-05-01 18:56:24[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 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 = 61210 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033249855041504 -- 25-05-01 18:56:24[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033378601074219 -- 25-05-01 18:56:24[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035278797149658 -- 25-05-01 18:56:24[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 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 = 4592595 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022094011306763 -- 25-05-01 18:56:24[彭宗平-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.017987012863159 -- 25-05-01 18:56:24[彭宗平-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.015131950378418 -- 25-05-01 18:56:24[彭宗平-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.019881010055542 -- 25-05-01 18:56:33[彭宗平-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.02105712890625 -- 25-05-01 18:56:41[彭宗平-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.0041458606719971 -- 25-05-01 18:56:41[彭宗平-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.03179407119751 -- 25-05-01 18:56:42[彭宗平-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.025081157684326 -- 25-05-01 18:56:47[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 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 = 61210 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028629302978516 -- 25-05-01 18:56:47[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029079914093018 -- 25-05-01 18:56:47[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029098987579346 -- 25-05-01 18:56:47[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 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 = 4592595 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002871036529541 -- 25-05-01 18:56:47[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0157310962677 -- 25-05-01 18:56:48[彭宗平-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.022581100463867 -- 25-05-01 18:56:48[彭宗平-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.017024040222168 -- 25-05-01 18:56:48[彭宗平-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.01778507232666 -- 25-05-01 18:57:46[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 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 = 61210 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034370422363281 -- 25-05-01 18:57:46[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034821033477783 -- 25-05-01 18:57:46[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034959316253662 -- 25-05-01 18:57:46[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 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 = 4592595 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034389495849609 -- 25-05-01 18:57:46[彭宗平-508] -- /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%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=61210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017843008041382 -- 25-05-01 18:57:47[彭宗平-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.021443843841553 -- 25-05-01 18:57:47[彭宗平-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.01489782333374 -- 25-05-01 18:57:47[彭宗平-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.017124891281128 -- 25-05-01 19:23:43 -- /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.003432035446167 -- 25-05-01 19:23:43 -- /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.003931999206543 -- 25-05-01 19:23:43 -- /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.0036849975585938 -- 25-05-01 19:23:43[高祥-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.014896154403687 -- 25-05-01 19:23:44[高祥-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.018707990646362 -- 25-05-01 19:23:45[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035309791564941 -- 25-05-01 19:23:45[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033109188079834 -- 25-05-01 19:23:45[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035200119018555 -- 25-05-01 19:23:45[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 25-05-01 19:23:45[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015049934387207 -- 25-05-01 19:23:48[高祥-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.019381999969482 -- 25-05-01 19:23:49[高祥-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.024451017379761 -- 25-05-01 19:32:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 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 = 5529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044031143188477 -- 25-05-01 19:32:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042438507080078 -- 25-05-01 19:32:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043809413909912 -- 25-05-01 19:32:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 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 = 4591717 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042321681976318 -- 25-05-01 19:32:58[刘丽艳-347] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225529%22}&event=edit_officialSeals&officialSeals_id=5529 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 347 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028056144714355 -- 25-05-01 21:09:47[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225517%22}&event=edit_officialSeals&officialSeals_id=5517 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 = 5517 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034999847412109 -- 25-05-01 21:09:47[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225517%22}&event=edit_officialSeals&officialSeals_id=5517 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034241676330566 -- 25-05-01 21:09:47[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225517%22}&event=edit_officialSeals&officialSeals_id=5517 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035250186920166 -- 25-05-01 21:09:47[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225517%22}&event=edit_officialSeals&officialSeals_id=5517 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 = 4578019 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033538341522217 -- 25-05-01 21:09:47[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%225517%22}&event=edit_officialSeals&officialSeals_id=5517 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016416072845459 -- 25-05-01 21:09:54[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235225%22}&event=edit_fareApply&fareApply_id=35225 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 35225 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036048889160156 -- 25-05-01 21:09:54[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235225%22}&event=edit_fareApply&fareApply_id=35225 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35225 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036449432373047 -- 25-05-01 21:09:54[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235225%22}&event=edit_fareApply&fareApply_id=35225 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 = 4565848 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030410289764404 -- 25-05-01 21:09:54[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235225%22}&event=edit_fareApply&fareApply_id=35225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032949447631836 -- 25-05-01 21:09:54[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235225%22}&event=edit_fareApply&fareApply_id=35225 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 = 4565848 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030171871185303 -- 25-05-01 21:09:54[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235225%22}&event=edit_fareApply&fareApply_id=35225 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017822027206421 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 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 = 61209 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039379596710205 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61209 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004004955291748 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 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 = 61209 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034058094024658 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033578872680664 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034811496734619 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 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 = 4591307 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033211708068848 -- 25-05-01 21:25:16[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261209%22}&event=edit_extrafareApply&extrafareApply_id=61209 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0191969871521 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 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 = 61114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043258666992188 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61114 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042850971221924 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 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 = 61114 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003713846206665 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037379264831543 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038669109344482 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 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 = 4583412 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037260055541992 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036900043487549 -- 25-05-01 21:25:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261114%22}&event=edit_extrafareApply&extrafareApply_id=61114 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018072128295898 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 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 = 61069 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040581226348877 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61069 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040650367736816 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 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 = 61069 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034639835357666 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003525972366333 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036129951477051 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 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 = 4576092 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00347900390625 -- 25-05-01 21:25:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261069%22}&event=edit_extrafareApply&extrafareApply_id=61069 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018370866775513 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 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 = 61068 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041019916534424 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61068 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041079521179199 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 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 = 61068 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035109519958496 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036618709564209 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036859512329102 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 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 = 4576081 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035190582275391 -- 25-05-01 21:25:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261068%22}&event=edit_extrafareApply&extrafareApply_id=61068 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019644021987915 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 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 = 61051 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030829906463623 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 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 = 61051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029349327087402 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030050277709961 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031008720397949 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 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 = 4573204 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029621124267578 -- 25-05-01 21:26:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024121999740601 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 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 = 61050 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040879249572754 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61050 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041439533233643 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 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 = 61050 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034949779510498 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035371780395508 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036530494689941 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 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 = 4573109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034849643707275 -- 25-05-01 21:26:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261050%22}&event=edit_extrafareApply&extrafareApply_id=61050 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015146970748901 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 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 = 61051 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029189586639404 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029520988464355 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 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 = 61051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029079914093018 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029468536376953 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029711723327637 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 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 = 4573204 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029478073120117 -- 25-05-01 21:26:25[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261051%22}&event=edit_extrafareApply&extrafareApply_id=61051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015000104904175 -- 25-05-01 21:26:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 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 = 61048 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030100345611572 -- 25-05-01 21:26:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61048 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003511905670166 -- 25-05-01 21:26:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 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 = 61048 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028669834136963 -- 25-05-01 21:26:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002892017364502 -- 25-05-01 21:26:33[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003046989440918 -- 25-05-01 21:26:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 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 = 4573078 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028820037841797 -- 25-05-01 21:26:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261048%22}&event=edit_extrafareApply&extrafareApply_id=61048 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017899990081787 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 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 = 61039 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035707950592041 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036709308624268 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 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 = 61039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034489631652832 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034770965576172 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036158561706543 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 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 = 4571365 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034589767456055 -- 25-05-01 21:26:38[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261039%22}&event=edit_extrafareApply&extrafareApply_id=61039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020251989364624 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 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 = 61036 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040359497070312 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61036 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041348934173584 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 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 = 61036 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039200782775879 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003960132598877 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041060447692871 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 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 = 4570678 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039210319519043 -- 25-05-01 21:26:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261036%22}&event=edit_extrafareApply&extrafareApply_id=61036 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------