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.

Virginia Store
Child's Duck Face T Shirts
Child's Duck Face T Shirts
Adults Duck Face and Pocket T Shirts
Adults Duck Face and Pocket T Shirts


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 10:29 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
266 ms 266 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
93 ms 93 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
78 ms 78 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
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
390 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btkansas, Time=62ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29:35.035
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btkansas, Time=16ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29: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 @ 22:29: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=51254389
cftoken=4ad5f45cf1b41789-468CA66D-65B8-C4AA-DB223777FBFA8D55
hitcount=1
lastvisit={ts '2010-03-09 22:29:35'}
timecreated={ts '2010-03-09 22:29:35'}
urltoken=CFID=51254389&CFTOKEN=4ad5f45cf1b41789-468CA66D-65B8-C4AA-DB223777FBFA8D55&jsessionid=2e30ae77aefe7c386f40
Cookie Variables:
CFID=51254389
CFTOKEN=4ad5f45cf1b41789-468CA66D-65B8-C4AA-DB223777FBFA8D55
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30ae77aefe7c386f40
urltoken=CFID=51254389&CFTOKEN=4ad5f45cf1b41789-468CA66D-65B8-C4AA-DB223777FBFA8D55&jsessionid=2e30ae77aefe7c386f40
URL Parameters:
SITE=ks
Debug Rendering Time: 110 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 10:29 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
266 ms 266 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
47 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
375 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btcleveland, Time=62ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29:36.036
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btcleveland, Time=0ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29: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 @ 22:29: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=51254390
cftoken=51b2fb5f46c0f993-468CA8FD-65B8-C4AA-DEC36724619499CE
hitcount=1
lastvisit={ts '2010-03-09 22:29:35'}
timecreated={ts '2010-03-09 22:29:35'}
urltoken=CFID=51254390&CFTOKEN=51b2fb5f46c0f993-468CA8FD-65B8-C4AA-DEC36724619499CE&jsessionid=2e30214a81e614314c50
Cookie Variables:
CFID=51254390
CFTOKEN=51b2fb5f46c0f993-468CA8FD-65B8-C4AA-DEC36724619499CE
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30214a81e614314c50
urltoken=CFID=51254390&CFTOKEN=51b2fb5f46c0f993-468CA8FD-65B8-C4AA-DEC36724619499CE&jsessionid=2e30214a81e614314c50
URL Parameters:
SITE=oh
Debug Rendering Time: 296 ms


Pittsburgh Store
picture of Key Chain
Key Chain

picture of PVGP Hat
PVGP Hat


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 10:29 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
500 ms 500 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
157 ms 157 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
157 ms 157 ms 1 top level E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
15 ms 15 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
734 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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


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=51254391
cftoken=4ecd714357b6b8ae-468CAC48-65B8-C4AA-D03BEA9FB2CD8ECA
hitcount=1
lastvisit={ts '2010-03-09 22:29:36'}
timecreated={ts '2010-03-09 22:29:36'}
urltoken=CFID=51254391&CFTOKEN=4ecd714357b6b8ae-468CAC48-65B8-C4AA-D03BEA9FB2CD8ECA&jsessionid=2e3069f134e4406a6072
Cookie Variables:
CFID=51254391
CFTOKEN=4ecd714357b6b8ae-468CAC48-65B8-C4AA-D03BEA9FB2CD8ECA
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e3069f134e4406a6072
urltoken=CFID=51254391&CFTOKEN=4ecd714357b6b8ae-468CAC48-65B8-C4AA-D03BEA9FB2CD8ECA&jsessionid=2e3069f134e4406a6072
URL Parameters:
SITE=pt
Debug Rendering Time: 78 ms


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

picture of Set of Note Cards and Envelopes
Set of Note Cards and Envelopes


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 10:29 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
234 ms 234 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
47 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
328 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

current_store (Datasource=btarizona, Time=31ms, Records=2) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29: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 @ 22:29: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 @ 22:29:37.037
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 12


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=51254392
cftoken=7de18865bbe2081c-468CB011-65B8-C4AA-D8CC6570C2C7F6A5
hitcount=1
lastvisit={ts '2010-03-09 22:29:37'}
timecreated={ts '2010-03-09 22:29:37'}
urltoken=CFID=51254392&CFTOKEN=7de18865bbe2081c-468CB011-65B8-C4AA-D8CC6570C2C7F6A5&jsessionid=2e30291da4b7261b5c4f
Cookie Variables:
CFID=51254392
CFTOKEN=7de18865bbe2081c-468CB011-65B8-C4AA-D8CC6570C2C7F6A5
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30291da4b7261b5c4f
urltoken=CFID=51254392&CFTOKEN=7de18865bbe2081c-468CB011-65B8-C4AA-D8CC6570C2C7F6A5&jsessionid=2e30291da4b7261b5c4f
URL Parameters:
SITE=az
Debug Rendering Time: 78 ms


St.Louis Store
picture of Habitat for Humanity Books
Habitat for Humanity Books

picture of Denim caps with embroided HFHSL logo
Denim caps with embroided HFHSL logo


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 10:29 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
312 ms 312 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
312 ms 312 ms 1 E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm
297 ms 297 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequestStart(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
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
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
656 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 @ 22:29:38.038
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=btstlouis, Time=47ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29:38.038
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18

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


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=51254393
cftoken=f6836d03e1c4094d-468CB262-65B8-C4AA-D71887AE77ACAD4A
hitcount=1
lastvisit={ts '2010-03-09 22:29:38'}
timecreated={ts '2010-03-09 22:29:38'}
urltoken=CFID=51254393&CFTOKEN=f6836d03e1c4094d-468CB262-65B8-C4AA-D71887AE77ACAD4A&jsessionid=2e30fac2413d49676a33
Cookie Variables:
CFID=51254393
CFTOKEN=f6836d03e1c4094d-468CB262-65B8-C4AA-D71887AE77ACAD4A
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e30fac2413d49676a33
urltoken=CFID=51254393&CFTOKEN=f6836d03e1c4094d-468CB262-65B8-C4AA-D71887AE77ACAD4A&jsessionid=2e30fac2413d49676a33
URL Parameters:
SITE=st
Debug Rendering Time: 62 ms


Colorado Store
picture of Beacon of Hope Outreach Center Katrina Sweatshirt
Beacon of Hope Outreach Center Katrina Sweatshirt

picture of Make-A-Wish Foundation 25th Anniversary Music CD
Make-A-Wish Foundation 25th Anniversary Music CD


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /store/allblacktiestores.cfm
Time Stamp 09-Mar-10 10:29 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
16 ms 16 ms 1 CFC[ E:\hosts\blacktiecolorado\htdocs\application.cfc | onRequest(/store/allblacktiestores.cfm) ] from E:\hosts\blacktiecolorado\htdocs\application.cfc
16 ms 16 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
359 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 @ 22:29:39.039
	SELECT 
		TOP 2 productid, picture,title
	FROM 
		tblStoreItems
	WHERE 
		show = 1 
	ORDER BY 
		dateshown, productid
update_shown (Datasource=blacktie, Time=16ms, Records=0) in E:\hosts\blacktiecolorado\htdocs\store\allblacktiestores.cfm @ 22:29:39.039
		UPDATE tblStoreItems 
		SET dateshown = GETDATE()
		WHERE productid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 56

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


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=51254394
cftoken=335db36f17092fcd-468CB5CD-65B8-C4AA-D7B02495ABDB19E7
hitcount=1
lastvisit={ts '2010-03-09 22:29:39'}
timecreated={ts '2010-03-09 22:29:39'}
urltoken=CFID=51254394&CFTOKEN=335db36f17092fcd-468CB5CD-65B8-C4AA-D7B02495ABDB19E7&jsessionid=2e306b9529fe543d116c
Cookie Variables:
CFID=51254394
CFTOKEN=335db36f17092fcd-468CB5CD-65B8-C4AA-D7B02495ABDB19E7
Request Parameters:
inlclude_separate_links=true
skipbtlook=0
Session Variables:
sessionid=2e306b9529fe543d116c
urltoken=CFID=51254394&CFTOKEN=335db36f17092fcd-468CB5CD-65B8-C4AA-D7B02495ABDB19E7&jsessionid=2e306b9529fe543d116c
URL Parameters:
SITE=co
Debug Rendering Time: 63 ms