Time: 0.017825841903687 -- 25-08-03 00:02:54[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.0035600662231445 -- 25-08-03 00:02:54[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.0035290718078613 -- 25-08-03 00:02:54[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.003673791885376 -- 25-08-03 00:02:54[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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 (1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039258003234863 -- 25-08-03 00:02:54[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.030644178390503 -- 25-08-03 00:02:55[彭宗平-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.018111944198608 -- 25-08-03 00:02:55[彭宗平-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.017860889434814 -- 25-08-03 00:02:55[彭宗平-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.019540071487427 -- 25-08-03 00:03:02[彭宗平-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.018805027008057 -- 25-08-03 00:03:13[彭宗平-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.019316911697388 -- 25-08-03 00:03:19[彭宗平-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.021565914154053 -- 25-08-03 00:05: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.0037038326263428 -- 25-08-03 00:05: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 (1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035331249237061 -- 25-08-03 00:05: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.020120143890381 -- 25-08-03 00:05:40[彭宗平-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.0039479732513428 -- 25-08-03 00:05:40[彭宗平-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.017892122268677 -- 25-08-03 00:05:45[彭宗平-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.0035200119018555 -- 25-08-03 00:05:45[彭宗平-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.025696992874146 -- 25-08-03 00:05:47[彭宗平-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.0036101341247559 -- 25-08-03 00:05:47[彭宗平-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.017523050308228 -- 25-08-03 00:05:48[彭宗平-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.00347900390625 -- 25-08-03 00:05:48[彭宗平-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.020474910736084 -- 25-08-03 00:05:49[彭宗平-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.017106771469116 -- 25-08-03 00:07:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.0034329891204834 -- 25-08-03 00:07:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.0033090114593506 -- 25-08-03 00:07:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.0035679340362549 -- 25-08-03 00:07:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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 (1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037710666656494 -- 25-08-03 00:07:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.019323110580444 -- 25-08-03 00:07:37[彭宗平-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.018309831619263 -- 25-08-03 00:07:37[彭宗平-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.020301103591919 -- 25-08-03 00:07:37[彭宗平-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.021827936172485 -- 25-08-03 00:07:41[彭宗平-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.016086101531982 -- 25-08-03 00:07:52[彭宗平-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.022224187850952 -- 25-08-03 00:07:56[彭宗平-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.018970012664795 -- 25-08-03 00:09:11[彭宗平-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.0038678646087646 -- 25-08-03 00:09:11[彭宗平-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 (1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037240982055664 -- 25-08-03 00:09:12[彭宗平-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.019508838653564 -- 25-08-03 00:09:14[彭宗平-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.0029759407043457 -- 25-08-03 00:09:14[彭宗平-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.019609928131104 -- 25-08-03 00:09: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.0038719177246094 -- 25-08-03 00:09: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.024730205535889 -- 25-08-03 00:09: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.015912055969238 -- 25-08-03 00:10:11[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.0031421184539795 -- 25-08-03 00:10:11[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.0031180381774902 -- 25-08-03 00:10:11[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.0033149719238281 -- 25-08-03 00:10:11[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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 (1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035741329193115 -- 25-08-03 00:10:11[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495087,1495086,1495085,1495084,1495083,1495082,1495081,1495080,1495079,1495078,1495077&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.025505065917969 -- 25-08-03 00:10:11[彭宗平-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.023224115371704 -- 25-08-03 00:10:11[彭宗平-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.016624927520752 -- 25-08-03 00:10:12[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%济南办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014943838119507 -- 25-08-03 00:10:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.0029408931732178 -- 25-08-03 00:10:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.0029361248016357 -- 25-08-03 00:10:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.0031979084014893 -- 25-08-03 00:10:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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 (1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029749870300293 -- 25-08-03 00:10:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1495054,1494422,1494175,1494174,1494163,1494161,1494160,1493987&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.016494989395142 -- 25-08-03 00:39:20[吴凌刚-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.027638912200928 -- 25-08-03 00:39:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38330 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 = 38330 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061349868774414 -- 25-08-03 00:39:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38330 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38330 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046601295471191 -- 25-08-03 00:39:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38330 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 = 5031125 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033159255981445 -- 25-08-03 00:39:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035099983215332 -- 25-08-03 00:39:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38330 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 = 5031125 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033180713653564 -- 25-08-03 00:39:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018869161605835 -- 25-08-03 00:39:34[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020800828933716 -- 25-08-03 00:39:35[吴凌刚-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.02028489112854 -- 25-08-03 00:39:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 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 = 38329 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042979717254639 -- 25-08-03 00:39:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38329 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043759346008301 -- 25-08-03 00:39:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 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 = 5031104 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038230419158936 -- 25-08-03 00:39:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040249824523926 -- 25-08-03 00:39:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 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 = 5031104 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038230419158936 -- 25-08-03 00:39:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01653003692627 -- 25-08-03 00:39:46[吴凌刚-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.023064136505127 -- 25-08-03 00:39:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 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 = 38329 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034809112548828 -- 25-08-03 00:39:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38329 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034999847412109 -- 25-08-03 00:39:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 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 = 5031104 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034880638122559 -- 25-08-03 00:39:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035190582275391 -- 25-08-03 00:39:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 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 = 5031104 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00347900390625 -- 25-08-03 00:39:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020681858062744 -- 25-08-03 00:39:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028165102005005 -- 25-08-03 00:39:50[吴凌刚-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.021497011184692 -- 25-08-03 00:39:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3703 select a.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(a.purch_apply_date,'%Y-%m-%d') apply_date,1 appr_type_id,p.appr_proc_name, date_format(a.purch_end_date,'%Y-%m-%d') purch_end_date from dbpurc.purc_apply a LEFT JOIN dbsys.sys_contact c ON a.purch_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON a.purch_department_id = org.org_id LEFT JOIN dbsys.sys_contact cr on a.createdby_id = cr.cont_id LEFT JOIN dbsys.sys_contact up on a.updatedby_id = up.cont_id LEFT JOIN dboa.oa_appr_process p ON a.appr_proc_id = p.appr_proc_id where a.purcapply_id = 3703 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052640438079834 -- 25-08-03 00:39:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3703 select * from dbpurc.purc_apply_product where purcapply_id = 3703 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 25-08-03 00:39:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3703 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01817512512207 -- 25-08-03 00:39:53[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015672922134399 -- 25-08-03 00:39:54[吴凌刚-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.038389921188354 -- 25-08-03 05:35:14[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057699680328369 -- 25-08-03 05:35:14[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046300888061523 -- 25-08-03 05:35:14[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037500858306885 -- 25-08-03 05:35:14[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047039985656738 -- 25-08-03 05:35:14[李磊-753] -- /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= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021283864974976 -- 25-08-03 05:35:14[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=64077 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 = 64077 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003061056137085 -- 25-08-03 05:35:14[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=64077 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030050277709961 -- 25-08-03 05:35:14[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=64077 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031499862670898 -- 25-08-03 05:35:14[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=64077 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 = 5019563 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002964973449707 -- 25-08-03 05:35:14[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=64077 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018445014953613 -- 25-08-03 05:35:14[李磊-753] -- /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.016987085342407 -- 25-08-03 05:35:15[李磊-753] -- /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.018570899963379 -- 25-08-03 05:35:15[李磊-753] -- /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.024289131164551 -- 25-08-03 05:35:17[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037670135498047 -- 25-08-03 05:35:17[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036649703979492 -- 25-08-03 05:35:17[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036520957946777 -- 25-08-03 05:35:17[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036599636077881 -- 25-08-03 05:35:17[李磊-753] -- /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= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014896869659424 -- 25-08-03 09:45:59 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028719902038574 -- 25-08-03 09:45:59 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039379596710205 -- 25-08-03 09:45:59 -- /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.0031778812408447 -- 25-08-03 09:45:59[吴凌刚-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.023422002792358 -- 25-08-03 09:46:00[吴凌刚-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.01701021194458 -- 25-08-03 11:33:30 -- /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.018733978271484 -- 25-08-03 11:33:35[吴凌刚-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.016938924789429 -- 25-08-03 12:55:12[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63338 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 = 63338 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028660297393799 -- 25-08-03 12:55:12[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63338 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002885103225708 -- 25-08-03 12:55:12[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63338 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030598640441895 -- 25-08-03 12:55:12[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63338 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 = 4919028 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028729438781738 -- 25-08-03 12:55:12[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63338 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018767118453979 -- 25-08-03 12:55:12[李丹-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.026751041412354 -- 25-08-03 12:55:13[李丹-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.016993999481201 -- 25-08-03 12:55:13[李丹-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.019345045089722 -- 25-08-03 12:56:15[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63281 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 = 63281 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034151077270508 -- 25-08-03 12:56:15[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63281 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034680366516113 -- 25-08-03 12:56:15[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63281 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035579204559326 -- 25-08-03 12:56:15[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63281 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 = 4910574 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034210681915283 -- 25-08-03 12:56:15[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63281 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023567199707031 -- 25-08-03 12:56:15[李丹-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.01623797416687 -- 25-08-03 12:56:15[李丹-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.019598007202148 -- 25-08-03 12:56:15[李丹-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.027383089065552 -- 25-08-03 13:35:04 -- /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.015210866928101 -- 25-08-03 13:35:04 -- /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.0031299591064453 -- 25-08-03 13:35:04 -- /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.0036039352416992 -- 25-08-03 13:35:04 -- /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='XiongWangXian' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033829212188721 -- 25-08-03 13:35:04[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019357919692993 -- 25-08-03 13:35:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024832010269165 -- 25-08-03 13:49:57[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.0036001205444336 -- 25-08-03 13:49:57[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.0034980773925781 -- 25-08-03 13:49:57[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.0036799907684326 -- 25-08-03 13:49:57[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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 (1461463) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004533052444458 -- 25-08-03 13:49:57[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.028979063034058 -- 25-08-03 13:49:57[李丹-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.02361798286438 -- 25-08-03 13:49:57[李丹-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.018422842025757 -- 25-08-03 13:49:57[李丹-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.038151025772095 -- 25-08-03 13:50:06[李丹-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.02096700668335 -- 25-08-03 13:50:09[李丹-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.017752885818481 -- 25-08-03 13:50:41[李丹-751] -- /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.017796039581299 -- 25-08-03 13:51:00[李丹-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.0036051273345947 -- 25-08-03 13:51:00[李丹-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 (1461463) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035009384155273 -- 25-08-03 13:51:00[李丹-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.017791986465454 -- 25-08-03 13:51:03[李丹-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.0035011768341064 -- 25-08-03 13:51:03[李丹-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.01578688621521 -- 25-08-03 13:51:04[李丹-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.0031030178070068 -- 25-08-03 13:51:04[李丹-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.01821494102478 -- 25-08-03 13:51:06[李丹-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.0035929679870605 -- 25-08-03 13:51:07[李丹-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.015108108520508 -- 25-08-03 13:51:07[李丹-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.0029330253601074 -- 25-08-03 13:51:08[李丹-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.01941704750061 -- 25-08-03 13:51:09[李丹-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.0038490295410156 -- 25-08-03 13:51:09[李丹-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.022584915161133 -- 25-08-03 13:51:09[李丹-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.014937877655029 -- 25-08-03 14:06:25[张承龙-2197] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2197 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018864870071411 -- 25-08-03 15:05:49 -- /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.003748893737793 -- 25-08-03 15:05:49 -- /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.0042600631713867 -- 25-08-03 15:05:49 -- /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='Wang4Wang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039799213409424 -- 25-08-03 15:05:49[姜维华-529] -- /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= 16 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017332792282104 -- 25-08-03 15:05:49[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02151083946228 -- 25-08-03 15:44:52[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=63056 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 = 63056 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037658214569092 -- 25-08-03 15:44:53[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=63056 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038070678710938 -- 25-08-03 15:44:53[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=63056 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039448738098145 -- 25-08-03 15:44:53[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=63056 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 = 4873249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037529468536377 -- 25-08-03 15:44:53[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=63056 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037589073181152 -- 25-08-03 15:44:53[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=63056 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019790887832642 -- 25-08-03 15:44:53[李丹-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.021695852279663 -- 25-08-03 15:44:53[李丹-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.026023149490356 -- 25-08-03 15:44: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.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018568992614746 -- 25-08-03 15:45:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.00372314453125 -- 25-08-03 15:45:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.0036928653717041 -- 25-08-03 15:45:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.0037848949432373 -- 25-08-03 15:45:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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 (1461463) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004080057144165 -- 25-08-03 15:45:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1461463&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.020377159118652 -- 25-08-03 16:18:48 -- /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.017972946166992 -- 25-08-03 16:18:49[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019811868667603 -- 25-08-03 16:18:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015994071960449 -- 25-08-03 16:19:00[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017688989639282 -- 25-08-03 16:20:18[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 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 = 63758 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031630992889404 -- 25-08-03 16:20:18[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031900405883789 -- 25-08-03 16:20:18[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033259391784668 -- 25-08-03 16:20:18[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 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 = 4965635 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028493881225586 -- 25-08-03 16:20: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 AND cust_disp_name like '%上海办-梁思聪%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015449047088623 -- 25-08-03 16:20: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.025053977966309 -- 25-08-03 16:20: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.017125129699707 -- 25-08-03 16:20:22[李丹-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.0033810138702393 -- 25-08-03 16:20:22[李丹-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.025339841842651 -- 25-08-03 16:20: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.0029768943786621 -- 25-08-03 16:20: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.02026104927063 -- 25-08-03 16:20:29[李丹-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.016853094100952 -- 25-08-03 16:20:58[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 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 = 63758 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029559135437012 -- 25-08-03 16:20:58[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002997875213623 -- 25-08-03 16:20:58[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031149387359619 -- 25-08-03 16:20:58[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 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 = 4965635 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029511451721191 -- 25-08-03 16:20:58[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03016996383667 -- 25-08-03 16:20:59[李丹-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.017518043518066 -- 25-08-03 16:20:59[李丹-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.030626773834229 -- 25-08-03 16:20:59[李丹-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.018582105636597 -- 25-08-03 16:22:07[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63930 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 = 63930 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035049915313721 -- 25-08-03 16:22:07[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035068988800049 -- 25-08-03 16:22:07[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036489963531494 -- 25-08-03 16:22:07[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63930 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 = 5000990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003511905670166 -- 25-08-03 16:22:07[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020417928695679 -- 25-08-03 16:22: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 =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.019684076309204 -- 25-08-03 16:22: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 = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%李丹%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015892028808594 -- 25-08-03 16:22: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 = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020279884338379 -- 25-08-03 16:22:29[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 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 = 63758 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037429332733154 -- 25-08-03 16:22:29[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037810802459717 -- 25-08-03 16:22:29[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039780139923096 -- 25-08-03 16:22:29[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 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 = 4965635 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037651062011719 -- 25-08-03 16:22:29[李丹-751] -- /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%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017621994018555 -- 25-08-03 16:22:30[李丹-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.01704216003418 -- 25-08-03 16:22:30[李丹-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.015594959259033 -- 25-08-03 16:22:30[李丹-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.016767978668213 -- 25-08-03 16:32:03[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0172119140625 -- 25-08-03 16:32:10[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01822304725647 -- 25-08-03 16:32:12[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017248868942261 -- 25-08-03 16:57:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016073942184448 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 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 = 64155 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64155 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036640167236328 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 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 = 64155 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003058910369873 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030770301818848 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032451152801514 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 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 = 5032123 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030441284179688 -- 25-08-03 16:57:25[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64155 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027628898620605 -- 25-08-03 16:57:27[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64155 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02514386177063 -- 25-08-03 16:57:27[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021697998046875 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 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 = 64153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043370723724365 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64153 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045077800750732 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 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 = 64153 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042891502380371 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042359828948975 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043718814849854 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 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 = 5031156 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042121410369873 -- 25-08-03 16:57:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015761852264404 -- 25-08-03 16:57:34[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016109943389893 -- 25-08-03 16:57:34[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027431011199951 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 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 = 64152 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004249095916748 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64152 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043630599975586 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 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 = 64152 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040600299835205 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004086971282959 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042538642883301 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 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 = 5031150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040419101715088 -- 25-08-03 16:57:36[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027956008911133 -- 25-08-03 16:57:40[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015745878219604 -- 25-08-03 16:57:41[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018030166625977 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 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 = 64150 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035920143127441 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037028789520264 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 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 = 64150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034580230712891 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034921169281006 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 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 = 5030756 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034639835357666 -- 25-08-03 16:57:42[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016355037689209 -- 25-08-03 16:57:44[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015563011169434 -- 25-08-03 16:57:44[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027673006057739 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 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 = 64121 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035901069641113 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036778450012207 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 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 = 64121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034511089324951 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034821033477783 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 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 = 5026008 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034549236297607 -- 25-08-03 16:57:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015020132064819 -- 25-08-03 16:57:48[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023997068405151 -- 25-08-03 16:57:48[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019109964370728 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 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 = 64120 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038118362426758 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 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 = 64120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035688877105713 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035958290100098 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037620067596436 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 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 = 5025998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035641193389893 -- 25-08-03 16:57:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016424894332886 -- 25-08-03 16:57:54[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021553039550781 -- 25-08-03 16:57:55[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017665147781372 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 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 = 64113 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039291381835938 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036180019378662 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 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 = 64113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033941268920898 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035500526428223 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 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 = 5025738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033760070800781 -- 25-08-03 16:57:56[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021265983581543 -- 25-08-03 16:57:57[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019227981567383 -- 25-08-03 16:57:57[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021308898925781 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 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 = 64100 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035629272460938 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032720565795898 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 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 = 64100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030181407928467 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030419826507568 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031931400299072 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 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 = 5025146 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030219554901123 -- 25-08-03 16:57:58[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030961036682129 -- 25-08-03 16:58:03[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016784906387329 -- 25-08-03 16:58:04[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018460988998413 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 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 = 63758 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040810108184814 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041739940643311 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 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 = 63758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035521984100342 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035700798034668 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037281513214111 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 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 = 4965635 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035600662231445 -- 25-08-03 16:58:05[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019128084182739 -- 25-08-03 16:58:06[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016433000564575 -- 25-08-03 16:58:07[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016532182693481 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 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 = 63758 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031750202178955 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 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 = 63758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031640529632568 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00319504737854 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032191276550293 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 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 = 4965635 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031981468200684 -- 25-08-03 16:58:08[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63758 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026423931121826 -- 25-08-03 16:58:22[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025804042816162 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 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 = 64100 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035388469696045 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 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 = 64100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035438537597656 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035600662231445 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036239624023438 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 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 = 5025146 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035250186920166 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64100 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025561094284058 -- 25-08-03 16:58:23[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0263512134552 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 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 = 64113 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035619735717773 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037980079650879 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 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 = 64113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035538673400879 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035510063171387 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036160945892334 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 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 = 5025738 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035419464111328 -- 25-08-03 16:58:24[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64113 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019680976867676 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 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 = 64142 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038731098175049 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64142 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035409927368164 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 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 = 64142 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033619403839111 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033271312713623 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034980773925781 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 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 = 5029378 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032830238342285 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032780170440674 -- 25-08-03 17:05:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02559494972229 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 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 = 64142 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037128925323486 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64142 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040059089660645 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 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 = 64142 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037291049957275 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003756046295166 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037829875946045 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 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 = 5029378 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037178993225098 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037150382995605 -- 25-08-03 17:05:45[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264142%22}&event=edit_extrafareApply&extrafareApply_id=64142 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018831968307495 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 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 = 64151 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00376296043396 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64151 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038530826568604 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 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 = 64151 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036439895629883 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036628246307373 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038149356842041 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 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 = 5030841 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036320686340332 -- 25-08-03 17:05:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264151%22}&event=edit_extrafareApply&extrafareApply_id=64151 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018832921981812 -- 25-08-03 17:09:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264153%22}&event=edit_extrafareApply&extrafareApply_id=64153 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 = 64153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030179023742676 -- 25-08-03 17:09:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264153%22}&event=edit_extrafareApply&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029540061950684 -- 25-08-03 17:09:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264153%22}&event=edit_extrafareApply&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030839443206787 -- 25-08-03 17:09:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264153%22}&event=edit_extrafareApply&extrafareApply_id=64153 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 = 5031156 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002938985824585 -- 25-08-03 17:09:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264153%22}&event=edit_extrafareApply&extrafareApply_id=64153 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031872987747192 -- 25-08-03 17:09:27[彭宗平-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.025344133377075 -- 25-08-03 17:09:27[彭宗平-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.017032861709595 -- 25-08-03 17:09:27[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三组%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019221067428589 -- 25-08-03 17:09:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264152%22}&event=edit_extrafareApply&extrafareApply_id=64152 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 = 64152 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-08-03 17:09:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264152%22}&event=edit_extrafareApply&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 25-08-03 17:09:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264152%22}&event=edit_extrafareApply&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-08-03 17:09:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264152%22}&event=edit_extrafareApply&extrafareApply_id=64152 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 = 5031150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036330223083496 -- 25-08-03 17:09:37[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264152%22}&event=edit_extrafareApply&extrafareApply_id=64152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015205860137939 -- 25-08-03 17:09: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 AND cust_disp_name like '%济南办-彭宗平%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017640113830566 -- 25-08-03 17:09:38[彭宗平-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.017000198364258 -- 25-08-03 17:09:38[彭宗平-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.018651008605957 -- 25-08-03 17:52:12 -- /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.016775846481323 -- 25-08-03 18:06:41[吴凌刚-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.030045032501221 -- 25-08-03 18:34:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264121%22}&event=edit_extrafareApply&extrafareApply_id=64121 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 = 64121 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038390159606934 -- 25-08-03 18:34:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264121%22}&event=edit_extrafareApply&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037481784820557 -- 25-08-03 18:34:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264121%22}&event=edit_extrafareApply&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038940906524658 -- 25-08-03 18:34:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264121%22}&event=edit_extrafareApply&extrafareApply_id=64121 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 = 5026008 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037350654602051 -- 25-08-03 18:34:17[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264121%22}&event=edit_extrafareApply&extrafareApply_id=64121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029590129852295 -- 25-08-03 18:34: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 AND cust_disp_name like '%上海办-何飞-外租司机%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02151894569397 -- 25-08-03 18:34: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.030078887939453 -- 25-08-03 18:34: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.018326044082642 -- 25-08-03 18:35:18[李丹-751] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019750118255615 -- 25-08-03 18:35:21[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037500858306885 -- 25-08-03 18:35:21[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054621696472168 -- 25-08-03 18:35:21[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036618709564209 -- 25-08-03 18:35:21[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036392211914062 -- 25-08-03 18:35:21[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020189046859741 -- 25-08-03 18:35:42[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041279792785645 -- 25-08-03 18:35:42[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003748893737793 -- 25-08-03 18:35:42[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 25-08-03 18:35:42[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040469169616699 -- 25-08-03 18:35:42[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01802396774292 -- 25-08-03 18:35:47[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=63930 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 = 63930 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032742023468018 -- 25-08-03 18:35:47[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032269954681396 -- 25-08-03 18:35:48[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 25-08-03 18:35:48[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=63930 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 = 5000990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031869411468506 -- 25-08-03 18:35:48[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020707845687866 -- 25-08-03 18:35:48[李丹-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.023090839385986 -- 25-08-03 18:35:48[李丹-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.015986919403076 -- 25-08-03 18:35:48[李丹-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.020165920257568 -- 25-08-03 18:36:01[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039710998535156 -- 25-08-03 18:36:01[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039858818054199 -- 25-08-03 18:36:01[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038759708404541 -- 25-08-03 18:36:01[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038881301879883 -- 25-08-03 18:36:01[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020907878875732 -- 25-08-03 18:36:40[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004317045211792 -- 25-08-03 18:36:40[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042428970336914 -- 25-08-03 18:36:40[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041399002075195 -- 25-08-03 18:36:40[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041201114654541 -- 25-08-03 18:36:40[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018087148666382 -- 25-08-03 18:36:48[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035610198974609 -- 25-08-03 18:36:48[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035429000854492 -- 25-08-03 18:36:48[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035009384155273 -- 25-08-03 18:36:48[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034990310668945 -- 25-08-03 18:36:48[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0212562084198 -- 25-08-03 18:37:30[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015589952468872 -- 25-08-03 18:37:32[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 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 = 64151 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033488273620605 -- 25-08-03 18:37:32[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64151 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034761428833008 -- 25-08-03 18:37:32[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 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 = 64151 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028829574584961 -- 25-08-03 18:37:32[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029139518737793 -- 25-08-03 18:37:32[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030450820922852 -- 25-08-03 18:37:33[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 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 = 5030841 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028820037841797 -- 25-08-03 18:37:33[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64151 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030143022537231 -- 25-08-03 18:37:35[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016067981719971 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 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 = 64101 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036039352416992 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64101 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003626823425293 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 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 = 64101 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030419826507568 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030820369720459 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032100677490234 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 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 = 5025182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030591487884521 -- 25-08-03 18:37:50[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02066707611084 -- 25-08-03 18:38:04[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015388965606689 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 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 = 63930 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00351881980896 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63930 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035078525543213 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 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 = 63930 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029239654541016 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029799938201904 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031001567840576 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 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 = 5000990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029311180114746 -- 25-08-03 18:38:26[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017184972763062 -- 25-08-03 18:38:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01736307144165 -- 25-08-03 18:38:29[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01884388923645 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 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 = 63921 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038290023803711 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63921 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038700103759766 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 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 = 63921 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036180019378662 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036590099334717 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038251876831055 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 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 = 4999310 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036470890045166 -- 25-08-03 18:38:43[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63921 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021141052246094 -- 25-08-03 18:38:46[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023864984512329 -- 25-08-03 18:38:48[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 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 = 64101 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037829875946045 -- 25-08-03 18:38:48[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 64101 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039448738098145 -- 25-08-03 18:38:48[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 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 = 64101 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036389827728271 -- 25-08-03 18:38:48[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036602020263672 -- 25-08-03 18:38:49[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038108825683594 -- 25-08-03 18:38:49[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 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 = 5025182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036220550537109 -- 25-08-03 18:38:49[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018136024475098 -- 25-08-03 18:38:51[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016875982284546 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 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 = 63930 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037829875946045 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63930 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034608840942383 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 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 = 63930 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031940937042236 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032529830932617 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033760070800781 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 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 = 5000990 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 25-08-03 18:39:17[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63930 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019936800003052 -- 25-08-03 18:39:18[熊旺先-480] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 480 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021689891815186 -- 25-08-03 19:15:50[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004633903503418 -- 25-08-03 19:15:50[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040159225463867 -- 25-08-03 19:15:50[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045361518859863 -- 25-08-03 19:15:50[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046248435974121 -- 25-08-03 19:15:50[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01896595954895 -- 25-08-03 19:15:53[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038092136383057 -- 25-08-03 19:15:53[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037000179290771 -- 25-08-03 19:15:53[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003633975982666 -- 25-08-03 19:15:53[李丹-751] -- /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 = 751 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() )AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036160945892334 -- 25-08-03 19:15:53[李丹-751] -- /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= 751 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) AND status_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0194251537323 -- 25-08-03 20:08:50[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264084%22}&event=edit_extrafareApply&extrafareApply_id=64084 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 = 64084 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031058788299561 -- 25-08-03 20:08:50[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264084%22}&event=edit_extrafareApply&extrafareApply_id=64084 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030219554901123 -- 25-08-03 20:08:50[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264084%22}&event=edit_extrafareApply&extrafareApply_id=64084 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031790733337402 -- 25-08-03 20:08:50[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264084%22}&event=edit_extrafareApply&extrafareApply_id=64084 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 = 5020545 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030069351196289 -- 25-08-03 20:08:50[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264084%22}&event=edit_extrafareApply&extrafareApply_id=64084 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021363973617554 -- 25-08-03 20:08:51[彭宗平-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.018912076950073 -- 25-08-03 20:08:51[彭宗平-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.01851487159729 -- 25-08-03 20:08:51[彭宗平-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.016062021255493 -- 25-08-03 20:43:44 -- /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.014938116073608 -- 25-08-03 21:07:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014929056167603 -- 25-08-03 21:07:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027095079421997 -- 25-08-03 21:07:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020430088043213 -- 25-08-03 23:27:21[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264101%22}&event=edit_extrafareApply&extrafareApply_id=64101 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 = 64101 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036728382110596 -- 25-08-03 23:27:21[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264101%22}&event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035991668701172 -- 25-08-03 23:27:21[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264101%22}&event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037639141082764 -- 25-08-03 23:27:21[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264101%22}&event=edit_extrafareApply&extrafareApply_id=64101 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 = 5025182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035929679870605 -- 25-08-03 23:27:21[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2264101%22}&event=edit_extrafareApply&extrafareApply_id=64101 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020617961883545 -- 25-08-03 23:27:22[李丹-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.028301954269409 -- 25-08-03 23:27:23[李丹-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.025583982467651 -- 25-08-03 23:27:23[李丹-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 ------------------------------------------------------------------------------------------------------------------------------------------------------