Sandbox

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 = 442 
  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 = 442 
  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.00044

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows
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
442	434	414/434/442	3	1	0	A	14	10	1347746400	0	N		N	0	N	0			default	0	N			en	Roof underlays	<p>Underlayments, also called roof foil, roof membrane or sarking membrane, are a modern product used mainly in roof construction. They form the layer between the roofing and the insulation layer of the roof. In this regard, especially 2 points are very important. Especially in the shell construction phase, these foils must keep the underlying construction dry. This means that such foils must be rainproof, and at least tested for resistance to water penetration of class W1. This class serves its purpose in normal weather conditions. In addition, since roofs are already insulated but not covered for a long period of time, a certain UV resistance of this membrane is absolutely necessary. If the roof tiles are laid later, this point is no longer so important, because the film is no longer directly exposed to UV radiation.<br /> <br /> The second point is the permeability of water vapor, it is also called diffusion openness. The underlay is on the outside, so any water vapor must be able to escape from the inside to the outside. The so-called Sd value serves as a measure of this permeability. The lower this value, the more permeable the film is to water vapor.</p> <p>Even after the shell construction phase, the roof foils are an important protection against water from the outside. Be it from rain that is pushed under the roofing with the wind, or be it when individual tiles break and there is a hole in the roofing until they are replaced. Standing water can also occur when the snow melts, if the ice and snow on the roof do not thaw evenly. Here, too, the underlayment performs its important service of keeping the roof watertight and preventing entry into the insulation layer.</p>	A roofing membrane, Replaces roofing felt, Placed under the roof, Protects the attic, Diffusion properties, Insulation layer against moisture, High vapor permeability, Can be placed directly on a full boarding.	✔A roofing membrane as an advanced product protects your roof from moisture ✔Buy easily and conveniently online ✔Want to know more >> Advice & Order info@baubay.de	Roof underlays \| byggbay.se			roof-underlays	414/434