select id,max(update_time) from table1 group by id order by date limit 10
select t.* from table1 t where update_time = (select max(update_time) from table1 where id= t.id) order by date limit 10
select t.* from table1t where not exists (select 1 from table1 where id= t.idand update_time > t.update_time) order by date limit 10