Achab - we distribute software and serenity

Achab sells Archive Server and SMS Gateway for MDaemon

Achab sells Archive Server and SMS Gateway for MDaemon

With Archive Server for MDaemon, you know exactly where all of your emails are. You can retrieve them quickly and you will not lose messages among the thousands.
Try it for free, now!

SMS Gateway for MDaemon fills the gap between the two most used enterprise communication means: email and mobile phones.
Try it for free, now!

Achab distributes software

Achab distributes software

Achab distributes software enabling SMBs to create ICT infrastructures that are flexible, effective, and cost efficient.
Our mission is to always simplify the lives of our customers, our resellers, and the end user.
With Achab, it's easy!

We are representing Alt-N, Kaseya, Avira, Cortex, CenterTools, QBik and ADVSoft.

Are you a software vendor? Do you need software distribution in Italy? Contact us!

Debugging Information

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

Execution Time

Total Time	Avg Time	Count	Template
182 ms	182 ms	1	D:\Inetpub\dev_achab_it\sito\application\index.cfm
67 ms	67 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc \| recTopDownload(1) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc
27 ms	27 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc \| recUrlCode(/Eng/HomePage.htm) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc
21 ms	21 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc \| recNews(13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc
21 ms	4 ms	6	D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm
21 ms	21 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\menuDX.cfm
16 ms	16 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\prodotti.cfm
13 ms	13 ms	1	D:\Inetpub\dev_achab_it\sito\application\Application.cfm
11 ms	11 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
10 ms	10 ms	1	D:\Inetpub\dev_achab_it\sito\application\config\Config.cfm
9 ms	9 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\banner.cfm
7 ms	7 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\menuTop.cfm
4 ms	4 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recMenu(1, 13, desc, , 3953) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
4 ms	4 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\footer.cfm
3 ms	3 ms	1	D:\Inetpub\dev_achab_it\sito\application\prod\common\art_carrello.cfm
2 ms	1 ms	2	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recContentById(3953, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
2 ms	2 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recGroups(28, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
2 ms	2 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recTipoMenu(28, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
2 ms	2 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc \| recLastCode() ] 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\menu.cfc \| recFamGroups(476, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
1 ms	1 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recFamGroups(477, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
1 ms	1 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recMenu(2, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
1 ms	1 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recMenu(4, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
1 ms	1 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recSubGroups(476, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
1 ms	1 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc \| recSubGroups(477, 13) ] from D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc
1 ms	1 ms	1	CFC[ D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc \| recContentsByCnt_Key(3953, 13) ] 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\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\setPage.cfc \| recMetaTag() ] 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\setPage.cfc \| recTitle() ] 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\common\_script.cfm
1 ms	1 ms	1	D:\Inetpub\dev_achab_it\sito\application\config\config_key.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
0 ms	0 ms	1	D:\Inetpub\dev_achab_it\sito\application\OnRequestEnd.cfm
0 ms	0 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\_meta.cfm
0 ms	0 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\js_func\js_open_tutorial.cfm
0 ms	0 ms	1	D:\Inetpub\dev_achab_it\sito\application\common\js_func\trim.cfm
0 ms	0 ms	1	D:\Inetpub\dev_achab_it\sito\application\config\configuration.cfm
0 ms	0 ms	1	D:\Inetpub\dev_achab_it\sito\application\verificaTemp.cfm
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
196 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

02:04:36.036 - Expression Exception - in D:\Inetpub\dev_achab_it\sito\application\common\prodotti.cfm : line 76

	    Variable label_0_100 is undefined.

SQL Queries

getConfig (Datasource=www_achab_it, Time=1ms, Records=17) in D:\Inetpub\dev_achab_it\sito\application\config\Config.cfm @ 02:04:35.035

    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:04:35.035

    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:04:35.035

    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:04:35.035

	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=0ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\config\config_key.cfm @ 02:04:35.035

	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:04:35.035

        	SELECT	*
			FROM	sys_lingue
            WHERE	lng_key = 13

tipoMenu (Datasource=www_achab_it, Time=2ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc @ 02:04:35.035

                        SELECT 	*
                        FROM 	t_CMS_sezioni
                        WHERE	(
                                    lower(sez_name) = 'homepage' OR 
                                    lower(sez_name) = 'homepage' OR 
                                    lower(sez_name) = 'homepage' OR 
                                    lower(sez_name) = 'homepage' OR 
                                    lower(sez_name) = 'homepage' 
                                 )                    	
                          AND	sez_lingua_id = 13

recCntbySez (Datasource=www_achab_it, Time=18ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc @ 02:04:35.035

                            SELECT 	*
                            FROM 	t_CMS_contenuti
                            WHERE	(
                                        lower(cnt_titolo) = 'homepage' OR 
                                        lower(cnt_titolo) = 'homepage' OR 
                                        lower(cnt_titolo) = 'homepage' OR 
                                        lower(cnt_titolo) = 'homepage' OR 
                                        lower(cnt_titolo) = 'homepage' 
                                     )
                              AND	cnt_url = '/index.cfm'
                              AND	cnt_attivo = 1
                              AND	cnt_tipo_fk IN (1)
                              AND	cnt_lingua_id = 13
                            ORDER BY cnt_ordinamento

recCntbyGrp (Datasource=www_achab_it, Time=5ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\navBar.cfc @ 02:04:35.035

                SELECT 	*
                FROM 	t_CMS_contenuti
                WHERE	cnt_url = '/index.cfm'
                	AND	cnt_tipo_fk = 1
                    AND cnt_fk_id IN (23,38)
                    AND	cnt_attivo = 1
                    AND	cnt_lingua_id = 13
                ORDER BY cnt_ordinamento

getLabel (Datasource=www_achab_it, Time=4ms, Records=191) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:04:35.035

	SELECT 	lbl_valore, lbl_template_id, lbl_label_id
	FROM 	sys_labels
	WHERE 	(lbl_template_id = 0
		
	OR  lbl_template_id IN ( 0, 22, 96, 34 )
		
        )
	AND		lbl_lingua_id = 13

recNews (Datasource=www_achab_it, Time=21ms, Records=2) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:04:35.035

        	SELECT Top 2 Prodotto, titolo, keynews, testo
            FROM    WA_news
            WHERE   Approvata=1
	            AND   Wne_lingua_id = 13
            ORDER BY wne_ordinamento DESC

recTopDownload (Datasource=www_achab_it, Time=66ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:04:35.035

			SELECT TOP (3) T_FamiglieProdotti.Descrizione, T_FamiglieProdotti.keyFamiglieProdotti, 
					T_FamiglieProdotti.nomeImmagine, 
					CASE WHEN t_CMS_gruppi.grp_father_id > 0 THEN t_CMS_gruppi_1.grp_descrizione + '/' + t_CMS_gruppi.grp_descrizione
						ELSE t_CMS_gruppi.grp_descrizione END AS grp_descrizione
			FROM 	T_download 
					INNER JOIN T_ProdottiDwl ON T_download.dwl_key = T_ProdottiDwl.Pwd_idProdotto 
					INNER JOIN T_FamiglieProdotti ON T_download.dwl_prodotto = T_FamiglieProdotti.keyFamiglieProdotti 
					INNER JOIN t_CMS_contenuti ON T_FamiglieProdotti.keyFamiglieProdotti = t_CMS_contenuti.cnt_fk_id 
					INNER JOIN t_CMS_gruppi ON T_FamiglieProdotti.fpr_gruppo_id = t_CMS_gruppi.grp_key
					LEFT OUTER JOIN t_CMS_gruppi AS t_CMS_gruppi_1 ON t_CMS_gruppi.grp_father_id = t_CMS_gruppi_1.grp_key
			WHERE   T_ProdottiDwl.Pwd_data > DATEADD(day, -7, GETDATE()) 
				AND T_FamiglieProdotti.attivo = 1 
				AND t_CMS_contenuti.cnt_tipo_fk = 3 
				AND t_CMS_contenuti.cnt_attivo = 1
				AND t_CMS_contenuti.cnt_lingua_id = 1
			GROUP BY T_FamiglieProdotti.Descrizione, T_FamiglieProdotti.keyFamiglieProdotti, T_FamiglieProdotti.nomeImmagine, 
					CASE WHEN t_CMS_gruppi.grp_father_id > 0 THEN t_CMS_gruppi_1.grp_descrizione + '/' + t_CMS_gruppi.grp_descrizione
						ELSE t_CMS_gruppi.grp_descrizione END
			ORDER BY COUNT(T_download.dwl_key) DESC

recMetaTag (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:04:35.035

                SELECT	cnt_metaDescription, cnt_metakeywords
                FROM    t_CMS_contenuti
                WHERE   cnt_key = 3953

recTitle (Datasource=www_achab_it, Time=0ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:04:35.035

                SELECT	cnt_metaTitle
                FROM    t_CMS_contenuti
                WHERE   cnt_key = 3953

Checkcookie (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

                        SELECT 	Vst_code
                        FROM 	T_Visitatori
                        WHERE 	Vst_code = 'B13LF012ZT0IGFU'
                        ORDER BY Vst_key DESC

recLastCode (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

            SELECT  Vst_key, Vst_Ip
            FROM    T_Visitatori
            WHERE   Vst_Code = 'B13LF012ZT0IGFU'
            ORDER BY Vst_key DESC

DataLastPage (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

                        SELECT TOP 1 pvs_data, pvs_key
                        FROM    T_PagineVisitatori 
                        WHERE   pvs_visitatore_id = 7114013
                        ORDER BY pvs_data DESC

InsertNewPage (Datasource=www_achab_it, Time=2ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

                        INSERT INTO T_PagineVisitatori 
                        (pvs_visitatore_id, pvs_data, pvs_cms_contenuti_id, pvs_lingua_id
                         )
                        VALUES 
                        (7114013, {ts '2012-02-23 02:04:35'}, 3953, 13 )

RecLastPage (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

                        SELECT TOP 1 pvs_data, pvs_key
                        FROM    T_PagineVisitatori 
                        WHERE   pvs_visitatore_id = 7114013
                        ORDER BY pvs_data DESC

CheckVisit (Datasource=www_achab_it, Time=1ms, Records=4) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

                          SELECT pvs_key,pvs_famigliaProdotto_id,pvs_title_id
                          FROM t_visitatori INNER JOIN t_pagineVisitatori
                              ON t_visitatori.vst_key = t_pagineVisitatori.pvs_visitatore_id
                          WHERE Vst_Code='B13LF012ZT0IGFU'
                          AND  Vst_key=7114013

updateEnabledCookie (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\tracking.cfc @ 02:04:35.035

                            UPDATE T_Visitatori
                            SET vst_enabledCookie = 1
                            WHERE Vst_key=7114013

getLabel (Datasource=www_achab_it, Time=3ms, Records=100) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:04:35.035

	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 = 13

getMenu (Datasource=www_achab_it, Time=3ms, Records=2) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:35.035

            SELECT 	*
            FROM 	t_CMS_sezioni
            WHERE 	(1=1)
			
			AND sez_posizione_menu = 1 
                AND		sez_lingua_id = 13 
            order by 
				sez_ordinamento desc

getLabel (Datasource=www_achab_it, Time=2ms, Records=100) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:04:35.035

	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 = 13

getMenu (Datasource=www_achab_it, Time=1ms, Records=2) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:35.035

            SELECT 	*
            FROM 	t_CMS_sezioni
            WHERE 	(1=1)
			
			AND sez_posizione_menu = 2 
					AND sez_key NOT IN (4,27)
				
                AND		sez_lingua_id = 13 
            order by 
				sez_ordinamento

recContentById (Datasource=www_achab_it, Time=0ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:35.035

            SELECT 	*
            FROM 	t_CMS_contenuti
            WHERE	cnt_key = 3953 
                AND		cnt_lingua_id = 13

recContentById (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:35.035

            SELECT 	*
            FROM 	t_CMS_contenuti
            WHERE	cnt_key = 3953 
                AND		cnt_lingua_id = 13

getLabel (Datasource=www_achab_it, Time=2ms, Records=100) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:04:36.036

	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 = 13

recTipoMenu (Datasource=www_achab_it, Time=2ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

            SELECT 	*
            FROM 	t_CMS_sezioni
            WHERE	sez_tipo_menu = (
            							SELECT sez_tipo_menu
                                        FROM t_CMS_sezioni
                                        WHERE sez_key = 28
                                     )
            
                AND		sez_lingua_id = 13 
            
            order by sez_ordinamento

recGroups (Datasource=www_achab_it, Time=2ms, Records=2) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

                SELECT DISTINCT grp_father_id, grp_ordinamento, grp_descrizione, grp_key, GRP_SEZIONE_ID, grp_css, GRP_TOOLTIP, GRP_IMAGE
                FROM   t_CMS_gruppi INNER JOIN
                    t_CMS_contenuti ON t_CMS_gruppi.grp_key = t_CMS_contenuti.cnt_fk_id
                 WHERE	grp_sezione_id IN ( 28 )
                    AND (t_CMS_contenuti.cnt_tipo_fk = 2)
                    AND (t_CMS_gruppi.grp_attivo = 1)
                    AND (t_CMS_contenuti.cnt_attivo = 1)
                    AND	grp_father_id = 0
                
					AND	grp_lingua_id = 13                   
                    
                ORDER BY grp_father_id, grp_ordinamento

recSezName (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\common\prodotti.cfm @ 02:04:36.036

                            SELECT 	sez_name
                            FROM 	t_CMS_sezioni
                            WHERE	sez_key = 28

recSubGroups (Datasource=www_achab_it, Time=1ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

            SELECT 	*
            FROM 	t_CMS_gruppi
            WHERE	grp_father_id = 476
            	AND grp_attivo = 1
            
                AND		grp_lingua_id = 13 
            
            ORDER BY grp_ordinamento, grp_descrizione

recFamGroups (Datasource=www_achab_it, Time=0ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

            SELECT 	keyFamiglieProdotti, descrizione, nomeAlt,fpr_gruppo_id,fpr_ordGruppo,
					CASE WHEN keyFamiglieProdotti IN (115,116,117) THEN 485 ELSE fpr_plugin_id END AS fpr_plugin_id, 
					nomeImmagine 
            FROM 	t_FamiglieProdotti
			
            WHERE	fpr_gruppo_id IN (476)
            	AND t_FamiglieProdotti.attivo = 1
			
            ORDER BY fpr_ordGruppo

recSezName (Datasource=www_achab_it, Time=0ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\common\prodotti.cfm @ 02:04:36.036

                            SELECT 	sez_name
                            FROM 	t_CMS_sezioni
                            WHERE	sez_key = 28

recSubGroups (Datasource=www_achab_it, Time=0ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

            SELECT 	*
            FROM 	t_CMS_gruppi
            WHERE	grp_father_id = 477
            	AND grp_attivo = 1
            
                AND		grp_lingua_id = 13 
            
            ORDER BY grp_ordinamento, grp_descrizione

recFamGroups (Datasource=www_achab_it, Time=1ms, Records=0) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

            SELECT 	keyFamiglieProdotti, descrizione, nomeAlt,fpr_gruppo_id,fpr_ordGruppo,
					CASE WHEN keyFamiglieProdotti IN (115,116,117) THEN 485 ELSE fpr_plugin_id END AS fpr_plugin_id, 
					nomeImmagine 
            FROM 	t_FamiglieProdotti
			
            WHERE	fpr_gruppo_id IN (477)
            	AND t_FamiglieProdotti.attivo = 1
			
            ORDER BY fpr_ordGruppo

recContentsByCnt_Key (Datasource=www_achab_it, Time=1ms, Records=1) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\setPage.cfc @ 02:04:36.036

        	SELECT  *
            FROM 	t_CMS_contenuti
            WHERE	cnt_key = 3953
               	AND cnt_attivo = 1
            
                AND		cnt_lingua_id = 13

getLabel (Datasource=www_achab_it, Time=2ms, Records=100) in D:\Inetpub\dev_achab_it\sito\application\common\getLabel.cfm @ 02:04:36.036

	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 = 13

getMenu (Datasource=www_achab_it, Time=0ms, Records=4) in D:\Inetpub\dev_achab_it\sito\application\COMPONENTS\menu.cfc @ 02:04:36.036

            SELECT 	*
            FROM 	t_CMS_sezioni
            WHERE 	(1=1)
			
			AND sez_posizione_menu = 4 
					AND sez_key NOT IN (4,27)
				
                AND		sez_lingua_id = 13 
            order by 
				sez_ordinamento

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\index.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=/Eng/HomePage.htm
PATH_TRANSLATED=D:\Inetpub\dev_achab_it\sito\application\index.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.179.230
REMOTE_HOST=38.107.179.230
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.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=Eng
hitcount=7
idco=3953
idgr=0
idlingua=13
idme=0
idpr=0
idprdvideo=0
idse=28
idsg=0
lastvisit={ts '2012-02-23 02:04:11'}
siglalingua=EN
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: 24 ms