mysql的分页优化例子

例子1

#主键id自增长SELECT * FROM t_test WHERE ID >=(    SELECT id     FROM t_test     LIMIT 866613, 1) LIMIT 20

例子2

#inner join SELECT a.* FROM t_test a INNER JOIN     (        SELECT b.id         FROM t_test b         ORDER BY b.id DESC         LIMIT 900000, 15    ) c ON c.id = a.id