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	players_double	NULL	index_merge	PRIMARY,fk_players_double_player_1_id,fk_players_double_player_2_id	fk_players_double_player_1_id,fk_players_double_player_2_id	4,4	NULL	2	100	Using union(fk_players_double_player_1_id,fk_players_double_player_2_id); Using where
3	SUBQUERY	tournament_has_players_double	NULL	ref	PRIMARY,fk_tournament_has_players_double_players_double_id	fk_tournament_has_players_double_players_double_id	4	playtennis_dev.players_double.id	1	100	Using index
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