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 = 201 
  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 = 201 
  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.00067

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
201 167 166/167/201 3 1 1 0 A 3 140 1328475600 N N 0 N 0 default 0 N N en Processors [Product] is a versatile and innovative solution designed to meet a wide range of needs. It is crafted with precision and attention to detail, making it a reliable and durable choice for users. With its sleek and modern design, [product] seamlessly blends into any environment, adding a touch of elegance. Featuring advanced technology, [product] offers exceptional performance and efficiency. Its user-friendly interface allows for easy operation and customization, ensuring a seamless user experience. Whether you're a professional or a casual user, [product] caters to your specific requirements, making it suitable for various applications. The high-quality materials used in the construction of [product] guarantee its longevity and resilience. It is built to withstand daily wear and tear, providing long-lasting performance. Additionally, [product] is designed with safety in mind, incorporating various safety features to protect users and prevent accidents. One of the standout features of [product] is its versatility. It can be used for a wide range of purposes, from [specific use case] to [another specific use case]. Its adaptability makes it an ideal choice for individuals and businesses alike, offering endless possibilities. Furthermore, [product] is backed by excellent customer support, ensuring that any queries or concerns are promptly addressed. The company behind [product] is committed to delivering exceptional service and ensuring customer satisfaction. In conclusion, [product] is a reliable, efficient, and versatile solution that caters to various needs. Its sleek design, advanced technology, and durability make it a standout choice in the market. Whether you're a professional or a casual user, [product] is designed to enhance your experience and meet your specific requirements. 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 choice for any [product] enthusiast. Whether you are a professional or a h "Discover the Ultimate [Product]: Unleash the Power of Innovation" processors 166/167