id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tournaments	NULL	ref	idx_tournaments_status	idx_tournaments_status	2	const	67	100	Using temporary; Using filesort
1	SIMPLE	tournaments_has_profiles	NULL	ref	PRIMARY	PRIMARY	4	playtennis_dev.tournaments.id	7	100	NULL
1	SIMPLE	tournament_has_players_double	NULL	ALL	PRIMARY	NULL	NULL	NULL	4	100	Using where; Using join buffer (hash join)