mysql limit优化

SELECT * FROM `dianhuabang_itag_tag_detail_info` limit 6000005,10;

explain SELECT * FROM `dianhuabang_itag_tag_detail_info` a FORCE INDEX(idx_application)
where id in (select id from (select id from dianhuabang_itag_tag_detail_info limit 6000000,10) as t) ;

SELECT * FROM `dianhuabang_itag_tag_detail_info` a
where exists (select id from (select id from dianhuabang_itag_tag_detail_info limit 6000000,10) as t);

explain select id from (select id from dianhuabang_itag_tag_detail_info limit 6000000,10) as t

#这种写法测试效率最快
explain SELECT * FROM `dianhuabang_itag_tag_detail_info` a #FORCE INDEX(idx_application)
inner join (select id from dianhuabang_itag_tag_detail_info limit 7000001,10) b on a.id=b.id ;