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 = 168 
  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 = 168 
  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.00047

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
168 167 166/167/168 3 1 1 0 A 4 10 1328428800 N N 0 N 0 default 0 N N en Desktops [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 be 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 loved ones, [product] has got you covered. Equipped with advanced technology, [product] ensures top-notch performance and reliability. Its powerful processor and ample storage capacity allow for seamless multitasking and efficient data management. You can effortlessly run multiple applications simultaneously without any lag or slowdown. One of the standout features of [product] is its exceptional connectivity options. It supports various wireless protocols, enabling you to connect to the internet, peripherals, and other devices effortlessly. Whether you need to transfer files, stream media, or collaborate with others, [product] provides a seamless and reliable connection. In addition to its impressive performance, [product] also prioritizes your security and privacy. It incorporates robust security measures, such as biometric authentication and data encryption, to ensure that your sensitive information remains protected at all times. Furthermore, [product] is designed with sustainability in mind. It utilizes energy-efficient components and implements eco-friendly practices throughout its lifecycle, reducing its environmental impact. Overall, [product] is a game-changer in its field, offering a comprehensive solution that combines functionality, performance, and style. It is the perfect companion for individuals and professionals alike, empowering them to achieve more and simplify their lives. desktops, computers, PC, laptops, workstations, gaming desktops, all-in-one desktops, mini desktops, desktop accessories, desktop hardware, desktop software, desktop operating systems, desktop specifications, desktop performance, desktop reviews, desktop Discover the best [product] on the market. Our [product] offers exceptional quality, durability, and performance. With its innovative features and cutting-edge technology, it is designed to meet all your needs and exceed your expectations. Whether you are "Discover the Ultimate [Product]: Unleash the Power of Innovation" Age Warning This website contains content that is suitable for users who are 18 years of age or older. By continuing to browse this site, you confirm that you are at least 18 years old. If you are under the age of 18, please exit this website immediately. By clicking "I am 18 or older" below, you acknowledge that you are of legal age to view adult content and agree to abide by the terms and conditions of this website. If you are not of legal age or do not wish to view adult content, please click "Exit" to leave this website. I am 18 or older Exit desktops 166/167