Total Time	Avg Time	Count	Template
187 ms	187 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\citta.cfm
94 ms	94 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\include\barra-citta-citta.cfm
47 ms	47 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\include\risultati-strutture.cfm
15 ms	15 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\include\lista5news.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\menuregioni.htm
0 ms	0 ms	1	C:\inetpub\wwwroot\clients\hotel-sicilia\www\include\tabellaricercaavanzata.htm
15 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
202 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 = 'Palermo' 
       
   order by rate desc, ip desc

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

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

select * from prossimita where idcategoria = 10 and online = 1 and citta = 'Palermo' and provincia = 'PA'

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

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

select distinct frazione from strutture where citta = 'Altavilla Milicia' 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 = 'Bagheria' 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 = 'Balestrate' 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 = 'Bolognetta' 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 = 'Borgetto' 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 = 'Caccamo' 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 = 'Campofelice di Roccella' 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 = 'Capaci' 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 = 'Carini' 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 = 'Castelbuono' 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 = 'Casteldaccia' 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 = 'Castellana Sicula' 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 = 'Castronuovo 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 = 'Cefalù' 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 = 'Cinisi' 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 = 'Collesano' 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 = 'Corleone' 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 = 'Ficarazzi' 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 = 'Gangi' 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 = 'Geraci 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 = 'Gratteri' 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 = 'Isnello' 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 = 'Isola delle Femmine' 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 = 'Misilmeri' 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 = 'Monreale' 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 = 'Montelepre' 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 = 'Palazzo Adriano' 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 = 'Palermo' 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 = 'Partinico' 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 = 'Petralia Soprana' 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 = 'Petralia Sottana' 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 = 'Pollina' 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 = 'Roccapalumba' 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 Cristina Gela' 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 Flavia' 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 = 'Termini Imerese' 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 = 'Terrasini' 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 = 'Trabia' 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 = 'Trappeto' 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 = 'Ustica' 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 = 'Valleldomo' 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=Palermo&provincia=PA
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=Palermo
provincia=PA