id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
1	SIMPLE	t	ref	PRIMARY,team_season_id	team_season_id	4	const	1	Using where
1	SIMPLE	st	eq_ref	idx-stats_team-stats_layer,idx-stats_team-team_id,idx-stats_team-tournament_id	idx-stats_team-stats_layer	8	const,bsr.t.tournament_id	1	NULL