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 

 1 board at a time  101 Redwood, Inc.
 153lumber  1704650 ont ltd
 1800s enterprises llc  1955
 1961  1966
 1977  1982
 19th Century Timbers  19th Century Timbers
 1st Choice Lumber  2 Griffins Inc.
 258 Poplar LLC  2nd Chance Wood Co.
 2nd Time Around  2x4 Lumber Sales
 3 Timber Trading  3 Trees
 360 Distribution  365 EQUIPMENT SALES
 3D Wood Design Inc.  3T Trading Exim SRL
 4 AS TRADER  4 Plus Ltd.
 4 STAR RECLAIMED LUMBER  417 Barnwood
 47240 TREES  4BQS
 4M Lumber LLC  4Pcom Company Ltd
 5 Acre Mill  5 Star Forest Industries, Ltd.
 5018out on a limb  518022 Alberta Ltd.
 555 AUTO MALL INC.  6M INVEST SRL
 700 Woodworks  7elephants
 800drywood  813131 Ab Ltd.
 815 E St. LLC  84 Lumber Company
 869737 Alberta Ltd.


Debugging Information
ColdFusion Server Standard 10,0,23,302580
Template /directory/directory.cfm
Time Stamp 11-Oct-19 11:12 AM
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
109 ms 109 ms 1 top level C:\inetpub\wwwroot\release_new\directory\directory.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/release_new/Application.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/release_new/include/ad_track.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/release_new/mainvar/global_var.cfm
16 ms 16 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
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/include/woodplanet_top.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/release_new/mainvar/key.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
171 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 @ 11:12:54.054
			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 @ 11:12:54.054
		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=0ms, Records=1) in C:\inetpub\wwwroot\release_new\include\woodplanet_top.cfm @ 11:12:54.054
		select * from ad_ads
		where ad_id = '39'
	
todays_daily (Datasource=westmain, Time=16ms, Records=1) in C:\inetpub\wwwroot\release_new\include\woodplanet_left_new.cfm @ 11:12:54.054
 	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=19) in C:\inetpub\wwwroot\release_new\include\woodplanet_left_new.cfm @ 11:12:54.054
	select msg_id from wp_newsletter_include where msg_id = 28399 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 @ 11:12:54.054
	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=93ms, Records=45) in C:\inetpub\wwwroot\release_new\directory\directory.cfm @ 11:12:54.054
		  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
		  
		  
		  isnumeric(left(company_name,1)) = 1
		    
		  order by company_name asc


Stored Procedures

ads_updatetracktable (Datasource=westmain, Time=62ms) in C:\inetpub\wwwroot\release_new\include\ad_track.cfm @ 11:12:54.054
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  99    
 IN  cf_sql_timestamp  2019-10-11 11:12:54.135    
 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=Other&count=28    
 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=Other&count=28
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=39
AD_DTSTAMP={ts '2019-10-11 11:12:54'}
URL Parameters:
count=28
page=Other
Debug Rendering Time: 31 ms