Time: 0.024557113647461 -- 25-11-30 00:13:40[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_edit?event=finish_truckwork_arvLoad select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019376039505005 -- 25-11-30 09:56:22[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_edit?event=truck_arvUnLoad select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017228126525879 -- 25-11-30 16:08:29 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034630298614502 -- 25-11-30 16:08:29 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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.0039448738098145 -- 25-11-30 16:08:29 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='encho' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 25-11-30 16:08:29[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004410982131958 -- 25-11-30 16:08:29[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094349384307861 -- 25-11-30 16:08:29[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,ifnull(e.extrafareApply_id,1) as extrafareApply_id, ifnull(e.extrafareApply_no,'') as extrafareApply_no,e.status_id extrafareapply_status_id FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id and e.status_id <> 5 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/23' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022809028625488 -- 25-11-30 16:08:31[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select e.extrafareApply_id from dboa.oa_extrafareapply_tslorder e_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = e_tsl.extrafareApply_id where order_id = 645 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042169094085693 -- 25-11-30 16:08:31[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049219131469727 -- 25-11-30 16:08:31[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006950855255127 -- 25-11-30 16:08:31[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 645 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045421123504639 -- 25-11-30 16:08:31[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017362117767334 -- 25-11-30 16:08:34[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034279823303223 -- 25-11-30 16:08:34[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,ifnull(e.extrafareApply_id,1) as extrafareApply_id, ifnull(e.extrafareApply_no,'') as extrafareApply_no,e.status_id extrafareapply_status_id FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id and e.status_id <> 5 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/23' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016905069351196 -- 25-11-30 16:08:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select e.extrafareApply_id from dboa.oa_extrafareapply_tslorder e_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = e_tsl.extrafareApply_id where order_id = 645 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032720565795898 -- 25-11-30 16:08:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033230781555176 -- 25-11-30 16:08:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006058931350708 -- 25-11-30 16:08:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 645 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033271312713623 -- 25-11-30 16:08:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=645 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------