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 = 176 
  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 = 176 
  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 name object_id type dispatch path seo_name seo_path
176 175 166/175/176 3 1 1 0 A 5 10 1328475600 N N 0 N 0 default 0 N N en GPS & Navigation [Product] is a cutting-edge device that revolutionizes the way we [use/interact with] technology. With its sleek design and advanced features, it offers a seamless user experience like never before. This innovative product is packed with state-of-the-art technology, making it a must-have for tech enthusiasts. Its powerful processor ensures lightning-fast performance, allowing you to multitask effortlessly and run demanding applications smoothly. The [product] boasts a stunning high-resolution display that brings images and videos to life with vibrant colors and sharp details. Whether you're watching movies, playing games, or browsing the web, the visuals will be immersive and captivating. One of the standout features of this product is its exceptional camera system. Capture breathtaking photos and videos with the high-resolution lenses, and take your photography skills to the next level. With various shooting modes and editing tools, you can unleash your creativity and produce professional-quality content. In terms of connectivity, the [product] offers seamless integration with other devices, allowing you to effortlessly transfer files, share content, and connect to the internet. Stay connected wherever you go and enjoy fast and reliable network speeds. Furthermore, this product prioritizes user security and privacy. With advanced biometric authentication, your data and personal information are safeguarded, ensuring peace of mind in today's digital world. The [product] also comes with a long-lasting battery that keeps you powered throughout the day. Whether you're working, gaming, or streaming, you can rely on its impressive battery life to keep up with your demands. Overall, [product] is a game-changer in the world of technology. Its cutting-edge features, sleek design, and exceptional performance make it a top choice for those seeking the best in class. Experience the future of technology with [product]. [Product] is a high-quality and innovative solution designed to meet your needs. With its advanced features and user-friendly interface, it offers a seamless experience for all users. Whether you are a professional or a beginner, [product] provides the to "Discover the Ultimate [Product] for Unmatched Performance | [Brand Name]" "Enhance Your Lifestyle with the Revolutionary [Product] | [Brand Name]" "Experience the Power and Innovation of [Product] by [Brand Name]" "Unlock Limitless Possibilities with the gps-and-navigation 176 c 166/175 gps-and-navigation 166/175