Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /de/page.cfm
Time Stamp 09-Feb-12 03:31 AM
Locale German (Standard)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 10.235.46.189
Host Name 10.235.46.189


Execution Time

Total Time Avg Time Count Template
12 ms 12 ms 1 CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestStart(/de/page.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
11 ms 11 ms 1 top level /mnt/webroot/sites/viamala/html/page.cfm
9 ms 9 ms 1 /mnt/shared/customtags/staticpage.cfm
3 ms 3 ms 1 CFC[ /mnt/shared/cfc/v1/core/gcs_object.cfc | getDefaultLangFromID(319311) ] from /mnt/shared/cfc/v1/core/gcs_object.cfc
2 ms 2 ms 1 CFC[ /mnt/shared/cfc/v1/core/sites_param.cfc | getParamByID(cfmapping, 91) ] from /mnt/shared/cfc/v1/core/sites_param.cfc
1 ms 1 ms 1 CFC[ /mnt/shared/cfc/v1/core/gcs_staticpage.cfc | getDefaultLangFromID(argumentcollection = [complex value]) ] from /mnt/shared/cfc/v1/core/gcs_staticpage.cfc
0 ms 0 ms 1 CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestEnd(/de/page.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
24 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qSiteConfig (Datasource=web, Time=10ms, Records=0) in /mnt/webroot/sites/viamala/Application.cfc @ 03:31:12.012
			SELECT suffix FROM SITES WHERE lower(server_name) = 'www.viamala.ch'
		
qParamByID (Datasource=web, Time=1ms, Records=1) in /mnt/shared/cfc/v1/core/sites_param.cfc @ 03:31:12.012
			select sp.param_value 
			from sites_param sp 
			where sp.pk_sites_param = ? 
			and sp.fk_site_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = cfmapping
Parameter #2(cf_sql_integer) = 91

getDefaultLang (Datasource=web, Time=0ms, Records=1) in /mnt/shared/cfc/v1/core/gcs_staticpage.cfc @ 03:31:12.012
		SELECT getDefaultLangForStaticPage(319311) as lang_code
		
qStaticPages (Datasource=web, Time=1ms, Records=0) in /mnt/shared/customtags/staticpage.cfm @ 03:31:12.012
	select gcs_0.pk_gcs0_id,gcs_0.visible,IFNULL(gcs_templates.datei,'static_bare.cfm') AS datei,gcs_detail.title_offe,gcs_detail.navcode,gcs_lang.lang_code,gcs_detail.pk_gcs_detail_id,gcs_detail.meta_keywords,gcs_detail.meta_keywords,gcs_detail.meta_description,gcs_detail.text1
	from gcs_0 left join gcs_templates on (gcs_0.fk_gcs_templates_id = gcs_templates.pk_gcs_templates_id), gcs_detail, gcs_lang
	where gcs_0.pk_gcs0_id=? and fk_site_id = ? and gcs_0.fk_gcs_type_id = 7 and gcs_0.pk_gcs0_id = gcs_detail.fk_gcs0_id and gcs_detail.fk_lang_id = gcs_lang.pk_lang_id and (gcs_detail.deleted = 0 or gcs_detail.deleted is null) order by pk_gcs0_id desc,fk_lang_id
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 319311
Parameter #2(cf_sql_integer) = 91

templates (Datasource=, Time=2ms, Records=0) in /mnt/shared/customtags/staticpage.cfm @ 03:31:12.012
		Select distinct datei from qStaticPages
		


Scope Variables

Application Variables:
applicationname=REGSITE_VM
basepath=/mnt/webroot/sites/viamala/
datasource=web
gcsds=web
imagebasepath=http://images.cdn.gadmin.ch
instance=Struct (20)
langpath_id=Struct (13)
localmenu=Struct (13)
locator=Struct (8)
mkt_title=Struct (3)
myhostname=ps6
navigation=Struct (3)
navurls=Struct (5)
siteid=91
trans=Struct (4)
ua_code=UA-4012095-60
updatetimeav_de={ts '2012-02-09 02:26:14'}
updatetimeav_it={ts '2012-02-08 19:48:17'}
urlredirect=
util=Struct (20)
weathervia_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120209"><TxtDay>wechselnd bewölkt</TxtDay><SymbDay>54</SymbDay><TempMor>-13</TempMor><TempAft>-13</TempAft></Day><Day val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day><Day val="20120211"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-17</TempMor><TempAft>-6</TempAft></Day><Day val="20120212"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-17</TempMor><TempAft>-4</TempAft></Day><Day val="20120213"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-3</TempAft></Day><Day val="20120214"><TxtDay>stark bewölkt, anhaltender Schnee</TxtDay><SymbDay>22</SymbDay><TempMor>-11</TempMor><TempAft>-5</TempAft></Day></Location><Location name="Splügen"><Day val="20120209"><TxtDay>bedeckt</TxtDay><SymbDay>55</SymbDay><TempMor>-3</TempMor><TempAft>-3</TempAft></Day><Day val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-18</TempMor><TempAft>-11</TempAft></Day><Day val="20120211"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-21</TempMor><TempAft>-10</TempAft></Day><Day val="20120212"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-21</TempMor><TempAft>-8</TempAft></Day><Day val="20120213"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-18</TempMor><TempAft>-7</TempAft></Day><Day val="20120214"><TxtDay>stark bewölkt, anhaltender Schnee</TxtDay><SymbDay>22</SymbDay><TempMor>-15</TempMor><TempAft>-9</TempAft></Day></Location></Article> 
weathervia_it=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120208"><TxtDay>nuvoloso</TxtDay><SymbDay>54</SymbDay><TempMor>-11</TempMor><TempAft>-11</TempAft></Day><Day val="20120209"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-2</TempAft></Day><Day val="20120210"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day><Day val="20120211"><TxtDay>soleggiato</TxtDay><SymbDay>1</SymbDay><TempMor>-17</TempMor><TempAft>-6</TempAft></Day><Day val="20120212"><TxtDay>soleggiato</TxtDay><SymbDay>1</SymbDay><TempMor>-15</TempMor><TempAft>-3</TempAft></Day><Day val="20120213"><TxtDay>nuvoloso con rovesci di neve</TxtDay><SymbDay>11</SymbDay><TempMor>-11</TempMor><TempAft>-5</TempAft></Day></Location><Location name="Splügen"><Day val="20120208"><TxtDay>coperto</TxtDay><SymbDay>55</SymbDay><TempMor>-1</TempMor><TempAft>-1</TempAft></Day><Day val="20120209"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-6</TempAft></Day><Day val="20120210"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-18</TempMor><TempAft>-11</TempAft></Day><Day val="20120211"><TxtDay>soleggiato</TxtDay><SymbDay>1</SymbDay><TempMor>-21</TempMor><TempAft>-10</TempAft></Day><Day val="20120212"><TxtDay>soleggiato</TxtDay><SymbDay>1</SymbDay><TempMor>-19</TempMor><TempAft>-7</TempAft></Day><Day val="20120213"><TxtDay>nuvoloso con rovesci di neve</TxtDay><SymbDay>11</SymbDay><TempMor>-15</TempMor><TempAft>-9</TempAft></Day></Location></Article> 
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=/mnt/webroot/sites/viamala/html/page.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=CFID=14674548; CFTOKEN=95287857; AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA
HTTP_HOST=www.viamala.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/offer.cfm
PATH_TRANSLATED=/mnt/webroot/sites/viamala/html/page.cfm
QUERY_STRING=category=ViamalaTippVM&subcat=ViamalaTipp&id=319311&
REMOTE_ADDR=10.235.46.189
REMOTE_HOST=10.235.46.189
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/de/page.cfm
SERVER_NAME=www.myviamala.ch
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.9 (Debian) JRun/4.0
WEB_SERVER_API=
Cookie Variables:
AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA
CFID=14674548
CFTOKEN=95287857
Request Parameters:
currentnavtree=Query (181)
currentnavurls=Struct (175)
env=Struct (1)
langpath=de
langpathid=2
qlangpath=dt
site_title=Offizielle Website von Viamala Tourismus
siteid=91
Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
cfid=14674548
cftoken=95287857
qlangpath=de
rcountry=US
rlanguage=de
sessionid=REGSITE_VM_14674548_95287857
urltoken=CFID=14674548&CFTOKEN=95287857
URL Parameters:
CATEGORY=ViamalaTippVM
ID=319311
SUBCAT=ViamalaTipp
Debug Rendering Time: 20 ms