大数据量sql分页查询优化

先取ID，再limit N。

SELECT * FROM product WHERE ID > =(select id from tb_ limit 10000, 20000) limit 10;

记录查询位置

select max(b.id) from  (select id from tb_event_handle limit 100,2) b