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 = 1894 
  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 = 1894 
  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.00051

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
1894 1888 1887/1888/1894 3 0 0 A 26 60 1626840000 N N 0 N 0 default 0 1 N 0 en Chandeliers <span>American-made chandeliers give your space an instant focal point! Hand-crafted with careful attention to detail, our assortment of chandeliers can be customized to suit both residential and commercial needs! From traditional barn and schoolhouse styles to modern, industrial, and nautical designs!</span> <p><strong>What are chandeliers?</strong></p> <p>Bold, dramatic, and eye-catching: chandeliers are included in residential and commercial spaces to make a statement. Unlike other mountings and styles of lights, chandeliers almost always incorporate multiple fixtures into their designs. With their visually striking aesthetics, chandelier lighting completely transform a space. Serving as the jumping off point for a décor, rooms can be entirely styled around a chandelier, or these ceiling lights can put the finishing touches on already established designs.</p> <p><strong>What are some common chandelier styles?</strong></p> <p>Although typically thought of as grand and elegant, chandeliers are offered in a diverse array of styles, ranging from casual and contemporary to more formal aesthetics.</p> <ul> <li><strong>Barn chandeliers</strong><span> </span>incorporate multiple RLM style shades for a relaxed, vintage-inspired look. These shades are often coated in porcelain — a manufacturing technique dating back to historic lighting companies. However, for a more sophisticated style, solid copper or brass are used in the shade’s construction.</li> <li>Taking design cues from factories and warehouses,<span> </span><strong>industrial chandeliers</strong><span> </span>incorporate rugged details to create an elevated contemporary style. To establish their unique character, these lights feature cast guards, wire cages, and other rustic flourishes. Galvanized finishes are commonly used to further amplify the industrial appearance, while bright and lively hues imbue these chandeliers with modern playfulness.</li> <li><strong>Schoolhouse chandeliers</strong><span> </span>affix multiple glass globe shades to a single mounting. First used in public buildings, schoolhouse style lights demonstrate a sophisticate style while still fitting in with relaxed contemporary décors.</li> <li><strong>Multi light chandeliers<span> </span></strong>or<span> </span><strong>pendant chandeliers<span> </span></strong>hang several fixtures from a single ceiling mounting. To let homeowners and professionals get creative, these individual pendants are adjustable to different lengths for truly unique and eye-catching displays.</li> <li><strong>Minimalist chandeliers:<span> </span></strong>These ceiling lights remove shades from their structure, and instead present a bare bulb look. Minimalist chandeliers subtly steal attention with lively finish colors, unique designs, and materials like copper and brass.</li> </ul> rustic chandeliers, schoolhouse chandeliers, industrial chandeliers,  Get the best-fitting chandelier for your home or business. Shop rustic chandeliers through schoolhouse, barn-style, or vintage industrial. Chandeliers - Vintage, Modern & Industrial Chandeliers chandeliers 1894 c 1887/1888 chandeliers 1887/1888