Debugging Information
Railo (Endal) Os BETA 4.1.0.004 (CFML Version 10,0,0,0)
Template /de/page.cfm (/mnt/webroot/sites/toggenburg/html/page.cfm)
Time Stamp 25.04.2014 01:51
Time Zone Europe/Berlin
Locale German (standard)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 127.0.0.1
Host Name www.toggenburg.org
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
1660 ms 1660 ms 1 /mnt/webroot/sites/toggenburg/html/page.cfm
337 ms 337 ms 1 /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm
28.9 ms 28.9 ms 1 /mnt/webroot/sites/toggenburg/nav/subnavi.cfm
38.6 ms 19.3 ms 2 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc$extractSymbolAndDate
15.7 ms 15.7 ms 1 /mnt/webroot/sites/toggenburg/nav/toolbar_top.cfm
13.5 ms 13.5 ms 1 /mnt/webroot/sites/toggenburg/cfc/output.cfc$getPageDump
12.1 ms 12.1 ms 1 /mnt/webroot/sites/toggenburg/nav/footernavi.cfm
261 ms 9.69 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc$execute
8.6 ms 8.6 ms 1 /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc$generateURL
49.4 ms 6.17 ms 8 /mnt/gadmin4/cfc/parameter.cfc$getParamByID
5.68 ms 5.68 ms 1 /mnt/pages/242/de/64986_184416_de.cfm
7.56 ms 3.78 ms 2 /mnt/gadmin4/schema/site.cfc$getLanguages
7.04 ms 3.52 ms 2 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc$getPages
3.46 ms 3.46 ms 1 /mnt/pages/242/de/64987_184425_de.cfm
2.86 ms 2.86 ms 1 /mnt/webroot/sites/toggenburg/nav/params.cfm
2.79 ms 2.79 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc$init
2.65 ms 2.65 ms 1 /mnt/webroot/sites/toggenburg/cfc/getGlobals.cfc
2.59 ms 2.59 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/read_weather.cfm
2.37 ms 2.37 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc$getSymbolAtTime
4.7 ms 2.35 ms 2 /mnt/webroot/sites/toggenburg/cfc/gadmin/image.cfc$get
2.34 ms 2.34 ms 1 /mnt/webroot/sites/toggenburg/nav/main_bot.cfm
8.53 ms 2.13 ms 4 /mnt/webroot/sites/toggenburg/cfc/output.cfc$getNodeAssociations
1.91 ms 1.91 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/weather_klein.cfm
3.55 ms 1.77 ms 2 /mnt/gadmin4/schema/page.cfc$dumpPages
1.73 ms 1.73 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc$getMinTemperature
3 ms 1.5 ms 2 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc$getMaxTemperature
5.6 ms 1.4 ms 4 /mnt/webroot/sites/toggenburg/cfc/output.cfc$getAvailableDetails
110 ms 1.35 ms 81 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc$onMissingMethod
0.915 ms 0.915 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc$getMaxTemp
1.55 ms 0.775 ms 2 /mnt/gadmin4/schema/site.cfc$getDefaultLanguage
4.62 ms 0.513 ms 9 /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc$get
1.94 ms 0.486 ms 4 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadminBase.cfc$toStruct
0.471 ms 0.471 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc$getMinTemp
0.432 ms 0.432 ms 1 /mnt/webroot/sites/toggenburg/nav/globalvars.cfm
0.382 ms 0.382 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/weatherxml.cfc$getWeatherXML
0.34 ms 0.34 ms 1 /mnt/webroot/sites/toggenburg/Application.cfc$onRequestStart
4.77 ms 0.198 ms 24 /mnt/gadmin4/cfc/settings.cfc$getDatasource
0.194 ms 0.194 ms 1 /mnt/webroot/sites/toggenburg/nav/share.cfm
0.181 ms 0.181 ms 1 /mnt/webroot/sites/toggenburg/nav/meta.cfm
0.137 ms 0.137 ms 1 /mnt/webroot/sites/toggenburg/Application.cfc
0.121 ms 0.121 ms 1 /mnt/webroot/sites/toggenburg/Application.cfc$onSessionStart
0.115 ms 0.115 ms 1 /mnt/webroot/sites/toggenburg/nav/pdf.cfm
0.826 ms 0.103 ms 8 /mnt/webroot/sites/toggenburg/customtags/gpage.cfm
0.075 ms 0.075 ms 1 /mnt/webroot/sites/toggenburg/nav/social.cfm
0.12 ms 0.06 ms 2 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc$getImages
40.7 ms 0.055 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
0.942 ms 0.055 ms 17 /mnt/gadmin4/config.cfc
0.042 ms 0.042 ms 1 /mnt/webroot/sites/toggenburg/nav/breadcrumb.cfm
0.895 ms 0.033 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Result.cfc
0.031 ms 0.031 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc
0.027 ms 0.027 ms 1 /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc$init
0.66 ms 0.024 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc
0.073 ms 0.024 ms 3 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadminBase.cfc
0.02 ms 0.02 ms 1 /mnt/webroot/sites/toggenburg/nav/google.cfm
0.02 ms 0.02 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc
0.019 ms 0.019 ms 1 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc
0.017 ms 0.017 ms 1 /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc
0.017 ms 0.017 ms 1 /mnt/gadmin4/cfc/parameter.cfc$parameterContains
0.014 ms 0.014 ms 1 /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc
0.35 ms 0.012 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc$init
0.545 ms 0.012 ms 17 /mnt/gadmin4/cfc/settings.cfc
0.012 ms 0.012 ms 1 /mnt/webroot/sites/toggenburg/functions/watchMake.cfm
0.276 ms 0.01 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc$init
0.054 ms 0.009 ms 6 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadminBase.cfc$getQueryByName
0.006 ms 0.006 ms 1 /mnt/webroot/sites/toggenburg/functions/getLanguages.cfm
0.012 ms 0.006 ms 2 /mnt/webroot/sites/toggenburg/cfc/gadmin/image.cfc
0.101 ms 0.005 ms 17 /mnt/gadmin4/cfc/settings.cfc$setDumpDatasource
0.486 ms 0.005 ms 91 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc$addParam
0.496 ms 0.005 ms 96 /mnt/webroot/sites/toggenburg/WEB-INF/railo/context/Component.cfc
0.005 ms 0.005 ms 1 /mnt/webroot/sites/toggenburg/functions/addCloudPhrase.cfm
0.019 ms 0.004 ms 4 /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc$setProperty
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/function/watchLoad.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/resolveHref.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/getResorts.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/showSubMainNavigation.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/getUrl.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/flushNavigationNodeById.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/parseSwissGrid.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/getNodeTree.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/prepareUrl.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/getPageNavcode.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/getNode.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/stParseText.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/functions/showAddresses.cfm
0.004 ms 0.004 ms 1 /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc$init
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getNavigationTree.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getDefLang.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/startsWith.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getPage.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/showSubFootNavigation.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/removeFromUrl.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getFinderList.cfm
0.405 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getNodePageDetail.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/QueryToStruct.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/isNodePage.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/arrayInt.cfm
0.384 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getCloudPhrase.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/setLang.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getNodePage.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getAddresses.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/isBot.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/runMacros.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getCaption.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getKeyList.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getChildren.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getPathInfo.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/functions/getPhrase.cfm
0.003 ms 0.003 ms 1 /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc$init
0.046 ms 0.002 ms 17 /mnt/gadmin4/cfc/settings.cfc$setDatasource
2.6 ms 0.002 ms 4 /mnt/gadmin4/schema/page.cfc
0.005 ms 0.002 ms 2 /mnt/webroot/sites/toggenburg/cfc/gadmin/image.cfc$init
0.002 ms 0.002 ms 1 /mnt/webroot/sites/toggenburg/functions/getLocalHostName.cfm
0.002 ms 0.002 ms 1 /mnt/webroot/sites/toggenburg/functions/getNodeId.cfm
0.002 ms 0.002 ms 1 /mnt/webroot/sites/toggenburg/functions/getPageDetail.cfm
0.049 ms 0.001 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Result.cfc$setResult
0.035 ms 0.001 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Result.cfc$getResult
0.033 ms 0.001 ms 27 /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Result.cfc$setPrefix
0 ms 0 ms 1 /mnt/pages/242/de/11187_85952_de.cfm
0 ms 0 ms 1 /mnt/webroot/sites/toggenburg/nav/main_top.cfm
0 ms 0 ms 1 /mnt/webroot/sites/toggenburg/nav/header.cfm
0 ms 0 ms 1 /mnt/webroot/sites/toggenburg/nav/footer.cfm
0 ms 0 ms 1 /mnt/webroot/sites/toggenburg/nav/toolbar_bot.cfm
41.2 ms 0 ms 7 /mnt/gadmin4/cfc/parameter.cfc
1.24 ms 0 ms 2 /mnt/gadmin4/schema/site.cfc
0 ms 0 ms 2 /mnt/gadmin4/schema/template.cfc
0 ms 0 ms 2 /mnt/gadmin4/schema/node.cfc
0 ms 0 ms 2 /mnt/webroot/sites/toggenburg/cfc/output.cfc$dumpPage
43.7 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2629 ms  APPLICATION EXECUTION TIME
85.4 ms  QUERY EXECUTION TIME
2758 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /mnt/gadmin4/cfc/parameter.cfc 44 cfquery 8
variables /mnt/gadmin4/cfc/settings.cfc 71 cfquery 1
variables /mnt/gadmin4/schema/page.cfc 2060 cfquery 2
variables /mnt/gadmin4/schema/site.cfc 23 cfquery 2
variables /mnt/gadmin4/schema/site.cfc 23 getUserLanguagesQuery 2
variables /mnt/gadmin4/schema/site.cfc 25 GETUSERLANGUAGESQUERY 2
variables /mnt/gadmin4/schema/site.cfc 30 getLanguagesQuery 2
variables /mnt/gadmin4/schema/site.cfc 30 cfquery 2
variables /mnt/gadmin4/schema/site.cfc 36 GETLANGUAGESQUERY 2
variables /mnt/gadmin4/schema/site.cfc 43 DEFAULTLANGUAGE 2
variables /mnt/gadmin4/schema/site.cfc 45 DEFAULTLANGUAGE 2
variables /mnt/gadmin4/schema/site.cfc 52 DEFAULTLANGUAGE 2
variables /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc 123 I 10
variables /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc 124 I 2
variables /mnt/webroot/sites/toggenburg/cfc/gadmin/gadmin.cfc 125 I 2
variables /mnt/webroot/sites/toggenburg/cfc/gadmin/image.cfc 53 I 10
variables /mnt/webroot/sites/toggenburg/cfc/gadmin/image.cfc 54 I 2
variables /mnt/webroot/sites/toggenburg/cfc/gadmin/image.cfc 55 I 2
variables /mnt/webroot/sites/toggenburg/cfc/output.cfc 762 cfquery 5
variables /mnt/webroot/sites/toggenburg/cfc/output.cfc 840 cfquery 1
variables /mnt/webroot/sites/toggenburg/cfc/output.cfc 1078 cfquery 1
variables /mnt/webroot/sites/toggenburg/cfc/output.cfc 1918 getAvailableDetailsQuery 4
variables /mnt/webroot/sites/toggenburg/cfc/output.cfc 1918 cfquery 4
variables /mnt/webroot/sites/toggenburg/cfc/output.cfc 1920 GETAVAILABLEDETAILSQUERY 4
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 71 URLTORENDER 1
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 87 URLTORENDER 1
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 87 SERVICEURL 1
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 89 key 7
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 90 SERVICEURL 14
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 90 KEY 14
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 113 SERVICEURL 1
variables /mnt/webroot/sites/toggenburg/cfc/PDFRenderer.cfc 114 URLTORENDER 1
arguments /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm 24 NIDS 14
arguments /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm 25 LANGUAGE 25
arguments /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm 30 LANGUAGE 10
arguments /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm 46 PAGEID 14
arguments /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm 46 LANGUAGE 14
variables /mnt/webroot/sites/toggenburg/functions/getAllNavcodes.cfm 46 GETPAGENAVCODE 14
variables /mnt/webroot/sites/toggenburg/functions/getCloudPhrase.cfm 7 getKeywords 1
variables /mnt/webroot/sites/toggenburg/functions/getCloudPhrase.cfm 7 cfquery 1
variables /mnt/webroot/sites/toggenburg/functions/getCloudPhrase.cfm 10 GETKEYWORDS 1
variables /mnt/webroot/sites/toggenburg/functions/getKeyList.cfm 9 i 3
variables /mnt/webroot/sites/toggenburg/functions/getKeyList.cfm 11 I 2
arguments /mnt/webroot/sites/toggenburg/functions/getNodePage.cfm 10 NODEID 1
variables /mnt/webroot/sites/toggenburg/functions/getNodePage.cfm 14 GETPAGE 1
arguments /mnt/webroot/sites/toggenburg/functions/getPage.cfm 10 PAGEID 1
arguments /mnt/webroot/sites/toggenburg/functions/getPageNavcode.cfm 13 LANGUAGE 18
arguments /mnt/webroot/sites/toggenburg/functions/getPageNavcode.cfm 13 ID 18
arguments /mnt/webroot/sites/toggenburg/functions/getPageNavcode.cfm 18 LANGUAGE 3
arguments /mnt/webroot/sites/toggenburg/functions/getPageNavcode.cfm 19 ID 3
variables /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm 24 cfquery 1
variables /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm 30 QUERYTOSTRUCT 1
variables /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm 33 STORAGEIMAGESSTRUCT 1
variables /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm 34 STORAGEIMAGESSTRUCT 1
variables /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm 36 STORAGEIMAGESSTRUCT 1
variables /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 33 GETURLS 14
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 79 SITEID 14
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 79 LANGUAGE 14
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 79 PAGEID 14
variables /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 86 ISNODEPAGE 3
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 86 PAGEID 3
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 101 PAGEID 3
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 102 SITEID 3
query /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 112 NAVPATH 17
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 113 NAVLEVEL 17
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 114 NAVLEVEL 51
query /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 118 NAVPATH 17
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 120 LANGUAGE 28
variables /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 120 GETALLNAVCODES 14
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 120 PAGEID 14
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 122 LANGUAGE 6
arguments /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 122 PAGEID 3
variables /mnt/webroot/sites/toggenburg/functions/getUrl.cfm 122 GETPAGENAVCODE 3
arguments /mnt/webroot/sites/toggenburg/functions/isNodePage.cfm 10 ID 3
arguments /mnt/webroot/sites/toggenburg/functions/setLang.cfm 61 SAVE 1
variables /mnt/webroot/sites/toggenburg/functions/stParseText.cfm 45 GETURL 4
variables /mnt/webroot/sites/toggenburg/functions/stParseText.cfm 49 STPARSETEXT 4
variables /mnt/webroot/sites/toggenburg/functions/stParseText.cfm 49 STRING 4
variables /mnt/webroot/sites/toggenburg/functions/stParseText.cfm 51 STRING 4
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 14 elemChild 6
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 15 ELEMCHILD 6
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 16 ELEMCHILD 3
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 17 ELEMCHILD 2
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 115 dayInfo 12
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 116 symbolSearch 32
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 116 DAYINFO 12
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 117 SYMBOLSEARCH 32
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 119 SYMBOLSEARCH 4
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 120 rangeSearch 8
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 120 DAYINFO 4
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 121 RANGESEARCH 8
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 122 validDates 8
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 122 RANGESEARCH 4
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 123 VALIDDATES 12
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 124 VALIDDATES 8
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoBase.cfc 125 VALIDDATES 8
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 116 dayInfo 2
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 117 DAYINFO 2
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 127 dayInfo 1
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 128 DAYINFO 1
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 203 DAY0 1
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 204 DAY0 3
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 220 validation 2
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 221 VALIDATION 3
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 222 VALIDATION 2
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 223 VALIDATION 2
variables /mnt/webroot/sites/toggenburg/html/wetter/sfmeteo/SFMeteoController.cfc 224 VALIDATION 1
variables /mnt/webroot/sites/toggenburg/html/wetter/weatherxml.cfc 15 cfquery 1
arguments /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 11 PARENT 3
arguments /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 12 PARENT 15
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 14 GETPATHINFO 15
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 29 GETNAVIGATIONTREE 1
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 32 elem 3
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 34 ELEM 3
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 35 GETPATHINFO 3
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 35 ELEM 3
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 36 ELEM 3
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 37 BUILDFOOTERNAVISUB 3
variables /mnt/webroot/sites/toggenburg/nav/footernavi.cfm 37 ELEM 3
arguments /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 9 PARENT 22
arguments /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 10 PARENT 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 11 NODEURL 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 12 NODEHREF 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 13 GETPATHINFO 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 13 ISACTIVE 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 14 ISACTIVE 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 15 ISACTIVE 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 15 NODEHREF 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 15 NODEURL 131
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 18 NAVIBLOCKNODEIDS 17
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 19 BUILDMAINNAVISUB 16
arguments /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 19 MAINTREE 16
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 19 NODEURL 16
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 27 GETNAVIGATIONTREE 1
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 30 elem 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 31 ELEM 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 31 NODEURL 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 32 NODEHREF 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 33 ELEM 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 33 ISACTIVE 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 33 GETPATHINFO 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 34 ISACTIVE 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 35 NODEURL 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 35 NODEHREF 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 35 ELEM 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 35 ISACTIVE 7
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 36 ELEM 13
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 36 NAVIBLOCKNODEIDS 6
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 37 ELEM 6
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 37 BUILDMAINNAVISUB 6
variables /mnt/webroot/sites/toggenburg/nav/mainnavi.cfm 37 NODEURL 6
url /mnt/webroot/sites/toggenburg/nav/params.cfm 209 skin 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 16 GETPATHINFO 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 30 ISHOME 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 31 topNodeIdx 3
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 32 ISMICROSITE 2
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 32 TOPNODEIDX 2
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 32 MICROSITESNODEID 2
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 33 GETNAVIGATIONTREE 2
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 34 ISWARENKORB 2
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 44 ISMICROSITE 2
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 49 GETNODEPAGE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 49 NPAGE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 49 PARENTNODE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 51 NPAGE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 51 GETPAGENAVCODE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 55 GETNAVIGATIONTREE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 55 PARENTNODE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 93 SHOWQUICKBOX 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 95 SHOWMEDIUMRECTANGLE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 95 OST_MEDIUM_RECTANGLE_PAGE 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 97 REISEBERATUNGPAGE 3
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 97 SHOWREISEBERATUNG 1
variables /mnt/webroot/sites/toggenburg/nav/subnavi.cfm 97 STPARSETEXT 1
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc 274 METHODNAME 162
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc 275 METHODNAME 81
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc 302 METHODARGUMENTS 54
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc 174 PARAMS 97
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Query.cfc 175 NAME 401
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc 12 PATH 10
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc 12 ARGS 1
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc 13 PATH 9
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc 20 ARGS 1
arguments /mnt/webroot/sites/toggenburg/WEB-INF/railo/lib/service-libs/cfc/SingletonFactory.cfc 24 PATH 2


SQL Queries

getNodeAssociationsQuery (Datasource=web, Time=0.701 ms, Records=3) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
			select 
				REL.NODE_ID as nodeId
			from G_NODES_PAGES_REL REL
				join G_NODES N on (N.NODE_ID=REL.NODE_ID and N.DELETED=0) 
				join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=242)
			where REL.PAGE_ID=85952
			
		
getNodePageIdFromNavcodeQuery (Datasource=web, Time=0.805 ms, Records=1) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
the following colum(s) are never read within the request:pageId
			select 
				PD.PAGE_ID as pageId,
				
				
				N.NODE_ID as nodeId
			from G_PAGES_DETAILS PD
				join G_PAGES P on (P.PAGE_ID=PD.PAGE_ID and P.DELETED=0)
				join G_NODES N on (N.PAGE_ID=P.PAGE_ID and N.DELETED=0)
				join G_NODES_SITES_REL REL on (REL.NODE_ID=N.NODE_ID and REL.SITE_ID=242)
				
			where PD.NAVCODE='sommeraktivitaeten'
				and PD.DELETED=0
			
			limit 1
		
gTmpParentNodeQuery (Datasource=, Time=0.119 ms, Records=0) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
the following colum(s) are never read within the request:nodeid
									SELECT * FROM gTmpPageNode WHERE nodeId=65326
								
getKeywords (Datasource=web, Time=0.381 ms, Records=14) in /mnt/webroot/sites/toggenburg/functions/getCloudPhrase.cfm
the following colum(s) are never read within the request:url
    	select 
        	searchphrase,url FROM searchcloud_phrases_toggenburg 
        where 
        	language = 'de'
        order by count desc limit 14
    
q (Datasource=web, Time=0.42 ms, Records=9) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					SELECT
                                    page_id as page_id
                                FROM g_pages_sites_rel
                                    JOIN g_pages_details USING (page_id)
                                    WHERE site_id = 242
                                    /*resolve_navcodes*/
                                     AND page_id in ( 184488,184489,184513,184524,184525,184514,184365,184464,184419 ) 
                                
                                UNION
                                
                                SELECT
                                    n.page_id as page_id
                                FROM g_nodes_sites_rel nsr
                                    JOIN g_nodes n on (n.node_id = nsr.node_id)
                                    JOIN g_pages_details USING (page_id)
                                    WHERE n.page_id is not null
                                    AND nsr.site_id = 242
                                    /*resolve_navcodes*/
                                     AND page_id in ( 184488,184489,184513,184524,184525,184514,184365,184464,184419 )
				
q (Datasource=web, Time=2.02 ms, Records=6) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					SELECT 
                        IFNULL(PD.PAGE_ID,PDDFLT.PAGE_ID) as pageId
                        ,P.online_from as online_from
                        ,P.online_to as online_to
                        ,NULL as nodeId
                        ,NULL as nodeOrder
                        ,PD.VISIBLE as visibleLang
                        ,P.sortorder IS NULL AS isnull
                        ,IFNULL(PD.dropdown,PDDFLT.dropdown) as dropdown
                        ,IFNULL(PD.meta_description,PDDFLT.meta_description) as metaDescription
                        ,IFNULL(PD.meta_keywords,PDDFLT.meta_keywords) as metaKeywords
                        ,IFNULL(PD.meta_title,PDDFLT.meta_title) as metaTitle
                        ,IFNULL(PD.title_offe,PDDFLT.title_offe) as title
                        ,IFNULL(PD.alt_title_offe,PDDFLT.alt_title_offe) as alt_title_offe
                        ,PD.alt_title_offe as alt_title_offe_orig
                        ,IFNULL(PD.booking_info,PDDFLT.booking_info) as booking_info
                        ,IFNULL(PD.text1,PDDFLT.text1) as text1
                        ,IFNULL(PD.text2,PDDFLT.text2) as text2
                        ,IFNULL(PD.text3,PDDFLT.text3) as text3
                        ,IFNULL(PD.text4,PDDFLT.text4) as text4
                        ,IFNULL(PD.text5,PDDFLT.text5) as text5
                        ,IFNULL(PD.alt_text1,PDDFLT.alt_text1) as alt_text1
                        ,IFNULL(PD.alt_text2,PDDFLT.alt_text2) as alt_text2
                        ,IFNULL(PD.alt_text3,PDDFLT.alt_text3) as alt_text3
                        ,IFNULL(PD.url,PDDFLT.url) as url
                        ,IFNULL(PD.url_text,PDDFLT.url_text) as url_text
                        ,IFNULL(PD.url2,PDDFLT.url2) as url2
                        ,IFNULL(PD.url2_text,PDDFLT.url2_text) as url2_text
                        ,IFNULL(PD.url_logo,PDDFLT.url_logo) as url_logo
                        ,IFNULL(PD.url2_logo,PDDFLT.url2_logo) as url2_logo
                        ,IFNULL(PD.abstract1,PDDFLT.abstract1) as abstract1
                        ,IFNULL(PD.abstract2,PDDFLT.abstract2) as abstract2
                        ,IFNULL(PD.place,PDDFLT.place) as place
                        ,IFNULL(PD.navcode,PDDFLT.navcode) as navcode
                        ,IFNULL(PD.address,PDDFLT.address) as address
                        ,P.fk_angebotsfinder_id as angebotsfinderId
                        ,P.flags
                        ,P.postcode
                        ,P.disable_dropdown
                        ,P.sortorder as sortorder
                        ,P.nonbookable as nonbookable
                        ,P.r_key as rKey
                        ,P.s_key as sKey
                        ,P.ORIG_ID as origId
                        ,IFNULL(IF(P.x_coord=0,NULL,P.x_coord),IF(IFNULL((select x from r_addresses where pk_address=P.INFRA_FK_ADDRESS),0)>0,(select x from r_addresses where pk_address=P.INFRA_FK_ADDRESS),(select x from r_resorts where pk_resort=P.R_KEY))) as x_coord
                        ,IFNULL(IF(P.y_coord=0,NULL,P.y_coord),IF(IFNULL((select y from r_addresses where pk_address=P.INFRA_FK_ADDRESS),0)>0,(select y from r_addresses where pk_address=P.INFRA_FK_ADDRESS),(select y from r_resorts where pk_resort=P.R_KEY))) as y_coord
                        ,P.INFRA_FK_ADDRESS as adr_key
                        ,P.HOTEL_ID as hotel_id
                        ,P.cugbenutzername
                        ,P.cugpasswort
                        ,IFNULL(
                            (select OLDT.DATEI from G_TEMPLATES T join GCS_TEMPLATES OLDT on (OLDT.PK_GCS_TEMPLATES_ID=T.OLD_TEMPLATE_ID) where T.TEMPLATE_ID=P.TEMPLATE_ID),
                            (select T.DATEI from G_NODES_PAGES_REL NP
                                join G_NODES N on (N.NODE_ID=NP.NODE_ID and N.DELETED=0)
                                join G_PAGES PN on (PN.PAGE_ID=N.PAGE_ID and PN.DELETED=0)
                                join GCS_TEMPLATES T on (T.PK_GCS_TEMPLATES_ID=PN.OLD_GCS_TEMPLATE_ID)
                            where NP.PAGE_ID=P.PAGE_ID limit 1)) as templateId
                        ,NULL as nodeAction
                        ,IFNULL(PD.textfield1,PDDFLT.textfield1) as textfield1
                        ,IFNULL(PD.textfield2,PDDFLT.textfield2) as textfield2
                        ,IFNULL(PD.textfield3,PDDFLT.textfield3) as textfield3
                        ,IFNULL(PD.textfield4,PDDFLT.textfield4) as textfield4
                        ,IFNULL(PD.textfield5,PDDFLT.textfield5) as textfield5
                        ,IFNULL(PD.textfield6,PDDFLT.textfield6) as textfield6
                        ,IFNULL(PD.textfield7,PDDFLT.textfield7) as textfield7
                        ,IFNULL(PD.textfield8,PDDFLT.textfield8) as textfield8
                        ,IFNULL(PD.textfield9,PDDFLT.textfield9) as textfield9
                        ,IFNULL(PD.textfield10,PDDFLT.textfield10) as textfield10
                        ,IFNULL(PD.textarea1,PDDFLT.textarea1) as textarea1
                        ,IFNULL(PD.textarea2,PDDFLT.textarea2) as textarea2
                        ,IFNULL(PD.textarea3,PDDFLT.textarea3) as textarea3
                        ,IFNULL(PD.textarea4,PDDFLT.textarea4) as textarea4
                        ,IFNULL(PD.textarea5,PDDFLT.textarea5) as textarea5
                        ,IFNULL(PD.textarea6,PDDFLT.textarea6) as textarea6
                        ,IFNULL(PD.textarea7,PDDFLT.textarea7) as textarea7
                        ,IFNULL(PD.textarea8,PDDFLT.textarea8) as textarea8
                        ,IFNULL(PD.textarea9,PDDFLT.textarea9) as textarea9
                        ,IFNULL(PD.textarea10,PDDFLT.textarea10) as textarea10
                        ,IFNULL(PD.img_logo1,PDDFLT.img_logo1) as img_logo1
                        ,IFNULL(PD.img_logo2,PDDFLT.img_logo2) as img_logo2
                        ,IFNULL(PD.info_sdm,PDDFLT.info_sdm) as info_sdm
                        ,IFNULL(PD.destination_maps,PDDFLT.destination_maps) as destination_maps
                        ,IFNULL(PD.alt_dropdown,PDDFLT.alt_dropdown) as alt_dropdown
                        ,P.pictograms
                        ,r.name as resort
                        ,r.x as x_coord_mobile
                        ,r.y as y_coord_mobile
                        ,P.valid_from
                        ,P.valid_to
                        ,P.registeredUsers
                        ,IFNULL(PNPD.navcode,PNPDDFLT.navcode) as subcat
                        ,IFNULL(PNPD.title_offe,PNPDDFLT.title_offe) as subcat_title
                        ,IFNULL(PNPD.abstract1,PNPDDFLT.abstract1) as subcat_abstract1
                        ,IFNULL(PNPD.abstract2,PNPDDFLT.abstract2) as subcat_abstract2
                        ,P.VISIBLE as visiblePage
                        ,re.region_de as region
                        ,P.DEFAULT_LANG as defaultLanguage
                        ,PD.language as language
                        /*FROM*/
                        from G_PAGES P
                        left outer join G_PAGES_DETAILS/*preview*/ PD on (PD.PAGE_ID=P.PAGE_ID
                            and PD.DELETED=0
                            and PD.LANGUAGE='de')
                        left outer join G_PAGES_DETAILS PDDFLT on (PDDFLT.PAGE_ID=P.PAGE_ID
                            and PDDFLT.DELETED=0
                            and PDDFLT.VISIBLE=1
                            and PDDFLT.LANGUAGE=P.DEFAULT_LANG)
                        left outer join r_resorts r on ( P.r_key = r.pk_resort )
                        left outer join r_regions re on ( r.fk_region = re.pk_region )
                        left outer join G_PAGES_DETAILS PNPD on (PNPD.PAGE_ID=P.PAGE_ID
                            and PNPD.DELETED=0
                            and PNPD.VISIBLE=1
                            and PNPD.LANGUAGE='de')
                        left outer join G_PAGES_DETAILS PNPDDFLT on (PNPDDFLT.PAGE_ID=P.PAGE_ID
                            and PNPDDFLT.DELETED=0
                            and PNPDDFLT.VISIBLE=1
                            and PNPDDFLT.LANGUAGE=P.DEFAULT_LANG)
                        where 1 = 1
                             and P.PAGE_ID in ( 184365,184419,184488,184489,184524,184525,184464,184513,184514 ) 
                            and P.DELETED=0
                            and P.VISIBLE=1
                            and PD.VISIBLE IS NOT NULL /* null when language not existing */
                         order by isnull,sortorder  LIMIT 15 OFFSET 0
				
q (Datasource=web, Time=2.53 ms, Records=2) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					SELECT
                                    page_id as page_id
                                FROM g_pages_sites_rel
                                    JOIN g_pages_details USING (page_id)
                                    WHERE site_id = 242
                                     AND navcode in ( 'aktivurlaub','sommer','sommeraktivitaeten','85952' ) 
                                    /*resolve_pageIds*/
                                
                                UNION
                                
                                SELECT
                                    n.page_id as page_id
                                FROM g_nodes_sites_rel nsr
                                    JOIN g_nodes n on (n.node_id = nsr.node_id)
                                    JOIN g_pages_details USING (page_id)
                                    WHERE n.page_id is not null
                                    AND nsr.site_id = 242
                                     AND navcode in ( 'aktivurlaub','sommer','sommeraktivitaeten','85952' ) 
                                    /*resolve_pageIds*/
				
q (Datasource=web, Time=3.08 ms, Records=2) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					SELECT 
                        IFNULL(PD.PAGE_ID,PDDFLT.PAGE_ID) as pageId
                        ,P.online_from as online_from
                        ,P.online_to as online_to
                        ,NULL as nodeId
                        ,NULL as nodeOrder
                        ,PD.VISIBLE as visibleLang
                        ,P.sortorder IS NULL AS isnull
                        ,IFNULL(PD.dropdown,PDDFLT.dropdown) as dropdown
                        ,IFNULL(PD.meta_description,PDDFLT.meta_description) as metaDescription
                        ,IFNULL(PD.meta_keywords,PDDFLT.meta_keywords) as metaKeywords
                        ,IFNULL(PD.meta_title,PDDFLT.meta_title) as metaTitle
                        ,IFNULL(PD.title_offe,PDDFLT.title_offe) as title
                        ,IFNULL(PD.alt_title_offe,PDDFLT.alt_title_offe) as alt_title_offe
                        ,PD.alt_title_offe as alt_title_offe_orig
                        ,IFNULL(PD.booking_info,PDDFLT.booking_info) as booking_info
                        ,IFNULL(PD.text1,PDDFLT.text1) as text1
                        ,IFNULL(PD.text2,PDDFLT.text2) as text2
                        ,IFNULL(PD.text3,PDDFLT.text3) as text3
                        ,IFNULL(PD.text4,PDDFLT.text4) as text4
                        ,IFNULL(PD.text5,PDDFLT.text5) as text5
                        ,IFNULL(PD.alt_text1,PDDFLT.alt_text1) as alt_text1
                        ,IFNULL(PD.alt_text2,PDDFLT.alt_text2) as alt_text2
                        ,IFNULL(PD.alt_text3,PDDFLT.alt_text3) as alt_text3
                        ,IFNULL(PD.url,PDDFLT.url) as url
                        ,IFNULL(PD.url_text,PDDFLT.url_text) as url_text
                        ,IFNULL(PD.url2,PDDFLT.url2) as url2
                        ,IFNULL(PD.url2_text,PDDFLT.url2_text) as url2_text
                        ,IFNULL(PD.url_logo,PDDFLT.url_logo) as url_logo
                        ,IFNULL(PD.url2_logo,PDDFLT.url2_logo) as url2_logo
                        ,IFNULL(PD.abstract1,PDDFLT.abstract1) as abstract1
                        ,IFNULL(PD.abstract2,PDDFLT.abstract2) as abstract2
                        ,IFNULL(PD.place,PDDFLT.place) as place
                        ,IFNULL(PD.navcode,PDDFLT.navcode) as navcode
                        ,IFNULL(PD.address,PDDFLT.address) as address
                        ,P.fk_angebotsfinder_id as angebotsfinderId
                        ,P.flags
                        ,P.postcode
                        ,P.disable_dropdown
                        ,P.sortorder as sortorder
                        ,P.nonbookable as nonbookable
                        ,P.r_key as rKey
                        ,P.s_key as sKey
                        ,P.ORIG_ID as origId
                        ,IFNULL(IF(P.x_coord=0,NULL,P.x_coord),IF(IFNULL((select x from r_addresses where pk_address=P.INFRA_FK_ADDRESS),0)>0,(select x from r_addresses where pk_address=P.INFRA_FK_ADDRESS),(select x from r_resorts where pk_resort=P.R_KEY))) as x_coord
                        ,IFNULL(IF(P.y_coord=0,NULL,P.y_coord),IF(IFNULL((select y from r_addresses where pk_address=P.INFRA_FK_ADDRESS),0)>0,(select y from r_addresses where pk_address=P.INFRA_FK_ADDRESS),(select y from r_resorts where pk_resort=P.R_KEY))) as y_coord
                        ,P.INFRA_FK_ADDRESS as adr_key
                        ,P.HOTEL_ID as hotel_id
                        ,P.cugbenutzername
                        ,P.cugpasswort
                        ,IFNULL(
                            (select OLDT.DATEI from G_TEMPLATES T join GCS_TEMPLATES OLDT on (OLDT.PK_GCS_TEMPLATES_ID=T.OLD_TEMPLATE_ID) where T.TEMPLATE_ID=P.TEMPLATE_ID),
                            (select T.DATEI from G_NODES_PAGES_REL NP
                                join G_NODES N on (N.NODE_ID=NP.NODE_ID and N.DELETED=0)
                                join G_PAGES PN on (PN.PAGE_ID=N.PAGE_ID and PN.DELETED=0)
                                join GCS_TEMPLATES T on (T.PK_GCS_TEMPLATES_ID=PN.OLD_GCS_TEMPLATE_ID)
                            where NP.PAGE_ID=P.PAGE_ID limit 1)) as templateId
                        ,NULL as nodeAction
                        ,IFNULL(PD.textfield1,PDDFLT.textfield1) as textfield1
                        ,IFNULL(PD.textfield2,PDDFLT.textfield2) as textfield2
                        ,IFNULL(PD.textfield3,PDDFLT.textfield3) as textfield3
                        ,IFNULL(PD.textfield4,PDDFLT.textfield4) as textfield4
                        ,IFNULL(PD.textfield5,PDDFLT.textfield5) as textfield5
                        ,IFNULL(PD.textfield6,PDDFLT.textfield6) as textfield6
                        ,IFNULL(PD.textfield7,PDDFLT.textfield7) as textfield7
                        ,IFNULL(PD.textfield8,PDDFLT.textfield8) as textfield8
                        ,IFNULL(PD.textfield9,PDDFLT.textfield9) as textfield9
                        ,IFNULL(PD.textfield10,PDDFLT.textfield10) as textfield10
                        ,IFNULL(PD.textarea1,PDDFLT.textarea1) as textarea1
                        ,IFNULL(PD.textarea2,PDDFLT.textarea2) as textarea2
                        ,IFNULL(PD.textarea3,PDDFLT.textarea3) as textarea3
                        ,IFNULL(PD.textarea4,PDDFLT.textarea4) as textarea4
                        ,IFNULL(PD.textarea5,PDDFLT.textarea5) as textarea5
                        ,IFNULL(PD.textarea6,PDDFLT.textarea6) as textarea6
                        ,IFNULL(PD.textarea7,PDDFLT.textarea7) as textarea7
                        ,IFNULL(PD.textarea8,PDDFLT.textarea8) as textarea8
                        ,IFNULL(PD.textarea9,PDDFLT.textarea9) as textarea9
                        ,IFNULL(PD.textarea10,PDDFLT.textarea10) as textarea10
                        ,IFNULL(PD.img_logo1,PDDFLT.img_logo1) as img_logo1
                        ,IFNULL(PD.img_logo2,PDDFLT.img_logo2) as img_logo2
                        ,IFNULL(PD.info_sdm,PDDFLT.info_sdm) as info_sdm
                        ,IFNULL(PD.destination_maps,PDDFLT.destination_maps) as destination_maps
                        ,IFNULL(PD.alt_dropdown,PDDFLT.alt_dropdown) as alt_dropdown
                        ,P.pictograms
                        ,r.name as resort
                        ,r.x as x_coord_mobile
                        ,r.y as y_coord_mobile
                        ,P.valid_from
                        ,P.valid_to
                        ,P.registeredUsers
                        ,IFNULL(PNPD.navcode,PNPDDFLT.navcode) as subcat
                        ,IFNULL(PNPD.title_offe,PNPDDFLT.title_offe) as subcat_title
                        ,IFNULL(PNPD.abstract1,PNPDDFLT.abstract1) as subcat_abstract1
                        ,IFNULL(PNPD.abstract2,PNPDDFLT.abstract2) as subcat_abstract2
                        ,P.VISIBLE as visiblePage
                        ,re.region_de as region
                        ,P.DEFAULT_LANG as defaultLanguage
                        ,PD.language as language
                        /*FROM*/
                        from G_PAGES P
                        left outer join G_PAGES_DETAILS/*preview*/ PD on (PD.PAGE_ID=P.PAGE_ID
                            and PD.DELETED=0
                            and PD.LANGUAGE='de')
                        left outer join G_PAGES_DETAILS PDDFLT on (PDDFLT.PAGE_ID=P.PAGE_ID
                            and PDDFLT.DELETED=0
                            and PDDFLT.VISIBLE=1
                            and PDDFLT.LANGUAGE=P.DEFAULT_LANG)
                        left outer join r_resorts r on ( P.r_key = r.pk_resort )
                        left outer join r_regions re on ( r.fk_region = re.pk_region )
                        left outer join G_PAGES_DETAILS PNPD on (PNPD.PAGE_ID=P.PAGE_ID
                            and PNPD.DELETED=0
                            and PNPD.VISIBLE=1
                            and PNPD.LANGUAGE='de')
                        left outer join G_PAGES_DETAILS PNPDDFLT on (PNPDDFLT.PAGE_ID=P.PAGE_ID
                            and PNPDDFLT.DELETED=0
                            and PNPDDFLT.VISIBLE=1
                            and PNPDDFLT.LANGUAGE=P.DEFAULT_LANG)
                        where 1 = 1
                             and P.PAGE_ID in ( 185006,185058 ) 
                            and P.DELETED=0
                            and P.VISIBLE=1
                            and PD.VISIBLE IS NOT NULL /* null when language not existing */
                         order by isnull,sortorder  LIMIT 15 OFFSET 0
				
q (Datasource=web, Time=2.11 ms, Records=2) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					SELECT /*WRAP_COUNT_QUERY*/
                         * FROM (
                            SELECT
                            distinct
                            pdi2.image_id as imageId
                            ,p.page_id as pageId
                            ,p.sortorder as sortorder
                            ,pd.language as lang
                            ,iv.width
                            ,iv.height
                            ,pdi2.position as imgPosition
                            ,iv.images_size_id as sizeId
                            ,concat('http://images.gadmin.st.s3.amazonaws.com/',iv.filepath) as path
                            ,concat('/*pathimg*//',i.basepath,'/orig/',i.image_id,'.',i.fileextension) as origPath
                            ,concat('/*pathimg*//',i.basepath,'/thumb/',i.image_id,'.',i.fileextension) as thumbPath
                            ,IFNULL( (SELECT pdi.caption FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=pd.language and pdi.position=imgPosition), (SELECT pdi.caption FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=p.default_lang and pdi.position=imgPosition) ) as pageCaption
                            ,IFNULL( (SELECT pdi.url FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=pd.language and pdi.position=imgPosition), (SELECT pdi.url FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=p.default_lang and pdi.position=imgPosition) ) as imgUrl
                            ,i.default_lang as iDfltLang
                            ,IFNULL( ( SELECT gid2.caption FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=lang and deleted=p.deleted ), ( SELECT gid2.caption FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=iDfltLang and deleted=p.deleted ) ) as imgCaption
                            ,IFNULL( ( SELECT gid2.place FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=lang and deleted=p.deleted ), ( SELECT gid2.place FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=iDfltLang and deleted=p.deleted ) ) as imgPlace
                            ,CASE pdi2.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN p.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
                            /*FROM*/
                            FROM g_pages p
                                INNER JOIN g_pages_details pd ON p.page_id=pd.page_id AND p.visible=pd.visible AND p.deleted=pd.deleted
                                INNER JOIN G_PAGES_DETAILS_IMAGES_REL pdi2 ON p.page_id=pdi2.page_id
                                INNER JOIN G_IMAGES i ON pdi2.image_id=i.image_id AND p.visible=i.visible AND p.deleted=i.deleted
                                 INNER JOIN G_IMAGES_VERSIONS iv ON pdi2.image_id=iv.image_id
                            WHERE 1 = 1
                                 and p.page_id in ( 85952,185058,185006 ) 
                                /*imageid_query*/
                                and p.deleted = 0
                                and p.visible = 1
                                and pd.language = 'de'
                                 and pdi2.position in ( 9 ) 
                                 and iv.images_size_id in ( 507 ) 
                                 order by langsort  ) as basepath
                        GROUP BY lang /*group_imageid*/ ,pageId ,imgPosition ,sizeId  order by langsort  LIMIT 15 OFFSET 0
				
q (Datasource=web, Time=1.73 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					SELECT /*WRAP_COUNT_QUERY*/
                         * FROM (
                            SELECT
                            distinct
                            pdi2.image_id as imageId
                            ,p.page_id as pageId
                            ,p.sortorder as sortorder
                            ,pd.language as lang
                            ,iv.width
                            ,iv.height
                            ,pdi2.position as imgPosition
                            ,iv.images_size_id as sizeId
                            ,concat('http://images.gadmin.st.s3.amazonaws.com/',iv.filepath) as path
                            ,concat('/*pathimg*//',i.basepath,'/orig/',i.image_id,'.',i.fileextension) as origPath
                            ,concat('/*pathimg*//',i.basepath,'/thumb/',i.image_id,'.',i.fileextension) as thumbPath
                            ,IFNULL( (SELECT pdi.caption FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=pd.language and pdi.position=imgPosition), (SELECT pdi.caption FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=p.default_lang and pdi.position=imgPosition) ) as pageCaption
                            ,IFNULL( (SELECT pdi.url FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=pd.language and pdi.position=imgPosition), (SELECT pdi.url FROM G_PAGES_DETAILS_IMAGES_REL pdi WHERE pdi.page_id=pageId and language=p.default_lang and pdi.position=imgPosition) ) as imgUrl
                            ,i.default_lang as iDfltLang
                            ,IFNULL( ( SELECT gid2.caption FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=lang and deleted=p.deleted ), ( SELECT gid2.caption FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=iDfltLang and deleted=p.deleted ) ) as imgCaption
                            ,IFNULL( ( SELECT gid2.place FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=lang and deleted=p.deleted ), ( SELECT gid2.place FROM G_IMAGES_DETAILS gid2 WHERE image_id=imageId and language=iDfltLang and deleted=p.deleted ) ) as imgPlace
                            ,CASE pdi2.language WHEN 'de' THEN 1 WHEN 'de' THEN 2 WHEN p.DEFAULT_LANG THEN 3 ELSE 4 END AS langsort
                            /*FROM*/
                            FROM g_pages p
                                INNER JOIN g_pages_details pd ON p.page_id=pd.page_id AND p.visible=pd.visible AND p.deleted=pd.deleted
                                INNER JOIN G_PAGES_DETAILS_IMAGES_REL pdi2 ON p.page_id=pdi2.page_id
                                INNER JOIN G_IMAGES i ON pdi2.image_id=i.image_id AND p.visible=i.visible AND p.deleted=i.deleted
                                 INNER JOIN G_IMAGES_VERSIONS iv ON pdi2.image_id=iv.image_id
                            WHERE 1 = 1
                                 and p.page_id in ( 85952 ) 
                                /*imageid_query*/
                                and p.deleted = 0
                                and p.visible = 1
                                and pd.language = 'de'
                                 and pdi2.position in ( 1 ) 
                                 and iv.images_size_id in ( 507 ) 
                                 order by langsort  ) as basepath
                        GROUP BY lang /*group_imageid*/ ,pageId ,imgPosition ,sizeId  order by langsort  LIMIT 15 OFFSET 0
				
qParamByID (Datasource=web, Time=0.322 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('cfmapping') and sp.fk_site_id = 242
		
getNodeAssociationsQuery (Datasource=web, Time=0.311 ms, Records=1) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
			select 
				REL.NODE_ID as nodeId
			from G_NODES_PAGES_REL REL
				join G_NODES N on (N.NODE_ID=REL.NODE_ID and N.DELETED=0) 
				join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=242)
			where REL.PAGE_ID=184491
			limit 1
		
getAvailableDetailsQuery (Datasource=web, Time=0.319 ms, Records=2) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
            select LANGUAGE
            from G_PAGES_DETAILS
            where PAGE_ID=184491
            and DELETED=0
        
(Datasource=web_write, Time=0.326 ms, Records=1) in /mnt/gadmin4/cfc/settings.cfc
the following colum(s) are never read within the request:foo
                    select 'foo';
                
qParamByID (Datasource=web, Time=37.3 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('webroot') and sp.fk_site_id = 242
		
getUserLanguagesQuery (Datasource=web, Time=0.315 ms, Records=0) in /mnt/gadmin4/schema/site.cfc
the following colum(s) are never read within the request:languages
            select distinct languages                                                                    
            from g_rights gr
            join g_user gu on (gr.user_id = gu.user_id)
            where gu.username = ''
            and gr.site_id = 242
        
getLanguagesQuery (Datasource=web, Time=0.331 ms, Records=1) in /mnt/gadmin4/schema/site.cfc
            select LANGUAGES 
            from G_SITES 
            where SITE_ID=242
        
qParamByID (Datasource=web, Time=0.412 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('defaultLanguage') and sp.fk_site_id = 242
		
localvars.dumpPagesQuery (Datasource=web, Time=0.322 ms, Records=0) in /mnt/gadmin4/schema/page.cfc
the following colum(s) are never read within the request:pageId
                select PAGE_ID as pageId
                from G_PAGES
                where PAGE_ID IN (184491)
                and DELETED=0
                
                AND VISIBLE=1
                
            
q (Datasource=web, Time=0.672 ms, Records=0) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
the following colum(s) are never read within the request:page_id
					select page_id from g_nodes where page_id = 85952 and deleted = 0
				
q (Datasource=web, Time=0.461 ms, Records=3) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select path as navpath from g_pages_sites_rel
                                where page_id = 85952 and site_id = 242
				
q (Datasource=web, Time=0.3 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'de')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 11187
				
q (Datasource=web, Time=0.7 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
	                        ifnull(pd.navcode,pdflt.navcode) as navcode
	                        from g_pages p
	                        left outer join g_pages_details pd
	                            on (pd.page_id = p.page_id and pd.language = 'de')
	                        left outer join g_pages_details pdflt
	                            on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
	                        where p.page_id = 85952 and p.deleted = 0
				
q (Datasource=web, Time=0.294 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'de')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66637
				
q (Datasource=web, Time=0.585 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'de')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66638
				
q (Datasource=web, Time=0.614 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'de')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66643
				
q (Datasource=web, Time=0.649 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'de')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66940
				
q (Datasource=web, Time=0.267 ms, Records=0) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
the following colum(s) are never read within the request:page_id
					select page_id from g_nodes where page_id = 85952 and deleted = 0
				
q (Datasource=web, Time=0.294 ms, Records=3) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select path as navpath from g_pages_sites_rel
                                where page_id = 85952 and site_id = 242
				
q (Datasource=web, Time=0.33 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'en')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 11187
				
q (Datasource=web, Time=0.678 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
	                        ifnull(pd.navcode,pdflt.navcode) as navcode
	                        from g_pages p
	                        left outer join g_pages_details pd
	                            on (pd.page_id = p.page_id and pd.language = 'en')
	                        left outer join g_pages_details pdflt
	                            on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
	                        where p.page_id = 85952 and p.deleted = 0
				
q (Datasource=web, Time=0.304 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'en')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66637
				
q (Datasource=web, Time=0.732 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'en')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66638
				
q (Datasource=web, Time=17.7 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'en')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66643
				
q (Datasource=web, Time=0.602 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
                ifnull(pd.navcode,pdflt.navcode) as navcode
                from g_nodes n join g_pages p on (p.page_id = n.page_id )
                left outer join g_pages_details pd
                    on (pd.page_id = p.page_id and pd.language = 'en')
                left outer join g_pages_details pdflt
                    on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
                where node_id = 66940
				
getWeatherXMLQuery (Datasource=rds-tiny, Time=0 ms, Records=1) in /mnt/webroot/sites/toggenburg/html/wetter/weatherxml.cfc
					select xmlfile from ps_weather 
					where siteId = 242
					
				
qParamByID (Datasource=web, Time=0.329 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('cfmapping') and sp.fk_site_id = 242
		
getNodeAssociationsQuery (Datasource=web, Time=2.23 ms, Records=1) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
			select 
				REL.NODE_ID as nodeId
			from G_NODES_PAGES_REL REL
				join G_NODES N on (N.NODE_ID=REL.NODE_ID and N.DELETED=0) 
				join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=242)
			where REL.PAGE_ID=184487
			limit 1
		
getAvailableDetailsQuery (Datasource=web, Time=0.311 ms, Records=2) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
            select LANGUAGE
            from G_PAGES_DETAILS
            where PAGE_ID=184487
            and DELETED=0
        
qParamByID (Datasource=web, Time=0.288 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('webroot') and sp.fk_site_id = 242
		
getUserLanguagesQuery (Datasource=web, Time=0.279 ms, Records=0) in /mnt/gadmin4/schema/site.cfc
the following colum(s) are never read within the request:languages
            select distinct languages                                                                    
            from g_rights gr
            join g_user gu on (gr.user_id = gu.user_id)
            where gu.username = ''
            and gr.site_id = 242
        
getLanguagesQuery (Datasource=web, Time=0.317 ms, Records=1) in /mnt/gadmin4/schema/site.cfc
            select LANGUAGES 
            from G_SITES 
            where SITE_ID=242
        
qParamByID (Datasource=web, Time=1.98 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('defaultLanguage') and sp.fk_site_id = 242
		
localvars.dumpPagesQuery (Datasource=web, Time=2.27 ms, Records=0) in /mnt/gadmin4/schema/page.cfc
the following colum(s) are never read within the request:pageId
                select PAGE_ID as pageId
                from G_PAGES
                where PAGE_ID IN (184487)
                and DELETED=0
                
                AND VISIBLE=1
                
            
q (Datasource=web, Time=0.39 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select page_id from g_nodes where node_id = 11187 and deleted = 0
				
q (Datasource=web, Time=0.542 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
the following colum(s) are never read within the request:y_coord,admin_notes,adr_displ,cugbenutzername,hotel_id,visible,valid_from,s_key,template_id,x_coord,disable_dropdown,gcs0_id,orig_id,fk_anlagentype,is_static_page,old_gcs_type_id,online_to,pictograms,valid_to,ecrmprofile,r_key,nonbookable,flags,online_from,finder,site_id,cugpasswort,postcode,infra_fk_address,deleted,old_gcs_template_id,fk_angebotsfinder_id,ecrmprofilenames,old_navcode,sortorder,gcs1_id,registeredUsers,default_lang,gcs2_id
					select * from g_pages where page_id = 29803 and deleted = 0
				
q (Datasource=web, Time=0.643 ms, Records=1) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
					select
	                        ifnull(pd.navcode,pdflt.navcode) as navcode
	                        from g_pages p
	                        left outer join g_pages_details pd
	                            on (pd.page_id = p.page_id and pd.language = 'de')
	                        left outer join g_pages_details pdflt
	                            on (pdflt.page_id = p.page_id and pdflt.language = p.default_lang)
	                        where p.page_id = 29803 and p.deleted = 0
				
getStorageImagesQuery (Datasource=web, Time=0.402 ms, Records=4) in /mnt/webroot/sites/toggenburg/functions/getStorageImages.cfm
           SELECT concat('http://images.myswitzerland.com/',gid.filepath) as path,
                gid.width,
                gid.height,
                gi.image_id,
                gi.sortorder,
                gl.place,
                gl.caption
                FROM G_IMAGES_VERSIONS gid
                join G_IMAGES gi on (gi.IMAGE_ID=gid.IMAGE_ID and gi.DELETED=0)
                join G_NODES_IMAGES_REL gdr on (gdr.IMAGE_ID = gid.IMAGE_ID and gdr.NODE_ID=64990)
                join G_IMAGES_DETAILS gl on (gl.IMAGE_ID=gid.IMAGE_ID and gl.DELETED=0 and gl.LANGUAGE='de')
                join G_IMAGES_DETAILS gldflt on (gldflt.IMAGE_ID=gid.IMAGE_ID and gldflt.DELETED=0 and gldflt.LANGUAGE=gi.DEFAULT_LANG)
                WHERE gid.DELETED=0
                and gid.IMAGES_SIZE_ID=496
				and gi.visible = 1
                group by gi.image_id order by gi.sortorder
        
qParamByID (Datasource=web, Time=0.316 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('cfmapping') and sp.fk_site_id = 242
		
getNodeAssociationsQuery (Datasource=web, Time=0.284 ms, Records=1) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
			select 
				REL.NODE_ID as nodeId
			from G_NODES_PAGES_REL REL
				join G_NODES N on (N.NODE_ID=REL.NODE_ID and N.DELETED=0) 
				join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=242)
			where REL.PAGE_ID=184425
			limit 1
		
getAvailableDetailsQuery (Datasource=web, Time=0.281 ms, Records=2) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
            select LANGUAGE
            from G_PAGES_DETAILS
            where PAGE_ID=184425
            and DELETED=0
        
q (Datasource=web, Time=0.262 ms, Records=0) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
the following colum(s) are never read within the request:page_id
					select page_id from g_nodes where page_id = 185030 and deleted = 0
				
q (Datasource=web, Time=0.27 ms, Records=0) in /mnt/webroot/sites/toggenburg/WEB-INF/railo/components/org/railo/cfml/Base.cfc
the following colum(s) are never read within the request:navpath
					select path as navpath from g_pages_sites_rel
                                where page_id = 185030 and site_id = 242
				
qParamByID (Datasource=web, Time=0.281 ms, Records=1) in /mnt/gadmin4/cfc/parameter.cfc
			select sp.param_value from sites_param sp where LOWER(sp.pk_sites_param) = LOWER('cfmapping') and sp.fk_site_id = 242
		
getNodeAssociationsQuery (Datasource=web, Time=0.276 ms, Records=1) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
			select 
				REL.NODE_ID as nodeId
			from G_NODES_PAGES_REL REL
				join G_NODES N on (N.NODE_ID=REL.NODE_ID and N.DELETED=0) 
				join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=242)
			where REL.PAGE_ID=184416
			limit 1
		
getAvailableDetailsQuery (Datasource=web, Time=0.279 ms, Records=2) in /mnt/webroot/sites/toggenburg/cfc/output.cfc
            select LANGUAGE
            from G_PAGES_DETAILS
            where PAGE_ID=184416
            and DELETED=0
        


Scope Variables

Application Variables:
applicationname=Toggenburg_2013
basepath=/mnt/webroot/sites/toggenburg
cdnhost=toggenburg.org
defLang=de
dsn=Struct (2)
DUMPINSTANT=false
gadmin_cfc_parameter=Component (gadmin.cfc.parameter)
gadmin_schema_node=Component (gadmin.schema.node)
gadmin_schema_page=Component (gadmin.schema.page)
gadmin_schema_template=Component (gadmin.schema.template)
getPhrase=Complex type
instance=Component (Application)
languages=de,en
LASTWEATHERUPDATE={ts '2014-04-25 01:34:22'}
LOADED=0
navfooter_de=Query (3)
navfooter_en=Query (2)
navigation=Struct (3)
navmain_de=Query (7)
navmain_en=Query (7)
navParentNodeIds=64969,65015
navtree_de=Query (415)
navtree_en=Query (415)
outputHandler=Component (cfc.output)
SINGLETON=Component (service.cfc.SingletonFactory)
siteid=242
sitepath=sites-toggenburg
TRANS=Struct (4)
translation=ostschweiz
watches=Struct (0)
weatherHandler=Component (html.wetter.weatherxml)
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/toggenburg/html/page.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=x-gzip, gzip, deflate
http_accept_language=en-us,en-gb,en;q=0.7,*;q=0.3
http_connection=close
http_cookie=
http_host=www.toggenburg.org
http_referer=
http_user_agent=CCBot/2.0 (http://commoncrawl.org/faq/)
https=
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.0.1
local_host=ost2
path_info=
path_translated=/mnt/webroot/sites/toggenburg/html/page.cfm
query_string=path_info=/aktivurlaub/sommer/sommeraktivitaeten/85952
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
script_name=/de/page.cfm
server_name=www.toggenburg.org
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=
Cookie Variables:
cfid=276ec368-5446-42ef-8a64-7ed31bbb6ff2
cftoken=0
Request Variables:
bade_langpath=de
dumpmode=true
eventlangpath=de
langpath=de
langpathmarket=de
qlangpath=dt
snow_langpath=de
testdmpdatasource=false
Server Variables:
coldfusion=Struct (9)
java=Struct (7)
os=Struct (6)
railo=Struct (6)
separator=Struct (3)
servlet=Struct (1)
Session Variables:
cfid=276ec368-5446-42ef-8a64-7ed31bbb6ff2
cftoken=0
lastvisit={ts '2014-04-25 01:51:03'}
RCOUNTRY=en
RLANGUAGE=de
sessionid=Toggenburg_2013_276ec368-5446-42ef-8a64-7ed31bbb6ff2_0
timecreated={ts '2014-04-25 01:51:03'}
urltoken=CFID=276ec368-5446-42ef-8a64-7ed31bbb6ff2&CFTOKEN=0
URL Variables:
path_info=/aktivurlaub/sommer/sommeraktivitaeten/85952
pid=
skin=
Debug Rendering Time: 0.001 ms