Redirect 2 to www.casinocity.com/united-states/hobbs/zia-park-casino-hotel-and-racetrack/map/


Debugging Information
ColdFusion Server Standard 9,0,1,274733
Template /map.cfm
Time Stamp 22-Apr-21 01:04 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 216.116.192.60
Host Name 216.116.192.60


Execution Time

Total Time Avg Time Count Template
502 ms 502 ms 1 D:/ClusterSites/htdocs/minisites.casinocity.com/htdocs/map.cfm
1 ms 1 ms 1 D:/ClusterSites/htdocs/minisites.casinocity.com/htdocs/Application.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mappingfunctions.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
503 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=6ms, Records=0) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 13:04:22.022
		SELECT Property.PropertyId, Longitude, Latitude			-- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		WHERE dbo.StringToUrl(Property.City) = 'hobbs'
		  AND Property.UrlOrganizationName = 'zia-park-casino'
  		  AND Property.PropertyStatusTypeId =1
	
GetRedirectionPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=101ms, Records=0) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 13:04:23.023
			SELECT TOP 1 Property.PropertyId
			FROM PropertyUrlHistory 
			INNER JOIN Property ON PropertyUrlHistory.PropertyId = Property.PropertyId
			INNER JOIN PropertyAndPlaces StatePropertyAndPlaces ON 
				PropertyUrlHistory.PropertyId = StatePropertyAndPlaces.PropertyId 
				AND StatePropertyAndPlaces.PlaceLevel = 2
				AND StatePropertyAndPlaces.LocationTypeCode = 'P' 
			INNER JOIN ActiveStateMiniSites ON StatePropertyAndPlaces.PlaceId = ActiveStateMiniSites.PlaceId
			WHERE PropertyUrlHistory.URLOrganizationName = 'zia-park-casino'
			AND dbo.StringToUrl(PropertyUrlHistory.city) =  'hobbs'
			AND ActiveStateMiniSites.FQDN = '.casinocity.com'
			AND Property.PropertyStatusTypeId = 1
			ORDER BY PropertyUrlHistory.DateEntered DESC
		
PropertyRedirection (Datasource=GamingProperties-RO-CasinoCity, Time=393ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 13:04:23.023
				EXEC PropertyRedirectionUrlName 'united-states','','hobbs','','map'
			


Scope Variables

Application Variables:
applicationname=Minisites
dbpassword=m0nsters,Inc
dbusername=CC-RO-CasinoCity
dsn=GamingProperties-RO-CasinoCity
googlemapkey=AIzaSyDM2pDbQRrl4ZeldPpxu1lf8nENUYv-BLM
googlemapkey3=AIzaSyD56LEu3WUieqGOTmHj08k_WHnsVpAyTr4
sitename=casinocity.com
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:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.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=
HTTP_COOKIE=
HTTP_HOST=newmexico.casinocity.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/map.cfm
PATH_TRANSLATED=D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
QUERY_STRING=site=&city=hobbs&property=zia-park-casino
REMOTE_ADDR=216.116.192.60
REMOTE_HOST=216.116.192.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/map.cfm
SERVER_NAME=newmexico.casinocity.com
SERVER_PORT=3012
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Server Variables:
coldfusion=Struct (8)
os=Struct (5)
URL Parameters:
city=hobbs
property=zia-park-casino
site=
Debug Rendering Time: 13 ms