Time: 0.006227970123291 -- 25-12-03 12:56:13[黄奕洪-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/26'  AND o.order_date <= '2025/12/03 23:59:59 '
 AND e.extrafareApply_id > 1 
GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0065228939056396 -- 25-12-03 12:56: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 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/26'  AND o.order_date <= '2025/12/03 23:59:59 '
 AND ifnull(e.extrafareApply_id,1) <= 1 
GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------