SELECT 
  product_id, 
  feature_id, 
  variant_id 
FROM 
  cscart_product_features_values 
WHERE 
  product_id IN (
    33723, 34133, 34132, 34131, 34130, 34129, 
    34128, 34127, 34126, 34125, 34124, 
    34123, 34122, 34121, 34120, 34119, 
    34118, 34134, 34135, 34136, 34137, 
    34138, 34139, 34140, 34141, 34142, 
    34143, 34144, 34145, 34146, 34147, 
    34148, 34149, 34150, 34151, 34152, 
    34153, 34154, 34155, 34156, 34157, 
    34158, 34159, 34160, 34161, 34162, 
    34163, 34164, 34165, 34166, 34167, 
    34168, 34169, 34170, 34171, 34172, 
    34173, 34174, 34175, 34176, 34177, 
    34178, 34179, 34180, 34181, 34182, 
    34183, 34184, 34185, 34186, 34187, 
    34188, 34189, 34190, 34191, 34192, 
    34193, 34194, 34195, 34196, 34197, 
    34198, 34199, 34200, 34201
  ) 
  AND feature_id IN (23514, 23512) 
  AND lang_code = 'vi'

Query time 0.03036

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_features_values",
          "access_type": "range",
          "possible_keys": [
            "PRIMARY",
            "fl",
            "lang_code",
            "product_id",
            "fpl",
            "idx_product_feature_variant_id"
          ],
          "key": "idx_product_feature_variant_id",
          "key_length": "12",
          "used_key_parts": ["product_id", "feature_id", "lang_code"],
          "rows": 170,
          "filtered": 100,
          "attached_condition": "cscart_product_features_values.product_id in (33723,34133,34132,34131,34130,34129,34128,34127,34126,34125,34124,34123,34122,34121,34120,34119,34118,34134,34135,34136,34137,34138,34139,34140,34141,34142,34143,34144,34145,34146,34147,34148,34149,34150,34151,34152,34153,34154,34155,34156,34157,34158,34159,34160,34161,34162,34163,34164,34165,34166,34167,34168,34169,34170,34171,34172,34173,34174,34175,34176,34177,34178,34179,34180,34181,34182,34183,34184,34185,34186,34187,34188,34189,34190,34191,34192,34193,34194,34195,34196,34197,34198,34199,34200,34201) and cscart_product_features_values.feature_id in (23514,23512) and cscart_product_features_values.lang_code = 'vi'",
          "using_index": true
        }
      }
    ]
  }
}