Total Time	Avg Time	Count	Template
194 ms	194 ms	1	/mnt/webroot/sites/viamala/handler.cfm
171 ms	171 ms	1	/mnt/webroot/sites/viamala/html/page.cfm
168 ms	168 ms	1	/mnt/shared/customtags/staticpage.cfm
18 ms	18 ms	1	/mnt/webroot/sites/viamala/nav/tabhandler.cfm
12 ms	12 ms	1	CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestStart(/de.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
5 ms	5 ms	1	CFC[ /mnt/shared/cfc/v1/core/sites_param.cfc | getParamByID(cfmapping, 91) ] from /mnt/shared/cfc/v1/core/sites_param.cfc
2 ms	2 ms	1	CFC[ /mnt/shared/cfc/v1/core/gcs_object.cfc | getDefaultLangFromID(287505) ] from /mnt/shared/cfc/v1/core/gcs_object.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
1 ms	1 ms	1	CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestEnd(/de.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
208 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			SELECT suffix FROM SITES WHERE lower(server_name) = 'www.mineralbadandeer.ch'
		

	select
		e.navelementid as currentelement,
		e.parentelementid as activeParent
	from navelementlocale l
		inner join navelement e on e.navelementid = l.navelementid
		inner join navtree n on n.navtreeid = e.navtreeid 
	where (l.navlocaleid = 'de' OR l.navlocaleid = 'de_US' OR l.navlocaleid = ' ') and 
		(l.virtualurl = ? or ? REGEXP l.navident)
		and n.siteid = ? 
	order by CASE LENGTH(l.navlocaleid) WHEN 5 THEN 1 WHEN 2 THEN 2 WHEN 1 THEN 3 END

		SELECT depth, lineage FROM navelement WHERE navelementid = 1011 

select  
	e.navtreeid, 
	e.navelementid, 
	e.parentelementid, 
	CASE e.parentelementid  WHEN null THEN 0 WHEN 1011 THEN 3 WHEN 926 THEN 2 WHEN 972 THEN 1 END as tablevel,
	IFNULL(IFNULL((select navlocaleid from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de_US'),(select navlocaleid from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de')),(select navlocaleid from navelementlocale where navelementid = e.navelementid and navlocaleid = ' ')) as navlocaleid,
	IFNULL(IFNULL((select navident from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de_US'),(select navident from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de')),(select navident from navelementlocale where navelementid = e.navelementid and navlocaleid = ' ')) as navident,
	IFNULL(IFNULL((select parameter from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de_US'),(select parameter from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de')),(select parameter from navelementlocale where navelementid = e.navelementid and navlocaleid = ' ')) as parameter,
	IFNULL(IFNULL((select defaultaction from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de_US'),(select defaultaction from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de')),(select defaultaction from navelementlocale where navelementid = e.navelementid and navlocaleid = ' ')) as defaultaction,
	IFNULL(IFNULL((select virtualurl from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de_US'),(select virtualurl from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de')),(select virtualurl from navelementlocale where navelementid = e.navelementid and navlocaleid = ' ')) as virtualurl,
	IFNULL(IFNULL((select tablabel from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de_US'),(select tablabel from navelementlocale where navelementid = e.navelementid and navlocaleid = 'de')),(select tablabel from navelementlocale where navelementid = e.navelementid and navlocaleid = ' ')) as tablabel,
	e.sortorder
from navtree n
	inner join navelement e on e.navtreeid = n.navtreeid
where n.siteid = 91
	and e.parentelementid is null  or (e.parentelementid in (1011,926,972,929))
order by sortorder

	select * from selectTabs where parentelementid is null and tablabel is not null and defaultaction != 'trash'

	select * from selectTabs where parentelementid is not null and tablabel is not null and defaultaction != 'trash'

	select max(tablevel) as maxlevel from selectTabs

		select * from selectTabs where navelementid = 1011 

			select sp.param_value 
			from sites_param sp 
			where sp.pk_sites_param = ? 
			and sp.fk_site_id = ? 

		SELECT getDefaultLangForStaticPage(287505) as lang_code
		

	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
	

		Select distinct datei from qStaticPages
		

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-4488787-17
updatetimeav_de={ts '2012-02-04 09:53:18'}
updatetimeav_it={ts '2012-02-04 10:02:34'}
urlredirect=
util=Struct (20)
weathervia_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-14</TempMor><TempAft>-14</TempAft></Day><Day val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-21</TempMor><TempAft>-9</TempAft></Day><Day val="20120206"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-20</TempMor><TempAft>-9</TempAft></Day><Day val="20120207"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-18</TempMor><TempAft>-6</TempAft></Day><Day val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-2</TempAft></Day><Day val="20120209"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-12</TempMor><TempAft>0</TempAft></Day></Location><Location name="Splügen"><Day val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-18</TempMor><TempAft>-18</TempAft></Day><Day val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-25</TempMor><TempAft>-13</TempAft></Day><Day val="20120206"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-24</TempMor><TempAft>-13</TempAft></Day><Day val="20120207"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-22</TempMor><TempAft>-10</TempAft></Day><Day val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-18</TempMor><TempAft>-6</TempAft></Day><Day val="20120209"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-16</TempMor><TempAft>-4</TempAft></Day></Location></Article> 
weathervia_it=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120204"><TxtDay>coperto</TxtDay><SymbDay>5</SymbDay><TempMor>-14</TempMor><TempAft>-14</TempAft></Day><Day val="20120205"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-21</TempMor><TempAft>-9</TempAft></Day><Day val="20120206"><TxtDay>parzialmente soleggiato</TxtDay><SymbDay>3</SymbDay><TempMor>-20</TempMor><TempAft>-9</TempAft></Day><Day val="20120207"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-18</TempMor><TempAft>-6</TempAft></Day><Day val="20120208"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-2</TempAft></Day><Day val="20120209"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-12</TempMor><TempAft>0</TempAft></Day></Location><Location name="Splügen"><Day val="20120204"><TxtDay>coperto</TxtDay><SymbDay>5</SymbDay><TempMor>-18</TempMor><TempAft>-18</TempAft></Day><Day val="20120205"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-25</TempMor><TempAft>-13</TempAft></Day><Day val="20120206"><TxtDay>parzialmente soleggiato</TxtDay><SymbDay>3</SymbDay><TempMor>-24</TempMor><TempAft>-13</TempAft></Day><Day val="20120207"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-22</TempMor><TempAft>-10</TempAft></Day><Day val="20120208"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-18</TempMor><TempAft>-6</TempAft></Day><Day val="20120209"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-16</TempMor><TempAft>-4</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/handler.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=AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA; CFID=20669614; CFTOKEN=48557828
HTTP_HOST=www.mineralbadandeer.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/erlebnisse/wellness/aquandeer/
PATH_TRANSLATED=/mnt/webroot/sites/viamala/handler.cfm
QUERY_STRING=
REMOTE_ADDR=10.235.46.189
REMOTE_HOST=10.235.46.189
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/de.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=20669614
CFTOKEN=48557828

Request Parameters:
activepath=1011,926,972
activetab=1011,926,972,null
currentnavid=1011
currentnavtree=Query (181)
currentnavurls=Struct (175)
env=Struct (1)
langpath=de
langpathid=2
maxlevel=2
page=page
qlangpath=dt
selectmaintabs=Query (8)
selectsubtabs=Query (29)
selecttabs=Query (39)
site_title=Offizielle Website von Viamala Tourismus
siteid=91
suffix=_ad

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

Session Variables:
cfid=20669614
cftoken=48557828
qlangpath=de
rcountry=US
rlanguage=de
sessionid=REGSITE_VM_20669614_48557828
urltoken=CFID=20669614&CFTOKEN=48557828