Bay City, Michigan 48706
Front Page 09/20/2021 15:33 Log-In About us

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:

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:noPaperID
  pid:1560   pd:11-18-2012   nd:2021-09-16   ax:2021-09-20   Site:5   ArticleID:0   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 03:33 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
47 ms 47 ms 1 top level D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0436.cfm
31 ms 31 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t010.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
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
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-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
47 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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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 @ 15:33:35.035
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=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-0436.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-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=7700721
CFTOKEN=16ffdaf4be478c7a-2EF374F9-0C57-937F-0C9C828EC76DB331
Session Variables:
authortype=unknown
cfid=7700721
cftoken=16ffdaf4be478c7a-2EF374F9-0C57-937F-0C9C828EC76DB331
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_7700721_16ffdaf4be478c7a-2EF374F9-0C57-937F-0C9C828EC76DB331
urltoken=CFID=7700721&CFTOKEN=16ffdaf4be478c7a-2EF374F9-0C57-937F-0C9C828EC76DB331
URL Parameters:
P3_NewspaperID=noPaperID
Debug Rendering Time: 15 ms