SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    3143, 
    3282, 
    3257, 
    7901, 
    23727, 
    23726, 
    23725, 
    23651, 
    23724, 
    23765, 
    23723, 
    3237, 
    23791, 
    23700, 
    23692, 
    23699, 
    3236, 
    23677, 
    23790, 
    3270, 
    23676, 
    23622, 
    23687, 
    3235, 
    3231, 
    3248, 
    23691, 
    23698, 
    23675, 
    23697, 
    3243, 
    3153, 
    3203, 
    3242, 
    23103, 
    3245, 
    3240, 
    3273, 
    3146, 
    3152, 
    3241, 
    3151, 
    3261, 
    3149, 
    3150, 
    23104, 
    3317, 
    3148, 
    23624, 
    23657, 
    3360, 
    3202, 
    3359, 
    3147, 
    3272, 
    3271, 
    3244, 
    3201, 
    23105, 
    3199, 
    3200, 
    3246, 
    3382, 
    3239, 
    3238, 
    3144, 
    3145, 
    8113, 
    3318, 
    3313, 
    29863, 
    29864, 
    29870, 
    29882, 
    19442, 
    20847, 
    21373, 
    21259, 
    20885, 
    21374, 
    21254, 
    20886, 
    21256, 
    21376, 
    21378, 
    21255, 
    20894, 
    21249, 
    29875, 
    29871, 
    20844, 
    20845, 
    29865, 
    20916, 
    20917, 
    20851, 
    20852, 
    3337, 
    3366, 
    3312, 
    3361, 
    3311, 
    3315, 
    3283, 
    9708, 
    3371, 
    3370, 
    3310, 
    3314, 
    3369, 
    3365, 
    29866, 
    29867, 
    29872, 
    20849, 
    20921, 
    21379, 
    21245, 
    20850, 
    20918, 
    20919, 
    20920, 
    29868, 
    20842, 
    20843, 
    20889, 
    20890, 
    29876, 
    14829, 
    20902, 
    29878, 
    29869, 
    21260, 
    21250, 
    3258, 
    3377, 
    3374, 
    3222, 
    3372, 
    3269, 
    23713, 
    23712, 
    23711, 
    23682, 
    3234, 
    23789, 
    23690, 
    23710, 
    3233, 
    23709, 
    23618, 
    23670, 
    3267, 
    23696, 
    23704, 
    23669, 
    23689, 
    23688, 
    23703, 
    23686, 
    23631, 
    23685, 
    23674, 
    3266, 
    23702, 
    23684, 
    3265, 
    23695, 
    23701, 
    3230, 
    23708, 
    23623, 
    3264, 
    23681, 
    3232, 
    23668, 
    3229, 
    23621, 
    23667, 
    9761, 
    23650, 
    23722, 
    23721, 
    23707, 
    23673, 
    3228, 
    23706, 
    23683, 
    3263, 
    23661, 
    23720, 
    23646, 
    23719, 
    23648, 
    23718, 
    23620, 
    23778, 
    3262, 
    23678, 
    3227, 
    23680, 
    3226, 
    23509, 
    23612, 
    23613, 
    23671, 
    23614, 
    23672, 
    23666, 
    23610, 
    23665, 
    23779, 
    23705, 
    3225, 
    23694, 
    3223, 
    3224, 
    23717, 
    23716, 
    23715, 
    23764, 
    23714, 
    23679, 
    23693, 
    28052, 
    14827, 
    14828, 
    28053, 
    28054
  )

Query time 0.00221

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "137.78"
    },
    "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": 687,
      "rows_produced_per_join": 687,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "69.09",
        "eval_cost": "68.70",
        "prefix_cost": "137.79",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (3143,3282,3257,7901,23727,23726,23725,23651,23724,23765,23723,3237,23791,23700,23692,23699,3236,23677,23790,3270,23676,23622,23687,3235,3231,3248,23691,23698,23675,23697,3243,3153,3203,3242,23103,3245,3240,3273,3146,3152,3241,3151,3261,3149,3150,23104,3317,3148,23624,23657,3360,3202,3359,3147,3272,3271,3244,3201,23105,3199,3200,3246,3382,3239,3238,3144,3145,8113,3318,3313,29863,29864,29870,29882,19442,20847,21373,21259,20885,21374,21254,20886,21256,21376,21378,21255,20894,21249,29875,29871,20844,20845,29865,20916,20917,20851,20852,3337,3366,3312,3361,3311,3315,3283,9708,3371,3370,3310,3314,3369,3365,29866,29867,29872,20849,20921,21379,21245,20850,20918,20919,20920,29868,20842,20843,20889,20890,29876,14829,20902,29878,29869,21260,21250,3258,3377,3374,3222,3372,3269,23713,23712,23711,23682,3234,23789,23690,23710,3233,23709,23618,23670,3267,23696,23704,23669,23689,23688,23703,23686,23631,23685,23674,3266,23702,23684,3265,23695,23701,3230,23708,23623,3264,23681,3232,23668,3229,23621,23667,9761,23650,23722,23721,23707,23673,3228,23706,23683,3263,23661,23720,23646,23719,23648,23718,23620,23778,3262,23678,3227,23680,3226,23509,23612,23613,23671,23614,23672,23666,23610,23665,23779,23705,3225,23694,3223,3224,23717,23716,23715,23764,23714,23679,23693,28052,14827,14828,28053,28054))"
    }
  }
}

Result

category_id parent_id
3144 3143
3145 3143
3146 3143
3147 3143
3148 3143
3149 3143
3150 3143
3151 3143
3152 3143
3153 3143
3199 3143
3200 3143
3201 3143
3202 3143
3203 3143
3238 3143
3239 3143
3240 3143
3241 3143
3242 3143
3243 3143
3244 3143
3245 3143
3246 3143
3261 3143
3271 3143
3272 3143
3273 3143
3317 3143
3359 3143
3360 3143
3382 3143
20842 3143
20844 3143
20847 3143
20849 3143
20851 3143
20885 3143
20889 3143
20894 3143
20902 3143
20916 3143
20918 3143
23103 3143
23104 3143
23105 3143
23624 3143
23657 3143
28052 3143
29863 3143
29864 3143
29865 3143
29866 3143
29867 3143
29868 3143
29869 3143
29870 3143
29871 3143
29872 3143
29875 3143
29876 3143
29878 3143
29882 3143
23509 3145
23610 3145
23612 3145
23618 3145
23620 3145
23621 3145
23622 3145
23623 3145
23779 3145
23791 3145
23650 3153
23651 3153
23765 3153
23646 3203
23648 3203
23661 3203
23764 3203
3223 3222
3224 3222
3225 3222
3226 3222
3227 3222
3228 3222
3229 3222
3230 3222
3231 3222
3232 3222
3233 3222
3234 3222
3235 3222
3236 3222
3237 3222
3262 3222
3263 3222
3264 3222
3265 3222
3266 3222
3267 3222
3269 3222
3270 3222
9761 3222
23678 3222
23701 3222
23702 3222
23703 3222
23704 3222
23713 3222
23665 3224
23666 3224
23667 3224
23668 3224
23669 3224
23670 3224
23671 3224
23778 3224
23673 3225
23674 3225
23675 3225
23676 3225
23677 3225
23790 3225
23683 3228
23684 3228
23685 3228
23686 3228
23687 3228
23688 3228
23689 3228
23690 3228
23691 3228
23692 3228
23693 3232
23694 3232
23695 3232
23696 3232
23697 3232
23698 3232
23699 3232
23700 3232
23631 3233
23705 3233
23706 3233
23707 3233
23708 3233
23709 3233
23710 3233
23711 3233
23712 3233
23789 3233
23721 3236
23722 3236
23723 3236
23724 3236
23725 3236
23726 3236
23727 3236
3258 3257
3374 3257
3377 3257
23679 3262
23680 3262
23681 3262
23682 3262
23714 3270
23715 3270
23716 3270
23717 3270
23718 3270
23719 3270
23720 3270
3283 3282
3310 3282
3311 3282
3312 3282
3313 3282
3314 3282
3315 3282
3318 3282
3337 3282
3361 3282
3365 3282
3366 3282
3369 3282
3370 3282
3371 3282
3372 3282
8113 3282
9708 3282
14827 3282
14828 3282
28053 3282
28054 3282
20843 20842
20845 20844
21259 20847
21373 20847
20850 20849
20921 20849
21245 20849
21379 20849
20852 20851
20886 20885
21254 20885
21255 20885
21256 20885
21374 20885
21376 20885
21378 20885
20890 20889
21249 20894
21250 20902
21260 20902
20917 20916
20919 20918
20920 20918
23613 23612
23614 23613
23672 23671