Qty 
Item #: PFS10Y-100
Flag Stakes-Yellow
Package of 100
In Stock
3 lbs

$12.60

21" Flag Stakes measures 2-1/2" x 3-1/2" with a 16 gauge wire. Comes in packages of 100 or 1000 in the following colors: Blue, Yellow, Orange Glo, & Pink Glo. These are used as a marker by farmers to mark your crops of trees, blueberries, etc.


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /showitem.cfm (/var/www/html/kelcomaine/showitem.cfm)
Time Stamp Aug 19, 2019 10:33 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
42.1 ms 10.5 ms 4 /var/www/html/kelcomaine/makemenu.cfm
3.26 ms 3.26 ms 1 /var/www/html/kelcomaine/addtocartform.cfm
3.2 ms 3.2 ms 1 /var/www/html/kelcomaine/getitemweb.cfm
1.63 ms 1.63 ms 1 /var/www/html/kelcomaine/getitemwebstylegroup.cfm
1.21 ms 1.21 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
1.14 ms 1.14 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.681 ms 0.681 ms 1 /var/www/html/kelcomaine/showitemdetail.cfm
0.337 ms 0.337 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.185 ms 0.185 ms 1 /var/www/html/kelcomaine/Application.cfc
0.132 ms 0.132 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.119 ms 0.119 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.118 ms 0.118 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.089 ms 0.089 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.03 ms 0.03 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.026 ms 0.026 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.022 ms 0.022 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentContains
0.016 ms 0.016 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.027 ms 0.013 ms 2 /var/www/html/kelcomaine/WEB-INF/lucee/context/Component.cfc
0.01 ms 0.01 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.008 ms 0.008 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$init
0.005 ms 0.005 ms 1 /var/www/html/kelcomaine/addtoprocess.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/showitemcheckparam.cfm
0.001 ms 0.001 ms 1 /var/www/html/kelcomaine/addtocartbutton.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/showitem.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.58 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
43 ms  APPLICATION EXECUTION TIME
11.4 ms  QUERY EXECUTION TIME
55 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /addtocartform.cfm 1 noanchor 1
variables /addtocartform.cfm 5 NOANCHOR 1
cgi /addtocartform.cfm 8 QUERY_STRING 1
query /addtocartform.cfm 8 ITEMN 1
query /addtocartform.cfm 12 ONHAND 1
query /addtocartform.cfm 12 RESERVED 1
query /addtocartform.cfm 28 BACKORDERMSG 1
query /addtocartform.cfm 29 ITEMN 1
query /addtocartform.cfm 30 ITEMN 1
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 1
variables /getitemweb.cfm 40 WEBORDER 1
variables /getitemweb.cfm 41 ITEMN 1
variables /getitemweb.cfm 41 getitem 1
variables /getitemweb.cfm 41 cfquery 1
variables /getitemwebstylegroup.cfm 4 WEBORDER 1
variables /getitemwebstylegroup.cfm 23 STYLECODE 1
variables /getitemwebstylegroup.cfm 24 getitemwebstylegroup 1
variables /getitemwebstylegroup.cfm 24 cfquery 1
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 /showitem.cfm 2 ITEMN 1
variables /showitem.cfm 7 itemn 1
variables /showitem.cfm 8 ITEMN 1
variables /showitem.cfm 8 ITEM4TEXT 1
variables /showitem.cfm 14 STYLECODE 1
variables /showitem.cfm 18 GETITEMWEBSTYLEGROUP 1
variables /showitem.cfm 27 itemn 1
variables /showitem.cfm 28 GETITEM 1
variables /showitem.cfm 69 GETITEM 1
variables /showitem.cfm 69 ST 1
variables /showitem.cfm 70 ST 1
variables /showitem.cfm 100 ITEM4TEXT 1
variables /showitem.cfm 101 cfquery 1
variables /showitem.cfm 101 getitemtext 1
variables /showitem.cfm 104 GETITEM 1
variables /showitem.cfm 111 NOANCHOR 1
variables /showitem.cfm 118 IMAGEITEMN 1
variables /showitem.cfm 119 getitem 1
query /showitem.cfm 120 ITEMN 2
variables /showitem.cfm 120 IMAGESRC 1
variables /showitem.cfm 121 IMAGEITEMN 1
query /showitem.cfm 121 ITEMN 1
query /showitem.cfm 122 PICFILE1 1
query /showitem.cfm 123 PICFILE1 1
variables /showitem.cfm 123 IMAGESRC 1
variables /showitem.cfm 124 IMAGEITEMN 1
variables /showitem.cfm 124 IMAGESRC 1
variables /showitem.cfm 126 GETITEMWEBSTYLEGROUP 1
variables /showitem.cfm 129 LARGEPIC 1
variables /showitem.cfm 130 SAMPLEPIC 1
variables /showitem.cfm 131 IMAGESRC 1
variables /showitem.cfm 132 IMAGESRC 1
variables /showitem.cfm 138 GETITEMWEBSTYLEGROUP 1
query /showitem.cfm 181 ZOOM 1
variables /showitem.cfm 183 LARGEPIC 1
query /showitem.cfm 194 ITEMN 1
variables /showitem.cfm 195 cfquery 1
variables /showitem.cfm 195 image 1
variables /showitem.cfm 196 IMAGE 1
variables /showitem.cfm 199 IMAGESRC 1
variables /showitem.cfm 201 LARGEPIC 1
variables /showitem.cfm 203 IMAGE 1
variables /showitem.cfm 209 GETITEMWEBSTYLEGROUP 1
variables /showitem.cfm 212 GETITEMTEXT 1
variables /showitemdetail.cfm 2 SHOWHEADER 1
variables /showitemdetail.cfm 4 getitem 1
query /showitemdetail.cfm 23 OUTFORSEASON 1
query /showitemdetail.cfm 23 ACTIVE 1
query /showitemdetail.cfm 24 ORDERED 1
query /showitemdetail.cfm 42 ITEMN 1
query /showitemdetail.cfm 45 WEBDESC 1
query /showitemdetail.cfm 48 WEBSIZE 1
query /showitemdetail.cfm 54 ONHAND 1
query /showitemdetail.cfm 54 WEIGHT 1
query /showitemdetail.cfm 54 RESERVED 1
query /showitemdetail.cfm 55 LARGEPACKAGE 1
query /showitemdetail.cfm 55 largepackage 1
query /showitemdetail.cfm 60 PRICE 1
arguments /wilsonlib.cfm 25 STR 1
arguments /wilsonlib.cfm 33 STR 23
arguments /wilsonlib.cfm 34 STR 22
arguments /wilsonlib.cfm 41 STR 1
arguments /wilsonlib.cfm 42 STR 1
arguments /wilsonlib.cfm 43 STR 1
arguments /wilsonlib.cfm 57 STR 2
arguments /wilsonlib.cfm 58 STR 2
arguments /wilsonlib.cfm 62 STR 2
arguments /wilsonlib.cfm 63 STR 1


SQL Queries

getitem (Datasource=kelcodbpsql, Time=2.75 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request: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" = 'PFS10Y-100' 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;
getitemwebstylegroup (Datasource=kelcodbpsql, Time=1.25 ms, Records=0) in /var/www/html/kelcomaine/getitemwebstylegroup.cfm
the following colum(s) are never read within the request:stylegroupitem,pagetext,feature1,feature1value,styledesc,defaultitem,stylecode
SELECT
     "web_stylegroup"."stylecode" AS stylecode,
     "web_stylegroup"."styledesc" AS styledesc,
     "web_stylegroup"."pagetext" AS pagetext,
     "web_stylegroup"."feature1" AS feature1,
     "web_stylegroup"."defaultitem" AS defaultitem,
     "item_web"."feature1value" AS feature1value,
     "item_web"."itemn" AS stylegroupitem
   FROM "web_stylegroup","item_web","item" WHERE "web_stylegroup"."stylecode" = '' and "item_web"."stylecode" = "web_stylegroup"."stylecode" and
     item.itemn = item_web.itemn and item.active = 'Y' and item.discontinued = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
   ORDER BY feature1value
getmenu (Datasource=kelcodbpsql, Time=0.896 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.61 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=1.08 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.848 ms, Records=1) in /var/www/html/kelcomaine/getwebblock.cfm
select block_text from web_block where block_key='Kelco Store'
getitemtext (Datasource=kelcodbpsql, Time=0.856 ms, Records=1) in /var/www/html/kelcomaine/showitem.cfm
SELECT
	"item_web"."pagetext" AS pagetext
FROM   "item_web"
WHERE "item_web"."itemn" = 'PFS10Y-100'  and "item_web"."sitecode" = 'K'
image (Datasource=kelcodbpsql, Time=1.19 ms, Records=0) in /var/www/html/kelcomaine/showitem.cfm
SELECT COALESCE("item_webimages"."image",(SELECT image FROM item_webimages AS iwi WHERE iwi.itemn = item_webimages.sameasitemn)) AS image, COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = item_webimages.sameasitemn)) AS zoom FROM item_webimages WHERE itemn = 'PFS10Y-100'
getmenu (Datasource=kelcodbpsql, Time=0.892 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/showitem.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/showitem.cfm
query_string=item=PFS10Y-100&type=P
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://kelcomaine.com/showitem.cfm?item=PFS10Y-100&type=P
script_name=/showitem.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=fc317185-80c7-4973-b465-2df0249e0826
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=fc317185-80c7-4973-b465-2df0249e0826
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-08-19 10:33:28'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_fc317185-80c7-4973-b465-2df0249e0826_0
timecreated={ts '2019-08-19 10:33:28'}
urltoken=CFID=fc317185-80c7-4973-b465-2df0249e0826&CFTOKEN=0
URL Variables:
item=PFS10Y-100
type=P
Debug Rendering Time: 0 ms