SELECT 
  product_id 
FROM 
  cscart_products 
WHERE 
  product_type = 'D'

Query time 0.00017

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

Result

product_id
285