MyBayCity.com Click Here

Bay City, Michigan 48706

Front Page

09/20/2021 16:17

Log-In

About us

www.mybaycity.com Current Advertisers

E-Mail to: adsales@MyBayCity.Com

Freedom Banner

E-Mail to: adsales@MyBayCity.Com

--- Featured Advertisments ---

0360 nd 09-16-2021

12/31/2020 P3v3-0200-Ad.cfm

SPONSORED LINKS

12/31/2020 drop ads P3v3-0200-Ad.cfm

Designed at OJ Advertising, Inc. (V3) (v3) Software by Mid-Michigan Computer Consultants

Bay City, Michigan USA
All Photographs and Content Copyright © 1998 - 2021 by OJA/MMCC. They may be used by permission only.
P3V3-0360 (1) 0 ID:Default UserID:Default Type:reader R:x PubID:mbC NewspaperID:noPaperID
pid:1560 pd:11-18-2012 nd:2021-09-16 ax:2021-09-20 Site:5 MaxA: 999999 MaxAA: 999999
CCBot/2.0 (https://commoncrawl.org/faq/)

Debugging Information

ColdFusion Server Enterprise	2021,0,0,323925
Template	/scripts/P3_V2/P3V3-0360.cfm
Time Stamp	20-Sep-21 04:17 PM
Locale	English (US)
User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP	3.230.144.31
Host Name	3.230.144.31

Execution Time

Total Time	Avg Time	Count	Template
94 ms	94 ms	1	D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0360.cfm
47 ms	47 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox.cfm
32 ms	32 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t010.cfm
31 ms	31 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox2.cfm
16 ms	16 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTop.cfm
16 ms	16 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTopInit.cfm
15 ms	8 ms	2	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Banner.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0200-Ad.cfm
0 ms	0 ms	2	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerInit.cfm
0 ms	0 ms	1	D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-CategoryBox.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	3	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-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
15 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
109 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

MBC_GetUser (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\Application.cfm @ 16:17:11.011

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

P3_CurrentPaper (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:17:11.011

SELECT *
	FROM Newspapers
	WHERE NewspaperID = 'noPaperID'

P3_PublicationDef (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:17:11.011

SELECT *
	FROM P3_tPublications
	WHERE PUB_PublicationID = 'mbC'

P3_Get_SiteInfo (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:17:11.011

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

P3_PriorPaper (Datasource=mybaycity, Time=0ms, Records=2) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:17:11.011

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

P3q_CurrSubscriber (Datasource=MyBayCity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:17:11.011

SELECT * from Subscribers
		WHERE subscriberid ='9191919'

P3_AvailableBanners (Datasource=Advertising, Time=16ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTopInit.cfm @ 16:17:11.011

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

P3_GetBanner (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTop.cfm @ 16:17:11.011

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'freedom'

P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTop.cfm @ 16:17:11.011

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

P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0360.cfm @ 16:17:11.011

SELECT	*
	FROM Banners
	WHERE ExpDate > '2021-09-20'
	
	ORDER BY BannerUserName

P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 16:17:11.011

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

P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 16:17:11.011

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxx'

P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 16:17:11.011

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

P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 16:17:11.011

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

P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 16:17:11.011

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxx'

P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 16:17:11.011

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

P3_LogThesePubs (Datasource=MyBayCity, Time=16ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 16:17:11.011

SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID

P3_LogThesePubs (Datasource=MyBayCity, Time=0ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID

P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Frankenmuth'
		  and tLOG_Date = '2021-09-19'

P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Frankenmuth'
			  and tLOG_Date >= '2021-08-19'

P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Freeland'
		  and tLOG_Date = '2021-09-19'

P3_Pub30DayLog (Datasource=MyBayCity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Freeland'
			  and tLOG_Date >= '2021-08-19'

P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Gower'
		  and tLOG_Date = '2021-09-19'

P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Gower'
			  and tLOG_Date >= '2021-08-19'

P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MBC'
		  and tLOG_Date = '2021-09-19'

P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MBC'
			  and tLOG_Date >= '2021-08-19'

P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MTCN'
		  and tLOG_Date = '2021-09-19'

P3_Pub30DayLog (Datasource=MyBayCity, Time=15ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MTCN'
			  and tLOG_Date >= '2021-08-19'

P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Pinconning'
		  and tLOG_Date = '2021-09-19'

P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 16:17:11.011

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Pinconning'
			  and tLOG_Date >= '2021-08-19'

P3_PubCurrentLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 16:17:11.011

SELECT *
	FROM P3_tLog
	WHERE tLOG_RecordType = 'P'
	  and tLOG_Date = '2021-09-19'

Scope Variables

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-0360.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=www.mybaycity.com
HTTP_REFERER=
HTTP_URL=/scripts/P3_V2/P3V3-0360.cfm?P3_NewspaperID=noPaperID
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-0360.cfm
QUERY_STRING=P3_NewspaperID=noPaperID
REMOTE_ADDR=3.230.144.31
REMOTE_HOST=3.230.144.31
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/P3_V2/P3V3-0360.cfm
SERVER_NAME=www.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=7703198
CFTOKEN=1815b2b38277f1c9-3082976E-D612-1D50-47FA17688C672807

Session Variables:
authortype=unknown
cfid=7703198
cftoken=1815b2b38277f1c9-3082976E-D612-1D50-47FA17688C672807
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=www.mybaycity.com
p3v2_privdiag=0
p3v2_publication=mbC
sessionid=P3V2SYS_7703198_1815b2b38277f1c9-3082976E-D612-1D50-47FA17688C672807
urltoken=CFID=7703198&CFTOKEN=1815b2b38277f1c9-3082976E-D612-1D50-47FA17688C672807

URL Parameters:
P3_NewspaperID=noPaperID

Debug Rendering Time: 16 ms