Sandbox

SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    118, 1, 130, 59, 131, 4, 132, 19, 23, 136, 
    57, 32, 33, 49, 129, 48, 153, 112, 133, 
    134, 135, 61, 53, 54, 6, 74, 50, 58, 93
  )

Query time 0.00094

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7.00"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": [
        "parent"
      ],
      "rows_examined_per_scan": 59,
      "rows_produced_per_join": 52,
      "filtered": "88.14",
      "cost_info": {
        "read_cost": "1.80",
        "eval_cost": "5.20",
        "prefix_cost": "7.00",
        "data_read_per_join": "238K"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`testdobroded`.`cscart_categories`.`parent_id` in (118,1,130,59,131,4,132,19,23,136,57,32,33,49,129,48,153,112,133,134,135,61,53,54,6,74,50,58,93))"
    }
  }
}

Result

category_id	parent_id
118	32
130	129
131	129
132	129
33	1
49	1
48	1
47	1
46	1
112	1
133	1
60	59
61	59
53	4
52	4
54	4
6	19
74	19
50	23
51	23
81	57
58	57
82	57
84	57
80	57
83	57
93	32
106	32
134	1
135	1
136	129

category_id	parent_id
118	32
130	129
131	129
132	129
33	1
49	1
48	1
47	1
46	1
112	1
133	1
60	59
61	59
53	4
52	4
54	4
6	19
74	19
50	23
51	23
81	57
58	57
82	57
84	57
80	57
83	57
93	32
106	32
134	1
135	1
136	129

category_id	parent_id
118	32
130	129
131	129
132	129
33	1
49	1
48	1
47	1
46	1
112	1
133	1
60	59
61	59
53	4
52	4
54	4
6	19
74	19
50	23
51	23
81	57
58	57
82	57
84	57
80	57
83	57
93	32
106	32
134	1
135	1
136	129

category_id	parent_id
118	32
130	129
131	129
132	129
33	1
49	1
48	1
47	1
46	1
112	1
133	1
60	59
61	59
53	4
52	4
54	4
6	19
74	19
50	23
51	23
81	57
58	57
82	57
84	57
80	57
83	57
93	32
106	32
134	1
135	1
136	129