id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	tournaments	NULL	ALL	NULL	NULL	NULL	NULL	67	100	Using where; Using temporary; Using filesort
6	SUBQUERY	tournament_has_players_double	NULL	ALL	PRIMARY	NULL	NULL	NULL	4	33.33	Using where
5	DEPENDENT SUBQUERY	tournaments_has_profiles	NULL	index_subquery	PRIMARY	PRIMARY	4	func	7	33.33	Using where
3	SUBQUERY	tournament_has_players_double	NULL	index	PRIMARY,fk_tournament_has_players_double_players_double_id	fk_tournament_has_players_double_players_double_id	4	NULL	4	100	Using index
3	SUBQUERY	players_double	NULL	eq_ref	PRIMARY,fk_players_double_player_1_id,fk_players_double_player_2_id	PRIMARY	4	playtennis_dev.tournament_has_players_double.players_double_id	1	43.75	Using where
2	SUBQUERY	tournaments_has_profiles	NULL	ref	PRIMARY,fk_tournaments_has_profiles_profile_id,idx_tournaments_has_profiles_stage_id	fk_tournaments_has_profiles_profile_id	4	const	2	100	Using index