id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mp	index_merge	idx-match_player-match_id,idx-match_player-team_id,idx-match_player-player_id	idx-match_player-player_id,idx-match_player-team_id	4,4	NULL	1	Using intersect(idx-match_player-player_id,idx-match_player-team_id); Using where; Using temporary; Using filesort
1	SIMPLE	m	eq_ref	PRIMARY,idx-match-round_id	PRIMARY	4	bsr.mp.match_id	1	NULL
1	SIMPLE	r	eq_ref	PRIMARY	PRIMARY	4	bsr.m.round_id	1	Using index
1	SIMPLE	t	eq_ref	PRIMARY,team_season_id	PRIMARY	4	bsr.m.tournament_id	1	Using where