SELECT 
  * 
FROM 
  ushop_bm_containers as c 
  LEFT JOIN ushop_bm_grids as g ON g.container_id = c.container_id 
WHERE 
  1 
  AND g.container_id IN (1229, 1230, 1235, 1232) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00131

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "29.81"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "20.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "c",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "container_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 4,
            "rows_produced_per_join": 4,
            "filtered": "100.00",
            "index_condition": "(`marketplace`.`c`.`container_id` in (1229,1230,1235,1232))",
            "cost_info": {
              "read_cost": "2.41",
              "eval_cost": "0.40",
              "prefix_cost": "2.81",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "container_id",
              "location_id",
              "position",
              "width",
              "user_class",
              "linked_to_default",
              "status",
              "company_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "g",
            "access_type": "ref",
            "possible_keys": [
              "container_id"
            ],
            "key": "container_id",
            "used_key_parts": [
              "container_id"
            ],
            "key_length": "3",
            "ref": [
              "marketplace.c.container_id"
            ],
            "rows_examined_per_scan": 5,
            "rows_produced_per_join": 20,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "5.00",
              "eval_cost": "2.00",
              "prefix_cost": "9.81",
              "data_read_per_join": "17K"
            },
            "used_columns": [
              "grid_id",
              "container_id",
              "parent_id",
              "order",
              "width",
              "offset",
              "user_class",
              "omega",
              "alpha",
              "wrapper",
              "content_align",
              "html_element",
              "clear",
              "status",
              "abt__ut2_extended",
              "abt__ut2_padding",
              "abt__ut2_show_blocks_in_tabs",
              "abt__ut2_use_lazy_load"
            ]
          }
        }
      ]
    }
  }
}

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
1229 308 TOP_PANEL 3 top-grid-location N A 0 1958 0 0 0 0 1 LEFT div 0 0 no N
1229 308 TOP_PANEL 13 top-links-grid N D 0 1959 0 0 0 1 0 RIGHT div 1 0 no N
1230 308 HEADER 3 top-logo-grid Y A 0 1960 0 0 0 0 1 FULL_WIDTH div 0 0 no N
1232 308 FOOTER 16 ty-footer-menu b-top Y A 0 1969 0 0 0 1 1 FULL_WIDTH div 1 E no N
1232 308 FOOTER 16 ty-footer-grid__full-width footer-copyright Y A 0 1974 0 0 0 1 1 FULL_WIDTH div 1 O no N
1235 309 CONTENT 16 Y A 0 1985 0 0 0 1 1 FULL_WIDTH div 1 F ut2-bottom no N
1232 308 FOOTER 3 my-account-grid Y A 0 1970 1969 0 0 0 1 LEFT div 0 0 no N
1235 309 CONTENT 16 banners-grid hidden-phone Y A 0 1988 1987 0 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 banners-grid hidden-tablet hidden-desktop Y A 0 1992 1987 0 0 1 1 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 5 Y A 0 1989 1988 0 0 0 1 FULL_WIDTH div 0 0 no Y
1235 309 CONTENT 6 Y A 0 1990 1988 0 0 0 0 FULL_WIDTH div 0 0 no Y
1235 309 CONTENT 5 Y A 0 1991 1988 0 0 1 0 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 16 Explora-categorias Y A 0 1995 1994 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
1235 309 CONTENT 16 ut2-center Y A 0 1996 1994 0 0 1 1 FULL_WIDTH div 1 0 without_lazy_load Y
1235 309 CONTENT 16 Y A 0 1998 1997 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom no N
1235 309 CONTENT 16 mix-grid Y A 0 1999 1997 0 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 5 ab-mix-first Y A 0 2000 1999 0 0 0 1 FULL_WIDTH div 0 0 no Y
1235 309 CONTENT 6 ab-mix-center Y A 0 2001 1999 0 0 0 0 FULL_WIDTH div 0 0 no Y
1235 309 CONTENT 5 ab-mix-last Y A 0 2002 1999 0 0 1 0 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 16 Y D 0 2004 2003 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
1235 309 CONTENT 16 Y A 0 2005 2003 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no Y
1235 309 CONTENT 16 Y A 0 2006 2003 0 0 1 1 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 16 Y A 0 2009 2008 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
1235 309 CONTENT 16 Y A 0 2010 2008 0 0 1 1 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 16 Y A 0 2012 2011 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
1235 309 CONTENT 16 Y A 0 2013 2011 0 0 1 1 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 16 Y A 0 2016 2015 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
1235 309 CONTENT 16 Y A 0 2017 2015 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no Y
1235 309 CONTENT 16 Y A 0 2019 2018 0 0 1 1 FULL_WIDTH div 1 0 ut2-bottom-sm no N
1235 309 CONTENT 16 Y A 0 2020 2018 0 0 1 1 FULL_WIDTH div 1 0 no Y
1235 309 CONTENT 16 Y A 0 2023 2022 0 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 4 Y A 0 2028 2027 0 0 0 1 FULL_WIDTH div 0 0 no N
1235 309 CONTENT 4 Y A 0 2029 2027 0 0 0 0 FULL_WIDTH div 0 0 no N
1235 309 CONTENT 4 Y A 0 2030 2027 0 0 0 0 FULL_WIDTH div 0 0 no N
1235 309 CONTENT 4 Y A 0 2031 2027 0 0 1 0 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 8 Y A 0 2037 2036 0 0 0 1 FULL_WIDTH div 0 0 no N
1235 309 CONTENT 8 Y A 0 2038 2036 0 0 1 0 FULL_WIDTH div 1 0 no N
1230 308 HEADER 16 Y A 0 4086 4085 0 0 1 1 FULL_WIDTH div 1 0 no N
1230 308 HEADER 5 search-grid Y A 0 1961 0 1 0 0 0 FULL_WIDTH div 0 0 no N
1235 309 CONTENT 16 Y A 0 2272 0 1 0 1 1 FULL_WIDTH div 1 0 no N
1232 308 FOOTER 3 demo-store-grid Y A 0 1971 1969 1 0 0 0 LEFT div 0 0 no N
1232 308 FOOTER 16 Y A 0 1975 1974 1 0 1 1 LEFT div 1 0 no N
1230 308 HEADER 4 top-phones Y A 0 1962 0 2 0 0 0 FULL_WIDTH div 0 0 no N
1235 309 CONTENT 16 Y A 0 2262 0 2 0 1 1 FULL_WIDTH div 1 0 no N
1232 308 FOOTER 3 customer-service-grid Y A 0 1972 1969 2 0 0 0 LEFT div 0 0 no N
1230 308 HEADER 4 account-cart-grid Y A 0 1963 0 3 0 1 0 RIGHT div 1 0 no N
1235 309 CONTENT 16 Y A 0 1986 0 3 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1232 308 FOOTER 3 about-grid Y A 0 1973 1969 3 0 0 0 LEFT div 0 0 no N
1235 309 CONTENT 16 Y A 0 1987 0 4 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1232 308 FOOTER 3 Y A 0 2273 1969 4 0 1 0 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 Y A 0 1993 0 5 0 1 1 FULL_WIDTH div 1 0 no N
1230 308 HEADER 16 Y A 0 3457 0 5 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 Y A 0 1994 0 6 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1230 308 HEADER 16 Y A 0 1966 0 7 0 1 1 FULL_WIDTH div 1 E ut2-top no N
1235 309 CONTENT 16 ut2-wrap-container Y A 0 1997 0 7 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1235 309 CONTENT 16 Y A 0 2003 0 8 0 1 1 FULL_WIDTH div 1 E ut2-bottom-sm no N
1230 308 HEADER 16 second-header-grid top-menu-grid Y D 0 1964 0 9 0 1 1 FULL_WIDTH div 1 E no N
1235 309 CONTENT 16 Y A 0 2007 0 9 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 Y A 0 2008 0 10 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1230 308 HEADER 16 hidden-tablet hidden-desktop Y D 0 1965 0 11 0 1 1 FULL_WIDTH div 1 F no N
1235 309 CONTENT 16 Y A 0 2011 0 11 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1235 309 CONTENT 16 Y A 0 2014 0 12 0 1 1 FULL_WIDTH div 1 0 ut2-bottom no N
1235 309 CONTENT 16 Y A 0 2015 0 13 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1235 309 CONTENT 16 fill--color Y A 0 2018 0 14 0 1 1 FULL_WIDTH div 1 E ut2-top-bottom no N
1230 308 HEADER 16 Y A 0 4085 0 14 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 fill--gray Y D 0 2021 0 15 0 1 1 FULL_WIDTH div 1 E ut2-top-bottom no Y
1235 309 CONTENT 16 Y D 0 2022 0 16 0 1 1 FULL_WIDTH div 1 O no N
1235 309 CONTENT 16 Y A 0 2024 0 17 0 1 1 FULL_WIDTH div 1 O ut2-top-bottom no N
1235 309 CONTENT 16 Y A 0 2025 0 18 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 Y D 0 2026 0 19 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 banners-grid-resizable Y D 0 2027 0 20 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1235 309 CONTENT 16 Y A 0 2032 0 21 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 Y A 0 2033 0 22 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 4 banners-grid-resizable Y A 0 2034 0 23 0 1 1 FULL_WIDTH div 1 F no N
1235 309 CONTENT 16 Y A 0 2035 0 24 0 1 1 FULL_WIDTH div 1 0 no N
1235 309 CONTENT 16 mix-grid Y A 0 2036 0 25 0 1 1 FULL_WIDTH div 1 O ut2-bottom no N
1235 309 CONTENT 16 Y A 0 4026 0 26 0 1 1 FULL_WIDTH div 1 0 no N