SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    480, 263, 926, 923, 928, 903, 948, 949, 
    950, 951, 952, 953, 954, 955, 956, 957, 
    959, 958, 960, 901
  )

Query time 0.00032

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_categories range parent parent 3 39 Using index condition

Result

category_id parent_id
365 901
359 901
369 901
986 901
987 901
988 901
989 901
990 901
991 901
992 901
993 901
994 901
995 901
996 901
997 901