SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    30297, 
    36104, 
    41056, 
    30299, 
    30572, 
    35375, 
    40166, 
    40198, 
    36105, 
    36063, 
    32211, 
    39203, 
    36152, 
    40167, 
    36151, 
    30965, 
    36154, 
    40148, 
    40153, 
    30966, 
    40215, 
    36157, 
    36089, 
    36147, 
    41434, 
    40130, 
    30575, 
    40155, 
    40152, 
    36123, 
    36059, 
    35809, 
    36085, 
    40798, 
    36058, 
    41055, 
    39202, 
    40154, 
    30567, 
    36087, 
    40503, 
    38196, 
    41415, 
    40186, 
    30718, 
    40500, 
    40156, 
    36067, 
    35083, 
    39847, 
    35668, 
    39209, 
    30571, 
    40193, 
    40502, 
    36066, 
    36076, 
    36106, 
    41770, 
    36102, 
    41855, 
    40128, 
    38229, 
    40498, 
    36150, 
    40177, 
    41432, 
    42314, 
    40157, 
    35775, 
    36068, 
    36103, 
    40792, 
    40528, 
    40515, 
    40779, 
    41139, 
    40782, 
    40508, 
    40373, 
    12377, 
    40524, 
    40497, 
    12291, 
    295, 
    40794, 
    29492, 
    30213, 
    40527, 
    40529, 
    40516, 
    40780, 
    40783, 
    40509, 
    40795, 
    16209, 
    40374, 
    36065, 
    40531, 
    40781, 
    40784, 
    40517, 
    40796, 
    36062, 
    40510, 
    40375, 
    40797, 
    40532, 
    40785, 
    40376, 
    30239, 
    16293, 
    40518, 
    40511, 
    30250, 
    40533, 
    12347, 
    40786, 
    40377, 
    28866, 
    40519, 
    40512, 
    40534, 
    40787, 
    40378, 
    40513, 
    40520, 
    30717, 
    12526, 
    40535, 
    40521, 
    40930, 
    14399, 
    12326, 
    40379, 
    36061, 
    36125, 
    40496, 
    40536, 
    12531, 
    12298, 
    36127, 
    36099, 
    12450, 
    12517, 
    42568, 
    30379, 
    42600, 
    32182, 
    15848, 
    12297, 
    12415, 
    42888, 
    42556, 
    30284, 
    42615, 
    42558, 
    30228, 
    30319, 
    30233, 
    30229, 
    42897, 
    42566, 
    30227, 
    30391, 
    42567, 
    16340, 
    42569, 
    16343, 
    42570, 
    30311, 
    42614, 
    42896, 
    29493, 
    42906, 
    42574, 
    16362, 
    42575, 
    42576, 
    30218, 
    30224, 
    30219, 
    29091, 
    42900, 
    42618, 
    42621, 
    42579, 
    42587, 
    42911, 
    42562, 
    42593, 
    42577, 
    42578, 
    42912, 
    42580, 
    42560, 
    42583, 
    42563, 
    42582, 
    42613, 
    42585, 
    30226, 
    16415, 
    42588, 
    42589, 
    42590, 
    42604, 
    42559, 
    12495, 
    42889, 
    42616, 
    42617, 
    42892, 
    42565, 
    42594, 
    42596, 
    42597, 
    30283, 
    42598, 
    42599, 
    30222, 
    42557, 
    42902, 
    42907, 
    42609, 
    42601, 
    42612, 
    12358, 
    42903, 
    12365, 
    42602, 
    30251, 
    42603, 
    42605, 
    15757, 
    42898, 
    16374, 
    42606, 
    42571, 
    42607, 
    16494, 
    42608, 
    42564, 
    13054, 
    12296, 
    42573, 
    42905, 
    42890, 
    42561, 
    12401, 
    30223, 
    42592, 
    30356, 
    40143, 
    42610, 
    16210, 
    42620, 
    42619, 
    42611, 
    42586, 
    42591, 
    42901, 
    15639, 
    42581, 
    42595, 
    42572, 
    42555, 
    30542, 
    41069, 
    41147, 
    41140, 
    40507, 
    41071, 
    41148, 
    40514, 
    41141, 
    41149, 
    40522, 
    41150, 
    41143, 
    40523, 
    41151, 
    41152
  )

Query time 0.00119

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "170.21"
    },
    "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": 849,
      "rows_produced_per_join": 849,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "85.32",
        "eval_cost": "84.90",
        "prefix_cost": "170.22",
        "data_read_per_join": "2M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (30297,36104,41056,30299,30572,35375,40166,40198,36105,36063,32211,39203,36152,40167,36151,30965,36154,40148,40153,30966,40215,36157,36089,36147,41434,40130,30575,40155,40152,36123,36059,35809,36085,40798,36058,41055,39202,40154,30567,36087,40503,38196,41415,40186,30718,40500,40156,36067,35083,39847,35668,39209,30571,40193,40502,36066,36076,36106,41770,36102,41855,40128,38229,40498,36150,40177,41432,42314,40157,35775,36068,36103,40792,40528,40515,40779,41139,40782,40508,40373,12377,40524,40497,12291,295,40794,29492,30213,40527,40529,40516,40780,40783,40509,40795,16209,40374,36065,40531,40781,40784,40517,40796,36062,40510,40375,40797,40532,40785,40376,30239,16293,40518,40511,30250,40533,12347,40786,40377,28866,40519,40512,40534,40787,40378,40513,40520,30717,12526,40535,40521,40930,14399,12326,40379,36061,36125,40496,40536,12531,12298,36127,36099,12450,12517,42568,30379,42600,32182,15848,12297,12415,42888,42556,30284,42615,42558,30228,30319,30233,30229,42897,42566,30227,30391,42567,16340,42569,16343,42570,30311,42614,42896,29493,42906,42574,16362,42575,42576,30218,30224,30219,29091,42900,42618,42621,42579,42587,42911,42562,42593,42577,42578,42912,42580,42560,42583,42563,42582,42613,42585,30226,16415,42588,42589,42590,42604,42559,12495,42889,42616,42617,42892,42565,42594,42596,42597,30283,42598,42599,30222,42557,42902,42907,42609,42601,42612,12358,42903,12365,42602,30251,42603,42605,15757,42898,16374,42606,42571,42607,16494,42608,42564,13054,12296,42573,42905,42890,42561,12401,30223,42592,30356,40143,42610,16210,42620,42619,42611,42586,42591,42901,15639,42581,42595,42572,42555,30542,41069,41147,41140,40507,41071,41148,40514,41141,41149,40522,41150,41143,40523,41151,41152))"
    }
  }
}

Result

category_id parent_id
12291 295
12296 295
12298 295
13054 295
15757 295
30213 295
30239 295
30250 295
40930 295
41770 295
41855 295
42555 295
42560 295
42561 295
42562 295
42564 295
42566 295
42569 295
42570 295
42571 295
42572 295
42573 295
42576 295
42578 295
42579 295
42581 295
42585 295
42587 295
42590 295
42593 295
42595 295
42601 295
42603 295
42604 295
42605 295
42608 295
42612 295
42615 295
42616 295
42888 295
42890 295
42892 295
42896 295
42897 295
42901 295
42903 295
42905 295
42911 295
42912 295
12326 12291
12347 12291
12377 12291
12450 12291
12517 12291
12526 12291
12531 12291
36061 12291
36065 12291
36099 12291
36103 12291
36125 12291
36127 12291
40143 12291
41069 12291
12297 12296
12358 12296
12365 12296
12401 12296
12415 12298
12495 12298
15639 12298
30284 12298
42558 12298
36085 14399
39203 14399
40128 14399
40198 14399
15848 15757
16210 16209
16340 16209
16343 16209
16362 16209
16374 16209
16494 16209
29493 16209
30571 16209
30572 16209
30575 16209
30965 16209
32211 16209
35083 16209
35775 16209
36102 16209
36123 16209
39202 16209
39847 16209
40152 16209
40155 16209
40193 16209
40215 16209
41055 16209
41432 16209
42575 16209
42577 16209
42611 16209
42614 16209
29492 16210
36150 16210
16415 16293
29091 16293
30283 16293
30391 16293
30542 16293
30567 16293
36087 16293
40186 16293
40507 16293
40514 16293
40522 16293
40523 16293
40148 16340
40153 16340
40167 16340
41139 16340
40782 16343
40783 16343
40784 16343
40785 16343
40786 16343
40787 16343
36089 29493
36147 29493
36157 29493
41434 29493
30218 30213
30222 30213
30223 30213
30226 30213
30227 30213
30228 30213
30297 30213
41056 30213
41071 30213
42568 30213
42600 30213
30219 30218
30224 30218
30299 30218
41140 30218
41141 30218
41143 30218
30229 30228
30233 30228
30319 30228
41147 30228
41148 30228
41149 30228
41150 30228
41151 30228
41152 30228
30379 30239
30251 30250
30311 30250
30356 30250
32182 30250
42591 30250
40515 30567
40516 30567
40517 30567
40518 30567
40519 30567
40520 30567
40521 30567
30718 30717
35375 30717
35668 30717
36058 30717
36066 30717
36068 30717
36106 30717
38229 30717
39209 30717
40154 30717
40157 30717
40497 30717
40527 30717
30966 30965
36151 30965
36152 30965
36154 30965
40779 30965
40780 30965
40781 30965
40156 35375
35809 35775
36059 35775
36076 35775
36105 35775
40166 35775
40177 35775
40498 35775
40500 35775
40502 35775
40503 35775
40794 35775
40795 35775
40796 35775
40797 35775
40798 35775
36063 36062
38196 36062
40130 36062
41415 36065
36067 36066
40508 36087
40509 36087
40510 36087
40511 36087
40512 36087
40513 36087
36104 36103
40792 36125
40373 40130
40374 40130
40375 40130
40376 40130
40377 40130
40378 40130
40379 40130
40496 40130
40524 40186
40528 40527
40529 40527
40531 40527
40532 40527
40533 40527
40534 40527
40535 40527
40536 40527
42586 41770
42314 41855
42559 41855
42567 41855
42583 41855
42592 41855
42599 41855
42602 41855
42606 41855
42617 41855
42618 41855
42556 42555
42620 42555
42902 42555
42557 42556
42565 42556
42580 42556
42563 42562
42589 42562
42598 42562
42621 42562
42574 42573
42900 42573
42582 42581
42588 42587
42594 42593
42596 42595
42597 42595
42607 42595
42610 42595
42613 42595
42619 42595
42609 42608
42889 42888
42898 42890
42906 42905
42907 42905