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 'categories' 
  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 = 952 
  AND dynamic_object_content.object_type like 'categories' 
WHERE 
  cscart_bm_snapping.grid_id IN (
    1958, 1959, 1960, 1961, 1962, 1985, 1986, 
    1987, 2045, 2050, 1964, 2052, 1965, 
    2051, 2210, 1945, 1947, 1956, 1950, 
    1948, 1952, 1957, 1955, 1949, 1953, 
    1946, 1954, 2207
  ) 
  AND cscart_bm_blocks_descriptions.lang_code = 'se' 
  AND cscart_bm_blocks.company_id = 2 
ORDER BY 
  cscart_bm_snapping.order, 
  cscart_bm_snapping.block_id

Query time 0.00274

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_bm_snapping range grid_id grid_id 4 42 Using index condition; Using filesort
1 SIMPLE cscart_bm_block_statuses ref snapping_id snapping_id 4 mahm3t_cs443.cscart_bm_snapping.snapping_id 1 Using where
1 SIMPLE cscart_bm_blocks eq_ref PRIMARY PRIMARY 4 mahm3t_cs443.cscart_bm_snapping.block_id 1 Using where
1 SIMPLE cscart_bm_blocks_descriptions eq_ref PRIMARY PRIMARY 10 mahm3t_cs443.cscart_bm_snapping.block_id,const 1 Using index condition
1 SIMPLE default_content ref PRIMARY PRIMARY 18 mahm3t_cs443.cscart_bm_snapping.block_id,const,mahm3t_cs443.cscart_bm_blocks_descriptions.lang_code,const 1 Using where
1 SIMPLE dynamic_object_content ref PRIMARY PRIMARY 4 mahm3t_cs443.cscart_bm_snapping.block_id 5 Using where

Result

grid_id block_id content object_id object_type object_ids snapping_id wrapper user_class order status type properties company_id fpc_exclude_cache lang_code name
1962 18 a:1:{s:5:"items";a:2:{s:7:"filling";s:13:"full_tree_cat";s:18:"parent_category_id";s:0:"";}} 0 2484 0 D categories a:3:{s:8:"template";s:52:"blocks/categories/categories_dropdown_horizontal.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:2:"12";} 2 N se Top menu
1987 19 0 2522 blocks/wrappers/mainbox_general.tpl 0 A main 2 N se Main Content
1965 28 0 2491 blocks/wrappers/onclick_dropdown.tpl top-my-account 0 A my_account a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} 2 Y se Min profil
1964 53 0 2489 0 A languages a:4:{s:8:"template";s:20:"blocks/languages.tpl";s:4:"text";s:0:"";s:6:"format";s:4:"icon";s:14:"dropdown_limit";s:1:"1";} 2 N se Languages
1948 553 a:1:{s:7:"content";s:125:"<p><img alt="Paypal Verified" rel="margin-top: 5px;" src="/images/firma/paypal_verified.png" style="margin-top: 5px;" /></p> ";} 0 2472 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se paypal_verified
1946 573 a:1:{s:7:"content";s:390:"<div class="ty-social-link-block"><h3 class="ty-social-link__title">{__("get_social")}</h3> <div class="ty-social-link facebook"> <a href="https://web.facebook.com/byggbayse-1660927094194673"><i class="ty-icon-facebook"></i> Facebook</a> </div> <div class="ty-social-link twitter"> <a href="https://twitter.com"><i class="ty-icon-twitter"></i> Twitter</a> </div></div> ";} 0 2470 0 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 2 N se Social links
1952 574 0 2474 blocks/wrappers/footer_general.tpl 0 A template a:1:{s:8:"template";s:44:"blocks/static_templates/my_account_links.tpl";} 2 N se My account
1953 631 a:1:{s:7:"content";s:638:"<ul id="customer_service_links"> <li class="ty-footer-menu__item"><a href="{"wishlist.view"|fn_url}">Önskelistan</a></li> <li class="ty-footer-menu__item"><a href="{"product_features.compare"|fn_url}">Jämförelselista</a></li> <li class="ty-footer-menu__item"><a href="{"orders.search"|fn_url}">Din beställning</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=46"|fn_url}">Priser och leverans</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=45"|fn_url}">Kontakt</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=30"|fn_url}">Kontakta oss formen</a></li> </ul>";} 0 2475 blocks/wrappers/footer_general.tpl footer-no-wysiwyg 0 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 2 N se Customer service
1954 632 a:1:{s:7:"content";s:555:"<ul id="customer_service_links"> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=2"|fn_url}">Om oss</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=69"|fn_url}">Frakt- & Betalning</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=67"|fn_url}">Allmänna affärsvillkor</a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=68"|fn_url}">Ångerrätt </a></li> <li class="ty-footer-menu__item"><a href="{"pages.view?page_id=70"|fn_url}">Dataskyddsförklaring </a></li> </ul>";} 0 2476 blocks/wrappers/footer_general.tpl footer-no-wysiwyg 0 A smarty_block a:1:{s:8:"template";s:23:"blocks/smarty_block.tpl";} 2 N se Information
1960 633 0 2603 0 D call_request a:1:{s:8:"template";s:44:"addons/call_requests/blocks/call_request.tpl";} 2 N se Call request
1964 665 0 2490 0 A currencies a:4:{s:8:"template";s:21:"blocks/currencies.tpl";s:4:"text";s:0:"";s:6:"format";s:6:"symbol";s:14:"dropdown_limit";s:1:"0";} 2 N se Currencies
1957 681 a:1:{s:7:"content";s:116:"<img alt="SSL Certificate" src="/images/firma/comodo_secure_100x85_white.png" style="width: 100px; height: 85px;" />";} 0 2553 0 D html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Comodo Secure SSL
1956 779 a:1:{s:7:"content";s:442:"<!--Start of Tawk.to Script--><script type="text/javascript"> var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date(); (function(){ var s1=document.createElement("script"),s0=document.getElementsByTagName("script")[0]; s1.async=true; s1.src='https://embed.tawk.to/60522a86f7ce182709311fbb/1f10fc7q0'; s1.charset='UTF-8'; s1.setAttribute('crossorigin','*'); s0.parentNode.insertBefore(s1,s0); })(); </script><!--End of Tawk.to Script-->";} 0 2797 0 D html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se tawk.to
1947 797 a:1:{s:7:"content";s:104:"<p><img alt="byggbay.se Forbes Diamant" src="/images/firma/Diament_Forbes_2021_white_h125px.png"/></p> ";} 0 2825 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Forbes se
2210 799 a:1:{s:7:"content";s:1252:"<p style="text-align: center;"><span style="font-size:24px;">PayPal om byggbaY.se</span></p> <p style="text-align: center;"><span style="color: rgb(255, 0, 0); font-family: PayPal-Sans, sans-serif; font-size: 14.88px; text-align: center;">Ni har nöjda kunder, bra säljaromdömen på PayPal-konto och vi har de alla informationerna vi behöver för att skydda ditt konto.</span><br style="color: rgb(255, 0, 0); font-family: PayPal-Sans, sans-serif; font-size: 14.88px; text-align: center;" /> <span style="color: rgb(255, 0, 0); font-family: PayPal-Sans, sans-serif; font-size: 14.88px; text-align: center;">Det betyder att du har en bra försäljningshistorik på PayPal-konto. Fortsätta på detta sätt! </span></p> <p style="text-align: center;"><img alt="" src="https://d2d2yzufo5fwh3.cloudfront.net/images/firma/paypal_cart_se.PNG" style="width: 260px; height: 130px; margin: 5px 10px;" /><img alt="" src="https://d2d2yzufo5fwh3.cloudfront.net/images/firma/paypal_heart_se.PNG" style="width: 260px; height: 130px; margin: 5px 10px;" /><img alt="" src="https://d2d2yzufo5fwh3.cloudfront.net/images/firma/paypal_shield_se.PNG" style="width: 260px; height: 130px; margin: 5px 10px;" /></p> <div style="text-align: center;">&nbsp;</div> ";} 0 2830 0 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Paypal refferences se
1986 820 a:1:{s:5:"items";a:2:{s:7:"filling";s:22:"subcategories_tree_cat";s:7:"sort_by";s:8:"position";}} 0 2854 blocks/wrappers/sidebox_general.tpl 0 D categories a:1:{s:8:"template";s:43:"blocks/categories/categories_text_links.tpl";} 2 N se Kategorier
1985 26 0 2517 1 A breadcrumbs a:1:{s:8:"template";s:22:"common/breadcrumbs.tpl";} 2 N se Breadcrumbs
1957 105 0 2477 1 A payment_methods a:1:{s:8:"template";s:19:"blocks/payments.tpl";} 2 N se Payments
1986 647 a:1:{s:5:"items";a:2:{s:7:"filling";s:8:"manually";s:8:"item_ids";s:0:"";}} 0 2518 blocks/wrappers/sidebox_general.tpl 1 A product_filters a:1:{s:8:"template";s:35:"blocks/product_filters/original.tpl";} 2 N se Produktfilter
1987 782 a:1:{s:7:"content";s:10:"byggbaY.se";} 0 359,365,480,261,263,262,354,355,556,901,835,838,279,273,274,296,275,277,259,387,496,493,495,494,865,497 2809 1 D html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Category SEO text
1962 823 a:1:{s:4:"menu";s:1:"9";} 0 2857 1 A menu a:3:{s:8:"template";s:35:"blocks/menu/dropdown_horizontal.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"6";} 2 N se TOP menu SE
1958 16 0 2480 2 A template a:1:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";} 2 N se Logo
1956 24 0 2478 2 A template a:1:{s:8:"template";s:37:"blocks/static_templates/copyright.tpl";} 2 N se Copyright
2050 37 0 2598 2 A template a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} 2 N se Search
1959 37 0 2481 top-search 2 A template a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} 2 N se Search
1961 38 0 2483 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";} 2 Y se Cart content
1957 40 0 2479 2 D template a:1:{s:8:"template";s:41:"blocks/static_templates/payment_icons.tpl";} 2 N se Payment icons
1965 52 a:1:{s:4:"menu";s:1:"1";} 0 2492 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";} 2 N se Quick links
1949 199 a:1:{s:7:"content";s:460:"<!-- Beginn des Händlerbund HTML-Code --><!-- Der HTML-Code darf im Sinne der einwandfreien Funktionalität nicht verändert werden! --> <p> <a href="https://logo.haendlerbund.de/show.php?mid=13A688B85DE" target="_blank"> <img alt="Mitglied im Händlerbund" border="0" height="120" hspace="5" src="https://www.haendlerbund.de/images/mglogo/hbm120.png" title="Händlerbund Mitglied" vspace="5" width="120" /> </a> <!-- Ende des Händlerbund HTML-Code --></p> ";} 0 2471 2 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Haendlerbund
2207 583 a:1:{s:5:"items";a:4:{s:7:"filling";s:17:"blog.recent_posts";s:6:"period";s:1:"A";s:9:"last_days";s:3:"365";s:5:"limit";s:2:"50";}} 0 2808 blocks/wrappers/footer_general.tpl footer-no-wysiwyg 2 A blog a:1:{s:8:"template";s:35:"addons/blog/blocks/recent_posts.tpl";} 2 N se Blog
1986 666 a:1:{s:5:"items";a:2:{s:7:"filling";s:15:"recent_products";s:5:"limit";s:1:"5";}} 0 2519 blocks/wrappers/sidebox_general.tpl 2 A 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:"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:"1";s:15:"thumbnail_width";s:2:"80";s:18:"outside_navigation";s:1:"Y";s:23:"hide_add_to_cart_button";s:1:"Y";} 2 N se Nyligen visat
1962 815 a:1:{s:7:"content";s:163:"<p style="text-align: center;"><a href="https://www.byggbay.se/takfoenster/velux/"><img alt="" src="/images/companies/2/baner-velux-schon-ab-se-3.png" /></a></p> ";} 0 2849 2 A html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Baner
1986 28 0 2520 blocks/wrappers/sidebox_general.tpl 3 D my_account a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} 2 Y se Min profil
2051 38 0 2599 3 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";} 2 Y se Cart content
1962 816 a:1:{s:7:"content";s:1697:"<meta content="width=device-width, initial-scale=1" name="viewport" /> <style type="text/css">#demo { border: 1px grey dashed; background-color: #FFCC00; color: black; font-family: 'Open Sans',sans-serif; font-weight: bold; text-align: center; font-size: max(3vh, 18px); margin-top: 10px; } </style> <p id="demo">&nbsp;</p> <script> // Set the date we're counting down to var countDownDate = new Date("Mar 03, 2024 23:59:59").getTime(); // Update the count down every 1 second var x = setInterval(function() { // Get today's date and time var now = new Date().getTime(); // Find the distance between now and the count down date var distance = countDownDate - now; // Time calculations for days, hours, minutes and seconds var days = Math.floor(distance / (1000 * 60 * 60 * 24)); var hours = Math.floor((distance % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60)); var minutes = Math.floor((distance % (1000 * 60 * 60)) / (1000 * 60)); var seconds = Math.floor((distance % (1000 * 60)) / 1000); // Output the result in an element with id="demo" document.getElementById("demo").innerHTML = "VELUX takfönster upp till 10% billigare | från så lite som 2 606 € | " + "endast " + days + " dagar : " + hours + " t : " + minutes + " M : " + seconds + " s"; // If the count down is over, write some text if (distance < 0) { clearInterval(x); document.getElementById("demo").innerHTML = ""; } }, 1000); </script> <p style="text-align: center;"><a class="ty-btn ty-btn__primary" href="takfoenster/velux-takfoenster/takfoenster-velux/" rel="nofollow">Säkra upp till 10% rabatt nu</a></p> ";} 0 2850 3 D html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Promo
1962 700 a:1:{s:7:"content";s:1600:"<meta content="width=device-width, initial-scale=1" name="viewport" /> <style type="text/css">#demo { border: 1px grey dashed; background-color: #FFCC00; color: black; font-family: 'Open Sans',sans-serif; font-weight: bold; text-align: center; font-size: max(3vh, 18px); margin-top: 10px; } </style> <p id="demo">&nbsp;</p> <script> // Set the date we're counting down to var countDownDate = new Date("Nov 26, 2023 23:59:59").getTime(); // Update the count down every 1 second var x = setInterval(function() { // Get today's date and time var now = new Date().getTime(); // Find the distance between now and the count down date var distance = countDownDate - now; // Time calculations for days, hours, minutes and seconds var days = Math.floor(distance / (1000 * 60 * 60 * 24)); var hours = Math.floor((distance % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60)); var minutes = Math.floor((distance % (1000 * 60 * 60)) / (1000 * 60)); var seconds = Math.floor((distance % (1000 * 60)) / 1000); // Output the result in an element with id="demo" document.getElementById("demo").innerHTML = "Black Weekend | Spara 5% på allt | " + "bara " + days + " dagar : " + hours + " t : " + minutes + " m : " + seconds + " s" + " kvar"; // If the count down is over, write some text if (distance < 0) { clearInterval(x); document.getElementById("demo").innerHTML = ""; } }, 1000); </script> <p style="text-align: center;">Använd "<strong>black</strong>" kupongkoden i kundvagnen helt enkelt!</p> ";} 0 2567 4 D html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Slogan
1962 634 a:1:{s:7:"content";s:195:"<p><span style="font-size:18px;">Kära kunder,&nbsp;</span></p> <p><span style="font-size:18px;">Kundtjänst är inte tillgänglig idag. Onlinebeställningar fungerar som vanligt.</span></p> ";} 0 2485 addons/ecl_popup_wrapper/blocks/wrappers/popup_window.tpl 5 D html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} 2 N se Meddelande