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 |
+----+-------------+---------------+------+---------------------------+-----------+---------+-------+------+-------------+



# Query_time: 8  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974103 OR ban_ip <> '');
# User@Host: db[db] @  [192.168.100.129]
# Query_time: 5  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6973999 OR ban_ip <> '');
# User@Host: db[db] @  [192.168.100.128]
# Query_time: 19  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974884 OR ban_ip <> '');
# User@Host: db[db] @  [192.168100.129]
# Query_time: 11  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974545 OR ban_ip <> '');
# User@Host: db[db] @  [192.168100.128]
# Query_time: 0  Lock_time: 0  Rows_sent: 89  Rows_examined: 89
SELECT * FROM `atvi_board_cod`.`phpbb_forums`  ORDER BY parent_id ASC, left_id ASC, forum_id ASC;
# User@Host: db[db] @  [192.168.100.121]
# Query_time: 6  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974777 OR ban_ip <> '');
# User@Host: db[db] @  [192.168100.121]
# Query_time: 20  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974743 OR ban_ip <> '');
# User@Host: db[db] @  [192.168.100.121]
# Query_time: 5  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6973968 OR ban_ip <> '');
# User@Host: db[db] @  [192.168.100.121]
# Query_time: 7  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974495 OR ban_ip <> '');
# User@Host: db[db] @  [192.168100.121]
# Query_time: 15  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974783 OR ban_ip <> '');
# User@Host: db[db] @  [192.168.100.129]
# Query_time: 29  Lock_time: 0  Rows_sent: 1609  Rows_examined: 3844
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
                        FROM phpbb_banlist
                        WHERE ban_email = '' AND (ban_userid = 6974396 OR ban_ip <> '');