Above problem is solved in PS 5.6.22. Unable to reproduce it. mysql> show create table goods_comments \G *************************** 1. row *************************** Table: goods_comments Create Table: CREATE TABLE `goods_comments` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `text` text NOT NULL COMMENT 'Текст', `created` datetime NOT NULL COMMENT 'Дата создания', `ip` int(11) unsigned NOT NULL COMMENT 'ip', `status` tinyint(3) unsigned NOT NULL COMMENT 'Статус', `record_id` mediumint(8) unsigned NOT NULL, `name` varchar(64) NOT NULL COMMENT 'Имя', `email` varchar(64) NOT NULL COMMENT 'Электронная почта', `user_id` mediumint(8) unsigned NOT NULL, `mark` tinyint(3) unsigned DEFAULT NULL COMMENT 'Оценка товара', `rating` smallint(5) NOT NULL COMMENT 'Рейтинг коментария', `count_voices` smallint(5) unsigned NOT NULL COMMENT 'Общее количество голосов коментария', `summary` varchar(255) NOT NULL COMMENT 'Краткое содержание', `dignity` text NOT NULL COMMENT 'Плюсы', `shortcomings` text NOT NULL COMMENT 'Минусы', `parent_comment_id` int(11) unsigned NOT NULL, `subscribed_on_replies` tinyint(3) unsigned NOT NULL COMMENT 'Подписан на ответы', `positive_vote_count` mediumint(8) unsigned NOT NULL COMMENT 'Количество положительных отзывов', `negative_vote_count` mediumint(8) unsigned NOT NULL COMMENT 'Количество отрицательных отзывов', `percent_dignity` tinyint(3) unsigned NOT NULL COMMENT 'Полезность комментария', `points` smallint(5) NOT NULL COMMENT 'Количество положительных баллов', `service_info` varchar(1024) NOT NULL COMMENT 'Cлужебная информация', `date_approved` datetime NOT NULL COMMENT 'Дата одобрения', `from_buyer` tinyint(3) unsigned NOT NULL COMMENT 'От купившего', `allow_html` tinyint(3) unsigned NOT NULL COMMENT 'Позволять html-теги', `favorite_for_author` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Избранный для автора', `is_answers_readed` tinyint(3) unsigned DEFAULT '0' COMMENT 'Ответы, добавленные после этого коммента прочитанны', `last_readed_answer_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Дата последнего прочитанного комментария', PRIMARY KEY (`record_id`,`id`), KEY `id_index` (`id`), KEY `mark_index` (`mark`), KEY `parent_comment_id_index` (`parent_comment_id`), KEY `status_index` (`status`), KEY `user_id_index` (`user_id`), KEY `record_id_index` (`record_id`), KEY `favorite_for_author_index` (`favorite_for_author`), KEY `user_id_status_index` (`user_id`,`status`) ) ENGINE=InnoDB AUTO_INCREMENT=7519748 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED /*!50100 PARTITION BY HASH (record_id) PARTITIONS 10 */ 1 row in set (0.00 sec) mysql> mysql> select count(*) from goods_comments; +----------+ | count(*) | +----------+ | 2686398 | +----------+ 1 row in set (0.57 sec) mysql> SELECT id, user_id FROM goods_comments WHERE user_id=197827 AND id=5273769; +---------+---------+ | id | user_id | +---------+---------+ | 5273769 | 197827 | +---------+---------+ 1 row in set (0.01 sec) mysql> explain SELECT id, user_id FROM goods_comments WHERE user_id=197827 AND id=5273769; +----+-------------+----------------+------+---------------------------------------------+----------+---------+-------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+----------------+------+---------------------------------------------+----------+---------+-------+------+-------------+ | 1 | SIMPLE | goods_comments | ref | id_index,user_id_index,user_id_status_index | id_index | 4 | const | 8 | Using where | +----+-------------+----------------+------+---------------------------------------------+----------+---------+-------+------+-------------+ 1 row in set (0.00 sec) mysql>