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 (
    71341, 71339, 71338, 71337, 71336, 71335, 
    71334, 71333, 71332, 71331, 71342, 
    71732, 71733, 71734, 71735, 71736, 
    71800, 71799, 71798, 71843, 71842, 
    71841, 71840, 71839, 72227, 72226, 
    72224, 72223, 72794, 72795, 73332, 
    73331, 73333, 77936, 77934, 77935, 
    77945, 77943, 77944, 82164, 82154, 
    82162, 82160, 82158, 82167, 82166, 
    82165, 82207, 82217, 82218, 82219, 
    82220, 82222, 82223, 82224, 82208, 
    82209, 82210, 82211, 82212, 82213, 
    82214, 82216, 82616, 82625, 82626, 
    82627, 82628, 82629, 82630, 82631, 
    82632, 82617, 82618, 82619, 82620, 
    82621, 82622, 82623, 82624, 82636, 
    82652, 82645, 82653, 82654, 82655, 
    82656, 82646, 82649, 82650, 82651, 
    82647, 82637, 82638, 82639, 82640, 
    82641, 82642, 82643, 82644, 84249, 
    84251, 84252, 84253, 84254, 84255, 
    84250, 86594, 86595, 87282, 87278, 
    87281, 87280, 87279, 87711, 87712, 
    87713
  )

Query time 0.03227

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": 117,
          "filtered": 100,
          "index_condition": "pfv.variant_id in (71341,71339,71338,71337,71336,71335,71334,71333,71332,71331,71342,71732,71733,71734,71735,71736,71800,71799,71798,71843,71842,71841,71840,71839,72227,72226,72224,72223,72794,72795,73332,73331,73333,77936,77934,77935,77945,77943,77944,82164,82154,82162,82160,82158,82167,82166,82165,82207,82217,82218,82219,82220,82222,82223,82224,82208,82209,82210,82211,82212,82213,82214,82216,82616,82625,82626,82627,82628,82629,82630,82631,82632,82617,82618,82619,82620,82621,82622,82623,82624,82636,82652,82645,82653,82654,82655,82656,82646,82649,82650,82651,82647,82637,82638,82639,82640,82641,82642,82643,82644,84249,84251,84252,84253,84254,84255,84250,86594,86595,87282,87278,87281,87280,87279,87711,87712,87713)"
        }
      },
      {
        "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'"
        }
      }
    ]
  }
}