Qty 
Item #: PFNL01P
Pink Long # Flagging(1)
Package of 1
In Stock
0.4 lbs

$3.40

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:55 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
8.6 ms 8.6 ms 1 /var/www/html/kelcomaine/getitemweb.cfm
34 ms 8.5 ms 4 /var/www/html/kelcomaine/makemenu.cfm
2.96 ms 2.96 ms 1 /var/www/html/kelcomaine/addtocartform.cfm
1.37 ms 1.37 ms 1 /var/www/html/kelcomaine/getitemwebstylegroup.cfm
1.15 ms 1.15 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
0.878 ms 0.878 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.66 ms 0.66 ms 1 /var/www/html/kelcomaine/showitemdetail.cfm
0.314 ms 0.314 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.128 ms 0.128 ms 1 /var/www/html/kelcomaine/Application.cfc
0.123 ms 0.123 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.109 ms 0.109 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.109 ms 0.109 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.076 ms 0.076 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.036 ms 0.036 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.025 ms 0.025 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.021 ms 0.021 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentContains
0.015 ms 0.015 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.02 ms 0.01 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/wilsonlib.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/addtoprocess.cfm
0.003 ms 0.003 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.498 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
29.1 ms  APPLICATION EXECUTION TIME
21.4 ms  QUERY EXECUTION TIME
51.1 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 20
arguments /wilsonlib.cfm 34 STR 19
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=8.14 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" = 'PFNL01P' 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.05 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.686 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.21 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.743 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.594 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.61 ms, Records=1) in /var/www/html/kelcomaine/showitem.cfm
SELECT
	"item_web"."pagetext" AS pagetext
FROM   "item_web"
WHERE "item_web"."itemn" = 'PFNL01P'  and "item_web"."sitecode" = 'K'
image (Datasource=kelcodbpsql, Time=7.8 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 = 'PFNL01P'
getmenu (Datasource=kelcodbpsql, Time=0.637 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=PFNL01P&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=PFNL01P&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=82ed1a45-fe03-443c-8b81-eaf8bb2b2cfb
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=82ed1a45-fe03-443c-8b81-eaf8bb2b2cfb
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-10-22 13:55:37'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_82ed1a45-fe03-443c-8b81-eaf8bb2b2cfb_0
timecreated={ts '2019-10-22 13:55:37'}
urltoken=CFID=82ed1a45-fe03-443c-8b81-eaf8bb2b2cfb&CFTOKEN=0
URL Variables:
item=PFNL01P
type=P
Debug Rendering Time: 0 ms