SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    34391, 
    30592, 
    30300, 
    34537, 
    32558, 
    34553, 
    30577, 
    32397, 
    33323, 
    36071, 
    34703, 
    32404, 
    32405, 
    32406, 
    41289, 
    34536, 
    36073, 
    41366, 
    30714, 
    32403, 
    30994, 
    33206, 
    32231, 
    6339, 
    884, 
    5158, 
    6334, 
    5080, 
    6335, 
    2645, 
    5079, 
    6336, 
    2778, 
    6337, 
    5554, 
    5459, 
    6338, 
    6623, 
    15016, 
    28650, 
    1569, 
    889, 
    6644, 
    1337, 
    6574, 
    28617, 
    6559, 
    2329, 
    6767, 
    5087, 
    2330, 
    28658, 
    989, 
    2219, 
    14939, 
    1334, 
    3116, 
    887, 
    28657, 
    1169, 
    3001, 
    1231, 
    5081, 
    2331, 
    7307, 
    3111, 
    2220, 
    1117, 
    2535, 
    954, 
    5167, 
    14966, 
    1321, 
    3657, 
    2322, 
    5098, 
    1297, 
    2590, 
    15013, 
    5076, 
    2333, 
    1021, 
    1022, 
    5097, 
    28652, 
    6772, 
    15307, 
    28627, 
    6563, 
    5100, 
    3107, 
    1149, 
    6768, 
    2995, 
    5109, 
    28563, 
    2336, 
    1328, 
    3572, 
    2284, 
    28651, 
    3102, 
    972, 
    2561, 
    2230, 
    6769, 
    5466, 
    311, 
    7132, 
    3117, 
    3100, 
    3110, 
    1931, 
    14928, 
    883, 
    28614, 
    6770, 
    28653, 
    2723, 
    5548, 
    1449, 
    28654, 
    2637, 
    2464, 
    848, 
    6771, 
    984, 
    3662, 
    5077, 
    1017, 
    5190, 
    28020, 
    967, 
    6766, 
    23396, 
    6333, 
    6773, 
    13058, 
    30411, 
    8787, 
    28751, 
    921, 
    7308, 
    30388, 
    30470, 
    30005, 
    30421, 
    30427, 
    30423, 
    29387, 
    42904, 
    7324, 
    29624, 
    29709, 
    7180, 
    30426, 
    30430, 
    30414, 
    30415, 
    5688, 
    7134, 
    37603, 
    30432, 
    30420, 
    7160, 
    30425, 
    2631, 
    28376, 
    30436, 
    30439, 
    30434, 
    7147, 
    13060, 
    2771, 
    30441, 
    30443, 
    3579, 
    30417, 
    30444, 
    5685, 
    2481, 
    30438, 
    30465, 
    30466, 
    30462, 
    30467, 
    7133, 
    30442, 
    29181, 
    7109, 
    13059, 
    29009, 
    13024, 
    5606, 
    5683, 
    2483, 
    28692, 
    849, 
    28699, 
    30413, 
    13026, 
    30424, 
    2715, 
    4496, 
    28752, 
    7220, 
    1019, 
    30446, 
    30419, 
    30437, 
    8782, 
    12980, 
    30416, 
    12940, 
    30447, 
    30450, 
    30451, 
    12938, 
    12939, 
    28664, 
    28375, 
    30449, 
    7148, 
    30418, 
    30453, 
    30002, 
    12944, 
    29708, 
    7222, 
    2063, 
    1601, 
    5774, 
    5773, 
    6942, 
    11917, 
    7158, 
    29175, 
    29180, 
    29179, 
    29707, 
    7159, 
    30428, 
    1616, 
    5467, 
    13029, 
    5437, 
    7325, 
    30461, 
    3005, 
    30541, 
    30452, 
    30543, 
    30454, 
    5603, 
    1084, 
    5458, 
    2498, 
    30455, 
    29029, 
    30431, 
    30457, 
    30429, 
    12941, 
    30458, 
    8788, 
    29010, 
    12981, 
    12963, 
    28964, 
    28750, 
    30412, 
    30422, 
    28615, 
    5691, 
    12942, 
    28669, 
    13025, 
    1576, 
    30435, 
    5687, 
    30433, 
    7382, 
    30440, 
    30448, 
    30456, 
    30459, 
    5083, 
    2529, 
    5693, 
    29114, 
    30445, 
    29024, 
    28686, 
    30093, 
    6765, 
    7161, 
    6793, 
    28758, 
    14789, 
    28759, 
    15306, 
    15309, 
    15311
  )

Query time 0.00213

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "182.38"
    },
    "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": 909,
      "rows_produced_per_join": 909,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "91.48",
        "eval_cost": "90.90",
        "prefix_cost": "182.38",
        "data_read_per_join": "2M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (34391,30592,30300,34537,32558,34553,30577,32397,33323,36071,34703,32404,32405,32406,41289,34536,36073,41366,30714,32403,30994,33206,32231,6339,884,5158,6334,5080,6335,2645,5079,6336,2778,6337,5554,5459,6338,6623,15016,28650,1569,889,6644,1337,6574,28617,6559,2329,6767,5087,2330,28658,989,2219,14939,1334,3116,887,28657,1169,3001,1231,5081,2331,7307,3111,2220,1117,2535,954,5167,14966,1321,3657,2322,5098,1297,2590,15013,5076,2333,1021,1022,5097,28652,6772,15307,28627,6563,5100,3107,1149,6768,2995,5109,28563,2336,1328,3572,2284,28651,3102,972,2561,2230,6769,5466,311,7132,3117,3100,3110,1931,14928,883,28614,6770,28653,2723,5548,1449,28654,2637,2464,848,6771,984,3662,5077,1017,5190,28020,967,6766,23396,6333,6773,13058,30411,8787,28751,921,7308,30388,30470,30005,30421,30427,30423,29387,42904,7324,29624,29709,7180,30426,30430,30414,30415,5688,7134,37603,30432,30420,7160,30425,2631,28376,30436,30439,30434,7147,13060,2771,30441,30443,3579,30417,30444,5685,2481,30438,30465,30466,30462,30467,7133,30442,29181,7109,13059,29009,13024,5606,5683,2483,28692,849,28699,30413,13026,30424,2715,4496,28752,7220,1019,30446,30419,30437,8782,12980,30416,12940,30447,30450,30451,12938,12939,28664,28375,30449,7148,30418,30453,30002,12944,29708,7222,2063,1601,5774,5773,6942,11917,7158,29175,29180,29179,29707,7159,30428,1616,5467,13029,5437,7325,30461,3005,30541,30452,30543,30454,5603,1084,5458,2498,30455,29029,30431,30457,30429,12941,30458,8788,29010,12981,12963,28964,28750,30412,30422,28615,5691,12942,28669,13025,1576,30435,5687,30433,7382,30440,30448,30456,30459,5083,2529,5693,29114,30445,29024,28686,30093,6765,7161,6793,28758,14789,28759,15306,15309,15311))"
    }
  }
}

Result

category_id parent_id
2219 311
2220 311
13024 311
13025 311
13026 311
849 848
887 848
889 848
954 848
989 848
5458 848
8782 848
30994 848
311 883
1931 883
2230 883
2284 883
2322 883
2329 883
2330 883
2331 883
2333 883
2336 883
2561 883
2590 883
2637 883
2715 883
2723 883
3001 883
3102 883
3107 883
3110 883
3111 883
3116 883
3117 883
3572 883
3657 883
12938 883
12939 883
12940 883
12941 883
12942 883
12944 883
12980 883
12981 883
13029 883
28664 883
28699 883
28751 883
28752 883
29024 883
29175 883
29179 883
29181 883
29387 883
29624 883
29707 883
30300 883
32397 967
33206 972
1019 1017
1021 1017
1022 1017
1117 1017
1149 1017
1169 1017
1231 1017
1297 1017
1321 1017
1328 1017
1334 1017
1337 1017
1569 1017
5109 1017
7382 1017
12963 1017
13058 1017
13060 1017
28750 1017
30002 1017
30005 1017
34391 1017
37603 1017
41289 1017
5466 1337
6559 1337
6563 1337
7180 1337
34553 1337
13059 2284
29180 2284
2535 2995
3005 2995
5076 2995
5081 2995
5087 2995
5097 2995
5098 2995
5100 2995
5167 2995
5467 2995
5773 2995
5774 2995
6942 2995
7109 2995
7158 2995
7159 2995
7160 2995
7161 2995
7222 2995
11917 2995
28375 2995
28964 2995
34536 2995
921 3100
1576 3100
1616 3100
2481 3100
2483 3100
2498 3100
2631 3100
2771 3100
3579 3100
4496 3100
5437 3100
5603 3100
5606 3100
5683 3100
5687 3100
5688 3100
5691 3100
5693 3100
8787 3100
28669 3100
28692 3100
32231 3100
32558 3100
33323 3100
34537 3100
42904 3100
30461 3111
1084 3662
1601 3662
2063 3662
2529 3662
5083 3662
5685 3662
28686 3662
32403 3662
32404 3662
32405 3662
32406 3662
2778 5077
5079 5077
5080 5077
5158 5077
5459 5077
6574 5077
6623 5077
28657 5077
28658 5077
28758 5077
28759 5077
30714 5087
6334 6333
6335 6333
6336 6333
6337 6333
6338 6333
6339 6333
6644 6333
6765 6333
6793 6333
7347 6333
14789 6333
15306 6333
15307 6333
15309 6333
15311 6333
28615 6333
6767 6766
6768 6766
6769 6766
6770 6766
6771 6766
6772 6766
6773 6766
7308 6766
7324 6766
7325 6766
8788 6766
29009 6766
7133 7132
7134 7132
7220 7132
41366 7134
30592 14966
28617 23396
28627 23396
28376 28375
29029 28654
29010 28751
29708 29114
29709 29114
30388 29114
30577 29624
30541 29707
30543 30300
30412 30411
30422 30411
30413 30412
30417 30412
30419 30412
30421 30412
30424 30412
30425 30412
30427 30412
30432 30412
30433 30412
30436 30412
30439 30412
30441 30412
30442 30412
30445 30412
30446 30412
30447 30412
30450 30412
30451 30412
30452 30412
30453 30412
30454 30412
30455 30412
30457 30412
30458 30412
30459 30412
30414 30413
30415 30414
30416 30415
30418 30417
30420 30419
30423 30422
30426 30425
30428 30427
30429 30428
30430 30429
30431 30430
30434 30433
30435 30434
30437 30436
30438 30437
30440 30439
30443 30442
30444 30443
30448 30447
30449 30448
30456 30455
30462 30461
30465 30461
30466 30461
30467 30461
30470 30461
34703 34391
36071 34391
36073 34391