SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    37371, 
    39723, 
    37723, 
    39736, 
    30200, 
    31174, 
    39724, 
    41731, 
    36889, 
    3112, 
    1688, 
    1190, 
    1570, 
    6379, 
    5451, 
    19301, 
    2646, 
    1163, 
    19143, 
    5041, 
    19138, 
    10531, 
    1157, 
    935, 
    1129, 
    10583, 
    1001, 
    17700, 
    1026, 
    5043, 
    1166, 
    1167, 
    1346, 
    15736, 
    1218, 
    21681, 
    1008, 
    1043, 
    1042, 
    17643, 
    16605, 
    19318, 
    17349, 
    3571, 
    1133, 
    15709, 
    2978, 
    5454, 
    2718, 
    1181, 
    2849, 
    6853, 
    1006, 
    6991, 
    21656, 
    1176, 
    16600, 
    10647, 
    26441, 
    16631, 
    2724, 
    1863, 
    1221, 
    19212, 
    19213, 
    2968, 
    19311, 
    1039, 
    27275, 
    16621, 
    27871, 
    2534, 
    1383, 
    1215, 
    17426, 
    1005, 
    2845, 
    1051, 
    1089, 
    5154, 
    21672, 
    1339, 
    10495, 
    4558, 
    4560, 
    5027, 
    4557, 
    17332, 
    1172, 
    19264, 
    6636, 
    1037, 
    1352, 
    5156, 
    2856, 
    8779, 
    1220, 
    1040, 
    2553, 
    5065, 
    5066, 
    1156, 
    5049, 
    5565, 
    1032, 
    2920, 
    16598, 
    10746, 
    1359, 
    5053, 
    1194, 
    1193, 
    16622, 
    1871, 
    1033, 
    1128, 
    1371, 
    1338, 
    7218, 
    1369, 
    2531, 
    1097, 
    1197, 
    1240, 
    1239, 
    1198, 
    1204, 
    863, 
    2555, 
    1140, 
    6606, 
    1195, 
    19202, 
    862, 
    1380, 
    1191, 
    6637, 
    4559, 
    16606, 
    7344, 
    1192, 
    1302, 
    1048, 
    1171, 
    7007, 
    1188, 
    2405, 
    1309, 
    5176, 
    1362, 
    1153, 
    1372, 
    1139, 
    1100, 
    1101, 
    19280, 
    1113, 
    6583, 
    8797, 
    1000, 
    1199, 
    8914, 
    19142, 
    21611, 
    1161, 
    7129, 
    2597, 
    6840, 
    1685, 
    6854, 
    2558, 
    4441
  )

Query time 0.00143

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "48.72"
    },
    "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": 241,
      "rows_produced_per_join": 241,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "24.62",
        "eval_cost": "24.10",
        "prefix_cost": "48.72",
        "data_read_per_join": "625K"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`parent_id` in (37371,39723,37723,39736,30200,31174,39724,41731,36889,3112,1688,1190,1570,6379,5451,19301,2646,1163,19143,5041,19138,10531,1157,935,1129,10583,1001,17700,1026,5043,1166,1167,1346,15736,1218,21681,1008,1043,1042,17643,16605,19318,17349,3571,1133,15709,2978,5454,2718,1181,2849,6853,1006,6991,21656,1176,16600,10647,26441,16631,2724,1863,1221,19212,19213,2968,19311,1039,27275,16621,27871,2534,1383,1215,17426,1005,2845,1051,1089,5154,21672,1339,10495,4558,4560,5027,4557,17332,1172,19264,6636,1037,1352,5156,2856,8779,1220,1040,2553,5065,5066,1156,5049,5565,1032,2920,16598,10746,1359,5053,1194,1193,16622,1871,1033,1128,1371,1338,7218,1369,2531,1097,1197,1240,1239,1198,1204,863,2555,1140,6606,1195,19202,862,1380,1191,6637,4559,16606,7344,1192,1302,1048,1171,7007,1188,2405,1309,5176,1362,1153,1372,1139,1100,1101,19280,1113,6583,8797,1000,1199,8914,19142,21611,1161,7129,2597,6840,1685,6854,2558,4441))"
    }
  }
}

Result

category_id parent_id
863 862
1033 862
1037 862
1113 862
1133 862
1215 862
2555 862
2856 862
1032 935
1153 935
1157 935
1172 935
2553 935
1001 1000
1188 1000
1199 1000
1156 1001
2920 1001
21656 1001
21681 1001
31174 1001
1006 1005
1140 1005
1166 1005
1176 1005
6991 1005
1040 1006
1139 1006
1161 1006
1193 1006
1194 1006
1195 1006
1218 1006
6853 1006
7129 1006
8779 1006
1008 1026
1042 1026
1043 1026
7007 1026
30200 1026
2849 1048
1089 1051
1101 1100
6583 1100
1129 1128
2531 1129
1221 1163
1346 1163
1685 1163
2405 1163
2724 1163
2845 1163
1167 1166
1220 1166
7344 1166
2978 1172
5156 1172
1181 1176
2718 1176
8914 1190
41731 1190
1192 1191
1302 1191
1198 1197
1239 1197
1240 1197
1372 1197
1863 1221
1339 1338
1369 1338
1352 1339
1362 1339
1371 1339
1688 1685
1871 1685
3112 2558
3571 2558
7218 2558
4558 4557
4559 4558
4560 4559
5027 4560
5043 5041
5049 5041
10531 5041
10583 5041
10647 5041
10746 5041
5053 5049
5065 5053
5066 5053
6637 6636
6840 6636
19138 17332
19212 17332
19202 17426
27275 17643
27871 17643
19142 19138
19143 19142
19311 19143
21611 19143
19264 19202
19280 19202
19213 19212
21672 19212
37371 36889
37723 37371
39723 37371
39724 37371
39736 37723