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 = 1897 
  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 = 1897 
  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.00052

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
1897	1896	1887/1896/1897	3	0	0	A	51	10	1626840000	N		N	0	N	0			default	0	1	N											0	en	Gooseneck Lights	<span>Iconic styles with roots in historic RLM designs, our gooseneck barn lights are hand-crafted from the highest quality materials. Fitted to interior or exterior walls, gooseneck lighting adds a functional style to residential spaces while withstanding the rigors of commercial applications.</span>	<p><strong>What is Gooseneck Lighting?</strong></p> <p>First made popular in the mid-1900s, gooseneck light fixtures are an iconic turn-of-the-century style of wall lighting. Known for the bent, swooping shape of their arms, gooseneck lights provide a unique vintage look reminiscent of the fixtures found on classic farmhouses and barns.</p> <p>Their timeless appeal has sparked a revival in modern designs for both home and commercial use. With a look and function slightly different from traditional wall sconces, the long gooseneck arm extends the light away from the building, providing a unique aesthetic and a wide spread of light. Historically used to illuminate large barn doors and entryways to workshops, many contemporary gooseneck lights are used to elevate the curb appeal of homes and businesses, along with additional interior applications.</p> <p><strong>Types of Gooseneck Light fixtures</strong></p> <p>Gooseneck fixtures and light shades are offered with various mounting options, sizes, and finishes. To appeal to décor sensibilities ranging from vintage to modern, typical finishes replicate the look of galvanized metal and include various colors of powder coat. Shades vary in width, height, color, and finish to match or contrast with the gooseneck arm, depending on individual preferences.</p> <p>With hundreds of styles and customization options, you can mix and match the height, style, and material finish to match any interior or exterior design. Choose traditional incandescent or LED light options.</p> <p><strong>Rooms & Usage</strong></p> <p>Most gooseneck light fixtures are placed outside on homes, while storefronts and restaurants often use them for both interior and exterior lighting. Because of the resilient metal material and finishes, they can weather the elements in exterior use.</p> <p>Gooseneck lights are most commonly found outside of the house, adorning barns, garages, and the entryways into the house. However, many designers include gooseneck lighting in interior applications. Common placements include: </p> <ul> <li>Front porches</li> <li>On garages</li> <li>Kitchens</li> <li>Mud rooms</li> <li>Bathroom vanities </li> </ul> <p>Because of the long, curved nature of the gooseneck arm, these lights can illuminate signs or shine at angles that standard ceiling pendants or wall lights cannot achieve. Be sure to shop of the best angle for your specific application, in or around your commercial space.</p>	gooseneck lighting, gooseneck lights, goose neck,	One-of-a-kind shape, our gooseneck light fixtures offer charm and character to your home or business, inside or outdoors. Shop this barn-inspired light.	Gooseneck Lighting - Classic Gooseneck Arms & Fixtures		gooseneck-lights	1897	c		1887/1896	gooseneck-lights	1887/1896