mysql> explain SELECT * FROM bw_thread WHERE thread_parent = 'X';
+----+-------------+-----------+------+---------------+------+---------+------+-------+-------------+
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+------+---------------+------+---------+------+-------+-------------+
1 | SIMPLE | bw_thread | ALL | NULL | NULL | NULL | NULL | 27835 | Using where |
+----+-------------+-----------+------+---------------+------+---------+------+-------+-------------+
Very on top of the SQL query list on the profileinfo of translatewiki.net
Version: master
Severity: normal