SELECT 
  c.* 
FROM 
  cscart_bm_containers as c 
WHERE 
  1 
  AND c.location_id = 38 
  AND c.company_id = 0

Query time 0.00028

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ref location_id,location_id_company_id,location_id_position_company_id location_id_position_company_id 3 const 4 Using index condition

Result

container_id location_id position width user_class linked_to_default status company_id
149 38 TOP_PANEL 16 Y A 0
150 38 HEADER 16 Y A 0
151 38 CONTENT 16 content-grid Y A 0
152 38 FOOTER 16 Y A 0