SELECT 
  * 
FROM 
  cscart_bm_containers as c 
  LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id 
WHERE 
  1 
  AND g.container_id IN (51, 52, 149, 54) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00030

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE g range container_id container_id 3 16 Using index condition; Using filesort
1 SIMPLE c eq_ref PRIMARY PRIMARY 3 toolboxdigitalshop_dev.g.container_id 1

Result

container_id location_id position width user_class linked_to_default status company_id grid_id parent_id order omega alpha wrapper content_align html_element clear offset
51 14 TOP_PANEL 5 top-links-grid Y A 0 87 0 0 0 1 LEFT div 0 0
51 14 TOP_PANEL 7 top-links-grid Y A 0 88 0 0 1 0 RIGHT div 1 0
52 14 HEADER 4 top-logo-grid Y A 0 89 0 0 0 1 LEFT div 0 0
52 14 HEADER 8 search-block-grid Y A 0 90 0 0 1 0 RIGHT div 1 0
52 14 HEADER 12 top-menu-grid Y A 0 92 0 0 1 1 FULL_WIDTH div 1 0
51 14 TOP_PANEL 12 Y A 0 177 0 0 1 1 FULL_WIDTH div 1 0
149 38 CONTENT 8 side-grid Y A 0 213 0 0 0 1 FULL_WIDTH div 0 0
54 14 FOOTER 5 Y A 0 301 298 0 0 1 FULL_WIDTH div 0 0
54 14 FOOTER 4 Y A 0 303 300 0 0 1 FULL_WIDTH div 0 0
149 38 CONTENT 4 sidebar Y A 0 214 0 1 1 0 FULL_WIDTH div 1 0
54 14 FOOTER 7 Y A 0 302 298 1 1 0 FULL_WIDTH div 1 0
54 14 FOOTER 4 Y A 0 304 300 1 0 0 FULL_WIDTH div 0 0
54 14 FOOTER 4 Y A 0 305 300 2 1 0 FULL_WIDTH div 1 0
54 14 FOOTER 12 tb-footer-menu-banners Y A 0 298 0 3 1 1 FULL_WIDTH div 1 0
54 14 FOOTER 12 tb-footer-inline-menu Y A 0 299 0 5 1 1 FULL_WIDTH div 1 0
54 14 FOOTER 12 tb-footer-logo-copyright-social Y A 0 300 0 7 1 1 FULL_WIDTH div 1 0