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.
If you want to see or drop your one of your indexesPHP Code:
CREATE INDEX players_user ON players(user);
PHP Code:
SHOW INDEX FROM players;
DROP INDEX players_user ON players;