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