Total Time	Avg Time	Count	Template
20 ms	20 ms	1	/mnt/webroot/sites/viamala/handler.cfm
17 ms	17 ms	1	/mnt/webroot/sites/viamala/nav/tabhandler.cfm
3 ms	3 ms	1	CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestStart(/de.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
0 ms	0 ms	1	CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestEnd(/de.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
3 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
26 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			SELECT suffix FROM SITES WHERE lower(server_name) = 'www.campingsplugen.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  
	e.navtreeid, 
	e.navelementid, 
	e.parentelementid, 
	CASE e.parentelementid  WHEN null THEN 0  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 
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

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-06 09:40:21'}
updatetimeav_it={ts '2012-02-06 08:51:53'}
urlredirect=
util=Struct (20)
weathervia_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120206"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-18</TempMor><TempAft>-18</TempAft></Day><Day val="20120207"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-19</TempMor><TempAft>-9</TempAft></Day><Day val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>0</TempAft></Day><Day val="20120209"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-11</TempMor><TempAft>0</TempAft></Day><Day val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-12</TempMor><TempAft>-4</TempAft></Day><Day val="20120211"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-14</TempMor><TempAft>1</TempAft></Day></Location><Location name="Splügen"><Day val="20120206"><TxtDay>bedeckt</TxtDay><SymbDay>5</SymbDay><TempMor>-11</TempMor><TempAft>-11</TempAft></Day><Day val="20120207"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-23</TempMor><TempAft>-13</TempAft></Day><Day val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-19</TempMor><TempAft>-4</TempAft></Day><Day val="20120209"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-15</TempMor><TempAft>-4</TempAft></Day><Day val="20120210"><TxtDay>Aufhellungen, einzelne Schneeschauer</TxtDay><SymbDay>8</SymbDay><TempMor>-16</TempMor><TempAft>-8</TempAft></Day><Day val="20120211"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-18</TempMor><TempAft>-3</TempAft></Day></Location></Article> 
weathervia_it=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120206"><TxtDay>coperto</TxtDay><SymbDay>5</SymbDay><TempMor>-18</TempMor><TempAft>-18</TempAft></Day><Day val="20120207"><TxtDay>nuvoloso con rovesci di neve</TxtDay><SymbDay>11</SymbDay><TempMor>-19</TempMor><TempAft>-9</TempAft></Day><Day val="20120208"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>0</TempAft></Day><Day val="20120209"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-11</TempMor><TempAft>0</TempAft></Day><Day val="20120210"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-12</TempMor><TempAft>-4</TempAft></Day><Day val="20120211"><TxtDay>nuvoloso con rovesci di neve</TxtDay><SymbDay>11</SymbDay><TempMor>-14</TempMor><TempAft>1</TempAft></Day></Location><Location name="Splügen"><Day val="20120206"><TxtDay>coperto</TxtDay><SymbDay>5</SymbDay><TempMor>-11</TempMor><TempAft>-11</TempAft></Day><Day val="20120207"><TxtDay>nuvoloso con rovesci di neve</TxtDay><SymbDay>11</SymbDay><TempMor>-23</TempMor><TempAft>-13</TempAft></Day><Day val="20120208"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-19</TempMor><TempAft>-4</TempAft></Day><Day val="20120209"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-15</TempMor><TempAft>-4</TempAft></Day><Day val="20120210"><TxtDay>schiarite, rovesci nevosi sparsi</TxtDay><SymbDay>8</SymbDay><TempMor>-16</TempMor><TempAft>-8</TempAft></Day><Day val="20120211"><TxtDay>nuvoloso con rovesci di neve</TxtDay><SymbDay>11</SymbDay><TempMor>-18</TempMor><TempAft>-3</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=21222677; CFTOKEN=37850360
HTTP_HOST=www.campingsplugen.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/Badewetter/
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=21222677
CFTOKEN=37850360

Request Parameters:
activepath=
activetab=1
currentnavtree=Query (181)
currentnavurls=Struct (175)
env=Struct (1)
langpath=de
langpathid=2
maxlevel=
qlangpath=dt
selectmaintabs=Query (8)
selectsubtabs=Query (0)
selecttabs=Query (10)
site_title=Offizielle Website von Viamala Tourismus
siteid=91

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

Session Variables:
cfid=21222677
cftoken=37850360
qlangpath=de
rcountry=US
rlanguage=de
sessionid=REGSITE_VM_21222677_37850360
urltoken=CFID=21222677&CFTOKEN=37850360