If you have got an account system and you often search your user on their username. Then it would be better to make this an index. This will increase performance 10 times.

PHP Code:
    CREATE INDEX players_user ON players(user); 
If you want to see or drop your one of your indexes
PHP Code:
    SHOW INDEX FROM players;
    DROP INDEX players_user ON players;