Skating Rink Directory - RinkTime - We are All About Rinks! Get Analyzed - Get Analyzed by Keith Primeau
  Home | Tournaments and Events | RinkTime Blog | News/Blogs | Forums | Videos | Community | Add Rink | Rink Staff  

Green County WI Skating Rink, Skating Arena & Hockey Rink Directory




 
Skating Rinks, Skating Arenas by City
 
Monroe      

 
Skating Rinks, Skating Arenas
 
Alpine Curling Club in Monroe ICE
The Roller Den in Monroe ROLLER
StateLine Ice & Community Expo (slice) in Monroe ICE

Top User-Rated Rinks
- No Rated Rinks -

 

Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /skating_rinks/wi/green_county_wi_skating_rinks_arenas.cfm
Time Stamp 05-Sep-08 11:56 PM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.103.63.60
Host Name 38.103.63.60

Execution Time

Total Time Avg Time Count Template
281 ms 281 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequest(/skating_rinks/wi/green_county_wi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
250 ms 250 ms 1 C:\WWW\v2\skating_rinks\template_County.cfm
250 ms 250 ms 1 top level C:\WWW\v2\skating_rinks\wi\green_county_wi_skating_rinks_arenas.cfm
125 ms 125 ms 1 C:\WWW\v2\skating_rinks\dsp_AdvertisementBanner.cfm
125 ms 125 ms 1 C:\WWW\v2\skating_rinks\dsp_Header.cfm
125 ms 125 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | showRotator(ORIENTATION = HORIZONTAL, STYLE = , LOCATION = DIRECTORY_TOP, MAXSIZE = 700) ] from C:\WWW\v2\Components\Link.cfc
93 ms 47 ms 2 C:\WWW\v2\Extensions\Link.cfm
78 ms 78 ms 1 C:\WWW\v2\Events\dsp_CategoryEvents.cfm
78 ms 78 ms 1 CFC[ C:\WWW\v2\Components\Event.cfc | PromoEvents(isHost = False, Featured = True, MaxResults = 50, StateCode = WI, CountyName = Green) ] from C:\WWW\v2\Components\Event.cfc
78 ms 78 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 37, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.cfc
31 ms 31 ms 1 C:\WWW\v2\vars_Request.cfm
16 ms 3 ms 5 C:\WWW\v2\Extensions\accelerate.cfm
16 ms 16 ms 1 C:\WWW\v2\skating_rinks\dsp_news.cfm
15 ms 15 ms 1 C:\WWW\v2\skating_rinks\dsp_BannerRotator.cfm
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 70, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | showRotator(ORIENTATION = VERTICAL, STYLE = , LOCATION = DIRECTORY_RIGHT, MAXSIZE = 750) ] from C:\WWW\v2\Components\Link.cfc
0 ms 0 ms 2 C:\CFusionMX7\CustomTags\Capitalize.cfm
0 ms 0 ms 1 C:\WWW\v2\Global_INC.cfm
0 ms 0 ms 1 C:\WWW\v2\act_CheckScrape.cfm
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestEnd(/skating_rinks/wi/green_county_wi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestStart(/skating_rinks/wi/green_county_wi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onSessionStart() ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Feature.cfc | getLocationFeatures(LOCATIONID = 0) ] from C:\WWW\v2\Components\Feature.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | hasFeature(NOADS, 0) ] from C:\WWW\v2\Components\Location.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeDetails(RINKTIME) ] from C:\WWW\v2\Components\Theme.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(COMLPETE!) ] from C:\WWW\v2\Components\UDF.cfc
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
312 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

Exceptions

23:56:09.009 - Application Exception - in C:\WWW\v2\Components\Event.cfc : line 671
	    No data returned.
23:56:09.009 - Expression Exception - in C:\WWW\v2\skating_rinks\dsp_news.cfm : line 83
	    Invalid list index 1.

SQL Queries

Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 23:56:09.009
			SELECT * FROM TBL_THEME
			WHERE 1=1
			
				and THEME_CODE = 'RINKTIME'
Link (Datasource=RINKTIME_v2, Time=16ms, Records=3) in C:\WWW\v2\Components\Link.cfc @ 23:56:09.009
			SELECT LINK_ID, LINK_H, LINK_W
			FROM TBL_LINK 
			INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
			WHERE LINK_LOCATION LIKE '%DIRECTORY_TOP%'
			AND LINK_ACTIVE = 1
			AND PARTNER_ACTIVE = 1
			AND LINK_STARTDATE <= getDate()
			AND LINK_ENDDATE >= getDate()
			order by LINK_PRIORITY
Link (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:56:09.009
					SELECT TOP 1 *
					FROM TBL_LINK
					INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
					WHERE TBL_LINK.LINK_ID = 37
					AND LINK_ACTIVE = 1
					AND PARTNER_ACTIVE = 1
					and 1=1
LinkLog (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:56:09.009
					INSERT INTO TBL_LINKLOG 
					(
						LINK_ID,
						RESOURCE_ID,
						LINKLOG_IP,
						LINKLOG_DATE,
						LINKLOG_REFERER,
						LINKLOG_TYPE
					) 
	  				VALUES 
					(
						37,
						0,
						'38.103.63.60',
						GetDate(),
						'',
						'VIEW'
					)
Result.Data (Datasource=RINKTIME_v2, Time=78ms, Records=0) in C:\WWW\v2\Components\Event.cfc @ 23:56:09.009
				select distinct TOP 50
					TBL_EVENT.EVENT_ID,
					TBL_EVENT.EVENT_NAME,
					TBL_EVENT.EVENT_START_DATE,
					TBL_EVENT.EVENT_END_DATE,
					TBL_EVENT.EVENT_IMAGE,
					TBL_EVENT.EVENT_IMAGETHUMB,
					TBL_EVENT.EVENT_PROMOSTART,
					TBL_EVENT.EVENT_PROMOTER,
					TBL_EVENT.EVENT_ALLOWLEADS,
					
					TBL_ACTIVITY.ACTIVITY_CODE,
					TBL_ACTIVITY.ACTIVITY_NAME,
					TBL_ACTIVITY.ACTIVITY_ID,
					TBL_DIVISION.DIVISION_CODE,
					TBL_DIVISION.DIVISION_NAME,
					TBL_DIVISION.DIVISION_ID,
					TBL_DESCRIPTION.DESCRIPTION_CODE,
					TBL_DESCRIPTION.DESCRIPTION_NAME,
					TBL_DESCRIPTION.DESCRIPTION_ID,
					
					'' as LocationURL,
					'' as EventURL
				from TBL_EVENT
				left join TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION on TBL_EVENT.EVENT_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.EVENT_ID
				left join TBL_ACTIVITY on TBL_ACTIVITY.ACTIVITY_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID
				left join TBL_DIVISION on TBL_DIVISION.DIVISION_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID
				left join TBL_DESCRIPTION on TBL_DESCRIPTION.DESCRIPTION_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID
				
					left join TBL_EVENT_LOCATION on TBL_EVENT_LOCATION.EVENT_ID = TBL_EVENT.EVENT_ID
					left join TBL_LOCATION on TBL_LOCATION.LOCATION_ID = TBL_EVENT_LOCATION.LOCATION_ID
				
				
					left join TBL_POSTAL on TBL_POSTAL.POSTAL_CODE = TBL_LOCATION.LOCATION_ZIP
				
				where 1=1
				and EVENT_PROMOSTART <= getDate()
				and EVENT_PROMOEND >= getDate()
				and EVENT_START_DATE >= getDate()
				and EVENT_ACTIVE = 1
				
					and EVENT_LOCATION_HELDHERE = 0
				
					and TBL_LOCATION.LOCATION_STATE = 'WI'
				
					and POSTAL_COUNTY = 'Green'
				
					and TBL_EVENT.EVENT_FEATURED = 1 
				order by EVENT_START_DATE asc
qry_Categories (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\skating_rinks\dsp_news.cfm @ 23:56:09.009
			select *
			from TBL_COMMUNITY_news_category
			order by newscat_order ASC
Features (Datasource=RINKTIME_v2, Time=0ms, Records=0) in C:\WWW\v2\Components\Feature.cfc @ 23:56:09.009
				SELECT
					TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID,
					TBL_LOCATION_PACKAGE_FEATURE.FEATURE_ID,
					TBL_LOCATION_PACKAGE_FEATURE.PACKAGE_ID,
					FEATURE_NAME,
					FEATURE_CODE,
					FEATURE_PRICE,
					FEATURE_PRICEPER,
					PACKAGE_FEATURE_DISCOUNT,
					PACKAGE_FEATURE_DISCOUNTUNIT,
					LOCATION_PACKAGE_FEATURE_STARTDATE, 
					LOCATION_PACKAGE_FEATURE_ENDDATE,
					LOCATION_PACKAGE_FEATURE_COMMITTEDUNTIL
					, '' as UnitDiscount
					, '' as DiscountedPrice
				FROM TBL_LOCATION_PACKAGE_FEATURE
				INNER JOIN TBL_LOCATION ON TBL_LOCATION.LOCATION_ID = TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID
				INNER JOIN TBL_FEATURE ON TBL_FEATURE.FEATURE_ID = TBL_LOCATION_PACKAGE_FEATURE.FEATURE_ID
				LEFT JOIN TBL_PACKAGE ON TBL_PACKAGE.PACKAGE_ID = TBL_LOCATION_PACKAGE_FEATURE.PACKAGE_ID
				LEFT JOIN TBL_PACKAGE_FEATURE ON (
					TBL_PACKAGE_FEATURE.PACKAGE_ID = TBL_LOCATION_PACKAGE_FEATURE.PACKAGE_ID 
					AND TBL_PACKAGE_FEATURE.FEATURE_ID = TBL_LOCATION_PACKAGE_FEATURE.FEATURE_ID
					)
				WHERE 1=1
				AND TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID = 0 
					AND LOCATION_PACKAGE_FEATURE_STARTDATE <= getDate()
					AND (LOCATION_PACKAGE_FEATURE_ENDDATE >= getDate() OR LOCATION_PACKAGE_FEATURE_ENDDATE IS NULL)
				
				AND FEATURE_STARTDATE <= getDate()
				AND (FEATURE_ENDDATE > getDate() or FEATURE_ENDDATE is NULL)
				ORDER BY TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID, FEATURE_PRIORITY
Link (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:56:09.009
			SELECT LINK_ID, LINK_H, LINK_W
			FROM TBL_LINK 
			INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
			WHERE LINK_LOCATION LIKE '%DIRECTORY_RIGHT%'
			AND LINK_ACTIVE = 1
			AND PARTNER_ACTIVE = 1
			AND LINK_STARTDATE <= getDate()
			AND LINK_ENDDATE >= getDate()
			order by LINK_PRIORITY
Link (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:56:09.009
					SELECT TOP 1 *
					FROM TBL_LINK
					INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
					WHERE TBL_LINK.LINK_ID = 70
					AND LINK_ACTIVE = 1
					AND PARTNER_ACTIVE = 1
					and 1=1
LinkLog (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:56:09.009
					INSERT INTO TBL_LINKLOG 
					(
						LINK_ID,
						RESOURCE_ID,
						LINKLOG_IP,
						LINKLOG_DATE,
						LINKLOG_REFERER,
						LINKLOG_TYPE
					) 
	  				VALUES 
					(
						70,
						0,
						'38.103.63.60',
						GetDate(),
						'',
						'VIEW'
					)

Scope Variables

Application Variables:
accountobj=Struct (5)
activityobj=Struct (7)
addir=a1/
allowdynamicsearch=False
applicationname=RT_Directory
appstarted={ts '2008-09-05 21:30:23'}
assetdir=Assets/
basedir=/
basepath=C:\WWW\v2\
cachedwithin=0.5
communityobj=Struct (14)
componentsdir=Components/
cryptkey=RinKtiMe+
daysuntilinvoicedue=14
dbdatasource=RINKTIME_v2
dbpassword=joelgrimes
dbusername=joelgrimes
debug=True
descriptionobj=Struct (4)
developerips=10.100.10.127,127.0.0.1,localhost,71.85.149.193,71.85.149.243,69.110.219.250,68.184.205.131,10.100.10.250,68.184.205.131,68.184.204.5
divisionobj=Struct (3)
domain=www.rinktime.com
erroremail=rt_errors@zepoid.com
event_costfeaturedperday=0.17
event_costperday=0.17
event_costperlocation=0.02
event_minimumfee=2.50
eventcontroldir=events/EventControl/
eventdir=events/
eventimagesdir=Assets/events/
eventobj=Struct (19)
extensiondir=Extensions/
extensionsdir=Extensions/
externaladdir=//s3.amazonaws.com/RT_ASSETS/a1/
externalassetdir=//s3.amazonaws.com/RT_ASSETS/
facebookkey=a639ea1d8381241007988ad44840fd54
fbclient=Struct (41)
featureobj=Struct (12)
filedir=Files/
financialsystemactivated=False
googlemapsapikey=ABQIAAAAIgEWZ8eRgO6bNZ0ZdzoALxQ4GwHlP3Y-ZeRcab9SrPhZZuUw1RTeInzqZoDyGzIb3zbZ9vrfnlhjYA
googlerateperclick=0.10
groupobj=Struct (15)
invoiceobj=Struct (4)
lastrequestthrottle=1
listingeditdir=RinkControl/edit/
locationadmindir=RinkControl/
locationobj=Struct (40)
logindir=Login/
mailinglistobj=Struct (15)
mailobj=Struct (6)
maindir=Checkin/
moduledir=Checkin/Modules/
msnrateperclick=0.15
nocache=False
paypalapipassword=9EEMZCDLUJTMAVFA
paypalapisignature=A47h7NfE8rUOc7ceXuk.19nNXdpKA5Wz296rK8roStIVnLZrKXEE5cBp
paypalapiusername=john_api1.rinktime.com
paypalobj=Struct (3)
paypalserverurl=https://api-3t.paypal.com/nvp
paypalurl=https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=
paypalversion=3.0
ratingobj=Struct (9)
recachenearby=528
requestcount=5171
requesttrottle=1
resourceobj=Struct (27)
reviewdisplayperiod=-6
roleobj=Struct (8)
rssdir=feeds/
rssobj=Struct (11)
s3basedir=//s3.amazonaws.com/RT_ASSETS/
s3bucketname=RT_ASSETS
s3obj=Struct (9)
secureprotocol=https://
securityobj=Struct (1)
sessioncount=1358
sessionobj=Struct (5)
sessiontimeout=30
statobj=Struct (16)
statsobj=Struct (16)
supportemail=support@rinktime.com
supporthours=8:30 - 5:00 pm, Pacific Time
supportphone=714.265.7342
theme=Query (1)
themecode=RINKTIME
themeid=1
themeobj=Struct (2)
transactionobj=Struct (8)
twittersearchstring=%22roller%20skate%22%20OR%20%22roller%20skating%22%20OR%20%22ice%20skate%22%20OR%20%22ice%20skating%22%20OR%20%22hockey%22%20OR%20%22curling%22%20OR%20%22roller%20derby%22%20OR%20%22rinktime%22%20OR%20%22rink%22
udfobj=Struct (35)
webcachedays=1
webdir=skating_rinks/
yahoorateperclick=0.15
zipobj=Struct (12)

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=C:\WWW\v2\skating_rinks\wi\green_county_wi_skating_rinks_arenas.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.rinktime.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/skating_rinks/wi/green_county_wi_skating_rinks_arenas.cfm
PATH_TRANSLATED=C:\WWW\v2\skating_rinks\wi\green_county_wi_skating_rinks_arenas.cfm
QUERY_STRING=
REMOTE_ADDR=38.103.63.60
REMOTE_HOST=38.103.63.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/skating_rinks/wi/green_county_wi_skating_rinks_arenas.cfm
SERVER_NAME=www.rinktime.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=

Cookie Variables:
CFID=2728189
CFTOKEN=72945096
PARTNER_ID=default
RT_ADSEED_DIRECTORY_RIGHT=2
RT_ADSEED_DIRECTORY_TOP=1
SESSION_ID=

Request Parameters:
displayedrows=0
lasttime=1220684169848
markerlist=Start: 1220684169848,<li style='color: white;'>COMLPETE!: 0/0
partnercountry=USA
partnerdir=//s3.amazonaws.com/RT_ASSETS/partners/default/
pid=default
requestthrottle=1
starttime=1220684169848
theme=Query (1)
themecode=RINKTIME
thisdirectory=C:\WWW\v2\
timemarkersinitiated=True

Server Variables:
ACCELERATOR=Struct (1643)
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
cfid=2728189
cftoken=72945096
sessionid=RT_DIRECTORY_2728189_72945096
starttime={ts '2008-09-05 23:56:09'}
urltoken=CFID=2728189&CFTOKEN=72945096

URL Parameters:
FORCEMAINT=False
SESSION_ID=
THEME=RINKTIME
Debug Rendering Time: 63 ms