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 (1, 2, 7, 4) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00105

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE g ALL container_id 108 Using where; Using filesort
1 SIMPLE c eq_ref PRIMARY PRIMARY 3 d38744sd170579.g.container_id 1

Result

container_id location_id position width user_class linked_to_default status grid_id parent_id order offset omega alpha wrapper content_align html_element clear
1 1 TOP_PANEL 6 top-links-grid Y A 1 0 0 0 0 1 LEFT div 0
2 1 HEADER 16 top-logo-grid Y A 3 0 0 0 1 1 FULL_WIDTH div 1
4 1 FOOTER 16 waveup Y A 10 0 0 0 1 1 FULL_WIDTH div 1
7 2 CONTENT 16 Y A 21 0 0 0 1 1 FULL_WIDTH div 1
4 1 FOOTER 4 my-account-grid Y A 14 13 0 0 0 1 LEFT div 0
4 1 FOOTER 4 demo-store-grid Y A 15 13 0 0 0 0 LEFT div 0
4 1 FOOTER 4 customer-service-grid Y A 16 13 0 0 0 0 LEFT div 0
4 1 FOOTER 4 about-grid Y A 17 13 0 0 1 0 LEFT div 1
4 1 FOOTER 8 Y A 19 18 0 0 0 1 LEFT div 0
4 1 FOOTER 8 Y A 20 18 0 0 1 0 RIGHT div 1
1 1 TOP_PANEL 10 top-links-grid Y A 2 0 1 0 1 0 RIGHT div 1
2 1 HEADER 16 top-menu-grid Y A 7 0 1 0 1 1 FULL_WIDTH div 1
4 1 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 13 0 2 0 1 1 FULL_WIDTH div 1
7 2 CONTENT 4 caviar-choice Y A 117 0 2 1 0 1 FULL_WIDTH div 0
7 2 CONTENT 4 caviar-choice Y A 118 0 3 0 0 0 FULL_WIDTH div 0
4 1 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 18 0 4 0 1 1 FULL_WIDTH div 1
7 2 CONTENT 4 caviar-choice Y A 119 0 4 0 1 0 FULL_WIDTH div 1
7 2 CONTENT 16 main-banners reviews-block Y D 22 0 6 0 1 1 FULL_WIDTH div 1
7 2 CONTENT 16 reviews-block Y A 122 0 8 0 1 1 FULL_WIDTH div 1
7 2 CONTENT 16 Y A 116 0 10 0 1 1 FULL_WIDTH div 1