Redirect 1 to http://newmexico.casinocity.com/hobbs/zia-park-casino-hotel-and-racetrack/map/nearest/
Debugging Information
Execution Time
SQL Queries GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=7ms, Records=0) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 12:10:43.043 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=74ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 12:10:44.044 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 = 'newmexico.casinocity.com' AND Property.PropertyStatusTypeId = 1 ORDER BY PropertyUrlHistory.DateEntered DESC PropertyRedirection (Datasource=GamingProperties-RO-CasinoCity, Time=75ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 12:10:44.044 EXEC PropertyRedirection 637300 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=newmexico&city=hobbs&property=zia-park-casino&nearest=OK 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 nearest=OK property=zia-park-casino site=newmexicoDebug Rendering Time: 12 ms |