Sandbox

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 = 1939 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 62860 
  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 = 62860 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00111

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 = 62860 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": 7,
      "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
62860	BLE-G-SCH-LED	P	E	C	M	A	D	0	A	1	515.00	1000	0.000	0	0	0	0.00	0	1418878800	0	N	N	N	D	N	P	N	N	N	Y	10	1418878800	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;}	1765293559	Price increased by $68 - DC 2/18/20 Price increased 5% from $506 to $531 - DC 6/1/21 Price increased 10% from $531 to $585 - DC 6/2/22 Price decreased from $585 to $445 - DC 11/3/22 Price increased from $445 to $515 - DC 2/24/23	Y		none	none	1663,1664,1665,1666	BLE-G	{"22791":3,"22797":9,"22796":9,"22795":9,"22794":9,"23173":11,"23172":11,"23171":11,"22675":12,"22644":13,"22798":10}	1008383	0	0	0	1	0	0	0	0	1	0.00	0	en	Primary LED Schoolhouse Gooseneck Light			<p>With a look dating back to the 1920s, the Primary updates classic schoolhouse lighting with integrated LED technology. The result of this union is modern efficiency and a timeless appearance. Clear or opaque shades give the fixture a nostalgic character while a gooseneck arm allows installation in numerous settings. Copper and brass, along with an assortment of powder coat colors, let the Primary match any home or business’s exact style.</p> <p>The LED components included in our schoolhouse lights’ designs are energy-saving, cost-effective, and environmentally sustainable. A practical yet decorative fixture, incorporate the Primary into any lighting plan!</p> <p>\|break\|</p> <ul> <li>Features a customizable glass schoolhouse globe and hand-spun fitter.</li> <li>This light is made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>White painted band(s) not recommended if opaque glass is selected, as it blends into the glass.</li> <li><span>The single band style has a silver border outlining the chosen finish.</span></li> </ul>	LED gooseneck lighting, led gooseneck, schoolhouse lighting, schoolhouse led lighting, schoolhouse lighting	A modern take on classic looks, this schoolhouse LED gooseneck light is perfect for both residential and commercial lighting applications! Check out efficient yet decorative lighting for yourself!	The Academia Schoolhouse LED Gooseneck Light, schoolhouse gooseneck, schoolhouse gooseneck lighting, gooseneck lighting, led schoolhouse, schoolhouse, led school house, school house, wall light, led wall light, led wall lighting, schoolhouse wall light, schoolhouse wall lighting, BLE-G-SCH-PC-LED, Secondary, Secondary Schoolhouse Gooseneck Light, Secondary Schoolhouse Gooseneck, The Secondary Schoolhouse Gooseneck Light, The Secondary Schoolhouse Gooseneck, Secondary Schoolhouse LED Gooseneck Light, Secondary Schoolhouse LED Gooseneck, The Secondary Schoolhouse LED Gooseneck Light, The Secondary Schoolhouse LED Gooseneck, Academia LED, Academia LED Schoolhouse, Academia, Academia LED Gooseneck, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary Schoolhouse Gooseneck Light, Primary Schoolhouse Gooseneck, Primary Gooseneck Light, Primary Gooseneck, Primary Schoolhouse LED Gooseneck Light, Primary Schoolhouse LED Gooseneck, Primary School house LED Gooseneck Light, Primary School house LED Gooseneck, Primary LED Gooseneck Light, Primary LED Gooseneck, primary, primary led, led primary, led primary gooseneck, led gooseneck gooseneck led, led goose neck, goose neck led, glass LED wall lighting, glass LED wall lighting fixture, glass LED wall lighting fixtures, glass LED shade wall light, glass shade wall lights, glass shade LED wall lighting, glass globe LED wall light, glass globe LED wall lighting, glass globe LED wall lights, glass globe shade LED wall light, glass globe shade LED wall lights, glass globe shade LED wall lighting, glass LED wall light fixture, glass LED wall light fixtures, LED glass wall lighting, LED glass wall lighting fixture, LED glass wall lighting fixtures, LED glass shade wall light, LED glass shade wall lights, LED glass shade wall lighting, LED glass globe wall light, LED glass globe wall lighting, LED glass globe wall lights, LED glass globe shade wall light, LED glass globe shade wall lights, LED glass globe shade wall lighting, LED glass wall light fixture, LED glass wall light fixtures, glass wall lighting, glass wall lighting fixture, glass wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass globe wall light, glass globe wall lighting, glass globe wall lights, glass globe shade wall light, glass globe shade wall lights, glass globe shade wall lighting, glass wall light fixture, glass wall light fixtures, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass wall lighting, glass wall lighting fixture, glass wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass globe wall light, glass globe wall lighting, glass globe wall lights, glass globe shade wall light, glass globe shade wall lights, glass globe shade wall lighting, glass wall light fixture, glass wall light fixtures, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass LED lighting, glass LED lighting fixture, glass LED lighting fixtures, glass LED shade, glass LED shades, glass shade LED light, glass shade LED lights, glass shade LED lighting, glass LED globe, glass LED globes, glass LED globe shade, glass LED globe shades, glass globe LED light, glass globe LED lighting, glass globe shade LED light, glass globe shade LED lights, glass globe shade LED lighting, glass LED light fixture, glass LED light fixtures, LED glass lighting, LED glass lighting fixture, LED glass lighting fixtures, LED glass shade, LED glass shades, LED glass shade light, LED glass shade lights, LED glass shade lighting, LED glass globe, LED glass globes, LED glass globe shade, LED glass globe shades, LED glass globe light, LED glass globe lighting, LED glass globe shade light, LED glass globe shade lights, LED glass globe shade lighting, LED glass light fixture, LED glass light fixtures, LED glass wall lighting, LED glass wall lighting fixture, LED glass wall lighting fixtures, LED glass shade wall light, LED glass shade wall lights, LED glass shade wall lighting, LED glass globe wall light, LED glass globe wall lighting, LED glass globe wall lights, LED glass globe shade wall light, LED glass globe shade wall lights, LED glass globe shade wall lighting, LED glass wall light fixture, LED glass wall light fixtures, glass LED wall lighting, glass LED wall lighting fixture, glass LED wall lighting fixtures, glass LED shade wall light, glass shade wall lights, glass shade LED wall lighting, glass globe LED wall light, glass globe LED wall lighting, glass globe LED wall lights, glass globe shade LED wall light, glass globe shade LED wall lights, glass globe shade LED wall lighting, glass LED wall light fixture, glass LED wall light fixtures, BLE-G-SCH10, BLE-G-SCH14, BLE-G-SCHCL10, BLE-G-SCHCL14, LED Schoolhouse collection, LED schoolhouse series, the LED schoolhouse collection, the LED schoolhouse series, LED School house collection, LED school house series, the LED school house collection, the LED school house series, primary LED Schoolhouse collection, primary LED schoolhouse series, the primary LED schoolhouse collection, the primary LED schoolhouse series, primary LED School house collection, primary LED school house series, the primary LED school house collection, the primary LED school house series, primary LED collection, primary LED series, the primary LED collection, the primary LED series, SPS-0175, SPS 0175, SPS0175, bleg, Primary schoolhouse gooseneck wall light, striped schoolhouse, striped schoolhouse light, striped schoolhouse light,	Primary LED Schoolhouse Gooseneck Light \| Barn Light Electric				515.000000	1547,1591,1847,1861,1925,2002,1939M	231398	Barn Light Electric Company	36	primary-schoolhouse-led-gooseneck-light	1920/1938/1939	B