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 = 165 
  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 = 165 
  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.00027

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
165 167 166/167/165 3 1 1 0 A 6 100 1310932800 N N 0 N 0 default 0 N N en Tablets [Product] is an innovative and versatile product that is designed to meet a wide range of needs. It is crafted with precision and attention to detail, ensuring a high-quality and reliable performance. This product is designed to simplify your daily tasks and enhance your productivity. With its user-friendly interface and intuitive controls, it is easy to operate and navigate through its various features. Whether you are a professional or a casual user, [product] is designed to cater to your specific requirements. One of the standout features of [product] is its durability and longevity. It is built to withstand the test of time and is made from premium materials that ensure its longevity. This ensures that you can rely on [product] for years to come, making it a worthwhile investment. In addition to its durability, [product] also offers exceptional performance. It is equipped with state-of-the-art technology that delivers fast and efficient results. Whether you are using it for work, entertainment, or any other purpose, [product] will exceed your expectations. Furthermore, [product] is designed with versatility in mind. It offers a wide range of functionalities and can adapt to various settings and environments. Whether you need it for personal use, professional use, or even for travel, [product] is designed to meet your needs. Lastly, [product] is backed by excellent customer support and a comprehensive warranty. The manufacturer is committed to providing exceptional service and ensuring customer satisfaction. This gives you peace of mind knowing that you are investing in a product that is supported by a reliable and trustworthy brand. In conclusion, [product] is a remarkable product that combines durability, performance, versatility, and excellent customer support. It is designed to simplify your life and enhance your overall experience. Whether you are a professional or a casual user, [product] is a must-have for anyone looking for a reliable and high-quality solution. tablets, tablet devices, tablet computers, tablet technology, tablet features, tablet specifications, tablet brands, tablet reviews, tablet comparisons, tablet prices, tablet accessories, tablet operating systems, tablet apps, tablet gaming, tablet produc Discover the best [product] on the market. Our [product] offers superior quality, durability, and functionality. With its innovative features and sleek design, it is perfect for any [product] enthusiast. Shop now and experience the ultimate [product] expe "Discover the Ultimate [Product]: Unleash the Power of Innovation" tablets 166/167