php mysql 百万，千万，亿级分页思路，效率很高

传统型
select * from t_card_coupon  limit 20000000,10 

 

高效型

select * from t_card_coupon where id in(
select id from (select id from t_card_coupon limit 20000000,10) as t
)