SELECT 
  status_id, 
  status 
FROM 
  cscart_statuses 
WHERE 
  type = 'O'

Query time 0.00012

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_statuses ALL 19 Using where

Result

status_id status
1 P
2 C
3 O
4 F
5 D
6 B
7 I
19 Y