Tutti i B&B della provincia di Enna

Debugging Information

ColdFusion Server Standard	9,0,0,251028
Template	/enna_bed_and_breakfast_tutti.cfm
Time Stamp	10-Sep-10 11:45 AM
Locale	Italian (Standard)
User Agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP	10.10.38.254
Host Name	10.10.38.254

Execution Time

Total Time	Avg Time	Count	Template
31 ms	31 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\enna_bed_and_breakfast_tutti.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\banner\banner.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\banner\bannerbottom.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\banner\bannerdx.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\include\barra-citta.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\include\footer.htm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\include\lista5news.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\include\menuprovince.htm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\include\risultati-strutture.cfm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\include\tabellaricercaavanzata.htm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
31 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

lista (Datasource=beb, Time=15ms, Records=31) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\enna_bed_and_breakfast_tutti.cfm @ 11:45:27.027

select id, ip, zona, tipo, zonanote, pmin, pmax, pdmin, pdmax, psmin, psmax, lastminute, datafine, tipo, frazione, nomebeb, citta, provincia, visite, preventivi, voti, descrizione, tel, tel1, tel2, cell1, cell2, url from strutture where online = 1 and provincia = 'EN' order by ip desc

citta (Datasource=beb, Time=16ms, Records=4) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\enna_bed_and_breakfast_tutti.cfm @ 11:45:27.027

select distinct citta from strutture where online = 1 and provincia = 'EN' order by citta

frazioni (Datasource=beb, Time=0ms, Records=0, Cached Query) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\include\barra-citta.cfm @ 11:45:27.027

	select distinct frazione from strutture where citta = 'Assoro' and Len(frazione) > 1 and frazione is not NULL and online = 1 and frazioneok = 1 order by frazione

frazioni (Datasource=beb, Time=0ms, Records=1, Cached Query) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\include\barra-citta.cfm @ 11:45:27.027

	select distinct frazione from strutture where citta = 'Enna' and Len(frazione) > 1 and frazione is not NULL and online = 1 and frazioneok = 1 order by frazione

frazioni (Datasource=beb, Time=0ms, Records=0, Cached Query) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\include\barra-citta.cfm @ 11:45:27.027

	select distinct frazione from strutture where citta = 'Piazza Armerina' and Len(frazione) > 1 and frazione is not NULL and online = 1 and frazioneok = 1 order by frazione

frazioni (Datasource=beb, Time=0ms, Records=0, Cached Query) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\include\barra-citta.cfm @ 11:45:27.027

	select distinct frazione from strutture where citta = 'Valguarnera' and Len(frazione) > 1 and frazione is not NULL and online = 1 and frazioneok = 1 order by frazione

lista5news (Datasource=bebitalia, Time=0ms, Records=5, Cached Query) in C:\inetpub\wwwroot\Clients\bed-and-breakfast-sicilia\www\include\lista5news.cfm @ 11:45:27.027

select top 5 * from news where online = 1 order by data desc

Scope Variables

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=C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\enna_bed_and_breakfast_tutti.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
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=LB-Persist=1361447434.20480.0000
HTTP_HOST=www.bed-and-breakfast-sicilia.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/enna_bed_and_breakfast_tutti.cfm
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\enna_bed_and_breakfast_tutti.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.38.254
REMOTE_HOST=10.10.38.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/enna_bed_and_breakfast_tutti.cfm
SERVER_NAME=www.bed-and-breakfast-sicilia.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Cookie Variables:
LB-Persist=1361447434.20480.0000

Debug Rendering Time: 31 ms

Ricerca Strutture per Caratteristiche nella Provincia di ENNA