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 (1530, 1531, 1556, 1533) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00092

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE g range container_id container_id 3 26 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
1531 421 HEADER 6 top-logo-grid Y A 1958 0 0 0 1 FULL_WIDTH div 0 0 N
1556 427 CONTENT 16 Y A 1985 0 0 1 1 FULL_WIDTH div 1 0 N
1530 421 TOP_PANEL 16 Y A 2045 0 0 1 1 FULL_WIDTH div 1 0 Y
1533 421 FOOTER 16 Y A 2210 0 0 1 1 FULL_WIDTH div 1 0 N
1530 421 TOP_PANEL 8 Y A 2050 2045 0 0 1 FULL_WIDTH div 0 0 N
1533 421 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 1945 0 1 1 1 FULL_WIDTH div 1 0 N
1531 421 HEADER 6 search-block-grid Y A 1959 0 1 0 0 FULL_WIDTH div 0 0 N
1530 421 TOP_PANEL 3 top-links-grid Y A 1964 0 1 0 1 LEFT div 0 0 N
1556 427 CONTENT 3 Y A 1986 0 1 0 1 FULL_WIDTH div 0 0 N
1533 421 FOOTER 3 Y A 1947 1945 1 0 1 FULL_WIDTH div 0 0 N
1533 421 FOOTER 8 Y A 1956 1955 1 0 1 LEFT div 0 0 N
1530 421 TOP_PANEL 4 Y A 2052 2045 1 0 0 FULL_WIDTH div 0 0 N
1533 421 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 1950 0 2 1 1 FULL_WIDTH div 1 0 N
1531 421 HEADER 3 ty-cr-content-grid Y A 1960 0 2 0 0 FULL_WIDTH div 0 0 N
1530 421 TOP_PANEL 13 top-links-grid Y A 1965 0 2 1 0 RIGHT div 1 0 N
1556 427 CONTENT 13 Y A 1987 0 2 1 0 FULL_WIDTH div 1 0 N
1533 421 FOOTER 3 Y A 1948 1945 2 0 0 FULL_WIDTH div 0 0 N
1533 421 FOOTER 3 customer-service-grid Y A 1952 1950 2 0 1 LEFT div 0 0 N
1533 421 FOOTER 8 Y A 1957 1955 2 1 0 RIGHT div 1 0 N
1530 421 TOP_PANEL 4 Y A 2051 2045 2 1 0 RIGHT div 1 0 N
1533 421 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 1955 0 3 1 1 FULL_WIDTH div 1 0 N
1531 421 HEADER 1 cart-content-grid Y A 1961 0 3 1 0 RIGHT div 1 0 N
1533 421 FOOTER 3 Y A 1949 1945 3 0 0 FULL_WIDTH div 0 0 N
1533 421 FOOTER 3 demo-store-grid Y A 1953 1950 3 0 0 LEFT div 0 0 N
1533 421 FOOTER 7 Y A 1946 1945 4 1 0 RIGHT div 1 0 N
1533 421 FOOTER 3 about-grid Y A 1954 1950 4 0 0 LEFT div 0 0 N
1531 421 HEADER 16 top-menu-grid Y A 1962 0 5 1 1 FULL_WIDTH div 1 0 N
1533 421 FOOTER 7 Y A 2207 1950 5 1 0 LEFT div 1 0 N