Time: 0.022875070571899 -- 25-11-27 01:04:46[-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.022724151611328 -- 25-11-27 08:50:40[-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.017508029937744 -- 25-11-27 16:59:35 -- /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.018412828445435 -- 25-11-27 17:00:55[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 917 and acct_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006195068359375 -- 25-11-27 17:00:55[黄奕洪-917] -- /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(ef_tsl.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 WHERE o.acct_id=2 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019171953201294 -- 25-11-27 17:01:02[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 917 and acct_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059010982513428 -- 25-11-27 17:01:02[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query 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(ef_tsl.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 WHERE o.acct_id=2 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' AND o.order_date <= '2025/11/27 23:59:59 ' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020411968231201 -- 25-11-27 17:01:03[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 917 and acct_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064959526062012 -- 25-11-27 17:01:03[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query 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(ef_tsl.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 WHERE o.acct_id=2 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' AND o.order_date <= '2025/11/27 23:59:59 ' AND ef_tsl.extrafareApply_id > 1 ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0228590965271 -- 25-11-27 17:01:04[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 917 and acct_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058960914611816 -- 25-11-27 17:01:04[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query 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(ef_tsl.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 WHERE o.acct_id=2 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' AND o.order_date <= '2025/11/27 23:59:59 ' AND ifnull(ef_tsl.extrafareApply_id,1) <= 1 ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016056060791016 -- 25-11-27 17:01:04[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 917 and acct_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031888484954834 -- 25-11-27 17:01:04[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query 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(ef_tsl.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 WHERE o.acct_id=2 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' AND o.order_date <= '2025/11/27 23:59:59 ' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018829107284546 -- 25-11-27 17:38:43[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 917 and acct_id = 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050079822540283 -- 25-11-27 17:38:43[黄奕洪-917] -- /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(ef_tsl.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 WHERE o.acct_id=2 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018434047698975 -- 25-11-27 17:38:48 -- /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.0037178993225098 -- 25-11-27 17:38:48 -- /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.0042088031768799 -- 25-11-27 17:38:48 -- /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.020555019378662 -- 25-11-27 17:38:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070018768310547 -- 25-11-27 17:38:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021904945373535 -- 25-11-27 17:39:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051660537719727 -- 25-11-27 17:39:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043540000915527 -- 25-11-27 17:39:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060939788818359 -- 25-11-27 17:39:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044229030609131 -- 25-11-27 17:39:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042891502380371 -- 25-11-27 17:39:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023865938186646 -- 25-11-27 17:39:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68249 and order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020445108413696 -- 25-11-27 17:39:16[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049240589141846 -- 25-11-27 17:39:16[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024394035339355 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050508975982666 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00370192527771 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005979061126709 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038180351257324 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003615140914917 -- 25-11-27 17:39:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022708892822266 -- 25-11-27 17:40:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060360431671143 -- 25-11-27 17:40:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027050018310547 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060939788818359 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047299861907959 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006598949432373 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049750804901123 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047171115875244 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047380924224854 -- 25-11-27 17:40:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023744106292725 -- 25-11-27 17:40:33[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081298351287842 -- 25-11-27 17:40:33[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03276801109314 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061318874359131 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046141147613525 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063419342041016 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047290325164795 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045809745788574 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045809745788574 -- 25-11-27 17:40:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02135705947876 -- 25-11-27 17:41:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071439743041992 -- 25-11-27 17:41:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016304969787598 -- 25-11-27 17:41:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042929649353027 -- 25-11-27 17:41:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022397041320801 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054588317871094 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044808387756348 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053410530090332 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045340061187744 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043799877166748 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043859481811523 -- 25-11-27 17:41:21[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020429134368896 -- 25-11-27 17:41:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048189163208008 -- 25-11-27 17:41:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033277034759521 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060889720916748 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048270225524902 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070409774780273 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048861503601074 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048160552978516 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047411918640137 -- 25-11-27 17:41:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019853115081787 -- 25-11-27 17:41:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052990913391113 -- 25-11-27 17:41:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016818046569824 -- 25-11-27 17:44:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006911039352417 -- 25-11-27 17:44:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 and e.status_id <> 5 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023752927780151 -- 25-11-27 17:44:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047821998596191 -- 25-11-27 17:44:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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(ef_tsl.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 WHERE o.acct_id=13 and o.buzSystem_id = 15 and e.status_id <> 5 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02030611038208 -- 25-11-27 17:46:04[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073850154876709 -- 25-11-27 17:46:04[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021743059158325 -- 25-11-27 17:46:07[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069410800933838 -- 25-11-27 17:46:07[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' AND o.order_date <= '2025/11/27 23:59:59 ' AND e.extrafareApply_id > 1 ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022980928421021 -- 25-11-27 17:46:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065281391143799 -- 25-11-27 17:46:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' AND o.order_date <= '2025/11/27 23:59:59 ' AND ifnull(e.extrafareApply_id,1) <= 1 ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022096872329712 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select extrafareApply_id from dboa.oa_extrafareapply_tslorder where order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052809715270996 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004410982131958 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052628517150879 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68249 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044410228729248 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637613 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042610168457031 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042550563812256 -- 25-11-27 17:46:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02056097984314 -- 25-11-27 17:50:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073580741882324 -- 25-11-27 17:50:28[黄奕洪-2485] -- /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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027797937393188 -- 25-11-27 17:50:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004572868347168 -- 25-11-27 17:50:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049479007720947 -- 25-11-27 17:50:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044920444488525 -- 25-11-27 17:50:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070781707763672 -- 25-11-27 17:50:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029927968978882 -- 25-11-27 17:50:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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.023579120635986 -- 25-11-27 17:52:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004594087600708 -- 25-11-27 17:52:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050899982452393 -- 25-11-27 17:52:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069830417633057 -- 25-11-27 17:52:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049748420715332 -- 25-11-27 17:52:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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.02220892906189 -- 25-11-27 17:52:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077199935913086 -- 25-11-27 17:52:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022422075271606 -- 25-11-27 17:52:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043389797210693 -- 25-11-27 17:52:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047111511230469 -- 25-11-27 17:52:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067968368530273 -- 25-11-27 17:52:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049159526824951 -- 25-11-27 17:52:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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.033087968826294 -- 25-11-27 17:52:26[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68250 and order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049889087677002 -- 25-11-27 17:52:26[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018532991409302 -- 25-11-27 17:52:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056078433990479 -- 25-11-27 17:52:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 5000.00 where extrafareApply_id = 68250 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018610954284668 -- 25-11-27 17:52:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68250 and order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031284093856812 -- 25-11-27 17:52:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069079399108887 -- 25-11-27 17:52:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019870042800903 -- 25-11-27 17:59:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066349506378174 -- 25-11-27 17:59:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016418933868408 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005012035369873 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00319504737854 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054430961608887 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031261444091797 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031230449676514 -- 25-11-27 17:59:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027108907699585 -- 25-11-27 18:01:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047171115875244 -- 25-11-27 18:01:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031418800354004 -- 25-11-27 18:01:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055868625640869 -- 25-11-27 18:01:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032730102539062 -- 25-11-27 18:01:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031430721282959 -- 25-11-27 18:01:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019206047058105 -- 25-11-27 18:01:05[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060100555419922 -- 25-11-27 18:01:05[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018049955368042 -- 25-11-27 18:01:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035669803619385 -- 25-11-27 18:01:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035099983215332 -- 25-11-27 18:01:07[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042629241943359 -- 25-11-27 18:01:07[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035331249237061 -- 25-11-27 18:01:07[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035359859466553 -- 25-11-27 18:01:07[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025638103485107 -- 25-11-27 18:01:09[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68250 and order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019483804702759 -- 25-11-27 18:01:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065360069274902 -- 25-11-27 18:01:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021113872528076 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044879913330078 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034589767456055 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00553297996521 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034410953521729 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034248828887939 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 25-11-27 18:01:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01743483543396 -- 25-11-27 18:01:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049901008605957 -- 25-11-27 18:01:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033450126647949 -- 25-11-27 18:01:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043418407440186 -- 25-11-27 18:01:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035030841827393 -- 25-11-27 18:01:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033369064331055 -- 25-11-27 18:01:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025145053863525 -- 25-11-27 18:01:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065619945526123 -- 25-11-27 18:01:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 5500.00 where extrafareApply_id = 68250 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019325971603394 -- 25-11-27 18:01:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68250 and order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016235828399658 -- 25-11-27 18:01:38[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057339668273926 -- 25-11-27 18:01:38[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019435882568359 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045719146728516 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038089752197266 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047900676727295 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039482116699219 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037980079650879 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038070678710938 -- 25-11-27 18:01:40[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019547939300537 -- 25-11-27 18:01:45[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038959980010986 -- 25-11-27 18:01:45[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01788592338562 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035591125488281 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034759044647217 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045897960662842 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035049915313721 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034630298614502 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034849643707275 -- 25-11-27 18:01:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016144037246704 -- 25-11-27 18:03:00[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005375862121582 -- 25-11-27 18:03:00[审批_test-433] -- /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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028700113296509 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 614 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053079128265381 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041911602020264 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005108118057251 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68250 and o.buzSystem_id = 15 and o.order_id = 614 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042321681976318 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 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 = 5637723 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040819644927979 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040860176086426 -- 25-11-27 18:03:02[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=614 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021317958831787 -- 25-11-27 18:03:06[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042707920074463 -- 25-11-27 18:03:06[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017596960067749 -- 25-11-27 18:03:45[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054121017456055 -- 25-11-27 18:03:45[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027740001678467 -- 25-11-27 18:03:46[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033020973205566 -- 25-11-27 18:03:46[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032930374145508 -- 25-11-27 18:03:46[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021695852279663 -- 25-11-27 18:04:18[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056948661804199 -- 25-11-27 18:04:18[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022829055786133 -- 25-11-27 18:04:23[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051009654998779 -- 25-11-27 18:04:23[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016728162765503 -- 25-11-27 18:04:27[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003352165222168 -- 25-11-27 18:04:27[审批_test-433] -- /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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021318197250366 -- 25-11-27 18:04:36 -- /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.0042238235473633 -- 25-11-27 18:04:36 -- /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.0051147937774658 -- 25-11-27 18:04:36 -- /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.030277013778687 -- 25-11-27 18:04:46[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select driver_id from dbsys.sys_driver where cont_id = 433 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006929874420166 -- 25-11-27 18:04:46[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018450975418091 -- 25-11-27 18:04:52[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037009716033936 -- 25-11-27 18:04:52[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037071704864502 -- 25-11-27 18:04:52[审批_test-433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016008138656616 -- 25-11-27 18:05:01 -- /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.0031890869140625 -- 25-11-27 18:05:01 -- /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.0040469169616699 -- 25-11-27 18:05:01 -- /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.023670196533203 -- 25-11-27 18:05:12[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073761940002441 -- 25-11-27 18:05:12[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023612976074219 -- 25-11-27 18:05:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039131641387939 -- 25-11-27 18:05:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042970180511475 -- 25-11-27 18:05:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063619613647461 -- 25-11-27 18:05:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046920776367188 -- 25-11-27 18:05:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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.016165971755981 -- 25-11-27 18:05:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68255 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031428337097168 -- 25-11-27 18:05:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019640922546387 -- 25-11-27 18:05:29[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061409473419189 -- 25-11-27 18:05:29[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 61144.00 where extrafareApply_id = 68255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019577980041504 -- 25-11-27 18:05:32[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68255 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025012016296387 -- 25-11-27 18:05:35[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055019855499268 -- 25-11-27 18:05:35[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019150972366333 -- 25-11-27 18:06:34 -- /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.0037679672241211 -- 25-11-27 18:06:34 -- /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.0042338371276855 -- 25-11-27 18:06:34 -- /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.027461767196655 -- 25-11-27 18:06:45[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0068650245666504 -- 25-11-27 18:06:45[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016860008239746 -- 25-11-27 18:06:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004025936126709 -- 25-11-27 18:06:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033168792724609 -- 25-11-27 18:06:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042388439178467 -- 25-11-27 18:06:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68255 and o.buzSystem_id = 15 and o.order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033659934997559 -- 25-11-27 18:06:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032408237457275 -- 25-11-27 18:06:49[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023910045623779 -- 25-11-27 18:06:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68255 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023576974868774 -- 25-11-27 18:06:58[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68255 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027904033660889 -- 25-11-27 18:07:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006458044052124 -- 25-11-27 18:07:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list 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=13 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018857002258301 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003997802734375 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036349296569824 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042428970336914 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68255 and o.buzSystem_id = 15 and o.order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037610530853271 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036208629608154 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036320686340332 -- 25-11-27 18:07:10[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024182081222534 -- 25-11-27 18:07:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 641 and e.status_id <> 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050909519195557 -- 25-11-27 18:07:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 68255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046989917755127 -- 25-11-27 18:07:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053408145904541 -- 25-11-27 18:07:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id 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_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 68255 and o.buzSystem_id = 15 and o.order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046799182891846 -- 25-11-27 18:07:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 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 = 5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047059059143066 -- 25-11-27 18:07:13[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019208908081055 -- 25-11-27 23:07:31[-2266] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2266 and acct_id = 46 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073089599609375 -- 25-11-27 23:07:31[-2266] -- /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=46 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023674964904785 -- 25-11-27 23:11:12[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/pickup_load_list?appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=2 AND w.work_type_id = 1 AND w.status_id < 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019217967987061 -- 25-11-27 23:12:30[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/pickup_load_list?is_unloadpage=1&appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=2 AND w.work_type_id = 1 AND w.status_id = 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017123222351074 -- 25-11-27 23:12:32[黄奕洪-917] -- /buz/tsl/index.php/tsloprt/pickup_load_list?appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=2 AND w.work_type_id = 1 AND w.status_id < 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019352912902832 -- 25-11-27 23:45:09[-2266] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2266 and acct_id = 46 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076529979705811 -- 25-11-27 23:45:09[-2266] -- /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=46 and o.buzSystem_id = 15 AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/20' ORDER BY o.order_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.037450790405273 -- 25-11-27 23:45:19[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_list?appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=46 AND w.work_type_id = 1 AND w.status_id < 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021124839782715 -- 25-11-27 23:45:22[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_list?is_unloadpage=1&appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=46 AND w.work_type_id = 1 AND w.status_id = 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025484085083008 -- 25-11-27 23:45:23[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_list?appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=46 AND w.work_type_id = 1 AND w.status_id < 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028632879257202 -- 25-11-27 23:55:07[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_list?appid=ww5262fb147810c303&agentid=1000020 SELECT w.*,dest.area_name dest_city,c.cust_name carrier,w.work_id recid, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon_dt,CB.cont_name createdby,load_a.addr_name load_addr FROM dbtsl.tsl_work w LEFT JOIN dbsys.sys_area dest ON w.dest_city_id = dest.area_id LEFT JOIN dbsys.v_sys_customer c ON c.customer_id = w.carrier_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = w.createdby_id LEFT JOIN dbtsl.tsl_address load_a ON load_a.address_id = w.dpt_addr_id WHERE w.acct_id=46 AND w.work_type_id = 1 AND w.status_id < 2 ORDER BY w.work_id DESC LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------