Sandbox

SELECT 
  *, 
  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 = 982 
  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 = 982 
  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.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	name	object_id	type	dispatch	path	seo_name	seo_path
982	897	412/897/982	3	1	0	A	15	210	1737586800	0	N		N	0	N	0			default	0	N			en	Awning blinds	<p>Awning blinds are the ideal solution for those looking for the most effective protection against heating the attic. They are mounted on the outside of the window and the pulled-down mesh reflects a large part of the sun's rays - before they reach the glass, because this is ultimately what heats the rooms. This can lower the temperature in the attic by several degrees Celsius on hot days.</p> <p><strong>Advantages of awning blinds:</strong></p> <p>✅ <strong>Highest effectiveness in protecting against heat:</strong> Reduce the heating of the room up to several times more effectively than interior roller blinds.<br /> ✅ <strong>Protection against UV radiation:</strong> Protect furniture and fabrics from fading.<br /> ✅ <strong>Energy saving:</strong> Reduce the need for air conditioning.<br /> ✅ <strong>Do not limit the view:</strong> Unlike external roller shutters, they do not completely darken the room.</p> <p><strong>When should you choose awning blinds?</strong></p> <ul> <li>When the highest protection against heat is a priority.</li> <li>If you want to maintain a comfortable temperature in the attic without air conditioning.</li> <li>If you do not want to completely darken the room.</li> </ul>	Awning blinds, roof window awning blinds, external blinds, sun protection, heat protection, UV protection, attic	Looking for the most effective protection against heat? Awning blinds are the perfect solution. They provide shade and comfort on hot days.	Awning blinds – Best Heat Protection		Awnings – The Most Effective Protection Against Heat	awning	982	c		412/897	awning	412/897