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 = 10 
  AND l.dispatch = 'categories.view' 
  AND (
    FIND_IN_SET(838, l.object_ids) 
    OR l.object_ids = ''
  ) 
ORDER BY 
  l.object_ids desc 
LIMIT 
  1

Query time 0.00032

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
427 categories.view 0 10 0 <!-- Global site tag (gtag.js) - Google Analytics --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-18YZPBYDFY" data-no-defer></script> <script data-no-defer> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-18YZPBYDFY'); </script> en Categories byggbaY.se