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 (
    70064, 70063, 70062, 70061, 70060, 70065, 
    70059, 70094, 70093, 70092, 70091, 
    70095, 70090, 70100, 70099, 70098, 
    70097, 70101, 70096, 71005, 71004, 
    71003, 71002, 71001, 71006, 71124, 
    71123, 71122, 71121, 71120, 71119, 
    71118, 71125, 71132, 71131, 71130, 
    71129, 71128, 71127, 71126, 71133, 
    75113, 75112, 75111, 75110, 75109, 
    75114, 79212, 79213, 79211, 79215, 
    79216, 79214, 79224, 79225, 79223, 
    79237, 79238, 79236, 81927, 81928, 
    81929, 82802, 82809, 82811, 82812, 
    82804, 82805, 82806, 82807, 82793, 
    82794, 82795, 82796, 82797, 82798, 
    82808, 82799, 82800, 82801, 82819, 
    82820, 84318, 84319, 84320, 84321, 
    84422, 84423, 84424, 84425, 84473, 
    84474, 76885, 76884, 85973, 85974, 
    85975, 85976, 85977, 85978, 85979
  )

Query time 0.01179

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": 101,
          "filtered": 100,
          "index_condition": "pfv.variant_id in (70064,70063,70062,70061,70060,70065,70059,70094,70093,70092,70091,70095,70090,70100,70099,70098,70097,70101,70096,71005,71004,71003,71002,71001,71006,71124,71123,71122,71121,71120,71119,71118,71125,71132,71131,71130,71129,71128,71127,71126,71133,75113,75112,75111,75110,75109,75114,79212,79213,79211,79215,79216,79214,79224,79225,79223,79237,79238,79236,81927,81928,81929,82802,82809,82811,82812,82804,82805,82806,82807,82793,82794,82795,82796,82797,82798,82808,82799,82800,82801,82819,82820,84318,84319,84320,84321,84422,84423,84424,84425,84473,84474,76885,76884,85973,85974,85975,85976,85977,85978,85979)"
        }
      },
      {
        "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'"
        }
      }
    ]
  }
}