select SUBSTR(b.qry, 6, position-6) as pfix, count(*) from (
select *, LOCATE('(', qry) as position from (
select sl.start_time, sl.query_time, sl.rows_examined,
convert(sl.sql_text using utf8) as qry
from mysql.slow_log sl
where start_time between '2018-10-16 00:00:00' and '2018-10-16 01:20:00') a) b
group by pfix
order by count(*) desc;