Time: 0.019086837768555 -- 25-12-01 08:55:14[-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.018780946731567 -- 25-12-01 10:44:29 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01669979095459 -- 25-12-01 10:45:12 -- /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.0033178329467773 -- 25-12-01 10:45:12 -- /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.0038108825683594 -- 25-12-01 10:45:12 -- /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='HuYuanYuan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01690411567688 -- 25-12-01 14:31:27 -- /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.0033659934997559 -- 25-12-01 14:31:27 -- /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.0038700103759766 -- 25-12-01 14:31:27 -- /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.0035331249237061 -- 25-12-01 14:31:27[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043790340423584 -- 25-12-01 14:31:27[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033400058746338 -- 25-12-01 14:31:27[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064089298248291 -- 25-12-01 14:31:27[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015933036804199 -- 25-12-01 14:31:42 -- /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.0031969547271729 -- 25-12-01 14:31:42 -- /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.0040509700775146 -- 25-12-01 14:31:42 -- /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.024410963058472 -- 25-12-01 14:32:47[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048060417175293 -- 25-12-01 14:32:47[黄奕洪-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 acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077018737792969 -- 25-12-01 14:32:47[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051348209381104 -- 25-12-01 14:32:47[黄奕洪-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 e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021992921829224 -- 25-12-01 14:32:51[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043289661407471 -- 25-12-01 14:32:51[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053458213806152 -- 25-12-01 14:32:52[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004349946975708 -- 25-12-01 14:32:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019978046417236 -- 25-12-01 14:33: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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038840770721436 -- 25-12-01 14:33:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067150592803955 -- 25-12-01 14:33: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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039811134338379 -- 25-12-01 14:33:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016654968261719 -- 25-12-01 14:33:28[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032849311828613 -- 25-12-01 14:33:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061361789703369 -- 25-12-01 14:33:28[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016489028930664 -- 25-12-01 14:33:29[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032169818878174 -- 25-12-01 14:33:29[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003309965133667 -- 25-12-01 14:33:29[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028994083404541 -- 25-12-01 14:33:29[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044338703155518 -- 25-12-01 14:33:29[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004533052444458 -- 25-12-01 14:33:29[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019396066665649 -- 25-12-01 14:33:30[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00382399559021 -- 25-12-01 14:33:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022624015808105 -- 25-12-01 14:33:30[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015834808349609 -- 25-12-01 14:33:30[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030670166015625 -- 25-12-01 14:33:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032269954681396 -- 25-12-01 14:33:30[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019025087356567 -- 25-12-01 14:33:30[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037190914154053 -- 25-12-01 14:33:30[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038270950317383 -- 25-12-01 14:33:30[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028169870376587 -- 25-12-01 14:33:46[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046310424804688 -- 25-12-01 14:33:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059270858764648 -- 25-12-01 14:33:46[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/01' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050430297851562 -- 25-12-01 14:33:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023128986358643 -- 25-12-01 14:33:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0043690204620361 -- 25-12-01 14:33:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055420398712158 -- 25-12-01 14:33:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0044229030609131 -- 25-12-01 14:33:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043008327484131 -- 25-12-01 14:33:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043079853057861 -- 25-12-01 14:33:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020066976547241 -- 25-12-01 14:33:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0033888816833496 -- 25-12-01 14:33:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043048858642578 -- 25-12-01 14:33:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0034940242767334 -- 25-12-01 14:33:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033857822418213 -- 25-12-01 14:33:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018198013305664 -- 25-12-01 14:34:03[黄奕洪-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.0055379867553711 -- 25-12-01 14:34:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 809.00 where extrafareApply_id = 68255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015835046768188 -- 25-12-01 14:34:12[黄奕洪-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.00514817237854 -- 25-12-01 14:34:12[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 829.36 where extrafareApply_id = 68255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019776821136475 -- 25-12-01 14:34:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-12-01 14:34:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070590972900391 -- 25-12-01 14:34:14[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039539337158203 -- 25-12-01 14:34:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019166946411133 -- 25-12-01 14:34:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0039091110229492 -- 25-12-01 14:34:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0042629241943359 -- 25-12-01 14:34:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0041000843048096 -- 25-12-01 14:34:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037899017333984 -- 25-12-01 14:34:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015772104263306 -- 25-12-01 14:34: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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030829906463623 -- 25-12-01 14:34:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032248497009277 -- 25-12-01 14:34: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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030829906463623 -- 25-12-01 14:34:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0244460105896 -- 25-12-01 14:35: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.0037550926208496 -- 25-12-01 14:35: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.004417896270752 -- 25-12-01 14:35: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.0040950775146484 -- 25-12-01 14:35:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043168067932129 -- 25-12-01 14:35:01[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038411617279053 -- 25-12-01 14:35:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069701671600342 -- 25-12-01 14:35:01[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043659210205078 -- 25-12-01 14:35:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02015495300293 -- 25-12-01 14:35:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.00360107421875 -- 25-12-01 14:35:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006289005279541 -- 25-12-01 14:35:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0037441253662109 -- 25-12-01 14:35:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003605842590332 -- 25-12-01 14:35:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025237083435059 -- 25-12-01 14:35:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032820701599121 -- 25-12-01 14:35:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046448707580566 -- 25-12-01 14:35:06[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034248828887939 -- 25-12-01 14:35:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021283864974976 -- 25-12-01 14:35:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0047121047973633 -- 25-12-01 14:35:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0066730976104736 -- 25-12-01 14:35:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0045430660247803 -- 25-12-01 14:35:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041348934173584 -- 25-12-01 14:35:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019582033157349 -- 25-12-01 14:35:15[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038328170776367 -- 25-12-01 14:35:15[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069279670715332 -- 25-12-01 14:35:15[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039398670196533 -- 25-12-01 14:35:15[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016566038131714 -- 25-12-01 14:35:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0033490657806396 -- 25-12-01 14:35:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0037291049957275 -- 25-12-01 14:35:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0035569667816162 -- 25-12-01 14:35:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031728744506836 -- 25-12-01 14:35:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017004013061523 -- 25-12-01 14:35: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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034489631652832 -- 25-12-01 14:35:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 25-12-01 14:35: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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033049583435059 -- 25-12-01 14:35:19[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016376972198486 -- 25-12-01 14:35:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0032198429107666 -- 25-12-01 14:35:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0052058696746826 -- 25-12-01 14:35:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0032501220703125 -- 25-12-01 14:35:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003180980682373 -- 25-12-01 14:35:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017085075378418 -- 25-12-01 14:35:23[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68426 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032250881195068 -- 25-12-01 14:35:23[黄奕洪-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.024955034255981 -- 25-12-01 14:35:31[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68426 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065319538116455 -- 25-12-01 14:35:31[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 6000.00 where extrafareApply_id = 68426 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018491983413696 -- 25-12-01 14:35:41[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 25-12-01 14:35:41[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043230056762695 -- 25-12-01 14:35:42[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037691593170166 -- 25-12-01 14:35:42[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021352052688599 -- 25-12-01 14:35:43[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 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 = 68426 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037128925323486 -- 25-12-01 14:35:43[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047409534454346 -- 25-12-01 14:35:43[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 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 = 68426 and o.buzSystem_id = 15 and o.order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038058757781982 -- 25-12-01 14:35:43[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5662245 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022634029388428 -- 25-12-01 14:35:46[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68426 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019349098205566 -- 25-12-01 14:35:50[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037658214569092 -- 25-12-01 14:35:50[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069711208343506 -- 25-12-01 14:35:50[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039489269256592 -- 25-12-01 14:35:50[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025742053985596 -- 25-12-01 14:35:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 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 = 68426 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049421787261963 -- 25-12-01 14:35:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064020156860352 -- 25-12-01 14:35:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 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 = 68426 and o.buzSystem_id = 15 and o.order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049309730529785 -- 25-12-01 14:35:53[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68426 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5662245 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02488899230957 -- 25-12-01 14:35:55[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050220489501953 -- 25-12-01 14:35:55[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064258575439453 -- 25-12-01 14:35:55[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050749778747559 -- 25-12-01 14:35:55[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018353939056396 -- 25-12-01 14:35:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0040881633758545 -- 25-12-01 14:35:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0060470104217529 -- 25-12-01 14:35:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0039620399475098 -- 25-12-01 14:35:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035550594329834 -- 25-12-01 14:35:57[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020868062973022 -- 25-12-01 14:36:00[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040841102600098 -- 25-12-01 14:36:00[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041890144348145 -- 25-12-01 14:36:00[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004086971282959 -- 25-12-01 14:36:00[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017577171325684 -- 25-12-01 14:36:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0035810470581055 -- 25-12-01 14:36:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0039801597595215 -- 25-12-01 14:36:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0037820339202881 -- 25-12-01 14:36:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033628940582275 -- 25-12-01 14:36:01[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030461072921753 -- 25-12-01 14:37:32[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040919780731201 -- 25-12-01 14:37:32[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077860355377197 -- 25-12-01 14:37:32[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041651725769043 -- 25-12-01 14:37:32[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021203994750977 -- 25-12-01 14:37:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.00494384765625 -- 25-12-01 14:37:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0067470073699951 -- 25-12-01 14:37:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0044970512390137 -- 25-12-01 14:37:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041050910949707 -- 25-12-01 14:37:34[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026242971420288 -- 25-12-01 14:38:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0057740211486816 -- 25-12-01 14:38:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0076949596405029 -- 25-12-01 14:38:36[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.11808896064758 -- 25-12-01 14:38:58[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036709308624268 -- 25-12-01 14:38:58[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02354907989502 -- 25-12-01 14:38:58[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041470527648926 -- 25-12-01 14:38:58[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019930839538574 -- 25-12-01 14:38:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0044760704040527 -- 25-12-01 14:38:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0063550472259521 -- 25-12-01 14:38:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.023380994796753 -- 25-12-01 14:50:26[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0051250457763672 -- 25-12-01 14:50:26[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0077731609344482 -- 25-12-01 14:50:26[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.020414113998413 -- 25-12-01 14:50:44[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.004518985748291 -- 25-12-01 14:50:44[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0065150260925293 -- 25-12-01 14:50:44[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.025901079177856 -- 25-12-01 14:50:44[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042030811309814 -- 25-12-01 14:50:44[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083038806915283 -- 25-12-01 14:50:44[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046379566192627 -- 25-12-01 14:50:44[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018487930297852 -- 25-12-01 14:50:45[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035989284515381 -- 25-12-01 14:50:45[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037038326263428 -- 25-12-01 14:50:45[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036201477050781 -- 25-12-01 14:50:45[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022326946258545 -- 25-12-01 14:50:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0044071674346924 -- 25-12-01 14:50:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0050239562988281 -- 25-12-01 14:50:47[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.023173093795776 -- 25-12-01 14:50:50[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045928955078125 -- 25-12-01 14:50:50[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01926589012146 -- 25-12-01 14:50:50[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046150684356689 -- 25-12-01 14:50:50[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018990993499756 -- 25-12-01 14:50:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0034720897674561 -- 25-12-01 14:50:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063538551330566 -- 25-12-01 14:50:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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.0035901069641113 -- 25-12-01 14:50:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034670829772949 -- 25-12-01 14:50:52[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017330884933472 -- 25-12-01 14:50:54[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031740665435791 -- 25-12-01 14:50:54[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027366876602173 -- 25-12-01 14:50:54[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032079219818115 -- 25-12-01 14:50:54[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017441034317017 -- 25-12-01 14:50:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0039408206939697 -- 25-12-01 14:50:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0059468746185303 -- 25-12-01 14:50:59[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.025489807128906 -- 25-12-01 14:51:02[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048010349273682 -- 25-12-01 14:51:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077750682830811 -- 25-12-01 14:51:02[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052299499511719 -- 25-12-01 14:51:02[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020815849304199 -- 25-12-01 14:51:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.004080057144165 -- 25-12-01 14:51:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0050041675567627 -- 25-12-01 14:51:03[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.022451162338257 -- 25-12-01 14:51:06[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044400691986084 -- 25-12-01 14:51:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023259878158569 -- 25-12-01 14:51:06[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004443883895874 -- 25-12-01 14:51:06[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020810127258301 -- 25-12-01 14:51:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0040979385375977 -- 25-12-01 14:51:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.0067839622497559 -- 25-12-01 14:51:11[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=1 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.022264957427979 -- 25-12-01 14:51:24[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68427 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043120384216309 -- 25-12-01 14:51:24[黄奕洪-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.021083116531372 -- 25-12-01 14:51:25[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68427 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055150985717773 -- 25-12-01 14:51:25[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 6000.00 where extrafareApply_id = 68427 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018813848495483 -- 25-12-01 14:51: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 = 68427 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031280040740967 -- 25-12-01 14:51:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046520233154297 -- 25-12-01 14:51:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072989463806152 -- 25-12-01 14:51:28[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004741907119751 -- 25-12-01 14:51:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025506019592285 -- 25-12-01 15:23:52 -- /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.0050539970397949 -- 25-12-01 15:23:52 -- /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.0058591365814209 -- 25-12-01 15:23:52 -- /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='CaiJunDong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052080154418945 -- 25-12-01 15:23:52[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050370693206787 -- 25-12-01 15:23:52[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049967765808105 -- 25-12-01 15:23:52[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0068769454956055 -- 25-12-01 15:23:52[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019927978515625 -- 25-12-01 15:23:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038690567016602 -- 25-12-01 15:23:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053648948669434 -- 25-12-01 15:23:55[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020914077758789 -- 25-12-01 15:24:08[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041239261627197 -- 25-12-01 15:24:08[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062160491943359 -- 25-12-01 15:24:08[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015791893005371 -- 25-12-01 15:24:09[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003079891204834 -- 25-12-01 15:24:09[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031859874725342 -- 25-12-01 15:24:09[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01858377456665 -- 25-12-01 15:24:21 -- /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.0037078857421875 -- 25-12-01 15:24:21 -- /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.0042140483856201 -- 25-12-01 15:24:21 -- /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='CaiJunDong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027608871459961 -- 25-12-01 15:24:52[蔡骏东-司机-2493] -- /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 = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00313401222229 -- 25-12-01 15:24:52[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024951219558716 -- 25-12-01 15:24:52[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027478933334351 -- 25-12-01 15:24:54[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054850578308105 -- 25-12-01 15:24:54[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062928199768066 -- 25-12-01 15:24:54[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026768922805786 -- 25-12-01 16:04:28[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037391185760498 -- 25-12-01 16:04:28[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065820217132568 -- 25-12-01 16:04:28[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019845008850098 -- 25-12-01 16:05:17[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038831233978271 -- 25-12-01 16:05:17[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065290927886963 -- 25-12-01 16:05:17[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028852939605713 -- 25-12-01 16:05:18[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036630630493164 -- 25-12-01 16:05:18[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037739276885986 -- 25-12-01 16:05:18[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02445912361145 -- 25-12-01 16:05:21[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036110877990723 -- 25-12-01 16:05:21[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065779685974121 -- 25-12-01 16:05:21[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 AND IFNULL(oe_f.fleet_org_id,1) = 1 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019639015197754 -- 25-12-01 16:10:14 -- /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.0039370059967041 -- 25-12-01 16:10:14 -- /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.0044569969177246 -- 25-12-01 16:10:14 -- /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.0041851997375488 -- 25-12-01 16:10:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043189525604248 -- 25-12-01 16:10:14[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003917932510376 -- 25-12-01 16:10:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058341026306152 -- 25-12-01 16:10:14[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 AND oe_f.fleet_org_id IN(1,505) AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039792060852051 -- 25-12-01 16:10:14[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026940107345581 -- 25-12-01 16:27: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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075018405914307 -- 25-12-01 16:27: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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042688846588135 -- 25-12-01 16:27:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020225048065186 -- 25-12-01 16:27: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.0039560794830322 -- 25-12-01 16:27: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.0046119689941406 -- 25-12-01 16:27: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.019665956497192 -- 25-12-01 16:31:00 -- /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.0038940906524658 -- 25-12-01 16:31:00 -- /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.0047059059143066 -- 25-12-01 16:31:00 -- /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.017868995666504 -- 25-12-01 16:31:09[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069239139556885 -- 25-12-01 16:31:09[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039010047912598 -- 25-12-01 16:31:09[黄奕洪-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 e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641,614) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018157958984375 -- 25-12-01 16:31:26[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00630784034729 -- 25-12-01 16:31:26[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039100646972656 -- 25-12-01 16:31:26[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015943050384521 -- 25-12-01 16:31:28[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036089420318604 -- 25-12-01 16:31:28[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056169033050537 -- 25-12-01 16:31:28[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 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 = 699 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023887872695923 -- 25-12-01 16:31:41[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68435 and order_id = 699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046379566192627 -- 25-12-01 16:31:41[蔡骏东-司机-2493] -- /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 = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027683973312378 -- 25-12-01 16:31:42[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68435 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054771900177002 -- 25-12-01 16:31:42[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 10.00 where extrafareApply_id = 68435 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020405054092407 -- 25-12-01 16:31:53[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063209533691406 -- 25-12-01 16:31:53[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041220188140869 -- 25-12-01 16:31:53[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024128913879395 -- 25-12-01 16:31:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039911270141602 -- 25-12-01 16:31:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043752193450928 -- 25-12-01 16:31:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 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 = 699 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022068023681641 -- 25-12-01 16:31:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041739940643311 -- 25-12-01 16:31:58[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041100978851318 -- 25-12-01 16:31:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029353857040405 -- 25-12-01 16:32: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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00490403175354 -- 25-12-01 16:32: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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043151378631592 -- 25-12-01 16:32:08[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024585008621216 -- 25-12-01 16:32:12[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039539337158203 -- 25-12-01 16:32:12[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059709548950195 -- 25-12-01 16:32:12[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 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 = 699 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022839069366455 -- 25-12-01 16:32:17[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074388980865479 -- 25-12-01 16:32:17[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049009323120117 -- 25-12-01 16:32:17[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021967887878418 -- 25-12-01 16:32:30[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 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 = 68435 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040240287780762 -- 25-12-01 16:32:30[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006274938583374 -- 25-12-01 16:32:30[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 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 = 68435 and o.buzSystem_id = 15 and o.order_id = 699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040709972381592 -- 25-12-01 16:32:30[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5663287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003957986831665 -- 25-12-01 16:32:30[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016926050186157 -- 25-12-01 16:32:35[黄奕洪-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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062899589538574 -- 25-12-01 16:32:35[黄奕洪-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 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 WHERE o.acct_id=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' AND o.order_date <= '2025/12/01 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033857822418213 -- 25-12-01 16:32:35[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028718948364258 -- 25-12-01 16:32:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044639110565186 -- 25-12-01 16:32:35[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040581226348877 -- 25-12-01 16:32:35[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023837089538574 -- 25-12-01 16:32:36[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042421817779541 -- 25-12-01 16:32:36[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066969394683838 -- 25-12-01 16:32:36[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=1 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 = 699 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021865129470825 -- 25-12-01 16:32:44[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68436 and order_id = 699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042409896850586 -- 25-12-01 16:32:44[蔡骏东-司机-2493] -- /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 = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01575493812561 -- 25-12-01 16:32:45[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 68436 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050129890441895 -- 25-12-01 16:32:45[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 5.00 where extrafareApply_id = 68436 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023700952529907 -- 25-12-01 16:32:52[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68436 and order_id = 699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021075963973999 -- 25-12-01 16:32:53[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058059692382812 -- 25-12-01 16:32:53[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042350292205811 -- 25-12-01 16:32:53[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018956184387207 -- 25-12-01 16:32:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 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 = 68435 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035710334777832 -- 25-12-01 16:32:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042049884796143 -- 25-12-01 16:32:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 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 = 68435 and o.buzSystem_id = 15 and o.order_id = 699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036900043487549 -- 25-12-01 16:32:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5663287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035550594329834 -- 25-12-01 16:32:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68435 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020705938339233 -- 25-12-01 16:32:57[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056390762329102 -- 25-12-01 16:32:57[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042951107025146 -- 25-12-01 16:32:57[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02046799659729 -- 25-12-01 16:32:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68436 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 = 68436 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037679672241211 -- 25-12-01 16:32:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68436 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046648979187012 -- 25-12-01 16:32:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68436 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 = 68436 and o.buzSystem_id = 15 and o.order_id = 699 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038719177246094 -- 25-12-01 16:32:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68436 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5663298 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037410259246826 -- 25-12-01 16:32:58[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=699&extrafareApply_id=68436 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2493 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03144097328186 -- 25-12-01 16:33:02[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048489570617676 -- 25-12-01 16:33:02[蔡骏东-司机-2493] -- /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 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 WHERE o.acct_id=47 and o.buzSystem_id = 15 and w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/24' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044219493865967 -- 25-12-01 16:33:02[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(699) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020202159881592 -- 25-12-01 18:11:34[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_edit?event=truck_arvLoad select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------