Total Time	Avg Time	Count	Template
156 ms	156 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\citta_prossimita.cfm
16 ms	16 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\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-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			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
156 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

select * from prossimita where id = 4642 

	select id, ip, tipo, zona, zonanote, pmin, pmax, pdmin, pdmax, psmin, psmax, lastminute, datafine, nomebeb, citta, frazione, provincia, visite, preventivi, voti, descrizione, tel, tel1, tel2, cell1, cell2, url, latitudine, longitudine from strutture where
DBO.f_Distance(37.2854963891049350, 15.1866459846496580, latitudine, longitudine) <30
and online = 1
order by DBO.f_Distance(37.2854963891049350, 15.1866459846496580, latitudine, longitudine)

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

select * from prossimita where idcategoria <> 10 and online = 1 and citta = 'Augusta'

select * from prossimita where idcategoria = 10 and online = 1 and citta = 'Augusta'

	select nomeprovincia, linkprovincia from province where province = 'SR'
	

select distinct frazione from strutture where online = 1 and citta = 'Augusta' and Len(frazione) > 1 and frazioneok = 1 order by frazione

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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\citta_prossimita.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=/citta_prossimita.cfm
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\citta_prossimita.cfm
QUERY_STRING=id=4642
REMOTE_ADDR=10.10.38.254
REMOTE_HOST=10.10.38.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/citta_prossimita.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

URL Parameters:
id=4642