SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    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, 
    19386, 
    10988, 
    3275, 
    37457, 
    7128, 
    10857, 
    19544, 
    37464, 
    10956, 
    7126, 
    37593, 
    37465, 
    10955, 
    37532, 
    10967, 
    37553, 
    23197, 
    37535, 
    37539, 
    37534, 
    37537, 
    10934, 
    37528, 
    37540, 
    37536, 
    37573, 
    37458, 
    10964, 
    5865, 
    37497, 
    5869, 
    16582, 
    23787, 
    5074, 
    3129, 
    19555, 
    37522, 
    37585, 
    37466, 
    37482, 
    37467, 
    37538, 
    3341, 
    5795, 
    37557, 
    23295, 
    5862, 
    11014, 
    19474, 
    37491, 
    37446, 
    37428, 
    7131, 
    10855, 
    37555, 
    3251, 
    30008, 
    37576, 
    37559, 
    23246, 
    37549, 
    37501, 
    10976, 
    5789, 
    37449, 
    3154, 
    13461, 
    13446, 
    10886, 
    17028, 
    37579, 
    37511, 
    37468, 
    37527, 
    37543, 
    23191, 
    37469, 
    21065, 
    37562, 
    37430, 
    37581, 
    37455, 
    37515, 
    37524, 
    37529, 
    37591, 
    37612, 
    37577, 
    10895, 
    37452, 
    10940, 
    37509, 
    37561, 
    37470, 
    11122, 
    5853, 
    37614, 
    10930, 
    15302, 
    37531, 
    37589, 
    13435, 
    37438, 
    1720, 
    23739, 
    23440, 
    3398, 
    37610, 
    37456, 
    23784, 
    37447, 
    17042, 
    23301, 
    23786, 
    37461, 
    37462, 
    37609, 
    7345, 
    37471, 
    37541, 
    37506, 
    37568, 
    37514, 
    8083, 
    37490, 
    5971, 
    37483, 
    21178, 
    3274, 
    23312, 
    8900, 
    37472, 
    37484, 
    37575, 
    37604, 
    37485, 
    5870, 
    23512, 
    37613, 
    37473, 
    37547, 
    2726, 
    23298, 
    37565, 
    37586, 
    37574, 
    37546, 
    5884, 
    10887, 
    6381, 
    23102, 
    37502, 
    37572, 
    37489, 
    37488, 
    37434, 
    37495, 
    37588, 
    37587, 
    37520, 
    37592, 
    37582, 
    10960, 
    16836, 
    5842, 
    37492, 
    37494, 
    3184, 
    5837, 
    37542, 
    3126, 
    37560, 
    17053, 
    1452, 
    8094, 
    37523, 
    37605, 
    20993, 
    10983, 
    23767, 
    37440, 
    37442, 
    37444, 
    37443, 
    37441, 
    3172, 
    10933, 
    37550, 
    37475, 
    1412, 
    37477, 
    11112, 
    16887, 
    3358, 
    37611, 
    37476, 
    8124, 
    37459, 
    37607, 
    10894, 
    7221, 
    37460, 
    37554, 
    11102, 
    7890, 
    3177, 
    37503, 
    37606, 
    37526, 
    37486, 
    1465, 
    37564, 
    37584, 
    37545, 
    37533, 
    37530, 
    1152, 
    11013, 
    37551, 
    37427, 
    37451, 
    37505, 
    16568, 
    8132, 
    11116, 
    37487, 
    37571, 
    3256, 
    37519, 
    6038, 
    13450, 
    37474, 
    7888, 
    10892, 
    3174, 
    37521, 
    37580, 
    37478, 
    10913, 
    37563, 
    37608, 
    37566, 
    1571
  )

Query time 0.00156

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "162.56"
    },
    "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": 810,
      "rows_produced_per_join": 810,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "81.56",
        "eval_cost": "81.00",
        "prefix_cost": "162.56",
        "data_read_per_join": "2M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (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,19386,10988,3275,37457,7128,10857,19544,37464,10956,7126,37593,37465,10955,37532,10967,37553,23197,37535,37539,37534,37537,10934,37528,37540,37536,37573,37458,10964,5865,37497,5869,16582,23787,5074,3129,19555,37522,37585,37466,37482,37467,37538,3341,5795,37557,23295,5862,11014,19474,37491,37446,37428,7131,10855,37555,3251,30008,37576,37559,23246,37549,37501,10976,5789,37449,3154,13461,13446,10886,17028,37579,37511,37468,37527,37543,23191,37469,21065,37562,37430,37581,37455,37515,37524,37529,37591,37612,37577,10895,37452,10940,37509,37561,37470,11122,5853,37614,10930,15302,37531,37589,13435,37438,1720,23739,23440,3398,37610,37456,23784,37447,17042,23301,23786,37461,37462,37609,7345,37471,37541,37506,37568,37514,8083,37490,5971,37483,21178,3274,23312,8900,37472,37484,37575,37604,37485,5870,23512,37613,37473,37547,2726,23298,37565,37586,37574,37546,5884,10887,6381,23102,37502,37572,37489,37488,37434,37495,37588,37587,37520,37592,37582,10960,16836,5842,37492,37494,3184,5837,37542,3126,37560,17053,1452,8094,37523,37605,20993,10983,23767,37440,37442,37444,37443,37441,3172,10933,37550,37475,1412,37477,11112,16887,3358,37611,37476,8124,37459,37607,10894,7221,37460,37554,11102,7890,3177,37503,37606,37526,37486,1465,37564,37584,37545,37533,37530,1152,11013,37551,37427,37451,37505,16568,8132,11116,37487,37571,3256,37519,6038,13450,37474,7888,10892,3174,37521,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
19556 19555
20815 19555
20817 19555
20819 19555
20823 19555
20825 19555
20828 19555
20829 19555
20831 19555
20926 19555
20931 19555
19732 19731
21139 19731
21180 19731
21333 19731
21388 19731
20977 20976
21041 20976
21111 20976
21116 20976
21162 20976
21179 20976
20994 20993
21390 20993
21066 21065
21159 21065
21173 21172
21175 21172
23192 23191
23432 23191
23345 23197
23347 23197
23281 23246
23310 23246
23816 23246
23884 23246
23296 23295
28607 23298
28714 23298
23308 23301
28636 23301
23861 23312
23513 23512
23740 23739
32185 30008