SELECT 
  product_id, 
  feature_id, 
  variant_id 
FROM 
  cscart_product_features_values 
WHERE 
  product_id IN (
    7448, 
    7449, 
    7450, 
    7451, 
    7452, 
    7453, 
    7454, 
    7455, 
    7456, 
    7457, 
    7458, 
    7459, 
    7460, 
    7461, 
    7462, 
    7463, 
    7484, 
    7485, 
    7486, 
    7487, 
    7488, 
    7489, 
    7490, 
    7491, 
    2969, 
    2970, 
    2912, 
    6554, 
    2981, 
    6647, 
    3069, 
    6557, 
    6561, 
    2976, 
    6558, 
    2977, 
    2980, 
    6553, 
    6562, 
    2481, 
    6081, 
    6082, 
    2482, 
    2638, 
    6231, 
    2639, 
    6232, 
    6141, 
    2549, 
    6142, 
    2550, 
    6145, 
    2553, 
    6146, 
    2554, 
    2370, 
    5970, 
    5971, 
    2371, 
    2642, 
    6235, 
    6380, 
    6497, 
    2916, 
    6381, 
    6560, 
    6501, 
    2978, 
    6502, 
    6866, 
    2795, 
    6564, 
    2983, 
    6645, 
    6498, 
    2794, 
    6559, 
    2913, 
    2979, 
    2917, 
    3070, 
    3311, 
    6648, 
    6555, 
    3066, 
    6649, 
    2971, 
    6556, 
    2982, 
    6644, 
    6563, 
    3071, 
    3067, 
    2972, 
    6236, 
    2643, 
    2479, 
    6079, 
    6080, 
    2480, 
    2483, 
    6083, 
    6084, 
    2484, 
    3621, 
    421, 
    422, 
    3622, 
    2910, 
    6495, 
    6496, 
    2911, 
    3619, 
    419, 
    420, 
    3620, 
    2636, 
    6229, 
    2637, 
    6230, 
    6139, 
    2547, 
    2914, 
    6499, 
    6500, 
    2915, 
    3064, 
    6140, 
    2548, 
    6143, 
    2551, 
    6144, 
    2552, 
    2368, 
    5968, 
    5969, 
    2369, 
    2640, 
    6233, 
    6234, 
    6642, 
    3065, 
    6643, 
    2792, 
    6378, 
    2641, 
    6379, 
    2477, 
    2793, 
    6077, 
    3068, 
    6078, 
    6646, 
    2478
  ) 
  AND feature_id IN (
    636, 627, 623, 622, 626, 553, 625, 624, 
    628, 595
  ) 
  AND lang_code = 'en'

Query time 0.02516

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "345.45"
    },
    "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",
      "used_key_parts": [
        "product_id",
        "feature_id",
        "lang_code"
      ],
      "key_length": "12",
      "rows_examined_per_scan": 1540,
      "rows_produced_per_join": 1540,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "191.45",
        "eval_cost": "154.00",
        "prefix_cost": "345.45",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "feature_id",
        "product_id",
        "variant_id",
        "lang_code"
      ],
      "attached_condition": "((`gaseus`.`cscart_product_features_values`.`product_id` in (7448,7449,7450,7451,7452,7453,7454,7455,7456,7457,7458,7459,7460,7461,7462,7463,7484,7485,7486,7487,7488,7489,7490,7491,2969,2970,2912,6554,2981,6647,3069,6557,6561,2976,6558,2977,2980,6553,6562,2481,6081,6082,2482,2638,6231,2639,6232,6141,2549,6142,2550,6145,2553,6146,2554,2370,5970,5971,2371,2642,6235,6380,6497,2916,6381,6560,6501,2978,6502,6866,2795,6564,2983,6645,6498,2794,6559,2913,2979,2917,3070,3311,6648,6555,3066,6649,2971,6556,2982,6644,6563,3071,3067,2972,6236,2643,2479,6079,6080,2480,2483,6083,6084,2484,3621,421,422,3622,2910,6495,6496,2911,3619,419,420,3620,2636,6229,2637,6230,6139,2547,2914,6499,6500,2915,3064,6140,2548,6143,2551,6144,2552,2368,5968,5969,2369,2640,6233,6234,6642,3065,6643,2792,6378,2641,6379,2477,2793,6077,3068,6078,6646,2478)) and (`gaseus`.`cscart_product_features_values`.`feature_id` in (636,627,623,622,626,553,625,624,628,595)) and (`gaseus`.`cscart_product_features_values`.`lang_code` = 'en'))"
    }
  }
}