Sandbox

SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    6838, 
    6937, 
    6645, 
    5693, 
    7208, 
    6750, 
    6852, 
    5800, 
    6565, 
    7128, 
    6738, 
    6461, 
    5584, 
    5851, 
    5675, 
    8833, 
    8973, 
    5525, 
    6739, 
    5596, 
    5678, 
    5603, 
    5651, 
    5957, 
    8790, 
    7535, 
    5857, 
    5865, 
    5880, 
    5771, 
    5599, 
    5694, 
    5686, 
    5881, 
    5877, 
    5784, 
    5797, 
    7105, 
    6736, 
    8959, 
    8963, 
    5506, 
    6123, 
    8801, 
    5933, 
    7101, 
    8850, 
    6407, 
    6866, 
    8800, 
    6651, 
    8818, 
    8799, 
    5963, 
    5983, 
    6077, 
    7093, 
    5690, 
    6939, 
    6148, 
    6278, 
    6358, 
    6441, 
    8946, 
    6874, 
    6190, 
    6211, 
    6274, 
    7510, 
    8794, 
    6347, 
    6401, 
    6413, 
    6507, 
    8819, 
    5511, 
    5519, 
    5725, 
    5656, 
    5590, 
    5696, 
    5848, 
    6134, 
    6959, 
    5669, 
    5863, 
    8972, 
    8974, 
    5612, 
    5666, 
    5673, 
    5713, 
    8953, 
    6469, 
    8791, 
    5970, 
    5889, 
    8834, 
    7218, 
    7156, 
    5767, 
    5887, 
    5806, 
    5981, 
    5778, 
    8960, 
    8964, 
    5712, 
    8806, 
    5763, 
    7121, 
    6142, 
    6113, 
    6670, 
    6954, 
    5608, 
    6757, 
    6753, 
    6969, 
    6672, 
    7118, 
    6421, 
    6031, 
    6000, 
    6096, 
    5898, 
    8820, 
    8802, 
    8803, 
    6163, 
    5818, 
    6858, 
    5814, 
    6771, 
    6368, 
    5749, 
    6455, 
    6584, 
    6242, 
    6226, 
    7513, 
    6888, 
    8795, 
    6793, 
    6360, 
    6466, 
    6516, 
    6444, 
    5706, 
    8947, 
    7536, 
    5737, 
    6289, 
    5672, 
    5721, 
    5858, 
    6971, 
    6267, 
    6775, 
    7177, 
    5908, 
    5822, 
    6811, 
    7084, 
    5871, 
    5577, 
    8957, 
    8975, 
    6479, 
    5899, 
    5992, 
    5897, 
    5835, 
    8965, 
    8793, 
    7233, 
    5719, 
    8824, 
    5840, 
    8835, 
    6173, 
    6680, 
    6772, 
    7175, 
    5796, 
    5619, 
    8954, 
    5950, 
    6036, 
    6011, 
    5991, 
    5639, 
    5701, 
    6993, 
    6437, 
    8805, 
    8822, 
    5759, 
    6468, 
    6880, 
    8804, 
    6256, 
    7516, 
    6141, 
    5860, 
    6687, 
    6949, 
    5826, 
    6372, 
    6478, 
    6529, 
    6457, 
    7147, 
    6392, 
    7537, 
    6604, 
    8948, 
    6302, 
    5905, 
    6990, 
    6822, 
    8784, 
    5728, 
    8976, 
    5909, 
    6043, 
    5878, 
    5868, 
    8958, 
    8796, 
    8826, 
    5925, 
    6492, 
    8836, 
    5726, 
    6697, 
    6109, 
    6001, 
    7252, 
    7186, 
    7195, 
    6132, 
    5647, 
    5809, 
    5623, 
    8810, 
    6279, 
    6484, 
    5630, 
    5765, 
    8955, 
    6287, 
    7519, 
    7010, 
    6491, 
    5834, 
    8949, 
    8823, 
    5837, 
    6899, 
    5869, 
    8966, 
    8807, 
    6790, 
    5926, 
    5707, 
    6153, 
    6380, 
    5923, 
    7005, 
    5738, 
    6064, 
    5918, 
    8961, 
    5891, 
    6104, 
    8849, 
    6705, 
    6509, 
    8827, 
    8977, 
    7259, 
    7204, 
    6017, 
    5682, 
    5632, 
    6292, 
    6496, 
    5774, 
    6178, 
    6300, 
    7520, 
    5734, 
    6539, 
    8837, 
    8812, 
    8950, 
    8956, 
    5652, 
    8825, 
    8808, 
    8797, 
    5850, 
    6802, 
    5936, 
    5948, 
    5817, 
    5932, 
    6079, 
    7024, 
    6816, 
    6682, 
    5930, 
    8962, 
    8945, 
    6271, 
    6794, 
    8828, 
    6515, 
    7217, 
    8978, 
    5904, 
    6029, 
    5640, 
    6311, 
    6505, 
    5786, 
    8798, 
    6322, 
    7521, 
    6337, 
    6553, 
    8951, 
    8838, 
    5661, 
    8809, 
    5743, 
    5828, 
    5941, 
    6034, 
    8981, 
    6700, 
    6396, 
    6829, 
    7238, 
    6520, 
    5730, 
    6325, 
    5649, 
    7524, 
    5917, 
    8967, 
    8814, 
    6391, 
    6572, 
    8829, 
    8979, 
    8952, 
    8839, 
    5792, 
    5752, 
    8811, 
    6723, 
    6895, 
    6450, 
    6215, 
    6537, 
    5770, 
    6409, 
    6041, 
    7526, 
    8968, 
    5655, 
    8840, 
    8815, 
    8980, 
    8830, 
    5801, 
    8813, 
    6588, 
    6831, 
    6606, 
    6235, 
    7374, 
    6921, 
    5780, 
    6429, 
    6063, 
    6548, 
    8969, 
    8841, 
    8821, 
    8816, 
    5662, 
    6610, 
    6918, 
    6624, 
    7385, 
    5847, 
    6527, 
    6071, 
    6976, 
    6558, 
    8970, 
    8817, 
    8842, 
    6626, 
    6702, 
    8831, 
    7561, 
    6550, 
    6994, 
    6089, 
    8971, 
    6569, 
    6647, 
    8832, 
    7572, 
    6638, 
    6721, 
    6105, 
    6585, 
    8843, 
    7587, 
    6839, 
    7022, 
    6126, 
    8844, 
    7593, 
    6853, 
    6147, 
    8845, 
    7046, 
    8846, 
    7065, 
    8847, 
    8848, 
    7503, 
    7534
  )

Query time 0.00203

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "880.62"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "range",
      "possible_keys": [
        "parent"
      ],
      "key": "parent",
      "used_key_parts": [
        "parent_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 2195,
      "rows_produced_per_join": 2195,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "441.62",
        "eval_cost": "439.00",
        "prefix_cost": "880.62",
        "data_read_per_join": "12M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (6838,6937,6645,5693,7208,6750,6852,5800,6565,7128,6738,6461,5584,5851,5675,8833,8973,5525,6739,5596,5678,5603,5651,5957,8790,7535,5857,5865,5880,5771,5599,5694,5686,5881,5877,5784,5797,7105,6736,8959,8963,5506,6123,8801,5933,7101,8850,6407,6866,8800,6651,8818,8799,5963,5983,6077,7093,5690,6939,6148,6278,6358,6441,8946,6874,6190,6211,6274,7510,8794,6347,6401,6413,6507,8819,5511,5519,5725,5656,5590,5696,5848,6134,6959,5669,5863,8972,8974,5612,5666,5673,5713,8953,6469,8791,5970,5889,8834,7218,7156,5767,5887,5806,5981,5778,8960,8964,5712,8806,5763,7121,6142,6113,6670,6954,5608,6757,6753,6969,6672,7118,6421,6031,6000,6096,5898,8820,8802,8803,6163,5818,6858,5814,6771,6368,5749,6455,6584,6242,6226,7513,6888,8795,6793,6360,6466,6516,6444,5706,8947,7536,5737,6289,5672,5721,5858,6971,6267,6775,7177,5908,5822,6811,7084,5871,5577,8957,8975,6479,5899,5992,5897,5835,8965,8793,7233,5719,8824,5840,8835,6173,6680,6772,7175,5796,5619,8954,5950,6036,6011,5991,5639,5701,6993,6437,8805,8822,5759,6468,6880,8804,6256,7516,6141,5860,6687,6949,5826,6372,6478,6529,6457,7147,6392,7537,6604,8948,6302,5905,6990,6822,8784,5728,8976,5909,6043,5878,5868,8958,8796,8826,5925,6492,8836,5726,6697,6109,6001,7252,7186,7195,6132,5647,5809,5623,8810,6279,6484,5630,5765,8955,6287,7519,7010,6491,5834,8949,8823,5837,6899,5869,8966,8807,6790,5926,5707,6153,6380,5923,7005,5738,6064,5918,8961,5891,6104,8849,6705,6509,8827,8977,7259,7204,6017,5682,5632,6292,6496,5774,6178,6300,7520,5734,6539,8837,8812,8950,8956,5652,8825,8808,8797,5850,6802,5936,5948,5817,5932,6079,7024,6816,6682,5930,8962,8945,6271,6794,8828,6515,7217,8978,5904,6029,5640,6311,6505,5786,8798,6322,7521,6337,6553,8951,8838,5661,8809,5743,5828,5941,6034,8981,6700,6396,6829,7238,6520,5730,6325,5649,7524,5917,8967,8814,6391,6572,8829,8979,8952,8839,5792,5752,8811,6723,6895,6450,6215,6537,5770,6409,6041,7526,8968,5655,8840,8815,8980,8830,5801,8813,6588,6831,6606,6235,7374,6921,5780,6429,6063,6548,8969,8841,8821,8816,5662,6610,6918,6624,7385,5847,6527,6071,6976,6558,8970,8817,8842,6626,6702,8831,7561,6550,6994,6089,8971,6569,6647,8832,7572,6638,6721,6105,6585,8843,7587,6839,7022,6126,8844,7593,6853,6147,8845,7046,8846,7065,8847,8848,7503,7534))"
    }
  }
}

Result

category_id	parent_id
5511	5506
5672	5506
8957	5506
8958	5506
8961	5506
8962	5506
8967	5506
8968	5506
8969	5506
8970	5506
8971	5506
5519	5511
8972	5511
5525	5519
5612	5519
5639	5519
5647	5519
5652	5519
5661	5519
8981	5519
5584	5577
5669	5577
7084	5577
8784	5577
8849	5577
8945	5577
5599	5584
5608	5584
5619	5584
5623	5584
5632	5584
5640	5584
5649	5584
5655	5584
5662	5584
5596	5590
5767	5590
5950	5590
6132	5590
6178	5590
6337	5590
6391	5590
6588	5590
6610	5590
6626	5590
6647	5590
5603	5596
5666	5596
5673	5596
5721	5596
5728	5596
5738	5596
5651	5603
5860	5630
5869	5630
5948	5630
6682	5630
6700	5630
6723	5630
6831	5630
6918	5630
5675	5669
5763	5669
5840	5669
5925	5669
6104	5669
6271	5669
6396	5669
6450	5669
6606	5669
6624	5669
6702	5669
6721	5669
6839	5669
6853	5669
7046	5669
7065	5669
5678	5673
5713	5673
5686	5675
5712	5675
5719	5675
5726	5675
5734	5675
5743	5675
5752	5675
5693	5682
5696	5682
5701	5682
5707	5682
5694	5686
5706	5686
5749	5690
5759	5690
5765	5690
5774	5690
5786	5690
5792	5690
5801	5690
7105	5690
7118	5690
7177	5690
7195	5690
5771	5763
5778	5763
5796	5763
5809	5763
5817	5763
5828	5763
5784	5767
5848	5767
5858	5767
5868	5767
5918	5767
5930	5767
5941	5767
5800	5780
5814	5780
5822	5780
5834	5780
5797	5784
5806	5784
5835	5784
5851	5840
5863	5840
5871	5840
5878	5840
5891	5840
5904	5840
5917	5840
5590	5847
5857	5847
6134	5847
6267	5847
6279	5847
6292	5847
6311	5847
6325	5847
6409	5847
6429	5847
6527	5847
6550	5847
6638	5847
7022	5847
5865	5857
5970	5857
5992	5857
6043	5857
6064	5857
6079	5857
5880	5865
5889	5865
5899	5865
5909	5865
5923	5865
5932	5865
5877	5868
5887	5868
5897	5868
5905	5868
5656	5869
5881	5869
5898	5869
5908	5869
5926	5869
5936	5869
5933	5925
6113	5925
6141	5925
6153	5925
5957	5948
5981	5948
5991	5948
6001	5948
6017	5948
6029	5948
6034	5948
6041	5948
6063	5948
6071	5948
6089	5948
6105	5948
6126	5948
6147	5948
5963	5950
6031	5950
6036	5950
6109	5950
5983	5963
6000	5963
6011	5963
6077	6036
6096	6036
6123	6104
6142	6104
6173	6104
6215	6104
6235	6104
6148	6132
6163	6132
6190	6178
6242	6178
6256	6178
6287	6178
6300	6178
6322	6178
6211	6190
6226	6190
6274	6256
6278	6271
6289	6271
6302	6271
6380	6271
6358	6325
6368	6325
6392	6325
6347	6337
6360	6337
6372	6337
6401	6391
6466	6391
6478	6391
6491	6391
6539	6391
6553	6391
6572	6391
6407	6396
6421	6396
6437	6396
6413	6401
6444	6401
6457	6401
6441	6429
6455	6429
6468	6429
6484	6429
6496	6429
6505	6429
6461	6450
6469	6450
6479	6450
6492	6450
6509	6450
6515	6450
6520	6450
6537	6450
6548	6450
6558	6450
6569	6450
6585	6450
6507	6491
6516	6491
6529	6491
6565	6550
6584	6550
6604	6550
6645	6624
6672	6624
6687	6624
6651	6638
6670	6638
6680	6638
6697	6638
6705	6638
6794	6638
6829	6638
6895	6638
6921	6638
6976	6638
6994	6638
6739	6705
6757	6705
6772	6705
6736	6721
6793	6721
6811	6721
6822	6721
6738	6723
6753	6723
6775	6723
6790	6723
6802	6723
6816	6723
6750	6736
6771	6736
6852	6794
6838	6831
6858	6831
6880	6831
6899	6831
6866	6853
6969	6853
6993	6853
7010	6853
6874	6866
6888	6866
6949	6866
5690	6918
5818	6918
5826	6918
5837	6918
5850	6918
6937	6918
6954	6918
6971	6918
6990	6918
7005	6918
7024	6918
6939	6921
6959	6921
7093	7022
7503	7022
7534	7022
7101	7084
7121	7084
7147	7084
8949	7084
8950	7084
8951	7084
8952	7084
7128	7093
7156	7093
7175	7093
7186	7093
7204	7093
7217	7093
7238	7093
7374	7093
7385	7093
7561	7093
7572	7093
7587	7093
7593	7093
5725	7195
5737	7195
7208	7195
7218	7195
7233	7195
7252	7195
7259	7195
7510	7503
7513	7503
7516	7503
7519	7503
7520	7503
7521	7503
7524	7503
7526	7503
7535	7534
7536	7534
7537	7534
8790	8784
8791	8784
8793	8784
8796	8784
8797	8784
8798	8784
8814	8784
8815	8784
8816	8784
8817	8784
8831	8784
8832	8784
8843	8784
8844	8784
8845	8784
8846	8784
8847	8784
8848	8784
8794	8793
8795	8793
8801	8796
8806	8796
8824	8796
8826	8796
8827	8796
8828	8796
8829	8796
8830	8796
8799	8797
8802	8797
8804	8797
8807	8797
8808	8797
8809	8797
8811	8797
8813	8797
8800	8798
8803	8798
8805	8798
8810	8798
8812	8798
8819	8816
8821	8816
8818	8817
8820	8817
8822	8817
8823	8817
8825	8817
8833	8832
8834	8832
8835	8832
8836	8832
8837	8832
8838	8832
8839	8832
8840	8832
8841	8832
8842	8832
8850	8849
8953	8849
8954	8849
8955	8849
8956	8849
8946	8945
8947	8945
8948	8945
8959	8958
8960	8958
8963	8962
8964	8962
8965	8962
8966	8962
8973	8972
8974	8972
8975	8972
8976	8972
8977	8972
8978	8972
8979	8972
8980	8972