HOME     ELECTRONICS      BROADCAST

 

     


3M / You shouldn't h…
ADDA Corporation
ADM Technology
ADM Technology / ADM…
ADM Technology / Ste…
Ampex / Reflections …

 

Ampex / VPR-20 Edge
Ampex / VPR-2B Edge
Ampex / VPR-2B Edge
Bosch / Fernseh Inc
Bosch / Fernseh Inc
Broadcast Electronic…

 

Canadian General Ele…
Central Dynamics
Cetec Broadcast Grou…
Cetec Vega
Cetec Vega / Dynex
Cetec Vega / Wireles…


 
     



Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /electronics/broadcast/Index.cfm
Time Stamp 02-Sep-15 01:28 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.159.26.69
Host Name 54.159.26.69


Execution Time

Total Time Avg Time Count Template
719 ms 719 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/electronics/broadcast/index.cfm
704 ms 704 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/library/templates/template.cfm
688 ms 688 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/library/includes/nav.view.new.cfm
0 ms 0 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/Application.cfm
0 ms 0 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/library/includes/footer.cfm
0 ms 0 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/library/includes/masthead.cfm
0 ms 0 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/library/templates/content/category.model.cfm
0 ms 0 ms 1 D:/Inetpub/vhosts/adsausage.com/httpdocs/library/templates/content/category.view.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
735 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetMyCat (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\templates\content\category.model.cfm @ 01:28:14.014
	SELECT headline, title, deptID, sub_sort
	FROM categories
	WHERE active = 1
	AND id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 118

GetMyDept (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\templates\content\category.model.cfm @ 01:28:14.014
	SELECT headline, title
	FROM departments
	WHERE id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3

GetMyAds (Datasource=adsausagedsn, Time=0ms, Records=18) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\templates\content\category.model.cfm @ 01:28:14.014
		SELECT TOP 18 a.id, a.title, a.TotalRows, '/library/images/thumb/'+a.thumb as thumb
		
		
		
		FROM (
			SELECT ROW_NUMBER() OVER (ORDER BY ads.title) AS RowNumber, ads.*, TotalRows = Count(*) OVER ()
			FROM ads INNER JOIN
			categories on categories.id = ads.catID
			WHERE ads.catID = ? 
            AND categories.active = 1
            AND ads.active = 1
		) a
		WHERE RowNumber >= ?
		ORDER BY title
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 118
Parameter #2(cf_sql_integer) = 1

getDepts (Datasource=adsausagedsn, Time=0ms, Records=14) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT id
	FROM departments
	WHERE active = 1
	AND id <> 5
	ORDER BY title
getDepts2 (Datasource=adsausagedsn, Time=0ms, Records=4) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT id, title
	FROM departments
	WHERE active = 1
	AND main = 0
	ORDER BY title
getCats (Datasource=adsausagedsn, Time=0ms, Records=120) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT categories.id, categories.deptID, categories.headline, categories.title, categories.sub_sort, departments.image as banner
	FROM categories INNER JOIN
    	departments ON departments.id = categories.deptID
	WHERE categories.active = 1
	ORDER BY categories.headline
get2 (Datasource=, Time=0ms, Records=8) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 2
	ORDER BY headline
get21 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 21
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 21 
get17 (Datasource=, Time=0ms, Records=3) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 17
	ORDER BY headline
get6 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 6
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 6 
get10 (Datasource=, Time=0ms, Records=11) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 10
	ORDER BY headline
get8 (Datasource=, Time=0ms, Records=5) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 8
	ORDER BY headline
get3 (Datasource=, Time=0ms, Records=10) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 3
	ORDER BY headline
get7 (Datasource=, Time=0ms, Records=3) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 7
	ORDER BY headline
get19 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 19
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=15ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 19 
get12 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 12
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 12 
get4 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 4
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 4 
get13 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 13
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=16ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 13 
get15 (Datasource=, Time=0ms, Records=0) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 15
	ORDER BY headline
getTemp (Datasource=adsausagedsn, Time=0ms, Records=1) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
            SELECT image as banner
            FROM departments
            WHERE id = 15 
get16 (Datasource=, Time=0ms, Records=13) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
	SELECT *
	FROM getCats
	WHERE deptID = 16
	ORDER BY headline
getA_D (Datasource=, Time=0ms, Records=17) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
		SELECT *
		FROM getCats
		WHERE deptID = 5
		AND sub_sort = 'A_D'
	
getE_H (Datasource=, Time=0ms, Records=7) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
		SELECT *
		FROM getCats
		WHERE deptID = 5
		AND sub_sort = 'E_H'
	
getI_M (Datasource=, Time=0ms, Records=15) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
		SELECT *
		FROM getCats
		WHERE deptID = 5
		AND sub_sort = 'I_M'
	
getN_Q (Datasource=, Time=0ms, Records=9) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
		SELECT *
		FROM getCats
		WHERE deptID = 5
		AND sub_sort = 'N_Q'
	
getR_U (Datasource=, Time=0ms, Records=12) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
		SELECT *
		FROM getCats
		WHERE deptID = 5
		AND sub_sort = 'R_U'
	
getV_Z (Datasource=, Time=0ms, Records=6) in D:\Inetpub\vhosts\adsausage.com\httpdocs\library\includes\nav.view.new.cfm @ 01:28:14.014
		SELECT *
		FROM getCats
		WHERE deptID = 5
		AND sub_sort = 'V_Z'
	
Debug Rendering Time: 15 ms