SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    467, 
    462, 
    379, 
    323, 
    344, 
    535, 
    493, 
    450, 
    440, 
    522, 
    630, 
    554, 
    556, 
    381, 
    385, 
    167, 
    416, 
    421, 
    441, 
    166, 
    568, 
    546, 
    617, 
    593, 
    560, 
    562, 
    474, 
    514, 
    360, 
    412, 
    393, 
    321, 
    235, 
    659, 
    628, 
    356, 
    362, 
    410, 
    651, 
    542, 
    539, 
    415, 
    305, 
    330, 
    332, 
    371, 
    601, 
    582, 
    341, 
    404, 
    588, 
    459, 
    549, 
    527, 
    453, 
    190, 
    454, 
    414, 
    623, 
    419, 
    357, 
    435, 
    436, 
    534, 
    590, 
    461, 
    463, 
    555, 
    561, 
    563, 
    424, 
    494, 
    569, 
    547, 
    557, 
    594, 
    460, 
    352, 
    536, 
    540, 
    618, 
    326, 
    325, 
    324, 
    245, 
    602, 
    573, 
    331, 
    475, 
    432, 
    394, 
    358, 
    613, 
    622, 
    631, 
    386, 
    382, 
    652, 
    422, 
    361, 
    413, 
    429, 
    485, 
    418, 
    451, 
    336, 
    515, 
    337, 
    455, 
    342, 
    405, 
    550, 
    660, 
    363, 
    411, 
    333, 
    420, 
    516, 
    653, 
    430, 
    251, 
    538, 
    452, 
    619, 
    551, 
    465, 
    584, 
    425, 
    489, 
    343, 
    476, 
    598, 
    372, 
    353, 
    387, 
    383, 
    574, 
    234, 
    603, 
    208, 
    406, 
    334, 
    417, 
    570, 
    571, 
    625, 
    384, 
    591, 
    583, 
    480, 
    236, 
    443, 
    339, 
    340, 
    359, 
    407, 
    595, 
    397, 
    426, 
    544, 
    592, 
    428, 
    483, 
    633, 
    496, 
    469, 
    471, 
    575, 
    505, 
    354, 
    620, 
    517, 
    170, 
    559, 
    545, 
    627, 
    250, 
    487, 
    486, 
    526, 
    369, 
    320, 
    596, 
    355, 
    490, 
    219, 
    626, 
    518, 
    576, 
    528, 
    364, 
    408, 
    399, 
    614, 
    470, 
    624, 
    398, 
    572, 
    497, 
    567, 
    599, 
    322, 
    446, 
    488, 
    634, 
    174, 
    506, 
    648, 
    654, 
    473, 
    457, 
    597, 
    444, 
    579, 
    328, 
    498, 
    395, 
    448, 
    466, 
    491, 
    366, 
    409, 
    525, 
    329, 
    449, 
    580, 
    530, 
    636, 
    532, 
    499, 
    438, 
    439, 
    347, 
    477, 
    615, 
    578, 
    519, 
    552, 
    482, 
    481, 
    616, 
    581, 
    308, 
    531, 
    500, 
    637, 
    566, 
    655, 
    638, 
    621, 
    565, 
    492, 
    464, 
    521, 
    587, 
    502, 
    629, 
    520, 
    639, 
    380, 
    350, 
    228, 
    503, 
    585, 
    640, 
    558, 
    524, 
    650, 
    543, 
    400, 
    523, 
    537, 
    504, 
    586, 
    351, 
    577, 
    641, 
    657, 
    662, 
    507, 
    564, 
    378, 
    401, 
    658, 
    642, 
    402, 
    513, 
    423, 
    643, 
    661, 
    458, 
    553, 
    664, 
    600, 
    644, 
    645, 
    646, 
    647
  ) 
  AND category_id != 264

Query time 0.00264

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.54"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "parent",
        "p_category_id"
      ],
      "rows_examined_per_scan": 347,
      "rows_produced_per_join": 347,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2.84",
        "eval_cost": "34.70",
        "prefix_cost": "37.54",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`parent_id` in (467,462,379,323,344,535,493,450,440,522,630,554,556,381,385,167,416,421,441,166,568,546,617,593,560,562,474,514,360,412,393,321,235,659,628,356,362,410,651,542,539,415,305,330,332,371,601,582,341,404,588,459,549,527,453,190,454,414,623,419,357,435,436,534,590,461,463,555,561,563,424,494,569,547,557,594,460,352,536,540,618,326,325,324,245,602,573,331,475,432,394,358,613,622,631,386,382,652,422,361,413,429,485,418,451,336,515,337,455,342,405,550,660,363,411,333,420,516,653,430,251,538,452,619,551,465,584,425,489,343,476,598,372,353,387,383,574,234,603,208,406,334,417,570,571,625,384,591,583,480,236,443,339,340,359,407,595,397,426,544,592,428,483,633,496,469,471,575,505,354,620,517,170,559,545,627,250,487,486,526,369,320,596,355,490,219,626,518,576,528,364,408,399,614,470,624,398,572,497,567,599,322,446,488,634,174,506,648,654,473,457,597,444,579,328,498,395,448,466,491,366,409,525,329,449,580,530,636,532,499,438,439,347,477,615,578,519,552,482,481,616,581,308,531,500,637,566,655,638,621,565,492,464,521,587,502,629,520,639,380,350,228,503,585,640,558,524,650,543,400,523,537,504,586,351,577,641,657,662,507,564,378,401,658,642,402,513,423,643,661,458,553,664,600,644,645,646,647)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`category_id` <> 264))"
    }
  }
}

Result

category_id parent_id
612 250
493 219
190 174
235 234
381 350
167 166
385 308
379 378
321 320
323 322
330 228
332 245
371 250
341 328
344 329
356 167
357 170
360 359
362 342
393 371
404 402
410 405
412 407
414 351
415 414
416 332
419 333
421 334
436 369
440 251
441 336
450 424
459 384
462 461
560 557
305 458
474 473
514 513
453 372
454 453
467 466
522 521
527 329
535 522
539 538
546 545
549 552
554 553
556 552
562 555
568 406
582 572
588 534
593 592
601 600
494 219
485 458
515 513
386 308
463 461
352 167
382 350
326 234
324 322
325 320
331 228
333 245
336 250
337 174
342 328
345 329
358 170
361 359
363 342
394 371
405 402
411 405
413 407
420 333
422 334
424 423
429 351
432 378
437 369
442 251
451 424
418 332
461 372
475 473
455 453
460 384
534 521
536 522
540 538
547 545
550 552
555 553
557 552
561 557
563 555
569 406
573 466
590 534
594 592
602 600
613 414
516 513
384 372
465 566
417 332
236 234
387 308
234 166
304 250
383 350
353 167
334 245
489 371
339 320
340 322
343 543
346 329
406 402
425 423
430 351
443 378
452 424
251 458
476 473
480 333
538 521
541 538
551 552
570 406
571 545
574 466
583 372
584 572
591 534
598 384
603 600
496 219
487 453
486 174
483 378
505 170
354 167
170 166
320 166
359 328
397 371
407 402
426 424
517 513
428 458
468 329
469 320
471 322
526 170
544 543
545 521
559 234
575 466
592 572
595 566
604 600
497 219
490 378
434 372
174 166
355 167
322 166
364 328
398 371
399 329
446 351
408 402
447 234
488 458
470 234
518 513
528 170
567 543
572 372
576 466
596 566
599 572
605 600
614 320
498 219
491 458
506 378
395 371
457 329
328 166
366 328
409 402
444 167
448 423
473 577
466 372
529 170
579 466
597 566
606 600
525 167
499 219
347 329
477 423
329 166
438 328
439 402
449 423
530 170
532 167
548 372
578 577
580 466
608 600
615 371
500 219
482 402
481 328
308 250
478 423
519 167
531 170
552 372
581 466
607 600
492 424
501 219
565 402
566 372
464 461
502 219
229 228
246 245
230 228
247 245
231 228
249 245
232 228
248 245
520 423
587 372
503 219
350 166
380 250
585 423
504 219
351 166
400 250
523 399
524 399
537 522
543 328
586 423
507 219
378 166
401 250
564 328
513 166
402 250
589 328
458 250
423 166
553 250
600 166
616 577
617 616
618 616
619 616
620 616
621 577
622 621
623 621
624 621
625 621
626 621
627 621
628 558
629 577
630 629
631 629
632 629
633 629
634 629
635 629
636 629
637 629
638 629
639 577
640 639
641 639
642 639
643 639
644 639
645 639
646 639
647 639
648 351
649 250
650 577
651 650
652 650
653 650
654 572
655 466
656 250
657 423
659 658
660 658
662 577
663 250
666 552
667 553
668 553
669 466