SELECT 
  cscart_categories.*, 
  cscart_category_descriptions.*, 
  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 = 186 
  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 = 186 
  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.00033

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_categories const PRIMARY,c_status,p_category_id PRIMARY 3 const 1
1 SIMPLE cscart_category_descriptions const PRIMARY PRIMARY 9 const,const 1
1 SIMPLE cscart_seo_names const PRIMARY,dispatch PRIMARY 210 const,const,const,const,const 1

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 lang_code category description meta_keywords meta_description page_title age_warning_message seo_name seo_path
186 175 166/175/186 3 1 1 0 A 4 30 1328475600 N N 0 N 0 default 0 N N en Speakers [Product] is a versatile and innovative product that is designed to meet the needs of modern consumers. It is crafted with precision and attention to detail, ensuring a high-quality and durable product that will last for years to come. This product offers a wide range of features and functionalities, making it suitable for various applications. Whether you are a professional or a casual user, [product] is designed to enhance your experience and simplify your tasks. With its sleek and modern design, [product] not only performs exceptionally well but also adds a touch of elegance to any space. Its ergonomic design ensures comfort and ease of use, allowing you to effortlessly navigate through its various functions. One of the standout features of [product] is its advanced technology, which sets it apart from its competitors. It incorporates cutting-edge innovations that enhance its performance and efficiency, providing you with a seamless and enjoyable user experience. Additionally, [product] is built with sustainability in mind. It is made from eco-friendly materials and is designed to minimize energy consumption, reducing its environmental impact. Whether you are looking to upgrade your current device or searching for a reliable and efficient solution, [product] is the perfect choice. Its exceptional performance, sleek design, and advanced features make it a must-have for anyone seeking a top-of-the-line product. Discover the best [product] for all your needs. Our [product] is designed to provide exceptional performance and durability. With its innovative features and cutting-edge technology, it is the perfect solution for [specific use cases]. Whether you are a p "Discover the Ultimate [Product]: Unleash the Power of Innovation" speakers 166/175