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 (2310, 2311, 2316, 2313) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00060

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.174082209,
    "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"],
              "loops": 1,
              "rows": 61,
              "cost": 0.07616664,
              "filtered": 100,
              "index_condition": "g.container_id in (2310,2311,2316,2313)"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "c",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["container_id"],
          "ref": ["u508912950_dev_2025.g.container_id"],
          "loops": 61,
          "rows": 1,
          "cost": 0.05865684,
          "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 section_class section_width sd_torino_width sd_torino_horizontal_align sd_torino_vertical_align sd_torino_vertical_override apply_background_color sd_torino_background_color sd_torino_background_full_width sd_torino_full_width abt__ut2_extended abt__ut2_padding abt__ut2_show_blocks_in_tabs abt__ut2_use_lazy_load
2310 578 TOP_PANEL 3 top-grid-location N A 0 3407 0 0 0 0 1 LEFT div 0 S NONE CENTER CENTER NONE N N N 0 no N
2310 578 TOP_PANEL 13 top-links-grid N A 0 3408 0 0 0 1 0 RIGHT div 1 S NONE CENTER CENTER NONE N N N 0 no N
2311 578 HEADER 16 top-menu-grid Y A 0 3409 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O no N
2311 578 HEADER 16 second-header-grid top-menu-grid Y A 0 3414 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N E no N
2313 578 FOOTER 16 ty-footer-menu b-top Y A 0 3417 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N E no N
2313 578 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 3422 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O no N
2316 579 CONTENT 16 Y A 0 3425 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N F ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3426 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 banners-grid-resizable Y A 0 3427 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3432 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 ut2-wrap-container Y A 0 3435 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3441 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N E ut2-bottom-sm no N
2316 579 CONTENT 16 Y A 0 3445 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3448 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3451 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3452 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 Y A 0 3458 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2316 579 CONTENT 16 fill--color Y A 0 3461 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N E ut2-top-bottom no N
2316 579 CONTENT 16 fill--gray Y A 0 3464 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N E ut2-top-bottom no Y
2316 579 CONTENT 16 Y A 0 3465 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-top-bottom no N
2316 579 CONTENT 16 Y A 0 3466 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 16 mix-grid Y A 0 3467 0 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N O ut2-bottom no N
2311 578 HEADER 4 top-logo Y A 0 3410 3409 0 0 0 1 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no N
2311 578 HEADER 9 top-search Y A 0 3411 3409 0 0 0 0 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no N
2311 578 HEADER 3 top-buttons top-button-cart Y A 0 3412 3409 0 0 1 0 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N
2311 578 HEADER 16 hidden-desktop hidden-tablet Y D 0 3413 3409 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N
2313 578 FOOTER 4 my-account-grid Y A 0 3418 3417 0 0 0 1 LEFT div 0 S NONE CENTER CENTER NONE N N N 0 no N
2313 578 FOOTER 4 demo-store-grid Y A 0 3419 3417 0 0 0 0 LEFT div 0 S NONE CENTER CENTER NONE N N N 0 no N
2313 578 FOOTER 4 customer-service-grid Y A 0 3420 3417 0 0 0 0 LEFT div 0 S NONE CENTER CENTER NONE N N N 0 no N
2313 578 FOOTER 4 about-grid Y A 0 3421 3417 0 0 1 0 LEFT div 1 S NONE CENTER CENTER NONE N N N 0 no N
2313 578 FOOTER 8 Y A 0 3423 3422 0 0 0 1 LEFT div 0 S NONE CENTER CENTER NONE N N N 0 no N
2313 578 FOOTER 8 Y A 0 3424 3422 0 0 1 0 RIGHT div 1 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 4 Y A 0 3428 3427 0 0 0 1 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 4 Y A 0 3429 3427 0 0 0 0 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 4 Y A 0 3430 3427 0 0 0 0 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 4 Y A 0 3431 3427 0 0 1 0 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 16 Y A 0 3433 3432 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no N
2316 579 CONTENT 16 ut2-center Y A 0 3434 3432 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 without_lazy_load Y
2316 579 CONTENT 16 Y A 0 3436 3435 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom no N
2316 579 CONTENT 16 mix-grid Y A 0 3437 3435 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 5 ab-mix-first Y A 0 3438 3437 0 0 0 1 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 6 ab-mix-center Y A 0 3439 3437 0 0 0 0 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 5 ab-mix-last Y A 0 3440 3437 0 0 1 0 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 16 Y A 0 3442 3441 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no N
2316 579 CONTENT 16 Y A 0 3443 3441 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no Y
2316 579 CONTENT 16 Y A 0 3444 3441 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 16 Y A 0 3446 3445 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no N
2316 579 CONTENT 16 Y A 0 3447 3445 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 16 Y A 0 3449 3448 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no N
2316 579 CONTENT 16 Y A 0 3450 3448 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 16 banners-grid hidden-phone Y A 0 3453 3452 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 16 banners-grid hidden-tablet hidden-desktop Y A 0 3457 3452 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 5 Y A 0 3454 3453 0 0 0 1 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 6 Y A 0 3455 3453 0 0 0 0 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 5 Y A 0 3456 3453 0 0 1 0 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 16 Y A 0 3459 3458 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no N
2316 579 CONTENT 16 Y A 0 3460 3458 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no Y
2316 579 CONTENT 16 Y A 0 3462 3461 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 ut2-bottom-sm no N
2316 579 CONTENT 16 Y A 0 3463 3461 0 0 1 1 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no Y
2316 579 CONTENT 8 Y A 0 3468 3467 0 0 0 1 FULL_WIDTH div 0 S NONE CENTER CENTER NONE N N N 0 no N
2316 579 CONTENT 8 Y A 0 3469 3467 0 0 1 0 FULL_WIDTH div 1 S NONE CENTER CENTER NONE N N N 0 no N