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 (
    69717, 69718, 69727, 69726, 69725, 69724, 
    69723, 69722, 69721, 69720, 69719, 
    69728, 69737, 69736, 69735, 69734, 
    69733, 69732, 69731, 69730, 69729, 
    69738, 69742, 69741, 69740, 69739, 
    69743, 69744, 69745, 69746, 69747, 
    69749, 69748, 69750, 69754, 69753, 
    69752, 69751, 69755, 69762, 69761, 
    69760, 69759, 69758, 69757, 69756, 
    69763, 69767, 69766, 69765, 69764, 
    69768, 69773, 69772, 69771, 69770, 
    69769, 69774, 69778, 69777, 69776, 
    69775, 69779, 78631, 78638, 78632, 
    78633, 78634, 78635, 78636, 78637, 
    78640, 78639, 78641, 78642, 78643, 
    78644, 78645, 78649, 78648, 78647, 
    78646, 78651, 78653, 78652, 78654, 
    78656, 78655, 78660, 78661, 78666, 
    78665, 78664, 78663, 78662, 78667
  )

Query time 0.02289

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": 96,
          "filtered": 100,
          "index_condition": "pfv.variant_id in (69717,69718,69727,69726,69725,69724,69723,69722,69721,69720,69719,69728,69737,69736,69735,69734,69733,69732,69731,69730,69729,69738,69742,69741,69740,69739,69743,69744,69745,69746,69747,69749,69748,69750,69754,69753,69752,69751,69755,69762,69761,69760,69759,69758,69757,69756,69763,69767,69766,69765,69764,69768,69773,69772,69771,69770,69769,69774,69778,69777,69776,69775,69779,78631,78638,78632,78633,78634,78635,78636,78637,78640,78639,78641,78642,78643,78644,78645,78649,78648,78647,78646,78651,78653,78652,78654,78656,78655,78660,78661,78666,78665,78664,78663,78662,78667)"
        }
      },
      {
        "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'"
        }
      }
    ]
  }
}