Time: 0.010037899017334 -- 2026-06-19 07:37:55.209[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0054469108581543 -- 2026-06-19 07:37:55.215[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.009490966796875 -- 2026-06-19 07:37:55.559[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013070106506348 -- 2026-06-19 07:37:55.820[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015990734100342 -- 2026-06-19 07:37:55.822[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 1.6162970066071 -- 2026-06-19 07:37:57.438[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021844863891602 -- 2026-06-19 07:37:59.363[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0022189617156982 -- 2026-06-19 07:37:59.712[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '西安市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010930776596069 -- 2026-06-19 07:37:59.912[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015062093734741 -- 2026-06-19 07:38:01.009[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084960460662842 -- 2026-06-19 07:58:49.173 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016911029815674 -- 2026-06-19 07:58:49.177 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0022599697113037 -- 2026-06-19 07:58:49.179 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='QinHu' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019919872283936 -- 2026-06-19 07:58:49.181[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018050670623779 -- 2026-06-19 07:58:49.194[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024509429931641 -- 2026-06-19 07:58:49.197[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091109275817871 -- 2026-06-19 07:58:49.753[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010399103164673 -- 2026-06-19 07:58:49.907[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018951892852783 -- 2026-06-19 07:58:49.909[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.13096404075623 -- 2026-06-19 07:58:50.040[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021194934844971 -- 2026-06-19 07:58:50.402[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0028800964355469 -- 2026-06-19 07:58:50.762[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '南京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089352130889893 -- 2026-06-19 07:58:50.851[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0075399875640869 -- 2026-06-19 07:58:51.494[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0075469017028809 -- 2026-06-19 08:04:48.471 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015168190002441 -- 2026-06-19 08:04:48.474 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0020878314971924 -- 2026-06-19 08:04:48.476 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='ChenTongZhao' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017919540405273 -- 2026-06-19 08:04:48.478[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015790462493896 -- 2026-06-19 08:04:48.491[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020210742950439 -- 2026-06-19 08:04:48.493[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084741115570068 -- 2026-06-19 08:04:48.762[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0096950531005859 -- 2026-06-19 08:04:48.916[陈同照-1165] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017688274383545 -- 2026-06-19 08:04:48.918[陈同照-1165] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12512898445129 -- 2026-06-19 08:04:49.043[陈同照-1165] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.025874137878418 -- 2026-06-19 08:04:54.510[陈同照-1165] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_id
select count(1) cnt,area_id,area_name from dbsys.sys_area where area_type = 3  AND area_name like '%郑州%' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0097558498382568 -- 2026-06-19 08:04:54.601[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017957925796509 -- 2026-06-19 08:04:54.774[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0076241493225098 -- 2026-06-19 08:04:57.844[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0094389915466309 -- 2026-06-19 08:05:06.398[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select admin_id from dbsys.sys_acct where acct_id = 9 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018620491027832 -- 2026-06-19 08:05:06.400[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 312 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086970329284668 -- 2026-06-19 08:05:08.198[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select admin_id from dbsys.sys_acct where acct_id = 9 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016670227050781 -- 2026-06-19 08:05:08.200[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 312 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012936115264893 -- 2026-06-19 08:05:20.272[陈同照-1165] -- /buz/third/index.php/thirdoprt/get_carrier_item
SELECT cust.customer_id AS `id`,cust.cust_disp_name AS `text`, cust.address, cust.tel,inv.pay_mode_id, cust.sys_cust_id,cust.city_id, 
 cust.inv_cust_id,inv.cust_disp_name inv_cust_name, IF(IFNULL(inv.account_name,'')<>'',inv.account_name,inv.cust_name) account_name, 
 inv.opening_bank,inv.bank_account,tce.shipper,tce.shipper_tel,tce.shipper_addr 
 FROM dbthird.v_thd_customer cust 
 left join dbthird.thd_customer_ext tce on tce.customer_id = cust.customer_id 
 left join dbthird.v_thd_customer inv on inv.customer_id = cust.inv_cust_id 
 left join dbsys.sys_customer_ext sce on sce.customer_id = cust.sys_cust_id 
 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust.cust_type,0)>=256 and ifnull(sce.is_blacklist,0) = 0  AND cust.cust_disp_name like '%平达%'  LIMIT 0,50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092639923095703 -- 2026-06-19 08:05:21.791[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_addressInfo_byCarrier
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088558197021484 -- 2026-06-19 08:06:00.391[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018420219421387 -- 2026-06-19 08:06:00.780[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 278114 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015465021133423 -- 2026-06-19 08:06:00.795[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144258 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010251998901367 -- 2026-06-19 08:06:01.114[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144258 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017640590667725 -- 2026-06-19 08:06:01.115[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 8439 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017340183258057 -- 2026-06-19 08:06:01.117[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 8439 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017168521881104 -- 2026-06-19 08:06:01.119[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016670227050781 -- 2026-06-19 08:06:01.121[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6676345
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01770281791687 -- 2026-06-19 08:06:01.237[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086719989776611 -- 2026-06-19 08:06:10.227[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083498954772949 -- 2026-06-19 08:06:10.392[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085210800170898 -- 2026-06-19 08:06:15.754[陈同照-1165] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1165 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010416984558105 -- 2026-06-19 08:37:24.378[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0026881694793701 -- 2026-06-19 08:37:24.381[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085380077362061 -- 2026-06-19 08:37:24.853[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090711116790771 -- 2026-06-19 08:37:25.024[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016169548034668 -- 2026-06-19 08:37:25.026[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11991906166077 -- 2026-06-19 08:37:25.146[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018683195114136 -- 2026-06-19 08:37:26.983[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0027229785919189 -- 2026-06-19 08:37:27.333[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '成都市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093309879302979 -- 2026-06-19 08:37:27.490[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089621543884277 -- 2026-06-19 08:37:28.044[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011959075927734 -- 2026-06-19 08:37:33.363[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_id
select count(1) cnt,area_id,area_name from dbsys.sys_area where area_type = 3  AND area_name like '%贵阳%' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0079138278961182 -- 2026-06-19 08:37:33.502[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014334917068481 -- 2026-06-19 08:37:34.102[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0082378387451172 -- 2026-06-19 08:37:39.829[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019471883773804 -- 2026-06-19 08:37:40.060[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0075709819793701 -- 2026-06-19 08:37:42.092[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014563083648682 -- 2026-06-19 08:37:48.622[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select admin_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018260478973389 -- 2026-06-19 08:37:48.624[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.20326089859009 -- 2026-06-19 08:37:57.392[李磊-753] -- /buz/third/index.php/thirdoprt/get_carrierAddr_item
SELECT cust.customer_id AS `id`,cust.cust_disp_name AS `text`, cust.address, cust.tel,a.address_id, 
 a.contact,a.contact_tel,a.addr_detail,cust.city_id,city.area_name city, cust.inv_cust_id,inv.cust_disp_name inv_cust_name, 
 IF(IFNULL(inv.account_name,'')<>'',inv.account_name,inv.cust_name) account_name, inv.opening_bank,inv.bank_account 
 FROM dbthird.v_thd_customer cust 
 left join dbsys.sys_area city on cust.city_id = city.area_id 
 LEFT JOIN dbthird.thd_address a ON cust.customer_id = a.customer_id and a.isenable = 1 and cust.city_id = a.`city_id` 
 left join dbthird.v_thd_customer inv on inv.customer_id = cust.inv_cust_id 
 left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id 
 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust.cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0  AND ifnull(cust.cust_type,0)&2048>0 AND cust.cust_disp_name like '%李磊%'  LIMIT 0,50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.082816123962402 -- 2026-06-19 08:38:13.252[李磊-753] -- /buz/third/index.php/thirdoprt/get_truckno_item
SELECT truck_id AS `id`,truck_no `text`,d.driver_id, d.driver_name,d.driver_tel,d.driver_type_id,carr.cust_disp_name carrier, 
 t.carrier_id,carr.inv_cust_id,inv_cust.cust_disp_name inv_cust_name,inv_cust.opening_bank,inv_cust.bank_account, 
 IF(IFNULL(inv_cust.account_name,'')<>'',inv_cust.account_name,inv_cust.cust_name) account_name 
 FROM dbthird.thd_truck t 
 left join dbthird.thd_driver d on d.driver_id = t.driver_id and t.isenable = 1 
 left join dbthird.v_thd_customer carr on carr.customer_id = t.carrier_id and carr.isenable = 1 
 left join dbthird.v_thd_customer inv_cust on inv_cust.customer_id = carr.inv_cust_id 
 WHERE t.acct_id =15 and t.isenable = 1 AND t.truck_no like '%贵An%'  limit 10
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0087110996246338 -- 2026-06-19 08:38:45.910[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017850399017334 -- 2026-06-19 08:38:46.172[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select mix_truckwork_id from dbthird.thd_truckwork_ext where truckwork_id = 309070 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034048557281494 -- 2026-06-19 08:38:46.176[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select * from dbthird.thd_truckwork tw 
 left join dbthird.thd_truckwork_fee tw_f on tw_f.truckwork_id = tw.truckwork_id 
 where tw.truckwork_id = 309070 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016970634460449 -- 2026-06-19 08:38:46.178[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 270663 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016748905181885 -- 2026-06-19 08:38:46.180[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 356711 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016610622406006 -- 2026-06-19 08:38:46.333[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016250610351562 -- 2026-06-19 08:38:46.372[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select mix_truckwork_id from dbthird.thd_truckwork_ext where truckwork_id = 309070 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012510061264038 -- 2026-06-19 08:38:46.586[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 309070 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017259120941162 -- 2026-06-19 08:38:46.588[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6676390
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012060165405273 -- 2026-06-19 08:38:46.726[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0097799301147461 -- 2026-06-19 08:38:50.788[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010497093200684 -- 2026-06-19 08:38:51.084[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010422945022583 -- 2026-06-19 08:39:05.505[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_id
select count(1) cnt,area_id,area_name from dbsys.sys_area where area_type = 3  AND area_name like '%深圳%' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021768808364868 -- 2026-06-19 08:39:05.621[李磊-753] -- /buz/third/index.php/thirdoprt/get_area_item
SELECT oa.area_id,concat(oa.area_name,'(',ap.area_name,')') area_name 
FROM dbsys.sys_area oa 
LEFT JOIN dbsys.sys_area ap ON ap.area_id = oa.parent_id 
WHERE oa.area_id > 1 and oa.area_type in(3) AND oa.area_name like '%深圳%' LIMIT 0,100
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011765956878662 -- 2026-06-19 08:39:07.719[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.009645938873291 -- 2026-06-19 08:39:07.885[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019501209259033 -- 2026-06-19 08:39:09.961[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011790037155151 -- 2026-06-19 08:39:10.133[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018419027328491 -- 2026-06-19 08:39:13.064[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010054111480713 -- 2026-06-19 08:39:32.644[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1893724 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012231111526489 -- 2026-06-19 08:39:34.532[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1893724
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015465974807739 -- 2026-06-19 08:49:45.988[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0025010108947754 -- 2026-06-19 08:49:45.991[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084490776062012 -- 2026-06-19 08:49:46.252[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018383026123047 -- 2026-06-19 08:49:46.432[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016660690307617 -- 2026-06-19 08:49:46.434[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.1215488910675 -- 2026-06-19 08:49:46.555[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091149806976318 -- 2026-06-19 08:49:50.098[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017549991607666 -- 2026-06-19 08:49:50.100[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021444082260132 -- 2026-06-19 08:49:50.335[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088820457458496 -- 2026-06-19 08:49:50.504[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014770030975342 -- 2026-06-19 08:49:50.506[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0029549598693848 -- 2026-06-19 08:49:50.509[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014573812484741 -- 2026-06-19 08:49:52.342[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021998882293701 -- 2026-06-19 08:49:54.341[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '成都市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084800720214844 -- 2026-06-19 08:49:54.592[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011482954025269 -- 2026-06-19 08:49:54.851[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015252113342285 -- 2026-06-19 09:25:46.959 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020179748535156 -- 2026-06-19 09:25:46.982 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0029590129852295 -- 2026-06-19 09:25:46.985 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='WuWenChao' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021920204162598 -- 2026-06-19 09:25:46.988[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0025730133056641 -- 2026-06-19 09:25:47.241[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024161338806152 -- 2026-06-19 09:25:47.244[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022703886032104 -- 2026-06-19 09:25:47.805[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089209079742432 -- 2026-06-19 09:25:47.968[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015988349914551 -- 2026-06-19 09:25:47.970[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12526392936707 -- 2026-06-19 09:25:48.096[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.006911039352417 -- 2026-06-19 09:25:49.637[吴文超-755] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016360282897949 -- 2026-06-19 09:25:49.973[吴文超-755] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '武汉市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090250968933105 -- 2026-06-19 09:25:50.140[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091290473937988 -- 2026-06-19 09:25:50.299[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0095851421356201 -- 2026-06-19 09:33:32.599[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021991729736328 -- 2026-06-19 09:33:32.601[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023625135421753 -- 2026-06-19 09:33:32.892[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091948509216309 -- 2026-06-19 09:33:33.065[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016250610351562 -- 2026-06-19 09:33:33.067[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11974692344666 -- 2026-06-19 09:33:33.187[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018975019454956 -- 2026-06-19 09:33:35.119[吴文超-755] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019631385803223 -- 2026-06-19 09:33:35.464[吴文超-755] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '武汉市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0082089900970459 -- 2026-06-19 09:33:35.548[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.008929967880249 -- 2026-06-19 09:33:35.697[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014303207397461 -- 2026-06-19 09:54:26.861 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016429424285889 -- 2026-06-19 09:54:26.864 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.002586841583252 -- 2026-06-19 09:54:26.867 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='LiangSiCong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018839836120605 -- 2026-06-19 09:54:26.869[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020451545715332 -- 2026-06-19 09:54:26.882[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020749568939209 -- 2026-06-19 09:54:26.884[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0069198608398438 -- 2026-06-19 09:54:27.191[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 536 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0087029933929443 -- 2026-06-19 09:54:27.363[梁思聪-536] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015020370483398 -- 2026-06-19 09:54:27.365[梁思聪-536] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.1196300983429 -- 2026-06-19 09:54:27.484[梁思聪-536] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024248838424683 -- 2026-06-19 09:54:29.355[梁思聪-536] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 536 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021560192108154 -- 2026-06-19 09:54:29.669[梁思聪-536] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '上海市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085299015045166 -- 2026-06-19 09:54:29.798[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 536 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020457983016968 -- 2026-06-19 09:54:29.966[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 536 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017077922821045 -- 2026-06-19 09:54:31.784[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 536 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0099649429321289 -- 2026-06-19 09:54:37.690[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1904730
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010037899017334 -- 2026-06-19 09:55:04.461[梁思聪-536] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903141
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010135889053345 -- 2026-06-19 10:30:26.370 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019187927246094 -- 2026-06-19 10:30:26.374 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0028278827667236 -- 2026-06-19 10:30:26.377 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='LiDan' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021698474884033 -- 2026-06-19 10:30:26.379[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0023460388183594 -- 2026-06-19 10:30:26.392[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0023961067199707 -- 2026-06-19 10:30:26.395[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019905090332031 -- 2026-06-19 10:30:26.768[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 751 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020117044448853 -- 2026-06-19 10:30:26.956[李丹-751] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016369819641113 -- 2026-06-19 10:30:26.958[李丹-751] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12882685661316 -- 2026-06-19 10:30:27.087[李丹-751] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021426200866699 -- 2026-06-19 10:30:28.947[李丹-751] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 751 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021810531616211 -- 2026-06-19 10:30:29.246[李丹-751] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '重庆市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0073502063751221 -- 2026-06-19 10:30:29.364[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 751 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01139497756958 -- 2026-06-19 10:30:33.682[李丹-751] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_id
select count(1) cnt,area_id,area_name from dbsys.sys_area where area_type = 3  AND area_name like '%上海市%' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086901187896729 -- 2026-06-19 10:30:33.785[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 751 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0079069137573242 -- 2026-06-19 10:30:34.105[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 751 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021099805831909 -- 2026-06-19 10:30:35.532[李丹-751] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 751 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0080430507659912 -- 2026-06-19 11:55:24.865 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015020370483398 -- 2026-06-19 11:55:24.868 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0020339488983154 -- 2026-06-19 11:55:24.870 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='TangMin' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017499923706055 -- 2026-06-19 11:55:24.872[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019350051879883 -- 2026-06-19 11:55:24.885[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020298957824707 -- 2026-06-19 11:55:24.887[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015759944915771 -- 2026-06-19 11:55:25.211[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 535 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020161151885986 -- 2026-06-19 11:55:25.431[唐敏-535] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019090175628662 -- 2026-06-19 11:55:25.433[唐敏-535] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.1240701675415 -- 2026-06-19 11:55:25.558[唐敏-535] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081651210784912 -- 2026-06-19 11:55:27.149[唐敏-535] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 535 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018959045410156 -- 2026-06-19 11:55:27.497[唐敏-535] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '北京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.008497953414917 -- 2026-06-19 11:55:27.655[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 535 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092000961303711 -- 2026-06-19 11:55:28.010[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 535 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023760080337524 -- 2026-06-19 11:55:32.830[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 535 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0066640377044678 -- 2026-06-19 11:55:33.062[唐敏-535] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 535 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020232915878296 -- 2026-06-19 12:12:26.892 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018620491027832 -- 2026-06-19 12:12:26.896 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
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.002439022064209 -- 2026-06-19 12:12:26.898 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='LanSeTianKong' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002108097076416 -- 2026-06-19 12:12:26.900[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019381046295166 -- 2026-06-19 12:12:26.913[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002363920211792 -- 2026-06-19 12:12:26.916[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019354820251465 -- 2026-06-19 12:12:28.145[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093080997467041 -- 2026-06-19 12:12:28.362[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016829967498779 -- 2026-06-19 12:12:28.364[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12101793289185 -- 2026-06-19 12:12:28.485[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.007706880569458 -- 2026-06-19 12:12:35.991[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018460750579834 -- 2026-06-19 12:12:36.309[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '济南市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0096030235290527 -- 2026-06-19 12:12:36.491[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014448881149292 -- 2026-06-19 12:12:36.863[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0087058544158936 -- 2026-06-19 12:12:38.174[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012650966644287 -- 2026-06-19 12:12:38.337[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022074937820435 -- 2026-06-19 12:12:45.346[彭宗平-508] -- /buz/third/index.php/thirdoprt/tally_list?event=getCarrier_byDptCityId
select admin_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019490718841553 -- 2026-06-19 12:12:45.348[彭宗平-508] -- /buz/third/index.php/thirdoprt/tally_list?event=getCarrier_byDptCityId
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021299123764038 -- 2026-06-19 12:12:45.612[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?&event=get_dockAddr_byCity
select address_id,addr_name,contact,contact_tel from dbthird.thd_address where city_id = 307 
and addr_type_id = 2 and isenable = 1 
and is_dockAddr_internal = 1 
 and acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013502836227417 -- 2026-06-19 12:13:03.235[彭宗平-508] -- /buz/third/index.php/thirdoprt/tally_list?event=sf_order_confirm
select admin_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017321109771729 -- 2026-06-19 12:13:03.237[彭宗平-508] -- /buz/third/index.php/thirdoprt/tally_list?event=sf_order_confirm
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01033616065979 -- 2026-06-19 12:13:03.790[彭宗平-508] -- /buz/third/index.php/thirdoprt/tally_list?event=sf_order_confirm
update dbthird.thd_order_preplan set preplanby_id = 508 where order_id = 1904804 and carrier_id = 3416 and carrier_no <> '' 
and preplan_city_id = 307 and load_addr_id = 205095 and unload_addr_id = 376456
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092411041259766 -- 2026-06-19 12:13:03.906[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016638040542603 -- 2026-06-19 12:13:04.128[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018229007720947 -- 2026-06-19 12:13:23.978[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0176100730896 -- 2026-06-19 12:13:24.197[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0078248977661133 -- 2026-06-19 12:13:29.794[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014779567718506 -- 2026-06-19 12:13:29.796[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.009566068649292 -- 2026-06-19 12:13:30.088[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088181495666504 -- 2026-06-19 12:13:30.421[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014710426330566 -- 2026-06-19 12:13:30.422[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0029160976409912 -- 2026-06-19 12:13:30.425[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085089206695557 -- 2026-06-19 12:13:36.080[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017080307006836 -- 2026-06-19 12:13:36.388[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '济南市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016235113143921 -- 2026-06-19 12:13:36.520[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083580017089844 -- 2026-06-19 12:13:36.712[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098569393157959 -- 2026-06-19 13:26:15.210 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019311904907227 -- 2026-06-19 13:26:15.214 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0025410652160645 -- 2026-06-19 13:26:15.217 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='QinBianLiang' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0022289752960205 -- 2026-06-19 13:26:15.219[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024509429931641 -- 2026-06-19 13:26:15.233[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0025439262390137 -- 2026-06-19 13:26:15.235[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091209411621094 -- 2026-06-19 13:26:15.515[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014756202697754 -- 2026-06-19 13:26:15.701[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019629001617432 -- 2026-06-19 13:26:15.703[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11940312385559 -- 2026-06-19 13:26:15.823[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083270072937012 -- 2026-06-19 13:26:17.569[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019271373748779 -- 2026-06-19 13:26:17.922[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '合肥市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0073988437652588 -- 2026-06-19 13:26:18.037[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089168548583984 -- 2026-06-19 13:26:18.460[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092840194702148 -- 2026-06-19 13:38:07.888 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018360614776611 -- 2026-06-19 13:38:07.892 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0024418830871582 -- 2026-06-19 13:38:07.895 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='QinHu' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021378993988037 -- 2026-06-19 13:38:07.897[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019359588623047 -- 2026-06-19 13:38:07.910[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024769306182861 -- 2026-06-19 13:38:07.912[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022030115127563 -- 2026-06-19 13:38:08.308[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089101791381836 -- 2026-06-19 13:38:08.509[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015690326690674 -- 2026-06-19 13:38:08.511[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11983799934387 -- 2026-06-19 13:38:08.631[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014324188232422 -- 2026-06-19 13:38:08.934[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020129680633545 -- 2026-06-19 13:38:09.271[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '南京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015906095504761 -- 2026-06-19 13:38:09.436[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014729022979736 -- 2026-06-19 13:38:09.657[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086989402770996 -- 2026-06-19 13:38:12.651[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098061561584473 -- 2026-06-19 13:39:30.920[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904351 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0080978870391846 -- 2026-06-19 13:39:52.324[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904351 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021121978759766 -- 2026-06-19 13:40:24.995[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904350 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093719959259033 -- 2026-06-19 13:41:12.399[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904342 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014287948608398 -- 2026-06-19 13:41:51.619[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904348 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093188285827637 -- 2026-06-19 13:42:25.529[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001964807510376 -- 2026-06-19 13:42:25.531[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014888048171997 -- 2026-06-19 13:42:25.705[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023635149002075 -- 2026-06-19 13:42:25.863[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020451545715332 -- 2026-06-19 13:42:25.866[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11914610862732 -- 2026-06-19 13:42:25.985[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0076239109039307 -- 2026-06-19 13:42:26.312[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017518997192383 -- 2026-06-19 13:42:26.657[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '南京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092551708221436 -- 2026-06-19 13:42:26.756[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088760852813721 -- 2026-06-19 13:42:26.893[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018664121627808 -- 2026-06-19 13:44:33.940[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0022609233856201 -- 2026-06-19 13:44:33.943[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010694026947021 -- 2026-06-19 13:44:34.113[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01170802116394 -- 2026-06-19 13:44:34.271[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001924991607666 -- 2026-06-19 13:44:34.273[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12028694152832 -- 2026-06-19 13:44:34.393[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085630416870117 -- 2026-06-19 13:44:34.708[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019538402557373 -- 2026-06-19 13:44:35.061[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '南京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020224809646606 -- 2026-06-19 13:44:35.193[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018433094024658 -- 2026-06-19 13:44:35.350[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0079400539398193 -- 2026-06-19 13:44:36.251[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0095140933990479 -- 2026-06-19 14:09:04.911 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018007755279541 -- 2026-06-19 14:09:04.915 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0023410320281982 -- 2026-06-19 14:09:04.917 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='LiLei' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002039909362793 -- 2026-06-19 14:09:04.919[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018799304962158 -- 2026-06-19 14:09:04.933[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024051666259766 -- 2026-06-19 14:09:04.935[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014683961868286 -- 2026-06-19 14:09:05.258[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020573139190674 -- 2026-06-19 14:09:05.432[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018508434295654 -- 2026-06-19 14:09:05.434[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11902499198914 -- 2026-06-19 14:09:05.553[李磊-753] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012991905212402 -- 2026-06-19 14:09:07.595[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018241405487061 -- 2026-06-19 14:09:07.907[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '成都市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081489086151123 -- 2026-06-19 14:09:08.017[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013766050338745 -- 2026-06-19 14:09:08.239[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012925863265991 -- 2026-06-19 14:09:14.183[李磊-753] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_id
select count(1) cnt,area_id,area_name from dbsys.sys_area where area_type = 3  AND area_name like '%贵阳%' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089840888977051 -- 2026-06-19 14:09:14.287[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.02140998840332 -- 2026-06-19 14:09:14.479[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010062217712402 -- 2026-06-19 14:15:49.134[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084021091461182 -- 2026-06-19 14:15:49.369[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083918571472168 -- 2026-06-19 14:15:50.262[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0076448917388916 -- 2026-06-19 14:15:50.421[李磊-753] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 753 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098919868469238 -- 2026-06-19 14:35:08.683 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019159317016602 -- 2026-06-19 14:35:08.686 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0028598308563232 -- 2026-06-19 14:35:08.689 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='YuYang' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021729469299316 -- 2026-06-19 14:35:08.692[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020279884338379 -- 2026-06-19 14:35:08.704[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0025148391723633 -- 2026-06-19 14:35:08.707[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092980861663818 -- 2026-06-19 14:35:08.878[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083200931549072 -- 2026-06-19 14:35:09.058[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014629364013672 -- 2026-06-19 14:35:09.059[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12294983863831 -- 2026-06-19 14:35:09.183[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092570781707764 -- 2026-06-19 14:35:10.843[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002100944519043 -- 2026-06-19 14:35:11.176[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '西安市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0094101428985596 -- 2026-06-19 14:35:11.272[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015071868896484 -- 2026-06-19 14:35:11.568[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012507915496826 -- 2026-06-19 16:32:21.274[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024459362030029 -- 2026-06-19 16:32:21.277[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093100070953369 -- 2026-06-19 16:32:21.605[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012120008468628 -- 2026-06-19 16:32:21.759[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014560222625732 -- 2026-06-19 16:32:21.761[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11953210830688 -- 2026-06-19 16:32:21.881[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021316051483154 -- 2026-06-19 16:32:23.593[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002079963684082 -- 2026-06-19 16:32:23.920[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '合肥市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093090534210205 -- 2026-06-19 16:32:24.043[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0095059871673584 -- 2026-06-19 16:32:24.223[秦变良-合肥办-1476] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013775110244751 -- 2026-06-19 18:05:33.947[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0022649765014648 -- 2026-06-19 18:05:33.949[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0097389221191406 -- 2026-06-19 18:05:34.215[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010764122009277 -- 2026-06-19 18:05:34.426[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019490718841553 -- 2026-06-19 18:05:34.428[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12466192245483 -- 2026-06-19 18:05:34.553[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021585941314697 -- 2026-06-19 18:05:37.130[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020489692687988 -- 2026-06-19 18:05:37.456[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '济南市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01025390625 -- 2026-06-19 18:05:37.583[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084810256958008 -- 2026-06-19 18:05:37.789[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015130996704102 -- 2026-06-19 18:05:40.940[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021501064300537 -- 2026-06-19 18:05:48.952[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select admin_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016930103302002 -- 2026-06-19 18:05:48.954[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016925096511841 -- 2026-06-19 18:05:54.819[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_area_item
SELECT oa.area_id,concat(oa.area_name,'(',ap.area_name,')') area_name 
FROM dbsys.sys_area oa 
LEFT JOIN dbsys.sys_area ap ON ap.area_id = oa.parent_id 
WHERE oa.area_id > 1 and oa.area_type in(3) AND oa.area_name like '%北京%' LIMIT 0,100
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088319778442383 -- 2026-06-19 18:05:56.053[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select admin_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018680095672607 -- 2026-06-19 18:05:56.055[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011016130447388 -- 2026-06-19 18:06:02.269[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_carrier_item
SELECT cust.customer_id AS `id`,cust.cust_disp_name AS `text`, cust.address, cust.tel,inv.pay_mode_id, cust.sys_cust_id,cust.city_id, 
 cust.inv_cust_id,inv.cust_disp_name inv_cust_name, IF(IFNULL(inv.account_name,'')<>'',inv.account_name,inv.cust_name) account_name, 
 inv.opening_bank,inv.bank_account,tce.shipper,tce.shipper_tel,tce.shipper_addr 
 FROM dbthird.v_thd_customer cust 
 left join dbthird.thd_customer_ext tce on tce.customer_id = cust.customer_id 
 left join dbthird.v_thd_customer inv on inv.customer_id = cust.inv_cust_id 
 left join dbsys.sys_customer_ext sce on sce.customer_id = cust.sys_cust_id 
 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust.cust_type,0)>=256 and ifnull(sce.is_blacklist,0) = 0  AND cust.cust_disp_name like '%威远%'  LIMIT 0,50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084061622619629 -- 2026-06-19 18:06:03.606[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_addressInfo_byCarrier
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020989894866943 -- 2026-06-19 18:06:03.768[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_addressInfo_byCarrier
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010859966278076 -- 2026-06-19 18:06:20.215[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019819736480713 -- 2026-06-19 18:06:20.217[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11322212219238 -- 2026-06-19 18:06:20.331[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 AND addr.addr_name like '%北京办%' 
 and addr.city_id = 666 
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.042661190032959 -- 2026-06-19 18:06:29.359[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_carrierAddr_item
SELECT cust.customer_id AS `id`,cust.cust_disp_name AS `text`, cust.address, cust.tel,a.address_id, 
 a.contact,a.contact_tel,a.addr_detail,cust.city_id,city.area_name city, cust.inv_cust_id,inv.cust_disp_name inv_cust_name, 
 IF(IFNULL(inv.account_name,'')<>'',inv.account_name,inv.cust_name) account_name, inv.opening_bank,inv.bank_account 
 FROM dbthird.v_thd_customer cust 
 left join dbsys.sys_area city on cust.city_id = city.area_id 
 LEFT JOIN dbthird.thd_address a ON cust.customer_id = a.customer_id and a.isenable = 1 and cust.city_id = a.`city_id` 
 left join dbthird.v_thd_customer inv on inv.customer_id = cust.inv_cust_id 
 left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id 
 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust.cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0  AND ifnull(cust.cust_type,0)&2048>0 AND cust.cust_disp_name like '%唐敏%'  LIMIT 0,50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0080127716064453 -- 2026-06-19 18:06:38.249[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016629695892334 -- 2026-06-19 18:06:38.467[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 205094 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.02293586730957 -- 2026-06-19 18:06:38.490[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144613 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019482851028442 -- 2026-06-19 18:06:38.734[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144613 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019171237945557 -- 2026-06-19 18:06:38.736[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 4381 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018789768218994 -- 2026-06-19 18:06:38.738[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 4381 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018839836120605 -- 2026-06-19 18:06:38.740[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 728 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017881393432617 -- 2026-06-19 18:06:38.742[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6678160
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083119869232178 -- 2026-06-19 18:06:38.878[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01829195022583 -- 2026-06-19 18:07:03.378[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014410018920898 -- 2026-06-19 18:07:03.379[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 205094 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034329891204834 -- 2026-06-19 18:07:03.383[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144613 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084900856018066 -- 2026-06-19 18:07:03.673[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144613 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012412071228027 -- 2026-06-19 18:07:03.674[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 4381 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012471675872803 -- 2026-06-19 18:07:03.676[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 4381 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012660026550293 -- 2026-06-19 18:07:03.677[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 728 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012459754943848 -- 2026-06-19 18:07:03.678[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6678160
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012218952178955 -- 2026-06-19 18:07:03.680[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098559856414795 -- 2026-06-19 18:07:03.817[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0096008777618408 -- 2026-06-19 18:07:08.649[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018129348754883 -- 2026-06-19 18:07:08.651[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 205094 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0042939186096191 -- 2026-06-19 18:07:08.655[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144613 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.02253794670105 -- 2026-06-19 18:07:08.915[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144613 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016858577728271 -- 2026-06-19 18:07:08.917[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 4381 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016582012176514 -- 2026-06-19 18:07:08.918[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 4381 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016748905181885 -- 2026-06-19 18:07:08.920[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 728 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001676082611084 -- 2026-06-19 18:07:08.922[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6678160
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016810894012451 -- 2026-06-19 18:07:08.924[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0077018737792969 -- 2026-06-19 18:07:09.067[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0076651573181152 -- 2026-06-19 18:07:10.312[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020085096359253 -- 2026-06-19 18:07:10.512[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086848735809326 -- 2026-06-19 18:07:12.471[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085268020629883 -- 2026-06-19 18:07:16.928[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select admin_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016698837280273 -- 2026-06-19 18:07:16.929[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_shipline_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 476 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015538930892944 -- 2026-06-19 18:07:29.218[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_carrier_item
SELECT cust.customer_id AS `id`,cust.cust_disp_name AS `text`, cust.address, cust.tel,inv.pay_mode_id, cust.sys_cust_id,cust.city_id, 
 cust.inv_cust_id,inv.cust_disp_name inv_cust_name, IF(IFNULL(inv.account_name,'')<>'',inv.account_name,inv.cust_name) account_name, 
 inv.opening_bank,inv.bank_account,tce.shipper,tce.shipper_tel,tce.shipper_addr 
 FROM dbthird.v_thd_customer cust 
 left join dbthird.thd_customer_ext tce on tce.customer_id = cust.customer_id 
 left join dbthird.v_thd_customer inv on inv.customer_id = cust.inv_cust_id 
 left join dbsys.sys_customer_ext sce on sce.customer_id = cust.sys_cust_id 
 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust.cust_type,0)>=256 and ifnull(sce.is_blacklist,0) = 0  AND cust.cust_disp_name like '%忠诺%'  LIMIT 0,50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010351896286011 -- 2026-06-19 18:07:30.565[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_addressInfo_byCarrier
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081448554992676 -- 2026-06-19 18:07:30.718[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_addressInfo_byCarrier
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.054762840270996 -- 2026-06-19 18:07:53.218[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_carrierAddr_item
SELECT cust.customer_id AS `id`,cust.cust_disp_name AS `text`, cust.address, cust.tel,a.address_id, 
 a.contact,a.contact_tel,a.addr_detail,cust.city_id,city.area_name city, cust.inv_cust_id,inv.cust_disp_name inv_cust_name, 
 IF(IFNULL(inv.account_name,'')<>'',inv.account_name,inv.cust_name) account_name, inv.opening_bank,inv.bank_account 
 FROM dbthird.v_thd_customer cust 
 left join dbsys.sys_area city on cust.city_id = city.area_id 
 LEFT JOIN dbthird.thd_address a ON cust.customer_id = a.customer_id and a.isenable = 1 and cust.city_id = a.`city_id` 
 left join dbthird.v_thd_customer inv on inv.customer_id = cust.inv_cust_id 
 left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id 
 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust.cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0  AND ifnull(cust.cust_type,0)&2048>0 AND cust.cust_disp_name like '%梁思聪%'  LIMIT 0,50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0077939033508301 -- 2026-06-19 18:08:16.156[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016288757324219 -- 2026-06-19 18:08:16.465[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 347344 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0033740997314453 -- 2026-06-19 18:08:16.469[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144614 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001492977142334 -- 2026-06-19 18:08:16.582[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010363101959229 -- 2026-06-19 18:08:16.739[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144614 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017199516296387 -- 2026-06-19 18:08:16.741[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 732 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017099380493164 -- 2026-06-19 18:08:16.743[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 7756 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016708374023438 -- 2026-06-19 18:08:16.745[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 732 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016078948974609 -- 2026-06-19 18:08:16.747[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6678161
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016325950622559 -- 2026-06-19 18:08:16.879[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090670585632324 -- 2026-06-19 18:08:36.330[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001708984375 -- 2026-06-19 18:08:36.332[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 347344 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00400710105896 -- 2026-06-19 18:08:36.336[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144614 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017619132995605 -- 2026-06-19 18:08:36.458[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.009458065032959 -- 2026-06-19 18:08:36.614[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144614 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001413106918335 -- 2026-06-19 18:08:36.615[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 732 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0013930797576904 -- 2026-06-19 18:08:36.617[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 7756 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0013959407806396 -- 2026-06-19 18:08:36.618[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 732 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0013909339904785 -- 2026-06-19 18:08:36.620[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6678161
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001384973526001 -- 2026-06-19 18:08:36.621[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012428998947144 -- 2026-06-19 18:08:36.743[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081157684326172 -- 2026-06-19 18:08:46.229[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015068054199219 -- 2026-06-19 18:08:46.230[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 347344 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0036640167236328 -- 2026-06-19 18:08:46.234[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select * from dbthird.v_thd_manifest where manifest_id = 1144614 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015640258789062 -- 2026-06-19 18:08:46.354[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_manifest_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01799201965332 -- 2026-06-19 18:08:46.513[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select m.manifest_id,m.manifest_no,m.carrier_no,m.carrier_id,m.inv_cust_id,m.network_id,m.dpt_city_id m_dpt_city_id, 
m.dest_city_id m_dest_city_id,m.trans_mode_id m_trans_mode_id,m.busi_mode_id m_busi_mode_id,m.owner_id,carr.cust_disp_name carrier, 
m.consignee,m.consignee_tel,m.consignee_addr,dpt.area_name m_dpt_city,dest.area_name m_dest_city,m.pay_mode_id, 
m_f.freight_fee m_freight_fee,m_f.delivery_fee m_delivery_fee,m.load_addr_id,m.trans_notes,m.unload_addr_id, 
addr.addr_name load_addr,m_f.opening_bank,m_f.bank_account,m_f.account_name,m.other_fee1 m_other_fee1, 
m.other_fee1_name m_other_fee1_name,m.acct_id,m.other_fee2 m_other_fee2,m.other_fee2_name m_other_fee2_name, 
m.other_fee3 m_other_fee3,m.other_fee3_name m_other_fee3_name,network.cust_disp_name network,m_e.shipreview_status_id, 
m_f.review_status_id,carr.inv_cust_id carrier_invcust_id, network.inv_cust_id network_invcust_id,m.createdby_id m_createdby_id,m.has_tempFare 
from dbthird.v_thd_manifest m 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = m.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = m.network_id 
LEFT JOIN dbthird.thd_manifest_fee m_f ON m_f.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_manifest_ext m_e ON m_e.manifest_id = m.manifest_id 
LEFT JOIN dbthird.thd_address addr ON addr.address_id = m.load_addr_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = m.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = m.dest_city_id 
where m.manifest_id = 1144614 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016880035400391 -- 2026-06-19 18:08:46.515[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name inv_cust_name from dbthird.v_thd_customer where customer_id = 732 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016880035400391 -- 2026-06-19 18:08:46.517[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name carrier_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) carrier_account_name, bank_account carrier_bank_account,opening_bank carrier_opening_bank 
from dbthird.v_thd_customer where customer_id = 7756 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016920566558838 -- 2026-06-19 18:08:46.518[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select cust_disp_name network_invcust_name,IF(IFNULL(account_name,'')<>'',account_name,cust_name) network_account_name, bank_account network_bank_account,opening_bank network_opening_bank 
from dbthird.v_thd_customer where customer_id = 732 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016689300537109 -- 2026-06-19 18:08:46.520[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6678161
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016839504241943 -- 2026-06-19 18:08:46.522[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_manifest_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0170738697052 -- 2026-06-19 18:08:46.652[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_manifest_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092759132385254 -- 2026-06-19 18:08:47.469[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.012423992156982 -- 2026-06-19 18:08:52.047[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_customer_item
SELECT cust_disp_name,customer_id,trk_convert_weight,air_convert_weight FROM dbthird.v_thd_customer 
WHERE cust_type & 1 and isenable = 1 and acct_id = 15 
 limit 20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020570993423462 -- 2026-06-19 18:08:52.186[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.022994995117188 -- 2026-06-19 18:08:52.391[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086719989776611 -- 2026-06-19 18:13:52.033[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021100044250488 -- 2026-06-19 18:13:52.036[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?customer=%E6%B5%AA%E6%BD%AE&appid=ww5262fb147810c303&agentid=1000016
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081479549407959 -- 2026-06-19 18:13:52.312[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010759115219116 -- 2026-06-19 18:13:52.481[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001924991607666 -- 2026-06-19 18:13:52.484[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11962485313416 -- 2026-06-19 18:13:52.603[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081541538238525 -- 2026-06-19 18:13:54.102[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081250667572021 -- 2026-06-19 18:13:55.124[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019419193267822 -- 2026-06-19 18:13:55.463[彭宗平-508] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '济南市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092101097106934 -- 2026-06-19 18:13:55.578[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0078611373901367 -- 2026-06-19 18:13:55.758[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018913984298706 -- 2026-06-19 18:13:58.783[彭宗平-508] -- /buz/third/index.php/thirdoprt/get_customer_item
SELECT cust_disp_name,customer_id,trk_convert_weight,air_convert_weight FROM dbthird.v_thd_customer 
WHERE cust_type & 1 and isenable = 1 and acct_id = 15 
 limit 20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0079910755157471 -- 2026-06-19 18:13:58.937[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021844148635864 -- 2026-06-19 18:13:59.128[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010107040405273 -- 2026-06-19 18:14:03.174[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0087940692901611 -- 2026-06-19 18:15:00.944[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015828609466553 -- 2026-06-19 18:15:00.946[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6670574
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014488697052002 -- 2026-06-19 18:15:00.948[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0096747875213623 -- 2026-06-19 18:15:01.080[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013506174087524 -- 2026-06-19 18:15:34.331[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018608570098877 -- 2026-06-19 18:15:34.333[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select mix_truckwork_id from dbthird.thd_truckwork_ext where truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0039670467376709 -- 2026-06-19 18:15:34.337[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select * from dbthird.thd_truckwork tw 
 left join dbthird.thd_truckwork_fee tw_f on tw_f.truckwork_id = tw.truckwork_id 
 where tw.truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017838478088379 -- 2026-06-19 18:15:34.339[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 243553 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017340183258057 -- 2026-06-19 18:15:34.341[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 363412 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017399787902832 -- 2026-06-19 18:15:34.884[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017311573028564 -- 2026-06-19 18:15:34.922[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select mix_truckwork_id from dbthird.thd_truckwork_ext where truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085020065307617 -- 2026-06-19 18:15:35.046[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0013599395751953 -- 2026-06-19 18:15:35.048[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6670574
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083580017089844 -- 2026-06-19 18:15:35.179[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013414859771729 -- 2026-06-19 18:15:52.391[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.001244068145752 -- 2026-06-19 18:15:52.393[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select mix_truckwork_id from dbthird.thd_truckwork_ext where truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002673864364624 -- 2026-06-19 18:15:52.396[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select * from dbthird.thd_truckwork tw 
 left join dbthird.thd_truckwork_fee tw_f on tw_f.truckwork_id = tw.truckwork_id 
 where tw.truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012381076812744 -- 2026-06-19 18:15:52.397[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 243553 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012111663818359 -- 2026-06-19 18:15:52.398[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select addr_name,contact,contact_tel,addr_detail from dbthird.thd_address where address_id = 363412 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012829303741455 -- 2026-06-19 18:15:52.541[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0012831687927246 -- 2026-06-19 18:15:52.577[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=do_truckwork_ship_arng
select mix_truckwork_id from dbthird.thd_truckwork_ext where truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010039091110229 -- 2026-06-19 18:15:52.675[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 308849 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016398429870605 -- 2026-06-19 18:15:52.677[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6670574
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016350746154785 -- 2026-06-19 18:15:52.679[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0080080032348633 -- 2026-06-19 18:15:52.803[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0081069469451904 -- 2026-06-19 18:15:54.291[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.020634174346924 -- 2026-06-19 18:15:54.479[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098309516906738 -- 2026-06-19 18:15:58.409[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088980197906494 -- 2026-06-19 18:16:03.447[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 308850 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016489028930664 -- 2026-06-19 18:16:03.448[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6670580
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014948844909668 -- 2026-06-19 18:16:03.450[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0079400539398193 -- 2026-06-19 18:16:03.567[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093028545379639 -- 2026-06-19 18:18:04.794[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0084497928619385 -- 2026-06-19 18:18:04.986[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021533012390137 -- 2026-06-19 18:18:06.868[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0092229843139648 -- 2026-06-19 18:18:10.656[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013114929199219 -- 2026-06-19 18:18:11.460[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011013984680176 -- 2026-06-19 18:18:23.529[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1901534
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010596990585327 -- 2026-06-19 18:19:12.030[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1901506
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010149955749512 -- 2026-06-19 18:22:10.206[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.009119987487793 -- 2026-06-19 18:22:11.813[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088951587677002 -- 2026-06-19 18:22:17.356[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091061592102051 -- 2026-06-19 18:22:17.546[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011213064193726 -- 2026-06-19 18:22:19.770[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010329961776733 -- 2026-06-19 18:22:23.317[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903788
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01435399055481 -- 2026-06-19 18:22:50.235[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903786
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.016991138458252 -- 2026-06-19 18:23:17.154[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903780
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0094301700592041 -- 2026-06-19 18:23:31.347[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903775
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0093598365783691 -- 2026-06-19 18:23:35.332[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903775
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088880062103271 -- 2026-06-19 18:23:47.983[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903772
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015310049057007 -- 2026-06-19 18:25:01.527[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderPrd_item
select * from  dbthird.thd_order_prd where order_id = 1903769
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0099761486053467 -- 2026-06-19 18:25:14.171[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 308850 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018379688262939 -- 2026-06-19 18:25:14.173[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6670580
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017480850219727 -- 2026-06-19 18:25:14.175[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014166831970215 -- 2026-06-19 18:25:14.305[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.018375873565674 -- 2026-06-19 18:25:25.264[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.008915901184082 -- 2026-06-19 18:25:25.459[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0078351497650146 -- 2026-06-19 18:25:27.058[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021723031997681 -- 2026-06-19 18:25:29.952[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select t.truckwork_id,t.owner_id,t.truckwork_no,t.carrier_no,t.carrier_id,t.inv_cust_id,t.dest_city_id t_dest_city_id,carr.cust_disp_name carrier, 
t.unload_addr_id,t.unload_contact,t.unload_tel,t.unload_addr,t.unload_addr_detail,dpt.area_name t_dpt_city,dest.area_name t_dest_city,twe.inspur_isPushLocation, 
t.pay_mode_id,t.freight_fee t_freight_fee,t.truck_no,t.trailer_no,t.driver_id,t.driver,t.driver_tel,gd.gps_device_id,gd.gps_device_name,twf.opening_bank,twf.bank_account,  
t.load_addr_id,t.load_addr,twf.account_name,t.ship_time,t.arrival_time,t.truckwork_type_id,t.pickup_type_id,t.viechle_type_id,t.driver_type_id,t.dpt_city_id t_dpt_city_id,  
t.network_id,network.cust_disp_name network,other_fee1_name t_other_fee1_name,other_fee1 t_other_fee1,other_fee2_name t_other_fee2_name,other_fee2 t_other_fee2, 
other_fee3_name t_other_fee3_name,other_fee3 t_other_fee3,t.trans_notes,t.acct_id,twf.otherfee1_networkPay_flag,twf.otherfee2_networkPay_flag,  
twf.otherfee3_networkPay_flag,t.review_status_id,t.shipreview_status_id,twe.mix_truckwork_id,t.createdby_id t_createdby_id, twe.gps_method_id, 
t.other_fee1_srvc_id,t.other_fee2_srvc_id,t.other_fee3_srvc_id 
from dbthird.thd_truckwork t 
LEFT JOIN dbthird.v_thd_truckwork_fee twf ON twf.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.thd_truckwork_ext twe ON twe.truckwork_id = t.truckwork_id 
LEFT JOIN dbthird.v_thd_customer carr ON carr.customer_id = t.carrier_id 
LEFT JOIN dbthird.v_thd_customer network ON network.customer_id = t.network_id 
LEFT JOIN dbsys.sys_area dpt ON dpt.area_id = t.dpt_city_id 
LEFT JOIN dbsys.sys_area dest ON dest.area_id = t.dest_city_id 
LEFT JOIN dbthird.thd_gps_device gd ON gd.gps_device_id = twe.gps_device_id 
where t.truckwork_id = 309061 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00164794921875 -- 2026-06-19 18:25:29.954[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6675557
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015151500701904 -- 2026-06-19 18:25:29.956[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_truckwork_info
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0088140964508057 -- 2026-06-19 18:25:30.072[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_truckwork_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0091421604156494 -- 2026-06-19 18:25:36.658[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0094120502471924 -- 2026-06-19 18:25:36.818[彭宗平-508] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 508 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.014340877532959 -- 2026-06-19 19:43:40.308 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0017659664154053 -- 2026-06-19 19:43:40.312 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0023150444030762 -- 2026-06-19 19:43:40.314 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='QinHu' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020630359649658 -- 2026-06-19 19:43:40.316[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018651485443115 -- 2026-06-19 19:43:40.329[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024168491363525 -- 2026-06-19 19:43:40.332[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098309516906738 -- 2026-06-19 19:43:40.721[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010290145874023 -- 2026-06-19 19:43:40.883[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018661022186279 -- 2026-06-19 19:43:40.885[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12058401107788 -- 2026-06-19 19:43:41.006[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021359920501709 -- 2026-06-19 19:43:41.327[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0023031234741211 -- 2026-06-19 19:43:41.709[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '南京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0087780952453613 -- 2026-06-19 19:43:41.830[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.011737823486328 -- 2026-06-19 19:43:41.986[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0096750259399414 -- 2026-06-19 19:44:39.753[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0024509429931641 -- 2026-06-19 19:44:39.756[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.019911050796509 -- 2026-06-19 19:44:39.965[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0086119174957275 -- 2026-06-19 19:44:40.115[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0015749931335449 -- 2026-06-19 19:44:40.116[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12044405937195 -- 2026-06-19 19:44:40.237[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0083310604095459 -- 2026-06-19 19:44:40.520[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019419193267822 -- 2026-06-19 19:44:40.845[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '南京市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.01242995262146 -- 2026-06-19 19:44:41.031[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0099899768829346 -- 2026-06-19 19:44:41.173[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010122060775757 -- 2026-06-19 19:44:42.348[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 2803 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090889930725098 -- 2026-06-19 19:45:19.230[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904351 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.015265941619873 -- 2026-06-19 19:45:40.146[秦湖-南京办-2803] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_orderSize_item
select * from  dbthird.thd_order_size where order_id = 1904348 order by order_size_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0085558891296387 -- 2026-06-19 19:57:51.334[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.00205397605896 -- 2026-06-19 19:57:51.336[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090060234069824 -- 2026-06-19 19:57:51.622[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.024019956588745 -- 2026-06-19 19:57:51.834[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019481182098389 -- 2026-06-19 19:57:51.836[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.12007904052734 -- 2026-06-19 19:57:51.956[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017657995223999 -- 2026-06-19 19:57:53.682[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018680095672607 -- 2026-06-19 19:57:54.021[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '西安市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.017719030380249 -- 2026-06-19 19:57:54.137[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010016918182373 -- 2026-06-19 19:57:54.324[于洋-西安办-1475] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 1475 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0098679065704346 -- 2026-06-19 21:43:09.391 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018618106842041 -- 2026-06-19 21:43:09.395 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
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.0024540424346924 -- 2026-06-19 21:43:09.397 -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select b.cont_id, c.cont_name, c.acct_id, c.cont_password 
from dbwechat.wechat_describe b 
left join dbsys.sys_contact c on b.cont_id = c.cont_id 
where openid='WuWenChao' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0021300315856934 -- 2026-06-19 21:43:09.400[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019619464874268 -- 2026-06-19 21:43:09.413[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select jsapi_ticket from dbwechat.wechat_token wt 
left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id 
where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002471923828125 -- 2026-06-19 21:43:09.415[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?appid=ww5262fb147810c303&agentid=1000009
select srvcitem_id,srvcitem_name,upload_file_type_id from dbthird.thd_srvcitem 
where isenable = 1 and acct_id = 15 
and fare_type_id = 9
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013787031173706 -- 2026-06-19 21:43:09.712[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.010594129562378 -- 2026-06-19 21:43:09.883[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
select tag, max(para_value) para_value from dbsys.v_sys_acct_para 
where acct_id=15 
group by tag
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0019462108612061 -- 2026-06-19 21:43:09.885[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
select acct_level,acct_parent_id from dbsys.sys_acct where acct_id = 15 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.11941504478455 -- 2026-06-19 21:43:10.005[吴文超-755] -- /buz/third/index.php/thirdoprt/get_address_item
SELECT CONCAT(addr.addr_name,'-',city.area_name) AS consignee_contact,addr.addr_name,addr.city_id,city.area_name,addr.customer_id,addr.district_id, 
addr.address_id AS consignee_addr_id,addr.contact,addr.addr_detail,addr.contact_tel,c.cust_disp_name customer,addr.addr_type_id,addr.district_id, district.area_name district_name, 
(CASE WHEN (c.cust_type & 1)>0 THEN 1  
 WHEN (c.cust_type & 2304)>0   THEN 2 END ) dock_type_id,addr.is_dockAddr_internal,c.trk_convert_weight,c.air_convert_weight 
FROM dbthird.thd_address addr 
left join dbsys.sys_area city on addr.city_id = city.area_id 
left join dbsys.sys_area district on addr.district_id = district.area_id 
 left join dbthird.v_thd_customer c on addr.customer_id = c.customer_id 
 WHERE addr.isenable=1 
 and addr.addr_type_id = 2 
 and addr.is_dockAddr_internal = 0 
 and c.cust_type & 1 >0
 and addr.acct_id in (15)  GROUP BY addr.addr_name,addr.city_id ORDER BY addr.address_id limit 50
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.013978958129883 -- 2026-06-19 21:43:11.796[吴文超-755] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0018870830535889 -- 2026-06-19 21:43:12.148[吴文超-755] -- /buz/third/index.php/thirdoprt/public_function?event=get_city_byLocatioon
SELECT c.area_id city_id,p.area_id province_id,count(1) cnt FROM dbsys.sys_area c 
 LEFT JOIN dbsys.sys_area p ON p.area_id = c.parent_id 
 WHERE c.area_name = '武汉市' and c.area_type = 3 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090441703796387 -- 2026-06-19 21:43:12.299[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=get_arngleft_item
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.007544994354248 -- 2026-06-19 21:43:12.486[吴文超-755] -- /buz/third/index.php/thirdoprt/trans_arng_desk_new?event=query_order
select acct_id, cont_id, cont_edikey from dbsys.sys_contact 
where cont_id = 755 and cont_isenable=1 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------