id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	match	ALL	NULL	NULL	NULL	NULL	7344	Using where; Using temporary; Using filesort
1	SIMPLE	match_series	eq_ref	PRIMARY	PRIMARY	4	bsr.match.series_id	1	Using where
1	SIMPLE	round_tour	eq_ref	PRIMARY	PRIMARY	4	bsr.match_series.tour_id	1	NULL