id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tournament	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
1	SIMPLE	tournament_team_player	ref	tournament_team_player-unique,tournament_team_player-tournament_id	tournament_team_player-unique	4	const	11	Using index condition; Using where