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 = 166 
  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 = 166 
  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.00048

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
166 0 166 1 1 1 0 A 0 10 1328428800 N N 0 N 0 default 0 N N en Electronics <div> <h1>Electronics</h1> <p> Electronics is a broad category that encompasses a wide range of devices and systems that operate using electrical circuits. It includes various consumer electronics, such as smartphones, laptops, televisions, cameras, and audio systems, as well as industrial and scientific equipment like robotics, sensors, and medical devices. </p> <p> In the world of electronics, there are numerous components and technologies that make these devices function. Integrated circuits (ICs), transistors, resistors, capacitors, and diodes are some of the fundamental building blocks used in electronic circuits. These components work together to process, store, and transmit information or perform specific tasks. </p> <p> The field of electronics is constantly evolving, with new advancements and innovations being introduced regularly. This includes the development of smaller and more powerful devices, improved energy efficiency, wireless communication technologies, and the integration of artificial intelligence and machine learning capabilities. </p> <p> Electronics have become an integral part of our daily lives, enabling us to communicate, work, entertain, and stay connected. They have revolutionized various industries, including telecommunications, entertainment, healthcare, transportation, and manufacturing. With the rapid pace of technological advancements, the future of electronics holds exciting possibilities and potential for further advancements in various fields. </p> </div> electronics, gadgets, technology, devices, appliances, computers, smartphones, tablets, audio, video, cameras, gaming, accessories, home electronics, wearable technology, electronic components, electronic accessories, electronic repair, electronic stores Discover the best [product] on the market that will revolutionize your [specific use or benefit]. Our [product] is designed with cutting-edge technology and superior craftsmanship to provide unmatched performance and durability. Whether you're a professio "The Ultimate Guide to [Product]: Everything You Need to Know | [Brand Name]""Unlocking the Power of [Product]: A Comprehensive Guide | [Brand Name]""[Product] 101: A Beginner's Guide to Mastering [Product] | [Brand Name]""The Definitive [Product] Reso GE Warning Message for Electronics: Attention: Important Safety Information Dear valued customer, We would like to bring to your attention some important safety information regarding your GE electronic device. Your safety is our top priority, and we want to ensure that you have a safe and enjoyable experience using our products. Please read the following warning message carefully: 1. Electrical Safety: - Always plug your electronic device into a properly grounded electrical outlet. - Avoid using extension cords or adapters that may not be compatible with your device. - Do not expose your device to water or other liquids, as it may cause electrical shock or damage. 2. Overheating: - Ensure proper ventilation for your electronic device to prevent overheating. - Do not cover or block any ventilation openings on the device. - Avoid using the device on soft surfaces such as beds or sofas, as it may obstruct airflow and lead to overheating. 3. Battery Safety: - Only use the recommended batteries or power sources specified for your device. - Do not attempt to disassemble or modify the battery. - If the battery is damaged or leaking, discontinue use immediately and contact our customer support for assistance. 4. Usage and Maintenance: - Follow the manufacturer's instructions for proper usage and maintenance of your electronic device. - Regularly clean the device using a soft, dry cloth to remove dust and debris. - Avoid exposing the device to extreme temperatures or direct sunlight. 5. Children's Safety: - Keep electronic devices out of reach of children. - Do not allow children to play with or handle electronic devices unsupervised. Please take these warnings seriously and ensure that you and your loved ones are aware of these safety precautions. Failure to follow these guidelines may result in damage to your device, personal injury, or even fire hazards. If you have any questions or concerns regarding the safety of your GE electronic device, please do not hesitate to contact our customer support team at [customer support contact details]. Thank you for choosing GE. We appreciate your trust in our products and are committed to providing you with the highest level of safety and quality. Sincerely, [Your Name] GE Customer Support electronics