Debugging Information
ColdFusion Server Standard 2016,0,05,303689
Template /createaccount.cfm
Time Stamp 20-Sep-20 12:56 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 34.205.93.2
Host Name 34.205.93.2


Execution Time

Total Time Avg Time Count Template
140 ms 140 ms 1 top level D:\tx-www-3\createaccount.cfm
31 ms 10 ms 3 D:/tx-www-3/admin/assets/qry/qry_tx_lookup.cfm
15 ms 8 ms 2 D:/tx-www-3/admin/assets/qry/qry_tx_location.cfm
15 ms 3 ms 5 D:/tx-www-3/application.cfm
0 ms 0 ms 1 D:/tx-www-3/Application.cfm
0 ms 0 ms 1 D:/tx-www-3/_footer.cfm
0 ms 0 ms 1 D:/tx-www-3/_header.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
140 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qry_search_lookup (Datasource=jobmatchingptptn, Time=16ms, Records=61) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 00:56:34.034
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 185 
                Order by name asc
            
qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=5) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 00:56:34.034
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 227 
                Order by name asc
            
qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=5) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 00:56:34.034
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 306 
                Order by name asc
            
qry_search_location (Datasource=jobmatchingptptn, Time=0ms, Records=15) in D:\tx-www-3\admin\assets\qry\qry_tx_location.cfm @ 00:56:34.034
            	SELECT id, name
                FROM location
                Where level = 2
                Order by level, name  
            
qry_search_location (Datasource=jobmatchingptptn, Time=0ms, Records=223) in D:\tx-www-3\admin\assets\qry\qry_tx_location.cfm @ 00:56:34.034
            	SELECT id, name
                FROM location
                Where level = 1
                Order by level, name  
            


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:\tx-www-3\createaccount.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
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=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=talentxchange.my
HTTP_REFERER=
HTTP_URL=/createaccount.cfm?ltype=employer
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=172.16.10.121
PATH_INFO=
PATH_TRANSLATED=D:\tx-www-3\createaccount.cfm
QUERY_STRING=ltype=employer
REMOTE_ADDR=34.205.93.2
REMOTE_HOST=34.205.93.2
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/createaccount.cfm
SERVER_NAME=talentxchange.my
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=2301522
CFTOKEN=50c4083d75bf3fd3-88F3B36A-079E-275C-BB81235E00D7B05A
Session Variables:
cfid=2301522
cftoken=50c4083d75bf3fd3-88F3B36A-079E-275C-BB81235E00D7B05A
companyid=0
fullname=
login_status=0
sessionid=TALENTXCHANGE_2301522_50c4083d75bf3fd3-88F3B36A-079E-275C-BB81235E00D7B05A
urltoken=CFID=2301522&CFTOKEN=50c4083d75bf3fd3-88F3B36A-079E-275C-BB81235E00D7B05A
userid=0
URL Parameters:
ltype=employer
Debug Rendering Time: 0 ms