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

Query time 0.00141

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 = 65137 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": 5,
      "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
65137	BLE-PMTD-WHS-LED		E	C	M	W	A	0	A	1	2398.00	1000	0.000	0	0	0	0.00	0	1588263997	0	N	N	N	D	N	R	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;}	1767811350	Price increased 5% from $2077 to $2180 - DC 5/28/21 Price increased 10% from $2180 to $2398 - DC 6/2/22	Y		none	none	2497,2499,2501	BLE-PMTD	{"22396":10,"22645":12,"22644":11,"22643":10}	0	0	0	0	1	0	0	0	0	1	0.00	0	en	The Original™ LED Triple Post Mount Light			<p>Simultaneously brightening a space and imparting a classic aesthetic, The Original™ becomes the highlight of any outdoor décor. With its timeless, vintage-inspired profile, this fixture easily conforms to today’s most popular styles. Numerous finish options help The Original™ standout or fit in with a company’s branded look. For residential applications, post mount fixtures fill exterior spaces with warm light, helping every home feel safe, secure, and welcoming. <br /><br />This post mount integrates LED components into its design. An efficient source of light, this technology transforms electricity into illumination while producing little waste. Thanks to its LEDs, The Original™ reduces costs and meets green building requirements.</p> <p>\|break\|</p> <ul> <li>This durable outdoor light includes a hand-built, American-made RLM warehouse shade.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Learn the differences between our Nautical LED and Standard LED lights over on our <a href="https://www.barnlight.com/inspiration/lighting-101-comparing-standard-led-nautical-led/" target="_blank">blog</a>!</li> </ul>		Give any home or business a new look with the stylish, energy efficient Original™ LED Post Mount Light! Handcrafted in the USA and fully customizable!	BLE-PMS-WHS, Sky Chief Single Post Mount Exterior Light, Sky Chief, BLE-PM1-WHS, single post, post mount, exterior light, driveway light, hook post, post mount light, pole light, walkway light, park light, garden post light, post light, post light, pole mount, BLE-PMS-WHS14, BLE-PMS-WHS16, outdoor lighting, outdoor post light, copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, BLE-PMSD-WHS, BLE-PMS-WHS, BLE-PMS-WHS-BRS, BLE-PMSD-WHS-COP, BLE-PMS-WHS-COP, BLE-PMSD-WHS-BRS, Sky Chief 3-Light Brass Post Mount Decorative Exterior Light, Sky Chief 3-Light Brass Post Mount Decorative Exterior Lights, Sky Chief 3-Light Brass Post Mount Decorative Exterior Lighting, Sky Chief 3-Light Brass Post Mount Decorative Light, Sky Chief 3-Light Brass Post Mount Decorative Lights, Sky Chief 3-Light Brass Post Mount Decorative Lighting, Sky Chief 3-Light Brass Decorative Exterior Light, Sky Chief 3-Light Brass Decorative Exterior Lights, Sky Chief 3-Light Brass Decorative Exterior Lighting, Sky Chief 3-Light Brass Decorative Light, Sky Chief 3-Light Brass Decorative Lights, Sky Chief 3-Light Brass Decorative Lighting, Sky Chief 3-Light Brass Post Mount Light, Sky Chief 3-Light Brass Post Mount Lights, Sky Chief 3-Light Brass Post Mount Lighting, Sky Chief 3 Light Brass Post Mount Decorative Exterior Light, Sky Chief 3 Light Brass Post Mount Decorative Exterior Lights, Sky Chief 3 Light Brass Post Mount Decorative Exterior Lighting, Sky Chief 3 Light Brass Post Mount Decorative Light, Sky Chief 3 Light Brass Post Mount Decorative Lights, Sky Chief 3 Light Brass Post Mount Decorative Lighting, Sky Chief 3 Light Brass Decorative Exterior Light, Sky Chief 3 Light Brass Decorative Exterior Lights, Sky Chief 3 Light Brass Decorative Exterior Lighting, Sky Chief 3 Light Brass Decorative Light, Sky Chief 3 Light Brass Decorative Lights, Sky Chief 3 Light Brass Decorative Lighting, Sky Chief 3 Light Brass Post Mount Light, Sky Chief 3 Light Brass Post Mount Lights, Sky Chief 3 Light Brass Post Mount Lighting, 3-light post mount, 3-light post mounts, 3 light post mount, 3 light post mounts, 3-light post mount light, 3-light post mount lights, 3-light post mount lighting, brass 3-light post mount, brass 3-light post mounts, brass 3-light post mount light, brass 3-light post mount lights, brass 3-light post mount lighting, 3-light brass post mount, 3-light brass post mounts, 3-light brass post mount light, 3-light brass post mount lights, 3-light brass post mount lighting, Sky Chief, Sky Chief post mount, Sky Chief post mounts, Sky Chief post mount light, Sky Chief post mount lights, Sky Chief post mount lighting, 3-light, 3 light, triple, triple light, triple lights, triple lighting, triple post mount light, triple post mount lights, triple post mount lighting, triple post mount light, triple post mount lights, triple post mount lighting, brass triple post mount, brass triple post mounts, brass triple post mount light, brass triple post mount lights, brass triple post mount lighting, triple brass post mount, triple brass post mounts, triple brass post mount light, triple brass post mount lights, triple brass post mount lighting, 3 light post mount light, 3 light post mount lights, 3 light post mount lighting, brass 3 light post mount, brass 3 light post mounts, brass 3 light post mount light, brass 3 light post mount lights, brass 3 light post mount lighting, 3 light brass post mount, 3 light brass post mounts, 3 light brass post mount light, 3 light brass post mount lights, 3 light brass post mount lighting, BLE-PMTD-WHS-BRS, BLE-PMTD-WHS-COP, Sky Chief 3-Light Copper Post Mount Decorative Exterior Light, Sky Chief 3-Light Copper Post Mount Decorative Exterior Lights, Sky Chief 3-Light Copper Post Mount Decorative Exterior Lighting, Sky Chief 3-Light Copper Post Mount Decorative Light, Sky Chief 3-Light Copper Post Mount Decorative Lights, Sky Chief 3-Light Copper Post Mount Decorative Lighting, Sky Chief 3-Light Copper Decorative Exterior Light, Sky Chief 3-Light Copper Decorative Exterior Lights, Sky Chief 3-Light Copper Decorative Exterior Lighting, Sky Chief 3-Light Copper Decorative Light, Sky Chief 3-Light Copper Decorative Lights, Sky Chief 3-Light Copper Decorative Lighting, Sky Chief 3-Light Copper Post Mount Light, Sky Chief 3-Light Copper Post Mount Lights, Sky Chief 3-Light Copper Post Mount Lighting, Sky Chief 3 Light Copper Post Mount Decorative Exterior Light, Sky Chief 3 Light Copper Post Mount Decorative Exterior Lights, Sky Chief 3 Light Copper Post Mount Decorative Exterior Lighting, Sky Chief 3 Light Copper Post Mount Decorative Light, Sky Chief 3 Light Copper Post Mount Decorative Lights, Sky Chief 3 Light Copper Post Mount Decorative Lighting, Sky Chief 3 Light Copper Decorative Exterior Light, Sky Chief 3 Light Copper Decorative Exterior Lights, Sky Chief 3 Light Copper Decorative Exterior Lighting, Sky Chief 3 Light Copper Decorative Light, Sky Chief 3 Light Copper Decorative Lights, Sky Chief 3 Light Copper Decorative Lighting, Sky Chief 3 Light Copper Post Mount Light, Sky Chief 3 Light Copper Post Mount Lights, Sky Chief 3 Light Copper Post Mount Lighting, 3-light post mount, 3-light post mounts, 3 light post mount, 3 light post mounts, 3-light post mount light, 3-light post mount lights, 3-light post mount lighting, copper 3-light post mount, copper 3-light post mounts, copper 3-light post mount light, copper 3-light post mount lights, copper 3-light post mount lighting, 3-light copper post mount, 3-light copper post mounts, 3-light copper post mount light, 3-light copper post mount lights, 3-light copper post mount lighting, Sky Chief, Sky Chief post mount, Sky Chief post mounts, Sky Chief post mount light, Sky Chief post mount lights, Sky Chief post mount lighting, 3-light, 3 light, triple, triple light, triple lights, triple lighting, triple post mount light, triple post mount lights, triple post mount lighting, triple post mount light, triple post mount lights, triple post mount lighting, copper triple post mount, copper triple post mounts, copper triple post mount light, copper triple post mount lights, copper triple post mount lighting, triple copper post mount, triple copper post mounts, triple copper post mount light, triple copper post mount lights, triple copper post mount lighting, 3 light post mount light, 3 light post mount lights, 3 light post mount lighting, copper 3 light post mount, copper 3 light post mounts, copper 3 light post mount light, copper 3 light post mount lights, copper 3 light post mount lighting, 3 light copper post mount, 3 light copper post mounts, 3 light copper post mount light, 3 light copper post mount lights, 3 light copper post mount lighting, sky chief, sky chief post, sky chief triple, pmtd, triple post, 3 light post mount, skychief post, The Original Triple Post Mount Light, Original Triple Post Mount Light, The Original Triple Post Mount, Original Triple Post Mount, Original Triple Post Mount, Original Triple Post Mount Light, Original Post Mount Light, Original Post Mount, Original Triple Post Mount, Original, Original Post, The Original, original, new led post, BLE-PMTD-WHS14, BLE-PMTD-WHS16, original+led+post+mount, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, SPS-0448, SPS0448, SPS 0448, original led series, original™ led series, originaltm led series, original led collection, original™ led collection, originaltm led collection, the original led series, the original™ led series, the originaltm led series, the original led collection, the original™ led collection, the originaltm led collection, SPS-0269, SPS 0269, SPS0269, The Original Post Mount Collection, The Original™ Post Mount Collection, The Originaltm post mount collection, The Original Post Mount series, The Original™ Post Mount series, The Originaltm post mount series, Original Post Mount Collection, Original™ Post Mount Collection, Originaltm post mount collection, Original Post Mount series, Original™ Post Mount series, Originaltm post mount series, SPS-0589, SPS 0589, SPS0589, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, LED post top, original led post mount, BLE PMS, lamp post lights, barn lights on pole, original led triple, outdoor pole lights, light post lighting, H-15114, H-15116, classic warehouse shade post light rlm, classic warehouse shade,	The Original™ LED Triple Post Mount Light \| Barn Light Electric				2398.000000	1858,2001,1936M	108647	Barn Light Electric Company	6	the-original-led-triple-post-mount-light	1920/1933/1936	B