SELECT 
  addon 
FROM 
  cscart_addons 
WHERE 
  unmanaged = 1 
  AND status = 'A' 
ORDER BY 
  priority

Query time 0.00025

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_addons ALL 83 Using where; Using filesort