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 = 1888 
  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 = 1888 
  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.00048

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
1888	1887	1887/1888	2	0	0	A	0	20	1626840000	N		N	0	N	0			default	0	1	N											0	en	Ceiling Lighting	<span>Our collections of pendant lights contribute a memorable style to residential and commercial décors! Crafted entirely from high quality materials, these American made ceiling lights bring eye-catching functionality to businesses, kitchens, living spaces, and more!</span>	<p><strong>What is Pendant Lighting?</strong></p> <p>Common in homes and businesses, pendant lights suspend decorative shades from the ceiling to provide a space with practical sources of illumination and an elevated style. Thanks to their aesthetic versatility, ceiling pendant lights are capable of performing numerous functions within a décor. With their straightforward designs, many ceiling pendants heighten a décor as subtle accent pieces. Large pendant lights, groups of hanging ceiling lights, and two or three light pendants operate similarly to traditional chandeliers, becoming a room’s main focal point.</p> <p> <strong>Types of Pendant Light Fixtures</strong></p> <p>With endless styles, mountings, and other customization options, any room can receive its ideal look. Styled after vintage fixtures, RLM and barn pendant lights ground contemporary buildings and houses with a nostalgic aesthetic. More modern pendant lights incorporate sleek profiles and chic designs. Minimalist ceiling pendants remove the shades entirely from their structure, instead opting for the clean bare bulb look.</p> <p><strong>Mountings & Usage</strong></p> <p>Pendant lights are regularly included in both interior and exterior settings, and where they’re installed depends almost entirely on their mounting. With mounting options for every residential and commercial application, ceiling pendant lights are integrated throughout houses and buildings for a coherent, unified décor. The most common mountings are:</p> <ul> <li><a title="Cord Pendant Lighting" href="/lighting/ceiling-lights/cord-hung-pendant-lighting/">Cord Pendant Lighting</a>: Suspended from the ceiling with a cord, these ceiling pendants are routinely incorporated into kitchens, living spaces, and dining rooms, as well as the interiors of commercial buildings. While certain cord hung lights are rated for installation in damp settings — areas subject to moisture, but not direct contact with water — most of the time these lights are included in interior locations.</li> <li><a title="Stem Mount Lighting" href="/lighting/ceiling-lights/stem-mount-pendant-lighting/">Stem Mount Lighting</a>: With a rigid metal stem incorporated into their designs, these ceiling lights are typically installed in wet areas: porches, patios, and covered breezeways. However, the slightly more formal aesthetic imparted by the stem contributes subtle hints of industrial character above kitchen sinks, dining room tables, and throughout large commercial venues.</li> <li><a title="Chain Hung Lighting" href="/lighting/ceiling-lights/chain-hung-pendant-lighting/">Chain Hung Lighting</a>: Similar to the cord hung variety, these ceiling lights weave a cord through a decorative chain mounting. This imbues an industrial edge into the pendant’s design.</li> <li><a title="Flush Mount Ceiling Lighting" href="/lighting/ceiling-lights/flush-mount-lights/">Flush Mount Lighting</a>: Mounted closely to the ceiling, flush mount pendants deliver classic styles to spaces with limited spatial requirements. Typically, flush mount lights can be seen in entryways, hallways, and bathrooms.</li> </ul> <p>From kitchen ceiling lights to options for bathrooms and commercial use, pendant lighting help homeowners and professional designers achieve uniquely stylish décors. Along with these aesthetic benefits, the touches of illumination emitted by these fixtures help homes and businesses feel warm, welcoming, and comfortable.</p>		Shop vintage industrial to modern minimalistic hanging chain lights. Single & multi-pendant clusters, various finishes, and other chain hung lighting	Ceiling Lighting - Pendants & Light Fixtures		ceiling-lights	1888	c		1887	ceiling-lights	1887