BOW-TIQUE

Buy Premium Blend Coffee and Support your Favorite Nonprofit.
$2 from your purchase will go to support your favorite Blacktie nonprofit organization.
When you check out, you will be asked to choose the nonprofit that you wish to receive this money.

America Store


Kansas Store

Decaffeinated Colombia Supremo


Colombia Supremo Coffee


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 06:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 208.106.181.127
Host Name 208.106.181.127


Execution Time

Total Time Avg Time Count Template
203 ms 203 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
125 ms 125 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
94 ms 94 ms 1 top level E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestEnd(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onSessionStart() ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 E:\hosts\blacktiecolorado\htdocs\admin\appcfg\visits.cfm
32 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
360 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btkansas, Time=94ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:35.035
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btkansas, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:35.035
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3

update_shown (Datasource=btkansas, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:35.035
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1


Scope Variables

Application Variables:
applicationname=BlackTieColorado
applicationtimeout=36000
clientmanagement=yes
clientstorage=blacktie
loginstorage=cookie
name=BlackTieColorado
scriptprotect=all
sessionmanagement=true
sessiontimeout=10800
setclientcookies=true
setdomaincookies=NO
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=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.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=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.blacktie-colorado.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/store/allblacktiestores.cfm
PATH_TRANSLATED=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
QUERY_STRING=site=ks
REMOTE_ADDR=208.106.181.127
REMOTE_HOST=208.106.181.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store/allblacktiestores.cfm
SERVER_NAME=www.blacktie-colorado.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=51251594
cftoken=43644a5953bbc375-45C33E25-65B8-C4AA-DBE4AF2B6DA3D047
hitcount=1
lastvisit={ts '2010-03-09 18:49:35'}
timecreated={ts '2010-03-09 18:49:35'}
urltoken=CFID=51251594&CFTOKEN=43644a5953bbc375-45C33E25-65B8-C4AA-DBE4AF2B6DA3D047&jsessionid=2e305a2ae57d87d10754
Cookie Variables:
CFID=51251594
CFTOKEN=43644a5953bbc375-45C33E25-65B8-C4AA-DBE4AF2B6DA3D047
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e305a2ae57d87d10754
urltoken=CFID=51251594&CFTOKEN=43644a5953bbc375-45C33E25-65B8-C4AA-DBE4AF2B6DA3D047&jsessionid=2e305a2ae57d87d10754
URL Parameters:
SITE=ks
Debug Rendering Time: 93 ms


Cleveland Store
picture of Dress For Success's Sean P. Combs Designer Scarf
Dress For Success's Sean P. Combs Designer Scarf

picture of Wigs For Kids Headband
Wigs For Kids Headband


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 06:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 208.106.181.127
Host Name 208.106.181.127


Execution Time

Total Time Avg Time Count Template
297 ms 297 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
47 ms 47 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
47 ms 47 ms 1 top level E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestEnd(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onSessionStart() ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 E:\hosts\blacktiecolorado\htdocs\admin\appcfg\visits.cfm
46 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
390 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btcleveland, Time=31ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:36.036
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btcleveland, Time=16ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:36.036
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 13

update_shown (Datasource=btcleveland, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:36.036
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 14


Scope Variables

Application Variables:
applicationname=BlackTieColorado
applicationtimeout=36000
clientmanagement=yes
clientstorage=blacktie
loginstorage=cookie
name=BlackTieColorado
scriptprotect=all
sessionmanagement=true
sessiontimeout=10800
setclientcookies=true
setdomaincookies=NO
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=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.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=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.blacktie-colorado.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/store/allblacktiestores.cfm
PATH_TRANSLATED=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
QUERY_STRING=site=oh
REMOTE_ADDR=208.106.181.127
REMOTE_HOST=208.106.181.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store/allblacktiestores.cfm
SERVER_NAME=www.blacktie-colorado.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=51251595
cftoken=e9957330eb0cfa72-45C34096-65B8-C4AA-D4BFE73C12062699
hitcount=1
lastvisit={ts '2010-03-09 18:49:36'}
timecreated={ts '2010-03-09 18:49:36'}
urltoken=CFID=51251595&CFTOKEN=e9957330eb0cfa72-45C34096-65B8-C4AA-D4BFE73C12062699&jsessionid=2e30bc0db83940413473
Cookie Variables:
CFID=51251595
CFTOKEN=e9957330eb0cfa72-45C34096-65B8-C4AA-D4BFE73C12062699
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30bc0db83940413473
urltoken=CFID=51251595&CFTOKEN=e9957330eb0cfa72-45C34096-65B8-C4AA-D4BFE73C12062699&jsessionid=2e30bc0db83940413473
URL Parameters:
SITE=oh
Debug Rendering Time: 78 ms


Pittsburgh Store
picture of Children's Beaded Bracelet
Children's Beaded Bracelet

picture of PVGP Retro T-Shirt
PVGP Retro T-Shirt


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 06:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 208.106.181.127
Host Name 208.106.181.127


Execution Time

Total Time Avg Time Count Template
187 ms 187 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
62 ms 62 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
62 ms 62 ms 1 top level E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestEnd(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onSessionStart() ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 E:\hosts\blacktiecolorado\htdocs\admin\appcfg\visits.cfm
32 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
281 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btpittsburgh, Time=47ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:37.037
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btpittsburgh, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:37.037
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 48

update_shown (Datasource=btpittsburgh, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:37.037
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 19


Scope Variables

Application Variables:
applicationname=BlackTieColorado
applicationtimeout=36000
clientmanagement=yes
clientstorage=blacktie
loginstorage=cookie
name=BlackTieColorado
scriptprotect=all
sessionmanagement=true
sessiontimeout=10800
setclientcookies=true
setdomaincookies=NO
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=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.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=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.blacktie-colorado.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/store/allblacktiestores.cfm
PATH_TRANSLATED=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
QUERY_STRING=site=pt
REMOTE_ADDR=208.106.181.127
REMOTE_HOST=208.106.181.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store/allblacktiestores.cfm
SERVER_NAME=www.blacktie-colorado.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=51251596
cftoken=5269f7c505d8a656-45C342F7-65B8-C4AA-D0F88CD2464F11F8
hitcount=1
lastvisit={ts '2010-03-09 18:49:36'}
timecreated={ts '2010-03-09 18:49:36'}
urltoken=CFID=51251596&CFTOKEN=5269f7c505d8a656-45C342F7-65B8-C4AA-D0F88CD2464F11F8&jsessionid=2e30d079ecf051537929
Cookie Variables:
CFID=51251596
CFTOKEN=5269f7c505d8a656-45C342F7-65B8-C4AA-D0F88CD2464F11F8
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30d079ecf051537929
urltoken=CFID=51251596&CFTOKEN=5269f7c505d8a656-45C342F7-65B8-C4AA-D0F88CD2464F11F8&jsessionid=2e30d079ecf051537929
URL Parameters:
SITE=pt
Debug Rendering Time: 110 ms


Arizona Store
picture of 2008 TNFL Restaurant Guide
2008 TNFL Restaurant Guide

picture of <b>Holiday Harps: Las Noches de las Luminarias</b>
Holiday Harps: Las Noches de las Luminarias


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 06:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 208.106.181.127
Host Name 208.106.181.127


Execution Time

Total Time Avg Time Count Template
360 ms 360 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
46 ms 46 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
46 ms 46 ms 1 top level E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
16 ms 16 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestEnd(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onSessionStart() ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 E:\hosts\blacktiecolorado\htdocs\admin\appcfg\visits.cfm
62 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
484 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btarizona, Time=46ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:37.037
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btarizona, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:37.037
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 10

update_shown (Datasource=btarizona, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:37.037
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8


Scope Variables

Application Variables:
applicationname=BlackTieColorado
applicationtimeout=36000
clientmanagement=yes
clientstorage=blacktie
loginstorage=cookie
name=BlackTieColorado
scriptprotect=all
sessionmanagement=true
sessiontimeout=10800
setclientcookies=true
setdomaincookies=NO
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=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.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=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.blacktie-colorado.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/store/allblacktiestores.cfm
PATH_TRANSLATED=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
QUERY_STRING=site=az
REMOTE_ADDR=208.106.181.127
REMOTE_HOST=208.106.181.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store/allblacktiestores.cfm
SERVER_NAME=www.blacktie-colorado.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=51251598
cftoken=657243bfafd52cdd-45C3451A-65B8-C4AA-DC289A5B2FE9E94E
hitcount=1
lastvisit={ts '2010-03-09 18:49:37'}
timecreated={ts '2010-03-09 18:49:37'}
urltoken=CFID=51251598&CFTOKEN=657243bfafd52cdd-45C3451A-65B8-C4AA-DC289A5B2FE9E94E&jsessionid=2e3063e87206553e4550
Cookie Variables:
CFID=51251598
CFTOKEN=657243bfafd52cdd-45C3451A-65B8-C4AA-DC289A5B2FE9E94E
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e3063e87206553e4550
urltoken=CFID=51251598&CFTOKEN=657243bfafd52cdd-45C3451A-65B8-C4AA-DC289A5B2FE9E94E&jsessionid=2e3063e87206553e4550
URL Parameters:
SITE=az
Debug Rendering Time: 63 ms


St.Louis Store
picture of Habitat for Humanity Travel Mugs
Habitat for Humanity Travel Mugs

picture of St. Louis Originals Cookbook
St. Louis Originals Cookbook


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 06:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 208.106.181.127
Host Name 208.106.181.127


Execution Time

Total Time Avg Time Count Template
281 ms 281 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
281 ms 281 ms 1 E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
234 ms 234 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestEnd(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onSessionStart() ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 E:\hosts\blacktiecolorado\htdocs\admin\appcfg\visits.cfm
63 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
578 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btstlouis, Time=219ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:38.038
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btstlouis, Time=31ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:38.038
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 13

update_shown (Datasource=btstlouis, Time=31ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:38.038
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 25


Scope Variables

Application Variables:
applicationname=BlackTieColorado
applicationtimeout=36000
clientmanagement=yes
clientstorage=blacktie
loginstorage=cookie
name=BlackTieColorado
scriptprotect=all
sessionmanagement=true
sessiontimeout=10800
setclientcookies=true
setdomaincookies=NO
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=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.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=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.blacktie-colorado.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/store/allblacktiestores.cfm
PATH_TRANSLATED=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
QUERY_STRING=site=st
REMOTE_ADDR=208.106.181.127
REMOTE_HOST=208.106.181.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store/allblacktiestores.cfm
SERVER_NAME=www.blacktie-colorado.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=51251599
cftoken=97eb3d736565c7bf-45C347C9-65B8-C4AA-D423BCFBCB13E118
hitcount=1
lastvisit={ts '2010-03-09 18:49:38'}
timecreated={ts '2010-03-09 18:49:38'}
urltoken=CFID=51251599&CFTOKEN=97eb3d736565c7bf-45C347C9-65B8-C4AA-D423BCFBCB13E118&jsessionid=2e30a0166ab277a37233
Cookie Variables:
CFID=51251599
CFTOKEN=97eb3d736565c7bf-45C347C9-65B8-C4AA-D423BCFBCB13E118
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30a0166ab277a37233
urltoken=CFID=51251599&CFTOKEN=97eb3d736565c7bf-45C347C9-65B8-C4AA-D423BCFBCB13E118&jsessionid=2e30a0166ab277a37233
URL Parameters:
SITE=st
Debug Rendering Time: 62 ms


Colorado Store
picture of APW Tote-- Includes Shipping
APW Tote-- Includes Shipping

picture of <b>Cherry Creek North Gift Card</b>
Cherry Creek North Gift Card


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 06:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 208.106.181.127
Host Name 208.106.181.127


Execution Time

Total Time Avg Time Count Template
1405 ms 1405 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
31 ms 31 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
15 ms 15 ms 1 top level E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestEnd(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onSessionStart() ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
0 ms 0 ms 1 E:\hosts\blacktiecolorado\htdocs\admin\appcfg\visits.cfm
47 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1483 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=blacktie, Time=0ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:40.040
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=blacktie, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:40.040
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 161

update_shown (Datasource=blacktie, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 18:49:40.040
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 99


Scope Variables

Application Variables:
applicationname=BlackTieColorado
applicationtimeout=36000
clientmanagement=yes
clientstorage=blacktie
loginstorage=cookie
name=BlackTieColorado
scriptprotect=all
sessionmanagement=true
sessiontimeout=10800
setclientcookies=true
setdomaincookies=NO
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=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.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=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.blacktie-colorado.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/store/allblacktiestores.cfm
PATH_TRANSLATED=E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
QUERY_STRING=site=co
REMOTE_ADDR=208.106.181.127
REMOTE_HOST=208.106.181.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store/allblacktiestores.cfm
SERVER_NAME=www.blacktie-colorado.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=51251601
cftoken=56025646dc8f2bce-45C34AF5-65B8-C4AA-DD8BFC96A073390F
hitcount=1
lastvisit={ts '2010-03-09 18:49:38'}
timecreated={ts '2010-03-09 18:49:38'}
urltoken=CFID=51251601&CFTOKEN=56025646dc8f2bce-45C34AF5-65B8-C4AA-DD8BFC96A073390F&jsessionid=2e30537a8d5617626348
Cookie Variables:
CFID=51251601
CFTOKEN=56025646dc8f2bce-45C34AF5-65B8-C4AA-DD8BFC96A073390F
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30537a8d5617626348
urltoken=CFID=51251601&CFTOKEN=56025646dc8f2bce-45C34AF5-65B8-C4AA-DD8BFC96A073390F&jsessionid=2e30537a8d5617626348
URL Parameters:
SITE=co
Debug Rendering Time: 94 ms