select * from (select * from tablename order by last_time desc) as t order by t.id desc
order by last_time,id desc 这种方式last_time默认是升序的
order by last_time and id desc 这种方式两个字段都是降序的
应该先分组,
select id,last_time from yourtablename group by last_time order by last_time desc,id desc