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.00052

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

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 abt__ut2_extended abt__ut2_padding abt__ut2_show_in_tabs abt__ut2_use_ajax
1 1 TOP_PANEL 3 top-links-grid ty-top-grid_float Y A 0 1 0 0 0 0 1 LEFT div 0 0 N N
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 0 N N
11 3 CONTENT 16 breadcrumbs-grid Y A 0 31 0 0 0 1 1 FULL_WIDTH div 1 0 N N
2 1 HEADER 16 Y A 0 264 0 0 0 1 1 FULL_WIDTH div 1 0 N N
2 1 HEADER 5 cart-content-grid Y D 0 8 6 0 0 1 1 RIGHT div 1 0 N N
4 1 FOOTER 11 ty-grid Y D 0 13 12 0 0 0 1 FULL_WIDTH div 0 0 N N
4 1 FOOTER 5 ty-grid Y D 0 14 12 0 0 1 0 FULL_WIDTH div 1 0 N N
4 1 FOOTER 4 my-account-grid Y A 0 16 15 0 0 0 1 LEFT div 0 0 N N
4 1 FOOTER 4 footer-store-grid Y A 0 17 15 0 0 0 0 LEFT div 0 0 N N
4 1 FOOTER 4 customer-service-grid Y A 0 18 15 0 0 0 0 LEFT div 0 0 N N
4 1 FOOTER 4 about-grid Y A 0 19 15 0 0 1 0 LEFT div 1 0 N N
4 1 FOOTER 6 Y A 0 21 20 0 0 0 1 LEFT div 0 0 N N
2 1 HEADER 6 Y A 0 3253 264 0 0 0 1 LEFT div 0 0 N N
1 1 TOP_PANEL 11 top-links-grid hidden-phone Y A 0 2 0 1 0 0 0 LEFT div 0 0 N N
11 3 CONTENT 16 main-content-grid Y A 0 32 0 1 0 1 1 FULL_WIDTH div 1 0 N N
4 1 FOOTER 3 Y A 0 277 20 1 0 0 0 LEFT div 0 0 N N
2 1 HEADER 10 Y A 0 265 264 1 0 1 0 LEFT div 1 0 N N
1 1 TOP_PANEL 2 Y A 0 3 0 2 0 1 0 RIGHT div 1 0 N N
2 1 HEADER 5 Y D 0 6 0 2 0 1 1 RIGHT div 1 0 N N
4 1 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 15 0 2 0 1 1 FULL_WIDTH div 1 0 N N
11 3 CONTENT 9 Y A 0 33 0 2 0 0 1 FULL_WIDTH div 0 0 N N
4 1 FOOTER 7 Y A 0 22 20 2 0 1 0 LEFT div 1 0 N N
11 3 CONTENT 7 Y A 0 34 0 3 0 1 0 FULL_WIDTH div 1 0 N N
2 1 HEADER 5 Y D 0 276 264 3 0 0 1 LEFT div 0 0 N N
2 1 HEADER 16 top-menu-grid Y A 0 9 0 4 0 1 1 FULL_WIDTH div 1 0 N N
4 1 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 20 0 4 0 1 1 FULL_WIDTH div 1 0 N N
11 3 CONTENT 8 Y A 0 2833 0 4 0 1 1 FULL_WIDTH div 1 0 N N
2 1 HEADER 6 Y D 0 3386 264 4 0 0 0 LEFT div 0 0 N N
2 1 HEADER 3 Y D 0 3254 264 5 0 1 0 LEFT div 1 0 N N
4 1 FOOTER 1 Y A 0 271 0 6 0 0 1 FULL_WIDTH div 0 0 N N
4 1 FOOTER 4 Y A 0 2831 0 7 0 0 0 FULL_WIDTH div 0 0 N N
4 1 FOOTER 5 Y D 0 2834 0 8 0 1 0 FULL_WIDTH div 1 0 N N