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 = 15056 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_categories.category_id = 15056 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  )

Query time 0.00007

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "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": "ref",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "206",
          "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
          "ref": ["const", "const", "const", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_seo_names.`type` = 'c' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
        }
      }
    ]
  }
}

Result

category_id parent_id id_path level company_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 is_trash is_default category_type ab__fn_category_status ab__fn_label_color ab__fn_label_background ab__fn_use_origin_image ab__lc_catalog_image_control ab__lc_landing ab__lc_subsubcategories ab__lc_menu_id ab__lc_how_to_use_menu ab__lc_inherit_control category_code xml_external_category_id storefront_id default_view_desktop default_view_tablet default_view_mobile lang_code category description meta_keywords meta_description page_title age_warning_message ab__fn_label_text ab__fn_label_show name object_id type dispatch path seo_name seo_path
15056 15001 28/15001/15056 3 0 0 A 0 120 1614084759 N N 0 N 0 default 0 N N C Y #ffffff #333333 N none N 0 0 N N 15056 1 en Cat Furniture Choosing the right cat scratching tree for your cat can be difficult and overwhelming. But luckily the many different kinds of scratching trees available make it easy to accommodate your cat’s individual needs. By just considering a few of your cat’s habits and preferences, you can find the perfect scratching tree to suit your cat. To find the right scratching tree, you will need to consider your cat’s scratching preferences, its safety needs, and what accessories will keep your cat active, healthy, and entertained. Note the material that appeals to your cat. Depending on whether your cat has spent more time indoors or more time outdoors, they may prefer certain materials over others. Take notice of what they are naturally attracted to scratching. Depending on their surroundings, cats may prefer to scratch wood, fabric, carpet, or rope. Choose wood if your cat spends time outdoors. If your cat is mostly accustomed to spending time outside, they may prefer a wood material that reminds them of a stump or tree. You can buy a scratching tree made out of natural logs. Choose between a horizontal or vertical scratching post. If your cat usually scratches rugs or carpets, a horizontal post may work the best. If you notice that your cat scratches furniture legs or wallpaper, pick a vertical post so your cat can mimic the behavior. Cat Furniture, Cat Supplies Find great variaty of Cat Furniture at www.ebonza.eu. Buy litters, box liners, box mats, toys and treats for your pet! Cat Furniture | eBonza Marketplace Y pet-supplies-cat-supplies-cat-furniture 15056 c 28/15001 pet-supplies-cat-supplies-cat-furniture 28/15001