nephyzw

摘要： 我们先查出偏移后的主键，再根据主键索引查询数据块的所有内容即可优化。 mysql> select a.* from member as a inner join (select id from member where gender=1 limit 300000,1) as b on a.id=b. 阅读全文