id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	stage	NULL	ALL	PRIMARY	NULL	NULL	NULL	15	100	Using filesort
1	SIMPLE	<subquery2>	NULL	eq_ref	<auto_distinct_key>	<auto_distinct_key>	5	playtennis_dev.stage.id	1	100	NULL
2	MATERIALIZED	tournament_stage_games	NULL	ref	fk_tournament_stage_games_tournament_id,fk_tournament_stage_games_use_stage_id,fk_tournament_stage_games_match_id	fk_tournament_stage_games_tournament_id	5	const	21	90	Using where