id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
2	SUBQUERY	tournament_has_players_double	NULL	ref	PRIMARY	PRIMARY	4	const	4	75	Using where