id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ttr	ALL	tournament_team-unique_pair,tournament_team-tournament_id,tournament_team-team_id	NULL	NULL	NULL	52	Using where; Using temporary; Using filesort
1	SIMPLE	tournament	eq_ref	PRIMARY	PRIMARY	4	bsr.ttr.tournament_id	1	NULL
1	SIMPLE	tournament_team_player	eq_ref	tournament_team_player-unique,tournament_team_player-tournament_id,tournament_team_player-team_id	tournament_team_player-unique	12	bsr.ttr.tournament_id,bsr.ttr.team_id,const	1	Using index