SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    5111, 
    5365, 
    23282, 
    8908, 
    23399, 
    20794, 
    6628, 
    2699, 
    20792, 
    1266, 
    19445, 
    1201, 
    1044, 
    29881, 
    23265, 
    20975, 
    20835, 
    20830, 
    8781, 
    23252, 
    23255, 
    20827, 
    21157, 
    1325, 
    23307, 
    2696, 
    23323, 
    1090, 
    2706, 
    20834, 
    8780, 
    23256, 
    1375, 
    23262, 
    28622, 
    23855, 
    23840, 
    23258, 
    19548, 
    19577, 
    21091, 
    5187, 
    23276, 
    23230, 
    19566, 
    5772, 
    5716, 
    19491, 
    13057, 
    20927, 
    19446, 
    1345, 
    23847, 
    23264, 
    19541, 
    1310, 
    19540, 
    2700, 
    19497, 
    1318, 
    1131, 
    21323, 
    20793, 
    20968, 
    20923, 
    21141, 
    2689, 
    23306, 
    23393, 
    23332, 
    19542, 
    1306, 
    2702, 
    7162, 
    7203, 
    7204, 
    7202, 
    7205, 
    7212, 
    5432, 
    7230, 
    5417, 
    7233, 
    5385, 
    7231, 
    5386, 
    7232, 
    5752, 
    5748, 
    5751, 
    5749, 
    5750, 
    7196, 
    7200, 
    7199, 
    7209, 
    7182, 
    7181, 
    7217, 
    7215, 
    7207, 
    7206, 
    7211, 
    7210, 
    5406, 
    5754, 
    5755, 
    5149, 
    5146, 
    7213, 
    5148, 
    5147, 
    5139, 
    5136, 
    5137, 
    5138, 
    5141, 
    5140, 
    5142, 
    5144, 
    5143, 
    7184, 
    7191, 
    7192, 
    7198, 
    7197, 
    7194, 
    7186, 
    7189, 
    7193, 
    7187, 
    7188, 
    5122, 
    5130, 
    5134, 
    5118, 
    5132, 
    5120, 
    5115, 
    5116, 
    5133, 
    5124, 
    5126, 
    5131, 
    5366, 
    5113, 
    5114, 
    5127, 
    5117, 
    5125, 
    5121, 
    5123, 
    5128, 
    5119, 
    5129, 
    7201, 
    5375, 
    5384, 
    5747, 
    7195, 
    7208, 
    5371, 
    23465, 
    5388, 
    7216, 
    7214, 
    5377, 
    23463, 
    5390, 
    23464, 
    23462, 
    5753, 
    5145, 
    5135, 
    7183, 
    7190, 
    7185, 
    5112, 
    21171, 
    1088, 
    23263, 
    20928, 
    20929, 
    21583, 
    20925, 
    2643, 
    7122, 
    2642, 
    19827, 
    2382, 
    2616, 
    19568, 
    20924, 
    20930, 
    20961, 
    21089, 
    1264, 
    21115, 
    1114, 
    1279, 
    6794, 
    1205, 
    23277, 
    19756, 
    1207, 
    6795, 
    2686, 
    2790
  )

Query time 0.00092

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "125.17"
    },
    "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": 624,
      "rows_produced_per_join": 624,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "62.77",
        "eval_cost": "62.40",
        "prefix_cost": "125.17",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (5111,5365,23282,8908,23399,20794,6628,2699,20792,1266,19445,1201,1044,29881,23265,20975,20835,20830,8781,23252,23255,20827,21157,1325,23307,2696,23323,1090,2706,20834,8780,23256,1375,23262,28622,23855,23840,23258,19548,19577,21091,5187,23276,23230,19566,5772,5716,19491,13057,20927,19446,1345,23847,23264,19541,1310,19540,2700,19497,1318,1131,21323,20793,20968,20923,21141,2689,23306,23393,23332,19542,1306,2702,7162,7203,7204,7202,7205,7212,5432,7230,5417,7233,5385,7231,5386,7232,5752,5748,5751,5749,5750,7196,7200,7199,7209,7182,7181,7217,7215,7207,7206,7211,7210,5406,5754,5755,5149,5146,7213,5148,5147,5139,5136,5137,5138,5141,5140,5142,5144,5143,7184,7191,7192,7198,7197,7194,7186,7189,7193,7187,7188,5122,5130,5134,5118,5132,5120,5115,5116,5133,5124,5126,5131,5366,5113,5114,5127,5117,5125,5121,5123,5128,5119,5129,7201,5375,5384,5747,7195,7208,5371,23465,5388,7216,7214,5377,23463,5390,23464,23462,5753,5145,5135,7183,7190,7185,5112,21171,1088,23263,20928,20929,21583,20925,2643,7122,2642,19827,2382,2616,19568,20924,20930,20961,21089,1264,21115,1114,1279,6794,1205,23277,19756,1207,6795,2686,2790))"
    }
  }
}

Result

category_id parent_id
1205 1090
1279 1114
6794 1114
1318 1131
1207 1205
2382 1266
2699 1266
2643 2642
2696 2686
2702 2700
5112 5111
5135 5111
5145 5111
5365 5111
5371 5111
5375 5111
5377 5111
5384 5111
5388 5111
5390 5111
5747 5111
5753 5111
7183 5111
7185 5111
7190 5111
7195 5111
7201 5111
7208 5111
7214 5111
7216 5111
23462 5111
23463 5111
23464 5111
23465 5111
5113 5112
5114 5112
5115 5112
5116 5112
5117 5112
5118 5112
5119 5112
5120 5112
5121 5112
5122 5112
5123 5112
5124 5112
5125 5112
5126 5112
5127 5112
5128 5112
5129 5112
5130 5112
5131 5112
5132 5112
5133 5112
5134 5112
5366 5112
5136 5135
5137 5135
5138 5135
5139 5135
5140 5135
5141 5135
5142 5135
5143 5135
5144 5135
5146 5145
5147 5145
5148 5145
5149 5145
7213 5145
7212 5375
7206 5377
7207 5377
5385 5384
5386 5384
5417 5384
5432 5384
7230 5384
7231 5384
7232 5384
7233 5384
7181 5388
7182 5388
5406 5390
7210 5390
7211 5390
5748 5747
5749 5747
5750 5747
5751 5747
5752 5747
5754 5753
5755 5753
7184 7183
7186 7185
7187 7185
7188 7185
7189 7185
7193 7185
7194 7185
7197 7185
7198 7185
7191 7190
7192 7190
7196 7195
7199 7195
7200 7195
7202 7201
7203 7201
7204 7201
7205 7201
7209 7208
7215 7214
7217 7216
19446 19445
19491 19445
19568 19445
20830 19445
20923 19445
21141 19445
21171 19445
19542 19541
19548 19541
19577 19541
19827 19541
20792 19541
20827 19541
20834 19541
20924 19541
20930 19541
20961 19541
21089 19541
21091 19541
21115 19541
20794 20793
20835 20793
20968 20793
21157 20793
20925 20924
20927 20924
20929 20928
21583 20928
23276 23230
23255 23252
23855 23256
23262 23258
23840 23258
28622 23258
23265 23264
23847 23277
23399 23282
23307 23306
23323 23306
23332 23306
23393 23306