SELECT 
  * 
FROM 
  cscart_bm_locations as l 
  LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id 
  AND d.lang_code = 'en' 
WHERE 
  l.layout_id = 2 
  AND l.dispatch = 'products.view' 
  AND (
    FIND_IN_SET(672, l.object_ids) 
    OR l.object_ids = ''
  ) 
ORDER BY 
  l.object_ids desc 
LIMIT 
  1

Query time 0.00030

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE l ALL 131 Using where; Using filesort
1 SIMPLE d eq_ref PRIMARY PRIMARY 10 mahm3t_cs443.l.location_id,const 1 Using where

Result

location_id dispatch is_default object_ids layout_id position custom_html lang_code name title meta_description meta_keywords
269 products.view 0 2 0 <!--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/1gthfi2pu'; s1.charset='UTF-8'; s1.setAttribute('crossorigin','*'); s0.parentNode.insertBefore(s1,s0); })(); </script> <!--End of Tawk.to Script--> <!-- Start of Tustami Script--> <script id="trustamiwidget" type="text/javascript" src="https://cdn.trustami.com/widgetapi/widget2/trustami-widget.js" data-profile="6136c90d2b5d85010d8b46ba" data-user="a4786dd9d18e9e0001efbbf33ff2a94d98f0d382" data-platform="0" async></script> <!-- End of Tustami Script--> en Products baubaY.de