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 = 1909 
  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 = 1909 
  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.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "table": {
      "table_name": "cscart_categories",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "c_status", "p_category_id"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["category_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_category_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["category_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "210",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "ref": ["const", "const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

category_id	parent_id	id_path	level	owner_id	usergroup_ids	status	product_count	position	timestamp	is_op	localization	age_verification	age_limit	parent_age_verification	parent_age_limit	selected_views	default_view	product_details_view	product_columns	company_id	is_trash	sidebar_r_bg	sidebar_r_title	sidebar_r_desc	sidebar_r_link	sidebar_r_link_text	sidebar_c_bg	sidebar_c_title	sidebar_c_desc	sidebar_c_link	sidebar_c_link_text	commercial_hidden	lang_code	category	description	ldescription	meta_keywords	meta_description	page_title	age_warning_message	name	object_id	type	dispatch	path	seo_name	seo_path
1909	1887	1887/1909	2	0	0	A	0	50	1626840000	N		N	0	N	0			default	0	1	N											0	en	Lamps	Barn Light Electric's collection of lamps offers every space a simple and instant makeover! Beautifully hand-crafted to imitate period-authentic fixtures, these portable table and floor lamps add a stylish touch of task lighting to every room. Available in porcelain enamel, powder coat, plus natural copper and brass finishes!	<p><strong>What is task lighting?</strong></p> <p>To provide illumination for paperwork, reading, homework, and other activities, task lighting directs light exactly where it’s needed. These lights are most commonly incorporated into a room as table, desk, and floor lamps. With their fashionable aesthetics, task lights often function as the decorative accessories every room requires to elevate its overall appearance.</p> <p>Because task lights are ubiquitous to nearly every home, they’re available in a diverse selection of styles. Adopting classic influences, certain floor and table lamps imitate timeless farmhouse, barn, and nautical looks. These lamps integrate traditional RLM shades into their designs to receive a familiar aesthetic. Other options embrace contemporary lines and the latest trends to help rooms feel modern and relevant.</p> <p>With fully customizable task lighting and a sincere commitment to craftsmanship, Barn Light Electric manufactures lamps that are sure to become long term features of living spaces, bedrooms, and offices.</p> <p><strong>Types of Task Lights</strong></p> <ul> <li><strong>Desk Lamps:</strong><span> </span>With their adjustable shades and focused light, these lamps make doing paperwork and studying easier and more comfortable. Along with this practical purpose, a stylish desk light provides home and commercial offices with an elevated aesthetic.</li> <li><strong>Table Lamps:</strong><span> </span>While these lamps offer task lighting for reading on the couch or in bed, they also bring additional brightness to living spaces and bedrooms. As a room’s sole source of light at night, table lamps provide the soft ambiance that makes a space feel cozy.</li> <li><strong>Floor Lamps:<span> </span></strong>Often assume similar looks and functions to table lamps, but with larger, more substantial profiles. Floor lamps contribute stylish accent pieces to elevate a room’s character.</li> </ul> <p>All task lamps manufactured by Barn Light Electric include high quality metal and are constructed by hand. Weighted bases are used to prevent tipping and provide the lamps with sturdy foundations.</p> <p><strong>Rooms and Usage</strong></p> <ul> <li>Living Rooms</li> <li>Bedrooms</li> <li>Home Offices and Commercial Office Spaces</li> <li>Craft Rooms</li> </ul>	table lamps, desk lamps, floor lamps, standing lamps,	Big style in a portable package, our desk and table lamps show off classic styles and quality construction. Hand-crafted in the USA and fully customizable.	Table, Desk and Floor Standing Lights \| Barn Light Electric		lamps	1909	c		1887	lamps	1887