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 = 194 
  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 = 194 
  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.00049

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
194 174 166/174/194 3 1 1 0 A 4 40 1328475600 N N 0 N 0 default 0 N N en DVD & Blu-ray Players [Product] is a cutting-edge innovation that revolutionizes the way we [describe the main function or purpose of the product]. With its sleek design and advanced features, it offers an unparalleled user experience. This state-of-the-art [product] is designed to simplify your life and enhance your productivity. Its intuitive interface allows for effortless navigation and seamless integration with other devices. Whether you're a professional or a casual user, [product] caters to your needs with its versatile functionality. One of the standout features of [product] is its exceptional performance. Powered by the latest technology, it delivers lightning-fast processing speeds and smooth multitasking capabilities. Say goodbye to lagging and buffering, as [product] ensures a seamless and efficient performance every time. In addition to its impressive performance, [product] boasts an impressive array of features. From its high-resolution display to its advanced camera system, it captures every detail with stunning clarity. Whether you're capturing precious moments or immersing yourself in multimedia content, [product] provides an immersive and visually captivating experience. Furthermore, [product] prioritizes your security and privacy. With advanced encryption and biometric authentication, your data is safeguarded from unauthorized access. You can use [product] with peace of mind, knowing that your personal information is protected. Overall, [product] is a game-changer in the market, offering a blend of style, functionality, and innovation. It is the perfect companion for those seeking a cutting-edge device that enhances their daily lives. Experience the future of technology with [product]. Discover the best [product] on the market. Our [product] offers exceptional quality, durability, and functionality. With its innovative features and sleek design, it is the perfect choice for any [product] enthusiast. Whether you are a professional or a b "Discover the Ultimate [Product]: Unleash the Power of Innovation" dvd-and-blu-ray-players 166/174