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 = 378 
  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 = 378 
  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.00036

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
378	374	260/374/378	3	2	0	A	11	50	1348351200	0	N		N	0	N	0			default	0	N			en	Snow protection	<p>Home owners have a duty of care that includes, not only keeping traffic routes free of snow, but also preventing damage to people or property caused by so-called roof avalanches. They are therefore liable if falling chunks of snow or ice hit pedestrians or cars.</p> <p>So, in order to prevent the snow on the roof from sliding and falling off the roof, so-called snow guard systems are installed. These are either a grid or also a beam, which are installed close to the edge of the roof. They accumulate snow at the edge of the roof and also protect gutters from clogging, overflowing or even falling down.</p> <p>The most common are snow guards - these are basically small fences with a load capacity in the middle range, as well as snow guards with a high load capacity. The latter are used mainly in snowier areas and are also often arranged in several rows one above the other.</p> <p style="text-align: justify;">They are not required for every building. It depends on the location of the building, as well as on the snow conditions of the particular place. In Sweden, there are 8 snow load zones, from 1 to 5,5. In addition, the roof pitch plays a role, and whether the building is located, for example, directly on the street or separately in the middle of a large property.</p>	Snow protection system, Preventing snow from sliding down the roof, Protecting the gutters from breaking, Snow fence, Roofing accessories, For all roofing materials, Against sliding snow, To be attached to the roof	✔What is the snow protection system and why do you need it? ✔Want to know more >> Advice & Order info@byggbay.se ✔Buy easily and conveniently online	Snow fences and bulks \| snow protection \| byggbay.se			snow-protection-en	260/374