SELECT 
  cscart_products.*, 
  cscart_product_descriptions.*, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = 'M', 
      CONCAT(
        cscart_products_categories.category_id, 
        'M'
      ), 
      cscart_products_categories.category_id
    )
  ) as category_ids, 
  popularity.total as popularity, 
  IF(
    shared_prices.product_id IS NOT NULL, 
    MIN(
      IF(
        shared_prices.percentage_discount = 0, 
        shared_prices.price, 
        shared_prices.price - (
          shared_prices.price * shared_prices.percentage_discount
        )/ 100
      )
    ), 
    MIN(
      IF(
        cscart_product_prices.percentage_discount = 0, 
        cscart_product_prices.price, 
        cscart_product_prices.price - (
          cscart_product_prices.price * cscart_product_prices.percentage_discount
        )/ 100
      )
    )
  ) as price, 
  companies.company as company_name, 
  cscart_product_sales.amount as sales_amount, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_discussion.type as discussion_type 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  AND cscart_product_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id 
  AND shared_prices.company_id = 1 
  AND shared_prices.lower_limit = 1 
  AND shared_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id 
  INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.company_id = 1 
  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_products.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_products.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_products.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_products.status IN ('A', 'H') 
  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id 
  AND cscart_product_sales.category_id = 1897 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 60899 
  AND cscart_seo_names.type = 'p' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND cscart_seo_names.company_id = 1 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id 
  AND cscart_discussion.object_type = 'P' 
WHERE 
  cscart_products.product_id = 60899 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00123

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "shared_prices",
      "access_type": "system",
      "possible_keys": [
        "usergroup",
        "product_id",
        "company_id",
        "lower_limit",
        "usergroup_id"
      ],
      "rows": 0,
      "filtered": 0,
      "const_row_not_found": true
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "status"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "companies",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["company_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "popularity",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "total"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_product_sales",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "pa"],
      "key": "PRIMARY",
      "key_length": "6",
      "used_key_parts": ["category_id", "product_id"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_product_prices",
      "access_type": "range",
      "possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
      "rowid_filter": {
        "range": {
          "key": "lower_limit",
          "used_key_parts": ["lower_limit", "product_id", "usergroup_id"]
        },
        "rows": 2,
        "selectivity_pct": 0.074128984
      },
      "rows": 2,
      "filtered": 100,
      "attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 60899 and cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'en')"
    },
    "table": {
      "table_name": "cscart_products_categories",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "pt"],
      "key": "pt",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 9,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "c_status", "p_category_id"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["category_id"],
      "ref": ["cscart_migrate.cscart_products_categories.category_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "cscart_categories.company_id = 1 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.`status` in ('A','H')"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "dispatch",
      "key_length": "210",
      "used_key_parts": [
        "dispatch",
        "object_id",
        "type",
        "lang_code",
        "company_id"
      ],
      "ref": ["const", "const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
    },
    "table": {
      "table_name": "cscart_discussion",
      "access_type": "ref",
      "possible_keys": ["object_id"],
      "key": "object_id",
      "key_length": "6",
      "used_key_parts": ["object_id", "object_type"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
    }
  }
}

Result

product_id product_code product_type trustmark_origin trustmark_certified trustmark_leadtime trustmark_location trustmark_return owner_id status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params updated_timestamp pricing_note use_new_layout category_image tax_code upc_code product_detail_ids nav_sku sku_columns nav_review_user_id hide_price vendor_fulfilled hide_commercial_price non_returnable ble_basics commercial_hidden allow_configurator enable_customize enable_buy_american base_cost redline_p lang_code product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message internal promo_text price category_ids popularity company_name sales_amount seo_name seo_path discussion_type
60899 BLE-G-ULO E C M W A 0 A 1 365.00 1000 0.000 0 0 0 0.00 0 1223956800 0 N N N D N P N N N Y 30 0 N 0 0 0 0 13 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 1770321824 Price increased by $51 - DC 5/20/21 37% commercial discount to base price manually added - DC 5/20/21 Price increased 10% from $289 to $318 - DC 5/24/22 Price increased from $330 to $365 - DC 10/31/22 Y none none 752,753,754 BLE-G {"22861":6,"22862":6,"22863":8,"22864":8,"22865":8,"22872":9,"22852":10,"22873":11,"22874":11,"22875":11,"21941":12} 1008383 0 0 0 0 0 0 0 0 1 0.00 0 en Outback Gooseneck Light <p>A versatile look, the Outback features simple lines and an eye-catching rugged character. By joining this shade and a gooseneck arm, this wall light embraces an iconic appearance and allows installation in any location. Indoors or out, this fixture’s aesthetic complements the numerous styles found in today’s homes and businesses: nautical, industrial, farmhouse, and more.<br /> <br />Manufactured and assembled in the United States, the Outback offers the heightened level of quality associated with handcrafted lighting. This fixture is fully customizable with various finish options, gooseneck arms, and guard and glass options. </p> <p>|break|</p> <ul> <li>Manufactured and hand-crafted in the USA</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> <li>Read more about the Outback Gooseneck Light over on our<span> <a href="https://www.barnlight.com/inspiration/gooseneck-barn-lights-bring-nautical-vibe-to-kitchen/" target="_blank">blog</a></span>!</li> </ul> rlm fixture with guard and glass, nautical gooseneck light, cage wall light, industrial barn lighting This versatile RLM light combines a classic barn light shade with a nautical guard & glass component. Perfect for adding a touch of industrial flair! the outback gooseneck light, outback light, gooseneck, warehouse shade, cast guard, nautical gooseneck, the outback, BLE-G-ULO-PC, BLE-G-ULO12-PC, BLE-G-ULO14-PC, BLE-G-ULO16-PC, BLE-G-ULO18-PC, BLE-G-ULO20-PC, The Outback Gooseneck Light, The Outback Gooseneck Lights, The Outback Gooseneck Lighting, Outback Gooseneck Light, Outback Gooseneck Lights, Outback Gooseneck Lighting, The Outback Industrial Gooseneck Light, The Outback Industrial Gooseneck Lights, The Outback Industrial Gooseneck Lighting, Outback Industrial Gooseneck Light, Outback Industrial Gooseneck Lights, Outback Industrial Gooseneck Lighting, outback, out back, outback gooseneck, out back gooseneck, out back goosenecks, Industrial light, industrial lights, industrial lighting, industrial lighting fixture, industrial lighting fixtures, rugged light, rugged lights, rugged lighting, rugged lighting fixture, rugged lighting fixtures, Vintage Industrial light, vintage industrial lights, vintage industrial lighting, vintage industrial lighting fixture, vintage industrial lighting fixtures, cast guard light, cast guard lights, cast guard lighting, cast guard lighting fixture, cast guard lighting fixtures, Queensland collection, queensland lighting, queensland light, queensland lights, queensland lighting, queensland light fixture, queensland light fixtures, Queens land collection, queens land lighting, queens land light, queens land lights, queens land lighting, queens land light fixture, queens land light fixtures, Queensland,  industrial gooseneck, industrial goosenecks, industrial goose neck, industrial goose necks, industrial wall light, industrial wall lights, industrial wall lighting, industrial light fixture, industrial light fixtures, industrial gooseneck light, industrial goose neck light, industrial gooseneck lights, industrial goose neck lights, industrial gooseneck lighting, industrial goose neck lighting, rugged gooseneck, rugged goosenecks, rugged goose neck, rugged goose necks, rugged wall light, rugged wall lights, rugged wall lighting, rugged light fixture, rugged light fixtures, rugged gooseneck light, rugged goose neck light, rugged gooseneck lights, rugged goose neck lights, rugged gooseneck lighting, rugged goose neck lighting, cast guard gooseneck, cast guard goosenecks, cast guard goose neck, cast guard goose necks, cast guard wall light, cast guard wall lights, cast guard wall lighting, cast guard light fixture, cast guard light fixtures, cast guard gooseneck light, cast guard goose neck light, cast guard gooseneck lights, cast guard goose neck lights, cast guard gooseneck lighting, cast guard goose neck lighting, Queensland wall light, Queensland wall lights, Queensland wall lighting, Queensland Wall Fixture, Queensland wall fixtures, Queens land wall light, Queens land wall lights, Queens land wall lighting, Queens land Wall Fixture, Queens land wall fixtures, Queensland Gooseneck, Queensland goose neck, queensland goose necks, Queensland gooseneck light, Queensland gooseneck lights, Queensland gooseneck lighting, Queensland goose neck light, Queensland goose neck lights, Queensland goose neck lighting, Queens land Gooseneck, Queens land goose neck, queens land goose necks, Queens land gooseneck light, Queens land gooseneck lights, Queens land gooseneck lighting, Queens land goose neck light, Queens land goose neck lights, Queens land goose neck lighting, Outback Series, Outback Collection, The Outback Series, The Outback Collection, Australia collection, Australia Series, the Australia collection, the Australia Series, Queensland Collection, Queensland Series, The Queensland Collection, the Queensland Series, Queens land Collection, Queens land Series, The Queens land Collection, the Queens land Series, Out back Series, Out back Collection, The Out back Series, The Out back Collection, SPS-0160, SPS 0160, SPS0160, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, Outback Gooseneck Light | Barn Light Electric 365.000000 1530,1602,1644,1697,1707,1782,1906,2001,1897M 327678 Barn Light Electric Company 129 outback-gooseneck-light 1887/1896/1897 B