Anonymous

mysql> explain SELECT sql_no_cache p.*, m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number, m.signature, m.website,m.yahoo,m.title,m.hide_email,m.msnname, g.g_id, g.g_title, g.g_icon FROM aposts p LEFT JOIN amembers m ON (p.author_id=m.id) LEFT JOIN agroups g ON (g.g_id=m.mgroup) WHERE p.topic_id='79513' and p.queued !='1' ORDER BY p.pid LIMIT 1;
+----+-------------+-------+--------+---------------+----------+---------+--------------------+------+-----------------------------+
| id | select_type | table | type   | possible_keys | key      | key_len | ref                | rows | Extra                       |
+----+-------------+-------+--------+---------------+----------+---------+--------------------+------+-----------------------------+
|  1 | SIMPLE      | p     | ref    | topic_id      | topic_id | 4       | const              | 1182 | Using where; Using filesort |
|  1 | SIMPLE      | m     | eq_ref | PRIMARY       | PRIMARY  | 3       | v101_1.p.author_id |    1 |                             |
|  1 | SIMPLE      | g     | eq_ref | PRIMARY       | PRIMARY  | 4       | v101_1.m.mgroup    |    1 |                             |
+----+-------------+-------+--------+---------------+----------+---------+--------------------+------+-----------------------------+
3 rows in set (0.00 sec)

mysql> explain SELECT sql_no_cache p.*, m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number, m.signature, m.website,m.yahoo,m.title,m.hide_email,m.msnname, g.g_id, g.g_title, g.g_icon FROM aposts p LEFT JOIN amembers m ON (p.author_id=m.id) LEFT JOIN agroups g ON (g.g_id=m.mgroup) WHERE p.topic_id='79513' and p.queued !='1' ORDER BY p.pid;
+----+-------------+-------+--------+---------------+----------+---------+--------------------+------+-----------------------------+
| id | select_type | table | type   | possible_keys | key      | key_len | ref                | rows | Extra                       |
+----+-------------+-------+--------+---------------+----------+---------+--------------------+------+-----------------------------+
|  1 | SIMPLE      | p     | ref    | topic_id      | topic_id | 4       | const              | 1183 | Using where; Using filesort |
|  1 | SIMPLE      | m     | eq_ref | PRIMARY       | PRIMARY  | 3       | v101_1.p.author_id |    1 |                             |
|  1 | SIMPLE      | g     | eq_ref | PRIMARY       | PRIMARY  | 4       | v101_1.m.mgroup    |    1 |                             |
+----+-------------+-------+--------+---------------+----------+---------+--------------------+------+-----------------------------+
3 rows in set (0.00 sec)