Qty 
Item #: SFH02
Felco Leather Holster Belt Slots
Each
In Stock
0.5 lbs

$15.10

Made in USA from heavy duty good quality grain leather, waxed thread and extra riveting for long lasting use. This holster has Belt Slots.


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 Sep 15, 2019 8:17 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
36.1 ms 9.04 ms 4 /var/www/html/kelcomaine/makemenu.cfm
5.65 ms 5.65 ms 1 /var/www/html/kelcomaine/getitemweb.cfm
2.85 ms 2.85 ms 1 /var/www/html/kelcomaine/addtocartform.cfm
1.48 ms 1.48 ms 1 /var/www/html/kelcomaine/getitemwebstylegroup.cfm
1.2 ms 1.2 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
0.979 ms 0.979 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.66 ms 0.66 ms 1 /var/www/html/kelcomaine/showitemdetail.cfm
0.323 ms 0.323 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.162 ms 0.162 ms 1 /var/www/html/kelcomaine/Application.cfc
0.143 ms 0.143 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.112 ms 0.112 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.11 ms 0.11 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.091 ms 0.091 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.029 ms 0.029 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.029 ms 0.014 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$isMobile
0.007 ms 0.007 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.006 ms 0.006 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.5 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
33.8 ms  APPLICATION EXECUTION TIME
16.2 ms  QUERY EXECUTION TIME
50.5 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
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 18
arguments /wilsonlib.cfm 34 STR 17
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=5.2 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" = 'SFH02' 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.15 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.688 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=2.14 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.21 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.684 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.651 ms, Records=1) in /var/www/html/kelcomaine/showitem.cfm
SELECT
	"item_web"."pagetext" AS pagetext
FROM   "item_web"
WHERE "item_web"."itemn" = 'SFH02'  and "item_web"."sitecode" = 'K'
image (Datasource=kelcodbpsql, Time=3.81 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 = 'SFH02'
getmenu (Datasource=kelcodbpsql, Time=0.657 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=SFH02&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=SFH02&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=69829d14-24be-4c6f-9dd5-1520b6a6faf6
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=35.173.57.202
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=69829d14-24be-4c6f-9dd5-1520b6a6faf6
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-09-15 08:17:27'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_69829d14-24be-4c6f-9dd5-1520b6a6faf6_0
timecreated={ts '2019-09-15 08:17:27'}
urltoken=CFID=69829d14-24be-4c6f-9dd5-1520b6a6faf6&CFTOKEN=0
URL Variables:
item=SFH02
type=P
Debug Rendering Time: 0 ms