SELECT 
  id_path 
FROM 
  cscart_categories 
WHERE 
  category_id IN (
    6, 48, 49, 51, 53, 55, 56, 57, 60, 61, 62, 
    64, 65, 67, 68, 69, 70, 71, 73, 74, 75, 
    76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 
    87, 88, 89, 90, 91, 119, 122, 181, 192, 
    200, 226, 244, 254, 273, 281, 304, 306
  )

Query time 0.00060

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY"],
      "rows": 240,
      "filtered": 20,
      "attached_condition": "cscart_categories.category_id in (6,48,49,51,53,55,56,57,60,61,62,64,65,67,68,69,70,71,73,74,75,76,77,79,80,81,82,83,84,85,86,87,88,89,90,91,119,122,181,192,200,226,244,254,273,281,304,306)"
    }
  }
}