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 = 235 
  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 = 235 
  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.00025

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
235 234 166/234/235 3 1 1 0 A 3 10 1328475600 N N 0 N 0 default 0 N N en Apple iPhone [Product] is a versatile and innovative solution designed to meet a wide range of needs. With its cutting-edge technology and user-friendly interface, it offers an unparalleled experience for users. Whether you are a professional or a casual user, [product] is designed to enhance your productivity and simplify your tasks. One of the standout features of [product] is its exceptional performance. It is equipped with powerful hardware and advanced software, ensuring smooth and efficient operation. Whether you are multitasking, running resource-intensive applications, or gaming, [product] delivers exceptional speed and responsiveness. In terms of design, [product] boasts a sleek and modern aesthetic. Its slim and lightweight build makes it highly portable, allowing you to take it with you wherever you go. The high-quality materials used in its construction ensure durability and longevity, making it a reliable companion for years to come. The user interface of [product] is intuitive and easy to navigate, making it accessible to users of all skill levels. Its customizable settings and personalized features allow you to tailor it to your specific preferences and needs. Whether you are a tech-savvy individual or a beginner, [product] offers a seamless and enjoyable user experience. Furthermore, [product] offers a wide range of connectivity options, allowing you to effortlessly connect and share data with other devices. Whether it's through Bluetooth, Wi-Fi, or USB, you can easily transfer files, stream media, or connect to external displays. In terms of security, [product] prioritizes the protection of your data and privacy. It incorporates advanced security features such as biometric authentication and encryption, ensuring that your information remains safe and secure. Overall, [product] is a game-changer in its field, offering a combination of performance, design, and functionality. Whether you are a professional seeking a reliable tool for work or a tech enthusiast looking for the latest innovation, [product] is sure to exceed your expectations. Discover the best [product] on the market with our comprehensive selection. Our [product] offers top-notch quality, durability, and functionality, making it the perfect choice for all your needs. Whether you're a professional or a hobbyist, our [product] "Discover the Ultimate [Product]: Unleash the Power of Innovation" apple-iphone 166/234