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)