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 = 195 
  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 = 195 
  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.00052

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
195 174 166/174/195 3 1 1 0 A 3 50 1328475600 N N 0 N 0 default 0 N N en Home Theater Systems [Product] is a versatile and innovative solution designed to simplify your daily tasks and enhance your productivity. With its sleek and modern design, it seamlessly integrates into any environment, whether it's your home, office, or on the go. This cutting-edge product offers a wide range of features and functionalities that cater to your specific needs. Its intuitive interface allows for effortless navigation and quick access to all its capabilities. Whether you're managing your schedule, organizing your files, or staying connected with colleagues and friends, [product] has got you covered. One of the standout features of [product] is its advanced technology, which ensures fast and efficient performance. It boasts powerful processing capabilities, enabling you to multitask seamlessly without any lag or slowdown. Additionally, its high-resolution display provides stunning visuals, making every task a visually immersive experience. Furthermore, [product] prioritizes your security and privacy. It incorporates state-of-the-art encryption and authentication protocols to safeguard your data and protect your sensitive information from unauthorized access. You can confidently store your files, share documents, and communicate securely, knowing that your privacy is always protected. Another notable aspect of [product] is its exceptional connectivity options. It supports various wireless technologies, allowing you to connect effortlessly to the internet, peripherals, and other devices. Whether you need to transfer files, stream media, or collaborate with others, [product] ensures seamless connectivity and compatibility. In addition to its impressive features, [product] also offers a wide range of accessories and add-ons to enhance your experience further. From ergonomic keyboards and stylus pens to protective cases and docking stations, you can customize [product] to suit your preferences and optimize your workflow. Overall, [product] is a game-changer in the market, revolutionizing the way you work, communicate, and stay organized. Its sleek design, powerful performance, advanced security features, and extensive connectivity options make it a must-have for anyone seeking a reliable and efficient solution to streamline their daily tasks. Discover the best [product] on the market. Our [product] offers exceptional quality, durability, and functionality. Whether you're a professional or a hobbyist, our [product] is designed to meet your needs. With its innovative features and advanced techno "Discover the Ultimate [Product]: Unleash the Power of Innovation" home-theater-systems 166/174