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 = 185 
  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 = 185 
  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.00026

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
185 175 166/175/185 3 1 1 0 A 5 20 1328475600 N N 0 N 0 default 0 N N en In-Dash Stereos [Product] is a versatile and innovative solution designed to meet a wide range of needs. With its cutting-edge features and user-friendly interface, it offers an unparalleled experience for users. This product is designed to simplify tasks and enhance productivity. Its advanced technology allows for seamless integration with other devices and systems, making it an ideal choice for both personal and professional use. The sleek and modern design of [product] adds a touch of elegance to any setting. Its compact size makes it easy to carry and use on the go, while its durable construction ensures long-lasting performance. One of the standout features of [product] is its intuitive interface. With just a few taps or clicks, users can navigate through various functions and access a wide range of features. Whether it's managing tasks, organizing files, or connecting with others, [product] makes it effortless and efficient. Furthermore, [product] offers exceptional security measures to protect sensitive information. With advanced encryption and authentication protocols, users can have peace of mind knowing their data is safe and secure. In addition to its functionality, [product] also boasts impressive performance. Its powerful processor and ample storage capacity ensure smooth and fast operation, even when handling demanding tasks or running multiple applications simultaneously. Overall, [product] is a game-changer in its field. Its combination of advanced features, user-friendly interface, and sleek design make it a must-have for anyone looking to enhance their productivity and simplify their daily tasks. Discover the best [product] on the market. Our [product] offers unparalleled quality and performance, making it the perfect choice for all your needs. With its innovative features and cutting-edge technology, our [product] will revolutionize the way you [ "The Ultimate Guide to [Product]: Everything You Need to Know | [Brand Name]" "Unlocking the Power of [Product]: A Comprehensive Guide | [Brand Name]" "[Product] 101: A Beginner's Guide to Mastering [Product] | [Brand Name]" "Discover the Hidden Potential in-dash-stereos 166/175