id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	match	range	idx-match-team1_id,idx-match-team2_id,idx-match-start_dt	idx-match-start_dt	6	NULL	1	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	tournament	eq_ref	PRIMARY	PRIMARY	4	bsr.match.tournament_id	1	Using where