SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (279)

Query time 0.00033

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_popularity const PRIMARY,total PRIMARY 3 const 1 Using index

Result

product_id
279