Sandbox

SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    32185, 
    32186, 
    10914, 
    10851, 
    21172, 
    1165, 
    20976, 
    19350, 
    21168, 
    37453, 
    19731, 
    37445, 
    12995, 
    2876, 
    23729, 
    37544, 
    12994, 
    10981, 
    37510, 
    37436, 
    10874, 
    10893, 
    37558, 
    7127, 
    37500, 
    16864, 
    37463, 
    19506, 
    11085, 
    23360, 
    19386, 
    20815, 
    23432, 
    23296, 
    10988, 
    3275, 
    37457, 
    23884, 
    7128, 
    21116, 
    10857, 
    20831, 
    19544, 
    19546, 
    19547, 
    19545, 
    20800, 
    37464, 
    20948, 
    20951, 
    20949, 
    20946, 
    20947, 
    20952, 
    20953, 
    20944, 
    20950, 
    20945, 
    10956, 
    7126, 
    37593, 
    37465, 
    20931, 
    10955, 
    37532, 
    10967, 
    19571, 
    37553, 
    21390, 
    20994, 
    28607, 
    20829, 
    28716, 
    23197, 
    23345, 
    23878, 
    37535, 
    37539, 
    37534, 
    37537, 
    23347, 
    10934, 
    37528, 
    37540, 
    37536, 
    37573, 
    37458, 
    10964, 
    5865, 
    23816, 
    23854, 
    37497, 
    20828, 
    23740, 
    5869, 
    16582, 
    23787, 
    20977, 
    5074, 
    19580, 
    3129, 
    19555, 
    21112, 
    37522, 
    37585, 
    37466, 
    21169, 
    37482, 
    37467, 
    37538, 
    3341, 
    21180, 
    5795, 
    20819, 
    37557, 
    23295, 
    5862, 
    28636, 
    20764, 
    11014, 
    20763, 
    20750, 
    20752, 
    20765, 
    20749, 
    20754, 
    20777, 
    20756, 
    20758, 
    20769, 
    20771, 
    20773, 
    20775, 
    20783, 
    20787, 
    20761, 
    20790, 
    20751, 
    20753, 
    20766, 
    20767, 
    20755, 
    20778, 
    20779, 
    20768, 
    20757, 
    20760, 
    20759, 
    20780, 
    20781, 
    20770, 
    21183, 
    20772, 
    21068, 
    20774, 
    20782, 
    20776, 
    20786, 
    20784, 
    20785, 
    20788, 
    20762, 
    20789, 
    20791, 
    21184, 
    19474, 
    21177, 
    37491, 
    37446, 
    37428, 
    7131, 
    19507, 
    21366, 
    10855, 
    37555, 
    3251, 
    30008, 
    37576, 
    37559, 
    23281, 
    23246, 
    37549, 
    37501, 
    19732, 
    19543, 
    21173, 
    19556, 
    10976, 
    5789, 
    23193, 
    37449, 
    3154, 
    21139, 
    13461, 
    13446, 
    10886, 
    17028, 
    21164, 
    19351, 
    37579, 
    37511, 
    37468, 
    20810, 
    23308, 
    20823, 
    37527, 
    37543, 
    23513, 
    23191, 
    37469, 
    19581, 
    21337, 
    21335, 
    21330, 
    21326, 
    21066, 
    21159, 
    21332, 
    21324, 
    21328, 
    21065, 
    37562, 
    37430, 
    37581, 
    37455, 
    37515, 
    37524, 
    37529, 
    37591, 
    37612, 
    37577, 
    10895, 
    37452, 
    21336, 
    21331, 
    21327, 
    21325, 
    21329, 
    20979, 
    10940, 
    37509, 
    37561, 
    37470, 
    11122, 
    5853, 
    37614, 
    10930, 
    15302, 
    37531, 
    37589, 
    13435, 
    37438, 
    1720, 
    23739, 
    23440, 
    3398, 
    37610, 
    37456, 
    20817, 
    23784, 
    37447, 
    17042, 
    23301, 
    23786, 
    37461, 
    37462, 
    37609, 
    7345, 
    37471, 
    37541, 
    37506, 
    37568, 
    37514, 
    8083, 
    37490, 
    20741, 
    20742, 
    5971, 
    37483, 
    21178, 
    3274, 
    23861, 
    23312, 
    21179, 
    21175, 
    8900, 
    37472, 
    37484, 
    37575, 
    37604, 
    37485, 
    23194, 
    5870, 
    23512, 
    37613, 
    37473, 
    21127, 
    21128, 
    37547, 
    2726, 
    23298, 
    37565, 
    37586, 
    37574, 
    19387, 
    37546, 
    5884, 
    10887, 
    6381, 
    20980, 
    23102, 
    37502, 
    37572, 
    37489, 
    37488, 
    37434, 
    37495, 
    37588, 
    37587, 
    21041, 
    37520, 
    37592, 
    37582, 
    10960, 
    28714, 
    16836, 
    21033, 
    5842, 
    37492, 
    37494, 
    3184, 
    5837, 
    37542, 
    3126, 
    37560, 
    17053, 
    1452, 
    8094, 
    37523, 
    37605, 
    20993, 
    21163, 
    21334, 
    21333, 
    10983, 
    21162, 
    23767, 
    37440, 
    37442, 
    37444, 
    37443, 
    37441, 
    20926, 
    3172, 
    10933, 
    37550, 
    37475, 
    1412, 
    37477, 
    19601, 
    11112, 
    16887, 
    3358, 
    3252, 
    37611, 
    37476, 
    8124, 
    37459, 
    37607, 
    10894, 
    7221, 
    21037, 
    37460, 
    37554, 
    11102, 
    7890, 
    3177, 
    37503, 
    37606, 
    37526, 
    21587, 
    37486, 
    1465, 
    37564, 
    37584, 
    37545, 
    37533, 
    37530, 
    1152, 
    21388, 
    23310, 
    23311, 
    21111, 
    19565, 
    11013, 
    37551, 
    37427, 
    37451, 
    37505, 
    16568, 
    8132, 
    19564, 
    11116, 
    37487, 
    37571, 
    3256, 
    37519, 
    6038, 
    13450, 
    37474, 
    21238, 
    7888, 
    10892, 
    20825, 
    3174, 
    37521, 
    23192, 
    37580, 
    37478, 
    10913, 
    37563, 
    37608, 
    37566, 
    1571
  )

Query time 0.00169

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "255.25"
    },
    "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": 1272,
      "rows_produced_per_join": 1272,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "128.05",
        "eval_cost": "127.20",
        "prefix_cost": "255.25",
        "data_read_per_join": "3M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (32185,32186,10914,10851,21172,1165,20976,19350,21168,37453,19731,37445,12995,2876,23729,37544,12994,10981,37510,37436,10874,10893,37558,7127,37500,16864,37463,19506,11085,23360,19386,20815,23432,23296,10988,3275,37457,23884,7128,21116,10857,20831,19544,19546,19547,19545,20800,37464,20948,20951,20949,20946,20947,20952,20953,20944,20950,20945,10956,7126,37593,37465,20931,10955,37532,10967,19571,37553,21390,20994,28607,20829,28716,23197,23345,23878,37535,37539,37534,37537,23347,10934,37528,37540,37536,37573,37458,10964,5865,23816,23854,37497,20828,23740,5869,16582,23787,20977,5074,19580,3129,19555,21112,37522,37585,37466,21169,37482,37467,37538,3341,21180,5795,20819,37557,23295,5862,28636,20764,11014,20763,20750,20752,20765,20749,20754,20777,20756,20758,20769,20771,20773,20775,20783,20787,20761,20790,20751,20753,20766,20767,20755,20778,20779,20768,20757,20760,20759,20780,20781,20770,21183,20772,21068,20774,20782,20776,20786,20784,20785,20788,20762,20789,20791,21184,19474,21177,37491,37446,37428,7131,19507,21366,10855,37555,3251,30008,37576,37559,23281,23246,37549,37501,19732,19543,21173,19556,10976,5789,23193,37449,3154,21139,13461,13446,10886,17028,21164,19351,37579,37511,37468,20810,23308,20823,37527,37543,23513,23191,37469,19581,21337,21335,21330,21326,21066,21159,21332,21324,21328,21065,37562,37430,37581,37455,37515,37524,37529,37591,37612,37577,10895,37452,21336,21331,21327,21325,21329,20979,10940,37509,37561,37470,11122,5853,37614,10930,15302,37531,37589,13435,37438,1720,23739,23440,3398,37610,37456,20817,23784,37447,17042,23301,23786,37461,37462,37609,7345,37471,37541,37506,37568,37514,8083,37490,20741,20742,5971,37483,21178,3274,23861,23312,21179,21175,8900,37472,37484,37575,37604,37485,23194,5870,23512,37613,37473,21127,21128,37547,2726,23298,37565,37586,37574,19387,37546,5884,10887,6381,20980,23102,37502,37572,37489,37488,37434,37495,37588,37587,21041,37520,37592,37582,10960,28714,16836,21033,5842,37492,37494,3184,5837,37542,3126,37560,17053,1452,8094,37523,37605,20993,21163,21334,21333,10983,21162,23767,37440,37442,37444,37443,37441,20926,3172,10933,37550,37475,1412,37477,19601,11112,16887,3358,3252,37611,37476,8124,37459,37607,10894,7221,21037,37460,37554,11102,7890,3177,37503,37606,37526,21587,37486,1465,37564,37584,37545,37533,37530,1152,21388,23310,23311,21111,19565,11013,37551,37427,37451,37505,16568,8132,19564,11116,37487,37571,3256,37519,6038,13450,37474,21238,7888,10892,20825,3174,37521,23192,37580,37478,10913,37563,37608,37566,1571))"
    }
  }
}

Result

category_id	parent_id
3252	3251
32186	10886
19351	19350
19543	19350
19564	19350
19580	19350
19581	19350
20749	19350
20979	19350
20980	19350
21033	19350
21037	19350
21112	19350
21127	19350
21128	19350
19387	19386
19571	19386
19601	19386
20741	19386
20742	19386
20810	19386
21164	19386
21169	19386
21238	19386
21366	19386
21177	19474
19507	19506
21587	19506
19545	19544
20800	19544
19546	19545
20944	19545
20946	19545
20948	19545
20952	19545
19547	19546
19556	19555
20815	19555
20817	19555
20819	19555
20823	19555
20825	19555
20828	19555
20829	19555
20831	19555
20926	19555
20931	19555
19565	19564
19732	19731
21139	19731
21180	19731
21333	19731
21388	19731
20750	20749
20752	20749
20754	20749
20756	20749
20758	20749
20761	20749
20763	20749
20765	20749
20769	20749
20771	20749
20773	20749
20775	20749
20777	20749
20783	20749
20787	20749
20790	20749
20751	20750
20753	20752
20755	20754
20757	20756
20768	20756
20759	20758
20760	20758
20762	20761
20789	20761
20764	20763
20766	20765
20767	20765
20770	20769
20780	20769
20781	20769
20772	20771
21183	20771
20774	20773
20782	20773
21068	20773
20776	20775
20778	20777
20779	20777
20784	20783
20785	20783
20786	20783
20788	20787
20791	20790
21184	20790
20945	20944
20950	20944
20947	20946
20949	20948
20951	20948
20953	20952
20977	20976
21041	20976
21111	20976
21116	20976
21162	20976
21179	20976
20994	20993
21390	20993
21066	21065
21159	21065
21324	21159
21326	21159
21328	21159
21330	21159
21332	21159
21335	21159
21337	21159
21163	21162
21334	21162
21173	21172
21175	21172
21325	21324
21327	21326
21329	21328
21331	21330
21336	21335
23192	23191
23432	23191
23193	23192
23194	23193
23345	23197
23347	23197
23281	23246
23310	23246
23816	23246
23884	23246
23296	23295
28607	23298
28714	23298
23308	23301
28636	23301
23311	23310
23360	23310
23861	23312
23878	23345
28716	23347
23513	23512
23740	23739
23854	23816
32185	30008