WoodPlanet Lumber & Wood Products Supplier Directory

Featured Companies  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  Other 

 Advantage Forestal Brazil / Advantage Trim & Lumber  Advantage Trim & Lumber
 Advantage Trim & Lumber  Advantage Trim & Lumber
 Advantage Trim & lumber  All American Reclaim
 American Cypress and Hardwood, LLC  Antique Building Materials
 Appalachian Forest Products  Applewhite Industries, LLC
 Armster Reclaimed Lumber Company  Biewer Lumber, LLC
 Big River Cypress & Hardwood, Inc.  Bozovich Timber Products
 Burlee Original  Canton Hardwood Co.
 Cashel Beams and Flooring  Central Hardwoods
 Craftsman Lumber Co.  Davislogging
 Endeavor Hardwoods Inc  Florip Toolworks
 geppert wood ind.  Greener Lumber
 Heritage Reclaimed Materials  High Country Lumber
 Historic Woods of the Great Lakes  Independent Stave Company
 J&L Barn Salvage  Jackel Enterprises, Inc.
 James Riness  k-diamond
 Kamuela Hardwoods Inc.  Lake George Forest Products
 Lang's Barn Recycling Inc.  Mid America Barnwood
 Millwork Products Imports  Montimber International LLC
 NW IMPERIAL HARDWOODS  Oakdale Lumber
 Old American Lumber  One Family Hardwoods
 Patrick Lumber/Patrick Export Company  Penn-Sylvan International Inc.
 Reclaim It  Roberts Plywood
 Sears Trostel Lumber  Simply Wood Inc.
 Stutzman Sawing  Sugar Ridge Timber Inc..
 Superior Building Supplies  Tkalcac Lumber
 Tuscarora Wood Midwest LLC  Wood, Steel & Glas, Inc.


Debugging Information
ColdFusion Server Standard 10,0,23,302580
Template /directory/directory.cfm
Time Stamp 14-Jun-18 01:00 PM
Locale English (US)
User Agent ColdFusion
Remote IP 74.115.231.227
Host Name 74.115.231.227


Execution Time

Total Time Avg Time Count Template
374 ms 374 ms 1 C:/inetpub/wwwroot/release_new/directory/directory.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/release_new/Application.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/release_new/include/ad_track.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/release_new/mainvar/global_var.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/release_new/include/woodplanet_header.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/release_new/include/woodplanet_left_new.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/release_new/include/woodplanet_top.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/directory/dirheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/include/cookietest.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/include/googleanalytics.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/include/loginboxregbuy.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/include/woodplanet_footer.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/mainvar/key.cfm
32 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
484 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getsites (Datasource=westmain, Time=0ms, Records=1) in C:\inetpub\wwwroot\release_new\mainvar\global_var.cfm @ 13:00:50.050
			select ssite_id from ref_ssite where ssite_home = 'www.woodplanet.com'
		
qGetAllBanners (Datasource=westmain, Time=0ms, Records=4) in C:\inetpub\wwwroot\release_new\include\woodplanet_top.cfm @ 13:00:50.050
		select ad_id, g_weight from ad_ads where ad_id != 10 and ssite_id = 1 and ad_type = 0 
        	and g_weight <> 0 
        	and (requires_service = 0 or (requires_service = 11 and company_id in (select company_id from company_service where service_id = 11)))	
	
qGetBanner (Datasource=westmain, Time=15ms, Records=1) in C:\inetpub\wwwroot\release_new\include\woodplanet_top.cfm @ 13:00:50.050
		select * from ad_ads
		where ad_id = '14'
	
todays_daily (Datasource=westmain, Time=0ms, Records=1) in C:\inetpub\wwwroot\release_new\include\woodplanet_left_new.cfm @ 13:00:50.050
 	select top 1 msg_id from wp_newsletter_include where msg_id is not null and date_sent is not null order by date_sent desc
is_today (Datasource=westmain, Time=0ms, Records=46) in C:\inetpub\wwwroot\release_new\include\woodplanet_left_new.cfm @ 13:00:50.050
	select msg_id from wp_newsletter_include where msg_id = 26175 and date_sent between dateadd(d,-1,getdate()) and getdate()
GetCategory (Datasource=westmain, Time=0ms, Records=15) in C:\inetpub\wwwroot\release_new\include\woodplanet_left_new.cfm @ 13:00:50.050
	SELECT ph.prod_id, prod_descr
	FROM prod_hier ph, ref_prod ref
	WHERE ph.prod_id = ref.prod_id and ph.parent_id is NULL and ph.ssite_id = 1
		order by ref.list_order asc
getcompids (Datasource=westmain, Time=172ms, Records=54) in C:\inetpub\wwwroot\release_new\directory\directory.cfm @ 13:00:50.050
		  select distinct c.company_id, company_name from company c, comp_prod_map cpm where c.is_supplier = 1 and
		  c.removal_date is NULL and c.company_id = cpm.company_id and
		  
		  c.company_id in (select company_id from company_service 
		  where service_id = 5 and ssite_id = 1 and isnull(suspended_date,dateadd(yy,1,getdate())) > getdate())
		    
		  order by company_name asc


Stored Procedures

ads_updatetracktable (Datasource=westmain, Time=78ms) in C:\inetpub\wwwroot\release_new\include\ad_track.cfm @ 13:00:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  99    
 IN  cf_sql_timestamp  2018-06-14 13:00:50.534    
 IN  cf_sql_varchar  74.115.231.227    
 IN  cf_sql_varchar  imp    
 IN  cf_sql_varchar  newuser    
 IN  cf_sql_varchar  /directory/directory.cfm    
 IN  cf_sql_varchar  page=FC&count=1    
 IN  cf_sql_varchar      
    
resultsets
nameresultset


Scope Variables

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=C:\inetpub\wwwroot\release_new\directory\directory.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.woodplanet.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=ColdFusion
LOCAL_ADDR=www.woodplanet.com
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\release_new\directory\directory.cfm
QUERY_STRING=page=FC&count=1
REMOTE_ADDR=74.115.231.227
REMOTE_HOST=74.115.231.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/directory.cfm
SERVER_NAME=www.woodplanet.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Cookie Variables:
AD=14
AD_DTSTAMP={ts '2018-06-14 13:00:50'}
URL Parameters:
count=1
page=FC
Debug Rendering Time: 16 ms