MySQL中的limit的优化延迟关联和边界查询

explain select * from ph_member limit 4000,10

1    SIMPLE    ph_member        ALL                    10705    100     使用时间为0.006s

#延迟关联
explain select * from ph_member INNER JOIN (select id from ph_member LIMIT 4000,10) as number USING(id);

1    PRIMARY    <derived2>    ALL                        4010    100    
1    PRIMARY    ph_member    eq_ref    PRIMARY        PRIMARY    8    number.id    1    100    
2    DERIVED    ph_member    index            telPhone    35        10705    100    Using index  使用时间为0.0001

#通过边界进行查询

EXPLAIN select * from ph_member where id BETWEEN  31190 and 34985 order by id;

1    SIMPLE    ph_member        range    PRIMARY    PRIMARY    8        5352    100    Using where   使用时间0.002s

延迟关联

边界值