SELECT 
  cscart_categories.*, 
  cscart_category_descriptions.*, 
  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 = 259 
  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 = 259 
  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.00074

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 seo_name seo_path
259 386 386/259 2 2 0 A 0 10 1337983200 0 N N 0 N 0 default 0 N en Drywall & Ceiling Systems <p style="text-align: center;"><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/ABGd6B0v9go" title="YouTube video player" width="560"></iframe></p> <p style="text-align: justify;">What's the fastest way of building internal walls / partitions? Of course pllasterboards installed on the profiles. We offer the standard GKB boards, but also water resistant and fire proof ones - all of them in most common lengths - 200 cm and 260 cm. Plaserboards can be applied on the walls but also on ceilings. Special construction made of alu-profiles allow to create any combinations. Additional products such as drywall screws, gypsum products to make the boards' surface even and wall paints will help to obtain the final desirable shape of a room.</p> GKB, OSB, screws, plasterboards, gypsum adhesive, selfdrilling screws, interior paints, white paint, sound proof mineral wool, GKB profiles, partitions, ceiling, partition profiles ✓GKB boards - standard, waterproof, fire proof ✓260 and 200 cm of lenth ✓for partition walls and ceilings ✓OSB boards - for walls, ceilings, partitions, load-bearing wall, flooring base, stands, racks, fences ✓profiles for GKB ✓screws✓gypsum ✓paints Drywall & Ceiling Systems | byggbay.se drywall-en 386