SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    35523, 
    9726, 
    23598, 
    23605, 
    23602, 
    23601, 
    3288, 
    23734, 
    3356, 
    23535, 
    3124, 
    23566, 
    23600, 
    23521, 
    9749, 
    9735, 
    3214, 
    3211, 
    7899, 
    23594, 
    23517, 
    9753, 
    9739, 
    9754, 
    3388, 
    3289, 
    8081, 
    23540, 
    3304, 
    8095, 
    3156, 
    23558, 
    7893, 
    7892, 
    8140, 
    3125, 
    3221, 
    23593, 
    3198, 
    23731, 
    9752, 
    23555, 
    3195, 
    23572, 
    23585, 
    23568, 
    3218, 
    3159, 
    23537, 
    23564, 
    7905, 
    23587, 
    23736, 
    7902, 
    23771, 
    9718, 
    9720, 
    9723, 
    9740, 
    9755, 
    8098, 
    8122, 
    3120, 
    8082, 
    23589, 
    23592, 
    3155, 
    23548, 
    23579, 
    3194, 
    3176, 
    23554, 
    23581, 
    23580, 
    3193, 
    23770, 
    9748, 
    3302, 
    7889, 
    23528, 
    3405, 
    3192, 
    9738, 
    8126, 
    23783, 
    23526, 
    3247, 
    3279, 
    3276, 
    3208, 
    3362, 
    23578, 
    23545, 
    7906, 
    23565, 
    3119, 
    23536, 
    23553, 
    23577, 
    23547, 
    23583, 
    3161, 
    3253, 
    3160, 
    23544, 
    23590, 
    23591, 
    3281, 
    23514, 
    23561, 
    9734, 
    23556, 
    23576, 
    23742, 
    23609, 
    9713, 
    9730, 
    9750, 
    23569, 
    9736, 
    3340, 
    23570, 
    23582, 
    3286, 
    23574, 
    23575, 
    3191, 
    23773, 
    23515, 
    23550, 
    3280, 
    23563, 
    23516, 
    3190, 
    23737, 
    9733, 
    9751, 
    9719, 
    23608, 
    9743, 
    9712, 
    9729, 
    9722, 
    9714, 
    3182, 
    3197, 
    9711, 
    23533, 
    9710, 
    9709, 
    23497, 
    9741, 
    9725, 
    3385, 
    23562, 
    23782, 
    3189, 
    23730, 
    23531, 
    3290, 
    7894, 
    8089, 
    7895, 
    9760, 
    8084, 
    3250, 
    23603, 
    23606, 
    23604, 
    7903, 
    23584, 
    23551, 
    3162, 
    23552, 
    23519, 
    3188, 
    9724, 
    23772, 
    7907, 
    3342, 
    3173, 
    23588, 
    23557, 
    3287, 
    23543, 
    9747, 
    23732, 
    9746, 
    3213, 
    23599, 
    23596, 
    23595, 
    23529, 
    23546, 
    23518, 
    3187, 
    9745, 
    9716, 
    9732, 
    3413, 
    3255, 
    3383, 
    9715, 
    3175, 
    23549, 
    3206, 
    3316, 
    3186, 
    23538, 
    23539, 
    23559, 
    3207, 
    23530, 
    3196, 
    23534, 
    23532, 
    23541, 
    8102, 
    23560, 
    23586, 
    8133, 
    23567, 
    23573, 
    8099, 
    23542, 
    9737, 
    23527, 
    23520, 
    3185, 
    9742, 
    9717, 
    9731, 
    9744, 
    23597, 
    23571
  )

Query time 0.08521

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "141.81"
    },
    "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": 705,
      "rows_produced_per_join": 705,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "71.32",
        "eval_cost": "70.50",
        "prefix_cost": "141.82",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (35523,9726,23598,23605,23602,23601,3288,23734,3356,23535,3124,23566,23600,23521,9749,9735,3214,3211,7899,23594,23517,9753,9739,9754,3388,3289,8081,23540,3304,8095,3156,23558,7893,7892,8140,3125,3221,23593,3198,23731,9752,23555,3195,23572,23585,23568,3218,3159,23537,23564,7905,23587,23736,7902,23771,9718,9720,9723,9740,9755,8098,8122,3120,8082,23589,23592,3155,23548,23579,3194,3176,23554,23581,23580,3193,23770,9748,3302,7889,23528,3405,3192,9738,8126,23783,23526,3247,3279,3276,3208,3362,23578,23545,7906,23565,3119,23536,23553,23577,23547,23583,3161,3253,3160,23544,23590,23591,3281,23514,23561,9734,23556,23576,23742,23609,9713,9730,9750,23569,9736,3340,23570,23582,3286,23574,23575,3191,23773,23515,23550,3280,23563,23516,3190,23737,9733,9751,9719,23608,9743,9712,9729,9722,9714,3182,3197,9711,23533,9710,9709,23497,9741,9725,3385,23562,23782,3189,23730,23531,3290,7894,8089,7895,9760,8084,3250,23603,23606,23604,7903,23584,23551,3162,23552,23519,3188,9724,23772,7907,3342,3173,23588,23557,3287,23543,9747,23732,9746,3213,23599,23596,23595,23529,23546,23518,3187,9745,9716,9732,3413,3255,3383,9715,3175,23549,3206,3316,3186,23538,23539,23559,3207,23530,3196,23534,23532,23541,8102,23560,23586,8133,23567,23573,8099,23542,9737,23527,23520,3185,9742,9717,9731,9744,23597,23571))"
    }
  }
}

Result

category_id parent_id
3120 3119
3159 3119
3182 3119
3206 3119
3208 3119
3218 3119
3247 3119
3253 3119
3276 3119
3279 3119
3281 3119
3286 3119
3287 3119
3362 3119
3385 3119
7903 3119
8081 3119
9709 3119
23497 3119
23514 3119
23783 3119
3125 3124
3185 3124
3186 3124
3187 3124
3188 3124
3189 3124
3190 3124
3191 3124
3192 3124
3193 3124
3194 3124
3198 3124
7902 3124
8133 3124
35523 3124
3156 3155
3160 3155
3161 3155
3173 3155
3175 3155
3195 3155
3196 3155
3211 3155
3213 3155
3214 3155
3221 3155
3250 3155
3255 3155
3280 3155
3288 3155
3289 3155
3302 3155
3304 3155
3316 3155
3340 3155
3342 3155
3383 3155
3388 3155
3405 3155
3413 3155
7889 3155
7905 3155
8082 3155
8095 3155
8122 3155
23734 3155
3162 3161
3176 3175
3197 3196
3207 3206
3290 3289
7893 7892
7899 7892
8126 7892
8140 7892
7895 7894
8084 7894
8089 7894
9760 7894
7906 7905
7907 7906
8099 8098
8102 8098
9710 9709
9725 9709
9741 9709
9712 9711
9714 9711
9719 9711
9722 9711
9729 9711
9743 9711
23608 9711
9713 9712
9724 9712
9742 9712
9745 9712
9747 9712
9749 9712
9753 9712
23737 9712
23770 9712
23771 9712
9715 9714
9716 9715
9717 9715
9718 9715
9720 9719
9723 9722
9726 9725
9730 9729
9731 9729
9732 9729
9733 9729
9734 9729
9735 9729
9736 9729
9737 9729
9738 9729
9739 9729
9740 9729
9748 9729
23730 9729
23731 9729
23732 9729
23772 9729
23773 9729
9744 9743
9746 9743
9750 9743
9751 9743
9752 9743
9754 9743
9755 9743
23515 23514
23516 23515
23517 23515
23518 23515
23519 23515
23520 23515
23521 23515
23736 23515
23742 23515
23782 23515
23527 23526
23541 23526
23542 23526
23543 23526
23546 23526
23552 23526
23562 23526
23563 23526
23575 23526
23576 23526
23577 23526
23578 23526
23579 23526
23580 23526
23587 23526
23593 23526
23594 23526
23600 23526
23528 23527
23529 23527
23530 23527
23531 23527
23532 23527
23533 23527
23534 23527
23535 23527
23536 23527
23537 23527
23538 23527
23540 23527
23539 23538
23544 23543
23545 23543
23547 23546
23548 23546
23549 23546
23550 23546
23551 23546
23553 23552
23554 23552
23555 23552
23556 23552
23557 23552
23558 23552
23559 23552
23560 23552
23561 23552
23564 23563
23565 23563
23566 23563
23567 23563
23568 23563
23569 23563
23570 23563
23571 23563
23572 23563
23573 23563
23574 23563
23581 23580
23582 23580
23583 23580
23584 23580
23585 23580
23586 23580
23588 23587
23589 23587
23590 23587
23591 23587
23592 23587
23595 23594
23596 23594
23597 23594
23599 23594
23598 23597
23601 23600
23602 23600
23603 23600
23604 23600
23605 23600
23606 23600
23609 23608