Advanced Search

Search Results

--- No record found ---


Execution Time

Total Time Avg Time Count Template
31 ms 5 ms 6 D:/tx-www-3/admin/assets/qry/qry_tx_lookup.cfm
31 ms 31 ms 1 top level D:\tx-www-3\search_jobs.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 0 ms 1 D:/tx-www-3/_left.cfm
0 ms 0 ms 1 D:/tx-www-3/admin/assets/qry/qry_tx_jobs.cfm
0 ms 0 ms 1 D:/tx-www-3/admin/assets/qry/qry_tx_location.cfm
0 ms 0 ms 8 D:/tx-www-3/application.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
31 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=3) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 05:17:58.058
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 192 
                Order by name asc
            
qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=3) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 05:17:58.058
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 233 
                Order by name asc
            
qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=6) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 05:17:58.058
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 183 
                Order by name asc
            
qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=8) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 05:17:58.058
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 188 
                Order by sort asc
            
qry_search_lookup (Datasource=jobmatchingptptn, Time=0ms, Records=5) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 05:17:58.058
            	SELECT id, name, parent_id, groupby
                FROM lookup
                Where parent_id = 438 
                Order by sort asc
            
qry_search_specialization (Datasource=jobmatchingptptn, Time=16ms, Records=91) in D:\tx-www-3\admin\assets\qry\qry_tx_lookup.cfm @ 05:17:58.058
                    
                SELECT A.id, A.name, B.name as parent_name,
                if(B.id IS NULL,0,B.id) as parent_id,
                if(B.sort IS NULL,A.sort,B.sort) as parent_sort, A.sort
                
                FROM specialization A 
                LEFT JOIN specialization B ON A.parent_id=B.id
                WHERE 1=1
                AND A.parent_id != 0 
                ORDER BY parent_sort,parent_id,sort
            
qry_search_location (Datasource=jobmatchingptptn, Time=0ms, Records=15) in D:\tx-www-3\admin\assets\qry\qry_tx_location.cfm @ 05:17:58.058
            	SELECT id, name
                FROM location
                Where level = 2
                Order by level, name  
            
qry_search_job (Datasource=jobmatchingptptn, Time=0ms, Records=0) in D:\tx-www-3\admin\assets\qry\qry_tx_jobs.cfm @ 05:17:58.058
                
                Select A.id as jobid, A.title as jobtitle, A.min_salary, A.max_salary, A.location, Z.name as state_name, Y.name as region_name
                From jobs A
                JOIN companies C
                Left Join location Z ON A.state_id = Z.id
                Left Join lookup Y ON Z.region = Y.id
                WHERE A.company_id = C.id
                AND A.publish = 1
                AND C.deleted =0
                and C.suspend =0
                AND C.project = 7 
                Order by A.date_created desc,A.title 


Scope Variables

URL Parameters:
CID=
PG=1
Debug Rendering Time: 0 ms