| phpbb_banlist | CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) unsigned NOT NULL default '0',
  `ban_ip` varchar(40) collate utf8_bin NOT NULL default '',
  `ban_email` varchar(100) collate utf8_bin NOT NULL default '',
  `ban_start` int(11) unsigned NOT NULL default '0',
  `ban_end` int(11) unsigned NOT NULL default '0',
  `ban_exclude` tinyint(1) unsigned NOT NULL default '0',
  `ban_reason` varchar(255) collate utf8_bin NOT NULL default '',
  `ban_give_reason` varchar(255) collate utf8_bin NOT NULL default '', echo "hola"
  PRIMARY KEY  (`ban_id`),
  KEY `ban_end` (`ban_end`),
  KEY `ban_user` (`ban_userid`,`ban_exclude`),
  KEY `ban_email` (`ban_email`,`ban_exclude`),
  KEY `ban_ip` (`ban_ip`,`ban_exclude`),
  KEY `ban_email_user_exclude_idx` (`ban_userid`,`ban_email`,`ban_exclude`),
  KEY `ban_email_user_ip_exclude` (`ban_userid`,`ban_email`,`ban_ip`,`ban_exclude`)
) ENGINE=InnoDB AUTO_INCREMENT=5176 DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
+

mysql> explain SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end                         FROM phpbb_banlist WHERE (ban_email = '' AND ban_userid = 6974414) OR (ban_email = '' AND ban_ip <> '');
+----+-------------+---------------+------+--------------------------------------------------------------------------------+-----------+---------+-------+------+-------------+
| id | select_type | table         | type | possible_keys                                                                  | key       | key_len | ref   | rows | Extra       |
+----+-------------+---------------+------+--------------------------------------------------------------------------------+-----------+---------+-------+------+-------------+
|  1 | SIMPLE      | phpbb_banlist | ref  | ban_user,ban_email,ban_ip,ban_email_user_exclude_idx,ban_email_user_ip_exclude | ban_email | 302     | const | 2048 | Using where |
+----+-------------+---------------+------+--------------------------------------------------------------------------------+-----------+---------+-------+------+-------------+
1 row in set (0.00 sec)


mysql> explain SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end                         FROM phpbb_banlist USE INDEX(ban_email_user_exclude_idx) WHERE (ban_email = '' AND ban_userid = 6974414) OR (ban_email = '' AND ban_ip <> '');
+----+-------------+---------------+------+----------------------------+------+---------+------+------+-------------+
| id | select_type | table         | type | possible_keys              | key  | key_len | ref  | rows | Extra       |
+----+-------------+---------------+------+----------------------------+------+---------+------+------+-------------+
|  1 | SIMPLE      | phpbb_banlist | ALL  | ban_email_user_exclude_idx | NULL | NULL    | NULL | 4097 | Using where |
+----+-------------+---------------+------+----------------------------+------+---------+------+------+-------------+
1 row in set (0.01 sec)