idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmatch_playerindex_mergeidx-match_player-match_id,idx-match_player-player_ididx-match_player-match_id,idx-match_player-player_id4,4NULL1Using intersect(idx-match_player-match_id,idx-match_player-player_id); Using where