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 = 1931 
  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 = 1931 
  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.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "table": {
      "table_name": "cscart_categories",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "c_status", "p_category_id"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["category_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_category_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["category_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "210",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "ref": ["const", "const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

category_id parent_id id_path level owner_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 company_id is_trash sidebar_r_bg sidebar_r_title sidebar_r_desc sidebar_r_link sidebar_r_link_text sidebar_c_bg sidebar_c_title sidebar_c_desc sidebar_c_link sidebar_c_link_text commercial_hidden lang_code category description ldescription meta_keywords meta_description page_title age_warning_message name object_id type dispatch path seo_name seo_path
1931 1927 1920/1927/1931 3 0 0 A 49 40 1626840000 N N 0 N 0 default 0 1 N 0 en Flush Mount Lighting <span>Combining all of the style of our vintage-inspired pendant lights with the latest in LED technology, this collection of Flush Mount LED Pendants offers loads of energy efficiency for every tight space. These ceiling-hugging flush mounts are easy to customize so you can create an eye-catching fixture for hallways, bathrooms, closets and more!</span> <p><strong>Why should homes and businesses replace standard fixtures with LED lights?</strong></p> <p>Replacing standard incandescent or CFL bulbs with integrated LED lights offers numerous benefits to both homeowners and business owners. From traditionally-decorated homes to contemporary businesses, our array of LED flush mount lights provides a finishing touch for residential and commercial spaces.</p> <p>With the latest, cutting-edge technology, LED components are integrated directly into the fixture’s structure. Renowned for their energy efficiency and environmentally friendly profile, our Flush Mount LED Lights emit about 50,000 hours of continuous light requiring little electricity to brighten a room. Reducing a space’s energy consumption is additionally beneficial to the environment and help homes and businesses meet “green” building codes.</p> <p>Multiple lumen options and color temperatures are available which give home and business owners the opportunity to control the look and feel of the illumination. As general lighting, these LED modules are capable of emitting a warm, natural light, reminiscent of incandescent bulbs, or they can produce a cooler, blue light to accentuate specific features.</p> <p><strong>Where are Flush Mount LED Lights used?</strong></p> <p>Flush Mount LED Lights feature a compact profile making them suitable for small spaces or in rooms with low ceilings. Hallways, bathrooms, powder rooms, laundry rooms, and closets all benefit from a ceiling-hugging, flush mount light.</p> <p>These fixtures are also suited to a number of décors including farmhouse-style homes, industrial city lofts, contemporary condos, or coastal cottages. Just like all of Barn Light Electric’s lighting, these fixtures are handspun from commercial grade materials and finished by hand with careful attention to every detail. This process imbues our Flush Mount LED Lighting with the dependability not found in other contemporary fixtures. When partnered with the longevity of LEDs, these Flush Mount Lights become a lasting decorative feature for any home or business.</p> <p><strong>Is Flush Mount LED Lighting customizable?</strong></p> <span>Because we handcraft our lighting, this collection of Flush Mount LED Lights is easy to customize to suit most any space. Perfect for both interior and exterior lighting applications, choose from an assortment of powder coat finish colors to create a unique look!</span> flush mounted vintage light fixtures, flush mounted LED lights, lighting fixtures, flush mount fixture for lights, flush mounted LED fixtures Impressive space-saving designs with cutting-edge LED technology! Our handcrafted flush mount lights feature fully integrated LED components! Flush Mount LED Lighting | Barn Light Electric flush-mount-lights 1931 c 1920/1927 flush-mount-lights 1920/1927