SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    79, 
    70, 
    114, 
    121, 
    154, 
    35, 
    126, 
    97, 
    44, 
    132, 
    136, 
    105, 
    146, 
    62, 
    102, 
    86, 
    161, 
    34, 
    80, 
    106, 
    162, 
    64, 
    87, 
    98, 
    133, 
    147, 
    115, 
    36, 
    137, 
    75, 
    45, 
    122, 
    155, 
    103, 
    125, 
    43, 
    99, 
    163, 
    72, 
    63, 
    81, 
    156, 
    37, 
    46, 
    138, 
    116, 
    127, 
    107, 
    148, 
    123, 
    88, 
    134, 
    60, 
    82, 
    135, 
    164, 
    71, 
    149, 
    108, 
    65, 
    61, 
    157, 
    100, 
    89, 
    139, 
    38, 
    117, 
    128, 
    47, 
    90, 
    109, 
    83, 
    66, 
    129, 
    48, 
    165, 
    73, 
    118, 
    69, 
    39, 
    140, 
    150, 
    166, 
    151, 
    76, 
    67, 
    84, 
    130, 
    160, 
    91, 
    40, 
    49, 
    141, 
    110, 
    111, 
    85, 
    41, 
    74, 
    142, 
    167, 
    68, 
    152, 
    50, 
    92, 
    95, 
    168, 
    42, 
    112, 
    153, 
    51, 
    159, 
    93, 
    143, 
    144, 
    169, 
    96, 
    94, 
    77, 
    52, 
    53, 
    101, 
    145, 
    170, 
    104, 
    171, 
    158, 
    54, 
    172, 
    55, 
    113, 
    173, 
    56, 
    119, 
    174, 
    120, 
    57, 
    124, 
    58, 
    175, 
    131, 
    59, 
    78
  )

Query time 0.00125

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": ["parent"],
      "rows": 142,
      "filtered": 100,
      "attached_condition": "cscart_categories.parent_id in (79,70,114,121,154,35,126,97,44,132,136,105,146,62,102,86,161,34,80,106,162,64,87,98,133,147,115,36,137,75,45,122,155,103,125,43,99,163,72,63,81,156,37,46,138,116,127,107,148,123,88,134,60,82,135,164,71,149,108,65,61,157,100,89,139,38,117,128,47,90,109,83,66,129,48,165,73,118,69,39,140,150,166,151,76,67,84,130,160,91,40,49,141,110,111,85,41,74,142,167,68,152,50,92,95,168,42,112,153,51,159,93,143,144,169,96,94,77,52,53,101,145,170,104,171,158,54,172,55,113,173,56,119,174,120,57,124,58,175,131,59,78)"
    }
  }
}

Result

category_id parent_id
53 43
51 43
52 43
35 34
36 34
37 34
38 34
39 34
40 34
41 34
42 34
44 43
45 43
46 43
47 43
48 43
49 43
50 43
54 43
55 43
56 43
57 43
58 43
59 43
62 61
63 61
64 61
65 61
66 61
67 61
68 61
70 69
71 69
72 69
73 69
74 69
75 69
76 69
77 69
79 78
80 78
81 78
82 78
83 78
84 78
86 85
87 85
88 85
89 85
90 85
91 85
92 85
93 85
94 85
97 96
98 96
99 96
100 96
102 101
103 101
105 104
106 104
107 104
108 104
109 104
110 104
111 104
112 104
114 113
115 113
116 113
117 113
118 113
121 120
122 120
123 120
125 124
126 124
127 124
128 124
129 124
130 124
132 131
133 131
134 131
135 131
136 60
137 60
138 60
139 60
140 60
141 60
142 60
143 60
144 60
145 60
146 95
147 95
148 95
149 95
150 95
151 95
152 95
153 95
154 119
155 119
156 119
157 119
158 60
159 69
161 160
162 160
163 160
164 160
165 160
166 160
167 160
168 160
169 160
170 160
171 160
172 160
173 160
174 160
175 160