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 (1478, 1479, 1504, 1481) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00090

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE g range container_id container_id 3 25 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
1479 408 HEADER 6 top-logo-grid Y A 1883 0 0 0 1 FULL_WIDTH div 0 0 N
1504 414 CONTENT 16 Y A 1910 0 0 1 1 FULL_WIDTH div 1 0 N
1481 408 FOOTER 16 Y A 2211 0 0 1 1 FULL_WIDTH div 1 0 N
1478 408 TOP_PANEL 8 search-grid Y A 2213 0 0 0 1 FULL_WIDTH div 0 0 Y
1481 408 FOOTER 3 Y A 1872 1870 0 0 1 FULL_WIDTH div 0 0 N
1481 408 FOOTER 3 my-account-grid Y A 1876 1875 0 0 1 LEFT div 0 0 N
1481 408 FOOTER 3 customer-service-grid Y A 1877 1875 0 0 0 LEFT div 0 0 N
1481 408 FOOTER 3 demo-store-grid Y A 1878 1875 0 0 0 LEFT div 0 0 N
1481 408 FOOTER 7 about-grid Y A 1879 1875 0 1 0 RIGHT div 1 0 N
1481 408 FOOTER 8 Y A 1881 1880 0 0 1 LEFT div 0 0 N
1481 408 FOOTER 8 Y A 1882 1880 0 1 0 RIGHT div 1 0 N
1481 408 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 1870 0 1 1 1 FULL_WIDTH div 1 0 N
1479 408 HEADER 6 search-block-grid Y A 1884 0 1 0 0 FULL_WIDTH div 0 0 N
1504 414 CONTENT 3 Y A 1911 0 1 0 1 FULL_WIDTH div 0 0 N
1478 408 TOP_PANEL 8 cart-grid Y A 2214 0 1 1 0 FULL_WIDTH div 1 0 N
1481 408 FOOTER 3 Y A 1873 1870 1 0 0 FULL_WIDTH div 0 0 N
1481 408 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 1875 0 2 1 1 FULL_WIDTH div 1 0 N
1479 408 HEADER 3 ty-cr-content-grid Y A 1885 0 2 0 0 FULL_WIDTH div 0 0 N
1504 414 CONTENT 13 Y A 1912 0 2 1 0 FULL_WIDTH div 1 0 N
1481 408 FOOTER 3 Y A 1874 1870 2 0 0 FULL_WIDTH div 0 0 N
1481 408 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 1880 0 3 1 1 FULL_WIDTH div 1 0 N
1479 408 HEADER 1 cart-content-grid Y A 1886 0 3 1 0 RIGHT div 1 0 N
1478 408 TOP_PANEL 3 top-links-grid Y A 1889 0 3 0 1 LEFT div 0 0 N
1481 408 FOOTER 7 Y A 1871 1870 3 1 0 RIGHT div 1 0 N
1478 408 TOP_PANEL 13 top-links-grid Y A 1890 0 4 1 0 RIGHT div 1 0 N
1479 408 HEADER 16 top-menu-grid Y A 1887 0 5 1 1 FULL_WIDTH div 1 0 N