Total Time	Avg Time	Count	Template
12 ms	12 ms	1	/var/www/advantagedata.com/docroot/Application.cfm
2 ms	2 ms	1	/var/www/advantagedata.com/docroot/login.cfm
0 ms	0 ms	1	/var/www/advantagedata.com/docroot/block_by_ip.cfm
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
15 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

        insert into visitorlog (remote_address, host, referer, browser, page, visit_time)
            values('10.20.5.167','10.20.5.167','unknown','CCBot/2.0 (http://commoncrawl.org/faq/)','/login.cfm',sysdate)
    

	select f_generate_client_key(sysdate) k, to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') ts from dual

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=/var/www/advantagedata.com/docroot/login.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.advantagedata.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=10.20.105.16
PATH_INFO=
PATH_TRANSLATED=/var/www/advantagedata.com/docroot/login.cfm
QUERY_STRING=
REMOTE_ADDR=10.20.5.167
REMOTE_HOST=10.20.5.167
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/login.cfm
SERVER_NAME=www.advantagedata.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.2.34 (Unix) DAV/2 mod_ssl/2.2.34 OpenSSL/1.0.2k-fips mod_jk/1.2.41
WEB_SERVER_API=

Client Variables:
cfid=123300
cftoken=30489253
hitcount=1
lastvisit={ts '2018-06-20 12:40:04'}
timecreated={ts '2018-06-20 12:40:04'}
urltoken=CFID=123300&CFTOKEN=30489253&jsessionid=83807B5EB998D7101591937D9B6156C9.cfusion

Cookie Variables:
CFID=123300
CFTOKEN=30489253

Session Variables:
sessionid=83807B5EB998D7101591937D9B6156C9.cfusion
urltoken=CFID=123300&CFTOKEN=30489253&jsessionid=83807B5EB998D7101591937D9B6156C9.cfusion