# Time: 070209 11:42:24
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 25  Rows_examined: 121730
SELECT n.nid, f.tid, n.title, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments FROM node_comment_statistics l, users cu, term_node r, users u, forum f, node n WHERE n.status = 1 AND l.last_comment_uid = cu.uid AND n.nid = l.nid AND n.nid = r.nid AND r.tid = 5 AND n.uid = u.uid AND n.vid = f.vid ORDER BY n.sticky DESC, l.last_comment_timestamp DESC, n.created DESC LIMIT 775, 25;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 25  Rows_examined: 121705
SELECT n.nid, f.tid, n.title, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments FROM node_comment_statistics l, users cu, term_node r, users u, forum f, node n WHERE n.status = 1 AND l.last_comment_uid = cu.uid AND n.nid = l.nid AND n.nid = r.nid AND r.tid = 5 AND n.uid = u.uid AND n.vid = f.vid ORDER BY n.sticky DESC, l.last_comment_timestamp DESC, n.created DESC LIMIT 750, 25;
# Time: 070209 11:42:25
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 25  Rows_examined: 121705
SELECT n.nid, f.tid, n.title, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments FROM node_comment_statistics l, users cu, term_node r, users u, forum f, node n WHERE n.status = 1 AND l.last_comment_uid = cu.uid AND n.nid = l.nid AND n.nid = r.nid AND r.tid = 5 AND n.uid = u.uid AND n.vid = f.vid ORDER BY n.sticky DESC, l.last_comment_timestamp DESC, n.created DESC LIMIT 750, 25;
# Time: 070209 11:42:27
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 3  Lock_time: 0  Rows_sent: 17270  Rows_examined: 86380
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 5 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# Time: 070209 11:42:32
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 12  Lock_time: 0  Rows_sent: 10  Rows_examined: 134432
SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n  INNER JOIN term_node tn0 ON n.nid = tn0.nid WHERE n.status = 1 AND n.moderate = 0  AND tn0.tid IN (6) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10;
# Time: 070209 11:42:33
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 12  Lock_time: 0  Rows_sent: 28560  Rows_examined: 236739
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# Time: 070209 11:42:34
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 28560  Rows_examined: 236739
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 28560  Rows_examined: 236739
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# Time: 070209 11:42:35
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 10  Rows_examined: 134432
SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n  INNER JOIN term_node tn0 ON n.nid = tn0.nid WHERE n.status = 1 AND n.moderate = 0  AND tn0.tid IN (6) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 15  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# Time: 070209 11:42:36
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# Time: 070209 11:42:39
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# Time: 070209 11:42:40
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 5  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# Time: 070209 11:42:41
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 5  Lock_time: 0  Rows_sent: 2  Rows_examined: 97044
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('12','13','16'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 14  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# Time: 070209 11:42:42
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 9  Lock_time: 0  Rows_sent: 2  Rows_examined: 252416
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node  LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (term_node.tid IN ('5','6'))  ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 2;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 13  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# Time: 070209 11:42:43
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 11  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 10  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# Time: 070209 11:42:44
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 10  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 9  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 9  Lock_time: 0  Rows_sent: 21497  Rows_examined: 215550
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 12 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 12  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 11  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;
# Time: 070209 11:42:45
# User@Host: drupaldb[drupaldb] @  [xxx.xxx.xx.xx]
# Query_time: 10  Lock_time: 0  Rows_sent: 28561  Rows_examined: 236742
SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, l.last_comment_timestamp desc;