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

Query time 0.00185

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 = 64365 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": 6,
      "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
64365	BLE-C-CYLV	P	E	C	M	A	A	0	A	1	200.00	1000	0.000	0	0	0	0.00	0	1516121965	0	N	N	N	D	N	R	N	N	N	Y	10	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;}	1768927680	Price increased by 5% from $172 to $181 - DC 5/27/21 Price increased by 10% from $181 to $200 - DC 5/20/22	Y		none	none	710,711	BLE-C-CYLV	{"21970":3,"21954":5,"22033":6,"22903":8,"21941":10,"23553":6,"23858":5,"23859":5,"23860":5}	1051256	0	0	0	0	0	0	0	0	1	0.00	0	en	Venice Cylinder Cord Pendant Light			<p>Representative of the latest trends and styles, the Venice Cylinder Pendant helps homeowners, professional designers, and businesses implement unique, fashionable décors. With its clean lines and eye-catching profile, the Venice’s chic approach offers a contemporary update to any setting, while still fitting in with the various looks commonly found in modern homes. Decorative slots, offered in several creative patterns and designs, elevate the pendant’s aesthetic with striking details and touches of uplight.</p> <p>Reinforced by our sincere commitment to quality, the Venice’s shade is constructed entirely from commercial-grade materials. With an abundance of finish colors, cord styles, and other customization options, it’s easy to personalize a pendant light for your space!</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 Venice Cylinder Pendant Light over on our<span> <a href="https://www.barnlight.com/inspiration/new-cylinder-pendant-lights-exude-modern-style/" target="_blank">blog</a></span>!</li> </ul>		A modern shape and unique slot shapes! The Venice is ideal for residential spaces and commercial applications. Bring hand-crafted and American made lights to your space!	BLE-C-CYLV, The Venice Cylinder Cord Hung Pendant, The Venice Cylinder Cord Hung Pendants, The Venice Cylinder Cord Hung Pendant Light, The Venice Cylinder Cord Hung Pendant Lights, The Venice Cylinder Cord Hung Pendant Lighting, The Venice Cylinder Cord Hung Ceiling Pendant, The Venice Cylinder Cord Hung Ceiling Pendants, The Venice Cylinder Cord Hung Ceiling Light, The Venice Cylinder Cord Hung Ceiling Lights, The Venice Cylinder Cord Hung Ceiling Lighting, The Venice Cylinder Cord Hung Light, The Venice Cylinder Cord Hung Lights, The Venice Cylinder Cord Hung Lighting, Venice Cylinder Cord Hung Pendant, Venice Cylinder Cord Hung Pendants, Venice Cylinder Cord Hung Pendant Light, Venice Cylinder Cord Hung Pendant Lights, Venice Cylinder Cord Hung Pendant Lighting, Venice Cylinder Cord Hung Ceiling Pendant, Venice Cylinder Cord Hung Ceiling Pendants, Venice Cylinder Cord Hung Ceiling Light, Venice Cylinder Cord Hung Ceiling Lights, Venice Cylinder Cord Hung Ceiling Lighting, Venice Cylinder Cord Hung Light, Venice Cylinder Cord Hung Lights, Venice Cylinder Cord Hung Lighting, The Venice Cylinder Pendant, The Venice Cylinder Pendants, The Venice Cylinder Pendant Light, The Venice Cylinder Pendant Lights, The Venice Cylinder Pendant Lighting, The Venice Cylinder Ceiling Pendant, The Venice Cylinder Ceiling Pendants, The Venice Cylinder Ceiling Light, The Venice Cylinder Ceiling Lights, The Venice Cylinder Ceiling Lighting, The Venice Cylinder Light, The Venice Cylinder Lights, The Venice Cylinder Lighting, Venice Cylinder Pendant, Venice Cylinder Pendants, Venice Cylinder Pendant Light, Venice Cylinder Pendant Lights, Venice Cylinder Pendant Lighting, Venice Cylinder Ceiling Pendant, Venice Cylinder Ceiling Pendants, Venice Cylinder Ceiling Light, Venice Cylinder Ceiling Lights, Venice Cylinder Ceiling Lighting, Venice Cylinder Light, Venice Cylinder Lights, Venice Cylinder Lighting, The Venice Cylinder Cord Mount Pendant, The Venice Cylinder Cord Mount Pendants, The Venice Cylinder Cord Mount Pendant Light, The Venice Cylinder Cord Mount Pendant Lights, The Venice Cylinder Cord Mount Pendant Lighting, The Venice Cylinder Cord Mount Ceiling Pendant, The Venice Cylinder Cord Mount Ceiling Pendants, The Venice Cylinder Cord Mount Ceiling Light, The Venice Cylinder Cord Mount Ceiling Lights, The Venice Cylinder Cord Mount Ceiling Lighting, The Venice Cylinder Cord Mount Light, The Venice Cylinder Cord Mount Lights, The Venice Cylinder Cord Mount Lighting, Venice Cylinder Cord Mount Pendant, Venice Cylinder Cord Mount Pendants, Venice Cylinder Cord Mount Pendant Light, Venice Cylinder Cord Mount Pendant Lights, Venice Cylinder Cord Mount Pendant Lighting, Venice Cylinder Cord Mount Ceiling Pendant, Venice Cylinder Cord Mount Ceiling Pendants, Venice Cylinder Cord Mount Ceiling Light, Venice Cylinder Cord Mount Ceiling Lights, Venice Cylinder Cord Mount Ceiling Lighting, Venice Cylinder Cord Mount Light, Venice Cylinder Cord Mount Lights, Venice Cylinder Cord Mount Lighting, The Venice Cord Mount Pendant, The Venice Cord Mount Pendants, The Venice Cord Mount Pendant Light, The Venice Cord Mount Pendant Lights, The Venice Cord Mount Pendant Lighting, The Venice Cord Mount Ceiling Pendant, The Venice Cord Mount Ceiling Pendants, The Venice Cord Mount Ceiling Light, The Venice Cord Mount Ceiling Lights, The Venice Cord Mount Ceiling Lighting, The Venice Cord Mount Light, The Venice Cord Mount Lights, The Venice Cord Mount Lighting, Venice Cord Mount Pendant, Venice Cord Mount Pendants, Venice Cord Mount Pendant Light, Venice Cord Mount Pendant Lights, Venice Cord Mount Pendant Lighting, Venice Cord Mount Ceiling Pendant, Venice Cord Mount Ceiling Pendants, Venice Cord Mount Ceiling Light, Venice Cord Mount Ceiling Lights, Venice Cord Mount Ceiling Lighting, Venice Cord Mount Light, Venice Cord Mount Lights, Venice Cord Mount Lighting, The Venice Cord Hung Pendant, The Venice Cord Hung Pendants, The Venice Cord Hung Pendant Light, The Venice Cord Hung Pendant Lights, The Venice Cord Hung Pendant Lighting, The Venice Cord Hung Ceiling Pendant, The Venice Cord Hung Ceiling Pendants, The Venice Cord Hung Ceiling Light, The Venice Cord Hung Ceiling Lights, The Venice Cord Hung Ceiling Lighting, The Venice Cord Hung Light, The Venice Cord Hung Lights, The Venice Cord Hung Lighting, Venice Cord Hung Pendant, Venice Cord Hung Pendants, Venice Cord Hung Pendant Light, Venice Cord Hung Pendant Lights, Venice Cord Hung Pendant Lighting, Venice Cord Hung Ceiling Pendant, Venice Cord Hung Ceiling Pendants, Venice Cord Hung Ceiling Light, Venice Cord Hung Ceiling Lights, Venice Cord Hung Ceiling Lighting, Venice Cord Hung Light, Venice Cord Hung Lights, Venice Cord Hung Lighting, The Cylinder Cord Hung Pendant, The Cylinder Cord Hung Pendants, The Cylinder Cord Hung Pendant Light, The Cylinder Cord Hung Pendant Lights, The Cylinder Cord Hung Pendant Lighting, The Cylinder Cord Hung Ceiling Pendant, The Cylinder Cord Hung Ceiling Pendants, The Cylinder Cord Hung Ceiling Light, The Cylinder Cord Hung Ceiling Lights, The Cylinder Cord Hung Ceiling Lighting, The Cylinder Cord Hung Light, The Cylinder Cord Hung Lights, The Cylinder Cord Hung Lighting, Cylinder Cord Hung Pendant, Cylinder Cord Hung Pendants, Cylinder Cord Hung Pendant Light, Cylinder Cord Hung Pendant Lights, Cylinder Cord Hung Pendant Lighting, Cylinder Cord Hung Ceiling Pendant, Cylinder Cord Hung Ceiling Pendants, Cylinder Cord Hung Ceiling Light, Cylinder Cord Hung Ceiling Lights, Cylinder Cord Hung Ceiling Lighting, Cylinder Cord Hung Light, Cylinder Cord Hung Lights, Cylinder Cord Hung Lighting, The Cylinder Pendant, The Cylinder Pendants, The Cylinder Pendant Light, The Cylinder Pendant Lights, The Cylinder Pendant Lighting, The Cylinder Ceiling Pendant, The Cylinder Ceiling Pendants, The Cylinder Ceiling Light, The Cylinder Ceiling Lights, The Cylinder Ceiling Lighting, The Cylinder Light, The Cylinder Lights, The Cylinder Lighting, Cylinder Pendant, Cylinder Pendants, Cylinder Pendant Light, Cylinder Pendant Lights, Cylinder Pendant Lighting, Cylinder Ceiling Pendant, Cylinder Ceiling Pendants, Cylinder Ceiling Light, Cylinder Ceiling Lights, Cylinder Ceiling Lighting, Cylinder Light, Cylinder Lights, Cylinder Lighting, cylinder, venice, cylinder pendant, cylinder pendants, cylinder collection, venice, cylinder, cylinders, cylinders pendant, BLE-C-CYLV-SML, BLE-C-CYLV-LRG, venice pendant, venice pendants, narrow slot vent, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded,	Venice Cylinder Cord Pendant Light \| Barn Light Electric				200.000000	1542,1611,1701,1745,2002,1889M	649042	Barn Light Electric Company	27	venice-cylinder-pendant-light	1887/1888/1889	B