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

Query time 0.00040

JSON explain

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