mysql的Late row lookups(延迟row查找)
CREATE TABLE `20130122handler` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `content` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `20130122handler_idx_uid` (`uid`)) ENGINE=InnoDB
select SQL_NO_CACHE * from 20130122handlerorder by uid LIMIT 120,20
select SQL_NO_CACHE * from 20130122handlerorder by uid LIMIT 2020,20
select SQL_NO_CACHE m.* from( select uid from 20130122handler ORDER BY uid LIMIT 2020,20) t,20130122handler mwhere t.uid=m.uid
select SQL_NO_CACHE * from 20130122handlerorder by id LIMIT 120,20select SQL_NO_CACHE * from 20130122handlerORDER BY id LIMIT 2040,20