mysql most popular page in 5 minute intervals, MySQL

Language: Layout:

drop table pages;

create table pages (pages_timestamp datetime, page_name nvarchar(25));

insert into pages select addtime(now(),'00:01:00.000001'), 'nice';
insert into pages select addtime(now(),'00:02:00.000001'), 'good';
insert into pages select addtime(now(),'00:03:00.000001'), 'nice';
insert into pages select addtime(now(),'00:04:00.000001'), 'nice';
insert into pages select addtime(now(),'00:05:00.000001'), 'nice';
insert into pages select addtime(now(),'00:06:00.000001'), 'nice';
insert into pages select addtime(now(),'00:07:00.000001'), 'nice';
insert into pages select addtime(now(),'00:08:00.000001'), 'good';
insert into pages select addtime(now(),'00:09:00.000001'), 'nice';
insert into pages select addtime(now(),'00:10:00.000001'), 'nice';
insert into pages select addtime(now(),'00:11:00.000001'), 'nice';
insert into pages select addtime(now(),'00:12:00.000001'), 'nice';
insert into pages select addtime(now(),'00:13:00.000001'), 'good';
insert into pages select addtime(now(),'00:14:00.000001'), 'good';
insert into pages select addtime(now(),'00:15:00.000001'), 'good';
insert into pages select addtime(now(),'00:16:00.000001'), 'good';
insert into pages select addtime(now(),'00:17:00.000001'), 'good';
insert into pages select addtime(now(),'00:18:00.000001'), 'good';

drop function if exists rtime;
create function rtime (time DATETIME)
returns DATETIME

BEGIN
DECLARE newtime DATETIME;
set newtime = from_unixtime(floor(unix_timestamp(time)/300)*300);
return newtime;
END;

#select rtime(pages_timestamp), page_name from pages;

#select Time, Page, Hits from (    select rtime(pages_timestamp) as time    , page_name as page    ,  count(page_name) as hits     from pages     group by page_name, rtime(pages_timestamp)     order by rtime(pages_timestamp), hits desc) g ;

select * from (select time, page, hits from (select rtime(pages_timestamp) as time, page_name as page,  count(page_name) as hits from pages group by page_name, rtime(pages_timestamp) order by rtime(pages_timestamp), hits desc) g ) h group by time;


absolute service time: 0,39 sec