Total Time	Avg Time	Count	Template
47 ms	47 ms	1	C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\citta.cfm
31 ms	31 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\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\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
47 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

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

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

select * from prossimita where idcategoria <> 10 and online = 1 and citta = 'Maniace' and provincia = 'CT'

select * from prossimita where idcategoria = 10 and online = 1 and citta = 'Maniace' and provincia = 'CT'

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

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

select distinct frazione from strutture where citta = 'Aci Catena' 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 = 'Aci Sant''Antonio' 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 = 'Acicastello' 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 = 'Acireale' 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 = 'Acitrezza' 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 = 'Adrano' 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 = 'Belpasso' 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 = 'Biancavilla' 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 = 'Bronte' 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 = 'Calatabiano' 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 = 'Caltagirone' 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 = 'Castiglione di Sicilia' 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 = 'Catania' 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 = 'Fiumefreddo di Sicilia' 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 = 'Giarre' 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 = 'Grammichele' 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 = 'Gravina di Catania' 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 = 'Linguaglossa' 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 = 'Maniace' 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 = 'Mascali' 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 = 'Mascalucia' 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 = 'Milo' 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 = 'Mirabella Imbaccari' 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 = 'Misterbianco' 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 = 'Nicolosi' 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 = 'Nunziata di Mascali' 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 = 'Paternò' 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 = 'Pedara' 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 = 'Piedimonte Etneo' 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 = 'Ragalna' 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 = 'Randazzo' 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 = 'Riposto' 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 = 'San Cono' 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 = 'San Giovanni La Punta' 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 = 'San Gregorio di Catania' 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 = 'San Michele di Ganzaria' 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 = 'San Pietro Clarenza' 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 = 'Santa Maria di Licodia' 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 = 'Santa Venerina' 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 = 'Sant''Agata li Battiati' 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 = 'Sant''Alfio' 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 = 'Trecastagni  ' 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 = 'Tremestieri Etneo' 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 = 'Valverde' 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 = 'Viagrande' 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 = 'Vizzini' 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 = 'Zafferana Etnea' 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.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.cfm
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\bed-and-breakfast-sicilia\www\citta.cfm
QUERY_STRING=citta=Maniace&provincia=CT
REMOTE_ADDR=10.10.38.254
REMOTE_HOST=10.10.38.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/citta.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:
citta=Maniace
provincia=CT