SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    3064, 
    3201, 
    2926, 
    2931, 
    2940, 
    2951, 
    2978, 
    2983, 
    2989, 
    2993, 
    3014, 
    3017, 
    3040, 
    3052, 
    3073, 
    3079, 
    3087, 
    3116, 
    3140, 
    3145, 
    3149, 
    3153, 
    3159, 
    3181, 
    3187, 
    3192, 
    3197, 
    3206, 
    3212, 
    3217, 
    3234, 
    3253, 
    9595, 
    3096, 
    3221, 
    3237, 
    3243, 
    3250, 
    2961, 
    3427, 
    3108, 
    3340, 
    3092, 
    3022, 
    2998, 
    3321, 
    3353, 
    3424, 
    3239, 
    3271, 
    3431, 
    3028, 
    3004, 
    3326, 
    3344, 
    3118, 
    3359, 
    3093, 
    3244, 
    3275, 
    2967, 
    3433, 
    3034, 
    3327, 
    3143, 
    3366, 
    3248, 
    3099, 
    3352, 
    3439, 
    3281, 
    2972, 
    3010, 
    3440, 
    3445, 
    3103, 
    3146, 
    3357, 
    3331, 
    3447, 
    3384, 
    3154, 
    3448, 
    3361, 
    3452, 
    3160, 
    3379, 
    3456, 
    3182, 
    3189, 
    3196, 
    3204, 
    3208, 
    3215, 
    3256, 
    3259, 
    3264, 
    3270, 
    3276, 
    3282, 
    3306, 
    3308, 
    3309, 
    3312, 
    3314, 
    3317, 
    3318, 
    3323, 
    3334, 
    3335, 
    3338, 
    3343, 
    3386, 
    3401, 
    3412, 
    3414, 
    3423, 
    3425, 
    3453, 
    3454, 
    3459, 
    3461, 
    3462, 
    3468, 
    3469, 
    3472, 
    3478, 
    3487, 
    3488, 
    3491, 
    3498, 
    3507
  )

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "71.54"
    },
    "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": 176,
      "rows_produced_per_join": 176,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "36.34",
        "eval_cost": "35.20",
        "prefix_cost": "71.54",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (3064,3201,2926,2931,2940,2951,2978,2983,2989,2993,3014,3017,3040,3052,3073,3079,3087,3116,3140,3145,3149,3153,3159,3181,3187,3192,3197,3206,3212,3217,3234,3253,9595,3096,3221,3237,3243,3250,2961,3427,3108,3340,3092,3022,2998,3321,3353,3424,3239,3271,3431,3028,3004,3326,3344,3118,3359,3093,3244,3275,2967,3433,3034,3327,3143,3366,3248,3099,3352,3439,3281,2972,3010,3440,3445,3103,3146,3357,3331,3447,3384,3154,3448,3361,3452,3160,3379,3456,3182,3189,3196,3204,3208,3215,3256,3259,3264,3270,3276,3282,3306,3308,3309,3312,3314,3317,3318,3323,3334,3335,3338,3343,3386,3401,3412,3414,3423,3425,3453,3454,3459,3461,3462,3468,3469,3472,3478,3487,3488,3491,3498,3507))"
    }
  }
}

Result

category_id parent_id
2961 2951
2967 2951
2972 2951
2998 2993
3004 2993
3010 2993
3022 3017
3028 3017
3034 3017
3092 3087
3093 3087
3099 3087
3103 3087
3108 3096
3118 3096
3143 3096
3146 3096
3154 3096
3160 3096
3182 3096
3189 3096
3196 3096
3204 3096
3208 3096
3215 3096
3239 3234
3244 3234
3248 3234
3271 3264
3275 3264
3281 3264
3321 3317
3326 3317
3327 3317
3331 3317
3340 3335
3344 3335
3352 3335
3357 3335
3361 3335
3379 3335
3353 3343
3359 3343
3366 3343
3384 3343
3424 3414
3433 3414
3440 3414
3447 3414
3452 3414
3456 3414
3427 3425
3431 3425
3439 3425
3445 3425
3448 3425