id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_referee	ref	idx-stats_referee-tournament_id	idx-stats_referee-tournament_id	4	const	1	Using where; Using temporary; Using filesort