Mysql百万级分页优化技巧

select * from user limit 1,20

SELECT * from user limit 100001,20; //time 0.151s
explain SELECT * from user limit 100001,20;

select * from user where id>(select id from user where id>=100000 limit 1) limit 20; //time 0.003s

 explain select * from user where id>(select id from user where id>=100000 limit 1) limit 20; 

select
     c.*
     FROM
  (
  SELECT
   a.logid
  FROM
   tableA a
  where 1 = 1
     <#if phone""> 
      AND a.phone like "%":phone"%" 
     </#if>
   ORDER BY
    a.create_time DESC
   limit :startIndex,:maxCount
  ) b,tableA c
  where 1 = 1 AND b.logid = c.logid