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 = 236 
  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 = 236 
  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.00036

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
236 234 166/234/236 3 1 1 0 A 5 20 1328475600 N N 0 N 0 default 0 N N en HTC [Product] is a versatile and innovative solution designed to meet the needs of modern consumers. With its sleek and ergonomic design, it seamlessly integrates into any environment, whether it be at home or in the office. This product offers a wide range of features that enhance convenience and efficiency. Its user-friendly interface allows for easy navigation and quick access to various functions. The high-resolution display provides crystal-clear visuals, ensuring an immersive and enjoyable experience. Equipped with advanced technology, [product] delivers exceptional performance. Its powerful processor ensures smooth multitasking and fast response times, allowing users to effortlessly handle demanding tasks. Additionally, the ample storage capacity provides ample space for files, documents, and multimedia content. One of the standout features of [product] is its connectivity options. It supports various wireless protocols, enabling seamless integration with other devices. Whether it's sharing files, streaming media, or connecting to peripherals, this product offers a seamless and hassle-free experience. Furthermore, [product] prioritizes user safety and security. It incorporates robust security measures to protect sensitive data and ensure privacy. With its reliable encryption and authentication features, users can have peace of mind knowing their information is safeguarded. In terms of sustainability, [product] is designed with eco-friendly materials and energy-efficient components. It strives to minimize its carbon footprint and contribute to a greener future. Overall, [product] is a cutting-edge solution that combines style, functionality, and performance. It is the perfect companion for individuals seeking a reliable and versatile device that can adapt to their ever-changing needs. Discover the best [product] on the market that will revolutionize your [specific use case]. Our [product] offers unparalleled performance, durability, and functionality, making it the ultimate choice for [target audience]. With its cutting-edge features a "Discover the Ultimate [Product]: Unleash the Power of Innovation" htc 166/234