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 (77, 78, 87, 80) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00027

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 hobilifedt.c.container_id 3

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
77 20 TOP_PANEL 4 top-links-grid Y A 0 94 0 0 0 0 1 LEFT div 0
77 20 TOP_PANEL 10 top-links-grid Y A 0 95 0 0 0 0 0 RIGHT div 0
77 20 TOP_PANEL 2 top-links-grid Y A 0 96 0 0 0 1 0 RIGHT div 1
78 20 HEADER 4 top-logo-grid Y A 0 97 0 0 0 0 1 FULL_WIDTH div 0
78 20 HEADER 5 search-block-grid Y A 0 98 0 0 0 0 0 FULL_WIDTH div 0
78 20 HEADER 4 ty-cr-content-grid Y A 0 99 0 0 0 0 0 FULL_WIDTH div 0
78 20 HEADER 3 cart-content-grid Y A 0 100 0 0 0 1 0 RIGHT div 1
78 20 HEADER 16 top-menu-grid Y A 0 101 0 0 0 1 1 FULL_WIDTH div 1
80 20 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 0 104 0 0 0 1 1 FULL_WIDTH div 1
80 20 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 107 0 0 0 1 1 FULL_WIDTH div 1
80 20 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 112 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 breadcrumbs-grid Y A 0 125 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 main-content-grid Y A 0 126 0 0 0 1 1 FULL_WIDTH div 1
80 20 FOOTER 8 Y A 0 105 104 0 0 0 1 LEFT div 0
80 20 FOOTER 8 Y A 0 106 104 0 0 1 0 RIGHT div 1
80 20 FOOTER 4 my-account-grid Y A 0 108 107 0 0 0 1 FULL_WIDTH div 0
80 20 FOOTER 4 demo-store-grid Y A 0 109 107 0 0 0 0 LEFT div 0
80 20 FOOTER 4 customer-service-grid Y A 0 110 107 0 0 0 0 LEFT div 0
80 20 FOOTER 4 about-grid Y A 0 111 107 0 0 1 0 LEFT div 1
80 20 FOOTER 8 Y A 0 113 112 0 0 0 1 LEFT div 0
80 20 FOOTER 8 Y A 0 114 112 0 0 1 0 RIGHT div 1