MySQL表查询优化(二):优雅的商品分页第一步

第一页
select * from prod_main order by prod_id desc limit 0,20;
这是最基本的分页sql
按照主键ID倒排序
type级别是index

第二页
select * from prod_main order by prod_id desc limit 20,20

优雅的分页应该是：

$startrow = 0;
$pagesize = 20;
if($startrow == 0){
    select * from prod_main order by prod_id desc limit startrow,pagesize;  
}else{
    select * from prod_main where prod_id<=(select prod_id from prod_main order by prod_id desc limit startrow,1) order by prod_id desc limit pagesize;
}

这样从第二页开始主查询type指标就是range了