id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	balls	NULL	ALL	NULL	NULL	NULL	NULL	4	100	Using where; Using filesort
3	SUBQUERY	tournaments	NULL	ref	idx_tournaments_status,fk_tournaments_ball_id	idx_tournaments_status	2	const	67	29.53	Using where
3	SUBQUERY	<subquery7>	NULL	eq_ref	<auto_distinct_key>	<auto_distinct_key>	5	playtennis_dev.tournaments.id	1	100	Using where; Not exists
3	SUBQUERY	tournaments_has_profiles	NULL	ref	PRIMARY	PRIMARY	4	playtennis_dev.tournaments.id	7	100	Using where; Not exists
7	MATERIALIZED	tournament_has_players_double	NULL	ALL	PRIMARY	NULL	NULL	NULL	4	100	Using where
5	SUBQUERY	tournament_has_players_double	NULL	ALL	PRIMARY	NULL	NULL	NULL	4	25	Using where
4	SUBQUERY	tournaments_has_profiles	NULL	ALL	PRIMARY	NULL	NULL	NULL	478	10	Using where
2	SUBQUERY	matches	NULL	ALL	fk_matches_tournament_id,idx_matches_status,fk_matches_ball_id	NULL	NULL	NULL	10	33.33	Using where