mysql> explain
    -> SELECT /* FlaggedRevs::getRevisionTags AHZ */  fr_tags  FROM `flaggedrevs`  WHERE fr_rev_id = '42275326'  LIMIT 1
    -> ;
+-------------+------+---------------+------+---------+------+--------+-------------+
| table       | type | possible_keys | key  | key_len | ref  | rows   | Extra       |
+-------------+------+---------------+------+---------+------+--------+-------------+
| flaggedrevs | ALL  | NULL          | NULL |    NULL | NULL | 142858 | Using where |
+-------------+------+---------------+------+---------+------+--------+-------------+
1 row in set (0.00 sec)

mysql> show create table flaggedrevs;
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| flaggedrevs | CREATE TABLE `flaggedrevs` (
  `fr_page_id` int(11) NOT NULL default '0',
  `fr_rev_id` int(11) NOT NULL default '0',
  `fr_user` int(5) NOT NULL default '0',
  `fr_timestamp` varchar(14) NOT NULL default '',
  `fr_comment` mediumblob NOT NULL,
  `fr_quality` tinyint(1) NOT NULL default '0',
  `fr_tags` mediumblob NOT NULL,
  `fr_text` mediumblob NOT NULL,
  `fr_flags` tinyblob NOT NULL,
  PRIMARY KEY  (`fr_page_id`,`fr_rev_id`),
  KEY `page_qal_rev` (`fr_page_id`,`fr_quality`,`fr_rev_id`)
) TYPE=InnoDB |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.09 sec)