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 = 421 
  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 = 421 
  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.00041

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
421 415 415/421 2 1 0 A 0 10 1339279200 0 N N 0 N 0 default 0 N en Facade, ETICS <h2>What is ETICS system? It's the External Thermal Insulation Composite System.</h2> <p style="text-align: justify;">It is a complete, ready-to-use system of thermal insulation products applied on exterior walls. It provides house insulate-finished surface and waterproofing. It consists of insulation boards, adhesive, reinforcement mesh, fixining pins,&nbsp; primer and thin-coat render. Of course there are a lot of facade insulation products and their choice should be dictated by bollowing criteria: biulding location and it's surrounding, apllication's time and temperature, economic criteria, expected facade design and color.</p> <p style="text-align: center;"><img alt="Insulation materials" src="https://d2d2yzufo5fwh3.cloudfront.net/images/products/eps_to/etics_layers.PNG" style="height: 252px; width: 800px;" title="What does ETICS consist of" /></p> <h2>Benefits of ETICS:</h2> <ul style="text-align: justify;"> <li>reduces heat loss and heating costs, reduces thermal bridges</li> <li>improves acoustic insulation of walls</li> <li>protects walls from water / moisture</li> <li>durable and damage resistant</li> <li>for insulation of standard, passive and energy efficient buildings</li> <li>complete set with proven complatibility</li> <li>insulation upon buildings up to 25 m high</li> <li>thermal insulation thickness even up to 250 mm</li> </ul> insulation, passive house, warm house, wall insulation, facade paint, facade render, facade insulation, waterproofing, damage resistance, EPS, XPS, mineral wool, PIR ✓wall insulation ✓EPS, XPS, PIR, mineral wool ✓warm house ✓energy efficient house ✓damage proof ✓water proof ✓no thermal bridges ✓400 colors of renders and facade paints ✓many renders and paint to choose ETICS | External Thermal Insulation Composite System facade-etics 415