Debugging Information
| ColdFusion Server Enterprise |
8,0,0,176276 |
| Template |
/index.cfm |
| Time Stamp |
20-Nov-08 12:30 AM |
| Locale |
English (US) |
| User Agent |
ColdFusion |
| Remote IP |
192.168.5.4 |
| Host Name |
192.168.5.4 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 265 ms |
265 ms |
1 |
CFC[ D:\webRoot\org\nationalnotary\getIPlocation.cfc | getIPlocation(IPADDR = 192.168.5.4) ] from D:\webRoot\org\nationalnotary\getIPlocation.cfc |
| 265 ms |
265 ms |
1 |
CFC[ D:\webRoot\org\nationalnotary\getIPlocation.cfc | getIPregion(IPADDR = 192.168.5.4) ] from D:\webRoot\org\nationalnotary\getIPlocation.cfc |
| 265 ms |
265 ms |
1 |
D:\webRoot\NationalNotary.org\Application.cfm |
| 16 ms |
16 ms |
1 |
D:\webRoot\NationalNotary.org\index.cfm |
| 0 ms |
0 ms |
1 |
CFC[ D:\webRoot\NationalNotary.org\nnaOnline.cfc | getStateList() ] 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:\webRoot\NationalNotary.org\OnRequestEnd.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\menus\t_nnamenupop.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\t_pagefooter1.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\t_pageheader.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\common\t_pagenavcolumn.cfm |
| 0 ms |
0 ms |
1 |
D:\webRoot\NationalNotary.org\fixState.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 281 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
qCatList (Datasource=sql_InsidetheNNA, Time=0ms, Records=10, Cached Query) in D:\webRoot\NationalNotary.org\common\t_pageheader.cfm @ 00:30:00.000
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=0ms) in D:\webRoot\NationalNotary.org\nnaOnline.cfc @ 00:30:00.000
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
|
| |
| resultsets |
name | resultset |
q_states |
1 |
|
getIPlocation (Datasource=ipLocation, Time=265ms) in D:\webRoot\org\nationalnotary\getIPlocation.cfc @ 00:30:00.000
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
IN |
cf_sql_float |
3232278532 |
|
|
|
| |
| resultsets |
name | resultset |
locationvar |
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\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=
HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.nationalnotary.org
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/index.cfm
PATH_TRANSLATED=D:\webRoot\NationalNotary.org\index.cfm
QUERY_STRING=
REMOTE_ADDR=192.168.5.4
REMOTE_HOST=192.168.5.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.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=6351613
cftoken=93630518
hitcount=1
lastvisit={ts '2008-11-20 00:30:00'}
login=
pass=
statefocus=National
timecreated={ts '2008-11-20 00:30:00'}
urltoken=CFID=6351613&CFTOKEN=93630518&jsessionid=f03097cde9adc3523a7f5b3d0a226165a147
Cookie Variables:
CFID=6351613
CFTOKEN=93630518
STATE=National
Form Fields:
AREA=NNA
KEYWORD=
PRODUCTREFID=
PRODUCTTYPE=
REDIRECT=community/index.cfm
SEMINAR=
Session Variables:
becomestate=California
browser=Internet Explorer
browsercheck=no
browseros=
browserversion=6.0
city=
confcart=
confguestnames=0
confprefername=
confrequests=
confroster=0
confveg=No
csa_expires=
first_name=
flashversion=None
iplocran=1
last_name=
laststateverify=
mid=
nnaid=
nsa=
nsaexam=
nsaexpire=
nsarenewal=no
nsastate=CA
nsatrain=
os=
pagestarted=
pagewatch=
pavalidate=0
phone=
qstringcurrent=
refer=
rooturl=index.cfm
secureadmin=no
securecheck=no
seotrackingid=
sessionid=f03097cde9adc3523a7f5b3d0a226165a147
sourcecode=
sourceprint=
state=National
stateabbrev=
statefocus=National
stringurl=
urltoken=CFID=6351613&CFTOKEN=93630518&jsessionid=f03097cde9adc3523a7f5b3d0a226165a147
validated=0
zip=
URL Parameters:
ACTION=
ERROR=
LOGIN=
LOGOUT=no
TEXT=
Debug Rendering Time: 31 ms
|