id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	team_player	ref	idx-team_player-team_id,idx-team_player-player_id	idx-team_player-team_id	4	const	14	Using where; Using temporary; Using filesort
1	SIMPLE	player	eq_ref	PRIMARY	PRIMARY	4	bsr.team_player.player_id	1	NULL
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	bsr.team_player.player_id	1	Using index