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                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+  





mysql> show full processlist;
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id   | User   | Host            | db                | Command | Time | State                | Info                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+  





mysql> show full processlist;
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id   | User   | Host            | db                | Command | Time | State                | Info                                                                                                 |
+------+--------+-----------------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+