Sandbox

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