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 (
    94, 95, 96, 116, 118, 119, 120, 121, 122, 
    280, 279, 335, 286, 284, 287, 285, 281, 
    288, 282, 283
  ) 
  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,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_bm_snapping.`order`, cscart_bm_snapping.block_id",
        "table": {
          "table_name": "cscart_bm_snapping",
          "access_type": "range",
          "possible_keys": ["grid_id"],
          "key": "grid_id",
          "key_length": "4",
          "used_key_parts": ["grid_id"],
          "rows": 42,
          "filtered": 100,
          "index_condition": "cscart_bm_snapping.grid_id in (94,95,96,116,118,119,120,121,122,280,279,335,286,284,287,285,281,288,282,283)"
        }
      }
    },
    "table": {
      "table_name": "cscart_bm_block_statuses",
      "access_type": "ref",
      "possible_keys": ["snapping_id"],
      "key": "snapping_id",
      "key_length": "4",
      "used_key_parts": ["snapping_id"],
      "ref": ["dev.cscart_bm_snapping.snapping_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id and cscart_bm_block_statuses.object_type like '')"
    },
    "table": {
      "table_name": "cscart_bm_blocks",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["block_id"],
      "ref": ["dev.cscart_bm_snapping.block_id"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_bm_blocks_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "10",
      "used_key_parts": ["block_id", "lang_code"],
      "ref": ["dev.cscart_bm_snapping.block_id", "const"],
      "rows": 1,
      "filtered": 100,
      "index_condition": "cscart_bm_blocks_descriptions.lang_code = 'en'"
    },
    "table": {
      "table_name": "default_content",
      "access_type": "ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "18",
      "used_key_parts": ["block_id", "snapping_id", "lang_code", "object_id"],
      "ref": [
        "dev.cscart_bm_snapping.block_id",
        "const",
        "dev.cscart_bm_blocks_descriptions.lang_code",
        "const"
      ],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(default_content.object_type like '')"
    },
    "table": {
      "table_name": "dynamic_object_content",
      "access_type": "ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["block_id"],
      "ref": ["dev.cscart_bm_snapping.block_id"],
      "rows": 4,
      "filtered": 100,
      "attached_condition": "trigcond(dynamic_object_content.lang_code = cscart_bm_blocks_descriptions.lang_code and dynamic_object_content.object_id = 0 and dynamic_object_content.object_type like '')"
    }
  }
}

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
286 5 0 338 0 A template a:2:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";s:11:"enable_link";s:1:"Y";} 0 1 en Logo
116 20 a:3:{s:5:"width";s:0:"";s:6:"height";s:3:"360";s:5:"items";a:2:{s:7:"filling";s:8:"manually";s:8:"item_ids";s:5:"24,25";}} 0 120 homepage-heros 0 A banners a:3:{s:8:"template";s:41:"addons/eitems_banners/blocks/carousel.tpl";s:10:"navigation";s:1:"N";s:5:"delay";s:1:"3";} 0 1 en Homepage Banners
120 24 a:1:{s:5:"items";a:3:{s:7:"filling";s:15:"blog.text_links";s:14:"parent_page_id";s:1:"7";s:5:"limit";s:1:"5";}} 0 124 blocks/wrappers/mainbox_simple.tpl 0 A blog a:1:{s:8:"template";s:33:"addons/blog/blocks/text_links.tpl";} 0 1 en Blog
121 25 0 125 blocks/wrappers/mainbox_simple.tpl homepage-reviews 0 A testimonials a:8:{s:8:"template";s:41:"addons/discussion/blocks/testimonials.tpl";s:5:"limit";s:1:"2";s:6:"random";s:1:"N";s:24:"not_scroll_automatically";s:1:"N";s:5:"speed";s:3:"400";s:11:"pause_delay";s:1:"3";s:13:"item_quantity";s:1:"1";s:18:"outside_navigation";s:1:"N";} 0 1 en Reviews
95 65 a:1:{s:5:"items";a:3:{s:7:"filling";s:13:"full_tree_cat";s:18:"parent_category_id";s:0:"";s:7:"sort_by";s:8:"position";}} 0 306 0 A categories a:2:{s:8:"template";s:50:"blocks/categories/categories_dropdown_vertical.tpl";s:25:"right_to_left_orientation";s:1:"N";} 0 1 en All Games
285 90 a:1:{s:4:"menu";s:1:"5";} 0 336 0 A menu a:2:{s:8:"template";s:21:"blocks/menu/icons.tpl";s:18:"show_items_in_line";s:1:"Y";} 0 1 en Social
286 92 a:1:{s:7:"content";s:80:"<p><strong>Eitems is the leading virtual gaming goods marketplace</strong></p> ";} 0 337 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en footer logo subtext
287 93 a:1:{s:4:"menu";s:1:"6";} 0 339 0 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 fooer menu
281 95 a:1:{s:7:"content";s:111:"<h1>Subscribe to our newsletter</h1> <p>Subscribe to our newsletter and stay tuned with future updates</p> ";} 0 334 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en Subscribe to our newsletter
279 97 a:1:{s:7:"content";s:339:"<div> <div class="icon--smile">&nbsp;</div> <p>Leading User Experience</p> </div> <div> <div class="icon--speed">&nbsp;</div> <p>Speedy Delivery</p> </div> <div> <div class="icon--protection">&nbsp;</div> <p>Trade Protection</p> </div> <div> <div class="icon--refund">&nbsp;</div> <p>Refund Policy</p> </div> ";} 0 327 homepage-icons 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en HP Icons
280 98 a:1:{s:7:"content";s:256:"<h1>Ready to start?</h1> <p>Start trending today. Maximize your gaming experience with just a few clicks.</p> <div class="buttons"><a class="btn btn-main" href="#">Starts Selling</a> <a class="btn btn-secondary-hero" href="#">Begin Buying</a></div> ";} 0 328 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en Ready to start?
96 104 0 346 top-styleswitcher 0 A eitems_design_styleswitcher a:1:{s:8:"template";s:45:"addons/eitems_design/blocks/styleswitcher.tpl";} 0 1 en Styleswitcher
288 121 a:1:{s:13:"chat_messages";a:1:{s:7:"filling";s:7:"default";}} 0 432 0 A eitems_chat_main a:2:{s:8:"template";s:39:"addons/eitems_chat/blocks/main_chat.tpl";s:10:"show_title";s:1:"Y";} 0 1 en Main Chat
122 140 0 552 space-top homepage-services 0 A eitems_service_types_main_page a:9:{s:8:"template";s:57:"addons/eitems_service_types/blocks/main_page_services.tpl";s:24:"not_scroll_automatically";s:1:"N";s:15:"scroll_per_page";s:1:"N";s:5:"speed";s:3:"400";s:11:"pause_delay";s:1:"3";s:13:"item_quantity";s:1:"6";s:3:"nav";s:1:"Y";s:10:"show_title";s:1:"Y";s:19:"show_products_count";s:1:"Y";} 0 1 en Main page Service Types
94 5 0 105 top-logo 1 A template a:2:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";s:11:"enable_link";s:1:"Y";} 0 1 en Logo
281 12 0 333 1 A template a:1:{s:8:"template";s:65:"addons/newsletters/blocks/static_templates/subscribe_advanced.tpl";} 0 1 en Subscribe
96 64 0 332 top-languages 1 A languages a:3:{s:8:"template";s:20:"blocks/languages.tpl";s:6:"format";s:4:"icon";s:14:"dropdown_limit";s:1:"0";} 0 1 en Languages
95 85 0 307 1 A categories_dropdown a:1:{s:8:"template";s:30:"blocks/categories_dropdown.tpl";} 0 1 en Features dropdown
284 91 a:1:{s:7:"content";s:25:"&copy; {date('Y')} Eitems";} 0 335 1 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 0 1 en copyright
122 109 0 353 space-top homepage-services 1 D eitems_services_main_page a:9:{s:8:"template";s:43:"addons/eitems_services/blocks/main_page.tpl";s:24:"not_scroll_automatically";s:1:"N";s:15:"scroll_per_page";s:1:"N";s:5:"speed";s:3:"400";s:11:"pause_delay";s:1:"3";s:13:"item_quantity";s:1:"6";s:3:"nav";s:1:"Y";s:10:"show_title";s:1:"Y";s:19:"show_products_count";s:1:"Y";} 0 1 en Services
95 141 0 551 top-search categories-dropdown 1 A eitems_service_types_search a:1:{s:8:"template";s:45:"addons/eitems_service_types/blocks/search.tpl";} 0 1 en Top Block Search
96 2 0 102 top-currencies 2 A currencies a:3:{s:8:"template";s:21:"blocks/currencies.tpl";s:6:"format";s:6:"symbol";s:14:"dropdown_limit";s:1:"1";} 0 1 en Currencies
118 22 a:1:{s:5:"items";a:2:{s:7:"filling";s:8:"manually";s:8:"item_ids";s:23:"241,244,245,246,247,248";}} 0 122 blocks/wrappers/mainbox_simple.tpl homepage-hotdeals 2 D 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:"N";s:24:"not_scroll_automatically";s:1:"Y";s:5:"speed";s:3:"400";s:15:"scroll_per_page";s:1:"Y";s:11:"pause_delay";s:1:"3";s:13:"item_quantity";s:1:"4";s:15:"thumbnail_width";s:3:"160";s:23:"hide_add_to_cart_button";s:1:"Y";s:18:"outside_navigation";s:1:"Y";} 0 1 en Hot deals
122 99 0 329 space-top homepage-categories 2 D eitems_design_feature_variants_list a:10:{s:8:"template";s:57:"addons/eitems_design/blocks/feature_variants_carousel.tpl";s:24:"not_scroll_automatically";s:1:"N";s:15:"scroll_per_page";s:1:"N";s:5:"speed";s:3:"400";s:11:"pause_delay";s:1:"3";s:13:"item_quantity";s:1:"6";s:3:"nav";s:1:"Y";s:10:"show_title";s:1:"Y";s:19:"show_products_count";s:1:"Y";s:7:"feature";s:1:"2";} 0 1 en Categories
95 108 0 352 top-search categories-dropdown 2 D eitems_services_search a:1:{s:8:"template";s:40:"addons/eitems_services/blocks/search.tpl";} 0 1 en Services Search
288 115 a:1:{s:7:"content";s:5569:"<h3>E-items: Your Trusted Marketplace for in-Game Goods</h3> <p>Welcome to E-items, the ultimate destination for all your gaming service needs. As a trusted marketplace, we pride ourselves on providing a reliable platform for buying and selling in-game goods. Discover a wide selection of products and services that will enhance your gaming experience and help you achieve success in the virtual world.</p> <h3>Top Selling Gamer Marketplaces</h3> <p>E-items is one of the leading gaming markets, where thousands of gamers from all over the world find everything they need for a successful gaming journey. Our platform offers a wide range of products. We have collected for you products and services for all games in one place, and now you do not need to waste time searching the Internet - we sell everything!</p> <h3>How It Works</h3> <p>At E-items, we've streamlined the process to ensure a seamless and hassle-free experience. Here's how it works:</p> <ol> <li>Create an Account: Sign up for a free account on E-items to unlock all the features and benefits our marketplace has to offer. Registration is quick and easy, allowing you to dive into the world of gaming in no time.</li> <li>Browse and Search: Explore our extensive collection of gaming goods and services. Whether you're seeking boosters, power-leveling services, or in-game items, we have everything you need to take your gaming to the next level. Use our intuitive search function to find exactly what you're looking for.</li> <li>Compare and Choose: With E-items, you have the power to compare prices, read reviews, and evaluate offerings from various sellers. This ensures that you make an informed decision and get the best value for your money.</li> <li>Secure Transactions: Once you've selected the perfect item or service, proceed to checkout with confidence. Our secure payment system guarantees the safety of your transaction, providing peace of mind every step of the way.</li> <li>Enjoy Your Purchase: Sit back, relax, and get ready to elevate your gameplay. Your purchased gaming goods or services will be delivered promptly, allowing you to immerse yourself in the excitement of your favorite games.</li> </ol> <h3>Buy Gaming Goods and Boost Your Gameplay</h3> <p>E-items is your one-stop shop for purchasing gaming goods that will revolutionize your gaming experience. Whether you're a PC enthusiast, Xbox aficionado, or immersed in the vast world of MMOs, our marketplace offers a wide range of products and services to suit your gaming needs.</p> <p>Discover an array of boosters, power-leveling services, and in-game items that will give you the competitive edge. Our handpicked team of expert boosters is dedicated to helping you achieve your gaming goals. With their expertise and insider knowledge, you'll reach new heights of skill and become a true gaming champion.</p> <p>Unlock a world of possibilities and supercharge your gaming prowess with E-items' premium selection of gaming goods and services.</p> <h3>Sell Your Game Assets Securely</h3> <p>Looking to sell your game assets? E-items provides a secure platform for selling your in-game items and characters. We understand the importance of a safe and trustworthy trading environment. Our robust security measures and strict verification processes ensure that every transaction is conducted securely and confidentially.</p> <p>List your game assets with confidence, knowing that E-items prioritizes the protection of your personal and financial information. Our dedicated team of moderators monitors the marketplace to prevent fraudulent activities, allowing you to sell your assets securely and efficiently.</p> <h3>Marketplace Features</h3> <p>At E-items, we pride ourselves on offering a feature-rich marketplace designed to enhance your gaming journey. Here are some key features that set us apart:</p> <ul> <li>Wide Range of Products: Our marketplace offers an extensive selection of gaming services and goods to meet all your needs and preferences.</li> <li>Professional Boosters: We collaborate only with experienced and professional boosters to ensure high-quality services.</li> <li>Competitive Prices: We provide competitive prices for all our products and services, allowing you to get the maximum value for your money.</li> <li>Secure Transactions: Our platform ensures the security of your transactions through advanced encryption technologies and data protection measures.</li> <li>Quality Guarantee: We guarantee high quality for all our products and services, ensuring that you receive nothing but the best.</li> <li>Ratings and Reviews: We have a rating and review system that helps you make informed decisions based on the experiences of other users.</li> <li>Customer Support: Our friendly customer support team is available 24/7 to assist you with any questions or issues you may have.</li> <li>Fast Delivery: We guarantee swift delivery of your purchased items or services, allowing you to start enjoying them as soon as possible.</li> <li>Flexible Payment Options: We offer various payment methods to ensure convenience and ease during the purchasing process.</li> </ul> <p>Join E-items today and unlock a world of gaming possibilities. Explore our vast selection of gaming goods and services, connect with like-minded gamers, and embark on a thrilling gaming journey. Trust E-items to deliver exceptional service, secure transactions, and unparalleled gaming experiences. Let us be your gateway to gaming success.</p> ";} 0 419 2 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en HP Text
122 11 0 126 3 A main 0 1 en Main Content
288 96 a:2:{s:5:"title";s:26:"Frequently asked questions";s:3:"faq";s:1:"1";} 0 341 3 A eitems_faq a:1:{s:8:"template";s:36:"addons/eitems_faq/blocks/default.tpl";} 0 1 en Faq HP
96 103 0 345 top-messages 3 A eitems_design_messages a:1:{s:8:"template";s:40:"addons/eitems_design/blocks/messages.tpl";} 0 1 en top messages
96 125 a:1:{s:4:"data";a:1:{s:7:"filling";s:7:"default";}} 0 440 top-messages 3 A eitems_privat_header_button a:1:{s:8:"template";s:45:"addons/eitems_privat/blocks/header_button.tpl";} 0 1 en top chats button
96 8 0 108 top-cart 4 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
95 89 0 313 categories-dropdown 4 D features a:2:{s:8:"template";s:28:"blocks/features/dropdown.tpl";s:8:"features";s:1:"2";} 0 1 en Categories dropdown
288 94 a:1:{s:7:"content";s:453:"<p><img src="http://ddd.eitems.gg/images/payments/applepay.png?1669558844513"><img src="http://ddd.eitems.gg/images/payments/googlepay.png?1669558857090"><img src="http://ddd.eitems.gg/images/payments/visa.png?1669558866606"><img src="http://ddd.eitems.gg/images/payments/mastercard.png?1669558875217"><img src="http://ddd.eitems.gg/images/payments/paypal.png?1669558883398"><img src="http://ddd.eitems.gg/images/payments/bitcoin.png?1669558891696"></p>";} 0 340 payment-icons 4 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 0 1 en Payment icons
122 100 a:1:{s:5:"items";a:2:{s:7:"filling";s:8:"manually";s:8:"item_ids";s:54:"34,43,60,61,69,78,85,95,96,101,104,113,119,120,124,131";}} 0 331 space-top homepage-games 4 A categories a:4:{s:8:"template";s:65:"addons/eitems_design/blocks/categories/custom_categories_grid.tpl";s:10:"show_title";s:1:"Y";s:25:"all_categories_link_title";s:17:"Explore all games";s:17:"number_of_columns";s:1:"4";} 0 1 en Popular Games
96 4 0 104 top-my-account 5 A my_account a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} 0 1 en My Account
95 7 0 107 top-search 5 D template a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} 0 1 en Search
119 23 a:1:{s:5:"items";a:3:{s:7:"filling";s:7:"on_sale";s:5:"limit";s:1:"8";s:3:"cid";s:0:"";}} 0 123 blocks/wrappers/mainbox_simple.tpl homepage-on-sale 5 A products a:4:{s:8:"template";s:41:"blocks/products/products_multicolumns.tpl";s:11:"item_number";s:1:"N";s:17:"number_of_columns";s:1:"4";s:23:"hide_add_to_cart_button";s:1:"Y";} 0 1 en Sale
95 106 0 348 top-search categories-dropdown 6 D eitems_design_search a:2:{s:8:"template";s:38:"addons/eitems_design/blocks/search.tpl";s:6:"filter";s:1:"1";} 0 1 en Search