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 (
    842, 843, 844, 845, 846, 847, 848, 849, 
    850, 851, 852, 853, 854, 855, 860, 859, 
    856, 861, 857, 858, 1252, 1251
  ) 
  AND cscart_bm_blocks_descriptions.lang_code = 'en' 
ORDER BY 
  cscart_bm_snapping.order, 
  cscart_bm_snapping.block_id

Query time 0.00124

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16771.61"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "12285.00"
      },
      "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": 39,
            "rows_produced_per_join": 39,
            "filtered": "100.00",
            "index_condition": "(`s2cart`.`cscart_bm_snapping`.`grid_id` in (842,843,844,845,846,847,848,849,850,851,852,853,854,855,860,859,856,861,857,858,1252,1251))",
            "cost_info": {
              "read_cost": "19.16",
              "eval_cost": "3.90",
              "prefix_cost": "23.06",
              "data_read_per_join": "30K"
            },
            "used_columns": [
              "snapping_id",
              "block_id",
              "grid_id",
              "wrapper",
              "user_class",
              "order",
              "status"
            ]
          }
        },
        {
          "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": [
              "s2cart.cscart_bm_snapping.snapping_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 39,
            "filtered": "100.00",
            "index_condition": "<if>(is_not_null_compl(cscart_bm_block_statuses), ((`s2cart`.`cscart_bm_snapping`.`snapping_id` = `s2cart`.`cscart_bm_block_statuses`.`snapping_id`) and (`s2cart`.`cscart_bm_block_statuses`.`object_type` like '')), true)",
            "cost_info": {
              "read_cost": "9.75",
              "eval_cost": "3.90",
              "prefix_cost": "36.71",
              "data_read_per_join": "4K"
            },
            "used_columns": [
              "snapping_id",
              "object_ids",
              "object_type"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_bm_blocks",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "block_id"
            ],
            "key_length": "4",
            "ref": [
              "s2cart.cscart_bm_snapping.block_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 39,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "9.75",
              "eval_cost": "3.90",
              "prefix_cost": "50.36",
              "data_read_per_join": "8K"
            },
            "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": [
              "s2cart.cscart_bm_snapping.block_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 39,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "9.75",
              "eval_cost": "3.90",
              "prefix_cost": "64.01",
              "data_read_per_join": "7K"
            },
            "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": [
              "s2cart.cscart_bm_snapping.block_id",
              "const",
              "s2cart.cscart_bm_blocks_descriptions.lang_code",
              "const"
            ],
            "rows_examined_per_scan": 9,
            "rows_produced_per_join": 351,
            "filtered": "100.00",
            "index_condition": "<if>(is_not_null_compl(default_content), (`s2cart`.`default_content`.`object_type` like ''), true)",
            "cost_info": {
              "read_cost": "87.75",
              "eval_cost": "35.10",
              "prefix_cost": "186.86",
              "data_read_per_join": "76K"
            },
            "used_columns": [
              "snapping_id",
              "object_id",
              "object_type",
              "block_id",
              "lang_code",
              "content"
            ]
          }
        },
        {
          "table": {
            "table_name": "dynamic_object_content",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "block_id"
            ],
            "key_length": "4",
            "ref": [
              "s2cart.cscart_bm_snapping.block_id"
            ],
            "rows_examined_per_scan": 35,
            "rows_produced_per_join": 12285,
            "filtered": "100.00",
            "index_condition": "<if>(is_not_null_compl(dynamic_object_content), ((`s2cart`.`dynamic_object_content`.`object_id` = 0) and (`s2cart`.`dynamic_object_content`.`lang_code` = `s2cart`.`cscart_bm_blocks_descriptions`.`lang_code`) and (`s2cart`.`dynamic_object_content`.`object_type` like '')), true)",
            "cost_info": {
              "read_cost": "3071.25",
              "eval_cost": "1228.50",
              "prefix_cost": "4486.61",
              "data_read_per_join": "2M"
            },
            "used_columns": [
              "object_id",
              "object_type",
              "block_id",
              "lang_code",
              "content"
            ]
          }
        }
      ]
    }
  }
}

Result

grid_id block_id content object_id object_type object_ids snapping_id wrapper user_class order status type properties company_id storefront_id lang_code name
844 5 0 997 top-logo 0 A template a:1:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";} 0 1 en Logo
852 10 0 1006 0 A breadcrumbs a:1:{s:8:"template";s:22:"common/breadcrumbs.tpl";} 0 1 en Breadcrumbs
853 11 0 1007 blocks/wrappers/mainbox_general.tpl 0 A main 0 1 en Main Content
860 19 0 1013 0 D template a:1:{s:8:"template";s:41:"blocks/static_templates/payment_icons.tpl";} 0 1 en Payment icons
843 50 0 994 top-languages 0 A 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 Languages
1252 84 0 1523 blocks/wrappers/footer_general.tpl 0 A template a:1:{s:8:"template";s:53:"blocks/static_templates/my_account_links_advanced.tpl";} 0 1 en Your Order
861 86 a:1:{s:7:"content";s:1112:"<div class="th_social-link facebook"> <a href="http://www.facebook.com" target="_blank"><i class="icon-tt-facebook-squared"></i></a> </div> <div class="th_social-link twitter"> <a href="https://twitter.com" target="_blank"><i class="icon-tt-twitter"></i></a> </div> <div class="th_social-link instagram"> <a href="https://instagram.com" target="_blank"><i class="icon-tt-instagram"></i></a> </div> <div class="th_social-link skype"> <a href="https://skype.com" target="_blank"><i class="icon-tt-skype"></i></a> </div> <div class="th_social-link snapchat"> <a href="https://snapchat.com" target="_blank"><i class="icon-tt-snapchat-ghost"></i></a> </div> <div class="th_social-link youtube"> <a href="https://youtube.com" target="_blank"><i class="icon-tt-youtube-play"></i></a> </div> <div class="th_social-link apple"> <a href="https://apple.com" target="_blank"><i class="icon-tt-apple"></i></a> </div> <div class="th_social-link android"> <a href="https://android.com" target="_blank"><i class="icon-tt-android"></i></a> </div>";} 0 1525 blocks/wrappers/footer_general.tpl 0 D smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Connect with us
842 205 0 993 0 A geo_maps_customer_location a:1:{s:8:"template";s:44:"addons/geo_maps/blocks/customer_location.tpl";} 0 1 en Customer location
846 208 0 999 top-buttons-grid hidden-phone 0 A template a:1:{s:8:"template";s:49:"blocks/static_templates/abt__ut2__top_buttons.tpl";} 0 1 en AB: Buttons Compare and Wishlist
855 213 0 1008 blocks/wrappers/footer_general.tpl 0 D template a:1:{s:8:"template";s:44:"blocks/static_templates/my_account_links.tpl";} 0 1 en My account
856 214 a:1:{s:7:"content";s:611:" <ul id="demo_store_links"> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=2"|fn_url}">About us</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=30"|fn_url}">Contact us</a></li> <li class="ty-footer-menu__item"><a href="{"gift_certificates.add"|fn_url}">Gift certificates</a></li> <li class="ty-footer-menu__item"><a href="{"product_features.view_all?filter_id=10"|fn_url}">Our brands</a></li> <li class="ty-footer-menu__item"><a href="{"sitemap.view"|fn_url}">Sitemap</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=7"|fn_url}">Blog</a></li> </ul>";} 0 1009 blocks/wrappers/footer_general.tpl footer-no-wysiwyg 0 D smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Demo Store
857 215 a:1:{s:7:"content";s:490:" <ul id="customer_service_links"> <li class="ty-footer-menu__item"><a href="{"orders.search"|fn_url}" rel="nofollow">About your order</a></li> {if $addons.wishlist && $addons.wishlist.status == 'A'} <li class="ty-footer-menu__item"><a href="{"wishlist.view"|fn_url}" rel="nofollow">Wishlist</a></li> {/if} {if $settings.General.enable_compare_products == 'Y'} <li class="ty-footer-menu__item"><a href="{"product_features.compare"|fn_url}" rel="nofollow">Comparison list</a></li> {/if} </ul>";} 0 1010 blocks/wrappers/footer_general.tpl footer-no-wysiwyg 0 D smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Customer Service
858 216 a:1:{s:7:"content";s:631:"<ul> <li>{$settings.Company.company_city}, {$settings.Company.company_address}</li> <li><a href="tel:{$settings.Company.company_phone}">{$settings.Company.company_phone} (the call is free)</a></li> <li><a href="tel:{$settings.Company.company_phone_2}">{$settings.Company.company_phone_2}</a></li> <li>{__('weekday_abr_1')}-{__('weekday_abr_0')} 9.00 - 18.00</li> <li><a class="ty-exception__links-a greeny" href="mailto:{$settings.Company.company_users_department}">{$settings.Company.company_users_department}</a></li> <li><a href="{'pages.view&page_id=20'|fn_url}" class="ty-exception__links-a">{__('view_on_map')}</a></li> </ul>";} 0 1011 blocks/wrappers/footer_general.tpl footer-no-wysiwyg 0 D smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Contact us
1251 236 a:1:{s:7:"content";s:826:"<div class="ut2-social-link-block"><div class="ty-mainbox-title">{__("get_social")}</div> <div class="ty-uppercase ty-social-link__title">Join us in the group <br> and be the first to know all promotions and offers!</div> <div class="ut2-social-links"> <a target="_blank" href="your_social_link"><i class="ut2-icon-facebook"></i></a> <a target="_blank" href="your_social_link"><i class="ut2-icon-vk"></i></a> <a target="_blank" href="your_social_link"><i class="ut2-icon-twitter"></i></a> <a target="_blank" href="your_social_link"><i class="ut2-icon-google-plus"></i></a> <a target="_blank" href="your_social_link"><i class="ut2-icon-youtube"></i></a> <a target="_blank" href="your_social_link"><i class="ut2-icon-skype"></i></a> <a target="_blank" href="your_social_link"><i class="ut2-icon-pinterest"></i></a> </div> </div>";} 0 1614 0 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en AB: Social links
860 281 a:1:{s:7:"content";s:74:"<!---<h4>Payment Ways</h4>---><p><img src="images/payment_icon.png"> </p>";} 0 1515 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en payment
846 318 a:1:{s:7:"content";s:1552:"<div class="sticky-container"> <ul class="sticky"> <li style="background:#ec1c24;width:100%;font-weight:bold;"> <img src="testing/images/produt-request.png"> <p><a href="/vendor-contact" class="Requirement"><span>Post Your <br>Requirement</span></a></p> </li> <!-- <li style="background:#ec1c24;width:100%;font-weight:bold;"> <img src="testing/images/our-needs.png"> <p style="padding-top: 15px;"><a href="#" class="need">Share Your Quote</a></p> </li> --> <li style="background:#00a551;width:100%;font-weight:bold;"> <img src="testing/images/seller.png"> <p><a href="/vendor-contact" class="Requirement">Want to Sell your<br> Idle Spares?</a></p> </li> <li style="background:#ec1c24;width:100%;font-weight:bold;"> <img src="testing/images/buyer.png"> <p><a href="/vendor-contact" class="Requirement">Looking For Quality <br>Clearance Stock?</a></p> </li> <li style="background:#00a551;width:100%;font-weight:bold;"> <img src="testing/images/partner.png"> <p><a href="/vendor-contact" class="Requirement">Want to become a <br>Business Partner?</a></p> </li> <li style="background:#ec1c24;width:100%;font-weight:bold;"> <img src="testing/images/our-needs.png"> <p style="padding-top: 15px;"><a href="/vendor-contact" class="need">Share Your Quote</a></p> </li> </ul> </div> ";} 0 1603 0 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en block
846 319 a:1:{s:7:"content";s:1003:"<style> .sticky li:hover { margin-left: -115px; } .sticky-container { padding: 0px; margin: 0px; position: fixed; right: -151px; top: 150px; width: 214px; z-index: 1100; } .sticky li img { float: left; margin: 5px 4px; margin-right: 5px; } .sticky li p { padding-top: 5px; margin: 0px; line-height: 16px; font-size: 11px; } a.Requirement, a.need { color: #ffff !important; font-size: 12px; } .sticky li p a { text-decoration: none; color: #2C3539; } /*.sticky li { list-style-type: none; background-color: #fff; color: #efefef; height: 44px; padding: 0px; margin: 0px 0px 1px 0px; -webkit-transition: all 0.25s ease-in-out; -moz-transition: all 0.25s ease-in-out; -o-transition: all 0.25s ease-in-out; transition: all 0.25s ease-in-out; cursor: pointer; }*/ .ty-wysiwyg-content ul { list-style-type: none!important; } </style> ";} 0 1604 0 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en css
843 2 0 995 top-currencies 1 A currencies a:3:{s:8:"template";s:21:"blocks/currencies.tpl";s:6:"format";s:6:"symbol";s:14:"dropdown_limit";s:1:"3";} 0 1 en Currencies
1251 87 0 1526 blocks/wrappers/footer_general.tpl 1 A template a:1:{s:8:"template";s:56:"addons/newsletters/blocks/static_templates/subscribe.tpl";} 0 1 en Newsletter sign up
855 195 a:1:{s:7:"content";s:156:"<span style="color:white;"><span class="fa fa-envelope"></span>&nbsp;&nbsp; Email :</span> <em><p style="color:white;">support@stock2cart.com</p></em> ";} 0 1516 blocks/wrappers/footer_general.tpl 1 D smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Contact Information
856 196 a:1:{s:4:"menu";s:1:"3";} 0 1517 blocks/wrappers/footer_general.tpl 1 A menu a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"N";} 0 1 en Get to know us
857 197 a:1:{s:4:"menu";s:1:"7";} 0 1519 blocks/wrappers/footer_general.tpl 1 A menu a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"N";} 0 1 en Let us Help You
858 198 a:1:{s:4:"menu";s:1:"8";} 0 1521 blocks/wrappers/footer_general.tpl 1 A menu a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"N";} 0 1 en Policy
846 209 a:1:{s:7:"content";s:406:"<div class="ut2-pn"> <div class="ut2-pn__items"> <a href="tel:{$settings.Company.company_phone}">{$settings.Company.company_phone}</a> <a href="tel:{$settings.Company.company_phone_2}">{$settings.Company.company_phone_2}</a> </div> <div class="ut2-pn__link"> {if $addons.call_requests.status == "A"}{include file="addons/call_requests/blocks/abt__ut2_call_request.tpl"}{/if} </div> </div>";} 0 1000 top-phones-grid 1 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en Request callback from us
861 280 a:1:{s:7:"content";s:108:"<p class="copyright">© 2011-2019 Stock2cart.com. Powered by GEESYS Technologies (India) Private Limited</p>";} 0 1514 1 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en copyright
843 3 a:1:{s:4:"menu";s:1:"1";} 0 996 top-quick-links 2 A menu a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"Y";} 0 1 en Quick links
850 7 0 1003 top-search 2 A template a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} 0 1 en Search
861 18 0 1012 2 D template a:1:{s:8:"template";s:37:"blocks/static_templates/copyright.tpl";} 0 1 en Copyright
851 51 0 1004 ut2-top-cart-content 2 A 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
845 207 a:1:{s:4:"menu";s:1:"3";} 0 998 hidden-phone 2 A menu a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"N";} 0 1 en Top menu
846 210 a:1:{s:7:"content";s:1558:"<div class="ut2-pn"> <div class="ty-dropdown-box"> <div class="ut2-btn-contacts" onclick="$(this).toggleClass('open');"> <i class="ut2-icon-baseline-phone"></i> <div class="ut2-pn__items-full ty-dropdown-box__content hidden"> <a href="javascript:void(0);" rel="nofollow" class="ut2-btn-close hidden" onclick="$(this).parent().prev().removeClass('open');"><i class="ut2-icon-baseline-close"></i></a> <div class="ut2-pn__items"> {* Change phones numbers *} <a href="tel:+88005550000"><span>+8(800)</span> 555-00-00</a> <a href="tel:+88005550001"><span>+8(800)</span> 555-00-01</a> <a href="tel:+88005550002"><span>+8(800)</span> 555-00-02</a> </div> <div class="ut2-pn__link hidden-desktop"> {if $addons.call_requests.status == "A"}{include file="addons/call_requests/blocks/abt__ut2_call_request.tpl"}{/if} </div> </div> </div> <div class="ut2-pn__wrap "> <div class="ut2-pn__items"> {* Change phone number *} <a href="tel:+88005559595"><span>+8(800)</span> 555-95-95</a> </div> <div class="ut2-pn__link"> {if $addons.call_requests.status == "A"}{include file="addons/call_requests/blocks/abt__ut2_call_request.tpl"}{/if} </div> </div> </div> </div>";} 0 1001 top-phones-grid 2 D smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en AB: Phone numbers (Demo)
849 211 a:1:{s:4:"menu";s:1:"6";} 0 1002 blocks/wrappers/onclick_dropdown.tpl top-menu-grid-vetrtical 2 A menu a:8:{s:8:"template";s:46:"blocks/menu/abt__ut2_dropdown_vertical_mwi.tpl";s:19:"abt_menu_icon_items";s:1:"Y";s:36:"no_hidden_elements_second_level_view";s:1:"5";s:36:"elements_per_column_third_level_view";s:2:"10";s:30:"dropdown_second_level_elements";s:2:"15";s:29:"dropdown_third_level_elements";s:1:"5";s:18:"abt_menu_ajax_load";s:1:"N";s:24:"abt__ut2_menu_min_height";i:475;} 0 1 en Categories
855 282 a:1:{s:7:"content";s:160:"<span style="color:#379424;"><span class="fa fa-envelope"></span>&nbsp;&nbsp; Email :</span> <em><p style="color:#379424;">support@stock2cart.com</p></em> ";} 0 1527 blocks/wrappers/footer_general.tpl 2 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en Contact Information
851 212 0 1005 ut2-top-my-account 3 A my_account a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} 0 1 en Account