time: 143.27ms; [ SELECT id,name,sex FROM cs LIMIT 1000000,10 ]
time: 0.41ms; [ SELECT id,name,sex FROM cs WHERE id>1000010 LIMIT 10 ]
:数据量少的时候并无太大差距,这种非常适合log表查询 根据上一次的分页查询获取到可根据某个字段的值来进行代替分页的值 (1000000 == WHERE id>1000010)
time: 23.56ms; [ SELECT * FROM user_family_trees WHERE depth in (1,2,3,4,5,6,7,8,9,10) ]
time: 0.47ms; [ SELECT * FROM user_family_trees WHERE depth in (1,2,3,4,5,6,7,8,9,10) LIMIT 10 ; ]
:适合根据N个唯一性字段 IN适合直接限制最高返回条数LIMIT