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 (181, 182, 187, 184) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00177

JSON explain

{
  "query_block": {
    "select_id": 1,
    "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": 60,
          "filtered": 100,
          "index_condition": "g.container_id in (181,182,187,184)"
        }
      }
    },
    "table": {
      "table_name": "c",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["container_id"],
      "ref": ["kigoonlinecs.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 abt__ut2_extended abt__ut2_padding abt__ut2_show_blocks_in_tabs abt__ut2_use_lazy_load
181 46 TOP_PANEL 3 top-grid-location N A 0 275 0 0 0 0 1 LEFT div 0 0 no N
181 46 TOP_PANEL 13 top-links-grid N A 0 276 0 0 0 1 0 RIGHT div 1 0 no N
182 46 HEADER 3 top-logo-grid Y A 0 277 0 0 0 0 1 FULL_WIDTH div 0 0 no N
182 46 HEADER 5 search-grid Y A 0 278 0 0 0 0 0 FULL_WIDTH div 0 0 no N
182 46 HEADER 4 top-phones Y A 0 279 0 0 0 0 0 FULL_WIDTH div 0 0 no N
182 46 HEADER 4 account-cart-grid Y A 0 280 0 0 0 1 0 RIGHT div 1 0 no N
182 46 HEADER 16 second-header-grid top-menu-grid Y A 0 281 0 0 0 1 1 FULL_WIDTH div 1 E no N
184 46 FOOTER 16 ty-footer-menu b-top Y A 0 284 0 0 0 1 1 FULL_WIDTH div 1 E no N
184 46 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 289 0 0 0 1 1 FULL_WIDTH div 1 O no N
187 47 CONTENT 16 Y A 0 293 0 0 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
184 46 FOOTER 4 my-account-grid Y A 0 285 284 0 0 0 1 LEFT div 0 0 no N
184 46 FOOTER 4 demo-store-grid Y A 0 286 284 0 0 0 0 LEFT div 0 0 no N
184 46 FOOTER 4 customer-service-grid Y A 0 287 284 0 0 0 0 LEFT div 0 0 no N
184 46 FOOTER 4 about-grid Y A 0 288 284 0 0 1 0 LEFT div 1 0 no N
184 46 FOOTER 8 Y A 0 290 289 0 0 0 1 LEFT div 0 0 no N
184 46 FOOTER 8 Y A 0 291 289 0 0 1 0 RIGHT div 1 0 no N
187 47 CONTENT 16 Y A 0 1816 292 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 10 Y A 0 1813 293 0 0 0 1 FULL_WIDTH div 0 0 ut2-bottom-sm no N
187 47 CONTENT 4 Y A 0 295 294 0 0 0 1 FULL_WIDTH div 0 0 no N
187 47 CONTENT 16 Y A 0 303 302 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom no N
187 47 CONTENT 16 mix-grid Y A 0 304 302 0 0 1 1 FULL_WIDTH div 1 0 no N
187 47 CONTENT 5 ab-mix-first Y A 0 305 304 0 0 0 1 FULL_WIDTH div 0 0 no Y
187 47 CONTENT 6 ab-mix-center Y A 0 306 304 0 0 0 0 FULL_WIDTH div 0 0 no Y
187 47 CONTENT 5 ab-mix-last Y A 0 307 304 0 0 1 0 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 16 Y A 0 309 308 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 16 Y A 0 310 308 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no Y
187 47 CONTENT 16 Y A 0 311 308 0 0 1 1 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 16 Y A 0 313 312 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 16 Y A 0 317 315 0 0 1 1 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 16 banners-grid hidden-phone Y A 0 320 319 0 0 1 1 FULL_WIDTH div 1 0 no N
187 47 CONTENT 16 banners-grid hidden-tablet hidden-desktop Y A 0 324 319 0 0 1 1 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 5 Y A 0 321 320 0 0 0 1 FULL_WIDTH div 0 0 no Y
187 47 CONTENT 6 Y A 0 322 320 0 0 0 0 FULL_WIDTH div 0 0 no Y
187 47 CONTENT 5 Y A 0 323 320 0 0 1 0 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 16 Y A 0 326 325 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 16 Y A 0 327 325 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no Y
187 47 CONTENT 16 Y A 0 329 328 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 16 Y A 0 330 328 0 0 1 1 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 8 Y A 0 335 334 0 0 0 1 FULL_WIDTH div 0 0 no N
187 47 CONTENT 8 Y A 0 336 334 0 0 1 0 FULL_WIDTH div 1 0 no N
187 47 CONTENT 16 Y A 0 292 0 1 0 1 1 FULL_WIDTH div 1 F ut2-bottom no N
187 47 CONTENT 6 Y A 0 1812 293 1 0 1 0 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 4 Y A 0 296 294 1 0 0 0 FULL_WIDTH div 0 0 no N
187 47 CONTENT 16 Y A 0 314 312 1 0 1 1 FULL_WIDTH div 1 0 no Y
187 47 CONTENT 16 Y A 0 316 315 1 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
187 47 CONTENT 16 banners-grid-resizable Y A 0 294 0 2 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 4 Y A 0 297 294 2 0 0 0 FULL_WIDTH div 0 0 no N
187 47 CONTENT 16 Y A 0 299 0 3 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 4 Y A 0 298 294 3 0 1 0 FULL_WIDTH div 1 0 no N
187 47 CONTENT 16 ut2-wrap-container Y A 0 302 0 4 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 16 Y A 0 308 0 5 0 1 1 FULL_WIDTH div 1 E ut2-bottom-sm no N
187 47 CONTENT 16 Y A 0 312 0 6 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 16 Y A 0 315 0 7 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 16 Y A 0 318 0 8 0 1 1 FULL_WIDTH div 1 0 ut2-bottom no N
187 47 CONTENT 16 Y A 0 319 0 9 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 16 Y A 0 325 0 10 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
187 47 CONTENT 16 fill--color Y A 0 328 0 11 0 1 1 FULL_WIDTH div 1 E ut2-top-bottom no N
187 47 CONTENT 16 fill--gray Y D 0 331 0 12 0 1 1 FULL_WIDTH div 1 E ut2-top-bottom no Y
187 47 CONTENT 16 Y A 0 332 0 13 0 1 1 FULL_WIDTH div 1 O ut2-top-bottom no N
187 47 CONTENT 16 Y A 0 333 0 14 0 1 1 FULL_WIDTH div 1 0 no N
187 47 CONTENT 16 mix-grid Y A 0 334 0 15 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N