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 = 269 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_categories.category_id = 269 
  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.00036

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.00183779,
    "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"],
          "loops": 1,
          "rows": 1,
          "cost": 0.00183779,
          "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 storefront_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 lang_code category description meta_keywords meta_description page_title age_warning_message name object_id type dispatch path seo_name seo_path
269 0 269 1 0 0 0 A 3 3 1762243200 N N 0 N 0 default 0 N N C en Arts & Crafts <p><strong><span style="color: rgb(192, 80, 77);">Arts & Crafts represent the joy of creativity and self-expression through handmade work. This category includes a wide range of creative activities such as painting, drawing, paper crafting, knitting, pottery, origami, and DIY (Do It Yourself) projects. Whether you’re an artist, a hobbyist, or simply exploring your imagination, arts and crafts help you create something beautiful and unique.</span></strong></p> <p><strong><span style="color: rgb(192, 80, 77);">From colorful paints and brushes to craft papers, beads, glue, and decorative materials &mdash; every tool lets you bring your ideas to life. Perfect for kids, students, and adults alike, arts and crafts encourage innovation, enhance motor skills, and provide relaxation through creative engagement.</span></strong></p> arts-and-crafts 269 c arts-and-crafts