SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    562, 563, 592, 567, 628, 629, 611, 613, 
    612, 18, 564, 550, 614, 549, 553, 610, 
    557, 584, 574, 569, 554, 585, 586, 583, 
    639, 623, 603, 579, 571, 582, 576, 606, 
    607, 608, 577, 570, 573, 605, 617, 615, 
    555, 625, 637, 645, 588, 640, 620, 590, 
    591, 599, 644, 634, 618, 619, 621, 566, 
    575, 604, 565, 616, 627, 633, 589, 578, 
    561, 602, 601, 568, 596, 632, 600, 630, 
    642, 572, 551, 560, 556, 622, 626, 548, 
    587, 638, 595, 624, 646, 580, 597, 593, 
    594, 581, 631, 558, 598, 552, 635, 559, 
    641, 609, 643, 636, 15, 16, 17
  )

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "31.66"
    },
    "table": {
      "table_name": "cscart_product_features",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 132,
      "rows_produced_per_join": 102,
      "filtered": "78.03",
      "cost_info": {
        "read_cost": "11.06",
        "eval_cost": "20.60",
        "prefix_cost": "31.66",
        "data_read_per_join": "121K"
      },
      "used_columns": [
        "feature_id",
        "feature_type"
      ],
      "attached_condition": "(`danishecarter_21_apr`.`cscart_product_features`.`feature_id` in (562,563,592,567,628,629,611,613,612,18,564,550,614,549,553,610,557,584,574,569,554,585,586,583,639,623,603,579,571,582,576,606,607,608,577,570,573,605,617,615,555,625,637,645,588,640,620,590,591,599,644,634,618,619,621,566,575,604,565,616,627,633,589,578,561,602,601,568,596,632,600,630,642,572,551,560,556,622,626,548,587,638,595,624,646,580,597,593,594,581,631,558,598,552,635,559,641,609,643,636,15,16,17))"
    }
  }
}