SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    9532, 
    9531, 
    9536, 
    9537, 
    5677, 
    3864, 
    3955, 
    3631, 
    3830, 
    6698, 
    3990, 
    3557, 
    3609, 
    3820, 
    3678, 
    3563, 
    4828, 
    7784, 
    3760, 
    7835, 
    3567, 
    3967, 
    3784, 
    3764, 
    3535, 
    3549, 
    3602, 
    3985, 
    3539, 
    3795, 
    3560, 
    8449, 
    3653, 
    3683, 
    3867, 
    4851, 
    3552, 
    3991, 
    3815, 
    3957, 
    3586, 
    3629, 
    3835, 
    3540, 
    3593, 
    3674, 
    5746, 
    3633, 
    3779, 
    7970, 
    3546, 
    7916, 
    6743, 
    3986, 
    3829, 
    3988, 
    8452, 
    3583, 
    3606, 
    3657, 
    3773, 
    3870, 
    4877, 
    3591, 
    3992, 
    3656, 
    3687, 
    3597, 
    3843, 
    8465, 
    3639, 
    3598, 
    3676, 
    3548, 
    5787, 
    3632, 
    3783, 
    3569, 
    6784, 
    3880, 
    3996, 
    3601, 
    3872, 
    4897, 
    3572, 
    3853, 
    3604, 
    3993, 
    3603, 
    3850, 
    3679, 
    3611, 
    3641, 
    5844, 
    3910, 
    3640, 
    8466, 
    3614, 
    3790, 
    5286, 
    3898, 
    4923, 
    3994, 
    3644, 
    8467, 
    3613, 
    3858, 
    3599, 
    3684, 
    3647, 
    3615, 
    5892, 
    3931, 
    3607, 
    3621, 
    3900, 
    3610, 
    3645, 
    4942, 
    3868, 
    3638, 
    3652, 
    3686, 
    5952, 
    3622, 
    3618, 
    3951, 
    9014, 
    3624, 
    6316, 
    3901, 
    3738, 
    3636, 
    3876, 
    3655, 
    3690, 
    6055, 
    3612, 
    4963, 
    3672, 
    3903, 
    3750, 
    3884, 
    3663, 
    3694, 
    3617, 
    3650, 
    4990, 
    3911, 
    3767, 
    3671, 
    3893, 
    3699, 
    3619, 
    3654, 
    3912, 
    3675, 
    3902, 
    3704, 
    3770, 
    3625, 
    3662, 
    3915, 
    3680, 
    3907, 
    3713, 
    3626, 
    3800, 
    3668, 
    3917, 
    3960, 
    3677, 
    3682, 
    3914, 
    3720, 
    3933, 
    3806, 
    3965, 
    3923, 
    3736, 
    3934, 
    3940, 
    3984, 
    3928, 
    3746, 
    3935, 
    3947, 
    3989, 
    3752, 
    3936, 
    4810, 
    3891, 
    3995, 
    3952, 
    5637, 
    5330, 
    3953, 
    6501, 
    5402, 
    6583, 
    5803, 
    6050, 
    6238, 
    6564, 
    6656, 
    6797, 
    6927, 
    7134, 
    3620, 
    3670, 
    3627, 
    3681, 
    3630, 
    3701, 
    3721, 
    3635, 
    3748, 
    3643, 
    3776, 
    3646, 
    3696, 
    3688, 
    3649, 
    3987, 
    3817, 
    3706, 
    3813, 
    4137, 
    3689, 
    3661, 
    3841, 
    3825, 
    3717, 
    5403, 
    4295, 
    3692, 
    3665, 
    3847, 
    3827, 
    3731, 
    5062, 
    5423, 
    3695, 
    3667, 
    5357, 
    3852, 
    3737, 
    5433, 
    3698, 
    3745, 
    5513, 
    3703, 
    3754, 
    3707, 
    5566, 
    3765, 
    5613, 
    3711, 
    3774, 
    5680, 
    3719, 
    3781, 
    5754, 
    3725, 
    5966, 
    3789, 
    3730, 
    3798, 
    6065, 
    3734, 
    3804, 
    6248, 
    3744, 
    3823, 
    6475, 
    3755, 
    3828, 
    6547, 
    6201, 
    3763, 
    3836, 
    6643, 
    3769, 
    7160, 
    3840, 
    3782, 
    6272, 
    7228, 
    3846, 
    3791, 
    6430, 
    3861, 
    7296, 
    3799, 
    3875, 
    7465, 
    3802, 
    6630, 
    7671, 
    6482, 
    3892, 
    3809, 
    3895, 
    7722, 
    3814, 
    3908, 
    7780, 
    3818, 
    3920, 
    8220, 
    3822, 
    3927, 
    8301, 
    3826, 
    8347, 
    3937, 
    3834, 
    3942, 
    3838, 
    3956, 
    8367, 
    3844, 
    3961, 
    3849, 
    4290, 
    3856, 
    8396, 
    3969, 
    3865, 
    4403, 
    8416, 
    3997, 
    8420, 
    3882, 
    4666, 
    4728, 
    3889, 
    5018, 
    4748, 
    5115, 
    3894, 
    4759, 
    5254, 
    3906, 
    5329, 
    3909, 
    5410, 
    3916, 
    5471, 
    3921, 
    5580, 
    3926, 
    5658, 
    3929, 
    5886, 
    3941, 
    6069, 
    6370, 
    6573, 
    6856, 
    6881, 
    7235, 
    7397, 
    7631, 
    7654, 
    9011, 
    9013
  )

Query time 0.00166

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "736.35"
    },
    "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": 1835,
      "rows_produced_per_join": 1835,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "369.35",
        "eval_cost": "367.00",
        "prefix_cost": "736.35",
        "data_read_per_join": "10M"
      },
      "used_columns": [
        "category_id",
        "parent_id"
      ],
      "attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (9532,9531,9536,9537,5677,3864,3955,3631,3830,6698,3990,3557,3609,3820,3678,3563,4828,7784,3760,7835,3567,3967,3784,3764,3535,3549,3602,3985,3539,3795,3560,8449,3653,3683,3867,4851,3552,3991,3815,3957,3586,3629,3835,3540,3593,3674,5746,3633,3779,7970,3546,7916,6743,3986,3829,3988,8452,3583,3606,3657,3773,3870,4877,3591,3992,3656,3687,3597,3843,8465,3639,3598,3676,3548,5787,3632,3783,3569,6784,3880,3996,3601,3872,4897,3572,3853,3604,3993,3603,3850,3679,3611,3641,5844,3910,3640,8466,3614,3790,5286,3898,4923,3994,3644,8467,3613,3858,3599,3684,3647,3615,5892,3931,3607,3621,3900,3610,3645,4942,3868,3638,3652,3686,5952,3622,3618,3951,9014,3624,6316,3901,3738,3636,3876,3655,3690,6055,3612,4963,3672,3903,3750,3884,3663,3694,3617,3650,4990,3911,3767,3671,3893,3699,3619,3654,3912,3675,3902,3704,3770,3625,3662,3915,3680,3907,3713,3626,3800,3668,3917,3960,3677,3682,3914,3720,3933,3806,3965,3923,3736,3934,3940,3984,3928,3746,3935,3947,3989,3752,3936,4810,3891,3995,3952,5637,5330,3953,6501,5402,6583,5803,6050,6238,6564,6656,6797,6927,7134,3620,3670,3627,3681,3630,3701,3721,3635,3748,3643,3776,3646,3696,3688,3649,3987,3817,3706,3813,4137,3689,3661,3841,3825,3717,5403,4295,3692,3665,3847,3827,3731,5062,5423,3695,3667,5357,3852,3737,5433,3698,3745,5513,3703,3754,3707,5566,3765,5613,3711,3774,5680,3719,3781,5754,3725,5966,3789,3730,3798,6065,3734,3804,6248,3744,3823,6475,3755,3828,6547,6201,3763,3836,6643,3769,7160,3840,3782,6272,7228,3846,3791,6430,3861,7296,3799,3875,7465,3802,6630,7671,6482,3892,3809,3895,7722,3814,3908,7780,3818,3920,8220,3822,3927,8301,3826,8347,3937,3834,3942,3838,3956,8367,3844,3961,3849,4290,3856,8396,3969,3865,4403,8416,3997,8420,3882,4666,4728,3889,5018,4748,5115,3894,4759,5254,3906,5329,3909,5410,3916,5471,3921,5580,3926,5658,3929,5886,3941,6069,6370,6573,6856,6881,7235,7397,7631,7654,9011,9013))"
    }
  }
}

Result

category_id parent_id
3539 3535
3546 3535
3548 3535
3604 3535
3607 3535
3610 3535
3612 3535
3617 3535
3619 3535
3625 3535
3626 3535
3677 3535
3806 3535
3940 3535
3947 3535
4810 3535
5637 3535
6501 3535
6583 3535
9529 3535
3549 3539
3552 3539
3569 3539
3572 3539
3599 3539
3638 3539
6316 3539
6482 3539
6630 3539
9531 3539
9536 3539
3557 3540
3674 3540
3676 3540
3679 3540
3684 3540
3686 3540
3690 3540
3694 3540
3699 3540
3704 3540
3713 3540
3720 3540
3736 3540
3746 3540
3752 3540
3567 3546
3586 3546
3597 3546
3603 3546
3613 3546
3618 3546
3738 3546
3750 3546
3767 3546
3770 3546
3800 3546
3560 3548
3583 3548
3601 3548
3614 3548
3621 3548
3624 3548
3636 3548
3650 3548
3654 3548
3662 3548
3668 3548
3960 3548
3965 3548
3984 3548
3989 3548
3995 3548
5330 3548
5402 3548
5803 3548
6050 3548
6238 3548
6564 3548
6656 3548
6797 3548
6927 3548
7134 3548
9537 3548
3632 3549
3641 3549
3647 3549
3652 3549
3655 3549
3663 3549
3671 3549
3675 3549
3680 3549
3682 3549
3688 3549
3689 3549
3692 3549
3695 3549
3698 3549
3703 3549
3707 3549
3711 3549
3719 3549
3725 3549
3730 3549
3734 3549
3744 3549
3755 3549
3763 3549
3769 3549
3782 3549
3791 3549
3799 3549
3802 3549
3809 3549
3814 3549
3818 3549
3822 3549
3826 3549
3834 3549
3838 3549
3844 3549
3849 3549
4290 3549
4403 3549
4666 3549
5018 3549
5115 3549
5254 3549
5329 3549
5410 3549
5471 3549
5580 3549
5658 3549
5886 3549
6069 3549
6370 3549
6573 3549
6881 3549
7235 3549
7397 3549
7654 3549
3563 3557
3593 3557
3598 3557
3611 3557
3615 3557
3622 3557
3672 3557
3631 3591
3633 3591
3639 3591
3640 3591
3644 3591
3645 3591
3602 3598
3606 3598
3784 3604
3815 3604
3817 3604
3825 3610
3827 3610
3864 3617
3867 3617
3870 3617
3872 3617
3898 3617
3900 3617
3901 3617
3903 3617
3911 3617
3912 3617
3915 3617
3917 3617
3933 3617
3934 3617
3935 3617
3936 3617
3952 3617
3953 3617
3830 3619
3841 3619
3847 3619
3852 3619
3627 3622
3630 3622
3635 3622
3643 3622
3646 3622
3649 3622
3661 3622
3665 3622
3667 3622
3955 3625
3957 3625
3992 3625
3993 3625
3994 3625
3609 3638
3620 3638
3629 3638
3656 3638
3670 3638
3681 3638
3701 3638
3721 3638
3748 3638
3776 3638
4137 3638
4295 3638
5062 3638
5357 3638
5513 3638
5566 3638
5613 3638
5680 3638
5754 3638
5966 3638
6065 3638
6248 3638
6475 3638
6547 3638
6643 3638
6856 3638
7160 3638
7228 3638
7296 3638
7465 3638
7631 3638
7671 3638
7722 3638
7780 3638
8220 3638
8301 3638
8347 3638
8367 3638
8396 3638
8416 3638
8420 3638
9011 3638
9013 3638
3990 3644
3991 3644
3653 3649
3657 3649
3856 3671
3865 3671
3882 3671
3889 3671
3894 3671
3906 3671
3909 3671
3916 3671
3921 3671
3926 3671
3929 3671
3941 3671
3678 3677
3683 3677
3687 3677
3696 3677
3706 3677
3717 3677
3731 3677
3737 3677
3745 3677
3754 3677
3765 3677
3774 3677
3781 3677
3789 3677
3798 3677
3804 3677
3836 3677
3840 3677
3846 3677
3853 3677
3861 3677
3875 3677
3892 3677
3895 3677
3908 3677
3920 3677
3927 3677
3937 3677
3942 3677
3956 3677
3961 3677
3969 3677
3997 3677
4728 3677
4748 3677
4759 3677
3760 3752
3779 3752
3783 3752
3790 3752
3764 3760
3773 3760
3795 3776
3829 3776
3880 3776
3910 3776
3931 3776
3951 3776
3987 3776
3967 3784
3988 3784
3996 3784
5286 3784
3813 3804
3823 3804
3828 3804
3820 3806
3835 3806
3843 3806
3850 3806
3858 3806
3868 3806
3876 3806
3884 3806
3891 3806
3893 3806
3902 3806
3907 3806
3914 3806
3923 3806
3928 3806
5403 3815
5423 3815
5433 3815
7784 3817
7970 3817
7835 3867
7916 3867
3985 3984
3986 3984
4828 4810
4851 4810
4877 4810
4897 4810
4923 4810
4942 4810
4963 4810
4990 4810
9532 4810
5677 5637
5746 5637
5787 5637
5844 5637
5892 5637
5952 5637
6055 5637
6201 5637
6272 5637
6430 5637
6698 6583
6743 6583
6784 6583
8449 8367
8452 8367
8465 8367
8466 8367
8467 8367
9014 8367