User's today activity (improved speed)

SQL

set @target = "Adesio2010";
select actor_id into @aid from actor where actor_name = @target limit 1;

select page_title,
CONCAT(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2), "-",substr(rev_timestamp,7,2)," ",substr(rev_timestamp,9,2)+7,":",substr(rev_timestamp,11,2)) as 'Timestamp'
from
(select rev_page,rev_timestamp from revision where rev_timestamp >= 20210603000000 and rev_timestamp <= 20210604000000 and rev_actor = @aid) p
inner join page on p.rev_page = page_id
order by rev_timestamp desc;

SQL

Checking query status...