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 = 1575 
  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 = 1575 
  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.00059

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
1575	1571	1571/1575	2	0	0	A	65	50	1505188800	N		N	0	N	0			default	0	1	N											0	en	Bulb Replacements	<div style="text-align: left;">No matter what barn light you choose, the light bulb puts the finishing touch on any look! Our collection includes a wide variety from decorative half-chrome and Edison Style Light Bulbs to eco-friendly halogen and LED bulbs.</div>	<div style="text-align: left;"> <p><strong>Why light bulbs matter in a décor.</strong></p> <p>Light bulbs are usually an afterthought when shopping for lighting fixtures, but they are incredibly important to establishing a room’s overall mood. While most people are familiar with incandescent bulbs, there are numerous fashionable and high-performance options you may not be familiar with.</p> <p><strong>What are Edison Bulbs? </strong></p> <p>Warm, nostalgic, and decorative — lately it seems as if Edison Bulbs are everywhere. This is largely due to their near-universal aesthetic appeal. By invoking the designs first developed by Thomas Edison, the style’s namesake, these bulbs foster a traditional character in modern settings without feeling archaic. Despite originating generations ago, these antique light bulbs complement the mindsets and design principles used to decorate contemporary homes and businesses.</p> <p>Modern reproduction Edison bulbs embrace the same oblong shape and visible curled filament associated with the originals; filament options include squirrel cage, hairpin, loop, and spiral. Other vintage light bulb styles consist of elongated tube-shaped bulbs, Victorian bulbs, and round ball-shaped globe bulbs. Because of their eye-catching aesthetics, these bulbs are often shown off in bare bulb lighting and in fixtures with minimalist cages.</p> <p><strong>What makes Edison Bulbs so popular? And what are they used for?</strong></p> <p>Edison Bulbs have a lower lumen output than many other bulb styles, so they produce warmer, softer illumination. This imbues a room with ambiance and atmosphere. With their traditional, eye-catching shapes, Nostalgic Edison Bulbs often serve as accent pieces within a décor. The historic nature of these bulbs complements the industrial and minimalist styles that are common in contemporary businesses. Businesses like trendy coffee shops, breweries, mixology bars, and restaurants incorporate Edison bulbs to create a relaxed, casual mood for their customers.</p> <p><strong>Are Edison Bulbs available in LED?</strong></p> <p>Yes, Edison Light Bulbs are available in LED. These bulbs adopt the expected Edison-style but produce illumination with high-performance, extremely efficient technology. Available in a wide range of timeless looks, the LED Edison bulbs we carry produce an average of 30,000 hours of light, offer several lumen options, and feature multiple color temperatures.</p> <p><strong>What are half-chrome light bulbs?</strong></p> <p>For fixtures that leave their bulbs exposed, the bottoms of half-chrome light bulbs are finished with a shiny silver layer to prevent glare. In RLM shades, half-chrome bulbs reflect light back to the shade for a more even distribution. Regularly used in bare bulb pendants and sconces, this option tends to be easier on the eyes than more traditional incandescent bulbs.</p> <p><strong>What are some practical, efficient, and utilitarian light bulb options?</strong></p> <p>Incandescent bulbs are among the most common and affordable options. Other bulbs are designed to be more energy efficient. Compact fluorescent, also referred to as CFLs, require less electricity and offer a longer lifespan than more traditional forms of lighting. However, these bulbs are best used indoors, and in applications where they function as more ambient lighting. With their bright light and energy efficiency, halogen bulbs are perfect for outdoor flood lights and display lighting. </p> </div>	light bulbs, edison light bulbs,	Wide variety of light bulbs, from nostalgic Edison to energy efficient CFL! Put the finishing touch on your light with a stylish light bulb.	Light Bulbs - LED, Edison-style, Incandescent, Fluorescent		light-bulbs	1575	c		1571	light-bulbs	1571