id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	round	ALL	PRIMARY	NULL	NULL	NULL	1029	Using where; Using temporary; Using filesort
1	SIMPLE	match	ref	idx-match-round_id,idx-match-team1_id,idx-match-team2_id	idx-match-round_id	4	bsr.round.round_id	3	Using where