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