top three category, MySQL

Language: Layout:

drop table if exists tst;

create table tst (id int, title varchar(100), category varchar(100), time_stamp datetime);
insert into tst values 
  ( 1, "post 1", "category 1", "2017-10-28 14:03"),
  ( 2, "post 2", "category 1", "2017-10-28 14:05"),
  ( 3, "post 3", "category 4", "2017-10-28 14:05"),
  ( 4, "post 4", "category 1", "2017-10-28 14:08"),
  ( 5, "post 5", "category 2", "2017-10-28 14:09"),
  ( 6, "post 6", "category 5", "2017-10-28 14:13"),
  ( 7, "post 7", "category 3", "2017-10-28 14:14"),
  ( 8, "post 8", "category 6", "2017-10-28 14:15"),
  ( 9, "post 9", "category 2", "2017-10-28 14:16"),
  (10, "post 10", "category 2", "2017-10-28 14:16:30"),
  (11, "post 11", "category 4", "2017-10-28 14:18"),
  (12, "post 5", "category 4", "2017-10-28 14:18");
  
select     tst.*
from       tst
inner join (
            select   category, 
                     max(time_stamp) time_stamp,
                     max(id) id
            from     tst
            group by category
            order by 2 desc
            limit    3
           ) as topthree
        on topthree.id = tst.id;
        
drop table tst;


absolute service time: 0,35 sec