Total Time	Avg Time	Count	Template
109 ms	109 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\citta.cfm
78 ms	78 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\include\barra-citta-citta.cfm
15 ms	15 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\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\tabellaricercaavanzata.htm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
109 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

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

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

select * from prossimita where idcategoria <> 10 and online = 1 and citta = 'Gioiosa Marea' and provincia = 'ME'

select * from prossimita where idcategoria = 10 and online = 1 and citta = 'Gioiosa Marea' and provincia = 'ME'

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

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

select distinct frazione from strutture where citta = 'Acquedolci' 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 = 'Alcara Li Fusi' 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 = 'Alì Terme' 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 = 'Alicudi' 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 = 'Barcellona Pozzo di Gotto' 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 = 'Brolo' 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 = 'Capo d''Orlando' 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 = 'Capri Leone' 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 = 'Caronia' 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 = 'Castelmola' 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 = 'Cesarò' 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 = 'Falcone' 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 = 'Filicudi' 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 = 'Forza d''Agrò' 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 = 'Francavilla 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 = 'Furci Siculo' 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 = 'Furnari' 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 = 'Galati Mamertino' 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 = 'Giardini Naxos' 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 = 'Gioiosa Marea' 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 = 'Graniti' 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 = 'Letojanni' 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 = 'Lipari' 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 = 'Messina' 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 = 'Milazzo' 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 = 'Mistretta' 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 = 'Monforte San Giorgio' 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 = 'Montalbano Elicona' 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 = 'Nizza 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 = 'Oliveri' 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 = 'Pace del Mela' 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 = 'Panarea' 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 = 'Patti' 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 = 'Piraino' 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 = 'Reitano' 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 = 'Roccalumera' 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 = 'Rometta' 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 = 'Salina' 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 Filippo del Mela' 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 Fratello' 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 Domenica Vittoria' 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 di Militello' 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''Alessio Siculo' 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 = 'Santo Stefano di Camastra' 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 = 'Savoca' 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 = 'Sinagra' 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 = 'Spadafora' 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 = 'Stromboli' 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 = 'Taormina' 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 = 'Terme Vigliatore' 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 = 'Torregrotta' 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 = 'Torrenova' 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 = 'Tripi' 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 = 'Tusa' 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 = 'Villafranca Tirrena' 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 = 'Vulcano' 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.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.cfm
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\hotel-sicilia\www\citta.cfm
QUERY_STRING=citta=Gioiosa%20Marea&provincia=ME
REMOTE_ADDR=10.10.38.254
REMOTE_HOST=10.10.38.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/citta.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=Gioiosa Marea
provincia=ME