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 = 1898 
  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 = 1898 
  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.00053

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
1898	1896	1887/1896/1898	3	0	0	A	11	20	1626840000	N		N	0	N	0			default	0	1	N											0	en	Sign Lights	<p>Hand-crafted sign lighting inspired by early 20th century farm lights. Easy to customize with shade style, finish color, and gooseneck arm options, these sign lights bring both character and illumination to storefronts and other commercial spaces, as well as to residential settings.</p>	<p><strong>What is Sign Lighting?</strong></p> <p>With the goal of illuminating outdoor signs at gas stations, grocery stores, and other businesses, traditional sign lighting originated in the early 20<sup>th</sup><span> </span>century. To brighten these surfaces, sign lights mount rounded angle shades to curved gooseneck arms. By incorporating numerous angles and options for the gooseneck arm, sign lights deliver the perfect amount of light exactly where it’s needed. This establishes a brighter, more welcoming outdoor environment and helps a business’s sign and logo stand out at night.</p> <p>Although first created for practical purposes, their timeless aesthetic has made sign lights a favorite for modern commercial buildings. Business owners and designers who desire extra touches of character in their outdoor spaces incorporate these lights as decorative alternatives to more utilitarian sign options.</p> <p>As use of sign lighting remains popular, new designs have emerged to reflect the latest technological advances. To increase their functionality, these commercial sign lights integrate hyper-efficient LED drivers, establishing some of the most versatile contemporary fixtures available.</p> <p><strong>Uses for Sign Lights</strong></p> <p>Most sign lights are rated for installation in both interior and exterior settings. While these fixtures are still used to accentuate signs, creative business owners and designers, along with some homeowners, have discovered numerous alternative applications for sign lights.</p> <p><strong>Common Outdoor Applications for Sign Lights</strong></p> <ul> <li>Illuminating decorative awnings and walls</li> <li>Accentuating outdoor murals and other unique design features</li> <li>In residential settings, brightening address signs and numbers</li> <li>And brightening signs, logos, and other corporate markings</li> </ul> <p><strong>Interior Sign Lighting Applications</strong></p> <ul> <li>Highlighting menu boards in restaurants, bars, bakeries, and coffee shops</li> <li>Drawing attention to products on the shelves in retail settings</li> <li>Emphasizing artwork, indoor murals, and other design features</li> </ul> <p>While other more utilitarian sources of light fulfill a similar function, sign lights provide the extra aesthetic details and character needed for an elevated curb appeal. With endless combinations of finish colors, arm styles, and other customization accessories, commercial buildings can easily integrate fashionable sign lights into their interior and exterior spaces.</p>	sign lighting, signage lights, shop lights	Add the finishing touches to your shop, business or house's street numbers with vintage sign lighting. Shop gooseneck or wall-mount sign lights & fixtures.	Sign Lighting - Indoor & Exterior Sign Light Fixtures		sign-lights	1898	c		1887/1896	sign-lights	1887/1896