id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tournament	ref	PRIMARY,fk-tournament-league-1	fk-tournament-league-1	5	const	24	Using index; Using temporary; Using filesort
1	SIMPLE	game	ref	fk-game-tournament-1	fk-game-tournament-1	5	mobileapi.tournament.tournamentId	46	Using where
1	SIMPLE	host	eq_ref	PRIMARY	PRIMARY	4	mobileapi.game.hostTeamId	1	Using where
1	SIMPLE	guest	eq_ref	PRIMARY	PRIMARY	4	mobileapi.game.guestTeamId	1	Using where