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 (906, 907, 924, 909) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00065

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

Result

container_id location_id position width user_class linked_to_default status grid_id parent_id order omega alpha wrapper content_align html_element clear offset sticky_menu
907 265 HEADER 6 top-logo-grid Y A 1118 0 0 0 1 FULL_WIDTH div 0 0 N
924 269 CONTENT 16 Y A 1156 0 0 1 1 FULL_WIDTH div 1 0 N
906 265 TOP_PANEL 16 top-panel-grid Y A 2042 0 0 1 1 FULL_WIDTH div 1 0 Y
909 265 FOOTER 14 Y A 2182 0 0 1 1 FULL_WIDTH div 1 1 N
909 265 FOOTER 3 my-account-grid Y A 1136 1135 0 0 1 LEFT div 0 0 N
909 265 FOOTER 8 Y A 1141 1140 0 0 1 LEFT div 0 0 N
924 269 CONTENT 13 Y A 2014 1157 0 0 1 FULL_WIDTH div 0 0 N
906 265 TOP_PANEL 9 search-grid Y A 2054 2042 0 0 1 FULL_WIDTH div 0 0 N
907 265 HEADER 6 search-block-grid Y A 1119 0 1 0 0 FULL_WIDTH div 0 0 N
924 269 CONTENT 16 main-content-grid Y A 1157 0 1 1 1 FULL_WIDTH div 1 0 N
909 265 FOOTER 16 Y A 2217 1130 1 1 1 FULL_WIDTH div 1 0 N
909 265 FOOTER 3 customer-service-grid Y A 1137 1135 1 0 0 LEFT div 0 0 N
924 269 CONTENT 3 Y A 2015 1157 1 1 0 FULL_WIDTH div 1 0 N
906 265 TOP_PANEL 3 hidden-phone Y A 2055 2042 1 0 0 FULL_WIDTH div 0 0 N
907 265 HEADER 2 ty-cr-content-grid Y A 1120 0 2 0 0 FULL_WIDTH div 0 0 N
909 265 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 1130 0 2 1 1 FULL_WIDTH div 1 0 N
906 265 TOP_PANEL 3 top-links-grid Y A 1143 0 2 0 1 LEFT div 0 0 N
924 269 CONTENT 8 Y A 1937 0 2 0 1 FULL_WIDTH div 0 0 N
909 265 FOOTER 12 footer-social Y A 1132 1130 2 0 1 LEFT div 0 0 N
909 265 FOOTER 3 customer-service-grid Y A 1138 1135 2 0 0 LEFT div 0 0 N
909 265 FOOTER 8 Y A 1142 1140 2 1 0 RIGHT div 1 0 N
906 265 TOP_PANEL 4 cart-grid Y A 2056 2042 2 1 0 RIGHT div 1 0 N
907 265 HEADER 2 cart-content-grid Y A 1121 0 3 1 0 RIGHT div 1 0 N
906 265 TOP_PANEL 13 top-links-grid Y A 1144 0 3 1 0 RIGHT div 1 0 N
924 269 CONTENT 8 Y A 2039 0 3 1 0 FULL_WIDTH div 1 0 N
909 265 FOOTER 4 footer-social Y A 1131 1130 3 1 0 LEFT div 1 0 N
909 265 FOOTER 7 customer-service-grid Y A 1139 1135 3 1 0 FULL_WIDTH div 1 0 N
907 265 HEADER 16 top-menu-grid Y A 1122 0 4 1 1 FULL_WIDTH div 1 0 N
909 265 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 1135 0 4 1 1 FULL_WIDTH div 1 0 N
924 269 CONTENT 16 Y D 1159 0 4 1 1 FULL_WIDTH div 1 0 N
909 265 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 1140 0 6 1 1 FULL_WIDTH div 1 0 N