Qty 
Item #: PFNL01PDY
Yellow Dot Long # Flagging(1)
Package of 1
In Stock
0.4 lbs

$3.55

Eliminate counting mistakes and aggravation. These tags are 19" long and come 200 per roll. Sequentially numbered per roll, per box, per series of boxes of any one color.



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 Oct 22, 2019 1:59 PM
Time Zone UTC
Locale English (us)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 127.0.0.1
Host Name www.kelcomaine.com
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
288 ms 288 ms 1 /var/www/html/kelcomaine/showitem.cfm
42 ms 10.5 ms 4 /var/www/html/kelcomaine/makemenu.cfm
7.87 ms 7.87 ms 1 /var/www/html/kelcomaine/getitemweb.cfm
4.52 ms 4.52 ms 1 /var/www/html/kelcomaine/addtocartform.cfm
1.81 ms 1.81 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
1.55 ms 1.55 ms 1 /var/www/html/kelcomaine/getitemwebstylegroup.cfm
1.02 ms 1.02 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.826 ms 0.826 ms 1 /var/www/html/kelcomaine/showitemdetail.cfm
0.416 ms 0.416 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.15 ms 0.15 ms 1 /var/www/html/kelcomaine/Application.cfc
0.137 ms 0.137 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.134 ms 0.134 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.128 ms 0.128 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.097 ms 0.097 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.07 ms 0.07 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.05 ms 0.05 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentContains
0.042 ms 0.042 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.024 ms 0.024 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.032 ms 0.016 ms 2 /var/www/html/kelcomaine/WEB-INF/lucee/context/Component.cfc
0.011 ms 0.011 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$init
0.008 ms 0.008 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.006 ms 0.006 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/showitemcheckparam.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/addtoprocess.cfm
0.002 ms 0.002 ms 1 /var/www/html/kelcomaine/addtocartbutton.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.683 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2.79 ms  APPLICATION EXECUTION TIME
346 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 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
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
query /showitem.cfm 182 ITEMN 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
query /showitem.cfm 197 ITEMN 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 22
arguments /wilsonlib.cfm 34 STR 21
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=7.32 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" = 'PFNL01PDY' 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.14 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.679 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.41 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.983 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.662 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.661 ms, Records=1) in /var/www/html/kelcomaine/showitem.cfm
SELECT
	"item_web"."pagetext" AS pagetext
FROM   "item_web"
WHERE "item_web"."itemn" = 'PFNL01PDY'  and "item_web"."sitecode" = 'K'
image (Datasource=kelcodbpsql, Time=332 ms, Records=1) 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 = 'PFNL01PDY'
getmenu (Datasource=kelcodbpsql, Time=1.06 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=www.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=PFNL01PDY&type=P
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://www.kelcomaine.com/showitem.cfm?item=PFNL01PDY&type=P
script_name=/showitem.cfm
server_name=www.kelcomaine.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=
Cookie Variables:
cfid=3cb1b57c-1ae9-4db5-ac49-ffbcd3ce236a
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=34.204.191.31
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=3cb1b57c-1ae9-4db5-ac49-ffbcd3ce236a
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-10-22 13:59:00'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_3cb1b57c-1ae9-4db5-ac49-ffbcd3ce236a_0
timecreated={ts '2019-10-22 13:59:00'}
urltoken=CFID=3cb1b57c-1ae9-4db5-ac49-ffbcd3ce236a&CFTOKEN=0
URL Variables:
item=PFNL01PDY
type=P
Debug Rendering Time: 0 ms