3条sql语句的性能对比

有谁能分析出三条语句的执行性能吗

select a.*,b.* 
FROM tb_order_user_229 a,tb_order_info_user_229 b 
WHERE a.order_id=b.order_id and a.user_id = 45923430 AND a.trade_code != 'Z0001' 
order by a.create_time desc limit 100,300

SELECT a.order_id, a.trade_code, a.user_id, a.user_name, a.create_time, a.cancel_time, a.pay_time, a.pay_account, a.seller_id, a.seller_name, a.pay_channel, a.pay_id, a.closing_price, a.consumer_details, a.third_id, a.express_id, a.express_no, a.province_id, a.city_id, a.county_id, a.receiver_address, a.receiver_name, a.receiver_mobile, a.receiver_tele, a.order_state, a.seller_comment, a.buyer_comment, a.source, a.last_update_time, a.last_update_user_id, a.create_user_id,a.pay_state,a.address_id,a.province_name, a.city_name,a.county_name,a.post_code,a.deliver_time, a.success_time, a.complain_state, a.after_sale_state, a.settlement_state, a.postage, a.is_buyer_delete, a.score,a.score_platform_id,a.order_state_type, a.order_state_type_desc,a.settlement_time,a.coupon_no,a.coupon_price,a.order_tag,a.express_name, a.wi, a.from_source, a.order_id, a.trade_pay_id, a.discount_category, a.discount_id, a.discount_type, a.discount_desc, a.discount_satisfy_rule, a.discount_price, b.product_id, b.class_num, b.seller_class_num, b.sku_num, b.sku_desc, b.cur_price, b.org_price, b.count, b.postage, b.product_snapshoot_id, b.comment, b.last_update_time, b.last_update_user_id, b.create_time, b.create_user_id,b.location,b.profile,b.shelf,b.product_name,b.images_url,b.type,b.level,b.score, b.cate,b.promotion_id,b.discount_price,b.coupon_price from 
(select a.order_id FROM tb_order_user_229 a, tb_order_info_user_229 b WHERE a.order_id = b.order_id AND a.user_id = 45923430 AND a.trade_code != 'Z0001' GROUP BY a.order_id order by a.create_time desc limit 100 ,530 )
c, tb_order_user_229 a,tb_order_info_user_229 b where c.order_id = a.order_id AND c.order_id = b.order_id 

SELECT a.order_id, a.trade_code, a.user_id, a.user_name, a.create_time, a.cancel_time, a.pay_time, a.pay_account, a.seller_id, a.seller_name, a.pay_channel, a.pay_id, a.closing_price, a.consumer_details, a.third_id, a.express_id, a.express_no, a.province_id, a.city_id, a.county_id, a.receiver_address, a.receiver_name, a.receiver_mobile, a.receiver_tele, a.order_state, a.seller_comment, a.buyer_comment, a.source, a.last_update_time, a.last_update_user_id, a.create_user_id,a.pay_state,a.address_id,a.province_name, a.city_name,a.county_name,a.post_code,a.deliver_time, a.success_time, a.complain_state, a.after_sale_state, a.settlement_state, a.postage, a.is_buyer_delete, a.score,a.score_platform_id,a.order_state_type, a.order_state_type_desc,a.settlement_time,a.coupon_no,a.coupon_price,a.order_tag,a.express_name, a.wi, a.from_source, a.order_id, a.trade_pay_id, a.discount_category, a.discount_id, a.discount_type, a.discount_desc, a.discount_satisfy_rule, a.discount_price, b.product_id, b.class_num, b.seller_class_num, b.sku_num, b.sku_desc, b.cur_price, b.org_price, b.count, b.postage, b.product_snapshoot_id, b.comment, b.last_update_time, b.last_update_user_id, b.create_time, b.create_user_id,b.location,b.profile,b.shelf,b.product_name,b.images_url,b.type,b.level,b.score, b.cate,b.promotion_id,b.discount_price,b.coupon_price from 
( select t.* from tb_order_user_229 t where t.order_id in 
(select DISTINCT a.order_id FROM tb_order_user_229 a, tb_order_info_user_229 b WHERE a.order_id = b.order_id AND a.user_id = 45923430 AND a.trade_code != 'Z0001' ) order by t.create_time desc limit 100,300 )a,tb_order_info_user_229 b where a.order_id=b.order_id 
#2014-09-24 16:11:50,558 [pool-2-thread-24] DEBUG sql.PreparedStatement - ==> Parameters: 6760(Integer), 10(Integer)