select 'true' as QUERYID, rb_id, rb_source, rb_startTime, rb_endTime, rb_type, rb_useable, rb_redBagNum, rb_singleContains, rb_currentNum, rb_content from redbag order by rb_startTime desc limit 0 , 10;
select 'true' as QUERYID, rb_id, rb_source, rb_startTime, rb_endTime, rb_type, rb_useable, rb_redBagNum, rb_singleContains, rb_currentNum, rb_content from redbag order by rb_startTime desc
按照时间排序,分页查询,第二页出现了第一页的数据,同时,第一页的数据也和不带分页的顺序不一致。
解决办法,在存在相同时间的时候,额外增加id排序。