Sandbox

SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    889, 
    829, 
    890, 
    891, 
    744, 
    911, 
    912, 
    880, 
    738, 
    799, 
    879, 
    892, 
    791, 
    913, 
    739, 
    893, 
    785, 
    745, 
    894, 
    895, 
    746, 
    896, 
    801, 
    897, 
    881, 
    860, 
    830, 
    747, 
    831, 
    748, 
    898, 
    899, 
    749, 
    900, 
    882, 
    832, 
    901, 
    833, 
    802, 
    856, 
    902, 
    861, 
    821, 
    750, 
    834, 
    817, 
    903, 
    862, 
    904, 
    751, 
    752, 
    905, 
    753, 
    754, 
    906, 
    822, 
    803, 
    835, 
    863, 
    874, 
    914, 
    836, 
    864, 
    804, 
    837, 
    907, 
    792, 
    908, 
    740, 
    755, 
    776, 
    800, 
    741, 
    915, 
    909, 
    786, 
    838, 
    814, 
    887, 
    865, 
    888, 
    777, 
    951, 
    910, 
    839, 
    787, 
    756, 
    883, 
    922, 
    923, 
    916, 
    788, 
    757, 
    823, 
    866, 
    805, 
    815, 
    924, 
    758, 
    925, 
    884, 
    950, 
    917, 
    918, 
    919, 
    793, 
    742, 
    759, 
    926, 
    927, 
    928, 
    929, 
    760, 
    840, 
    930, 
    794, 
    820, 
    778, 
    761, 
    931, 
    932, 
    762, 
    763, 
    796, 
    828, 
    779, 
    806, 
    933, 
    841, 
    920, 
    934, 
    764, 
    842, 
    795, 
    921, 
    765, 
    766, 
    767, 
    780, 
    855, 
    768, 
    875, 
    935, 
    843, 
    885, 
    936, 
    937, 
    938, 
    844, 
    939, 
    769, 
    876, 
    770, 
    781, 
    859, 
    797, 
    940, 
    771, 
    772, 
    733, 
    872, 
    734, 
    735, 
    736, 
    737, 
    732, 
    743, 
    941, 
    782, 
    773, 
    845, 
    824, 
    867, 
    857, 
    942, 
    816, 
    807, 
    784, 
    868, 
    774, 
    825, 
    877, 
    846, 
    847, 
    848, 
    808, 
    809, 
    878, 
    869, 
    849, 
    810, 
    943, 
    850, 
    944, 
    945, 
    789, 
    826, 
    870, 
    851, 
    946, 
    811, 
    812, 
    886, 
    818, 
    947, 
    852, 
    873, 
    790, 
    948, 
    949, 
    813, 
    858, 
    827, 
    871, 
    819, 
    853, 
    854, 
    775, 
    783, 
    952, 
    953, 
    798, 
    1294, 
    1298, 
    1296
  ) 
  AND category_id != 265

Query time 0.00171

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY", "parent", "p_category_id"],
      "rows": 654,
      "filtered": 63.456,
      "attached_condition": "cscart_categories.parent_id in (889,829,890,891,744,911,912,880,738,799,879,892,791,913,739,893,785,745,894,895,746,896,801,897,881,860,830,747,831,748,898,899,749,900,882,832,901,833,802,856,902,861,821,750,834,817,903,862,904,751,752,905,753,754,906,822,803,835,863,874,914,836,864,804,837,907,792,908,740,755,776,800,741,915,909,786,838,814,887,865,888,777,951,910,839,787,756,883,922,923,916,788,757,823,866,805,815,924,758,925,884,950,917,918,919,793,742,759,926,927,928,929,760,840,930,794,820,778,761,931,932,762,763,796,828,779,806,933,841,920,934,764,842,795,921,765,766,767,780,855,768,875,935,843,885,936,937,938,844,939,769,876,770,781,859,797,940,771,772,733,872,734,735,736,737,732,743,941,782,773,845,824,867,857,942,816,807,784,868,774,825,877,846,847,848,808,809,878,869,849,810,943,850,944,945,789,826,870,851,946,811,812,886,818,947,852,873,790,948,949,813,858,827,871,819,853,854,775,783,952,953,798,1294,1298,1296) and cscart_categories.category_id <> 265"
    }
  }
}

Result

category_id	parent_id
733	732
734	732
735	732
736	732
737	732
738	737
739	737
740	737
741	737
742	737
743	732
744	743
745	743
746	743
747	743
748	743
749	743
750	743
751	743
752	743
753	743
754	743
755	743
756	743
757	743
758	743
759	743
760	743
761	743
762	743
763	743
764	743
765	743
766	743
767	743
768	743
769	743
770	743
771	743
772	743
773	743
774	743
775	743
776	775
777	775
778	775
779	775
780	775
781	775
782	775
783	775
785	784
786	784
787	784
788	784
791	790
792	791
793	791
794	791
795	791
796	790
797	790
799	798
800	799
801	800
802	800
803	800
804	800
805	800
806	800
807	800
808	800
809	800
810	800
811	800
812	800
813	800
814	799
815	814
816	814
817	816
818	814
819	814
820	799
821	820
822	820
823	820
824	820
825	820
826	820
827	820
828	799
829	828
830	828
831	828
832	828
833	828
834	828
835	828
836	828
837	828
838	828
839	828
840	828
841	828
842	828
843	828
844	828
845	828
846	828
847	828
848	828
849	828
850	828
851	828
852	828
853	828
854	828
855	799
856	855
857	855
858	855
859	799
860	859
861	859
862	859
863	859
864	859
865	859
866	859
867	859
868	859
869	859
870	859
871	859
872	799
873	799
874	873
875	873
876	873
877	873
878	873
879	798
880	879
881	880
882	880
883	880
884	880
885	880
886	880
887	879
888	879
889	888
890	888
891	888
892	888
893	888
894	888
895	888
896	888
897	888
898	888
899	888
900	888
901	888
902	888
903	888
904	888
905	888
906	888
907	888
908	888
909	888
910	888
911	910
912	910
913	910
914	910
915	910
916	910
917	910
918	910
919	910
920	910
921	910
922	888
923	888
924	888
925	888
926	888
927	888
928	888
929	888
930	888
931	888
932	888
933	888
934	888
935	888
936	888
937	888
938	888
939	888
940	888
941	888
942	888
943	888
944	888
945	888
946	888
947	888
948	888
949	888
950	879
951	950
952	798
953	952
1298	888
1296	828
1294	775