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

Query time 0.00059

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