SELECT 
  c.* 
FROM 
  cscart_bm_containers as c 
WHERE 
  1 
  AND c.location_id = 408

Query time 0.00033

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

Result

container_id location_id position width user_class linked_to_default status
1478 408 TOP_PANEL 16 top-grid Y A
1479 408 HEADER 16 header-grid Y A
1480 408 CONTENT 16 Y A
1481 408 FOOTER 16 Y A