百万级 分页查询优化

SELECT * FROM `table` WHERE id <= (SELECT id FROM `table` ORDER BY id desc LIMIT ".($page-1)*$pagesize.", 1) ORDER BY id desc LIMIT $pagesizeSELECT * FROM `table` WHERE id <= (SELECT id FR