id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	team_player	index_merge	idx-team_player-team_id,idx-team_player-player_id	idx-team_player-player_id,idx-team_player-team_id	4,4	NULL	1	Using intersect(idx-team_player-player_id,idx-team_player-team_id); Using where; Using filesort