Time: 0.0062658786773682 -- 25-12-02 11:27: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 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/25'  AND o.order_date <= '2025/12/02 23:59:59 '
 AND e.extrafareApply_id > 1 
GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------