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, 122, 123, 80) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00036

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
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
122 31 HEADER 5 top-logo-grid N A 0 150 0 0 0 0 1 FULL_WIDTH div 0
122 31 HEADER 6 vendor-stores-block-grid N A 0 151 0 0 0 0 0 FULL_WIDTH div 0
122 31 HEADER 5 cart-content-grid N A 0 152 0 0 0 1 0 RIGHT div 1
122 31 HEADER 16 vendor-info-grid N A 0 153 0 0 0 1 1 FULL_WIDTH div 1
123 31 CONTENT 16 breadcrumbs-grid Y A 0 157 0 0 0 1 1 FULL_WIDTH div 1
123 31 CONTENT 4 side-grid Y A 0 158 0 0 0 0 1 FULL_WIDTH div 0
123 31 CONTENT 12 main-content-grid Y A 0 159 0 0 0 1 0 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
122 31 HEADER 4 vendor-logo-grid N A 0 154 153 0 0 0 1 FULL_WIDTH div 0
122 31 HEADER 6 vendor-search-grid N A 0 155 153 0 0 0 0 FULL_WIDTH div 0
122 31 HEADER 6 vendor-information-grid N A 0 156 153 0 0 1 0 FULL_WIDTH div 1