SELECT 
  cscart_bm_snapping.grid_id as grid_id, 
  cscart_bm_snapping.block_id as block_id, 
  IFNULL(
    dynamic_object_content.content, 
    default_content.content
  ) as content, 
  IFNULL(
    dynamic_object_content.object_id, 
    default_content.object_id
  ) AS object_id, 
  IFNULL(
    dynamic_object_content.object_type, 
    default_content.object_type
  ) AS object_type, 
  cscart_bm_block_statuses.object_ids as object_ids, 
  cscart_bm_snapping.*, 
  cscart_bm_blocks.*, 
  cscart_bm_blocks_descriptions.* 
FROM 
  cscart_bm_snapping 
  LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id 
  LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id 
  AND cscart_bm_block_statuses.object_type LIKE '' 
  LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id 
  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id 
  AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code 
  AND default_content.snapping_id = 0 
  AND default_content.object_id = 0 
  AND default_content.object_type like '' 
  LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id 
  AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code 
  AND dynamic_object_content.object_id = 0 
  AND dynamic_object_content.object_type like '' 
WHERE 
  cscart_bm_snapping.grid_id IN (
    448417, 448420, 448418, 448421, 448425, 
    448422, 448423, 448424, 448419, 448426, 
    448427, 448430, 448434, 448428, 448429, 
    448431, 448432, 448433, 448435, 448436, 
    448437, 448438, 448439, 448441, 448440, 
    448442, 448443, 448444
  ) 
  AND cscart_bm_blocks_descriptions.lang_code = 'en' 
ORDER BY 
  cscart_bm_snapping.order, 
  cscart_bm_snapping.block_id

Query time 0.00304

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1599.51"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "1038.68"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_bm_snapping",
            "access_type": "range",
            "possible_keys": [
              "grid_id"
            ],
            "key": "grid_id",
            "used_key_parts": [
              "grid_id"
            ],
            "key_length": "4",
            "rows_examined_per_scan": 45,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "index_condition": "(`webmarco`.`cscart_bm_snapping`.`grid_id` in (448417,448420,448418,448421,448425,448422,448423,448424,448419,448426,448427,448430,448434,448428,448429,448431,448432,448433,448435,448436,448437,448438,448439,448441,448440,448442,448443,448444))",
            "cost_info": {
              "read_cost": "82.01",
              "eval_cost": "9.00",
              "prefix_cost": "91.01",
              "data_read_per_join": "35K"
            },
            "used_columns": [
              "snapping_id",
              "block_id",
              "grid_id",
              "wrapper",
              "user_class",
              "order",
              "status",
              "ab__ab_hide_block"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_bm_block_statuses",
            "access_type": "ref",
            "possible_keys": [
              "snapping_id"
            ],
            "key": "snapping_id",
            "used_key_parts": [
              "snapping_id"
            ],
            "key_length": "4",
            "ref": [
              "webmarco.cscart_bm_snapping.snapping_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "45.00",
              "eval_cost": "9.00",
              "prefix_cost": "145.01",
              "data_read_per_join": "5K"
            },
            "used_columns": [
              "snapping_id",
              "object_ids",
              "object_type"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_bm_block_statuses), ((`webmarco`.`cscart_bm_snapping`.`snapping_id` = `webmarco`.`cscart_bm_block_statuses`.`snapping_id`) and (`webmarco`.`cscart_bm_block_statuses`.`object_type` like '')), true)"
          }
        },
        {
          "table": {
            "table_name": "cscart_bm_blocks",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "block_id"
            ],
            "key_length": "4",
            "ref": [
              "webmarco.cscart_bm_snapping.block_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "45.00",
              "eval_cost": "9.00",
              "prefix_cost": "199.01",
              "data_read_per_join": "9K"
            },
            "used_columns": [
              "block_id",
              "type",
              "properties",
              "company_id",
              "storefront_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_bm_blocks_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "block_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "webmarco.cscart_bm_snapping.block_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "45.00",
              "eval_cost": "9.00",
              "prefix_cost": "253.01",
              "data_read_per_join": "9K"
            },
            "used_columns": [
              "block_id",
              "lang_code",
              "name"
            ]
          }
        },
        {
          "table": {
            "table_name": "default_content",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "block_id",
              "snapping_id",
              "lang_code",
              "object_id"
            ],
            "key_length": "18",
            "ref": [
              "webmarco.cscart_bm_snapping.block_id",
              "const",
              "webmarco.cscart_bm_blocks_descriptions.lang_code",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "45.00",
              "eval_cost": "9.00",
              "prefix_cost": "307.01",
              "data_read_per_join": "9K"
            },
            "used_columns": [
              "snapping_id",
              "object_id",
              "object_type",
              "block_id",
              "lang_code",
              "content"
            ],
            "attached_condition": "<if>(is_not_null_compl(default_content), (`webmarco`.`default_content`.`object_type` like ''), true)"
          }
        },
        {
          "table": {
            "table_name": "dynamic_object_content",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "block_id"
            ],
            "key_length": "4",
            "ref": [
              "webmarco.cscart_bm_snapping.block_id"
            ],
            "rows_examined_per_scan": 23,
            "rows_produced_per_join": 1038,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "46.08",
              "eval_cost": "207.74",
              "prefix_cost": "560.83",
              "data_read_per_join": "227K"
            },
            "used_columns": [
              "snapping_id",
              "object_id",
              "object_type",
              "block_id",
              "lang_code",
              "content"
            ],
            "attached_condition": "<if>(is_not_null_compl(dynamic_object_content), ((`webmarco`.`dynamic_object_content`.`object_id` = 0) and (`webmarco`.`dynamic_object_content`.`lang_code` = `webmarco`.`cscart_bm_blocks_descriptions`.`lang_code`) and (`webmarco`.`dynamic_object_content`.`object_type` like '')), true)"
          }
        }
      ]
    }
  }
}

Result

grid_id block_id content object_id object_type object_ids snapping_id wrapper user_class order status ab__ab_hide_block type properties company_id storefront_id lang_code name
448425 360 0 553216 0 A N languages a:3:{s:8:"template";s:20:"blocks/languages.tpl";s:6:"format";s:4:"name";s:14:"dropdown_limit";s:1:"0";} 0 1 en Language
448424 369 0 553213 0 A N template a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} 0 1 en Search
448423 370 0 553212 0 A N call_request a:1:{s:8:"template";s:44:"addons/call_requests/blocks/call_request.tpl";} 0 1 en Call Request
448429 416 0 553220 0 A N vendor_search a:1:{s:8:"template";s:32:"blocks/vendors/vendor_search.tpl";} 0 1 en Vendor search
448439 1233 a:8:{s:20:"et_eib_block_1_title";s:15:"Happy Customers";s:19:"et_eib_block_1_text";s:149:"Lorem ipsum dolor sit amet, consectetuer a dipiscing elit, sed diam nonummy nibh euismod tincidunt ut Lorem ipsum dolor consectetuer a dipiscing elit";s:20:"et_eib_block_2_title";s:15:"Premium Vendors";s:19:"et_eib_block_2_text";s:149:"Lorem ipsum dolor sit amet, consectetuer a dipiscing elit, sed diam nonummy nibh euismod tincidunt ut Lorem ipsum dolor consectetuer a dipiscing elit";s:20:"et_eib_block_3_title";s:23:"Your Secure Marketplace";s:19:"et_eib_block_3_text";s:149:"Lorem ipsum dolor sit amet, consectetuer a dipiscing elit, sed diam nonummy nibh euismod tincidunt ut Lorem ipsum dolor consectetuer a dipiscing elit";s:20:"et_eib_block_4_title";s:20:"Buy or Sell Anything";s:19:"et_eib_block_4_text";s:149:"Lorem ipsum dolor sit amet, consectetuer a dipiscing elit, sed diam nonummy nibh euismod tincidunt ut Lorem ipsum dolor consectetuer a dipiscing elit";} 0 553231 addons/et_vivashop_settings/blocks/eib_wrappers/fib_wrapper.tpl 0 A N et_eib a:2:{s:8:"template";s:42:"addons/et_vivashop_settings/blocks/eib.tpl";s:11:"et_settings";a:8:{s:16:"et_icon_position";s:1:"T";s:22:"additional_colors_type";s:1:"S";s:14:"main_bkg_color";s:7:"#eef1ea";s:4:"text";s:7:"#333333";s:6:"icon_1";a:5:{s:4:"type";s:1:"C";s:5:"value";s:17:"et-icon-fib-happy";s:10:"color_type";s:1:"S";s:5:"color";s:7:"#333333";s:3:"bkg";s:7:"#eef1ea";}s:6:"icon_2";a:5:{s:4:"type";s:1:"C";s:5:"value";s:19:"et-icon-fib-premium";s:10:"color_type";s:1:"S";s:5:"color";s:7:"#333333";s:3:"bkg";s:7:"#eef1ea";}s:6:"icon_3";a:5:{s:4:"type";s:1:"C";s:5:"value";s:18:"et-icon-fib-secure";s:10:"color_type";s:1:"S";s:5:"color";s:7:"#333333";s:3:"bkg";s:7:"#eef1ea";}s:6:"icon_4";a:5:{s:4:"type";s:1:"C";s:5:"value";s:20:"et-icon-fib-buy-sell";s:10:"color_type";s:1:"S";s:5:"color";s:7:"#333333";s:3:"bkg";s:7:"#eef1ea";}}} 0 1 en Footer info blocks
448419 1248 a:1:{s:4:"menu";s:1:"1";} 0 553207 et-top-right-link 0 D N et_top_menu a:1:{s:8:"template";s:42:"addons/et_mega_menu/blocks/et_top_menu.tpl";} 0 1 en Top right menu - VIVAshop
448431 1250 a:1:{s:5:"items";a:1:{s:7:"filling";s:13:"full_tree_cat";}} 0 553221 addons/et_mega_menu/blocks/wrappers/et_category_menu_icon.tpl 0 A N et_main_menu a:3:{s:8:"template";s:43:"addons/et_mega_menu/blocks/et_main_menu.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"5";} 0 1 en All categories
448422 1326 0 553211 0 A N template a:2:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";s:11:"enable_link";s:1:"Y";} 0 1 en Logo (vendor page)
448426 1327 0 553218 0 A N et_vendor_store_header_mobile a:1:{s:8:"template";s:76:"addons/et_vivashop_mv_functionality/blocks/et_vendor_store_header_mobile.tpl";} 0 1 en Vendor store header mobile
448428 1328 a:1:{s:10:"menu_items";a:1:{s:7:"filling";s:13:"full_tree_cat";}} 0 553219 0 A N et_vendor_store_menu_mobile a:1:{s:8:"template";s:74:"addons/et_vivashop_mv_functionality/blocks/et_vendor_store_menu_mobile.tpl";} 0 1 en Vendor store menu mobile
448434 1329 0 553225 0 A N et_vendor_store_header a:1:{s:8:"template";s:69:"addons/et_vivashop_mv_functionality/blocks/et_vendor_store_header.tpl";} 0 1 en Vendor store header
448438 1339 a:1:{s:5:"items";a:6:{s:7:"filling";s:14:"et_same_vendor";s:5:"limit";s:2:"10";s:13:"percent_range";s:0:"";s:16:"similar_category";s:1:"Y";s:15:"similar_subcats";s:1:"Y";s:16:"similar_in_stock";s:1:"Y";}} 0 553229 blocks/wrappers/et_mainbox_simple.tpl 0 A N products a:2:{s:8:"template";s:30:"blocks/products/short_list.tpl";s:23:"hide_add_to_cart_button";s:1:"N";} 0 1 en More items from us
448438 1340 a:1:{s:5:"items";a:6:{s:7:"filling";s:14:"et_same_vendor";s:5:"limit";s:2:"20";s:13:"percent_range";s:0:"";s:16:"similar_category";s:1:"N";s:15:"similar_subcats";s:1:"Y";s:16:"similar_in_stock";s:1:"Y";}} 0 553230 blocks/wrappers/et_mainbox_simple.tpl margin-top 0 A N products a:11:{s:8:"template";s:37:"blocks/products/products_scroller.tpl";s:10:"show_price";s:1:"Y";s:17:"enable_quick_view";s:1:"Y";s:24:"not_scroll_automatically";s:1:"Y";s:15:"scroll_per_page";s:1:"Y";s:5:"speed";s:3:"400";s:11:"pause_delay";s:1:"3";s:13:"item_quantity";s:1:"6";s:15:"thumbnail_width";s:3:"203";s:18:"outside_navigation";s:1:"Y";s:23:"hide_add_to_cart_button";s:1:"N";} 0 1 en Our best products
448444 1374 a:1:{s:7:"content";s:373:"<div class="social-right-links"> <a href="https://www.facebook.com/IlTuoBusinessPartner/?modal=admin_todo_tour" class="social-right-icon social-right-fb" target="_blank"><i class="fab fa-facebook"></i></a> <a href="https://www.instagram.com/webmarco_/" class="social-right-icon social-right-ig" target="_blank"><i class="fab fa-instagram"></i></a> </div> ";} 0 553238 0 D N smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en FB + Insta
448418 1410 a:1:{s:7:"content";s:653:"<div class="social-top-links"> <a href="https://www.facebook.com/IlTuoBusinessPartner/?modal=admin_todo_tour" class="social-top-icon social-top-fb" target="_blank"><i class="fab fa-facebook"></i></a> <a href="https://www.instagram.com/webmarco_/" class="social-top-icon social-top-ig" target="_blank"><i class="fab fa-instagram"></i></a> <a href="https://www.youtube.com/channel/UC8C400XdYN5xte5Jwz73uvA" class="social-top-icon social-top-yt" target="_blank"><i class="fab fa-youtube"></i></a> <a href="https://wa.link/vrlj31" class="social-top-icon social-top-wp" target="_blank"><i class="fab fa-whatsapp"></i></a> </div> ";} 0 553205 0 D N smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Top Social Links
448431 103 0 553222 1 A N template a:1:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";} 0 1 en Logo
448419 435 0 553208 top-cart-content 1 A N cart_content a:4:{s:8:"template";s:23:"blocks/cart_content.tpl";s:22:"display_bottom_buttons";s:1:"Y";s:20:"display_delete_icons";s:1:"Y";s:19:"products_links_type";s:5:"thumb";} 0 1 en Cart content
448418 1246 a:1:{s:4:"menu";s:2:"12";} 0 553203 et-top-left-link 1 D N et_top_menu a:1:{s:8:"template";s:42:"addons/et_mega_menu/blocks/et_top_menu.tpl";} 0 1 en Top left menu - VIVAshop
448425 1247 0 553217 1 A N currencies a:3:{s:8:"template";s:21:"blocks/currencies.tpl";s:6:"format";s:4:"name";s:14:"dropdown_limit";s:1:"0";} 0 1 en Currencies
448424 1250 a:1:{s:5:"items";a:1:{s:7:"filling";s:13:"full_tree_cat";}} 0 553214 1 A N et_main_menu a:3:{s:8:"template";s:43:"addons/et_mega_menu/blocks/et_main_menu.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"5";} 0 1 en All categories
448434 1330 a:1:{s:10:"menu_items";a:1:{s:7:"filling";s:13:"full_tree_cat";}} 0 553226 1 A N et_vendor_store_menu a:1:{s:8:"template";s:67:"addons/et_vivashop_mv_functionality/blocks/et_vendor_store_menu.tpl";} 0 1 en Vendor store menu
448441 18 0 553232 2 A N template a:1:{s:8:"template";s:37:"blocks/static_templates/copyright.tpl";} 0 1 en Copyright
448435 373 0 553227 2 A N breadcrumbs a:1:{s:8:"template";s:22:"common/breadcrumbs.tpl";} 0 1 en Breadcrumbs
448437 374 0 553228 2 A N main 0 1 en Main Content
448443 1243 0 553233 2 A N template a:1:{s:8:"template";s:46:"blocks/static_templates/mobile_sticky_home.tpl";} 0 1 en Mobile sticky - Home
448418 1247 0 553204 top-currencies 2 A N currencies a:3:{s:8:"template";s:21:"blocks/currencies.tpl";s:6:"format";s:4:"name";s:14:"dropdown_limit";s:1:"0";} 0 1 en Currencies
448432 1249 0 553223 et-header-call 2 D N call_request a:1:{s:8:"template";s:44:"addons/call_requests/blocks/call_request.tpl";} 0 1 en Call
448424 1251 a:1:{s:4:"menu";s:1:"2";} 0 553215 2 A N et_menu_horizontal a:3:{s:8:"template";s:49:"addons/et_mega_menu/blocks/et_menu_horizontal.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"6";} 0 1 en Main Menu - VIVAshop
448419 1253 0 553209 2 A N template a:1:{s:8:"template";s:48:"blocks/static_templates/top_wishlist_compare.tpl";} 0 1 en Wishlist/Comparison links
448418 360 0 553206 top-languages 3 A N languages a:3:{s:8:"template";s:20:"blocks/languages.tpl";s:6:"format";s:4:"name";s:14:"dropdown_limit";s:1:"0";} 0 1 en Language
448419 367 0 553210 blocks/wrappers/onclick_dropdown.tpl top-my-account 3 A N my_account a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} 0 1 en My Account
448443 367 0 553234 blocks/wrappers/et_sticky_my_account.tpl 3 A N my_account a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} 0 1 en My Account
448432 369 0 553224 et-top-search 3 A N template a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} 0 1 en Search
448443 1244 0 553235 4 A N template a:1:{s:8:"template";s:49:"blocks/static_templates/mobile_sticky_compare.tpl";} 0 1 en Mobile sticky - Compare link
448443 1245 0 553236 5 A N template a:1:{s:8:"template";s:50:"blocks/static_templates/mobile_sticky_wishlist.tpl";} 0 1 en Mobile sticky - Wishlist
448443 435 0 553237 blocks/wrappers/et_sticky_cart.tpl 6 A N cart_content a:4:{s:8:"template";s:23:"blocks/cart_content.tpl";s:22:"display_bottom_buttons";s:1:"Y";s:20:"display_delete_icons";s:1:"Y";s:19:"products_links_type";s:5:"thumb";} 0 1 en Cart content