SELECT 
  category_id, 
  parent_id 
FROM 
  ushop_categories 
WHERE 
  parent_id IN(
    483, 
    408, 
    503, 
    695, 
    640, 
    745, 
    484, 
    504, 
    744, 
    365, 
    659, 
    681, 
    690, 
    376, 
    746, 
    641, 
    691, 
    619, 
    522, 
    385, 
    409, 
    665, 
    404, 
    386, 
    642, 
    777, 
    456, 
    387, 
    434, 
    534, 
    388, 
    558, 
    739, 
    443, 
    559, 
    495, 
    471, 
    712, 
    457, 
    445, 
    472, 
    444, 
    458, 
    352, 
    355, 
    788, 
    447, 
    448, 
    449, 
    410, 
    748, 
    435, 
    524, 
    485, 
    473, 
    749, 
    546, 
    523, 
    405, 
    694, 
    592, 
    784, 
    505, 
    353, 
    411, 
    606, 
    747, 
    620, 
    660, 
    643, 
    630, 
    377, 
    359, 
    506, 
    367, 
    525, 
    450, 
    349, 
    750, 
    535, 
    751, 
    507, 
    536, 
    560, 
    708, 
    358, 
    412, 
    537, 
    752, 
    459, 
    362, 
    413, 
    782, 
    593, 
    496, 
    631, 
    497, 
    538, 
    753, 
    436, 
    414, 
    460, 
    644, 
    621, 
    372, 
    415, 
    356, 
    416, 
    667, 
    622, 
    461, 
    417, 
    418, 
    607, 
    632, 
    462, 
    474, 
    584, 
    475, 
    526, 
    668, 
    608, 
    633, 
    476, 
    539, 
    609, 
    610, 
    498, 
    623, 
    661, 
    709, 
    486, 
    494, 
    561, 
    757, 
    389, 
    508, 
    419, 
    585, 
    758, 
    759, 
    611, 
    364, 
    547, 
    754, 
    437, 
    713, 
    634, 
    778, 
    612, 
    714, 
    645, 
    548, 
    779, 
    673, 
    390, 
    594, 
    562, 
    438, 
    715, 
    692, 
    624, 
    716, 
    717, 
    780, 
    760, 
    420, 
    646, 
    678, 
    368, 
    421, 
    761, 
    540, 
    718, 
    682, 
    391, 
    378, 
    379, 
    762, 
    380, 
    381, 
    382, 
    670, 
    477, 
    463, 
    563, 
    719, 
    595, 
    789, 
    635, 
    636, 
    527, 
    596, 
    647, 
    509, 
    392, 
    422, 
    549, 
    550, 
    564, 
    662, 
    393, 
    394, 
    674, 
    613, 
    423, 
    528, 
    424, 
    675, 
    565, 
    566, 
    567, 
    568, 
    720, 
    464, 
    569, 
    570, 
    571, 
    572, 
    573, 
    406, 
    510, 
    755, 
    614, 
    663, 
    465, 
    648, 
    499, 
    649, 
    683, 
    370, 
    350, 
    637, 
    696, 
    650, 
    697, 
    541, 
    542, 
    511, 
    395, 
    689, 
    638, 
    478, 
    597, 
    479, 
    396, 
    451, 
    452, 
    397, 
    489, 
    586, 
    787, 
    487, 
    625, 
    598, 
    574, 
    551, 
    552, 
    439, 
    575, 
    488, 
    440, 
    651, 
    756, 
    425, 
    721, 
    453, 
    698, 
    587, 
    599, 
    529, 
    576, 
    371, 
    722, 
    454, 
    354, 
    699, 
    543, 
    600, 
    530, 
    588, 
    373, 
    384, 
    403, 
    407, 
    433, 
    442, 
    446, 
    470, 
    482, 
    493, 
    502, 
    521, 
    533, 
    557, 
    583, 
    591, 
    618, 
    629, 
    658, 
    666, 
    672, 
    680, 
    707, 
    711, 
    738, 
    742, 
    766, 
    790, 
    544, 
    601, 
    455, 
    723, 
    653, 
    427, 
    512, 
    724, 
    553, 
    554, 
    466, 
    426, 
    725, 
    577, 
    652, 
    428, 
    555, 
    361, 
    669, 
    578, 
    579, 
    500, 
    700, 
    480, 
    654, 
    429, 
    676, 
    677, 
    626, 
    726, 
    430, 
    490, 
    491, 
    492, 
    741, 
    513, 
    441, 
    398, 
    639, 
    602, 
    615, 
    399, 
    627, 
    655, 
    763, 
    727, 
    501, 
    360, 
    514, 
    431, 
    701, 
    704, 
    400, 
    702, 
    703, 
    664, 
    684, 
    693, 
    679, 
    628, 
    710, 
    401, 
    432, 
    515, 
    728, 
    516, 
    467, 
    517, 
    729, 
    468, 
    783, 
    366, 
    469, 
    531, 
    357, 
    402, 
    363, 
    740, 
    705, 
    603, 
    604, 
    730, 
    685, 
    656, 
    785, 
    616, 
    617, 
    589, 
    731, 
    732, 
    657, 
    686, 
    556, 
    687, 
    688, 
    348, 
    733, 
    590, 
    545, 
    383, 
    764, 
    532, 
    734, 
    580, 
    518, 
    519, 
    786, 
    481, 
    706, 
    781, 
    776, 
    765, 
    582, 
    581, 
    520, 
    605, 
    351, 
    369, 
    743, 
    671, 
    735, 
    736, 
    737, 
    318, 
    793, 
    374, 
    328, 
    329, 
    330, 
    331, 
    332, 
    333, 
    334, 
    335, 
    325, 
    320, 
    326, 
    319, 
    336, 
    323, 
    337, 
    315, 
    338, 
    339, 
    324, 
    340, 
    341, 
    321, 
    342, 
    317, 
    322, 
    792, 
    316, 
    791, 
    343, 
    344, 
    775, 
    345, 
    327, 
    346, 
    375, 
    767, 
    768, 
    769, 
    770, 
    771, 
    772, 
    773, 
    774
  ) 
  AND category_id != 264

Query time 0.01177

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "53.06"
    },
    "table": {
      "table_name": "ushop_categories",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "parent",
        "p_category_id"
      ],
      "rows_examined_per_scan": 481,
      "rows_produced_per_join": 481,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "4.96",
        "eval_cost": "48.10",
        "prefix_cost": "53.06",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "((`marketplace`.`ushop_categories`.`parent_id` in (483,408,503,695,640,745,484,504,744,365,659,681,690,376,746,641,691,619,522,385,409,665,404,386,642,777,456,387,434,534,388,558,739,443,559,495,471,712,457,445,472,444,458,352,355,788,447,448,449,410,748,435,524,485,473,749,546,523,405,694,592,784,505,353,411,606,747,620,660,643,630,377,359,506,367,525,450,349,750,535,751,507,536,560,708,358,412,537,752,459,362,413,782,593,496,631,497,538,753,436,414,460,644,621,372,415,356,416,667,622,461,417,418,607,632,462,474,584,475,526,668,608,633,476,539,609,610,498,623,661,709,486,494,561,757,389,508,419,585,758,759,611,364,547,754,437,713,634,778,612,714,645,548,779,673,390,594,562,438,715,692,624,716,717,780,760,420,646,678,368,421,761,540,718,682,391,378,379,762,380,381,382,670,477,463,563,719,595,789,635,636,527,596,647,509,392,422,549,550,564,662,393,394,674,613,423,528,424,675,565,566,567,568,720,464,569,570,571,572,573,406,510,755,614,663,465,648,499,649,683,370,350,637,696,650,697,541,542,511,395,689,638,478,597,479,396,451,452,397,489,586,787,487,625,598,574,551,552,439,575,488,440,651,756,425,721,453,698,587,599,529,576,371,722,454,354,699,543,600,530,588,373,384,403,407,433,442,446,470,482,493,502,521,533,557,583,591,618,629,658,666,672,680,707,711,738,742,766,790,544,601,455,723,653,427,512,724,553,554,466,426,725,577,652,428,555,361,669,578,579,500,700,480,654,429,676,677,626,726,430,490,491,492,741,513,441,398,639,602,615,399,627,655,763,727,501,360,514,431,701,704,400,702,703,664,684,693,679,628,710,401,432,515,728,516,467,517,729,468,783,366,469,531,357,402,363,740,705,603,604,730,685,656,785,616,617,589,731,732,657,686,556,687,688,348,733,590,545,383,764,532,734,580,518,519,786,481,706,781,776,765,582,581,520,605,351,369,743,671,735,736,737,318,793,374,328,329,330,331,332,333,334,335,325,320,326,319,336,323,337,315,338,339,324,340,341,321,342,317,322,792,316,791,343,344,775,345,327,346,375,767,768,769,770,771,772,773,774)) and (`marketplace`.`ushop_categories`.`category_id` <> 264))"
    }
  }
}

Result

category_id parent_id
348 315
349 316
350 317
351 315
352 315
353 316
354 318
355 318
356 319
357 318
358 320
359 316
360 321
361 322
362 323
363 322
364 324
365 315
366 324
367 325
368 323
369 325
370 325
371 322
372 326
373 327
376 338
377 338
378 338
379 338
380 338
381 338
382 338
383 338
384 338
385 328
386 328
387 328
388 328
389 328
390 328
391 328
392 328
393 328
394 328
395 328
396 328
397 328
398 328
399 328
400 328
401 328
402 328
403 328
404 329
405 329
406 329
407 329
408 330
409 330
410 330
411 330
412 330
413 330
414 330
415 330
416 330
417 330
418 330
419 330
420 330
421 330
422 330
423 330
424 330
425 330
426 330
427 330
428 330
429 330
430 330
431 330
432 330
433 330
434 331
435 331
436 331
437 331
438 331
439 331
440 331
441 331
442 331
443 332
444 332
445 332
446 332
447 333
448 333
449 333
450 333
451 333
452 333
453 333
454 333
455 333
456 334
457 334
458 334
459 334
460 334
461 334
462 334
463 334
464 334
465 334
466 334
467 334
468 334
469 334
470 334
471 335
472 335
473 335
474 335
475 335
476 335
477 335
478 335
479 335
480 335
481 335
482 335
483 336
484 336
485 336
486 336
487 336
488 336
489 336
490 336
491 336
492 336
493 336
494 337
495 337
496 337
497 337
498 337
499 337
500 337
501 337
502 337
503 316
504 316
505 316
506 316
507 316
508 316
509 316
510 316
511 316
512 316
513 316
514 316
515 316
516 316
517 316
518 316
519 316
520 316
521 316
522 339
523 339
524 339
525 339
526 339
527 339
528 339
529 339
530 339
531 339
532 339
533 339
534 340
535 340
536 340
537 340
538 340
539 340
540 340
541 340
542 340
543 340
544 340
545 340
546 341
547 341
548 341
549 341
550 341
551 341
552 341
553 341
554 341
555 341
556 341
557 341
558 342
559 342
560 342
561 342
562 342
563 342
564 342
565 342
566 342
567 342
568 342
569 342
570 342
571 342
572 342
573 342
574 342
575 342
576 342
577 342
578 342
579 342
580 342
581 342
582 342
583 342
584 343
585 343
586 343
587 343
588 343
589 343
590 343
591 343
592 344
593 344
594 344
595 344
596 344
597 344
598 344
599 344
600 344
601 344
602 344
603 344
604 344
605 344
606 345
607 345
608 345
609 345
610 345
611 345
612 345
613 345
614 345
615 345
616 345
617 345
618 345
619 315
620 315
621 315
622 315
623 315
624 315
625 315
626 315
627 315
628 315
629 315
630 327
631 327
632 327
633 327
634 327
635 327
636 327
637 327
638 327
639 327
640 326
641 326
642 326
643 326
644 326
645 326
646 326
647 326
648 326
649 326
650 326
651 326
652 326
653 326
654 326
655 326
656 326
657 326
658 326
659 325
660 325
661 325
662 325
663 325
664 325
665 325
666 325
667 322
668 322
669 322
670 318
671 322
672 322
673 321
674 321
675 321
676 321
677 321
678 318
679 321
680 321
681 320
682 320
683 320
684 320
685 320
686 320
687 320
688 320
689 318
690 319
691 319
692 319
693 319
694 323
695 318
696 318
697 318
698 318
699 318
700 318
701 318
702 318
703 318
704 318
705 318
706 318
707 318
708 317
709 317
710 317
711 317
712 323
713 323
714 323
715 323
716 323
717 323
718 323
719 323
720 323
721 323
722 323
723 323
724 323
725 323
726 323
727 323
728 323
729 323
730 323
731 323
732 323
733 323
734 323
735 323
736 323
737 323
738 323
739 324
740 322
741 321
742 320
743 319
744 318
745 318
746 318
747 323
748 323
749 323
750 323
751 323
752 323
753 323
754 323
755 323
756 323
757 324
758 324
759 324
760 324
761 324
762 324
763 324
764 324
765 324
766 324
776 775
777 775
778 775
779 775
780 775
781 775
782 775
783 775
784 775
785 775
786 775
787 775
788 775
789 775
790 775
374 343
793 344