Bay City, Michigan 48706
Front Page 09/20/2021 16:52 Log-In About us
Home Community Arts/Theater Business Schools Government Downtown
Local News Opinion Health/Fitness Events Groups & Non-Profits

Mid-Michigan News Service
Subscriber Services

Welcome MyBayCity.com Reader.
If you are a subscriber, use this form to login
E-mail
Password
A password is required for subscription updates.
If you forgot or don't know your password just leave this blank.
We'll give you some other options on the next screen.
If you are NOT A SUBSCRIBER:
Click here to return to Article 07579

Mid-Michigan News Service is a subsidiary of OJ Advertising, Inc. - Bay City, Michigan
--- Advertisments ---
     


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-0436 (1) 0   ID:Default   UserID:Default   Type:reader   R:x   PubID:mbC   NewspaperID:1561
  pid:1560   pd:11-18-2012   nd:2021-09-16   ax:2021-09-20   Site:5   ArticleID:07579   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-0436.cfm
Time Stamp 20-Sep-21 04:52 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
62 ms 62 ms 1 top level D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0436.cfm
46 ms 46 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-CategoryBox.cfm
16 ms 8 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Banner.cfm
16 ms 8 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-BannerTop.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-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-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
62 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:52:46.046
SELECT * FROM 	authors
	WHERE	AuthorUsername	 = 'xxx-xxx'
P3_CurrentPaper (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:52:46.046
SELECT *
	FROM Newspapers
	WHERE NewspaperID = '1561'
P3_PublicationDef (Datasource=MyBayCity, Time=15ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:52:46.046
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:52:46.046
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:52:46.046
SELECT *
	FROM Newspapers
	WHERE ActivatedDate IS NOT NULL
	AND NPR_PublicationID = 'mbC'
	ORDER BY NewspaperID DESC
P3q_CurrSubscriber (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:52:46.046
SELECT * from Subscribers
		WHERE subscriberid ='9191919'
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTopInit.cfm @ 16:52:46.046
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:52:46.046
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:52:46.046
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = 'freedom'
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '002'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '003'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '004'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '006'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '009'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '012'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '017'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '019'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '039'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '074'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:52:46.046
SELECT *
		FROM Categories
		WHERE CategoryID = '083'
P3_AvailableBanners (Datasource=Advertising, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 16:52:46.046
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:52:46.046
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:52:46.046
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:52:46.046
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:52:46.046
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:52:46.046
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'


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-0436.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-0436.cfm?P3_NewspaperID=1561&P3_articleID=07579
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-0436.cfm
QUERY_STRING=P3_NewspaperID=1561&P3_articleID=07579
REMOTE_ADDR=3.230.144.31
REMOTE_HOST=3.230.144.31
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/P3_V2/P3V3-0436.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=7704877
CFTOKEN=7ecc646e2b85004e-31C860F7-9826-3EC6-A2B1EE6B79E7661B
Session Variables:
authortype=unknown
cfid=7704877
cftoken=7ecc646e2b85004e-31C860F7-9826-3EC6-A2B1EE6B79E7661B
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_7704877_7ecc646e2b85004e-31C860F7-9826-3EC6-A2B1EE6B79E7661B
urltoken=CFID=7704877&CFTOKEN=7ecc646e2b85004e-31C860F7-9826-3EC6-A2B1EE6B79E7661B
URL Parameters:
P3_NewspaperID=1561
P3_articleID=07579
Debug Rendering Time: 16 ms