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 = 182 
  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 = 182 
  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.00041

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
182 177 166/177/182 3 1 1 0 A 4 20 1328475600 N N 0 N 0 default 0 N N en Android [Product] is a versatile and innovative solution designed to meet the needs of modern consumers. This high-quality product offers a range of features and benefits that make it stand out from the competition. With its sleek and stylish design, [product] is visually appealing and will complement any space. Its ergonomic and user-friendly interface ensures effortless operation, making it suitable for users of all ages and technical abilities. One of the key features of [product] is its exceptional performance. It is equipped with state-of-the-art technology that delivers fast and efficient results. Whether you're using it for work, entertainment, or both, [product] will exceed your expectations. In addition to its impressive performance, [product] also prioritizes user safety. It is built with robust security measures to protect your data and privacy, giving you peace of mind while using it. Furthermore, [product] offers seamless connectivity options, allowing you to effortlessly connect and share data with other devices. Whether it's wirelessly connecting to your smartphone or syncing with your smart home devices, [product] ensures a hassle-free experience. Durability is another standout feature of [product]. It is built to withstand daily wear and tear, ensuring longevity and reliability. This makes it a cost-effective investment that will serve you well for years to come. Overall, [product] is a cutting-edge solution that combines style, performance, and functionality. It is the perfect choice for individuals who value quality and want a product that can keep up with their fast-paced lifestyle. 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're a professional or a "Discover the Ultimate [Product]: Unleash the Power of Innovation" android 166/177