id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	match_red_card	ref	idx-match_red_card-match_id,idx-match_red_card-player_id	idx-match_red_card-match_id	4	const	1	Using where