Queries by type:
================
select 173 452 [91.18%]
create 16 437 [ 8.64%]
delete 146 [ 0.08%]
insert 122 [ 0.06%]
optimize 22 [ 0.01%]
update 20 [ 0.01%]
replace 18 [ 0.01%]
flush 13 [ 0.01%]
---------------
Total: 190 230 queries
Queries by pattern:
===================
1. 104 813 [55.10%] - select distinct(n.nid),n.title,n.type,n.changed,n.uid,u.name,greatest(n.changed,l.last_comment_timestamp)as last_updated,l.comment_count from node n inner join node_comment_statistics l on n.nid=l.nid inner join users u on n.uid=u.uid left join comments c on n.nid=c.nid and(c.status={}or c.status is{})where n.status={}and(n.uid={}or c.uid={})order by last_updated desc limit{};
2. 33 888 [17.81%] - select count(distinct(n.nid))from node n left join comments c on n.nid=c.nid and(c.status={}or c.status is{})where n.status={}and(n.uid={}or c.uid={});
3. 16 921 [ 8.90%] - select distinct m.*,r.*,u.name,u.uid from cvs_messages m inner join cvs_repositories r on m.rid=r.rid inner join users u on m.uid=u.uid order by m.created desc limit{};
4. 7 738 [ 4.07%] - select distinct(n.nid),n.title,n.type,n.changed,n.uid,u.name,greatest(n.changed,l.last_comment_timestamp)as last_updated,l.comment_count from node n inner join users u on n.uid=u.uid inner join node_comment_statistics l on n.nid=l.nid where n.status={}order by last_updated desc limit{};
5. 4 568 [ 2.40%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
6. 3 973 [ 2.09%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
7. 3 299 [ 1.73%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
8. 2 835 [ 1.49%] - select r.tid,count(n.nid)as topic_count,sum(l.comment_count)as comment_count from node n inner join node_comment_statistics l on n.nid=l.nid inner join term_node r on n.nid=r.nid where n.status={}and n.type={}group by r.tid;
9. 1 834 [ 0.96%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
10. 1 263 [ 0.66%] - select case when status={}then{}else{}end from access where type={}and lower({})like lower(mask)order by status desc limit{};
11. 970 [ 0.51%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,l.last_comment_timestamp desc,n.created desc limit{};
12. 938 [ 0.49%] - select ncs.last_comment_timestamp,if(ncs.last_comment_uid!={},u2.name,ncs.last_comment_name)as last_comment_name,ncs.last_comment_uid from node n inner join users u1 on n.uid=u1.uid inner join term_node tn on n.nid=tn.nid inner join node_comment_statistics ncs on n.nid=ncs.nid inner join users u2 on ncs.last_comment_uid=u2.uid where n.status={}and n.type={}and tn.tid={}order by ncs.last_comment_timestamp desc limit{};
13. 828 [ 0.44%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
14. 728 [ 0.38%] - select n.nid,n.title,n.sticky,l.comment_count,l.last_comment_timestamp from node n inner join node_comment_statistics l on n.nid=l.nid inner join term_node r on n.nid=r.nid and r.tid={}where n.status={}and n.type={}order by n.sticky desc,l.last_comment_timestamp desc;
15. 507 [ 0.27%] - select t.word as realword,i.word from search_total t left join search_index i on t.word=i.word where i.word is{};
16. 433 [ 0.23%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
17. 364 [ 0.19%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))and(((n.uid={})or(p.assigned={})or(c.uid={})));
18. 296 [ 0.16%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))and(((n.uid={})or(p.assigned={})or(c.uid={})))order by n.changed desc limit{};
19. 252 [ 0.13%] - create temporary table temp_search_results engine=heap select i.type,i.sid,{}*({}*i.relevance)+{}*pow({},(greatest(n.created,n.changed,c.last_comment_timestamp)-{})*{}e-{})+{}*({}-{}/({}+c.comment_count*{}))as score from temp_search_sids i inner join search_dataset d on i.sid=d.sid and i.type=d.type inner join node n on n.nid=i.sid left join node_comment_statistics c on c.nid=i.sid where(d.data like{})order by score desc;
20. 232 [ 0.12%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
21. 221 [ 0.12%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
22. 151 [ 0.08%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
23. 125 [ 0.07%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
24. 125 [ 0.07%] - select t.*from term_node r inner join term_data t on r.tid=t.tid inner join vocabulary v on t.vid=v.vid where r.nid={}order by v.weight,t.weight,t.name;
25. 108 [ 0.06%] - select greatest(if(c.last_comment_timestamp is{},c.last_comment_timestamp),n.changed)as last_change,n.nid from node n left join node_comment_statistics c on n.nid=c.nid where n.status={}and((greatest(n.changed,c.last_comment_timestamp)={}and n.nid>{})or(n.changed>{}or c.last_comment_timestamp>{}))order by greatest(n.changed,c.last_comment_timestamp)asc,n.nid asc limit{};
26. 102 [ 0.05%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
27. 99 [ 0.05%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))order by n.changed desc limit{};
28. 85 [ 0.04%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))order by n.changed desc limit{};
29. 83 [ 0.04%] - select distinct m.*,r.*,u.name,u.uid from cvs_messages m inner join cvs_files f on m.cid=f.cid inner join cvs_repositories r on m.rid=r.rid inner join users u on m.uid=u.uid where f.branch={}order by m.created desc limit{};
30. 83 [ 0.04%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
31. 72 [ 0.04%] - select count(*)from users u inner join users_access ua on u.uid=ua.uid where u.uid>{}and u.status!={}and ua.access!={};
32. 70 [ 0.04%] - insert into comments(cid,nid,pid,uid,subject,comment,format,hostname,timestamp,status,score,users,thread,name,mail,homepage)values({});
33. 61 [ 0.03%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
34. 58 [ 0.03%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,l.last_comment_timestamp asc,n.created desc limit{};
35. 57 [ 0.03%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,l.comment_count asc,n.created desc limit{};
36. 57 [ 0.03%] - create temporary table temp_search_results engine=heap select i.type,i.sid,{}*({}*i.relevance)+{}*pow({},(greatest(n.created,n.changed,c.last_comment_timestamp)-{})*{}e-{})+{}*({}-{}/({}+c.comment_count*{}))as score from temp_search_sids i inner join search_dataset d on i.sid=d.sid and i.type=d.type inner join node n on n.nid=i.sid left join node_comment_statistics c on c.nid=i.sid where(d.data like{}and d.data like{})order by score desc;
37. 56 [ 0.03%] - delete from url_alias where src={};
38. 55 [ 0.03%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
39. 53 [ 0.03%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
40. 51 [ 0.03%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
41. 51 [ 0.03%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
42. 50 [ 0.03%] - select dst from url_alias where src={};
43. 49 [ 0.03%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,n.title asc,n.created desc limit{};
44. 49 [ 0.03%] - select data,created,headers,expire from cache_menu where cid={};
45. 42 [ 0.02%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,n.created asc,n.created desc limit{};
46. 40 [ 0.02%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
47. 39 [ 0.02%] - select t.tid,t.*from term_data t inner join term_hierarchy h on h.parent=t.tid where h.tid={}order by weight,name;
48. 36 [ 0.02%] - delete from cache_filter where expire!={}and expire<={};
49. 36 [ 0.02%] - select name,filename,throttle,bootstrap from system where type={}and status={}order by weight asc,filename asc;
50. 35 [ 0.02%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))order by n.changed desc limit{};
51. 35 [ 0.02%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
52. 33 [ 0.02%] - delete from cache_page where expire!={}and expire<={};
53. 33 [ 0.02%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
54. 32 [ 0.02%] - select sid from sessions where sid={};
55. 30 [ 0.02%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,n.created desc,n.created desc limit{};
56. 25 [ 0.01%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,n.title desc,n.created desc limit{};
57. 24 [ 0.01%] - select*from`node_revisions`;
58. 23 [ 0.01%] - select*from`search_index`;
59. 23 [ 0.01%] - select*from`accesslog`;
60. 23 [ 0.01%] - select*from`cache_filter`;
61. 22 [ 0.01%] - select data,created,headers,expire from cache_filter where cid={};
62. 22 [ 0.01%] - select*from`comments`;
63. 21 [ 0.01%] - select t.tid,t.*,parent from term_data t inner join term_hierarchy h on t.tid=h.tid where t.vid={}order by weight,name;
64. 21 [ 0.01%] - select distinct(p.perm)from role r inner join permission p on p.rid=r.rid where r.rid in({});
65. 21 [ 0.01%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
66. 21 [ 0.01%] - select*from`search_dataset`;
67. 21 [ 0.01%] - insert into url_alias(src,dst)values({});
68. 20 [ 0.01%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))order by n.changed desc limit{};
69. 19 [ 0.01%] - select*from files f inner join file_revisions r on f.fid=r.fid where r.vid={}order by f.fid;
70. 19 [ 0.01%] - select n.nid,f.tid,n.title,n.sticky,u.name,u.uid,n.created as timestamp,n.comment as comment_mode,l.last_comment_timestamp,if(l.last_comment_uid!={},cu.name,l.last_comment_name)as last_comment_name,l.last_comment_uid,l.comment_count as num_comments from node_comment_statistics l,users cu,term_node r,users u,forum f,node n where n.status={}and l.last_comment_uid=cu.uid and n.nid=l.nid and n.nid=r.nid and r.tid={}and n.uid=u.uid and n.vid=f.vid order by n.sticky desc,l.comment_count desc,n.created desc limit{};
71. 18 [ 0.01%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
72. 17 [ 0.01%] - select*from system where type={};
73. 15 [ 0.01%] - select parent,weight from book where vid={};
74. 15 [ 0.01%] - select last_comment_timestamp,last_comment_name,comment_count from node_comment_statistics where nid={};
75. 15 [ 0.01%] - select data,created,headers,expire from cache where cid={};
76. 14 [ 0.01%] - select count(pid)from url_alias;
77. 14 [ 0.01%] - select u.uid,ua.access from users u inner join users_access ua on u.uid=ua.uid where u.uid>{}and u.status!={}and ua.access!={}order by ua.access desc limit{};
78. 14 [ 0.01%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
79. 14 [ 0.01%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))and(((n.uid={})or(p.assigned={})or(c.uid={})))order by n.changed desc limit{};
80. 14 [ 0.01%] - select count(n.nid)from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid where n.status={}and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
81. 14 [ 0.01%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))and(((n.uid={})or(p.assigned={})or(c.uid={})));
82. 13 [ 0.01%] - select data,created,headers,expire from cache_page where cid={};
83. 13 [ 0.01%] - flush query cache;
84. 12 [ 0.01%] - create temporary table temp_search_sids engine=heap select i.type,i.sid,sum(i.score*t.count)as relevance,count(*)as matches from search_index i inner join search_total t on i.word=t.word inner join node n on n.nid=i.sid inner join users u on n.uid=u.uid where n.status={}and(i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={}or i.word={})and i.type={}group by i.type,i.sid having count(*)>={};
85. 12 [ 0.01%] - select n.nid from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid where n.status={}and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))order by n.changed desc limit{};
86. 12 [ 0.01%] - replace into cache_filter(cid,data,created,expire,headers)values({});
87. 11 [ 0.01%] - select message,count(message)as count from watchdog where type={}and uid={}group by message order by count desc limit{};
88. 11 [ 0.01%] - select distinct(n.nid),n.changed from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.uid={})or(p.assigned={})or(c.uid={})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}))order by n.changed desc limit{};
89. 11 [ 0.01%] - select*from project_issue_state order by weight;
90. 11 [ 0.01%] - select n.nid,n.vid,n.type,n.status,n.created,n.changed,n.comment,n.promote,n.sticky,r.timestamp as revision_timestamp,r.title,r.body,r.teaser,r.log,r.format,u.uid,u.name,u.picture,u.data from node n inner join users u on u.uid=n.uid inner join node_revisions r on r.vid=n.vid where n.nid={};
91. 10 [ 0.01%] - select count(distinct(n.nid))from node n inner join project_issues p on p.nid=n.nid inner join node_revisions r on r.vid=n.vid inner join users u on p.assigned=u.uid left join project_comments c on c.nid=p.nid where n.status={}and(((n.title like{})or(r.body like{})or(c.body like{})))and((p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}or p.sid={}));
92. 9 [ 0.00%] - select n.nid,n.title,b.parent,b.weight from node n inner join book b on n.vid=b.vid where n.status={}order by b.weight,n.title;
93. 9 [ 0.00%] - delete from url_alias where dst={};
94. 9 [ 0.00%] - update sessions set uid={},cache={},hostname={},session={},timestamp={}where sid={};
95. 9 [ 0.00%] - select*from`cache_menu`;
96. 8 [ 0.00%] - select count(*)from node_access where nid={}and((gid={}and realm={}))and grant_view>={};
97. 8 [ 0.00%] - select n.nid,n.title,b.parent,b.weight from node n inner join book b on n.vid=b.vid where n.nid={};
98. 8 [ 0.00%] - select distinct b.*from blocks b left join blocks_roles r on b.module=r.module and b.delta=r.delta where b.theme={}and b.status={}and(r.rid in({})or r.rid is{})order by b.region,b.weight,b.module;
99. 8 [ 0.00%] - insert into cvs_project_maintainers(nid,uid)values({});
100. 8 [ 0.00%] - insert into watchdog(uid,type,message,severity,link,location,referer,hostname,timestamp)values({});
---------------
Total: 100 patterns