SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    235, 216, 204, 242, 229, 222, 251, 210, 
    167, 168, 198, 166, 212, 176, 178, 190, 
    224, 255, 246, 182, 175, 230, 220, 252, 
    197, 211, 213, 236, 185, 169, 243, 191, 
    247, 209, 217, 203, 225, 193, 223, 199, 
    215, 221, 214, 231, 240, 208, 179, 249, 
    253, 226, 186, 218, 174, 244, 234, 194, 
    200, 180, 238, 232, 202, 227, 248, 187, 
    181, 195, 177, 228, 237, 196, 188, 241, 
    254, 189, 245, 250, 165, 170, 171, 172, 
    201, 263
  )

Query time 0.00049

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_categories ALL parent 83 Using where

Result

category_id parent_id
165 167
167 166
168 167
169 167
170 167
171 167
172 167
174 166
175 166
176 175
177 166
178 177
179 177
180 177
181 177
182 177
199 196
185 175
186 175
187 175
188 175
189 175
190 174
191 174
194 174
193 174
195 174
196 166
197 196
198 196
200 196
201 167
202 175
204 203
211 203
212 211
208 204
209 204
210 204
213 211
214 211
215 203
216 215
217 215
218 215
224 223
225 223
226 223
227 223
229 228
230 228
231 228
232 228
234 166
235 234
236 234
237 234
238 234
240 234
242 241
243 241
244 241
246 245
247 245
248 245
249 245
251 250
252 250
253 250
254 166
255 263
263 254