SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    1074, 
    450, 
    1191, 
    647, 
    492, 
    738, 
    604, 
    694, 
    854, 
    836, 
    884, 
    1069, 
    1017, 
    394, 
    735, 
    823, 
    506, 
    633, 
    548, 
    488, 
    889, 
    885, 
    1066, 
    708, 
    1135, 
    942, 
    439, 
    447, 
    816, 
    469, 
    1084, 
    607, 
    1086, 
    472, 
    948, 
    975, 
    536, 
    1152, 
    1149, 
    547, 
    1148, 
    818, 
    1151, 
    1155, 
    1153, 
    1154, 
    748, 
    526, 
    705, 
    590, 
    589, 
    520, 
    577, 
    559, 
    951, 
    535, 
    640, 
    684, 
    560, 
    474, 
    580, 
    454, 
    463, 
    578, 
    569, 
    567, 
    742, 
    542, 
    527, 
    459, 
    516, 
    670, 
    444, 
    555, 
    1088, 
    1085, 
    833, 
    1089, 
    1090, 
    1087, 
    689, 
    442, 
    707, 
    445, 
    715, 
    661, 
    755, 
    844, 
    945, 
    980, 
    939, 
    1092, 
    564, 
    753, 
    551, 
    667, 
    1018, 
    1016, 
    941, 
    1093, 
    752, 
    650, 
    665, 
    491, 
    424, 
    697, 
    400, 
    623, 
    624, 
    416, 
    606, 
    671, 
    401, 
    440, 
    792, 
    410, 
    605, 
    645, 
    481, 
    479, 
    710, 
    608, 
    570, 
    1039, 
    961, 
    1022, 
    950, 
    1095, 
    949, 
    1100, 
    1179, 
    1162, 
    490, 
    457, 
    513, 
    1157, 
    786, 
    435, 
    693, 
    745, 
    468, 
    758, 
    594, 
    743, 
    713, 
    497, 
    659, 
    500, 
    837, 
    1028, 
    1032, 
    430, 
    794, 
    741, 
    582, 
    828, 
    768, 
    545, 
    981, 
    642, 
    466, 
    674, 
    599, 
    465, 
    639, 
    771, 
    635, 
    541, 
    692, 
    959, 
    1029, 
    1112, 
    462, 
    432, 
    727, 
    434, 
    722, 
    760, 
    765, 
    489, 
    744, 
    656, 
    717, 
    574, 
    652, 
    429, 
    793, 
    852, 
    782, 
    698, 
    546, 
    571, 
    731, 
    1147, 
    418, 
    641, 
    955, 
    952, 
    954, 
    953, 
    561, 
    427, 
    1062, 
    412, 
    769, 
    721, 
    461, 
    522, 
    537, 
    531, 
    533, 
    622, 
    587, 
    774, 
    819, 
    784, 
    433, 
    386, 
    834, 
    1075, 
    437, 
    648, 
    438, 
    672, 
    756, 
    566, 
    483, 
    621, 
    482, 
    970, 
    1031, 
    724, 
    615, 
    495, 
    494, 
    398, 
    505, 
    984, 
    1077, 
    703, 
    687, 
    543, 
    600, 
    702, 
    448, 
    477, 
    983, 
    636, 
    552, 
    700, 
    521, 
    620, 
    563, 
    591, 
    879, 
    719, 
    425, 
    507, 
    853, 
    446, 
    499, 
    767, 
    498, 
    540, 
    471, 
    408, 
    409, 
    726, 
    415, 
    414, 
    780, 
    763, 
    634, 
    762, 
    892, 
    453, 
    565, 
    396, 
    711, 
    613, 
    1052, 
    704, 
    930, 
    848, 
    602, 
    729, 
    528, 
    510, 
    517, 
    428, 
    649, 
    718, 
    460, 
    467, 
    562, 
    682, 
    631, 
    720, 
    550, 
    549, 
    603, 
    750, 
    598, 
    751, 
    525, 
    575, 
    523, 
    683, 
    420, 
    452, 
    1067, 
    588, 
    486, 
    431, 
    456, 
    839, 
    596, 
    593, 
    403, 
    557, 
    407, 
    405, 
    529, 
    891, 
    1143, 
    1119, 
    1128, 
    1127, 
    1187, 
    1194, 
    1173, 
    1125, 
    1124, 
    1091, 
    1196, 
    1113, 
    1199, 
    1115, 
    1121, 
    1139, 
    1141, 
    1150, 
    1144, 
    1190, 
    1126, 
    1172, 
    1165, 
    1111, 
    1116, 
    1138, 
    1189, 
    1132, 
    1133, 
    972, 
    1178, 
    1177, 
    1176, 
    1021, 
    1166, 
    1131, 
    1169, 
    1156, 
    1168, 
    1171, 
    1094, 
    1186, 
    1097, 
    1106, 
    1182, 
    1107, 
    1109, 
    1108, 
    1105, 
    1185, 
    1104, 
    1181, 
    1103, 
    1102, 
    1134, 
    1098, 
    1184, 
    1183, 
    1192, 
    1188, 
    958, 
    1145, 
    986, 
    1158, 
    1076, 
    1123, 
    1136, 
    1146, 
    1071, 
    1180, 
    1137, 
    1163, 
    1170, 
    1081, 
    1160, 
    944, 
    1161, 
    1129, 
    1195, 
    1174, 
    1197, 
    1096, 
    1114, 
    1198, 
    1117, 
    1118, 
    1120, 
    1122, 
    1140, 
    1193, 
    1130, 
    673, 
    832, 
    947, 
    502, 
    484, 
    956, 
    387, 
    511, 
    940, 
    390, 
    473, 
    1164, 
    734, 
    1030, 
    960, 
    402, 
    485, 
    455, 
    964, 
    451, 
    860, 
    801, 
    966, 
    1033, 
    1035, 
    1175, 
    863, 
    441, 
    504, 
    458, 
    1142, 
    496, 
    419, 
    714, 
    538, 
    943, 
    820, 
    723, 
    417, 
    399, 
    493, 
    1159, 
    385, 
    874, 
    422, 
    802, 
    967, 
    397, 
    1034, 
    1036, 
    534, 
    861, 
    487, 
    544, 
    573, 
    404, 
    584, 
    393, 
    395, 
    800, 
    626, 
    478, 
    524, 
    406, 
    625, 
    803, 
    968, 
    1037, 
    530, 
    436, 
    443, 
    804, 
    1038, 
    805, 
    806, 
    807, 
    808, 
    809, 
    810, 
    811, 
    812, 
    813, 
    814, 
    815
  )

Query time 0.01048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_categories",
          "access_type": "ALL",
          "possible_keys": ["parent"],
          "rows": 525,
          "filtered": 100,
          "attached_condition": "cscart_categories.parent_id in (1074,450,1191,647,492,738,604,694,854,836,884,1069,1017,394,735,823,506,633,548,488,889,885,1066,708,1135,942,439,447,816,469,1084,607,1086,472,948,975,536,1152,1149,547,1148,818,1151,1155,1153,1154,748,526,705,590,589,520,577,559,951,535,640,684,560,474,580,454,463,578,569,567,742,542,527,459,516,670,444,555,1088,1085,833,1089,1090,1087,689,442,707,445,715,661,755,844,945,980,939,1092,564,753,551,667,1018,1016,941,1093,752,650,665,491,424,697,400,623,624,416,606,671,401,440,792,410,605,645,481,479,710,608,570,1039,961,1022,950,1095,949,1100,1179,1162,490,457,513,1157,786,435,693,745,468,758,594,743,713,497,659,500,837,1028,1032,430,794,741,582,828,768,545,981,642,466,674,599,465,639,771,635,541,692,959,1029,1112,462,432,727,434,722,760,765,489,744,656,717,574,652,429,793,852,782,698,546,571,731,1147,418,641,955,952,954,953,561,427,1062,412,769,721,461,522,537,531,533,622,587,774,819,784,433,386,834,1075,437,648,438,672,756,566,483,621,482,970,1031,724,615,495,494,398,505,984,1077,703,687,543,600,702,448,477,983,636,552,700,521,620,563,591,879,719,425,507,853,446,499,767,498,540,471,408,409,726,415,414,780,763,634,762,892,453,565,396,711,613,1052,704,930,848,602,729,528,510,517,428,649,718,460,467,562,682,631,720,550,549,603,750,598,751,525,575,523,683,420,452,1067,588,486,431,456,839,596,593,403,557,407,405,529,891,1143,1119,1128,1127,1187,1194,1173,1125,1124,1091,1196,1113,1199,1115,1121,1139,1141,1150,1144,1190,1126,1172,1165,1111,1116,1138,1189,1132,1133,972,1178,1177,1176,1021,1166,1131,1169,1156,1168,1171,1094,1186,1097,1106,1182,1107,1109,1108,1105,1185,1104,1181,1103,1102,1134,1098,1184,1183,1192,1188,958,1145,986,1158,1076,1123,1136,1146,1071,1180,1137,1163,1170,1081,1160,944,1161,1129,1195,1174,1197,1096,1114,1198,1117,1118,1120,1122,1140,1193,1130,673,832,947,502,484,956,387,511,940,390,473,1164,734,1030,960,402,485,455,964,451,860,801,966,1033,1035,1175,863,441,504,458,1142,496,419,714,538,943,820,723,417,399,493,1159,385,874,422,802,967,397,1034,1036,534,861,487,544,573,404,584,393,395,800,626,478,524,406,625,803,968,1037,530,436,443,804,1038,805,806,807,808,809,810,811,812,813,814,815)"
        }
      }
    ]
  }
}

Result

category_id parent_id
762 596
1124 834
752 650
751 487
745 429
741 429
738 734
735 734
1112 1028
731 729
722 390
718 445
714 484
710 390
707 445
703 427
704 444
705 511
702 673
701 417
700 402
693 434
692 538
684 492
683 419
1114 472
1115 546
687 648
672 406
674 673
671 400
667 451
659 448
661 485
636 549
635 538
634 763
1022 950
613 397
621 1071
622 385
623 399
624 623
625 626
620 404
615 390
1127 1095
1128 1095
608 406
610 502
1108 950
606 400
602 422
603 451
604 399
605 397
607 502
590 589
589 385
588 397
533 530
529 385
531 530
534 484
535 534
541 538
542 397
543 397
544 484
545 511
546 502
547 1115
670 516
582 429
801 800
802 800
584 484
1073 387
713 429
580 534
571 546
1126 1095
573 484
574 429
575 441
1085 445
577 393
578 451
717 673
527 538
522 493
523 451
524 417
525 524
526 445
521 404
520 393
570 406
567 549
569 443
1118 983
488 487
469 395
471 408
472 502
474 455
477 983
479 387
1133 473
481 479
482 1071
483 1071
485 484
724 673
723 484
665 650
652 516
1125 834
633 533
504 484
505 444
506 406
507 406
510 406
511 484
513 441
516 419
517 516
565 466
566 1071
750 487
457 455
456 455
753 487
1111 502
760 434
721 404
719 419
1097 950
748 487
744 434
1105 950
1106 950
726 414
689 390
650 502
648 419
649 648
1110 950
729 538
711 408
601 397
756 1071
755 844
600 461
595 1115
596 390
597 596
598 406
599 456
743 429
742 451
715 673
728 487
727 673
452 451
453 385
454 419
450 448
425 419
1104 950
427 419
428 427
429 387
430 429
431 406
432 406
433 406
434 387
435 434
436 451
437 395
438 395
439 438
440 438
442 441
444 443
445 444
446 445
447 406
448 387
415 414
416 399
418 417
1098 950
594 429
587 385
563 404
564 393
593 596
591 402
647 406
1084 502
1086 502
645 406
708 390
562 451
555 443
1132 473
557 402
559 422
560 444
561 393
423 422
424 399
656 390
1066 387
697 623
694 853
1107 950
698 427
463 385
1116 502
465 397
466 385
467 455
468 429
486 485
489 434
490 390
491 461
492 451
493 387
494 502
495 494
496 484
497 429
498 387
499 498
500 493
758 429
747 487
548 533
549 530
550 549
551 549
552 393
420 419
421 420
536 425
537 402
540 458
528 527
462 461
461 399
459 458
460 455
414 387
412 397
1190 1189
407 406
408 385
409 408
410 385
642 793
639 445
640 444
641 406
405 404
403 402
386 385
388 387
1123 530
394 393
396 395
398 397
400 399
401 400
763 502
765 434
767 673
768 448
769 404
771 538
774 387
980 673
777 429
780 763
782 429
784 774
786 479
1087 833
792 434
793 390
794 429
1131 1066
879 406
803 800
804 800
805 800
806 800
807 800
808 800
809 800
810 800
811 800
812 800
813 800
814 800
815 800
816 800
1081 445
818 1115
819 774
821 820
823 406
1122 930
839 456
828 844
1094 941
832 484
833 387
834 1086
1074 1092
836 673
837 833
1075 1092
1129 1096
1130 1096
844 387
1134 950
848 406
1071 456
852 1115
853 441
854 853
1117 494
1109 950
860 473
861 473
863 417
1099 950
1100 950
1101 950
1102 950
1103 950
1077 800
1095 949
1096 949
874 484
884 387
885 1066
889 673
1092 502
891 399
892 406
1121 930
984 820
1090 834
1113 472
981 708
983 502
930 502
931 484
1088 833
939 387
940 484
941 387
942 1066
943 484
944 640
945 445
1076 793
947 484
948 1095
949 502
950 387
951 1095
952 387
953 1116
954 1116
955 673
956 484
958 390
959 640
960 484
961 950
1186 950
964 640
1089 834
1091 834
966 832
967 832
968 832
970 1086
972 390
975 1084
986 390
1021 434
1016 941
1017 884
1018 673
1093 502
1028 387
1029 1111
1030 484
1031 1111
1032 1028
1033 1093
1034 1093
1035 947
1036 947
1037 947
1038 947
1039 673
1067 1084
1052 385
1062 445
1069 502
1135 1066
1136 527
1137 419
1164 484
1188 1183
1189 502
1168 833
1187 1115
1185 950
1138 502
1139 1138
1145 390
1140 1138
1141 1139
1142 484
1143 673
1144 1139
1146 820
1147 1115
1156 429
1148 1115
1157 833
1149 1115
1150 1139
1151 1115
1152 1115
1153 1115
1154 1115
1155 1115
1158 390
1159 484
1160 445
1161 640
1162 387
1163 404
1165 502
1166 1066
1169 833
1170 404
1171 939
1172 502
1173 1172
1174 1172
1175 484
1176 1175
1177 1175
1178 1175
1179 387
1180 456
1181 950
1182 950
1183 387
1184 1028
1191 484
1192 387
1193 1189
1194 1069
1195 1069
1196 1165
1197 1165
1198 607
1199 607