|
Debugging Information
Execution Time
SQL Queries qSiteConfigSuffix (Datasource=web, Time=0ms, Records=0, Cached Query) in /mnt/webroot/sites/otv_yverdon/Application.cfc @ 08:43:53.053SELECT suffix FROM SITES WHERE lower(server_name)='www.yverdon-les-bains-region.ch' local.parameterContainsQuery (Datasource=web, Time=1ms, Records=31) in /mnt/gadmin4/cfc/parameter.cfc @ 08:43:53.053select pk_sites_param as paramkey, fk_site_id as siteid, param_value as paramvalue from sites_param where param_value in (?) and fk_site_id in (?) Query Parameter Value(s) -getNodePageIdFromNavcodeQuery (Datasource=web, Time=7ms, Records=0) in /mnt/gadmin4/cfc/output.cfc @ 08:43:53.053select PD.PAGE_ID as pageId, case N.NODE_ID when ? then 1 when ? then 2 when ? then 3 when ? then 4 else 5 end as sortorderParentNode, N.NODE_ID as nodeId from G_PAGES_DETAILS PD join G_PAGES P on (P.PAGE_ID=PD.PAGE_ID and P.DELETED=?) join G_NODES N on (N.PAGE_ID=P.PAGE_ID and N.DELETED=?) join G_NODES_SITES_REL REL on (REL.NODE_ID=N.NODE_ID and REL.SITE_ID=?) left outer join G_NODES_REL PNNREL on (PNNREL.NODE_ID=N.NODE_ID and PNNREL.PARENT_NODE_ID in (?,?,?,?)) where PD.NAVCODE=? and PD.DELETED=? order by sortorderParentNode limit 1 Query Parameter Value(s) -getPageIdFromNavcodeQuery (Datasource=web, Time=1ms, Records=1) in /mnt/gadmin4/cfc/output.cfc @ 08:43:53.053select PD.PAGE_ID as pageId from G_PAGES_DETAILS PD join G_PAGES P on (P.PAGE_ID=PD.PAGE_ID and P.DELETED=?) join G_PAGES_SITES_REL REL on (REL.PAGE_ID=P.PAGE_ID and REL.SITE_ID=?) where PD.NAVCODE=? and PD.DELETED=? limit 1 Query Parameter Value(s) -getNodeAssociationsQuery (Datasource=web, Time=1ms, Records=1) in /mnt/gadmin4/cfc/output.cfc @ 08:43:53.053select 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=?) join G_NODES_SITES_REL NS on (NS.NODE_ID=REL.NODE_ID and NS.SITE_ID=?) where REL.PAGE_ID=? limit 1 Query Parameter Value(s) -Scope Variables Application Variables:
applicationname=REGSITE_YVERDON
basepath=/mnt/webroot/sites/otv_yverdon/
checkmobilesite=Complex type
datasource=web
gadmin_cfc_parameter=Struct (23)
gadmin_schema_node=Struct (50)
gadmin_schema_page=Struct (53)
gadminversion=4
getcrumbtitle=Complex type
getphrase=Complex type
imagebasepath=http://images.gadmin.st.s3.amazonaws.com
instance=Struct (35)
langpath=fr
lastreinit=0
locator=Struct (8)
myhostname=ps6
navadmin_de=Query (0)
navadmin_en=Query (0)
navadmin_fr=Query (0)
navadmin_it=Query (0)
navfooter_de=Query (7)
navfooter_en=Query (7)
navfooter_fr=Query (7)
navfooter_it=Query (7)
navidadmin=6143
navidfoot=6939
navidmain=6938
navidpart=6941
navidreg=6940
navidserv=6942
navidtop=6943
navigationlink=Complex type
navmain_de=Query (6)
navmain_en=Query (6)
navmain_fr=Query (6)
navmain_it=Query (6)
navparentnodeids=5468,6938,6942,6939
navpartiques_de=Query (5)
navpartiques_en=Query (5)
navpartiques_fr=Query (5)
navpartiques_it=Query (5)
navregion_de=Query (7)
navregion_en=Query (7)
navregion_fr=Query (7)
navregion_it=Query (7)
navservice_de=Query (5)
navservice_en=Query (5)
navservice_fr=Query (5)
navservice_it=Query (5)
navtop_de=Query (4)
navtop_en=Query (4)
navtop_fr=Query (4)
navtop_it=Query (4)
navtree_de=Query (530)
navtree_en=Query (530)
navtree_fr=Query (530)
navtree_it=Query (530)
navtreeid=5468
outputhandler=Struct (49)
refreshapplication=Complex type
resizefont=Complex type
securityservice=Struct (19)
shownavigation=Complex type
siteid=118
sitepath=sites-yverdon
sitetitle=Struct (4)
tagcache=Struct (16)
trans=Struct (5)
updatetimeyve_de={ts '2012-02-06 01:23:39'}
updatetimeyve_en={ts '2012-02-06 00:57:52'}
updatetimeyve_fr={ts '2012-02-05 16:09:44'}
util=Struct (23)
weatheryve_de=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/de/page.cfm/meteo" name="Yverdon-les-Bains"><Day exp="6. Februar 2012" val="20120206"><TxtDay>wechselnd bewölkt</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Orbe"><Day exp="6. Februar 2012" val="20120206"><TxtDay>wechselnd bewölkt</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Yvonand"><Day exp="6. Februar 2012" val="20120206"><TxtDay>wechselnd bewölkt</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location><Location link="/de/page.cfm/meteo" name="Grandson"><Day exp="6. Februar 2012" val="20120206"><TxtDay>wechselnd bewölkt</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7. Februar 2012" val="20120207"><TxtDay>teilweise sonnig</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8. Februar 2012" val="20120208"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9. Februar 2012" val="20120209"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10. Februar 2012" val="20120210"><TxtDay>bewölkt, einige Schneeschauer</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11. Februar 2012" val="20120211"><TxtDay>ziemlich sonnig</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location></Article>
weatheryve_en=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/en/page.cfm/meteo" name="Yverdon-les-Bains"><Day exp="6 February 2012" val="20120206"><TxtDay>mostly cloudy</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 February 2012" val="20120210"><TxtDay>mostly cloudy, some snow showers</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11 February 2012" val="20120211"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Orbe"><Day exp="6 February 2012" val="20120206"><TxtDay>mostly cloudy</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 February 2012" val="20120210"><TxtDay>mostly cloudy, some snow showers</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11 February 2012" val="20120211"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Yvonand"><Day exp="6 February 2012" val="20120206"><TxtDay>mostly cloudy</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 February 2012" val="20120210"><TxtDay>mostly cloudy, some snow showers</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11 February 2012" val="20120211"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location><Location link="/en/page.cfm/meteo" name="Grandson"><Day exp="6 February 2012" val="20120206"><TxtDay>mostly cloudy</TxtDay><SymbDay>54</SymbDay><TempMor>-9</TempMor><TempAft>-9</TempAft></Day><Day exp="7 February 2012" val="20120207"><TxtDay>partly sunny</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 February 2012" val="20120208"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 February 2012" val="20120209"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 February 2012" val="20120210"><TxtDay>mostly cloudy, some snow showers</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day><Day exp="11 February 2012" val="20120211"><TxtDay>mostly sunny</TxtDay><SymbDay>2</SymbDay><TempMor>-11</TempMor><TempAft>-3</TempAft></Day></Location></Article>
weatheryve_fr=<?xml version="1.0" encoding="UTF-8"?>
<Article><Location link="/fr/page.cfm/meteo" name="Yverdon-les-Bains"><Day exp="5 février 2012" val="20120205"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-7</TempMor><TempAft>-7</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>nuageux, quelques averses de neige</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Orbe"><Day exp="5 février 2012" val="20120205"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-7</TempMor><TempAft>-7</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>nuageux, quelques averses de neige</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Yvonand"><Day exp="5 février 2012" val="20120205"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-7</TempMor><TempAft>-7</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>nuageux, quelques averses de neige</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</TempAft></Day></Location><Location link="/fr/page.cfm/meteo" name="Grandson"><Day exp="5 février 2012" val="20120205"><TxtDay>ensoleillé</TxtDay><SymbDay>1</SymbDay><TempMor>-7</TempMor><TempAft>-7</TempAft></Day><Day exp="6 février 2012" val="20120206"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-14</TempMor><TempAft>-7</TempAft></Day><Day exp="7 février 2012" val="20120207"><TxtDay>en partie ensoleillé, passages nuageux parfois denses</TxtDay><SymbDay>3</SymbDay><TempMor>-12</TempMor><TempAft>-7</TempAft></Day><Day exp="8 février 2012" val="20120208"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-10</TempMor><TempAft>-5</TempAft></Day><Day exp="9 février 2012" val="20120209"><TxtDay>assez ensoleillé, passages nuageux</TxtDay><SymbDay>2</SymbDay><TempMor>-9</TempMor><TempAft>-4</TempAft></Day><Day exp="10 février 2012" val="20120210"><TxtDay>nuageux, quelques averses de neige</TxtDay><SymbDay>11</SymbDay><TempMor>-9</TempMor><TempAft>-5</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/otv_yverdon/html/page.cfm CONTENT_LENGTH= CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS= HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 HTTP_ACCEPT_ENCODING=gzip HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5 HTTP_CONNECTION=close HTTP_COOKIE=CFID=15755540; CFTOKEN=92278326; AWSELB=590FB3B30812EDC7EB028AF9472203E2487E8BC09AB97DEC7499BCB3CAFCFBF3FDBF35F751E1F5D156505E81F7ECDA1F81DDCB2DB2FA0F49616380FB93D48C85352E6DC7FA HTTP_HOST=www.yverdon-les-bains-region.ch HTTP_REFERER= HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html) PATH_INFO=/news_carte_chalets PATH_TRANSLATED=/mnt/webroot/sites/otv_yverdon/html/page.cfm QUERY_STRING= REMOTE_ADDR=10.235.46.189 REMOTE_HOST=10.235.46.189 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/fr/page.cfm SERVER_NAME=www.yverdonlesbainsregion.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=15755540 CFTOKEN=92278326 Request Parameters: env=Struct (1) langpath=fr langpathid=6 qlangpath=fr siteid=118 suffix= Server Variables: COLDFUSION=Struct (8) OS=Struct (5) Session Variables: cfid=15755540 cftoken=92278326 fontsize=0 sessionid=REGSITE_YVERDON_15755540_92278326 urltoken=CFID=15755540&CFTOKEN=92278326Debug Rendering Time: 32 ms |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||