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 = 1889 
  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 = 1889 
  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.00067

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
1889	1888	1887/1888/1889	3	0	0	A	149	10	1626840000	N		N	0	N	0			default	0	1	N											0	en	Cord Hung Pendants	<span>Offering a wide range of styles, from rustic to vintage to contemporary, this collection of Cord Hung Pendants offers easy-to-customize fixtures for both residential and commercial spaces. In addition to shade size and finish options, an assortment of cording options allows you to add even more personality to your ceiling lights.</span>	<p><strong>What are cord hung lights and how are they used in homes and businesses?</strong></p> <p>Among the most ubiquitous mountings, cord hung lights deliver a timeless aesthetic to residential and commercial settings. To create this iconic look, a shade hangs from the ceiling with help from a stylish cord. By providing extra hints of character, cord hung lights are often emphasized as a room’s key decorative feature. Pendant lights can function as an eye-catching focal point or can assume a background role, blending in with and subtly elevating an existing look.</p> <p>Along with these aesthetic benefits, cord hung pendants can also perform more practical applications. As task lighting above kitchen islands, these fixtures provide the perfect touches of illumination for chopping vegetables and preparing family favorite recipes. In larger commercial venues, like office buildings and retail settings, hanging pendant lights supply general illumination, creating warm, welcoming spaces to work or shop.</p> <p><strong>What styles are available as cord hung lighting?</strong></p> <p>Due to their aesthetic versatility, cord lights can accommodate nearly every popular style of lighting. For a familiar profile, our signature line of RLM shades recalls the timeless look of barn lighting. With a variety of shapes, ranging from classic designs to sleek modern lines, RLM lights are easy to incorporate into already-established décors.</p> <p>Cord lights outfitted with schoolhouse globes contribute a sophisticated yet still casual look to a space. Hand-painted stripes, in several different patterns, supply color to cord hung schoolhouse lighting’s design.</p> <p>For a more industrial or nautical aesthetic, durable guards and wire cages provide a contemporary edge to homes and businesses. By protecting the bulb, these guards and cages prioritize functionality in their designs.</p> <p><strong>How are cord hung lights constructed and customized?</strong></p> <p>Adopting techniques from vintage manufacturers, our RLM shades start as flat pieces of commercial-grade aluminum or steel. The metal is spun at a high speed on a lathe and worked by hand into the shade’s shape. This process makes our RLM shades artisan quality and incredibly durable. With hand-applied finishes, guard options, and wire cages, these lights adapt to any space’s preferred style.</p> <p>Schoolhouse pendants are also customizable with hand-painted bands and various finishes for its mounting and canopy. Similarly, these vibrant finish colors can give nautical guard lights a more playful appearance.</p> <p>All ceiling pendants in this collection include one of several different cord styles. Black or white cords provide a simpler appearance while chevron patterns and other colorful options and texture and draw attention to the fixture.</p>	hanging cord lighting, cord hung lights	Shop vintage industrial to modern minimalistic hanging cord lights. Single & multi-pendant clusters, various finishes, and other cord hung lighting	Cord Pendant Lighting – Durable, Stylish Ceiling Fixtures		cord-hung-pendant-lighting	1889	c		1887/1888	cord-hung-pendant-lighting	1887/1888