SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    482, 432, 925, 922, 929, 890, 938, 937, 
    939, 940, 941, 943, 942, 944, 945, 946, 
    461, 947, 468, 897
  )

Query time 0.00034

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
898 897
899 897
900 897
974 897
975 897
976 897
977 897
978 897
979 897
980 897
981 897
982 897
983 897
984 897
985 897