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 = 1892 
  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 = 1892 
  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.00056

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
1892	1888	1887/1888/1892	3	0	0	A	55	40	1626840000	N		N	0	N	0			default	0	1	N											0	en	Flush Mounts	<span>Thanks to their undersized profiles, our fashionable flush mount lights deliver ample illumination and an eye-catching style to the smaller areas of homes and businesses! Available with an abundance of finish options and shade styles, these lights can adopt truly unique looks. Fully customizable, entirely hand-crafted, and indescribably stylish!</span>	<p><strong>What is flush mount lighting?</strong></p> <p>To adopt space-saving profiles, flush mount lights remove long cords and stems from their designs. Instead, they mount their shades directly to the ceiling. This lets every space, regardless of size, embrace a truly original aesthetic.</p> <p><strong>How about</strong><span> </span><strong>semi-flush mount lights?</strong></p> <p>Semi-flush fixtures still provide the undersized dimensions and proportions required by smaller settings. However, unlike the more standard options, semi-flush pendants slightly suspend their shades from the ceiling.</p> <p><strong>Where is flush mount lighting typically installed?</strong></p> <p>Flush mount lights address the challenges of decorating and illuminating diminutive rooms, narrow hallways, and other settings with small footprints and low ceilings. These areas are often unable to accommodate longer<span> </span><a title="Stem Mount Lighting " href="/lighting/ceiling-lights/stem-mount-pendant-lighting/">stem</a>,<span> </span><a title="Cord Pendant Lighting" href="/lighting/ceiling-lights/cord-hung-pendant-lighting/">cord</a>, or <a title="Chain Hung Lighting" href="/lighting/ceiling-lights/chain-hung-pendant-lighting/">chain</a><span> </span>mounted pendants, which can limit the number of available styles.</p> <p>To illuminate these areas, many homeowners install plain, strictly utilitarian lighting fixtures that brighten the space but lack a distinguishing character. This can leave a room feeling unappreciated and disconnected from the rest of the home or business’s décor.</p> <p>However, professional designers understand how valuable stylish lighting is in making these spaces appear “lived-in” and welcoming. Luckily, there’s numerous flush mount lights that embrace the latest trends while still suiting the limited scale of the space.</p> <p>For lighting’s more practical responsibilities, flush mounts function as primary illumination in small rooms.</p> <p>In residential settings, these lights can be found in:</p> <ul> <li>Entryways</li> <li>Hallways</li> <li>Powder rooms</li> <li>Laundry rooms</li> <li>Mudrooms</li> <li>Porches</li> </ul> <p>Commercial spaces also incorporate flush mount lights. They’re frequently installed in:</p> <ul> <li>Entryways in restaurants, breweries, and bars</li> <li>As primary lighting for small boutique stores</li> <li>In historic downtown districts with low ceilings</li> </ul> <p><strong>What styles of flush mount lights are available?</strong></p> <p>Nearly every lighting and shade style can incorporate this versatile mounting. That includes:</p> <ul> <li>RLM Shades</li> <li>Nautical Lighting</li> <li>Schoolhouse Globes</li> <li>Contemporary Designs</li> <li>Industrial Fixtures</li> </ul> <p>By featuring today’s most prevalent trends, along with more traditional options, flush mount lights help homes and businesses express uniquely fashionable looks. These various lighting designs establish a uniform aesthetic throughout a property, letting it feel thoughtfully decorated and elevated. </p>	flush mounted vintage light fixtures, flush mounted lights, lighting fixtures, flush mount fixture for lights	Vintage lighting for the smaller spaces of homes or businesses! Our unique flush mount lighting is entirely hand-crafted in America and fully customizable!	Flush Mount Lighting – Compact Lighting Options		flush-mount-lights	1892	c		1887/1888	flush-mount-lights	1887/1888