SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    5037, 
    5001, 
    5064, 
    5041, 
    5010, 
    5011, 
    5055, 
    5002, 
    5048, 
    5065, 
    5003, 
    5047, 
    5066, 
    5004, 
    5054, 
    5067, 
    5005, 
    5006, 
    5007, 
    5096, 
    5112, 
    5113, 
    5008, 
    5095, 
    5009, 
    4917, 
    4918, 
    5038, 
    5070, 
    4900, 
    4903, 
    5109, 
    4910, 
    4911, 
    4909, 
    5026, 
    4945, 
    5100, 
    4985, 
    4974, 
    4939, 
    4949, 
    4950, 
    4951, 
    4954, 
    4952, 
    4953, 
    4955, 
    4956, 
    4944, 
    4946, 
    5106, 
    5032, 
    5018, 
    5039, 
    5078, 
    4914, 
    4915, 
    4997, 
    5062, 
    4996, 
    3417, 
    5063, 
    5061, 
    5141, 
    5140, 
    5132, 
    5136, 
    5068, 
    5045, 
    5046, 
    5156, 
    4981, 
    4976, 
    5030, 
    5028, 
    5029, 
    5072, 
    4991, 
    4913, 
    5099, 
    5111, 
    5155, 
    5173, 
    5175, 
    5049, 
    5023, 
    4921, 
    4941, 
    4942, 
    5105, 
    5120, 
    4988, 
    4977, 
    4975, 
    5056, 
    5182, 
    5185, 
    5080, 
    4931, 
    5021, 
    5073, 
    5087, 
    4986, 
    4935, 
    4982, 
    5031, 
    5052, 
    4990, 
    5024, 
    4992, 
    5022, 
    5183, 
    4989, 
    5076, 
    5075, 
    5158, 
    4940, 
    4979, 
    5051, 
    4912, 
    5033, 
    5035, 
    4906, 
    4907, 
    5176, 
    5089, 
    4980, 
    4901, 
    4899, 
    4902, 
    5012, 
    5184, 
    5159, 
    5088, 
    5147, 
    4987, 
    3438, 
    4937, 
    5129, 
    5126, 
    5127, 
    5017, 
    499, 
    4925, 
    4924, 
    5174, 
    5114, 
    5097, 
    5098, 
    5115, 
    5119, 
    5104, 
    4998, 
    5020, 
    4999, 
    5000, 
    5019, 
    5057, 
    5040, 
    5094, 
    5110, 
    4928, 
    5122, 
    5121, 
    5144, 
    5143, 
    5142, 
    5124, 
    5123, 
    5015, 
    5166, 
    5138, 
    5128, 
    5139, 
    5125, 
    3446, 
    4920, 
    5060, 
    5059, 
    5025, 
    5016, 
    5034, 
    5013, 
    5133, 
    5134, 
    5137, 
    5135, 
    5145, 
    5131, 
    5146, 
    4933, 
    4934, 
    4929, 
    4930, 
    5069, 
    5168, 
    4908, 
    5082, 
    5081, 
    5083, 
    5077, 
    5157, 
    5053, 
    4993, 
    4994, 
    4932, 
    5074, 
    5058, 
    4984, 
    5091, 
    5085, 
    5050, 
    5027, 
    5090, 
    5107, 
    5092, 
    5167, 
    5086, 
    4927, 
    4923, 
    4904, 
    4978, 
    5084, 
    4919, 
    4943, 
    4959, 
    4964, 
    4962, 
    4967, 
    4970, 
    4973, 
    4957, 
    4963, 
    4960, 
    4965, 
    4968, 
    4971, 
    4958, 
    4961, 
    4966, 
    4969, 
    4972, 
    5130, 
    5152, 
    5161, 
    5187, 
    5093, 
    5108, 
    5071, 
    4983, 
    4938, 
    4995, 
    5036, 
    5102, 
    5117, 
    5103, 
    5118, 
    5101, 
    5116, 
    5149, 
    5148, 
    5150, 
    5151, 
    5042, 
    5044, 
    5043, 
    4947, 
    4948, 
    5186, 
    5172, 
    5160, 
    5181, 
    5162, 
    5178, 
    5169, 
    5171, 
    5163, 
    5179, 
    5180, 
    5154, 
    5164, 
    5177, 
    5165, 
    5153, 
    5170, 
    3252, 
    5203, 
    3255, 
    911, 
    4926, 
    5079, 
    4922, 
    5014, 
    860, 
    1967, 
    849, 
    835, 
    4905, 
    1552, 
    2372, 
    2346, 
    897, 
    3542, 
    2486, 
    929, 
    3481, 
    2028, 
    3471, 
    921, 
    3476, 
    884, 
    1966, 
    1982, 
    2698, 
    2688, 
    2708, 
    3212, 
    3316, 
    3477, 
    2955, 
    890, 
    3170, 
    952, 
    3415, 
    1971, 
    2374, 
    2349, 
    2984, 
    418, 
    668, 
    2947, 
    1306, 
    1519, 
    478, 
    644, 
    568, 
    421, 
    1527, 
    2706, 
    758, 
    1069, 
    1192, 
    1300, 
    2009, 
    1530, 
    1521, 
    1974, 
    2714, 
    2194, 
    3492, 
    3485, 
    3487, 
    3269, 
    3315, 
    3271, 
    3273, 
    896, 
    3493, 
    3497, 
    3501, 
    3505, 
    3509, 
    3513, 
    3517, 
    3521, 
    3543, 
    4000, 
    3547, 
    3550, 
    5188, 
    5197, 
    5198, 
    5202, 
    3452
  ) 
  AND category_id != 414

Query time 0.00546

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "368.89"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "parent",
        "p_category_id"
      ],
      "rows_examined_per_scan": 3444,
      "rows_produced_per_join": 3000,
      "filtered": "87.11",
      "cost_info": {
        "read_cost": "68.89",
        "eval_cost": "300.00",
        "prefix_cost": "368.89",
        "data_read_per_join": "10M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "((`s2cart`.`cscart_categories`.`parent_id` in (5037,5001,5064,5041,5010,5011,5055,5002,5048,5065,5003,5047,5066,5004,5054,5067,5005,5006,5007,5096,5112,5113,5008,5095,5009,4917,4918,5038,5070,4900,4903,5109,4910,4911,4909,5026,4945,5100,4985,4974,4939,4949,4950,4951,4954,4952,4953,4955,4956,4944,4946,5106,5032,5018,5039,5078,4914,4915,4997,5062,4996,3417,5063,5061,5141,5140,5132,5136,5068,5045,5046,5156,4981,4976,5030,5028,5029,5072,4991,4913,5099,5111,5155,5173,5175,5049,5023,4921,4941,4942,5105,5120,4988,4977,4975,5056,5182,5185,5080,4931,5021,5073,5087,4986,4935,4982,5031,5052,4990,5024,4992,5022,5183,4989,5076,5075,5158,4940,4979,5051,4912,5033,5035,4906,4907,5176,5089,4980,4901,4899,4902,5012,5184,5159,5088,5147,4987,3438,4937,5129,5126,5127,5017,499,4925,4924,5174,5114,5097,5098,5115,5119,5104,4998,5020,4999,5000,5019,5057,5040,5094,5110,4928,5122,5121,5144,5143,5142,5124,5123,5015,5166,5138,5128,5139,5125,3446,4920,5060,5059,5025,5016,5034,5013,5133,5134,5137,5135,5145,5131,5146,4933,4934,4929,4930,5069,5168,4908,5082,5081,5083,5077,5157,5053,4993,4994,4932,5074,5058,4984,5091,5085,5050,5027,5090,5107,5092,5167,5086,4927,4923,4904,4978,5084,4919,4943,4959,4964,4962,4967,4970,4973,4957,4963,4960,4965,4968,4971,4958,4961,4966,4969,4972,5130,5152,5161,5187,5093,5108,5071,4983,4938,4995,5036,5102,5117,5103,5118,5101,5116,5149,5148,5150,5151,5042,5044,5043,4947,4948,5186,5172,5160,5181,5162,5178,5169,5171,5163,5179,5180,5154,5164,5177,5165,5153,5170,3252,5203,3255,911,4926,5079,4922,5014,860,1967,849,835,4905,1552,2372,2346,897,3542,2486,929,3481,2028,3471,921,3476,884,1966,1982,2698,2688,2708,3212,3316,3477,2955,890,3170,952,3415,1971,2374,2349,2984,418,668,2947,1306,1519,478,644,568,421,1527,2706,758,1069,1192,1300,2009,1530,1521,1974,2714,2194,3492,3485,3487,3269,3315,3271,3273,896,3493,3497,3501,3505,3509,3513,3517,3521,3543,4000,3547,3550,5188,5197,5198,5202,3452)) and (`s2cart`.`cscart_categories`.`category_id` <> 414))"
    }
  }
}

Result

category_id parent_id
664 644
669 668
670 668
671 668
672 668
673 668
674 668
675 668
676 668
677 668
678 668
679 668
680 644
685 644
645 644
635 568
636 568
640 568
641 568
628 568
621 568
619 568
620 568
618 568
617 568
616 568
611 568
610 568
605 568
604 568
603 568
585 568
586 568
587 568
579 568
578 568
573 568
572 568
571 568
569 568
567 478
566 478
565 478
564 478
526 478
527 478
469 418
470 418
471 418
472 418
473 418
474 418
475 418
476 418
477 418
479 478
480 478
484 478
493 478
494 478
495 478
496 478
497 478
498 478
500 499
501 499
502 499
503 499
504 499
505 499
506 478
508 478
509 478
510 478
511 478
521 478
522 478
523 478
524 478
525 478
431 421
432 421
433 421
434 421
435 421
436 421
437 421
438 421
439 421
440 421
441 421
442 421
443 421
444 418
445 418
446 418
447 418
448 418
449 418
450 418
451 418
452 418
453 418
454 418
455 418
456 418
457 418
458 418
459 418
460 418
461 418
424 421
423 421
422 421
419 418
420 418
695 644
696 644
697 644
701 644
706 644
713 644
714 644
715 644
716 644
717 644
718 644
719 644
720 644
736 644
737 644
740 644
743 644
749 644
751 644
752 644
759 758
760 758
761 758
762 758
769 758
770 758
771 758
772 758
777 758
781 758
782 758
783 758
784 758
785 758
786 758
787 758
788 758
791 758
792 758
793 758
794 758
795 758
799 758
800 758
801 758
802 758
803 758
804 758
805 758
806 758
807 758
808 758
812 758
815 758
816 758
821 758
822 758
824 849
838 835
841 835
848 849
852 849
853 849
855 849
856 849
857 849
859 849
861 860
882 897
887 3471
888 884
889 897
892 4000
898 897
899 897
900 897
901 897
902 897
903 897
904 897
905 897
906 897
907 897
908 897
909 897
910 897
914 911
920 3477
922 921
926 921
930 929
931 929
932 929
933 929
934 929
935 929
936 929
937 929
938 921
939 921
953 952
954 952
955 952
964 921
982 3476
990 921
999 921
1000 921
1012 921
1018 921
1027 921
1038 921
1056 921
1063 921
1067 921
1070 1069
1081 1069
1082 1069
1089 1069
1090 1069
1093 1069
1094 1069
1095 1069
1096 1069
1097 1069
1098 1069
1101 1069
1114 1069
1115 1069
1117 1069
1118 1069
1130 1069
1131 1069
1132 1069
1133 1069
1140 1069
1141 1069
1142 1069
1143 1974
1193 1192
1197 1192
1198 1192
1278 1192
1279 1192
1283 1192
1301 1300
1304 1300
1305 1300
1307 1306
1308 1300
1309 1192
1310 1192
1311 1192
1312 1192
1313 1192
1314 1192
1325 1192
1326 1192
1327 1192
1328 1192
1329 1306
1331 1306
1332 1306
1333 1306
1334 1192
1335 1306
1336 1306
1337 1306
1338 1306
1339 1306
1340 1306
1344 1306
1345 1306
1346 1306
1347 1306
1348 1306
1351 1306
1352 1306
1353 1306
1354 1306
1364 1306
1365 1306
1366 1306
1367 1306
1383 1306
1384 1306
1386 1306
1388 1192
1402 1306
1403 1192
1415 1192
1416 1192
1417 1192
1441 1192
1446 1192
1447 1192
1448 1192
1449 1192
1450 1192
1454 1192
1455 1192
1459 1192
1478 1306
1479 1192
1492 1192
1493 1192
1498 1192
1499 1306
1500 1300
1501 1192
1520 1519
1522 1521
1528 1527
1529 1519
1531 1530
1532 1519
1533 1530
1534 1527
1535 1530
1536 1519
1537 1530
1538 1530
1541 1530
1542 1530
1543 1530
1544 1530
1545 1530
1546 1519
1548 1530
1549 1519
1551 1530
1565 1530
1566 1530
1567 1530
1569 1530
1570 1519
1575 1519
1576 1530
1577 1530
1578 1521
1587 1521
1596 1519
1597 1527
1604 1527
1605 1530
1606 1527
1607 1527
1608 1527
1609 1527
1610 1527
1611 1519
1613 1530
1614 1530
1615 1530
1618 1519
1619 1530
1620 1527
1621 1519
1622 1519
1623 1519
1625 1527
1627 1530
1628 1530
1633 1521
1637 1521
1647 1521
1655 1521
1673 1530
1675 1530
1677 1521
1775 1521
1808 1521
1839 1530
1840 1530
1841 1530
1842 1530
1843 1530
1845 1530
1846 1519
1847 1519
1848 1519
1857 1530
1870 1552
1871 1530
1876 1527
1877 1527
1880 1519
1881 1519
1882 1527
1883 1519
1884 1519
1885 1530
1891 1530
1894 1530
1895 1530
1896 1527
1897 1530
1898 1530
1902 1530
1903 1530
1919 1527
1920 1527
1921 1974
1922 1530
1923 1519
1924 1530
1925 1530
1926 1519
1927 1530
1928 1530
1929 1530
1933 1530
1934 1521
1935 1530
1936 1530
1937 1527
1938 1530
1939 1530
1940 1530
1941 1530
1945 1527
1946 1530
1947 1519
1948 1530
1949 1519
1950 1519
1951 1519
1952 1527
1953 1519
1954 1530
1955 1519
1956 1530
1957 1530
1958 1521
1962 1530
1963 1530
1964 1519
1965 1519
1968 1967
1969 1967
1970 1967
1972 1971
1975 1974
1981 1971
1984 1974
1993 1974
2007 1974
2008 1971
2010 2009
2011 2009
2012 2009
2013 2009
2014 2009
2020 1974
2029 2028
2045 1974
2047 1971
2049 1974
2064 1966
2065 1974
2070 1971
2071 2028
2073 1971
2076 2028
2086 1982
2092 2028
2109 2028
2125 1974
2126 1974
2140 1974
2155 2028
2156 2028
2167 1974
2168 2028
2179 1974
2189 1974
2195 2194
2196 2194
2197 2194
2198 2194
2199 2194
2200 2194
2201 2194
2202 2194
2203 2194
2204 2194
2205 1974
2219 1974
2226 1974
2233 1974
2246 2028
2262 2028
2275 1971
2291 1974
2295 1974
2301 2028
2316 1974
2321 1971
2345 1971
2347 2346
2350 2349
2351 2349
2354 2349
2366 2349
2373 2372
2375 2374
2376 2372
2377 2346
2378 2346
2379 2374
2380 2346
2381 2372
2382 2374
2384 2346
2385 2372
2386 2374
2415 2372
2416 2346
2417 2346
2419 2372
2420 2372
2421 2372
2422 2372
2423 2374
2427 2374
2428 2346
2437 2374
2438 2374
2443 2372
2444 2374
2448 2372
2449 2372
2450 2372
2451 2346
2457 2374
2460 2372
2461 2374
2464 2372
2465 2349
2466 2372
2467 2374
2483 2372
2484 2374
2485 2346
2487 2486
2488 2486
2496 2372
2498 2372
2499 2486
2501 2486
2502 2374
2505 2349
2506 2349
2507 2349
2535 2349
2548 2349
2550 2349
2558 2349
2559 2349
2583 2349
2584 2349
2585 2486
2588 2372
2599 2374
2613 2349
2614 2346
2617 2346
2622 2346
2623 2346
2624 2374
2625 2346
2626 2346
2627 2372
2628 2372
2629 2372
2630 2372
2631 2486
2632 2346
2633 2346
2634 2372
2637 2374
2638 2372
2643 2372
2645 2349
2646 2349
2649 2349
2650 2374
2651 2346
2652 2349
2653 2349
2654 2374
2671 2346
2672 2374
2673 2346
2674 2374
2675 2372
2676 2374
2678 2349
2679 2372
2682 2486
2684 2486
2687 2372
2699 2698
2707 2706
2709 2708
2715 2714
2719 2698
2724 2706
2725 2688
2728 2706
2733 2706
2734 2688
2735 2688
2739 3477
2753 3477
2754 3477
2755 2706
2766 2698
2768 2706
2775 2706
2778 2708
2779 2688
2780 2706
2789 2706
2796 2698
2800 2688
2801 2706
2851 2706
2852 2706
2853 2706
2871 3477
2922 2708
2934 2708
2937 2706
2944 2955
2945 2708
2948 2947
2949 2947
2950 2947
2951 2947
2952 2947
2953 2947
2954 2947
2956 2955
2957 2955
2958 2955
2959 2708
2974 2708
2981 2708
2985 2984
2987 2698
2992 2984
2993 2984
3004 2708
3005 2984
3006 2984
3007 2984
3008 2706
3012 2708
3016 2706
3026 2714
3028 2706
3037 2708
3038 2706
3043 3315
3044 2706
3048 2708
3055 2706
3092 2706
3095 2706
3111 2698
3134 2984
3135 3477
3141 2714
3147 2714
3149 2688
3151 2984
3152 2698
3171 3170
3172 3170
3173 3170
3174 3170
3175 3170
3176 3170
3177 3170
3178 3170
3179 3170
3180 3170
3181 2708
3182 2706
3190 2708
3191 2708
3199 2688
3200 2708
3213 3212
3214 3212
3215 3212
3216 3212
3217 3212
3218 3212
3219 3212
3220 2708
3236 2708
3237 2708
3242 2708
3243 2708
3244 2708
3245 2688
3247 2714
3250 2708
3256 3481
3259 3269
3260 3315
3264 3315
3266 3485
3268 3487
3274 3269
3275 2984
3276 2984
3277 2984
3278 2984
3279 2984
3280 2984
3281 2984
3288 2984
3289 2706
3290 3477
3291 2706
3317 2706
3333 2698
3342 2698
3343 2984
3344 2706
3350 2706
3364 2688
3366 2708
3368 2698
3374 2984
3388 2984
3397 2984
3407 2984
3413 2708
3414 2706
3416 3415
3418 3417
3419 3417
3420 3415
3421 3415
3422 3415
3423 3452
3424 3415
3425 3415
3426 3415
3427 3415
3428 3415
3429 3415
3430 2708
3431 3415
3432 3415
3433 3415
3434 3415
3435 3415
3436 3415
3437 3415
3439 3415
3440 3415
3441 3415
3442 3415
3443 3415
3444 3415
3445 3415
3447 3446
3448 3446
3449 3446
3450 3446
3451 3415
3453 3415
3454 3415
3455 3415
3456 3415
3457 3415
3458 3415
3459 3415
3460 3415
3461 3415
3462 3415
3463 3415
3464 3415
3465 3415
3466 3415
3467 1967
3468 3415
4916 5188
4936 5188
886 884
1854 1552
2274 1966
2936 3252
3267 3255
854 849
2418 2346
837 835
895 3543
2986 3252
3488 3487
3262 3481
918 911
4001 4000
885 884
942 3476
1852 1552
2063 1966
2117 1982
2282 1966
916 911
851 3550
2439 2346
840 835
864 860
3489 3487
3257 3252
4896 3543
947 3476
1603 1552
2016 1966
2019 1966
2218 1982
913 911
858 3550
846 835
872 860
3490 3487
3544 4000
4897 3543
1624 1552
2137 1982
2341 1966
3254 3252
850 3550
842 835
915 3542
3150 3487
3470 3252
3161 2698
917 911
1030 3476
1009 3476
1556 1552
2115 1966
2175 1966
2260 1982
847 835
873 860
3251 3252
1062 3476
1626 1552
2119 1966
836 835
1006 3476
1553 1552
1849 1552
2273 1982
2277 1966
845 835
879 860
919 3542
956 3476
1612 1552
1850 1552
2256 1982
2323 1966
844 835
881 911
1008 3476
1851 1552
2062 1966
2258 1982
2336 1966
843 835
875 860
912 911
2002 1982
2177 1966
2257 1982
2342 1982
839 835
3482 3255
3486 3485
3478 3481
3523 3521
3522 3521
3518 3517
3514 3513
3510 3509
3506 3505
3502 3501
3498 3497
3494 3493
3548 3547
5189 5188
5199 5198
1853 1552
1983 1982
2005 1982
2118 1982
2178 1966
831 835
2015 1982
825 835
5196 884
1855 1552
2276 1982
2300 1982
5195 4000
1856 1552
1994 1982
2143 1982
2261 1982
2294 1982
1858 1552
2072 1982
2278 1982
3551 1982
1859 1552
2129 1982
2269 1982
2315 1982
1860 1552
1995 1982
2136 1982
2290 1982
1861 1552
1862 1552
2320 1982
3545 860
1863 1552
2343 1982
3479 3481
3483 3255
3524 3521
3519 3517
3515 3513
3511 3509
3507 3505
3503 3501
3499 3497
3495 3493
3549 3547
5190 5188
5200 5198
1864 1552
1865 1552
1866 1552
1867 1552
1868 1552
1869 1552
1872 1552
1873 1552
3484 3255
3537 3521
3520 3517
3516 3513
3512 3509
3508 3505
3504 3501
3500 3497
3496 3493
5191 5188
5201 5198
2878 2698
5192 5188
2802 2698
2923 2698
3115 2698
5193 5188
3023 2688
2690 2688
5194 5188