Debugging Information
ColdFusion Server Standard 9,0,0,251028
Template /achab.cfm
Time Stamp 23-Feb-12 02:11 AM
Locale Italian (Standard)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.107.179.234
Host Name 38.107.179.234


Execution Time

Total Time Avg Time Count Template
70 ms 70 ms 1 top level D:\Inetpub\dev_achab_it\sito\application\achab.cfm
47 ms 47 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc | recContents(11, 1, 1) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
47 ms 47 ms 1 D:\Inetpub\dev_achab_it\sito\application\common\_selectMenu.cfm
40 ms 40 ms 1 D:\Inetpub\dev_achab_it\sito\application\Application.cfm
35 ms 35 ms 1 D:\Inetpub\dev_achab_it\sito\application\config\Config.cfm
12 ms 4 ms 3 D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm
5 ms 5 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc | recUrlCode(/Ita/AREA-RIVENDITORI.htm) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc
4 ms 4 ms 1 D:\Inetpub\dev_achab_it\sito\application\common\_navBar.cfm
2 ms 2 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc | recMetaTag(Ita,AREA-RIVENDITORI) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc
2 ms 2 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc | recTitle() ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc
2 ms 2 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc | setTrack(true, , ) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc
1 ms 1 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc | recLingua() ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc
1 ms 1 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc | getVars() ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc
1 ms 1 ms 1 D:\Inetpub\dev_achab_it\sito\application\config\config_key.cfm
1 ms 1 ms 1 D:\Inetpub\dev_achab_it\sito\application\config\configuration.cfm
0 ms 0 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc | getBROWSER(CCBot/1.0 (+http://www.commoncrawl.org/bot.html)) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc
0 ms 0 ms 1 CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc | getOS(CCBot/1.0 (+http://www.commoncrawl.org/bot.html)) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
111 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getConfig (Datasource=www_achab_it, Time=23ms, Records=17) in D:\Inetpub\dev_achab_it\sito\application\config\Config.cfm @ 02:11:20.020
    SELECT  cfg_variabile, cfg_value
    FROM    sys_config
getUrlSSL (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\config\Config.cfm @ 02:11:20.020
    SELECT  lng_url_sito
    FROM    sys_lingue
    WHERE   lng_key = 1
getUrl (Datasource=www_achab_it, Time=0ms, Records=2) in D:\Inetpub\dev_achab_it\sito\application\config\Config.cfm @ 02:11:20.020
    SELECT  lng_url_sito
    FROM    sys_lingue
getLabel (Datasource=www_achab_it, Time=3ms, Records=138) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:11:20.020
	SELECT 	lbl_valore, lbl_template_id, lbl_label_id
	FROM 	sys_labels
	WHERE 	(lbl_template_id = 0
		
	OR  lbl_template_id IN ( 0, 22 )
		
        )
	AND		lbl_lingua_id = 1 
getPrezzoDVD (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\config\config_key.cfm @ 02:11:20.020
	SELECT	prd_prezzo
	FROM	t_prd_prodotti
	WHERE   prd_key = 5160 
recLingua (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:11:20.020
        	SELECT	*
			FROM	sys_lingue
            WHERE	lng_key = 1 
tipoMenu (Datasource=www_achab_it, Time=5ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc @ 02:11:20.020
                        SELECT 	*
                        FROM 	t_CMS_sezioni
                        WHERE	(
                                    lower(sez_name) = 'area-rivenditori' OR 
                                    lower(sez_name) = 'area rivenditori' OR 
                                    lower(sez_name) = 'area/rivenditori' OR 
                                    lower(sez_name) = 'area_rivenditori' OR 
                                    lower(sez_name) = 'area / rivenditori' 
                                 )                    	
                          AND	sez_lingua_id = 1 
getLabel (Datasource=www_achab_it, Time=3ms, Records=138) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:11:20.020
	SELECT 	lbl_valore, lbl_template_id, lbl_label_id
	FROM 	sys_labels
	WHERE 	(lbl_template_id = 0
		
	OR  lbl_template_id IN ( 0, 22 )
		
        )
	AND		lbl_lingua_id = 1 
getLabel (Datasource=www_achab_it, Time=2ms, Records=118) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:11:20.020
	SELECT 	lbl_valore, lbl_template_id, lbl_label_id
	FROM 	sys_labels
	WHERE 	(lbl_template_id = 0
		
	OR  lbl_template_id IN ( 0 )
		
        )
	AND		lbl_lingua_id = 1 
recContents (Datasource=www_achab_it, Time=46ms, Records=2) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:11:20.020
            SELECT 	*
            FROM 	t_CMS_contenuti
            WHERE	cnt_fk_id IN ( 11 )
            	AND cnt_attivo = 1
                AND cnt_tipo_fk = 1
				AND cnt_sottoPagina_id <= 0
            
                AND		cnt_lingua_id = 1 
            ORDER BY cnt_ordinamento
        
recMetaTag (Datasource=www_achab_it, Time=1ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:11:20.020
                SELECT	cnt_metaDescription, cnt_metakeywords
                FROM    t_CMS_contenuti
                WHERE   cnt_key = 0 
recTitle (Datasource=www_achab_it, Time=0ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:11:20.020
                SELECT	cnt_metaTitle
                FROM    t_CMS_contenuti
                WHERE   cnt_key = 0 
Checkcookie (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:11:20.020
                        SELECT 	Vst_code
                        FROM 	T_Visitatori
                        WHERE 	Vst_code = 'B13LF012ZT0IGFU'
                        ORDER BY Vst_key DESC
                    


Scope Variables

Application Variables:
applicationname=esd
cachecreated={ts '2012-02-22 23:42:51'}
componentspathadmin=COMPONENTS
dsnforobject=www_achab_it
img_est=.jpg
img_path=/img/
imglogo_path=/img/prod/
imglogobig_path=/img/prod/big/
imglogomed_path=/img/prod/medium/
imglogosma_path=/img/prod/small/
ochat=Struct (48)
odo=Struct (44)
omenu=Struct (11)
onavbar=Struct (4)
opage=Struct (14)
osurvey=Struct (33)
otrack=Struct (12)
ousers=Struct (20)
owhois=Struct (4)
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=D:\Inetpub\dev_achab_it\sito\application\achab.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=CFID=365533; CFTOKEN=89214513; CODE=B13LF012ZT0IGFU; SESSION=1
HTTP_HOST=dev.achab.it
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/Ita/AREA-RIVENDITORI.htm
PATH_TRANSLATED=D:\Inetpub\dev_achab_it\sito\application\achab.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.179.234
REMOTE_HOST=38.107.179.234
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/achab.cfm
SERVER_NAME=dev.achab.it
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
cfid=365533
cftoken=89214513
desclingua=Ita
hitcount=11
idco=0
idgr=0
idlingua=1
idme=6
idpr=0
idprdvideo=0
idse=11
idsg=0
lastvisit={ts '2012-02-23 02:09:38'}
siglalingua=IT
timecreated={ts '2012-02-23 01:59:36'}
urltoken=CFID=365533&CFTOKEN=89214513
Cookie Variables:
CFID=365533
CFTOKEN=89214513
CODE=B13LF012ZT0IGFU
SESSION=1
Session Variables:
cfid=365533
cftoken=89214513
sessionid=ESD_365533_89214513
urltoken=CFID=365533&CFTOKEN=89214513
Debug Rendering Time: 30 ms