id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	Using temporary
1	SIMPLE	sp	index_merge	idx-stats_player-stats_layer,idx-stats_player-player_id,idx-stats_player-tournament_id,idx-stats_player-season_id	idx-stats_player-player_id,idx-stats_player-season_id	4,5	NULL	1	Using intersect(idx-stats_player-player_id,idx-stats_player-season_id); Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	bsr.sp.tournament_id	1	Using where