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 = 238 
  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 = 238 
  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.00035

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
238 234 166/234/238 3 1 1 0 A 4 40 1328475600 N N 0 N 0 default 0 N N en Nokia [Product] is a versatile and innovative solution designed to simplify your daily tasks and enhance your productivity. With its sleek and ergonomic design, it seamlessly integrates into your workspace, making it a perfect addition to any professional or personal setting. This cutting-edge product offers a wide range of features and functionalities that cater to your specific needs. Its intuitive interface allows for easy navigation and quick access to various tools and applications. Whether you're a student, professional, or entrepreneur, [product] is designed to streamline your workflow and help you achieve your goals efficiently. One of the standout features of [product] is its advanced technology, which ensures seamless connectivity and compatibility with multiple devices. Whether you're using a laptop, tablet, or smartphone, you can effortlessly sync your data and access it from anywhere, anytime. This level of flexibility and convenience allows you to stay productive even when you're on the go. Additionally, [product] boasts a robust security system that safeguards your sensitive information and protects your privacy. With built-in encryption and biometric authentication, you can rest assured that your data is safe from unauthorized access. Furthermore, [product] offers a wide range of customization options, allowing you to personalize your experience according to your preferences. From adjustable settings to personalized shortcuts, you can tailor [product] to suit your unique needs and work style. In conclusion, [product] is a game-changer in the world of productivity tools. Its sleek design, advanced features, and user-friendly interface make it an indispensable asset for anyone looking to optimize their workflow and maximize their efficiency. Whether you're a student, professional, or entrepreneur, [product] is the ultimate tool to help you stay organized, focused, and ahead of the curve. 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 solution for all your [product] needs. Whether you are a professional or a "Discover the Ultimate [Product]: Unleash the Power of Innovation" nokia 166/234