id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	<subquery2>	NULL	ALL	NULL	NULL	NULL	NULL	NULL	100	Using where; Using temporary; Using filesort
1	SIMPLE	stage	NULL	eq_ref	PRIMARY	PRIMARY	4	<subquery2>.use_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	3	90	Using where