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 = 372 
  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 = 372 
  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.00034

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
372 280 257/280/372 3 2 0 A 19 20 1346536800 0 N N 0 N 0 default 0 N en Adhesives for tiles <h2>Adhesives for tiles are classified and labelled in accordance to PN-EN 12004+A1:2012 standard. The standard lists 3 types of adhesives:</h2> <ul> <li>C – cement adhesives</li> <li>D – dispersion adhesives</li> <li>R – adhesives based on reactive resins</li> </ul> <h2>Each of three types of adhesives can be offered in various types (classes), referring to additional requirements:</h2> <ul> <li>1 – standard setting adhesives; adhesion after 28 days ≥ 0.5 N/mm2</li> <li>2 – adhesives of improved parameters; adhesion after 28 days ≥ 1.0 N/mm2</li> <li>F – fast-setting adhesives; adhesion after 6 hours ≥ 0.5 N/mm2</li> <li>T – adhesives with reduced slip; slip not exceeding 0.5 mm</li> <li>E – adhesives with extended open time; adhesion after 28 days ≥ 0.5 N / mm2, despite the fact that time between application of adhesive and placing a tile is not longer than 30 minutes</li> <li>S1: Deformable (deformity of ≥ 2.5mm to ≤ 5mm)</li> <li>S2: Highly Deformable (deformity of ≥ 5mm)</li> </ul> <h2>Before fixing ceramic or natural stone cladding, one should pay particular attention to a few elements significant for proper selection of an adhesive.They are as follows:</h2> <ul> <li><strong>substrate </strong>– material which it is made of, its absorptiveness, bonding, cleanliness, stabilization degree and possible deformability,</li> <li><strong>tiles – type</strong> (gres-porcelain, terracotta, glazed, stone), size (mosaic, large size), absorptiveness and resistance to discolouration,</li> <li><strong>conditions of cladding use </strong>– influence of atmospheric factors (indoors or outdoors), location (wall or floor), type and range of live load (foot or vehicle traffic), frequency and range of temperature changes.</li> </ul> ✓Highly flexible tile adhesives ✓elastic adhesives ✓deformable adhesives ✓fastbonding adhesives ✓for each type of surface ✓also for very large sizes of tiles ✓extra hold ✓check it now! Large range of tile adhesives | byggbay.se adhesives-for-teils 257/280