Total Time	Avg Time	Count	Template
219 ms	219 ms	1	D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\p3v3-0152.cfm
156 ms	156 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0152-BodyLeft.cfm
32 ms	1 ms	27	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0152-Pour-Story.cfm
31 ms	31 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t010.cfm
16 ms	16 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-CategoryBox.cfm
15 ms	15 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTop.cfm
15 ms	15 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerWide.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0120-Ad.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0152-BodyRight.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0152-Columnist.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0152-LeftAdBlock.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0152-PaidCol-Block.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerSubDate.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTopInit.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerWideInit.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GOAD.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GoogleAnalytics.cfm
0 ms	0 ms	2	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-MBCcolor.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-MenuBox.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-SitePal.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Xparkapalooza-2015.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t900.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/_Configuration.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/scripts/p3_v2/Application.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT * FROM 	authors
	WHERE	AuthorUsername	 = 'xxx-xxx'

SELECT *
	FROM P3_tPublications
	WHERE PUB_PublicationID = 'mbC'

SELECT * FROM Newspapers 
	WHERE NPR_PublicationID = 'mbC' and NPR_AutoPub		=   '4' and NewspaperID		=   '1'

SELECT *
	FROM Newspapers
	WHERE NewspaperID = '1561'

SELECT *
	FROM P3_tPublications
	WHERE PUB_PublicationID = 'mbC'

SELECT *
	FROM Sites
	WHERE Name LIKE '%MyBayCity.com%'

SELECT *
	FROM Newspapers
	WHERE ActivatedDate IS NOT NULL
	AND NPR_PublicationID = 'mbC'
	ORDER BY NewspaperID DESC

SELECT * from Subscribers
		WHERE subscriberid ='9191919'

SELECT	* FROM Banners
		WHERE ExpDate > '2021-10-20'
		  AND Banner_Type = 'W'
		ORDER BY StartDate

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'freedom'

SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = 'freedom'
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-10-20'

SELECT *
		FROM Categories
		WHERE CategoryID = '001'

SELECT *
		FROM Categories
		WHERE CategoryID = '002'

SELECT *
		FROM Categories
		WHERE CategoryID = '003'

SELECT *
		FROM Categories
		WHERE CategoryID = '004'

SELECT *
		FROM Categories
		WHERE CategoryID = '005'

SELECT *
		FROM Categories
		WHERE CategoryID = '007'

SELECT *
		FROM Categories
		WHERE CategoryID = '012'

SELECT *
		FROM Categories
		WHERE CategoryID = '017'

SELECT *
		FROM Categories
		WHERE CategoryID = '020'

SELECT *
		FROM Categories
		WHERE CategoryID = '021'

SELECT *
		FROM Categories
		WHERE CategoryID = '039'

SELECT *
		FROM Categories
		WHERE CategoryID = '073'

SELECT *
		FROM Categories
		WHERE CategoryID = '074'

SELECT *
		FROM Categories
		WHERE CategoryID = '083'

SELECT *
		FROM Categories
		WHERE CategoryID = '090'

SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-10-20'	
		  AND Banner_Type = 'W'
		ORDER BY StartDate

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxxxxx'

SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-10-20'

SELECT *
			FROM articles
			WHERE  ArticleID = '11594'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11591'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11311'

SELECT *
			FROM categories
			WHERE  CategoryID = '20'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Sgkent'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11585'

SELECT *
			FROM categories
			WHERE  CategoryID = '83'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'admin'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11583'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11580'

SELECT *
			FROM categories
			WHERE  CategoryID = '83'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Library'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11577'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11574'

SELECT *
			FROM categories
			WHERE  CategoryID = '4'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'LynnNaylor'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11570'

SELECT *
			FROM categories
			WHERE  CategoryID = '17'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Sgkent'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11592'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11590'

SELECT *
			FROM categories
			WHERE  CategoryID = '1'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'admin'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11588'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11586'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11582'

SELECT *
			FROM categories
			WHERE  CategoryID = '1'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'admin'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11579'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11576'

SELECT *
			FROM categories
			WHERE  CategoryID = '17'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Sgkent'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11573'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11558'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11593'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11589'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11587'

SELECT *
			FROM categories
			WHERE  CategoryID = '73'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Great'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11584'

SELECT *
			FROM categories
			WHERE  CategoryID = '83'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Library'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11581'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11578'

SELECT *
			FROM categories
			WHERE  CategoryID = '83'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Library'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11575'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11572'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

SELECT *
			FROM articles
			WHERE  ArticleID = ' 11569'

SELECT *
			FROM categories
			WHERE  CategoryID = '3'

SELECT *
			FROM Authors
			WHERE  AuthorUsername  = 'Kathy'

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\p3v3-0152.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=mybaycity.com
HTTP_REFERER=
HTTP_URL=/scripts/p3_v2/p3v3-0152.cfm?P3_NewspaperID=1561
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=192.168.162.152
PATH_INFO=
PATH_TRANSLATED=D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\p3v3-0152.cfm
QUERY_STRING=P3_NewspaperID=1561
REMOTE_ADDR=3.236.51.151
REMOTE_HOST=3.236.51.151
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/p3_v2/p3v3-0152.cfm
SERVER_NAME=mybaycity.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=9681083
CFTOKEN=a2c06be6fb2015dd-43D919C6-FDAB-D3E7-CAC5E415A940862F

Session Variables:
authortype=unknown
cfid=9681083
cftoken=a2c06be6fb2015dd-43D919C6-FDAB-D3E7-CAC5E415A940862F
login_role=x
login_status=firsttime
login_type=reader
login_userid=Default
loginid=Default
p3_priornewspaperdate=2012-11-18 00:00:00.0
p3_priornewspaperid=1560
p3v2_home=mybaycity.com
p3v2_privdiag=0
p3v2_publication=mbC
sessionid=P3V2SYS_9681083_a2c06be6fb2015dd-43D919C6-FDAB-D3E7-CAC5E415A940862F
urltoken=CFID=9681083&CFTOKEN=a2c06be6fb2015dd-43D919C6-FDAB-D3E7-CAC5E415A940862F

URL Parameters:
P3_NewspaperID=1561