Debugging Information
| ColdFusion Server Enterprise |
8,0,0,176276 |
| Template |
/supplies/sitemapmaker.cfm |
| Time Stamp |
11-Jun-08 04:44 PM |
| Locale |
English (US) |
| User Agent |
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14 |
| Remote IP |
10.100.11.3 |
| Host Name |
10.100.11.3 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 47 ms |
47 ms |
1 |
 D:\webRoot\NationalNotary.org\supplies\sitemapmaker.cfm |
| 32 ms |
32 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageProcess.cfm |
| 15 ms |
8 ms |
2 |
CFC[ D:\webRoot\NationalNotary.org\nnaOnline.cfc | getStateList() ] from D:\webRoot\NationalNotary.org\nnaOnline.cfc |
| 15 ms |
15 ms |
1 |
D:\webRoot\NationalNotary.org\Application.cfm |
| 15 ms |
15 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageHeader.cfm |
| 15 ms |
15 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageheading.cfm |
| 0 ms |
0 ms |
2 |
CFC[ D:\webRoot\NationalNotary.org\nnaOnline.cfc | getPageText(PAGEKEY = supplyHome) ] from D:\webRoot\NationalNotary.org\nnaOnline.cfc |
| 0 ms |
0 ms |
1 |
D:\CustomTags\create_pop_help.cfm |
| 0 ms |
0 ms |
1 |
D:\CustomTags\create_pop_help_item.cfm |
| 0 ms |
0 ms |
1 |
D:\CustomTags\pop_help.cfm |
| 0 ms |
0 ms |
1 |
D:\CustomTags\sessionWatch.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\OnRequestEnd.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\mboxTracking.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\menus\nnaMenuPop.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageDefault.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageFooter1.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageFooting.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageNavColumn.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageTags.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageTitle-seo.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\pageTitle.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\process\mpDefaultParams.cfm |
| 31 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 93 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
getAbbrev (Datasource=sql_InsidetheNNA, Time=0ms, Records=1) in D:\webRoot\NationalNotary.org\Application.cfm @ 16:44:59.059
SELECT stateID FROM tblStates WHERE state = 'Florida'
getstatename (Datasource=, Time=0ms, Records=55) in D:\webRoot\NationalNotary.org\supplies\sitemapmaker.cfm @ 16:44:59.059
select * from q_states
qCatList (Datasource=sql_InsidetheNNA, Time=0ms, Records=10, Cached Query) in D:\webRoot\NationalNotary.org\common\pageHeader.cfm @ 16:44:59.059
SELECT c.productCatname
FROM tblProductCat c
WHERE c.productCatActive='True'
AND productCatID NOT IN (23, 24, 26, 14, 12, 9, 8, 18, 25)
ORDER BY productCatname
Stored Procedures
stateQuery (Datasource=sql_InsidetheNNA, Time=15ms) in D:\webRoot\NationalNotary.org\nnaOnline.cfc @ 16:44:59.059
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
|
| |
| resultsets |
name | resultset |
q_states |
1 |
|
pageTextQuery (Datasource=sql_InsidetheNNA, Time=0ms) in D:\webRoot\NationalNotary.org\nnaOnline.cfc @ 16:44:59.059
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
IN |
CF_SQL_VARCHAR |
supplyHome |
|
|
|
| |
| resultsets |
name | resultset |
pageText |
1 |
|
stateQuery (Datasource=sql_InsidetheNNA, Time=0ms) in D:\webRoot\NationalNotary.org\nnaOnline.cfc @ 16:44:59.059
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
|
| |
| resultsets |
name | resultset |
q_states |
1 |
|
productsFeaturedQuery (Datasource=sql_InsidetheNNA, Time=0ms) in D:\webRoot\NationalNotary.org\common\pageProcess.cfm @ 16:44:59.059
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
|
| |
| resultsets |
name | resultset |
featured |
1 |
|
pageTextQuery (Datasource=sql_InsidetheNNA, Time=0ms) in D:\webRoot\NationalNotary.org\nnaOnline.cfc @ 16:44:59.059
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
IN |
CF_SQL_VARCHAR |
supplyHome |
|
|
|
| |
| resultsets |
name | resultset |
pageText |
1 |
|
Scope Variables
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:\webRoot\NationalNotary.org\supplies\sitemapmaker.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/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=CFID=1175642; wm_NNA=1212188706740; __utmz=39795388.1212423462.3.2.utmccn=(organic)|utmcsr=google|utmctr=idaho+notary-classes|utmcmd=organic; CFCLIENT_NNAAPPLICATION=pass%3D%23state%3DFlorida%23statefocus%3DFlorida%23carttextlist8%3D%23cartquantlist%3D%23carttextlist7%3D%23login%3D%23carttextlist6%3D%23carttextlist5%3D%23carttextlist4%3D%23carttextlist3%3D%23carttextlist2%3D%23carttextlist1%3D%23cartmerchlist%3D%23cartseminarlist%3D%23carttypelist%3D%23; mbox=PC#1212422463642-176637#1275497970|session#1213226830216-108849#1213229706|check#true#1213227906; CFTOKEN=72873344; __utma=39795388.62106976.1212188703.1213197090.1213226830.22; WT_FPC=id=65.115.114.131-2686896032.29934233:lv=1213224246288:ss=1213223230607; CFGLOBALS=urltoken%3DCFID%23%3D1175642%26CFTOKEN%23%3D72873344%26jsessionid%23%3Df030370e6aae3ba459b27c1c275b254a2b35%23lastvisit%3D%7Bts%20%272008%2D06%2D11%2016%3A44%3A03%27%7D%23timecreated%3D%7Bts%20%272008%2D05%2D30%2015%3A53%3A58%27%7D%23hitcount%3D211%23cftoken%3D72873344%23cfid%3D1175642%23; __utmc=39795388; JSESSIONID=f030370e6aae3ba459b27c1c275b254a2b35; __utmb=39795388
HTTP_HOST=www.nationalnotary.org
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
PATH_INFO=/supplies/sitemapmaker.cfm
PATH_TRANSLATED=D:\webRoot\NationalNotary.org\supplies\sitemapmaker.cfm
QUERY_STRING=
REMOTE_ADDR=10.100.11.3
REMOTE_HOST=10.100.11.3
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/supplies/sitemapmaker.cfm
SERVER_NAME=www.nationalnotary.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cartmerchlist=
cartquantlist=
cartseminarlist=
carttextlist1=
carttextlist2=
carttextlist3=
carttextlist4=
carttextlist5=
carttextlist6=
carttextlist7=
carttextlist8=
carttypelist=
cfid=1175642
cftoken=72873344
hitcount=211
lastvisit={ts '2008-06-11 16:44:03'}
login=
pass=
state=Florida
statefocus=Florida
timecreated={ts '2008-05-30 15:53:58'}
urltoken=CFID=1175642&CFTOKEN=72873344&jsessionid=f030370e6aae3ba459b27c1c275b254a2b35
Cookie Variables:
CFCLIENT_NNAAPPLICATION=pass=#state=Florida#statefocus=Florida#carttextlist8=#cartquantlist=#carttextlist7=#login=#carttextlist6=#carttextlist5=#carttextlist4=#carttextlist3=#carttextlist2=#carttextlist1=#cartmerchlist=#cartseminarlist=#carttypelist=#
CFGLOBALS=urltoken=CFID#=1175642&CFTOKEN#=72873344&jsessionid#=f030370e6aae3ba459b27c1c275b254a2b35#lastvisit={ts '2008-06-11 16:44:03'}#timecreated={ts '2008-05-30 15:53:58'}#hitcount=211#cftoken=72873344#cfid=1175642#
CFID=1175642
CFTOKEN=72873344
JSESSIONID=f030370e6aae3ba459b27c1c275b254a2b35
WT_FPC=id=65.115.114.131-2686896032.29934233:lv=1213224246288:ss=1213223230607
__utma=39795388.62106976.1212188703.1213197090.1213226830.22
__utmb=39795388
__utmc=39795388
__utmz=39795388.1212423462.3.2.utmccn=(organic)|utmcsr=google|utmctr=idaho notary-classes|utmcmd=organic
mbox=PC#1212422463642-176637#1275497970|session#1213226830216-108849#1213229706|check#true#1213227906
wm_NNA=1212188706740
Form Fields:
AREA=NNA
KEYWORD=
LINE1=0
LINE2=0
LINE3=0
LINE4=0
LINE5=0
LINE6=0
LINE7=0
LINE8=0
MEMTOTFINAL=
NNAID=
NONMEMTOTFINAL=
PRODUCTREFID=
PRODUCTTYPE=
PROMPTRADIO=0
REDIRECT=community/index.cfm
SEMINAR=
SHIPOPTION=UPS
SOURCEMENU=SEARCH
STATE=
STATE2=
VCITY=
VSTATE=
VZIP=
Session Variables:
address=
address2=
addressx=
addressx2=
admin=0
adminabout=0
adminnews=0
adminnsa=0
adminpages=0
adminproducts=0
adminseminar=0
adminsupplypack=0
becomestate=California
browser=Internet Explorer
browsercheck=no
browseros=
browserversion=6.0
city=
city2=
commex=
commexpire=
comp=
compname=
comptype=
confcart=
confguestnames=0
confprefername=
confrequests=
confroster=0
confveg=No
corpcustomer=0
county=
county2=
csa_expires=
discount=
email=
expire=
fax=
first_name=
flashversion=None
fname=
last_name=
lname=
member=newMember
membershipvalid=no
mi=
mid=
name=0
nnaid=
nsa=
nsaexam=
nsaexpire=
nsarenewal=no
nsastate=CA
nsatrain=
orderdiscount=
orderdiscountamt=0
os=
pagestarted=
pagewatch=
partnercode=
password=
pavalidate=0
phone=
pretaxmem=0
pretaxnonmem=0
promo=no
qstringcurrent=
qstringprevious=text=howtoState&state=Montana
refer=
rooturl=index.cfm
salescode=
sameasship=0
secureadmin=no
securecheck=no
seotrackingid=6671
sessionid=f030370e6aae3ba459b27c1c275b254a2b35
shipoption=UPS
shipsurcharge=
source=WEBORD
sourcecode=
sourcemenu=WEBORD
sourceprint=
state=
state2=
stateabbrev=FL
statefocus=Florida
stringurl=
surcharge=0
testexpire=
urltoken=CFID=1175642&CFTOKEN=72873344&jsessionid=f030370e6aae3ba459b27c1c275b254a2b35
user=JARROD#S
validated=0
zip=
zip2=
zipx=
zipx2=
URL Parameters:
ACTION=
CATEGORYID=0
ERROR=
LOGIN=
LOGOUT=no
PRODUCTID=0
STATEID=0
TEXT=supplyHome
Debug Rendering Time: 32 ms
|
