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 (
    74801, 74802, 75217, 75216, 75499, 75498, 
    75497, 75496, 75540, 75539, 75544, 
    75543, 78030, 78029, 79581, 79582, 
    79583, 81008, 81009, 81010, 79612, 
    79613, 79616, 79617, 79618, 79619, 
    79620, 79621, 79626, 79627, 79628, 
    79629, 81014, 81002, 81003, 81004, 
    81005, 81006, 81007, 81015, 81016, 
    81035, 81036, 82612, 82613, 82614, 
    82602, 82611, 82615, 82603, 82604, 
    82605, 82606, 82607, 82608, 82609, 
    82610, 84766, 84293, 84547, 84643, 
    84546, 84496, 84495, 84493, 84492, 
    84491, 84490, 84497, 85625, 85620, 
    85623, 85618, 85622, 85619, 85621, 
    85624, 85863, 85872, 85873, 85874, 
    85875, 85876, 85877, 85878, 85879, 
    85880, 85881, 85882, 85864, 85865, 
    85866, 85867, 85868, 85869, 85870, 
    85871, 86298, 86297, 86299, 86606, 
    86607, 86608, 86125, 86126, 86127, 
    86128, 86129, 86130
  )

Query time 0.02211

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": 109,
          "filtered": 100,
          "index_condition": "pfv.variant_id in (74801,74802,75217,75216,75499,75498,75497,75496,75540,75539,75544,75543,78030,78029,79581,79582,79583,81008,81009,81010,79612,79613,79616,79617,79618,79619,79620,79621,79626,79627,79628,79629,81014,81002,81003,81004,81005,81006,81007,81015,81016,81035,81036,82612,82613,82614,82602,82611,82615,82603,82604,82605,82606,82607,82608,82609,82610,84766,84293,84547,84643,84546,84496,84495,84493,84492,84491,84490,84497,85625,85620,85623,85618,85622,85619,85621,85624,85863,85872,85873,85874,85875,85876,85877,85878,85879,85880,85881,85882,85864,85865,85866,85867,85868,85869,85870,85871,86298,86297,86299,86606,86607,86608,86125,86126,86127,86128,86129,86130)"
        }
      },
      {
        "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'"
        }
      }
    ]
  }
}