Sample output:

Queries by type:
================
select               10 658     [56.43%]
set                  4 821      [25.53%]
update               1 586      [ 8.40%]
show                 531        [ 2.81%]
insert               474        [ 2.51%]
delete               271        [ 1.43%]
create               213        [ 1.13%]
drop                 92         [ 0.49%]
unlock               50         [ 0.26%]
lock                 50         [ 0.26%]
replace              26         [ 0.14%]
flush                4          [ 0.02%]
desc                 4          [ 0.02%]
use                  2          [ 0.01%]
explain              2          [ 0.01%]
grant                2          [ 0.01%]
commit               1          [ 0.01%]
truncate             1          [ 0.01%]
...
---------------
Total: 18 886 queries


Queries by pattern:
===================
1.	4 790      [25.36%] - set names utf8
2.	3 731      [19.76%] - select id from projects where md5(id)={}
3.	1 373      [ 7.27%] - update dcdb_session set last_access_time=now()where profile_id={}and sid={}
4.	208        [ 1.10%] - select data,created,headers from cache where cid={}
5.	172        [ 0.91%] - insert into system(name,description,type,filename,status,throttle,bootstrap)values({})
6.	144        [ 0.76%] - select*from blocks where status={}and region in({})order by weight,module
7.	128        [ 0.68%] - delete from system where name={}and type={}
8.	124        [ 0.66%] - select r.rid,r.name from role r inner join users_roles ur on ur.rid=r.rid where ur.uid={}
9.	108        [ 0.57%] - show table status like{}
10.	104        [ 0.55%] - select id from profiles where project={}and login={}
11.	91         [ 0.48%] - select u.*,s.*from users u inner join sessions s on u.uid=s.uid where s.sid={}and u.status<{}limit{}
12.	91         [ 0.48%] - select*from url_alias
13.	91         [ 0.48%] - select name,filename,throttle,bootstrap from system where type={}and status={}
14.	91         [ 0.48%] - update sessions set uid={},hostname={},session={},timestamp={}where sid={}
15.	87         [ 0.46%] - select*from system where type={}order by name
16.	76         [ 0.40%] - update system set status={},throttle={}where type={}and name={}
17.	66         [ 0.35%] - select id,login,group_permissions from user where delfi_profile_id={}
18.	53         [ 0.28%] - select id from profiles where id={}and password={}and project={}
19.	50         [ 0.26%] - unlock tables
20.	50         [ 0.26%] - select id,title,access_level from album where id={}and user_id={}
21.	49         [ 0.26%] - insert into blocks(module,delta,status,weight,region,visibility,pages,custom,throttle,types)values({})
22.	49         [ 0.26%] - select id,name from category order by sort_order
23.	44         [ 0.23%] - delete from dcdb_session where sid={}
24.	42         [ 0.22%] - select id from profiles where id={}and password=md5({})and project={}
25.	40         [ 0.21%] - select id,title from album where user_id={}and id<&qt;{}
26.	38         [ 0.20%] - select sum(if(id<{}))as num_before,sum(if(id&qt;{}))as num_after,count(*)as num from image where album_id={}
27.	38         [ 0.20%] - select id,salt from image where album_id={}order by id limit{}
28.	34         [ 0.18%] - select sum(i.size)from image i inner join album a on i.album_id=a.id where a.user_id={}
...
---------------
Total: 1 093 patterns