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 = 838 
  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 = 838 
  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 = 2

Query time 0.00072

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
838 281 281/838 2 2 0 A 8 50 1457564400 0 N N 0 N 0 default 0 N en Shutters <p>As a suplementary accessory to facade windows we offer exterior shutters both, manual operated and electric powered.&nbsp; They will give you home-privacy, and as well make the house more safe. Such shutters makes harder breaking in to your home. Many colors and designes allow to fit the shutter perfectly to your house. There are few types of external shutters - front mounted with various box shapes, top mounted, where the box is completely hidden and all you see is a&nbsp; curtain, shutters with additional box insulation, or with mosquito net. We offer tailor made shutters - perfectly fitting to your windows. Write us an inquiry and we will send back the offer.</p> We offer external shutters mounted on the facade and top mounted. Perfect for new houses, but also for renovation buildings. They ensure privacy, light control and safety. Perfect fitting to the window's dimensions. Contact us to get the offer. External shutters for facade windows | byggbay.se shutters 838 c 281 shutters 281