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 (2837, 2838, 2843, 2844) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00199

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

Result

container_id location_id position width user_class linked_to_default status grid_id parent_id order offset omega alpha wrapper content_align html_element clear
2838 710 HEADER 16 background Y A 3624 0 0 0 0 0 FULL_WIDTH div 1
2843 711 CONTENT 16 services-block hidden-xs Y D 3645 0 0 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 16 resetgrid ty-footer-grid__full-width footer-stay-connected N A 3663 0 0 0 1 1 FULL_WIDTH div 1
2837 710 TOP_PANEL 16 down-message Y A 6583 0 0 0 1 1 FULL_WIDTH div 1
2837 710 TOP_PANEL 2 margin_left_reset col-sm-3 col-md-2 hidden-xs news_line Y A 3621 3620 0 0 0 1 FULL_WIDTH div 0
2838 710 HEADER 16 grid_container Y A 3625 3624 0 0 1 1 FULL_WIDTH div 1
2838 710 HEADER 16 resetgridwithrow header-left col-xs-12 col-sm-12 col-md-12 Y A 3626 3625 0 0 1 1 FULL_WIDTH div 1
2838 710 HEADER 16 clean_row Y A 3627 3626 0 0 1 1 FULL_WIDTH div 1
2838 710 HEADER 16 grid_container Y A 3630 3629 0 0 0 0 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container Y D 3646 3645 0 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 Y A 3650 3649 0 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container content Y A 3654 3653 0 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container Y A 3656 3655 0 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container Y A 3658 3657 0 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 row mobileAccord Y A 3660 3659 0 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 16 grid_container content top-footer N A 3664 3663 0 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column1 Y A 3762 3761 0 0 0 1 FULL_WIDTH div 0
2837 710 TOP_PANEL 5 resetgridwithrow header-left col-xs-12 col-sm-4 col-md-4 Y A 6987 6986 0 0 0 1 FULL_WIDTH div 0
2844 711 FOOTER 16 row-fluid footer-copyright N A 7003 6998 0 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 16 grid_container N A 7002 7001 0 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 16 grid_container N A 7004 7003 0 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 10 wrapper_centered N A 7005 7004 0 0 0 1 FULL_WIDTH div 0
2844 711 FOOTER 16 grid_container N A 7008 7007 0 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 16 row-fluid N A 7007 0 1 0 1 1 FULL_WIDTH div 1
2837 710 TOP_PANEL 7 margin_left_reset col-xs-5 col-sm-6 col-md-7 col-sm-push-0 news_line Y D 3622 3620 1 0 0 0 FULL_WIDTH div 0
2838 710 HEADER 16 top-menu-grid navbar-main-menu-outer hidden-xs Y A 3629 3624 1 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column2 Y A 3763 3761 1 0 0 0 FULL_WIDTH div 0
2837 710 TOP_PANEL 5 col-xs-12 col-sm-4 col-md-4 top-link pull-rights news_line search_cart_buttons resetgridwithrow navbar-secondary static-link Y A 7027 6986 1 0 0 0 FULL_WIDTH div 0
2844 711 FOOTER 6 wrapper_centered N A 7006 7004 1 0 1 0 FULL_WIDTH div 1
2843 711 CONTENT 16 Y A 3647 0 2 0 1 1 FULL_WIDTH div 1
2837 710 TOP_PANEL 16 top-header-container Y A 6986 0 2 0 1 1 FULL_WIDTH div 1
2844 711 FOOTER 16 row-fluid gray-row N A 7001 0 2 0 1 1 FULL_WIDTH div 1
2837 710 TOP_PANEL 2 margin_left_reset col-xs-5 col-sm-3 col-md-2 top-link pull-right news_line search_cart_buttons Y D 3623 3620 2 0 1 0 FULL_WIDTH div 1
2838 710 HEADER 5 col-xs-12 col-sm-4 col-md-4 top-link pull-right news_line search_cart_buttons resetgridwithrow navbar-secondary static-link Y D 3628 3625 2 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container content Y A 3652 3651 2 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column2 Y A 3764 3761 2 0 0 0 FULL_WIDTH div 0
2837 710 TOP_PANEL 6 left col-xs-12 col-sm-4 col-md-4 top-link pull-rights news_line search_cart_buttons resetgridwithrow navbar-secondary Y A 6988 6986 2 0 1 0 FULL_WIDTH div 1
2844 711 FOOTER 16 grid_container N A 6998 0 3 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column2 Y A 3765 3761 3 0 1 0 FULL_WIDTH div 1
2837 710 TOP_PANEL 16 clean_row Y A 3619 0 4 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 slider_container Y A 3648 0 4 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container content Y D 3761 3651 4 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column1 Y A 6971 3761 5 0 0 1 FULL_WIDTH div 0
2837 710 TOP_PANEL 16 clean_row Y A 3620 0 6 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 slider_container hidden-lg hidden-md hidden-sm Y D 7025 0 6 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container content Y A 3766 3651 6 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column2 Y A 6972 3761 6 0 0 0 FULL_WIDTH div 0
2843 711 CONTENT 4 column2 Y A 6973 3761 7 0 0 0 FULL_WIDTH div 0
2843 711 CONTENT 16 main-content-grid Y A 3651 0 8 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 4 column2 Y A 6974 3761 8 0 1 0 FULL_WIDTH div 1
2843 711 CONTENT 16 resetgrid container content circle_banners slick-style2 Y A 3649 0 10 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 blog-content-grid blog-widget parallax Y D 3653 0 12 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 our-brands-grid content Y D 3655 0 14 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 content social-widget animate-bg hidden-xs Y D 3657 0 16 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 grid_container content Y D 3659 0 18 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 reviews-content-grid Y D 3661 0 20 0 1 1 FULL_WIDTH div 1
2843 711 CONTENT 16 footer-content-grid Y A 3662 0 22 0 1 1 FULL_WIDTH div 1