idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmindex_mergeidx-match-team1_id,idx-match-team2_id,idx-match-start_dtidx-match-team1_id,idx-match-team2_id5,5NULL3Using union(idx-match-team1_id,idx-match-team2_id); Using where; Using filesort