常规是这么写的
SELECT id,name FROM `XX_flow` WHERE `class_id`=1 ORDER BY `id` desc LIMIT 0,10
如果要对里面的多个条件进行排序,先排序时间再排序热度 会发现翻页以后数据出现重复
SELECT id,name FROM `XX_flow` WHERE `class_id`=1 ORDER BY `date` desc, `hot` desc LIMIT 10,10
解决办法,再进行一次ID排序
SELECT id,name FROM `XX_flow` WHERE `class_id`=1 ORDER BY `date` desc, `hot` desc , `id` desc LIMIT 10,10