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 (1083, 1052, 1085, 1054) 
ORDER BY 
  g.order, 
  g.parent_id, 
  g.grid_id ASC

Query time 0.00096

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": 36,
          "filtered": 100,
          "index_condition": "g.container_id in (1083,1052,1085,1054)"
        }
      }
    },
    "table": {
      "table_name": "c",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["container_id"],
      "ref": ["vietpom_dev.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 parallax_speed parallax_effect_id
1052 202 HEADER 3 Y D 0 2199 0 0 0 0 1 FULL_WIDTH div 0
1054 202 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y D 0 2203 0 0 0 1 1 FULL_WIDTH div 1
1083 210 TOP_PANEL 16 N A 0 2289 0 0 0 1 1 FULL_WIDTH div 1 0
1085 210 CONTENT 12 gutter-b Y A 0 2396 0 0 0 0 1 FULL_WIDTH div 0
1054 202 FOOTER 4 Y A 0 2204 2203 0 0 0 1 FULL_WIDTH div 0
1054 202 FOOTER 3 Y A 0 2205 2203 0 0 0 0 FULL_WIDTH div 0
1054 202 FOOTER 3 Y A 0 2206 2203 0 0 0 0 FULL_WIDTH div 0
1054 202 FOOTER 3 Y A 0 2207 2203 0 0 0 0 FULL_WIDTH div 0
1054 202 FOOTER 3 Y A 0 2208 2203 0 0 1 0 FULL_WIDTH div 1
1054 202 FOOTER 10 Y A 0 2210 2209 0 0 0 1 FULL_WIDTH div 0
1054 202 FOOTER 6 Y A 0 2211 2209 0 0 1 0 FULL_WIDTH div 1
1054 202 FOOTER 16 hidden-phone Y A 0 2214 2213 0 0 1 1 LEFT div 1 0
1054 202 FOOTER 16 gutter-b Y A 0 2220 2219 0 0 1 1 FULL_WIDTH div 1 0
1083 210 TOP_PANEL 2 hidden-desktop hidden-tablet N A 0 2403 2402 0 0 0 1 FULL_WIDTH div 0
1052 202 HEADER 13 hidden-phone Y A 0 2200 0 1 0 1 0 FULL_WIDTH div 1 0
1054 202 FOOTER 16 ty-footer-grid__full-width footer-copyright Y D 0 2209 0 1 0 1 1 FULL_WIDTH div 1
1085 210 CONTENT 4 hidden-phone gutter-b Y A 0 2397 0 1 0 1 0 FULL_WIDTH div 1
1083 210 TOP_PANEL 3 hidden-tablet hidden-desktop N A 0 2404 2402 1 0 0 0 LEFT div 0
1054 202 FOOTER 16 Y A 0 2212 0 2 0 1 1 FULL_WIDTH div 1
1083 210 TOP_PANEL 3 hidden-phone N A 0 2290 0 2 0 0 1 LEFT div 0
1085 210 CONTENT 16 Y A 0 2398 0 2 0 1 1 FULL_WIDTH div 1
1054 202 FOOTER 16 Y A 0 2413 2213 2 0 1 1 FULL_WIDTH div 1
1083 210 TOP_PANEL 1 hidden-desktop hidden-tablet N A 0 2405 2402 2 0 0 0 RIGHT div 0
1054 202 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 2213 0 3 0 1 1 FULL_WIDTH div 1 0
1085 210 CONTENT 8 background gutter-y Y A 0 2292 0 3 0 0 1 FULL_WIDTH div 0 0
1083 210 TOP_PANEL 8 N A 0 2395 0 3 0 0 0 FULL_WIDTH div 0
1083 210 TOP_PANEL 1 hidden-desktop hidden-tablet N A 0 2406 2402 3 0 0 0 RIGHT div 0
1054 202 FOOTER 16 ty-footer-grid__full-width ty-footer-menu Y A 0 2219 0 4 0 1 1 FULL_WIDTH div 1 0
1083 210 TOP_PANEL 5 hidden-phone N A 0 2291 0 4 0 1 0 RIGHT div 1
1085 210 CONTENT 8 Y A 0 2293 0 4 0 1 0 FULL_WIDTH div 1
1054 202 FOOTER 8 Y A 0 2215 2213 4 0 0 1 LEFT div 0 0
1083 210 TOP_PANEL 7 hidden-tablet hidden-desktop N A 0 2407 2402 4 0 1 0 FULL_WIDTH div 1
1054 202 FOOTER 3 Y D 0 2216 2213 5 0 0 0 FULL_WIDTH div 0 0
1083 210 TOP_PANEL 16 top-panel-icons N A 0 2402 0 6 0 1 1 FULL_WIDTH div 1
1054 202 FOOTER 3 Y D 0 2217 2213 6 0 1 0 FULL_WIDTH div 1 0
1054 202 FOOTER 3 Y D 0 2218 2213 8 0 1 1 FULL_WIDTH div 1 0