select a.* from product as a,
(select max(create_time) as create_time from product group by type) as b
where a.create_time=b.create_time
group by a.type
order by a.create_time desc;
或者
select a.* from product as a
innner join(select max(create_time) as create_time from product group by type) as b
on a.create_time=b.create_time
group by a.type
order by a.create_time desc;