SELECT 
  pfv.variant_id, 
  pfv.position, 
  pfvd.variant 
FROM 
  cscart_product_feature_variants AS pfv 
  INNER JOIN cscart_product_feature_variant_descriptions AS pfvd ON pfv.variant_id = pfvd.variant_id 
  AND pfvd.lang_code = 'vi' 
WHERE 
  pfv.variant_id IN (
    70938, 70937, 70939, 70971, 70970, 70972, 
    74420, 74421, 77472, 77917, 82351, 
    82352, 82353, 82354, 82355, 82356, 
    82362, 82363, 82364, 82365, 82366, 
    82367, 83944, 83945, 83946, 83947, 
    83948, 83949, 83950, 83973, 83972, 
    83971, 83975, 83983, 83974, 83977, 
    83980, 83978, 83981, 83982, 83979, 
    83976, 85457, 85458, 85459, 85460, 
    85461, 85462, 86218, 86219, 86220, 
    86391, 86392, 86393, 86394, 86395, 
    86396, 86397, 86398, 86403, 86404, 
    86405, 86402, 86401, 86493, 86492, 
    87425, 87423, 87424, 87427, 87428, 
    87426
  )

Query time 0.00937

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "pfv",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["variant_id"],
          "rows": 72,
          "filtered": 100,
          "index_condition": "pfv.variant_id in (70938,70937,70939,70971,70970,70972,74420,74421,77472,77917,82351,82352,82353,82354,82355,82356,82362,82363,82364,82365,82366,82367,83944,83945,83946,83947,83948,83949,83950,83973,83972,83971,83975,83983,83974,83977,83980,83978,83981,83982,83979,83976,85457,85458,85459,85460,85461,85462,86218,86219,86220,86391,86392,86393,86394,86395,86396,86397,86398,86403,86404,86405,86402,86401,86493,86492,87425,87423,87424,87427,87428,87426)"
        }
      },
      {
        "table": {
          "table_name": "pfvd",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["variant_id", "lang_code"],
          "ref": ["dev_db.pfv.variant_id", "const"],
          "rows": 1,
          "filtered": 100,
          "index_condition": "pfvd.lang_code = 'vi'"
        }
      }
    ]
  }
}