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

Query time 0.00077

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c range PRIMARY PRIMARY 3 4 Using index condition; Using temporary; Using filesort
1 SIMPLE g ref container_id container_id 3 cscart_dev_4_16.c.container_id 2

Result

container_id location_id position width user_class linked_to_default status company_id grid_id parent_id order offset omega alpha wrapper content_align html_element clear
1 1 TOP_PANEL 3 top-links-grid ty-top-grid_float Y A 0 1 0 0 0 0 1 LEFT div 0
1 1 TOP_PANEL 11 top-links-grid Y A 0 2 0 0 0 0 0 LEFT div 0
1 1 TOP_PANEL 2 top-links-grid Y A 0 3 0 0 0 1 0 RIGHT div 1
2 1 HEADER 3 top-logo-grid Y A 0 4 0 0 0 0 1 FULL_WIDTH div 0
2 1 HEADER 5 ty-cr-content-grid Y A 0 5 0 0 0 0 0 FULL_WIDTH div 0
2 1 HEADER 8 Y A 0 6 0 0 0 1 0 FULL_WIDTH div 1
2 1 HEADER 16 top-menu-grid Y A 0 9 0 0 0 1 1 FULL_WIDTH div 1
4 1 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 0 12 0 0 0 1 1 FULL_WIDTH div 1
4 1 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 15 0 0 0 1 1 FULL_WIDTH div 1
4 1 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 20 0 0 0 1 1 FULL_WIDTH div 1
11 3 CONTENT 16 breadcrumbs-grid Y A 0 31 0 0 0 1 1 FULL_WIDTH div 1
11 3 CONTENT 16 main-content-grid Y A 0 32 0 0 0 1 1 FULL_WIDTH div 1
11 3 CONTENT 9 Y A 0 33 0 0 0 0 1 FULL_WIDTH div 0
11 3 CONTENT 7 Y A 0 34 0 0 0 1 0 FULL_WIDTH div 1
2 1 HEADER 4 search-block-grid Y A 0 7 6 0 0 0 1 FULL_WIDTH div 0
2 1 HEADER 4 cart-content-grid Y A 0 8 6 0 0 1 0 FULL_WIDTH div 1
4 1 FOOTER 10 ty-grid Y A 0 13 12 0 0 0 1 FULL_WIDTH div 0
4 1 FOOTER 6 ty-grid Y A 0 14 12 0 0 1 0 FULL_WIDTH div 1
4 1 FOOTER 4 my-account-grid Y A 0 16 15 0 0 0 1 LEFT div 0
4 1 FOOTER 4 footer-store-grid Y A 0 17 15 0 0 0 0 LEFT div 0
4 1 FOOTER 4 customer-service-grid Y A 0 18 15 0 0 0 0 LEFT div 0
4 1 FOOTER 4 about-grid Y A 0 19 15 0 0 1 0 LEFT div 1
4 1 FOOTER 8 Y A 0 21 20 0 0 0 1 LEFT div 0
4 1 FOOTER 8 Y A 0 22 20 0 0 1 0 RIGHT div 1