Slow query log from updated version of drupal.org

I've crawled it with wget as a logged in user.

Many of the queries are probably covered by http://drupal.org/node/371475

 Starting... 
|||||| 21 Queries 
|||||| Total time: 51, Average time: 2.42857142857143
|||||| Taking 2  to 3  seconds to complete
|||||| Rows analyzed 471225 - 529228
SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n  INNER JOIN term_node tnXXX ON n.vid = tnXXX.vid WHERE n.status = XXX  AND tnXXX.tid IN (XXX) ORDER BY n.sticky DESC, n.created DESC LIMIT XXX, XXX;

SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n  INNER JOIN term_node tn0 ON n.vid = tn0.vid WHERE n.status = 1  AND tn0.tid IN (77) ORDER BY n.sticky DESC, n.created DESC LIMIT 58008, 6;


|||||| 10 Queries 
|||||| Total time: 41, Average time: 4.1
|||||| Taking 4 , 4 , 4 , 4 , 4 , 4 , 4 , 4 , 4 , 5  seconds to complete
|||||| Rows analyzed 949806, 949856, 949906, 949956, 950006, 950056, 950106, 950156, 950206 and 950301
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT 500, 50;


|||||| 19 Queries 
|||||| Total time: 38, Average time: 2
|||||| Taking 2  to 2  seconds to complete
|||||| Rows analyzed 655348 - 707486
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT 51700, 50;


|||||| 2 Queries 
|||||| Total time: 13, Average time: 6.5
|||||| Taking 4 , 9  seconds to complete
|||||| Rows analyzed 0 and 0
SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ) count_alias;

SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ) count_alias;


|||||| 4 Queries 
|||||| Total time: 8, Average time: 2
|||||| Taking 2 , 2 , 2 , 2  seconds to complete
|||||| Rows analyzed 485681, 485731, 485781 and 555029
SELECT n.nid, r.tid, n.title, n.type, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != XXX, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments, f.tid AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON n.nid = l.nid INNER JOIN users cu ON l.last_comment_uid = cu.uid INNER JOIN term_node r ON n.vid = r.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN forum f ON n.vid = f.vid WHERE n.status = XXX AND r.tid = XXX ORDER BY n.sticky DESC, l.last_comment_timestamp DESC, n.created DESC LIMIT XXX, XXX;

SELECT n.nid, r.tid, n.title, n.type, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments, f.tid AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON n.nid = l.nid INNER JOIN users cu ON l.last_comment_uid = cu.uid INNER JOIN term_node r ON n.vid = r.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN forum f ON n.vid = f.vid WHERE n.status = 1 AND r.tid = 22 ORDER BY n.sticky DESC, l.last_comment_timestamp DESC, n.created DESC LIMIT 69350, 25;


|||||| 1 Query 
|||||| Total time: 7, Average time: 7
|||||| Taking 7  seconds to complete
|||||| Rows analyzed 1542093
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX)
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1)
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 5, Average time: 5
|||||| Taking 5  seconds to complete
|||||| Rows analyzed 1
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, 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 = XXX;


SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, 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 = 211477;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY project_issues_sid ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY project_issues_sid ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY users_project_issues_name ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY users_project_issues_name ASC
 LIMIT 0, 50;


|||||| 2 Queries 
|||||| Total time: 4, Average time: 2
|||||| Taking 2 , 2  seconds to complete
|||||| Rows analyzed 0 and 0
SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ) count_alias;

SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ) count_alias;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY project_issues_priority ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY project_issues_priority ASC
 LIMIT 0, 50;


|||||| 2 Queries 
|||||| Total time: 4, Average time: 2
|||||| Taking 2 , 2  seconds to complete
|||||| Rows analyzed 655348 and 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY project_issues_category ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY project_issues_category ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY node_comment_statistics_comment_count ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY node_comment_statistics_comment_count ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY node_comment_statistics_last_comment_timestamp ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY node_comment_statistics_last_comment_timestamp ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 0
SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ) count_alias;

SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ) count_alias;


|||||| 2 Queries 
|||||| Total time: 4, Average time: 2
|||||| Taking 2 , 2  seconds to complete
|||||| Rows analyzed 655348 and 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY users_project_issues_name ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY users_project_issues_name ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY node_project_issues__project_release_nodes_version ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY node_project_issues__project_release_nodes_version ASC
 LIMIT 0, 50;


|||||| 2 Queries 
|||||| Total time: 4, Average time: 2
|||||| Taking 2 , 2  seconds to complete
|||||| Rows analyzed 655348 and 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY node_comment_statistics_last_comment_timestamp ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY node_comment_statistics_last_comment_timestamp ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 22579
SELECT n.nid, n.title, n.changed, r.log, u.uid, u.name
    FROM node n
    INNER JOIN book b ON n.nid = b.nid INNER JOIN node_revisions r ON n.vid = r.vid INNER JOIN users u ON u.uid = r.uid
    WHERE n.status = XXX
    ORDER BY n.changed DESC LIMIT XXX, XXX;

SELECT n.nid, n.title, n.changed, r.log, u.uid, u.name
    FROM node n
    INNER JOIN book b ON n.nid = b.nid INNER JOIN node_revisions r ON n.vid = r.vid INNER JOIN users u ON u.uid = r.uid
    WHERE n.status = 1
    ORDER BY n.changed DESC LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 942095
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY node_title ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY node_title ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY node_project_issues_XXX_title ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY node_project_issues_1_title ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 4, Average time: 4
|||||| Taking 4  seconds to complete
|||||| Rows analyzed 949806
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (node.uid = XXX OR (SELECT COUNT(*) FROM comments c WHERE c.uid = XXX AND c.nid = node.nid))
   ORDER BY project_issues_category ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_project_issues__project_release_nodes.version AS node_project_issues__project_release_nodes_version,
   node_project_issues__project_release_nodes.nid AS node_project_issues__project_release_nodes_nid,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (node.uid = 227 OR (SELECT COUNT(*) FROM comments c WHERE c.uid = 227 AND c.nid = node.nid))
   ORDER BY project_issues_category ASC
 LIMIT 0, 50;


|||||| 2 Queries 
|||||| Total time: 4, Average time: 2
|||||| Taking 2 , 2  seconds to complete
|||||| Rows analyzed 655348 and 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY project_issues_sid ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY project_issues_sid ASC
 LIMIT 0, 50;


|||||| 2 Queries 
|||||| Total time: 4, Average time: 2
|||||| Taking 2 , 2  seconds to complete
|||||| Rows analyzed 655348 and 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY node_comment_statistics_comment_count ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY node_comment_statistics_comment_count ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 3, Average time: 3
|||||| Taking 3  seconds to complete
|||||| Rows analyzed 309165
SELECT p.category, SUM(n.changed - n.created) / COUNT(p.category) AS duration FROM project_issues p INNER JOIN node n ON n.nid = p.nid WHERE n.status = XXX AND p.sid > XXX GROUP BY p.category;

SELECT p.category, SUM(n.changed - n.created) / COUNT(p.category) AS duration FROM project_issues p INNER JOIN node n ON n.nid = p.nid WHERE n.status = 1 AND p.sid > 1 GROUP BY p.category;


|||||| 1 Query 
|||||| Total time: 3, Average time: 3
|||||| Taking 3  seconds to complete
|||||| Rows analyzed 0
SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX)
   ) count_alias;

SELECT COUNT(*) FROM (SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN project_release_nodes node_project_issues__project_release_nodes ON node_project_issues.nid = node_project_issues__project_release_nodes.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1)
   ) count_alias;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 174588
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY node_title ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY node_title ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY project_issues_priority ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY project_issues_priority ASC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 485681
SELECT n.nid, r.tid, n.title, n.type, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != XXX, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments, f.tid AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON n.nid = l.nid INNER JOIN users cu ON l.last_comment_uid = cu.uid INNER JOIN term_node r ON n.vid = r.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN forum f ON n.vid = f.vid WHERE n.status = XXX AND r.tid = XXX ORDER BY n.sticky DESC, l.comment_count ASC, n.created DESC LIMIT XXX, XXX;

SELECT n.nid, r.tid, n.title, n.type, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments, f.tid AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON n.nid = l.nid INNER JOIN users cu ON l.last_comment_uid = cu.uid INNER JOIN term_node r ON n.vid = r.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN forum f ON n.vid = f.vid WHERE n.status = 1 AND r.tid = 22 ORDER BY n.sticky DESC, l.comment_count ASC, n.created DESC LIMIT 0, 25;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 991013
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.vid = r.vid WHERE n.status = XXX GROUP BY r.tid;

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.vid = r.vid WHERE n.status = 1 GROUP BY r.tid;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 459272
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX')) AND (project_issues.category in ('XXX'))
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4')) AND (project_issues.category in ('bug'))
   ORDER BY node_comment_statistics_last_comment_timestamp DESC
 LIMIT 0, 50;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 182922
SELECT DISTINCT m.*, u.name, u.uid FROM cvs_messages m INNER JOIN cvs_files f ON m.cid = f.cid INNER JOIN users u ON m.uid = u.uid WHERE f.branch = 'XXX' ORDER BY m.created DESC LIMIT XXX, XXX;

SELECT DISTINCT m.*, u.name, u.uid FROM cvs_messages m INNER JOIN cvs_files f ON m.cid = f.cid INNER JOIN users u ON m.uid = u.uid WHERE f.branch = 'DRUPAL-5' ORDER BY m.created DESC LIMIT 0, 10;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 485681
SELECT n.nid, r.tid, n.title, n.type, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != XXX, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments, f.tid AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON n.nid = l.nid INNER JOIN users cu ON l.last_comment_uid = cu.uid INNER JOIN term_node r ON n.vid = r.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN forum f ON n.vid = f.vid WHERE n.status = XXX AND r.tid = XXX ORDER BY n.sticky DESC, n.title ASC, n.created DESC LIMIT XXX, XXX;

SELECT n.nid, r.tid, n.title, n.type, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments, f.tid AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON n.nid = l.nid INNER JOIN users cu ON l.last_comment_uid = cu.uid INNER JOIN term_node r ON n.vid = r.vid INNER JOIN users u ON n.uid = u.uid INNER JOIN forum f ON n.vid = f.vid WHERE n.status = 1 AND r.tid = 22 ORDER BY n.sticky DESC, n.title ASC, n.created DESC LIMIT 0, 25;


|||||| 1 Query 
|||||| Total time: 2, Average time: 2
|||||| Taking 2  seconds to complete
|||||| Rows analyzed 655815
SELECT node.nid AS nid,
   node_project_issues_XXX.title AS node_project_issues_XXX_title,
   node_project_issues_XXX.nid AS node_project_issues_XXX_nid,
   node_project_issues_XXX__project_projects.uri AS node_project_issues_XXX__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_XXX ON project_issues.pid = node_project_issues_XXX.nid
 LEFT JOIN project_projects node_project_issues_XXX__project_projects ON node_project_issues_XXX.nid = node_project_issues_XXX__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('XXX')) AND (node.status <> XXX OR node.uid = XXX or XXX = XXX) AND (project_issues.sid in ('XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', 'XXX'))
   ORDER BY node_project_issues_XXX_title ASC
 LIMIT XXX, XXX;

SELECT node.nid AS nid,
   node_project_issues_1.title AS node_project_issues_1_title,
   node_project_issues_1.nid AS node_project_issues_1_nid,
   node_project_issues_1__project_projects.uri AS node_project_issues_1__project_projects_uri,
   node.title AS node_title,
   project_issues.sid AS project_issues_sid,
   project_issues.priority AS project_issues_priority,
   project_issues.category AS project_issues_category,
   node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
   node.type AS node_type,
   node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp,
   users_project_issues.name AS users_project_issues_name,
   users_project_issues.uid AS users_project_issues_uid
 FROM node node 
 LEFT JOIN project_issues project_issues ON node.nid = project_issues.nid
 LEFT JOIN users users_project_issues ON project_issues.assigned = users_project_issues.uid
 LEFT JOIN node node_project_issues ON project_issues.rid = node_project_issues.nid
 LEFT JOIN node node_project_issues_1 ON project_issues.pid = node_project_issues_1.nid
 LEFT JOIN project_projects node_project_issues_1__project_projects ON node_project_issues_1.nid = node_project_issues_1__project_projects.nid
 LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 WHERE (node.type in ('project_issue')) AND (node.status <> 0 OR node.uid = 227 or 1 = 1) AND (project_issues.sid in ('1', '16', '8', '13', '14', '15', '2', '4'))
   ORDER BY node_project_issues_1_title ASC
 LIMIT 0, 50;