id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	age_category	NULL	ALL	PRIMARY,idx_age_category_is_active	NULL	NULL	NULL	9	100	Using where; Using temporary; Using filesort
1	SIMPLE	<subquery2>	NULL	eq_ref	<auto_distinct_key>	<auto_distinct_key>	5	playtennis_dev.age_category.id	1	100	NULL
2	MATERIALIZED	tournaments	NULL	ref	fk_tournaments_age_category_id,idx_tournaments_status	idx_tournaments_status	2	const	67	100	NULL
2	MATERIALIZED	tournaments_has_profiles	NULL	ref	PRIMARY	PRIMARY	4	playtennis_dev.tournaments.id	7	100	NULL
2	MATERIALIZED	tournament_has_players_double	NULL	ALL	PRIMARY	NULL	NULL	NULL	4	100	Using where; Using join buffer (hash join)