SELECT 
  *, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_categories 
  LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id 
  AND cscart_category_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 983 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND cscart_seo_names.company_id = cscart_categories.company_id 
WHERE 
  cscart_categories.category_id = 983 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.company_id = 1

Query time 0.00069

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_categories const PRIMARY,c_status,p_category_id,idx_category_id PRIMARY 3 const 1
1 SIMPLE cscart_category_descriptions const PRIMARY PRIMARY 9 const,const 1
1 SIMPLE cscart_seo_names const PRIMARY,dispatch PRIMARY 210 const,const,const,const,const 1

Result

category_id parent_id id_path level company_id usergroup_ids status product_count position timestamp size_chart_id is_op localization age_verification age_limit parent_age_verification parent_age_limit selected_views default_view product_details_view product_columns is_trash staff_notes action lang_code category description meta_keywords meta_description page_title age_warning_message custom_header name object_id type dispatch path seo_name seo_path
983 897 412/897/983 3 1 0 A 5 220 1737586800 0 N N 0 N 0 default 0 N en Shutters <p>Shutters are a versatile solution that not only offers protection from sun and heat, but also provides additional thermal and acoustic insulation as well as increased security. They are mounted on the outside of the window and form an effective barrier against weather influences, noise and potential break-ins.</p> <p><strong>Advantages of shutters:</strong></p> <p>✅ <strong>Effective protection against heat:</strong> Reduce the heating of the room.<br /> ✅ <strong>Additional acoustic and thermal insulation:</strong> Damping outside noise and reduce heat loss in winter.<br /> ✅ <strong>Burglary protection:</strong> Offer additional protection against burglary.<br /> ✅ <strong>Complete blackout:</strong> Allow full control over the light in the room.<br /> ✅ <strong>Weather protection:</strong> Protect windows from rain, snow and wind.</p> <p><strong>When should you choose shutters?</strong></p> <ul> <li>If you want comprehensive protection from sun, heat, noise and burglary.</li> <li>If you want to completely darken the room.</li> <li>If you live in an area that is exposed to strong winds or weather conditions.</li> </ul> Shutters, window shutters, exterior shutters, security shutters, thermal insulation, acoustic insulation, sun protection, noise protection, burglary protection, weather protection Looking for comprehensive protection for your home? Shutters are the perfect solution. They offer protection from sun, noise, and burglary. External Shutters – Comprehensive Protection and Security for Your Home External Shutters – Comprehensive Protection and Security shutters 983 c 412/897 shutters 412/897