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 (281, 282, 283, 164) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00151

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": 33,
              "filtered": 100,
              "index_condition": "g.container_id in (281,282,283,164)"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "c",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["container_id"],
          "ref": ["live_clonned.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
164 41 FOOTER 16 ty-footer-grid__full-width footer-stay-connected Y A 0 192 0 0 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 339 0 0 0 1 1 FULL_WIDTH div 1
282 71 HEADER 16 N A 0 347 0 0 0 1 1 FULL_WIDTH div 1
281 71 TOP_PANEL 16 N A 0 363 0 0 0 1 1 FULL_WIDTH div 1
164 41 FOOTER 10 ty-grid Y A 0 193 192 0 0 0 1 FULL_WIDTH div 0
164 41 FOOTER 6 ty-grid Y A 0 194 192 0 0 1 0 FULL_WIDTH div 1
164 41 FOOTER 4 my-account-grid Y A 0 196 195 0 0 0 1 LEFT div 0
164 41 FOOTER 11 bottom_footer_img Y A 0 323 322 0 0 0 1 FULL_WIDTH div 0
281 71 TOP_PANEL 3 top-links-grid top-mobile-sec-left-side N D 0 365 364 0 0 0 1 LEFT div 0
281 71 TOP_PANEL 3 top-links-grid hidden-phone hidden-tablet N D 0 369 368 0 0 0 1 LEFT div 0
282 71 HEADER 12 top-menu-grid N A 0 345 0 1 0 0 1 FULL_WIDTH div 0
281 71 TOP_PANEL 16 top-mobile-view-section-one hidden-desktop N A 0 364 0 1 0 1 1 FULL_WIDTH div 1
164 41 FOOTER 4 footer-store-grid Y A 0 197 195 1 0 0 0 LEFT div 0
164 41 FOOTER 5 Y A 0 324 322 1 0 1 0 FULL_WIDTH div 1
281 71 TOP_PANEL 8 top-links-grid hidden-desktop N A 0 367 364 1 0 0 0 LEFT div 0
281 71 TOP_PANEL 8 top-links-grid hidden-tablet hidden-phone N A 0 370 368 1 0 0 0 LEFT div 0
164 41 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 195 0 2 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 340 0 2 0 1 1 FULL_WIDTH div 1
282 71 HEADER 4 N A 0 346 0 2 0 1 0 FULL_WIDTH div 1
281 71 TOP_PANEL 16 top-mobile-view-section-two N D 0 368 0 2 0 1 1 FULL_WIDTH div 1
164 41 FOOTER 4 customer-service-grid Y A 0 198 195 2 0 0 0 LEFT div 0
281 71 TOP_PANEL 5 top-links-grid top-mobile-sec-right-side N A 0 366 364 2 0 1 0 RIGHT div 1
281 71 TOP_PANEL 5 top-links-grid N A 0 371 368 2 0 1 0 RIGHT div 1
281 71 TOP_PANEL 16 site_links N A 0 372 0 3 0 1 1 FULL_WIDTH div 1
164 41 FOOTER 4 about-grid Y A 0 199 195 3 0 1 0 LEFT div 1
164 41 FOOTER 16 copyright-sec Y A 0 322 0 4 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 341 0 4 0 1 1 FULL_WIDTH div 1
164 41 FOOTER 16 Y A 0 300 195 4 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 348 0 6 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 349 0 8 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 350 0 10 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 351 0 12 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 352 0 14 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 353 0 16 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 354 0 18 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 355 0 20 0 1 1 FULL_WIDTH div 1
283 71 CONTENT 16 Y A 0 343 0 22 0 1 1 FULL_WIDTH div 1