SELECT 
  category_id, 
  parent_id 
FROM 
  categories 
WHERE 
  parent_id IN(
    2952, 2977, 3007, 3008, 2995, 2929, 2984, 
    3016, 3015, 2985, 2986, 2919, 2988, 
    2971, 3009, 3010, 2949, 3011, 3012, 
    3014, 2947, 2982, 11373, 2973, 2920, 
    11372, 2951, 2987, 11374, 2930, 2981, 
    2946, 2898, 2921, 2972, 11369, 2989, 
    3017, 3018, 2529, 7760, 2901, 2894, 
    2909, 2963, 2900, 2528, 2964, 2911, 
    2895, 2896, 2913, 2965, 2530, 2890, 
    2531, 2914, 2966, 2893, 2532, 2899, 
    2892, 2968, 2970, 2902, 2932, 2891, 
    2956, 2944, 2991, 2974, 2918, 2967, 
    2916, 2903, 2978, 2915, 2948, 2962, 
    2928, 2957, 2943, 2975, 2969, 2953, 
    2960, 2980, 2945, 2983, 2954, 2961, 
    2955, 2979, 2959, 2958, 2993
  )

Query time 0.00130

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "36.72"
    },
    "table": {
      "table_name": "categories",
      "access_type": "range",
      "possible_keys": [
        "parent"
      ],
      "key": "parent",
      "used_key_parts": [
        "parent_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 180,
      "rows_produced_per_join": 180,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "18.72",
        "eval_cost": "18.00",
        "prefix_cost": "36.72",
        "data_read_per_join": "471K"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`goimagine`.`categories`.`parent_id` in (2952,2977,3007,3008,2995,2929,2984,3016,3015,2985,2986,2919,2988,2971,3009,3010,2949,3011,3012,3014,2947,2982,11373,2973,2920,11372,2951,2987,11374,2930,2981,2946,2898,2921,2972,11369,2989,3017,3018,2529,7760,2901,2894,2909,2963,2900,2528,2964,2911,2895,2896,2913,2965,2530,2890,2531,2914,2966,2893,2532,2899,2892,2968,2970,2902,2932,2891,2956,2944,2991,2974,2918,2967,2916,2903,2978,2915,2948,2962,2928,2957,2943,2975,2969,2953,2960,2980,2945,2983,2954,2961,2955,2979,2959,2958,2993))"
    }
  }
}