mysql> show full processlist;
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id   | User   | Host            | db                | Command | Time | State                | Info                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 863 | phpbb3 | localhost:44375 | phpbb3_production | Query   |  663 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS p.topic_id FROM (phpbb_search_wordmatch m0, phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch m3, phpbb_search_wordmatch m4, phpbb_search_wordmatch m5, phpbb_search_wordmatch m6, phpbb_topics t) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE p.topic_id = t.topic_id AND m0.word_id = 23 AND m1.word_id = 68 AND m1.post_id = m0.post_id AND m2.word_id = 171 AND m2.post_id = m0.post_id AND m3.word_id = 453 AND m3.post_id = m0.post_id AND m4.word_id = 1063 AND m4.post_id = m0.post_id AND m5.word_id = 1913 AND m5.post_id = m0.post_id AND m6.word_id = 2231 AND m6.post_id = m0.post_id AND p.post_approved = 1 AND p.forum_id NOT IN (4, 6, 8, 9, 10, 11, 14, 15, 19, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40) GROUP BY p.topic_id, t.topic_last_post_time ORDER BY t.topic_last_post_time DESC
 LIMIT 250                 |

 
 
mysql> show full processlist;
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id   | User   | Host            | db                | Command | Time | State                | Info                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 1486 | phpbb3 | localhost:45739 | phpbb3_production | Query   | 1560 | statistics |SELECT SQL_CALC_FOUND_ROWS p.post_id FROM (phpbb_search_wordmatch m0, phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch m3, phpbb_search_wordmatch m4, phpbb_search_wordmatch m5, phpbb_search_wordmatch m6, phpbb_search_wordmatch m7, phpbb_search_wordmatch m8, phpbb_search_wordmatch m9, phpbb_search_wordmatch m10, phpbb_search_wordmatch m11) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 10 AND m1.word_id = 148 AND m1.post_id = m0.post_id AND m2.word_id = 219 AND m2.post_id = m0.post_id AND m3.word_id = 248 AND m3.post_id = m0.post_id AND m4.word_id = 333 AND m4.post_id = m0.post_id AND m5.word_id = 392 AND m5.post_id = m0.post_id AND m6.word_id = 561 AND m6.post_id = m0.post_id AND m7.word_id = 926 AND m7.post_id = m0.post_id AND m8.word_id = 926 AND m8.post_id = m0.post_id AND m9.word_id = 1308 AND m9.post_id = m0.post_id AND m10.word_id = 1637 AND m10.post_id = m0.post_id AND m11.word_id = 1637 AND m11.post_id = m0.post_id AND p.post_approved = 1 AND p.forum_id NOT IN (6, 8, 9, 10, 11, 15, 19, 28, 35, 36, 37) GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC
 LIMIT 250 |



mysql> show full processlist;
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id   | User   | Host            | db                | Command | Time | State                | Info                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 2013 | phpbb3 | localhost:46983 | phpbb3_production | Query   | 25834 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS p.post_id FROM (phpbb_search_wordmatch m0, phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch m3, phpbb_search_wordmatch m4, phpbb_search_wordmatch m5) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 79 AND m1.word_id = 89 AND m1.post_id = m0.post_id AND m2.word_id = 144 AND m2.post_id = m0.post_id AND m3.word_id = 217 AND m3.post_id = m0.post_id AND m4.word_id = 221 AND m4.post_id = m0.post_id AND m5.word_id = 401 AND m5.post_id = m0.post_id AND p.post_approved = 1 AND p.forum_id NOT IN (6, 8, 9, 10, 11, 15, 19, 28, 35, 36, 37) GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC
 LIMIT 250                                                                             |



mysql> show full processlist;
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id   | User   | Host            | db                | Command | Time | State                | Info                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 2014 | phpbb3 | localhost:46984 | phpbb3_production | Query   | 25909 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS p.post_id FROM (phpbb_search_wordmatch m0, phpbb_search_wordmatch m1, phpbb_search_wordmatch m2, phpbb_search_wordmatch m3, phpbb_search_wordmatch m4, phpbb_search_wordmatch m5, phpbb_search_wordmatch m6) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 79 AND m1.word_id = 89 AND m1.post_id = m0.post_id AND m2.word_id = 143 AND m2.post_id = m0.post_id AND m3.word_id = 144 AND m3.post_id = m0.post_id AND m4.word_id = 217 AND m4.post_id = m0.post_id AND m5.word_id = 221 AND m5.post_id = m0.post_id AND m6.word_id = 401 AND m6.post_id = m0.post_id AND p.post_approved = 1 AND p.forum_id NOT IN (6, 8, 9, 10, 11, 15, 19, 28, 35, 36, 37) GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC
 LIMIT 250 |