Time: 0.0041129589080811 -- 25-12-04 16:11:36[罗军-2461] -- /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,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date 
 					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 = 75  OR  AND IFNULL(oe_f.fleet_org_id,1) = 1  )  AND IFNULL(w.work_type_id,1) = 1  AND o.order_date >= '2025/11/27' GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0034589767456055 -- 25-12-04 16:11:50[罗军-2461] -- /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,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date 
 					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 = 75  OR  AND IFNULL(oe_f.fleet_org_id,1) = 1  )  AND IFNULL(w.work_type_id,1) = 1  AND o.order_date >= '2025/11/27' GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0044898986816406 -- 25-12-04 16:12:51[罗军-2461] -- /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,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date 
 					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 = 75  OR  AND IFNULL(oe_f.fleet_org_id,1) = 1  )  AND IFNULL(w.work_type_id,1) = 1  AND o.order_date >= '2025/11/27' GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0032927989959717 -- 25-12-04 16:13:14[罗军-2461] -- /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,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date 
 					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 = 75  OR  AND IFNULL(oe_f.fleet_org_id,1) = 1  )  AND IFNULL(w.work_type_id,1) = 1  AND o.order_date >= '2025/11/27' GROUP BY o.order_id ORDER BY o.order_id DESC  LIMIT 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------