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 = 1926 
  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 = 1926 
  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.00066

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
1926 1921 1920/1921/1926 3 0 0 A 34 50 1626840000 N N 0 N 0 default 0 1 N 0 en High Lumen <span data-contrast="none" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW116779832 BCX0"><span class="NormalTextRun SCXW116779832 BCX0">Engineered with performance and efficiency in mind, this assortment of high-lumen LED lighting is intended for large, open spaces. To produce the extremely bright light necessary for these areas, these fixtures integrate powerful LED components into their designs. With these fixtures, you can select the proper lumen option and color temperature for your exact setting.</span></span><span class="EOP SCXW116779832 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}"> </span> high lumens LED lighting, high lumen vintage lighting, high lumen mid-century lighting, light fixtures high lumens These powerful, high lumen LED lighting fixtures will satisfy any vintage loving decor! Highlight your space with high-lumen fixtures! High Lumen Lighting | Barn Light Electric high-lumen-lights 1926 c 1920/1921 high-lumen-lights 1920/1921