id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	tournaments	NULL	ref	idx_tournaments_status	idx_tournaments_status	2	const	67	42.92	Using where
1	PRIMARY	<subquery7>	NULL	eq_ref	<auto_distinct_key>	<auto_distinct_key>	5	playtennis_dev.tournaments.id	1	100	Using where; Not exists
1	PRIMARY	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
3	SUBQUERY	tournament_has_players_double	NULL	ALL	PRIMARY	NULL	NULL	NULL	4	25	Using where
2	SUBQUERY	tournaments_has_profiles	NULL	ALL	PRIMARY	NULL	NULL	NULL	478	10	Using where