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 = 189 
  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 = 189 
  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.00048

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
189 175 166/175/189 3 1 1 0 A 5 70 1328475600 N N 0 N 0 default 0 N N en Radar Detectors [Product] is a versatile and innovative solution designed to meet the needs of modern consumers. With its sleek design and advanced features, it offers a seamless user experience and enhances everyday life. This product is equipped with cutting-edge technology that allows for effortless connectivity and convenience. Whether you're at home, in the office, or on the go, [product] ensures that you stay connected and productive. The sleek and stylish design of [product] makes it a standout in any setting. Its compact size and lightweight construction make it easy to carry around, while its durable materials ensure long-lasting performance. One of the standout features of [product] is its intuitive interface, which makes it incredibly user-friendly. With just a few simple taps or swipes, you can access a wide range of functions and customize settings to suit your preferences. Additionally, [product] offers exceptional performance and reliability. Its powerful processor and ample storage capacity allow for seamless multitasking and efficient storage of files, photos, and videos. Furthermore, [product] is equipped with advanced security features to protect your data and privacy. With built-in encryption and biometric authentication, you can have peace of mind knowing that your information is safe and secure. Whether you're a tech enthusiast, a professional, or a casual user, [product] is designed to cater to your needs. Its versatility and adaptability make it suitable for a wide range of applications, from entertainment and productivity to communication and creativity. In conclusion, [product] is a state-of-the-art solution that combines style, functionality, and performance. With its advanced features and user-friendly interface, it is sure to enhance your daily life and exceed your expectations. Discover the best [product] on the market that will revolutionize your [specific use or benefit]. Our [product] is designed with cutting-edge technology and superior craftsmanship to provide you with unmatched performance and durability. Whether you're a "Discover the Ultimate [Product]: Unleash the Power of Innovation" radar-detectors 166/175