The Kelco Tree Planter


  • Heavy Steel Construction
  • Blade furrowing size is adjustable up to a three foot tree.
  • Spacing attachments available in various sizes from 4 to 8 feet (see below). A wheel can also be special ordered to users exact requirements.
  • Comes fully assembled.
F.O.B Milbridge, Maine
Shipped via Motor Freight

Qty 
Item #: TP300
Kelco Tree Planter
Out of Stock
760 lbs
Ships Motor Freight Only

$3,844.00
Scroll down to order Spacer Wheel Attachments

Spacer Wheel Attachment Sold Seperately.

Click here for Accessories.

We built this planter for our own use. It works great in sod or plowed ground for small or large transplants.

The planter weighs 760 lbs. Towing specifications: three-point hitch-category 1 or 2. The minimum horsepower of the towing tractor is 16 HP.

The planter is equipped for two individuals to be seated and to plant.

To plant in sandy or loamy soil, set furrowing shoe to desired depth (up to 9" maximum). Tree planter should be made to point slightly downward when attached to tractor or tow vehicle. This will insure an aggressive cut by the coulture wheel. Two people should be used during planting process. If you are to use one person, the opposite seat should be weighted at approx. 160 lbs. This insures that the packing wheels (rubber wheels in rear) will be able to repack the soil that was displaced by furrowing shoe.

Drive shoe spacers come with the Tree Planter. These spacers are used to set the width of the wings of the shoe, which in turn, determines the width of the furrow. The three spacers are as follows: small spacer will give you a 4" furrow, medium spacer creates a 6" furrow, and the large spacer creates a 8" furrow. The size of the spacer is determined by the individual planting requirements of the user.

An optional Spacing Wheel Attachment may also be used with the Kelco Tree Planter. This is an enclosed metal wheel which is attached to the side of the planter and rides on the ground next to the planter. Inside the metal wheel is a spring that rides within a metal tube. The spring makes a clunking sound once during a full rotation of the wheel. When clunking sound is heard, person planting trees should immediately put tree in furrow. The spacer wheels come in the various sizes: from 4 to 8 feet. A wheel can also be special ordered to users exact requirements.

To plant trees in a straight row, the driver of the tow vehicle should pick a line of sight object in front of him. This object can then be sighted with an object on the tow vehicle it self. Once the two objects are in direct line of sight, you can commence the planting project. TIP:Once first row of trees has been planted, a rod, with one end attached to front of tow vehicle, and a rope or light chain approximately the height of tractor from ground up attached to other end, can be used to keep rows straight. The hanging chain or rope is used to go lightly over your first row of trees and is used to insure that the second row and so on are equidistant from the first row.


SPECIFICATIONS

  • Weight: 760 lbs.
  • Over All Length: 6' - 6" PLUS SPACER WHEEL
  • Over All Width: 5' - 4"
  • Over All Height: 3' - 6"
  • Coulter Diameter: 20"
  • Shoe Width: 7"
  • Furrow Width: 6" - 10" - 12" ADJUSTABLE
  • Furrow Depth: ADJUSTABLE UP TO 9"
  • Leg Room: 32"
  • Planting Stock Trays: 20" x 22" (2 EACH)
  • Packing Wheels: ADJUSTABLE - WIDTH & ANGLE

Spacer Attachments -

 These spacer attachments for the Kelco Tree Planter helps you plant your trees with accurate spacing between each seedling. See below for extra wheels.

Qty 
Item #: TP302-4
Spacer Attachment Kit 4 Foot
1 Kit
Out of Stock
62 lbs

$440.00

Qty 
Item #: TP302-5
Spacer Attachment Kit 5 Foot
1 Kit
In Stock
62 lbs
Ships Motor Freight Only

$440.00

Qty 
Item #: TP302-6
Spacer Attachment Kit 6 Foot
1 Kit
In Stock
62 lbs

$440.00

Qty 
Item #: TP302-7
Spacer Attachment Kit 7 Foot
1 Kit
Out of Stock
62 lbs

$440.00

Qty 
Item #: TP302-8
Spacer Attachment Kit 8 Foot
1 Kit
In Stock
62 lbs

$440.00

Extra Spacer Wheels -

 If you already have a spacer attachment, these extra wheels let you setup for additional spacing requirements.

Qty 
Item #: TP303-4
Spacer Wheel Only 4 Foot
1 Unit
Out of Stock
30 lbs

$245.30

Qty 
Item #: TP303-5
Spacer Wheel Only 5 Foot
1 Unit
In Stock
30 lbs

$245.30

Qty 
Item #: TP303-5.6
Spacer Wheel Only 5 1/2 Foot
1 Unit
In Stock
13 lbs

$245.30

Qty 
Item #: TP303-6
Spacer Wheel Only 6 Foot
1 Unit
In Stock
30 lbs

$245.30

Qty 
Item #: TP303-7
Spacer Wheel Only 7 Foot
1 Unit
Out of Stock
30 lbs
Ships Motor Freight Only

$245.30

Qty 
Item #: TP303-8
Spacer Wheel Only 8 Foot
1 Unit
In Stock
30 lbs
Ships Motor Freight Only

$245.30


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /tp300.cfm (/var/www/html/kelcomaine/tp300.cfm)
Time Stamp Aug 19, 2019 10:39 AM
Time Zone UTC
Locale English (us)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 127.0.0.1
Host Name kelcomaine.com
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
228 ms 228 ms 1 /var/www/html/kelcomaine/tp300page.cfm
35.8 ms 8.96 ms 4 /var/www/html/kelcomaine/makemenu.cfm
60.8 ms 5.07 ms 12 /var/www/html/kelcomaine/getitemweb.cfm
1.23 ms 1.23 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
1.14 ms 1.14 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
10.9 ms 0.91 ms 12 /var/www/html/kelcomaine/addtocartform.cfm
9.3 ms 0.775 ms 12 /var/www/html/kelcomaine/showitemdetail.cfm
0.321 ms 0.321 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.19 ms 0.19 ms 1 /var/www/html/kelcomaine/Application.cfc
0.135 ms 0.135 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.119 ms 0.119 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.109 ms 0.109 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.092 ms 0.092 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.031 ms 0.031 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.027 ms 0.027 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.021 ms 0.021 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentContains
0.017 ms 0.017 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.028 ms 0.014 ms 2 /var/www/html/kelcomaine/WEB-INF/lucee/context/Component.cfc
0.008 ms 0.008 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.008 ms 0.008 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$init
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/addtoprocess.cfm
0.003 ms 0.003 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.01 ms 0.002 ms 5 /var/www/html/kelcomaine/addbackorderbutton.cfm
0.012 ms 0.001 ms 7 /var/www/html/kelcomaine/addtocartbutton.cfm
0 ms 0 ms 12 /var/www/html/kelcomaine/showproductpageitem.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/tp300.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.868 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
287 ms  APPLICATION EXECUTION TIME
61.2 ms  QUERY EXECUTION TIME
349 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /addtocartform.cfm 1 noanchor 11
variables /addtocartform.cfm 2 NOANCHOR 1
variables /addtocartform.cfm 5 NOANCHOR 12
query /addtocartform.cfm 6 ITEMN 12
cgi /addtocartform.cfm 8 QUERY_STRING 12
query /addtocartform.cfm 8 ITEMN 12
query /addtocartform.cfm 12 ONHAND 12
query /addtocartform.cfm 12 RESERVED 12
query /addtocartform.cfm 12 KIT_AVAILABLE 8
variables /addtocartform.cfm 12 ALWAYSINSTOCK 5
query /addtocartform.cfm 12 ITEMN 5
query /addtocartform.cfm 28 BACKORDERMSG 12
query /addtocartform.cfm 29 ITEMN 12
query /addtocartform.cfm 30 ITEMN 12
variables /Application.cfc 34 MOBILEDETECTION 1
variables /Application.cfc 35 MOBILEDETECTION 1
variables /Application.cfc 88 cflock 1
variables /Application.cfc 108 CLIENT_IP 1
variables /Application.cfc 110 CLIENT_IP 1
variables /Application.cfc 112 RIP 1
variables /Application.cfc 112 CLIENT_IP 1
variables /Application.cfc 136 rip 1
variables /Application.cfc 137 RIP 1
variables /Application.cfc 143 CSEMAIL 1
variables /Application.cfc 145 SAFETAGS 1
variables /Application.cfc 147 ALWAYSINSTOCK 1
variables /getitemweb.cfm 4 WEBORDER 12
variables /getitemweb.cfm 40 WEBORDER 12
variables /getitemweb.cfm 41 ITEMN 12
variables /getitemweb.cfm 41 getitem 12
variables /getitemweb.cfm 41 cfquery 12
variables /getwebblock.cfm 2 BLOCK 1
variables /getwebblock.cfm 3 getwebblock 1
variables /getwebblock.cfm 3 cfquery 1
variables /makemenu.cfm 3 RETURN_VALUE 36
arguments /makemenu.cfm 3 TEMPLATE 36
arguments /makemenu.cfm 4 TEMPLATE 36
variables /makemenu.cfm 5 TAG_VALUE 3
variables /makemenu.cfm 6 RETURN_VALUE 6
variables /makemenu.cfm 6 TAG_VALUE 3
arguments /makemenu.cfm 8 TEMPLATE 36
variables /makemenu.cfm 9 RETURN_VALUE 6
variables /makemenu.cfm 11 RETURN_VALUE 36
variables /makemenu.cfm 21 MENUTABLE 4
variables /makemenu.cfm 24 getmenu 4
variables /makemenu.cfm 24 cfquery 4
variables /makemenu.cfm 26 menu_type 4
variables /makemenu.cfm 30 MENU_TYPE 4
variables /makemenu.cfm 33 SUBMENU 2
variables /makemenu.cfm 34 PREV_MENU_ORDER 2
variables /makemenu.cfm 35 FIRST 2
variables /makemenu.cfm 36 getmenu 2
variables /makemenu.cfm 37 PREV_MENU_ORDER 36
variables /makemenu.cfm 37 GETMENU 36
variables /makemenu.cfm 38 PREV_MENU_ORDER 8
variables /makemenu.cfm 38 GETMENU 8
variables /makemenu.cfm 39 SUBMENU 8
variables /makemenu.cfm 40 PREV_MENUTEXT 2
variables /makemenu.cfm 40 PREV_URL 2
variables /makemenu.cfm 43 FIRST 6
variables /makemenu.cfm 44 PREV_MENUTEXT 4
variables /makemenu.cfm 44 PREV_URL 4
variables /makemenu.cfm 47 SUBMENU 8
variables /makemenu.cfm 48 FIRST 8
variables /makemenu.cfm 49 GETMENU 8
variables /makemenu.cfm 49 PREV_URL 8
variables /makemenu.cfm 50 PREV_MENUTEXT 8
variables /makemenu.cfm 50 GETMENU 8
variables /makemenu.cfm 52 SUBMENU 28
variables /makemenu.cfm 53 PREV_MENUTEXT 25
variables /makemenu.cfm 53 PREV_URL 25
variables /makemenu.cfm 55 SUBMENU 28
variables /makemenu.cfm 56 PREV_MENUTEXT 3
variables /makemenu.cfm 56 PREV_URL 3
variables /makemenu.cfm 58 SUBMENU 3
variables /makemenu.cfm 60 PREV_URL 28
variables /makemenu.cfm 60 GETMENU 28
variables /makemenu.cfm 61 GETMENU 28
variables /makemenu.cfm 61 PREV_MENUTEXT 28
variables /makemenu.cfm 65 SUBMENU 2
variables /makemenu.cfm 67 PREV_MENUTEXT 1
variables /makemenu.cfm 67 PREV_URL 1
variables /makemenu.cfm 71 PREV_URL 1
variables /makemenu.cfm 71 PREV_MENUTEXT 1
variables /makemenu.cfm 74 SUBMENU 2
variables /makemenu.cfm 82 MENU_TYPE 4
variables /makemenu.cfm 83 FIRST 1
variables /makemenu.cfm 84 getmenu 1
variables /makemenu.cfm 85 FIRST 5
variables /makemenu.cfm 86 GETMENU 10
variables /makemenu.cfm 87 FIRST 5
variables /makemenu.cfm 91 MENU_TYPE 4
variables /makemenu.cfm 92 getmenu 1
variables /makemenu.cfm 93 GETMENU 10
variables /pagebottom.cfm 13 MENU_TYPE 1
variables /pagebottom.cfm 14 MENUTABLE 1
variables /pagetop.cfm 29 MENU_TYPE 1
variables /pagetop.cfm 30 MENUTABLE 1
variables /pagetopandleft.cfm 14 MENU_TYPE 1
variables /pagetopandleft.cfm 15 MENUTABLE 1
variables /pagetopandleft.cfm 17 MENU_TYPE 1
variables /pagetopandleft.cfm 18 MENUTABLE 1
variables /pagetopandleft.cfm 26 BLOCK 1
variables /pagetopandleft.cfm 28 GETWEBBLOCK 1
variables /pagetopstatus.cfm 1 BROWSELINKS 1
variables /pagetopstatus.cfm 3 BROWSEURL 1
variables /showitemdetail.cfm 1 showheader 11
variables /showitemdetail.cfm 2 SHOWHEADER 1
variables /showitemdetail.cfm 4 getitem 12
query /showitemdetail.cfm 23 OUTFORSEASON 12
query /showitemdetail.cfm 23 ACTIVE 12
query /showitemdetail.cfm 24 ORDERED 12
query /showitemdetail.cfm 42 ITEMN 12
query /showitemdetail.cfm 45 WEBDESC 12
query /showitemdetail.cfm 48 WEBSIZE 12
query /showitemdetail.cfm 54 ONHAND 12
query /showitemdetail.cfm 54 WEIGHT 12
query /showitemdetail.cfm 54 RESERVED 12
query /showitemdetail.cfm 54 KIT_AVAILABLE 8
query /showitemdetail.cfm 55 LARGEPACKAGE 12
query /showitemdetail.cfm 55 largepackage 12
query /showitemdetail.cfm 60 PRICE 12
variables /tp300page.cfm 54 ITEMN 1
variables /tp300page.cfm 90 SAFETAGS 1
variables /tp300page.cfm 90 GETITEM 1
variables /tp300page.cfm 112 ITEMN 1
variables /tp300page.cfm 115 ITEMN 1
variables /tp300page.cfm 118 ITEMN 1
variables /tp300page.cfm 119 SHOWHEADER 1
variables /tp300page.cfm 121 ITEMN 1
variables /tp300page.cfm 124 ITEMN 1
variables /tp300page.cfm 127 ITEMN 1
variables /tp300page.cfm 143 ITEMN 1
variables /tp300page.cfm 144 SHOWHEADER 1
variables /tp300page.cfm 147 ITEMN 1
variables /tp300page.cfm 148 SHOWHEADER 1
variables /tp300page.cfm 151 ITEMN 1
variables /tp300page.cfm 152 SHOWHEADER 1
variables /tp300page.cfm 155 ITEMN 1
variables /tp300page.cfm 156 SHOWHEADER 1
variables /tp300page.cfm 159 ITEMN 1
variables /tp300page.cfm 160 SHOWHEADER 1
variables /tp300page.cfm 163 ITEMN 1
variables /tp300page.cfm 164 SHOWHEADER 1
arguments /wilsonlib.cfm 25 STR 13
arguments /wilsonlib.cfm 33 STR 3265
arguments /wilsonlib.cfm 34 STR 3252
arguments /wilsonlib.cfm 41 STR 2
arguments /wilsonlib.cfm 42 STR 2
arguments /wilsonlib.cfm 43 STR 2
arguments /wilsonlib.cfm 47 STR 142
arguments /wilsonlib.cfm 57 STR 36
arguments /wilsonlib.cfm 58 STR 36
arguments /wilsonlib.cfm 62 STR 26
arguments /wilsonlib.cfm 63 STR 13


SQL Queries

getmenu (Datasource=kelcodbpsql, Time=1.24 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,menu_order,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq
getmenu (Datasource=kelcodbpsql, Time=1.58 ms, Records=31) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_menuview
         WHERE site='K' 
         ORDER BY menu_order, orderseq
getmenu (Datasource=kelcodbpsql, Time=0.962 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq
getwebblock (Datasource=kelcodbpsql, Time=0.838 ms, Records=1) in /var/www/html/kelcomaine/getwebblock.cfm
select block_text from web_block where block_key='Kelco Store'
getitem (Datasource=kelcodbpsql, Time=3.88 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP300' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=5.2 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP302-4' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.68 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP302-5' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.65 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP302-6' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.4 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP302-7' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.71 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP302-8' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=5.42 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP303-4' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.66 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price,kit_available
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP303-5' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.8 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price,kit_available
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP303-5.6' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.45 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price,kit_available
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP303-6' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.15 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP303-7' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitem (Datasource=kelcodbpsql, Time=4.52 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:pagetext,zoom,picfile1,line,type,base_price,kit_available
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'TP303-8' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getmenu (Datasource=kelcodbpsql, Time=1.04 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,menu_order,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq


Scope Variables

Application Variables:
applicationname=
INITIALIZED=1
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=/var/www/html/kelcomaine/tp300.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=gzip
http_accept_language=en-US,en;q=0.5
http_connection=close
http_cookie=
http_host=kelcomaine.com
http_referer=
http_user_agent=CCBot/2.0 (https://commoncrawl.org/faq/)
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.0.1
local_host=ec2trixie.kelcomaine.com
path_info=
path_translated=/var/www/html/kelcomaine/tp300.cfm
query_string=
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://kelcomaine.com/tp300.cfm
script_name=/tp300.cfm
server_name=kelcomaine.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=
Cookie Variables:
cfid=e556f351-b4e3-4df4-8aaa-965c118dd035
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=35.175.200.4
Request Variables:
cart_items=0
Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)
Session Variables:
cfid=e556f351-b4e3-4df4-8aaa-965c118dd035
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-08-19 10:39:03'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_e556f351-b4e3-4df4-8aaa-965c118dd035_0
timecreated={ts '2019-08-19 10:39:03'}
urltoken=CFID=e556f351-b4e3-4df4-8aaa-965c118dd035&CFTOKEN=0
Debug Rendering Time: 0 ms