Execution Time

Total Time Avg Time Count Template
110 ms 110 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
16 ms 16 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 0 ms 2 D:/tx-www-3/admin/assets/qry/qry_tx_location.cfm
0 ms 0 ms 5 D:/tx-www-3/application.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
126 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qry_search_lookup (Datasource=jobmatchingptptn, Time=31ms, Records=61) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 06:35:01.001
            	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 @ 06:35:01.001
            	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 @ 06:35:01.001
            	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 @ 06:35:01.001
            	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 @ 06:35:01.001
            	SELECT id, name
                FROM location
                Where level = 1
                Order by level, name  
            


Scope Variables

URL Parameters:
ltype=employer
Debug Rendering Time: 15 ms