idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmatch_player_statsindex_mergePRIMARY,idx-match_stats-match_id,idx-match_stats-player_ididx-match_stats-player_id,PRIMARY8,4NULL1Using intersect(idx-match_stats-player_id,PRIMARY); Using where