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 (84, 87, 82, 81) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00255

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "g.`order`, g.parent_id, g.grid_id",
            "table": {
              "table_name": "g",
              "access_type": "range",
              "possible_keys": ["container_id"],
              "key": "container_id",
              "key_length": "3",
              "used_key_parts": ["container_id"],
              "rows": 44,
              "filtered": 100,
              "index_condition": "g.container_id in (84,87,82,81)"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "c",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["container_id"],
          "ref": ["batterycube.g.container_id"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

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
81 21 TOP_PANEL 3 top-links-grid Y A 0 89 0 0 0 0 1 LEFT div 0
81 21 TOP_PANEL 3 top-links-grid Y A 0 90 0 0 0 0 0 LEFT div 0
81 21 TOP_PANEL 8 top-links-grid Y A 0 91 0 0 0 0 0 RIGHT div 0
81 21 TOP_PANEL 2 top-links-grid Y A 0 92 0 0 0 1 0 RIGHT div 1
82 21 HEADER 4 top-logo-grid ty-top-logo-grid-responsive Y A 0 93 0 0 0 0 1 FULL_WIDTH div 0
82 21 HEADER 7 search-block-grid Y A 0 94 0 0 0 0 0 FULL_WIDTH div 0
82 21 HEADER 2 ty-cr-content-grid Y A 0 95 0 0 0 0 0 FULL_WIDTH div 0
82 21 HEADER 3 cart-content-grid Y A 0 96 0 0 0 1 0 RIGHT div 1
82 21 HEADER 16 top-menu-grid Y A 0 97 0 0 0 1 1 FULL_WIDTH div 1
84 21 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 0 100 0 0 0 1 1 FULL_WIDTH div 1
84 21 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 103 0 0 0 1 1 FULL_WIDTH div 1
84 21 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 108 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 Y A 0 111 0 0 0 1 1 FULL_WIDTH div 0
87 22 CONTENT 16 batterycube-highlights-grid Y A 0 112 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-category-grid Y A 0 113 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-why-grid Y A 0 114 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-featured-products-grid Y A 0 115 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-b2b-grid Y A 0 116 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 our-brands-grid batterycube-brands-grid Y A 0 117 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-applications-grid Y A 0 118 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-vendor-grid Y A 0 119 0 0 0 1 1 FULL_WIDTH div 1
87 22 CONTENT 16 batterycube-main-content-grid Y A 0 120 0 0 0 1 1 FULL_WIDTH div 1
84 21 FOOTER 10 ty-grid Y A 0 101 100 0 0 0 1 FULL_WIDTH div 0
84 21 FOOTER 6 ty-grid Y A 0 102 100 0 0 1 0 RIGHT div 1
84 21 FOOTER 4 my-account-grid Y A 0 104 103 0 0 0 1 FULL_WIDTH div 0
84 21 FOOTER 4 footer-store-grid Y A 0 105 103 0 0 0 0 FULL_WIDTH div 0
84 21 FOOTER 4 customer-service-grid Y A 0 106 103 0 0 0 0 FULL_WIDTH div 0
84 21 FOOTER 4 about-grid Y A 0 107 103 0 0 1 0 FULL_WIDTH div 1
84 21 FOOTER 8 Y A 0 109 108 0 0 0 1 LEFT div 0
84 21 FOOTER 8 Y A 0 110 108 0 0 1 0 RIGHT div 1