SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    627, 626, 558, 589, 625, 628, 601, 588, 
    561, 553, 562, 583, 591, 584, 565, 563, 
    564, 568, 567, 599, 586, 560, 572
  )

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_features",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 76,
          "filtered": 30.2631588,
          "attached_condition": "cscart_product_features.feature_id in (627,626,558,589,625,628,601,588,561,553,562,583,591,584,565,563,564,568,567,599,586,560,572)"
        }
      }
    ]
  }
}