SELECT 
  *, 
  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 = 240 
  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 = 240 
  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 name object_id type dispatch path seo_name seo_path
240 234 166/234/240 3 1 1 0 A 5 30 1328475600 N N 0 N 0 default 0 N N en Motorola [Product] is a cutting-edge innovation designed to revolutionize the way we [describe the purpose or function of the product]. With its sleek and modern design, this product seamlessly combines style and functionality. Featuring state-of-the-art technology, [product] offers an unparalleled user experience. Its intuitive interface allows for effortless navigation and control, making it suitable for users of all ages and tech-savviness levels. One of the standout features of [product] is its exceptional performance. Powered by advanced processors and high-quality components, it delivers lightning-fast speeds and smooth operation, ensuring that tasks are completed efficiently and without any lag. In addition to its impressive performance, [product] also boasts an extensive range of features. From its versatile connectivity options to its innovative software, it offers endless possibilities for customization and personalization. Whether you're a professional seeking a powerful tool for work or a casual user looking for entertainment, [product] has something to offer for everyone. Durability and reliability are also key aspects of [product]. Built with premium materials and rigorous quality control, it is designed to withstand the test of time and provide long-lasting performance. Its robust construction ensures that it can handle everyday wear and tear, making it a reliable companion for years to come. Furthermore, [product] prioritizes user safety and security. With advanced encryption and privacy features, it safeguards your sensitive data and protects against potential threats, giving you peace of mind while using the product. Overall, [product] is a game-changer in its field. With its cutting-edge technology, sleek design, exceptional performance, and user-friendly interface, it sets a new standard for [describe the purpose or function of the product]. Whether you're a tech enthusiast, a professional, or a casual user, [product] is the perfect choice for those seeking innovation, reliability, and style. 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] for Unmatched Performance and Quality" motorola 240 c 166/234 motorola 166/234