mysql 语句常用优化贴
大数据量的翻页使用 where > id 好过offset
不好的
select * from user offset 1000000000 limit 1
好的
select * from user where id > 1000000000 limit 1
Notice: Undefined index: key in /home/worker/data/www/liuzimu-blogs/usr/plugins/MysqlRun/Plugin.php on line 138
select * from user offset 1000000000 limit 1
select * from user where id > 1000000000 limit 1