Sandbox

SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    23059, 
    22782, 
    22505, 
    22766, 
    22849, 
    22959, 
    22973, 
    22592, 
    22826, 
    23142, 
    22957, 
    22939, 
    22893, 
    22990, 
    22985, 
    23021, 
    23051, 
    22862, 
    22759, 
    22712, 
    22763, 
    22675, 
    22760, 
    22847, 
    22786, 
    22839, 
    22546, 
    22814, 
    22876, 
    22547, 
    23006, 
    22631, 
    22643, 
    22639, 
    22645, 
    22640, 
    22647, 
    23007, 
    23068, 
    23066, 
    22646, 
    22926, 
    22563, 
    22542, 
    22917, 
    22920, 
    23161, 
    22787, 
    22776, 
    22928, 
    22910, 
    22762, 
    22624, 
    22896, 
    23146, 
    23121, 
    22982, 
    22880, 
    22543, 
    22666, 
    22680, 
    22498, 
    22586, 
    22580, 
    22714, 
    22738, 
    22676, 
    22673, 
    22613, 
    22881, 
    22890, 
    22929, 
    22934, 
    22878, 
    22827, 
    22909, 
    22778, 
    22784, 
    22623, 
    22711, 
    22496, 
    23084, 
    22503, 
    22915, 
    22866, 
    22633, 
    23063, 
    23061, 
    23134, 
    22816, 
    22818, 
    22879, 
    23028, 
    23038, 
    23039, 
    22817, 
    22813, 
    22508, 
    23037, 
    22523, 
    22598, 
    23118, 
    23050, 
    22597, 
    22831, 
    22807, 
    22512, 
    22904, 
    22765, 
    22956, 
    23067, 
    22497, 
    22883, 
    22761, 
    22509, 
    22515, 
    22510, 
    22856, 
    22716, 
    22677, 
    22741, 
    22650, 
    22903, 
    22972, 
    22974, 
    22975, 
    22968, 
    22981, 
    22885, 
    22963, 
    22889, 
    23047, 
    23045, 
    22809, 
    22833, 
    22837, 
    22906, 
    22549, 
    22892, 
    22550, 
    23148, 
    23062, 
    22846, 
    22774, 
    22745, 
    22685, 
    22719, 
    22661, 
    22694, 
    22791, 
    22887, 
    23008, 
    22997, 
    22995, 
    22594, 
    22504, 
    22795, 
    22548, 
    22649, 
    22561, 
    22511, 
    22554, 
    23032, 
    22808, 
    22832, 
    22513, 
    22518, 
    22642, 
    23154, 
    22933, 
    22932, 
    22923, 
    22855, 
    22951, 
    22941, 
    22914, 
    22911, 
    22916, 
    22992, 
    22560, 
    22516, 
    22977, 
    23073, 
    23052, 
    23054, 
    23119, 
    22991, 
    22858, 
    22988, 
    22522, 
    22636, 
    22524, 
    22902, 
    22950, 
    22918, 
    22927, 
    22653, 
    22797, 
    22678, 
    23048, 
    23079, 
    22494, 
    22870, 
    23022, 
    22841, 
    23023, 
    22994, 
    22967, 
    22930, 
    22946, 
    22576, 
    22573, 
    22768, 
    22587, 
    22581, 
    22850, 
    22616, 
    23125, 
    22584, 
    22578, 
    22996, 
    22608, 
    22993, 
    22986, 
    22970, 
    23015, 
    22619, 
    23041, 
    22559, 
    22936, 
    22905, 
    22938, 
    22507, 
    22811, 
    22607, 
    22853, 
    22721, 
    22743, 
    22564, 
    22610, 
    22900, 
    23056, 
    22601, 
    22829, 
    22806, 
    22942, 
    22525, 
    22823, 
    22822, 
    23091, 
    23016, 
    23017, 
    22558, 
    22777, 
    22965, 
    22599, 
    22824, 
    22526, 
    22886, 
    22568, 
    22783, 
    22767, 
    22567, 
    22499, 
    22571, 
    22570, 
    22620, 
    22628, 
    22779, 
    22794, 
    22842, 
    22519, 
    22520, 
    22632, 
    22637, 
    22707, 
    22790, 
    22769, 
    22897, 
    22612, 
    22894, 
    22506, 
    23210, 
    22527, 
    22634, 
    22715, 
    22654, 
    22686, 
    22691, 
    22739, 
    22629, 
    22899, 
    22964, 
    23089, 
    22825, 
    22821, 
    22744, 
    22655, 
    22720, 
    22692, 
    22756, 
    22667, 
    22700, 
    22733, 
    22492, 
    22500, 
    22622, 
    22670, 
    22801, 
    23036, 
    23046, 
    22770, 
    22840, 
    22922, 
    22865, 
    22704, 
    22545, 
    22912, 
    22556, 
    22551, 
    22552, 
    23002, 
    22528, 
    23033, 
    23029, 
    23027, 
    23025, 
    23055, 
    22627, 
    22861, 
    22751, 
    22664, 
    22728, 
    22709, 
    23040, 
    22948, 
    23139, 
    22657, 
    22798, 
    22585, 
    22579, 
    22575, 
    22882, 
    22943, 
    22901, 
    22848, 
    22998, 
    22529, 
    22617, 
    23057, 
    22572, 
    22955, 
    22851, 
    22530, 
    22969, 
    22565, 
    22689, 
    22852, 
    23085, 
    22860, 
    22989, 
    22531, 
    22962, 
    23010, 
    23049, 
    22949, 
    23014, 
    23020, 
    23092, 
    23074, 
    23075, 
    22944, 
    22979, 
    23090, 
    23077, 
    23160, 
    22574, 
    22595, 
    22495, 
    22789, 
    23003, 
    23138, 
    23144, 
    22630, 
    22931, 
    22961, 
    22514, 
    23011, 
    22600, 
    22602, 
    22749, 
    22672, 
    22725, 
    22708, 
    22764, 
    23013, 
    22958, 
    22748, 
    22687, 
    22723, 
    22662, 
    22703, 
    23019, 
    22681, 
    22717, 
    22697, 
    22740, 
    22663, 
    23012, 
    22978, 
    23065, 
    22820, 
    22810, 
    22834, 
    22830, 
    22954, 
    22772, 
    22618, 
    22952, 
    22836, 
    22953, 
    23096, 
    23135, 
    23129, 
    23137, 
    23108, 
    23124, 
    23098, 
    23140, 
    23099, 
    23101, 
    23095, 
    23111, 
    23110, 
    23106, 
    23147, 
    23155, 
    23107, 
    23158, 
    23104, 
    23126, 
    23122, 
    23123, 
    23128, 
    23162, 
    23150, 
    23130, 
    23105, 
    23149, 
    23141, 
    23112, 
    23102, 
    23136, 
    23097, 
    23153, 
    23114, 
    23133, 
    23109, 
    23145, 
    23132, 
    23156, 
    23100, 
    23094, 
    23103, 
    23143, 
    23117, 
    23115, 
    23152, 
    23151, 
    23034, 
    23024, 
    23030, 
    22532, 
    22980, 
    23042, 
    23082, 
    23088, 
    23127, 
    22614, 
    22605, 
    22606, 
    23131, 
    22871, 
    22895, 
    22753, 
    22730, 
    22671, 
    22706, 
    22976, 
    22845, 
    22501, 
    22591, 
    22863, 
    22940, 
    23070, 
    22868, 
    22864, 
    23000, 
    23060, 
    23076, 
    22888, 
    22891, 
    22596, 
    22593, 
    22872, 
    23116, 
    22493, 
    23058, 
    23004, 
    22937, 
    22638, 
    23009, 
    22771, 
    22898, 
    22947, 
    22984, 
    22615, 
    22983, 
    22815, 
    22999, 
    22569, 
    22577, 
    22788, 
    23087, 
    22544, 
    22935, 
    22626, 
    22690, 
    22688, 
    22758, 
    22734, 
    22674, 
    22710, 
    22750, 
    22724, 
    22702, 
    22668, 
    22644, 
    22800, 
    22533, 
    22583, 
    22588, 
    22582, 
    22683, 
    22658, 
    22757, 
    23043, 
    22867, 
    22908, 
    22534, 
    23120, 
    22641, 
    22693, 
    22660, 
    22747, 
    22684, 
    22722, 
    22907, 
    22792, 
    22590, 
    22553, 
    22746, 
    22659, 
    22726, 
    22695, 
    22854, 
    22966, 
    23053, 
    22828, 
    22921, 
    22924, 
    22875, 
    22913, 
    22621, 
    22869, 
    23078, 
    22859, 
    22609, 
    22773, 
    22731, 
    22799, 
    22698, 
    23018, 
    22603, 
    22775, 
    22682, 
    22718, 
    22656, 
    22696, 
    22742, 
    22755, 
    22665, 
    22732, 
    22705, 
    23081, 
    22812, 
    22835, 
    22536, 
    23035, 
    23026, 
    23031, 
    22557, 
    22535, 
    23005, 
    22521, 
    23064, 
    23071, 
    22611, 
    22537, 
    22625, 
    22971, 
    22925, 
    22635, 
    22589, 
    22679, 
    22713, 
    22652, 
    22737, 
    22843, 
    22648, 
    22877, 
    23083, 
    22857, 
    23157, 
    23159, 
    22555, 
    23086, 
    23069, 
    22793, 
    22780, 
    22752, 
    22727, 
    22699, 
    22736, 
    22735, 
    23113, 
    22919, 
    22538, 
    22785, 
    22987, 
    22754, 
    22729, 
    22669, 
    22701, 
    23093, 
    23044, 
    23072, 
    22540, 
    22539, 
    22844, 
    22541, 
    22502, 
    22960, 
    23001, 
    22781, 
    22796, 
    22805, 
    22804, 
    22802, 
    22803, 
    22819, 
    22604, 
    22874, 
    22651, 
    22566, 
    22945, 
    23080, 
    22517, 
    22873, 
    22884
  ) 
  AND category_id != 1

Query time 0.00054

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_categories",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY", "parent", "p_category_id"],
          "rows": 2670,
          "filtered": 100,
          "attached_condition": "cscart_categories.parent_id in (23059,22782,22505,22766,22849,22959,22973,22592,22826,23142,22957,22939,22893,22990,22985,23021,23051,22862,22759,22712,22763,22675,22760,22847,22786,22839,22546,22814,22876,22547,23006,22631,22643,22639,22645,22640,22647,23007,23068,23066,22646,22926,22563,22542,22917,22920,23161,22787,22776,22928,22910,22762,22624,22896,23146,23121,22982,22880,22543,22666,22680,22498,22586,22580,22714,22738,22676,22673,22613,22881,22890,22929,22934,22878,22827,22909,22778,22784,22623,22711,22496,23084,22503,22915,22866,22633,23063,23061,23134,22816,22818,22879,23028,23038,23039,22817,22813,22508,23037,22523,22598,23118,23050,22597,22831,22807,22512,22904,22765,22956,23067,22497,22883,22761,22509,22515,22510,22856,22716,22677,22741,22650,22903,22972,22974,22975,22968,22981,22885,22963,22889,23047,23045,22809,22833,22837,22906,22549,22892,22550,23148,23062,22846,22774,22745,22685,22719,22661,22694,22791,22887,23008,22997,22995,22594,22504,22795,22548,22649,22561,22511,22554,23032,22808,22832,22513,22518,22642,23154,22933,22932,22923,22855,22951,22941,22914,22911,22916,22992,22560,22516,22977,23073,23052,23054,23119,22991,22858,22988,22522,22636,22524,22902,22950,22918,22927,22653,22797,22678,23048,23079,22494,22870,23022,22841,23023,22994,22967,22930,22946,22576,22573,22768,22587,22581,22850,22616,23125,22584,22578,22996,22608,22993,22986,22970,23015,22619,23041,22559,22936,22905,22938,22507,22811,22607,22853,22721,22743,22564,22610,22900,23056,22601,22829,22806,22942,22525,22823,22822,23091,23016,23017,22558,22777,22965,22599,22824,22526,22886,22568,22783,22767,22567,22499,22571,22570,22620,22628,22779,22794,22842,22519,22520,22632,22637,22707,22790,22769,22897,22612,22894,22506,23210,22527,22634,22715,22654,22686,22691,22739,22629,22899,22964,23089,22825,22821,22744,22655,22720,22692,22756,22667,22700,22733,22492,22500,22622,22670,22801,23036,23046,22770,22840,22922,22865,22704,22545,22912,22556,22551,22552,23002,22528,23033,23029,23027,23025,23055,22627,22861,22751,22664,22728,22709,23040,22948,23139,22657,22798,22585,22579,22575,22882,22943,22901,22848,22998,22529,22617,23057,22572,22955,22851,22530,22969,22565,22689,22852,23085,22860,22989,22531,22962,23010,23049,22949,23014,23020,23092,23074,23075,22944,22979,23090,23077,23160,22574,22595,22495,22789,23003,23138,23144,22630,22931,22961,22514,23011,22600,22602,22749,22672,22725,22708,22764,23013,22958,22748,22687,22723,22662,22703,23019,22681,22717,22697,22740,22663,23012,22978,23065,22820,22810,22834,22830,22954,22772,22618,22952,22836,22953,23096,23135,23129,23137,23108,23124,23098,23140,23099,23101,23095,23111,23110,23106,23147,23155,23107,23158,23104,23126,23122,23123,23128,23162,23150,23130,23105,23149,23141,23112,23102,23136,23097,23153,23114,23133,23109,23145,23132,23156,23100,23094,23103,23143,23117,23115,23152,23151,23034,23024,23030,22532,22980,23042,23082,23088,23127,22614,22605,22606,23131,22871,22895,22753,22730,22671,22706,22976,22845,22501,22591,22863,22940,23070,22868,22864,23000,23060,23076,22888,22891,22596,22593,22872,23116,22493,23058,23004,22937,22638,23009,22771,22898,22947,22984,22615,22983,22815,22999,22569,22577,22788,23087,22544,22935,22626,22690,22688,22758,22734,22674,22710,22750,22724,22702,22668,22644,22800,22533,22583,22588,22582,22683,22658,22757,23043,22867,22908,22534,23120,22641,22693,22660,22747,22684,22722,22907,22792,22590,22553,22746,22659,22726,22695,22854,22966,23053,22828,22921,22924,22875,22913,22621,22869,23078,22859,22609,22773,22731,22799,22698,23018,22603,22775,22682,22718,22656,22696,22742,22755,22665,22732,22705,23081,22812,22835,22536,23035,23026,23031,22557,22535,23005,22521,23064,23071,22611,22537,22625,22971,22925,22635,22589,22679,22713,22652,22737,22843,22648,22877,23083,22857,23157,23159,22555,23086,23069,22793,22780,22752,22727,22699,22736,22735,23113,22919,22538,22785,22987,22754,22729,22669,22701,23093,23044,23072,22540,22539,22844,22541,22502,22960,23001,22781,22796,22805,22804,22802,22803,22819,22604,22874,22651,22566,22945,23080,22517,22873,22884) and cscart_categories.category_id <> 1"
        }
      }
    ]
  }
}

Result

category_id	parent_id
22493	22492
22494	22492
22495	22492
22496	22492
22497	22492
22498	22492
22499	22492
22500	22492
22501	22492
22502	22492
22503	22492
22504	22492
22505	22492
22507	22506
22508	22506
22509	22506
22510	22506
22511	22506
22512	22506
22513	22506
22514	22506
22515	22506
22516	22506
22517	22506
22518	22506
22519	22506
22520	22506
22521	22506
22522	22506
22523	22506
22524	22506
22525	22506
22526	22506
22527	22506
22528	22506
22529	22506
22530	22506
22531	22506
22532	22506
22533	22506
22534	22506
22535	22506
22536	22506
22537	22506
22538	22506
22539	22506
22540	22506
22541	22506
22543	22542
22544	22542
22546	22545
22547	22545
22548	22545
22549	22545
22550	22545
22551	22545
22552	22545
22553	22552
22554	22552
22555	22552
22556	22552
22557	22545
22558	22557
22559	22557
22560	22557
22561	22557
22564	22563
22565	22564
22566	22564
22567	22563
22568	22567
22569	22567
22570	22567
22571	22567
22572	22563
22573	22572
22574	22572
22575	22572
22576	22572
22577	22563
22578	22577
22579	22577
22580	22577
22581	22577
22582	22577
22583	22563
22584	22583
22585	22583
22586	22583
22587	22583
22588	22583
22589	22563
22591	22590
22592	22590
22593	22590
22594	22593
22595	22593
22596	22590
22597	22590
22598	22597
22599	22597
22601	22600
22602	22601
22603	22601
22604	22601
22605	22600
22606	22600
22607	22606
22608	22606
22609	22606
22610	22606
22611	22606
22612	22606
22613	22606
22614	22606
22615	22600
22616	22600
22617	22600
22618	22600
22619	22600
22620	22600
22622	22621
22623	22621
22624	22621
22625	22621
22626	22621
22627	22621
22628	22621
22629	22621
22630	22621
22631	22621
22632	22621
22633	22621
22635	22634
22636	22634
22637	22634
22638	22634
22640	22639
22641	22639
22642	22639
22643	22639
22644	22639
22645	22639
22646	22639
22647	22639
22648	22639
22649	22639
22651	22650
22652	22651
22653	22651
22654	22651
22655	22651
22656	22651
22657	22651
22658	22651
22659	22651
22660	22651
22661	22651
22662	22651
22663	22651
22664	22651
22665	22651
22666	22651
22667	22651
22668	22651
22669	22651
22670	22651
22671	22651
22672	22651
22673	22651
22674	22651
22675	22650
22676	22675
22677	22675
22678	22675
22679	22675
22680	22675
22681	22675
22682	22675
22683	22675
22684	22675
22685	22675
22686	22675
22687	22675
22688	22675
22689	22650
22690	22689
22691	22689
22692	22689
22693	22689
22694	22689
22695	22689
22696	22689
22697	22689
22698	22689
22699	22689
22700	22689
22701	22689
22702	22689
22703	22689
22704	22689
22705	22689
22706	22689
22707	22689
22708	22689
22709	22689
22710	22689
22711	22650
22712	22711
22713	22711
22714	22711
22715	22711
22716	22711
22717	22711
22718	22711
22719	22711
22720	22711
22721	22711
22722	22711
22723	22711
22724	22711
22725	22711
22726	22711
22727	22711
22728	22711
22729	22711
22730	22711
22731	22711
22732	22711
22733	22711
22734	22711
22735	22650
22736	22735
22737	22735
22738	22735
22739	22735
22740	22735
22741	22735
22742	22735
22743	22735
22744	22735
22745	22735
22746	22735
22747	22735
22748	22735
22749	22735
22750	22735
22751	22735
22752	22735
22753	22735
22754	22735
22755	22735
22756	22735
22757	22735
22758	22735
22759	22650
22760	22759
22761	22759
22762	22759
22763	22759
22764	22759
22765	22759
22766	22650
22767	22766
22768	22766
22769	22766
22770	22766
22771	22766
22772	22766
22773	22766
22774	22766
22775	22766
22776	22766
22777	22766
22778	22766
22779	22766
22780	22766
22782	22781
22783	22782
22784	22782
22785	22782
22786	22782
22787	22782
22788	22782
22789	22782
22790	22782
22791	22782
22792	22782
22793	22782
22794	22782
22795	22782
22796	22781
22797	22796
22798	22796
22799	22796
22800	22796
22801	22796
22802	22781
22803	22781
22804	22781
22805	22781
22806	22805
22807	22805
22808	22805
22809	22805
22810	22805
22811	22805
22812	22805
22813	22805
22814	22781
22815	22814
22816	22814
22817	22814
22818	22814
22819	22781
22821	22820
22822	22821
22823	22821
22824	22821
22825	22821
22826	22821
22827	22821
22828	22820
22829	22830
22830	22828
22831	22830
22832	22830
22833	22830
22834	22830
22835	22830
22836	22828
22837	22781
22840	22839
22841	22839
22842	22839
22843	22839
22844	22839
22845	22839
22846	22839
22847	22839
22848	22839
22849	22839
22850	22839
22851	22839
22852	22839
22853	22839
22854	22839
22855	22839
22856	22839
22858	22857
22859	22857
22860	22857
22861	22857
22862	22857
22863	22857
22864	22857
22865	22857
22866	22857
22867	22857
22868	22857
22869	22857
22870	22857
22871	22857
22872	22857
22873	22857
22874	22857
22875	22857
22876	22857
22877	22857
22879	22878
22880	22878
22881	22878
22882	22878
22883	22878
22884	22878
22885	22878
22886	22878
22887	22878
22888	22878
22889	22878
22890	22878
22891	22878
22892	22878
22893	22878
22894	22878
22895	22878
22896	22878
22897	22878
22898	22878
22899	22878
22901	22900
22902	22901
22903	22901
22904	22901
22905	22901
22906	22901
22907	22901
22908	22901
22909	22901
22910	22901
22911	22900
22912	22911
22913	22911
22914	22911
22915	22911
22916	22911
22917	22900
22918	22917
22919	22917
22920	22917
22921	22917
22922	22900
22923	22922
22924	22922
22925	22922
22926	22922
22927	22922
22928	22922
22929	22922
22930	22900
22931	22900
22932	22931
22933	22931
22934	22931
22935	22931
22937	22936
22938	22936
22940	22939
22941	22940
22942	22940
22943	22940
22944	22940
22945	22940
22946	22940
22947	22940
22948	22940
22949	22940
22950	22939
22951	22950
22952	22950
22953	22950
22954	22950
22955	22950
22956	22950
22957	22950
22958	22939
22959	22958
22960	22958
22961	22958
22962	22958
22963	22958
22964	22958
22965	22958
22966	22958
22967	22958
22968	22939
22969	22968
22970	22968
22971	22968
22972	22968
22973	22968
22974	22968
22975	22968
22976	22968
22977	22968
22978	22968
22979	22968
22980	22939
22981	22980
22982	22980
22983	22980
22984	22939
22985	22984
22986	22984
22987	22984
22988	22939
22989	22988
22990	22988
22991	22988
22992	22988
22993	22939
22994	22993
22995	22993
22996	22993
22997	22993
22998	22993
22999	22993
23000	22993
23001	22993
23002	22993
23003	22993
23004	22993
23005	22993
23006	22993
23007	22993
23008	22993
23009	22993
23010	22939
23011	23010
23012	23010
23013	23010
23014	23010
23015	22939
23016	22939
23017	23016
23018	23016
23019	23016
23020	23016
23021	22939
23023	23022
23024	23023
23025	23023
23026	23023
23027	23023
23028	23023
23029	23023
23030	23023
23031	23023
23032	23022
23033	23032
23034	23032
23035	23032
23036	23032
23037	23022
23038	23022
23039	23038
23040	23038
23041	23038
23042	23038
23043	23038
23044	23022
23045	23022
23046	23045
23047	23045
23048	23045
23049	23045
23050	23022
23051	23022
23052	23022
23053	23052
23054	23052
23055	23052
23056	23022
23057	23022
23058	23057
23059	23057
23060	23057
23061	23022
23062	23061
23063	23061
23064	23022
23065	23022
23066	23022
23067	23066
23068	23066
23069	23022
23070	23069
23071	23069
23072	23069
23073	23022
23075	23074
23076	23075
23077	23075
23078	23077
23079	23077
23080	23077
23081	23077
23082	23077
23083	23077
23084	23077
23085	23077
23086	23077
23087	23075
23088	23075
23089	23075
23090	23075
23091	23075
23092	23074
23093	23074
23095	23094
23096	23095
23097	23096
23098	23096
23099	23096
23100	23096
23101	23095
23102	23101
23103	23101
23104	23101
23105	23101
23106	23101
23107	23101
23108	23101
23109	23095
23110	23094
23111	23110
23112	23110
23113	23094
23114	23113
23115	23113
23116	23094
23117	23094
23118	23117
23119	23117
23120	23117
23121	23117
23122	23094
23123	23122
23124	23122
23125	23122
23126	23122
23127	23122
23128	23094
23129	23128
23130	23128
23131	23128
23132	23128
23133	23128
23134	23128
23135	23094
23136	23135
23137	23135
23138	23135
23139	23135
23140	23094
23141	23140
23142	23140
23143	23140
23144	23140
23145	23140
23146	23140
23147	23140
23148	23140
23149	23094
23150	23149
23151	23149
23152	23149
23153	23149
23154	23149
23155	23149
23156	23094
23157	23094
23158	23157
23159	23157
23160	23157
23161	23094
23162	23094
23210	22506