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 = 415 
  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 = 415 
  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.00045

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
415 0 415 1 1 0 A 0 40 1337983200 0 N N 0 N 0 default 0 N en Insulation <h2>How to insulate a house?</h2> <p style="text-align: justify;">House insulation in general is made during a renovation or while construction. It reduces the heat losses in winter, prevents from cold air, but also prevents from overheating of the house during the summer.&nbsp; What areas should be insulated? Of course exterior walls, but also floor, foundation, roof, partition walls, ceiling - all the weak points, where is threat of cold air getting in. On the market there are a lot of brands, that offer insulation products. We decided to offer proven quality products, from Polish manufacturers. You can choose between EPS, XPS, PIR boards or mineral wool. Of course should be noted, that each product should be chosen carefully due to it's properties and destination. For wall insulation it is λ (thermal conductivity) value important - the lower, the better. It tells how warm your house will be thanks to it. For floor or parking insulation compressive stress value is important - the higher, the better. This value tells how heavy load EPS board will handle.</p> <p style="text-align: justify;">Wide range of renders - from mineral ones to silicone-silicate renders together with facade paints allow to secure your walls insulation layer, but also will give your home elegant look. 400 colors to choose allow to create unique facade design.</p> <p style="text-align: justify;">To each type of insulation there are dedicated different mounting products - glue, pins, fibre glass net, primers. We offer all of them to complete your insulation system. Please find below our offer:</p> ETICS, EPS, XPS,mineral wool, render, facade, facade paint, roof insulation, wall insulation, foundation insulation, Polystyrene boards, adhesive, fscade glue, PIR boards, mineral render, hybrid render, silicone render, silicate render, silicone paint ✓insulation system ✓ETiCS ✓floor insulation ✓wall insulation ✓roof insulation ✓foundation insulation ✓EPS ✓XPS ✓mineral wool ✓low thermal conductivity ✓warm house ✓high compressive stress ✓PIR boards Insulation of walls, ceilings, roof, floor | baubay.de insulation