SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    396, 397, 320, 360, 398, 373, 387, 374, 
    388, 401, 322, 364, 327, 402, 361, 381, 
    382, 330, 336, 352, 348, 367, 405, 356, 
    317, 409, 341, 302, 413, 310, 393, 376, 
    334, 400, 299, 313, 304, 407, 418, 363, 
    391, 331, 337, 362, 349, 368, 342, 357, 
    410, 318, 321, 415, 416, 325, 389, 365, 
    328, 366, 419, 377, 300, 394, 408, 311, 
    335, 404, 305, 358, 411, 332, 338, 350, 
    369, 343, 319, 326, 329, 372, 420, 395, 
    345, 314, 359, 351, 339, 355, 344, 370, 
    421, 315, 346, 371, 340, 316, 380, 347, 
    422, 423, 424, 425, 426, 428, 429, 430, 
    431, 432, 433, 298, 434, 301, 435, 303, 
    309, 312, 333, 375, 392, 399, 403, 406, 
    412, 414, 417, 436
  )

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "30.49"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": [
        "parent"
      ],
      "rows_examined_per_scan": 125,
      "rows_produced_per_join": 125,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "5.49",
        "eval_cost": "25.00",
        "prefix_cost": "30.49",
        "data_read_per_join": "511K"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`cscart`.`cscart_categories`.`parent_id` in (396,397,320,360,398,373,387,374,388,401,322,364,327,402,361,381,382,330,336,352,348,367,405,356,317,409,341,302,413,310,393,376,334,400,299,313,304,407,418,363,391,331,337,362,349,368,342,357,410,318,321,415,416,325,389,365,328,366,419,377,300,394,408,311,335,404,305,358,411,332,338,350,369,343,319,326,329,372,420,395,345,314,359,351,339,355,344,370,421,315,346,371,340,316,380,347,422,423,424,425,426,428,429,430,431,432,433,298,434,301,435,303,309,312,333,375,392,399,403,406,412,414,417,436))"
    }
  }
}