Total Time	Avg Time	Count	Template
46 ms	46 ms	1	D:\Websites\marineindustrieswest.com\GroupCatProducts.cfm
31 ms	31 ms	1	D:/Websites/marineindustrieswest.com/design.cfm
16 ms	16 ms	1	D:/Websites/marineindustrieswest.com/Application.cfm
16 ms	16 ms	1	D:/Websites/marineindustrieswest.com/_SideBarCats.cfm
15 ms	15 ms	1	D:/Websites/marineindustrieswest.com/styles.cfm
0 ms	0 ms	1	D:/Websites/marineindustrieswest.com/ShoppingCart.cfm
0 ms	0 ms	4	D:/Websites/marineindustrieswest.com/_GetLookAndFeel.cfm
0 ms	0 ms	1	D:/Websites/marineindustrieswest.com/_PromoSideBar.cfm
0 ms	0 ms	1	D:/Websites/marineindustrieswest.com/_SideBarSearch.cfm
0 ms	0 ms	1	D:/Websites/marineindustrieswest.com/_shoppingcartlink.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
62 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

		SELECT	*
		FROM	area
		WHERE area_name = 'Catalog'
	

		SELECT *
		FROM tblGroups
		WHERE tblGroups.group_id = '9'
	

		SELECT LookAndFeel.*
		FROM LookAndFeelSets
		Left Join LookAndFeel on LookAndFeelSets.SetID = LookAndFeel.SetID
		
			Where SetActive = 1
		

	SELECT *
	FROM category_border_images
	WHERE border_image_active = 1

		SELECT *
		FROM tblGroups
		WHERE tblGroups.group_id = '9'
	

		SELECT LookAndFeel.*
		FROM LookAndFeelSets
		Left Join LookAndFeel on LookAndFeelSets.SetID = LookAndFeel.SetID
		
			Where SetActive = 1
		

		SELECT *
		FROM webpageMETAcontent
	

			SELECT title, meta_description, meta_keywords, cat_website_text
			FROM tblCategory
			WHERE catid='269'
		

		SELECT *
		FROM tblGroups
		WHERE tblGroups.group_id = '9'
	

		SELECT LookAndFeel.*
		FROM LookAndFeelSets
		Left Join LookAndFeel on LookAndFeelSets.SetID = LookAndFeel.SetID
		
			Where SetActive = 1
		

	SELECT *
	FROM tblinterfaceimages
	WHERE image_type = 'backdrop'
			   and image_active = 'yes'
			   and image_start_date <= {d '2020-07-10'}
			   and image_end_date >= {d '2020-07-10'} 

	SELECT *
	FROM website_background_images
	WHERE background_image_active_videos = 'Yes'

	SELECT *
	FROM website_background_images
	WHERE background_image_active_installation = 'Yes'

	SELECT *
	FROM website_background_images
	WHERE background_image_active_finishes = 'Yes'

	SELECT *
	FROM area
	WHERE area_active='Yes'

	Select tblpart.partid, tblpart.Description, tblpart.CatID, group_id
	From tblPart
	left join tblCategory on tblpart.catid = tblcategory.catid
	Where tblPart.Promote = 'yes' and tblPart.Active='yes' and tblPart.retail_view='yes'

	Select Title
	From SideBarPromoHeading
	Where Active = 'Yes'

	SELECT *
	FROM tblinterfaceimages
	WHERE image_type = 'backdrop'
			   
				   	and image_AltLookFeel = 0
			   
			   and image_active = 'yes'
			   and image_start_date <= {d '2020-07-10'}
			   and image_end_date >= {d '2020-07-10'} 

			SELECT *
			FROM tblinterfaceimages
			WHERE image_type = 'corner'
			   
				   	and image_AltLookFeel = 0
			   
			   and image_active = 'yes'
			   and image_start_date <= {d '2020-07-10'}
			   and image_end_date >= {d '2020-07-10'} 

		SELECT CatId, Title, CatUserDefinedSort
		FROM tblCategory
		left join tblgroups on tblcategory.group_id = tblgroups.group_id
		Where tblgroups.Active_Flag = 'Yes' and tblcategory.Active_Flag = 'Yes'
		ORDER by Title
	

				SELECT *
				FROM category_background_images
				WHERE background_image_active = 'Yes'
			   
				   	and background_image_AltLookFeel = 0
			   

	SELECT group_name
	FROM tblGroups
	WHERE tblGroups.group_id = '9'

	SELECT *
	FROM tblCategory
	WHERE tblcategory.CatID = '269'

			Select 0 as ProductGroup, tblPart.PartID, tblPart.CatID, Description, PartNum, Website_Text, EngravingOption, PricingTypeOverride, CategoryProducts_image_file,
			UnitPrice, OEMUnitPrice, DistributorUnitPrice, DealerUnitPrice, NoDiscount, NoRetailSale
			, UserDefinedSort as USD, '0' as AddOnProduct
			From tblPart
			
			Where
				CatId = '269'
				and Active='yes'
						
						and retail_view = 'Yes'
						
		UNION ALL
			Select 0 as ProductGroup, tblPart.PartID, tblPart.CatID, Description, PartNum, Website_Text, EngravingOption, PricingTypeOverride, CategoryProducts_image_file,
			UnitPrice, OEMUnitPrice, DistributorUnitPrice, DealerUnitPrice, NoDiscount, NoRetailSale
			, altCategories.UserDefinedSort as USD, altCategories.AddOn as AddOnProduct
			From AltCategories
			Left Join tblPart on AltCategories.PartID = TblPart.PartID
			
			Where
				AltCategories.CatId = '269'
				and Active='yes'
						
						and retail_view = 'Yes'
						
		UNION ALL
			Select 1 as ProductGroup, ProductGroups.ProductGroupID as PartID, ProductGroups.CategoryID as CatID, Description, ProductGroups.ProductGroupPN as PartNum, Website_Text, null as EngravingOption, 0 as PricingTypeOverride, CategoryProducts_image_file,
			0 as UnitPrice, 0 as OEMUnitPrice, 0 as DistributorUnitPrice, 0 as DealerUnitPrice, 0 as NoDiscount, 0 as NoRetailSale
			, SortOrder as USD, highlight as AddOnProduct
			From ProductGroups
			Where
				CategoryId = '269'
				and Active=1
						
						and retail_view = 'Yes'
						

			Order by USD, PartNum 

								SELECT *
								FROM tblCategory
								WHERE tblcategory.CatID = '269'
							

								SELECT cat_website_text, cat_products_override
								FROM tblCategory
								WHERE catid = '269'
							

									SELECT text_value
									FROM tblSiteText
									WHERE text_name = 'Category_Products_Text'
								

					SELECT *
					FROM RetailSale
				

			SELECT *
			FROM CategoryAudio
			WHERE catid = '269' and AudioActive = 1
		

		SELECT *
		FROM tblGroups
		WHERE tblGroups.group_id = '9'
	

		SELECT LookAndFeel.*
		FROM LookAndFeelSets
		Left Join LookAndFeel on LookAndFeelSets.SetID = LookAndFeel.SetID
		
			Where SetActive = 1
		

		SELECT *
		FROM WebsiteAudio
		WHERE page = 'groupcatproducts.cfm' and AudioActive = 1
	

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=128
CERT_SECRETKEYSIZE=3072
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
CERT_SERVER_SUBJECT=CN=www.marineindustrieswest.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Websites\marineindustrieswest.com\GroupCatProducts.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=128
HTTPS_SECRETKEYSIZE=3072
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
HTTPS_SERVER_SUBJECT=CN=www.marineindustrieswest.com
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.marineindustrieswest.com
HTTP_REFERER=
HTTP_URL=/groupcatproducts.cfm?group_id=9&CatID=269&maxitems=100&showdetail=1
HTTP_USER_AGENT=ColdFusion
LOCAL_ADDR=64.71.73.229
PATH_INFO=
PATH_TRANSLATED=D:\Websites\marineindustrieswest.com\GroupCatProducts.cfm
QUERY_STRING=group_id=9&CatID=269&maxitems=100&showdetail=1
REMOTE_ADDR=64.71.73.226
REMOTE_HOST=64.71.73.226
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/groupcatproducts.cfm
SERVER_NAME=www.marineindustrieswest.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Client Variables:
cfid=98003650
cftoken=9567e442d53c55ca-485FCC6C-F121-FF1A-F339FFF99D56A618
danacart=
hitcount=1
lastvisit={ts '2020-07-10 16:35:49'}
timecreated={ts '2020-07-10 16:35:49'}
urltoken=CFID=98003650&CFTOKEN=9567e442d53c55ca-485FCC6C-F121-FF1A-F339FFF99D56A618

Cookie Variables:
CFID=98003650
CFTOKEN=9567e442d53c55ca-485FCC6C-F121-FF1A-F339FFF99D56A618

Session Variables:
catalog=no
cfid=98003650
cftoken=9567e442d53c55ca-485FCC6C-F121-FF1A-F339FFF99D56A618
sessionid=DANAMARINE_98003650_9567e442d53c55ca-485FCC6C-F121-FF1A-F339FFF99D56A618
show_watermark=yes
urltoken=CFID=98003650&CFTOKEN=9567e442d53c55ca-485FCC6C-F121-FF1A-F339FFF99D56A618

URL Parameters:
CatID=269
group_id=9
maxitems=100
showdetail=1