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

red = over 250 ms average execution time

	select id, ip, tipo, rate, stelle, zona, pmin, pmax, pdmin, pdmax, psmin, psmax, lastminute, datafine, nomebeb, citta, frazione, provincia, tel, tel1, tel2, cell1, cell2, url 
	  from strutture 
	 where online = 1 
	   and citta = 'Santa Croce Camerina' 
	   and frazione = 'Punta Secca' 
	      	   
	   order by rate desc, ip desc
	

select top 1 provincia from strutture where online = 1 and citta = 'Santa Croce Camerina'

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

select * from prossimita where idcategoria <> 10 and online = 1 and citta = 'Santa Croce Camerina'

select * from prossimita where idcategoria = 10 and online = 1 and citta = 'Santa Croce Camerina'

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

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

select distinct frazione from strutture where citta = 'Chiaramonte Gulfi' 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 = 'Comiso' 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 = 'Ispica' 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 = 'Modica' 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 = 'Pozzallo' 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 = 'Ragusa' 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 Croce Camerina' 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 = 'Scicli' 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 = 'Vittoria' 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\hotel-sicilia\www\citta_frazione.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.hotel-sicilia.it
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/citta_frazione.cfm
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\hotel-sicilia\www\citta_frazione.cfm
QUERY_STRING=citta=Santa%20Croce%20Camerina&frazione=Punta%20Secca
REMOTE_ADDR=10.10.38.254
REMOTE_HOST=10.10.38.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/citta_frazione.cfm
SERVER_NAME=www.hotel-sicilia.it
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=Santa Croce Camerina
frazione=Punta Secca