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 97,823 square feet.
Loading. Please Wait.
Retail Store 11096-Portage
Facility Type: Retail Store
6495 US Hwy 6, Portage, IN
Map It! | Profile


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:46 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
225 ms 225 ms 1 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
225 ms 225 ms 1 top level /data/cf_code/estar/index.cfm
186 ms 186 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_switch.cfm
185 ms 185 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fa_showmap.cfm
154 ms 154 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm
22 ms 22 ms 1 /data/cf_code/estar/ia/fbx_layouts.cfm
13 ms 13 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm
11 ms 11 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
9 ms 9 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap.cfm
2 ms 2 ms 1 /data/cf_code/estar/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/Application.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/lay_english_default.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/metadata/metadata.wddx
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/dsp_showmap_list.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/business/labeled_buildings/view_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.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_sections.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 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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
228 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:46:48.048 - 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:46:48.048 - 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=34ms, Records=24350, Cached Query) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:46:48.048
	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=49ms, Records=24350) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:46:48.048
SELECT DISTINCT
	b_id,
	floorspace
FROM allLocatorResults
getFootage (Datasource=, Time=68ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:46:48.048
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:46:48.048
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_1634938

getFilteredCount (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:46:48.048
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:46:48.048
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:46:48.048
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:46:48.048
SELECT *
FROM allBuildings
getMinLat (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:46:48.048
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:46:48.048
SELECT MAX(latitude) AS lat
FROM getResultSet
getMinLong (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:46:48.048
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:46:48.048
SELECT MAX(longitude) AS long
FROM getResultSet
getMenuItems (Datasource=, Time=9ms, Records=20) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:46:48.048
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&ALSO_SEARCH_ID=NONE&ZIP=&S_CODE=ALL&STARTNUM=1&CITY=&OWNER_ID=&STR=&MINI=&VIEW=&YEAR=2009&PROFILES=0&PAGE=1&BUILDING_TYPE_ID=780&filter_b_id=b_1634938
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=19822814
cftoken=3d05e1f6c6542641-E92E49C9-D9FE-E5B0-7D852400AE83CD7C
hitcount=1
lastvisit={ts '2014-07-23 12:46:48'}
timecreated={ts '2014-07-23 12:46:48'}
urltoken=CFID=19822814&CFTOKEN=3d05e1f6c6542641-E92E49C9-D9FE-E5B0-7D852400AE83CD7C
Cookie Variables:
CFID=19822814
CFTOKEN=3d05e1f6c6542641-E92E49C9-D9FE-E5B0-7D852400AE83CD7C
URL Parameters:
ALSO_SEARCH_ID=NONE
BUILDING_TYPE_ID=780
CITY=
MINI=
OWNER_ID=
PAGE=1
PROFILES=0
STARTNUM=1
STR=
S_CODE=ALL
VIEW=
YEAR=2009
ZIP=
filter_b_id=b_1634938
fuseaction=labeled_buildings.showMap
Debug Rendering Time: 55 ms