Total Time	Avg Time	Count	Template
170 ms	170 ms	1	CFC[ /mnt/webroot/sites/viamala/Application.cfc | onError([complex value], ) ] from /mnt/webroot/sites/viamala/Application.cfc
143 ms	143 ms	1	/mnt/webroot/sites/viamala/handler.cfm
129 ms	129 ms	1	/mnt/webroot/sites/viamala/nav/tabhandler.cfm
12 ms	12 ms	1	/mnt/webroot/sites/viamala/html/offer.cfm
10 ms	5 ms	2	/mnt/shared/customtags/closedcat.cfm
3 ms	3 ms	1	CFC[ /mnt/shared/cfc/v1/core/functions.cfc | runMacros(ps6, 91, filesync) ] from /mnt/shared/cfc/v1/core/functions.cfc
3 ms	2 ms	2	CFC[ /mnt/shared/cfc/v1/core/sites_param.cfc | getParamByID(cfmapping, 91) ] from /mnt/shared/cfc/v1/core/sites_param.cfc
3 ms	3 ms	1	CFC[ /mnt/shared/cfc/v2/locator.cfc | getCountryCode(10.235.46.189) ] from /mnt/shared/cfc/v2/locator.cfc
1 ms	1 ms	1	/mnt/webroot/sites/viamala/nav/main_top.cfm
1 ms	1 ms	1	CFC[ /mnt/shared/cfc/v1/core/gcs_1.cfc | getPassword(argumentcollection = [complex value]) ] from /mnt/shared/cfc/v1/core/gcs_1.cfc
1 ms	1 ms	1	CFC[ /mnt/shared/cfc/v1/core/gcs_2.cfc | getPassword(argumentcollection = [complex value]) ] from /mnt/shared/cfc/v1/core/gcs_2.cfc
1 ms	1 ms	1	CFC[ /mnt/webroot/sites/viamala/Application.cfc | onRequestStart(/de.cfm) ] from /mnt/webroot/sites/viamala/Application.cfc
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
316 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			SELECT suffix FROM SITES WHERE lower(server_name) = 'www.viamala.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

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

			
			SELECT	g.CUGPasswort as password, g.CUGBenutzername as username
			FROM   	gcs_2 g 
					inner join gcs_sites_gcs2_rel gsr on g.pk_gcs2_id = gsr.fk_gcs2_id 
			WHERE  
					g.navcode = ?
					and gsr.fk_site_id = ?  AND g.fk_gcs_type_id = ? 
					AND g.visible = 1
					AND gsr.visible=1
		

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

			
			SELECT	g.CUGPasswort as password, g.CUGBenutzername as username
			FROM   	gcs_1 g 
					inner join gcs_sites_gcs1_rel gs1r on g.pk_gcs1_id = gs1r.fk_gcs1_id 
					
			WHERE  
					g.navcode = ?
					and gs1r.fk_site_id = ?  AND g.fk_gcs_type_id = ? 
					AND g.visible = 1
					AND gs1r.visible=1
		

				select file,id from ps6
				where siteid = ?
				and timediff(now(), created) > ? 

				SELECT cc as IP
				FROM geoip.ip NATURAL JOIN geoip.cc
				WHERE end >= INET_ATON('10.235.46.189') 
				ORDER BY end ASC
				LIMIT 1
        	

			SELECT * FROM SITES WHERE lower(server_name) = 'www.myviamala.ch'
		

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-04 23:38:13'}
updatetimeav_it={ts '2012-02-05 02:19:01'}
urlredirect=
util=Struct (20)
weathervia_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location name="Thusis"><Day val="20120204"><TxtDay>bedeckt</TxtDay><SymbDay>55</SymbDay><TempMor>-13</TempMor><TempAft>-13</TempAft></Day><Day val="20120205"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-21</TempMor><TempAft>-9</TempAft></Day><Day val="20120206"><TxtDay>sonnig</TxtDay><SymbDay>1</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>55</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>sonnig</TxtDay><SymbDay>1</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="20120205"><TxtDay>coperto</TxtDay><SymbDay>55</SymbDay><TempMor>-14</TempMor><TempAft>-14</TempAft></Day><Day val="20120206"><TxtDay>soleggiato</TxtDay><SymbDay>1</SymbDay><TempMor>-20</TempMor><TempAft>-9</TempAft></Day><Day val="20120207"><TxtDay>molto nuvoloso, nevicate intermittenti</TxtDay><SymbDay>19</SymbDay><TempMor>-19</TempMor><TempAft>-7</TempAft></Day><Day val="20120208"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-15</TempMor><TempAft>-5</TempAft></Day><Day val="20120209"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-13</TempMor><TempAft>-2</TempAft></Day><Day val="20120210"><TxtDay>parzialmente soleggiato</TxtDay><SymbDay>3</SymbDay><TempMor>-13</TempMor><TempAft>-6</TempAft></Day></Location><Location name="Splügen"><Day val="20120205"><TxtDay>coperto</TxtDay><SymbDay>55</SymbDay><TempMor>-19</TempMor><TempAft>-19</TempAft></Day><Day val="20120206"><TxtDay>soleggiato</TxtDay><SymbDay>1</SymbDay><TempMor>-24</TempMor><TempAft>-13</TempAft></Day><Day val="20120207"><TxtDay>molto nuvoloso, nevicate intermittenti</TxtDay><SymbDay>19</SymbDay><TempMor>-23</TempMor><TempAft>-11</TempAft></Day><Day val="20120208"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-19</TempMor><TempAft>-9</TempAft></Day><Day val="20120209"><TxtDay>abbastanza soleggiato</TxtDay><SymbDay>2</SymbDay><TempMor>-17</TempMor><TempAft>-6</TempAft></Day><Day val="20120210"><TxtDay>parzialmente soleggiato</TxtDay><SymbDay>3</SymbDay><TempMor>-17</TempMor><TempAft>-10</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=CFID=15466445; CFTOKEN=27731949; AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA
HTTP_HOST=www.viamala.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/veranstaltungen/perlen/en/offer.cfm
PATH_TRANSLATED=/mnt/webroot/sites/viamala/handler.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.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=15466445
CFTOKEN=27731949

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

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

Session Variables:
cfid=15466445
cftoken=27731949
qlangpath=de
rcountry=US
rlanguage=de
sessionid=REGSITE_VM_15466445_27731949
urltoken=CFID=15466445&CFTOKEN=27731949

URL Parameters:
CATEGORY=ViamalaTippVM
ID=319311
SUBCAT=ViamalaTipp