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 = 6974666 OR 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 | 302     | const | 2032 | Using where |
+----+-------------+---------------+------+---------------------------+-----------+---------+-------+------+-------------+