SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    627, 626, 558, 589, 625, 628, 601, 588, 
    552, 561, 553, 562, 566, 583, 598, 597, 
    596, 591, 584, 593, 594, 595, 592, 600, 
    565, 563, 564, 568, 567, 599, 586, 560, 
    572, 580
  )

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_features",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 76,
          "filtered": 44.73684311,
          "attached_condition": "cscart_product_features.feature_id in (627,626,558,589,625,628,601,588,552,561,553,562,566,583,598,597,596,591,584,593,594,595,592,600,565,563,564,568,567,599,586,560,572,580)"
        }
      }
    ]
  }
}