Start Over Reset Search
Show as a Map - Up to 500 Facilities Show as List
ENERGY STAR Labeled Buildings & Plants
ENERGY STAR Logo Advanced Search
Print this page
1-1 of 1 Facilities. Labeled Buildings represent 46,538 square feet.
Loading. Please Wait.
Office Von Karman Corporate Building 16755
Facility Type: Office
16755 Von Karman, Irvine, CA
Map It! | Full Profile


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:47 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 192.168.15.110
Host Name 192.168.15.110


Execution Time

Total Time Avg Time Count Template
3667 ms 3667 ms 1 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
3667 ms 3667 ms 1 /data/cf_code/estar/index.cfm
2382 ms 2382 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_switch.cfm
2328 ms 2328 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fa_showmap.cfm
1928 ms 1928 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm
629 ms 629 ms 1 /data/cf_code/estar/ia/fbx_layouts.cfm
207 ms 207 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_settings.cfm
190 ms 190 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
143 ms 143 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/dsp_showmap_list.cfm
92 ms 92 ms 1 /data/cf_code/estar/Application.cfm
81 ms 81 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap.cfm
31 ms 31 ms 1 /data/cf_code/estar/fbx_settings.cfm
13 ms 13 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
12 ms 12 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm
11 ms 11 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm
9 ms 9 ms 1 /data/cf_code/estar/ia/fbx_settings.cfm
4 ms 4 ms 1 /data/cf_code/estar/ia/dsp_footer.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/lay_lb_popup.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/view_showmap.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/dsp_sections.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/lay_english_default.cfm
0 ms 0 ms 1 /data/cf_code/estar/OnRequestEnd.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_cache_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_debug_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_layoutoption_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_message_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_specialurlformat_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/fbx_circuits.cfm
0 ms 0 ms 2 /data/cf_code/estar/fbx_server.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_js_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_layout_pick.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagecrumb_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagetitle_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/fbx_settings.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/act_showmap.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_layouts.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/lay_lb_popup_showmap.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_createqstring.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_normalizevalue.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_building_type_id.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_showmap.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_acrobat_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_devnotes.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_email_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_footer_links.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_googletagmanager.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_photo.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_printable_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sitesearch_textbox.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_slogan.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_trail.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/lay_english_standard.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/metadata/metadata.wddx
0 ms 0 ms 2 /data/cf_code/estar/ia/val_language.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_layout.cfm
0 ms 0 ms 1 /data/cf_code/estar/lockoutapps.cfm
0 ms 0 ms 1 /data/coldfusion10/cfusion/CustomTags/inputfilter.cfm
104 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3863 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:47:03.003 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template ia/business/fbx_Layouts.cfm.
	    
12:47:04.004 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template fbx_Layouts.cfm.
	    


SQL Queries

allLocatorResults (Datasource=PMULAB_PMU, Time=141ms, Records=24350, Cached Query) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:47:01.001
	SELECT
		b_id,
		sort_building_name,
		building_name,
		building_type_id,
		building_type,
		bt_id,
		nvl(owner,'N/A') as owner,
		prop_manager,
		address1,
		address2,
		city,
		state,
		state_name,
		zip,
		formatted_zip,
		spp,
		property_type_id,
		property_type_name,
		property_type,
		plantyears,
		ratings_desc,
		yearBuilt,
		floorspace,
		hasFullProfile_tf,
		latitude,
		longitude,
		date_approved,
		approx_yn,
		federal_bldg_yn,
		pin_offset_yn		
	FROM
		mv_bldg_loc_result
	WHERE
		building_type_id != '23'
getCount (Datasource=, Time=110ms, Records=24350) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:47:01.001
SELECT DISTINCT
	b_id,
	floorspace
FROM allLocatorResults
getFootage (Datasource=, Time=1660ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:47:03.003
SELECT SUM(floorspace) AS footage
FROM getCount
allBuildings (Datasource=, Time=7ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:47:03.003
SELECT *
FROM allLocatorResults
WHERE
	1 = 1
	
	
	AND b_id IN (?)

	
ORDER BY
	sort_building_name,
	date_approved DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = b_1992

getFilteredCount (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:47:03.003
SELECT DISTINCT
	b_id,
	floorspace
FROM allBuildings
getFilteredFootage (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:47:03.003
SELECT SUM(floorspace) AS footage
FROM getFilteredCount
getStates (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap.cfm @ 12:47:03.003
SELECT DISTINCT
	state,
	state_name,
	0 AS cnt
FROM allBuildings
ORDER BY state_name
getResultSet (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:47:03.003
SELECT *
FROM allBuildings
getMinLat (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:47:03.003
SELECT MIN(latitude) AS lat
FROM getResultSet
getMaxLat (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:47:03.003
SELECT MAX(latitude) AS lat
FROM getResultSet
getMinLong (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:47:03.003
SELECT MIN(longitude) AS long
FROM getResultSet
getMaxLong (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:47:03.003
SELECT MAX(longitude) AS long
FROM getResultSet
qProfile (Datasource=PMULAB_PMU, Time=38ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:47:03.003
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1992

getMenuItems (Datasource=, Time=187ms, Records=20) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:47:04.004
SELECT *
FROM menuItems
ORDER BY
  itemGroup,
  itemOrder


Scope Variables

Application Variables:
applicationname=lb
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=/data/cf_code/estar/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
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=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energystar.gov
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/data/cf_code/estar/index.cfm
QUERY_STRING=fuseaction=labeled_buildings.showMap&ZIP=&S_CODE=ALL&STARTNUM=1&CITY=&OWNER_ID=&STR=&MINI=&VIEW=&YEAR=2001&PROFILES=0&PAGE=1&BUILDING_TYPE_ID=ALL&filter_b_id=b_1992
REMOTE_ADDR=192.168.15.110
REMOTE_HOST=192.168.15.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.energystar.gov
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=
WEB_SERVER_API=
Client Variables:
cfid=19822870
cftoken=bf35701ed4469d2c-E93029A5-C452-EA13-57CEE9E291D86451
hitcount=1
lastvisit={ts '2014-07-23 12:47:00'}
timecreated={ts '2014-07-23 12:47:00'}
urltoken=CFID=19822870&CFTOKEN=bf35701ed4469d2c-E93029A5-C452-EA13-57CEE9E291D86451
Cookie Variables:
CFID=19822870
CFTOKEN=bf35701ed4469d2c-E93029A5-C452-EA13-57CEE9E291D86451
URL Parameters:
BUILDING_TYPE_ID=ALL
CITY=
MINI=
OWNER_ID=
PAGE=1
PROFILES=0
STARTNUM=1
STR=
S_CODE=ALL
VIEW=
YEAR=2001
ZIP=
filter_b_id=b_1992
fuseaction=labeled_buildings.showMap
Debug Rendering Time: 301 ms