SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    701, 
    706, 
    634, 
    402, 
    170, 
    217, 
    179, 
    195, 
    307, 
    494, 
    635, 
    210, 
    341, 
    190, 
    345, 
    349, 
    353, 
    538, 
    269, 
    406, 
    331, 
    319, 
    377, 
    623, 
    327, 
    554, 
    357, 
    363, 
    416, 
    192, 
    632, 
    697, 
    321, 
    177, 
    626, 
    677, 
    412, 
    267, 
    167, 
    171, 
    180, 
    219, 
    196, 
    266, 
    646, 
    495, 
    343, 
    188, 
    348, 
    346, 
    354, 
    411, 
    311, 
    211, 
    206, 
    407, 
    332, 
    320, 
    624, 
    633, 
    328, 
    555, 
    360, 
    364, 
    356, 
    361, 
    415, 
    193, 
    376, 
    322, 
    627, 
    678, 
    667, 
    400, 
    172, 
    181, 
    197, 
    549, 
    324, 
    221, 
    660, 
    496, 
    344, 
    168, 
    165, 
    393, 
    355, 
    540, 
    312, 
    268, 
    212, 
    333, 
    556, 
    362, 
    365, 
    358, 
    414, 
    350, 
    347, 
    323, 
    628, 
    399, 
    169, 
    182, 
    403, 
    661, 
    543, 
    342, 
    382, 
    541, 
    622, 
    334, 
    213, 
    326, 
    329, 
    351, 
    359, 
    366, 
    413, 
    325, 
    409, 
    396, 
    629, 
    639, 
    662, 
    641, 
    243, 
    689, 
    390, 
    647, 
    676, 
    223, 
    542, 
    199, 
    405, 
    335, 
    352, 
    330, 
    214, 
    669, 
    398, 
    185, 
    397, 
    209, 
    194, 
    178, 
    242, 
    218, 
    687, 
    631, 
    204, 
    336, 
    690, 
    191, 
    698, 
    200, 
    215, 
    670, 
    271, 
    640, 
    381, 
    224, 
    203, 
    338, 
    216, 
    201, 
    386, 
    552, 
    226, 
    656, 
    229, 
    245, 
    337, 
    316, 
    208, 
    672, 
    379, 
    264, 
    642, 
    202, 
    685, 
    679, 
    225, 
    340, 
    700, 
    668, 
    711, 
    643, 
    233, 
    696, 
    228, 
    688, 
    395, 
    644, 
    232, 
    391, 
    339, 
    537, 
    539, 
    645, 
    231, 
    383, 
    220, 
    310, 
    657, 
    256, 
    707, 
    234, 
    404, 
    230, 
    658, 
    189, 
    671, 
    712, 
    708, 
    183, 
    686, 
    544
  )

Query time 0.00406

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "53.72"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": [
        "parent"
      ],
      "rows_examined_per_scan": 233,
      "rows_produced_per_join": 233,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "7.12",
        "eval_cost": "46.60",
        "prefix_cost": "53.72",
        "data_read_per_join": "607K"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`ea201_diorama`.`cscart_categories`.`parent_id` in (701,706,634,402,170,217,179,195,307,494,635,210,341,190,345,349,353,538,269,406,331,319,377,623,327,554,357,363,416,192,632,697,321,177,626,677,412,267,167,171,180,219,196,266,646,495,343,188,348,346,354,411,311,211,206,407,332,320,624,633,328,555,360,364,356,361,415,193,376,322,627,678,667,400,172,181,197,549,324,221,660,496,344,168,165,393,355,540,312,268,212,333,556,362,365,358,414,350,347,323,628,399,169,182,403,661,543,342,382,541,622,334,213,326,329,351,359,366,413,325,409,396,629,639,662,641,243,689,390,647,676,223,542,199,405,335,352,330,214,669,398,185,397,209,194,178,242,218,687,631,204,336,690,191,698,200,215,670,271,640,381,224,203,338,216,201,386,552,226,656,229,245,337,316,208,672,379,264,642,202,685,679,225,340,700,668,711,643,233,696,228,688,395,644,232,391,339,537,539,645,231,383,220,310,657,256,707,234,404,230,658,189,671,712,708,183,686,544))"
    }
  }
}

Result

category_id parent_id
679 203
701 179
402 194
179 177
192 191
195 194
210 209
207 204
170 167
217 179
327 326
319 316
321 323
331 319
341 218
345 223
349 224
353 245
357 353
363 355
377 208
406 405
416 412
494 185
307 203
538 202
269 264
626 398
554 214
623 402
190 168
632 190
635 634
697 668
412 177
677 185
267 177
266 264
180 179
167 165
193 191
196 194
206 204
211 209
219 177
171 167
328 326
322 323
320 316
332 319
343 218
346 223
348 224
354 245
356 353
360 354
361 354
364 355
376 208
407 405
415 412
495 185
311 203
411 202
555 214
627 398
624 402
188 168
633 190
646 634
678 185
667 185
400 354
172 167
181 179
168 165
197 194
212 209
221 177
268 204
323 316
324 323
333 319
344 218
347 177
350 224
355 245
358 353
362 354
365 355
393 208
414 412
496 185
312 203
540 202
549 264
556 214
628 398
660 634
399 353
403 264
169 167
182 179
213 209
329 326
325 323
326 316
334 319
342 218
351 224
359 353
366 355
382 177
396 204
409 208
413 412
541 202
543 185
622 203
629 398
661 634
639 634
662 634
641 634
390 264
199 194
214 209
223 224
243 167
330 326
335 319
352 224
405 204
542 202
647 634
669 398
676 208
689 316
397 194
218 177
191 165
200 194
215 209
242 167
336 319
631 190
670 398
687 264
690 316
698 208
201 194
216 209
224 177
271 167
338 319
381 168
630 190
640 634
229 168
245 177
316 203
337 319
379 209
386 194
552 167
656 634
672 190
225 177
317 203
340 319
408 194
642 634
685 190
700 209
228 177
233 168
318 203
643 634
688 190
198 202
232 168
339 319
395 203
391 177
644 634
537 168
231 168
383 177
539 203
645 634
310 203
220 177
256 168
657 634
234 168
404 177
707 203
230 168
189 168
658 634
671 168