We are sorry, it was not possible to find any products matching your search request.

Here are some hints:

1. Double check spelling.
2. Try both singular and plural forms. For example, "knife" if "knives" produces incomplete results.
3. If the only difference between singular and plural is the letters "s" or "es" then always use the singular form. For example, always use "ring" instead of "rings".
4. Use fewer words or letters to produce more complete results. For example "velvet" instead of "velvet ribbon" may produce a more complete list as might "clamp" instead of "clamp-on".
5. Always use a minumum of 3 letters in a search.
6. When searching use no punctuation such as ",?,. and no boolean terms such as "AND", "OR", etc.


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /searchresults.cfm (/var/www/html/kelcomaine/searchresults.cfm)
Time Stamp Aug 19, 2019 1:27 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
13.4 ms 13.4 ms 1 /var/www/html/kelcomaine/getsearchresults.cfm
38.1 ms 9.54 ms 4 /var/www/html/kelcomaine/makemenu.cfm
1.23 ms 1.23 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
1.19 ms 1.19 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
0.325 ms 0.325 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.164 ms 0.164 ms 1 /var/www/html/kelcomaine/Application.cfc
0.139 ms 0.139 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.111 ms 0.111 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.11 ms 0.11 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.088 ms 0.088 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.032 ms 0.032 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.023 ms 0.023 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.021 ms 0.021 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.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.004 ms 0.004 ms 1 /var/www/html/kelcomaine/searchcheckparam.cfm
0.003 ms 0.003 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.001 ms 0.001 ms 1 /var/www/html/kelcomaine/errorhints.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/searchresults.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.814 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
34.7 ms  APPLICATION EXECUTION TIME
20.3 ms  QUERY EXECUTION TIME
55.9 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
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 /getsearchresults.cfm 5 SEARCH_STRING 1
variables /getsearchresults.cfm 6 SEARCH_STRING 2
variables /getsearchresults.cfm 7 SEARCH_STRING 2
variables /getsearchresults.cfm 8 SEARCH_STRING 2
variables /getsearchresults.cfm 9 SEARCH_STRING 2
variables /getsearchresults.cfm 10 SEARCH_STRING 2
variables /getsearchresults.cfm 11 SEARCH_STRING 2
variables /getsearchresults.cfm 12 SEARCH_STRING 2
variables /getsearchresults.cfm 13 SEARCH_STRING 2
variables /getsearchresults.cfm 14 SEARCH_STRING 2
variables /getsearchresults.cfm 15 SEARCH_STRING 2
variables /getsearchresults.cfm 16 SEARCH_STRING 2
variables /getsearchresults.cfm 17 SEARCH_STRING 2
variables /getsearchresults.cfm 18 SEARCH_STRING 2
variables /getsearchresults.cfm 19 SEARCH_STRING 2
variables /getsearchresults.cfm 53 SEARCH_STRING 1
variables /getsearchresults.cfm 78 SEARCH_STRING 1
variables /getsearchresults.cfm 85 WEBORDER 1
variables /getsearchresults.cfm 87 SEARCH_STRING 2
variables /getsearchresults.cfm 96 cfquery 1
variables /getsearchresults.cfm 96 catsearch 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 /searchresults.cfm 4 getwebclass 1
variables /searchresults.cfm 4 cfquery 1
variables /searchresults.cfm 12 GETWEBCLASS 1
variables /searchresults.cfm 12 TITLE 1
variables /searchresults.cfm 13 TITLE 1
variables /searchresults.cfm 14 TITLE 1
variables /searchresults.cfm 26 TITLE 1
variables /searchresults.cfm 30 SHOWTHUMBS 1
variables /searchresults.cfm 35 QUERY_STRING 1
variables /searchresults.cfm 36 QUERY_STRING 2
variables /searchresults.cfm 37 QUERY_STRING 2
variables /searchresults.cfm 50 WEBORDER 1
variables /searchresults.cfm 71 CATSEARCH 1
arguments /wilsonlib.cfm 3 INPUTSTR 1
variables /wilsonlib.cfm 3 STR 1
variables /wilsonlib.cfm 5 STR 1
variables /wilsonlib.cfm 8 STR 1
variables /wilsonlib.cfm 11 STR 1
variables /wilsonlib.cfm 14 STR 1
variables /wilsonlib.cfm 17 STR 1
arguments /wilsonlib.cfm 25 STR 1
arguments /wilsonlib.cfm 33 STR 18
arguments /wilsonlib.cfm 34 STR 17
arguments /wilsonlib.cfm 62 STR 2
arguments /wilsonlib.cfm 63 STR 1


SQL Queries

getwebclass (Datasource=kelcodbpsql, Time=1.11 ms, Records=0) in /var/www/html/kelcomaine/searchresults.cfm
the following colum(s) are never read within the request:classpagetext
SELECT classpagetext, classtitle FROM web_class WHERE "webclass" = 'any';
getmenu (Datasource=kelcodbpsql, Time=0.909 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=3.63 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.13 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.943 ms, Records=1) in /var/www/html/kelcomaine/getwebblock.cfm
select block_text from web_block where block_key='Kelco Store'
catsearch (Datasource=kelcodbpsql, Time=11.6 ms, Records=0) in /var/www/html/kelcomaine/getsearchresults.cfm
the following colum(s) are never read within the request:picfile2,backordermsg,rank,price,webdesc,outforseason,weight,onhand,picfile1,itemn,line,descbold,ordered,stylecode,websize,thumb,typeorder,type,active,kit_available,reserved,largepackage
SELECT
            "web_stylegroup"."stylecode" AS itemn,
            "web_stylegroup"."styledesc" AS webdesc,
            "web_stylegroup"."styledescbold" AS descbold,
            "web_stylegroup"."stylesize" AS websize,
            ' ' AS picfile1,
            ' ' AS picfile2,
            ' ' AS thumb,
            ' ' AS stylecode,
            0.00 AS price,
            0.00 AS weight,
            0 AS onhand,
            0 AS reserved,
            'Y' AS active,
            "web_stylegroup"."feature1" AS outforseason,
            'N' AS largepackage,
            0 AS line,
            0 AS ordered,
            ' ' AS backordermsg,
            'G' AS type,
            0 AS typeorder,
             0 AS kit_available,
            1 AS rank
      FROM web_stylegroup
      WHERE "web_stylegroup"."stylecode" = upper('Havahartbrand')
      GROUP BY itemn, webdesc, descbold, websize, picfile1, picfile2, outforseason
           UNION
 	SELECT
            "item_web"."itemn" AS itemn,
            "item_web"."webdesc" AS webdesc,
            ' ' AS descbold,
            "item_web"."websize" AS websize,
            "item_web"."picfile1" AS picfile1,
            "item_web"."picfile2" AS picfile2,
            COALESCE("item_webimages"."thumb",(SELECT thumb FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS thumb,
            ' ' AS stylecode,
            "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_web"."backordermsg" AS backordermsg,
            "item"."type" AS type,
            '1' AS typeorder,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available,
	ts_rank(textsearchable_index_col, to_tsquery('english', 'Havahartbrand'),1) as rank
      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"."sitecode" = 'K' and "item_web"."web_class" <> 'ZZZ' and "item"."discontinued" = 'N' AND "item"."not_for_website" = 'N' AND
(textsearchable_index_col @@ to_tsquery('english','Havahartbrand') OR "item"."itemn" ILIKE 'Havahartbrand%')
     GROUP BY item_web.itemn, webdesc, descbold,  websize, picfile1, picfile2, thumb, stylecode, price, 
	weight, item.onhand, type, item.reserved, active, outforseason, 
	largepackage, backordermsg, line, ordered,textsearchable_index_col

     ORDER BY typeorder,webdesc ASC;
getmenu (Datasource=kelcodbpsql, Time=0.99 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/searchresults.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/searchresults.cfm
query_string=SearchText=Havahartbrand&SearchClass=any&Go=Go
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://www.kelcomaine.com/searchresults.cfm?SearchText=Havahartbrand&SearchClass=any&Go=Go
script_name=/searchresults.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=b47ed45e-f5be-4331-8908-6785a3e81da8
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=34.238.189.171
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=b47ed45e-f5be-4331-8908-6785a3e81da8
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-08-19 13:27:20'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_b47ed45e-f5be-4331-8908-6785a3e81da8_0
timecreated={ts '2019-08-19 13:27:20'}
urltoken=CFID=b47ed45e-f5be-4331-8908-6785a3e81da8&CFTOKEN=0
URL Variables:
Go=Go
SearchClass=any
SearchText=Havahartbrand
Debug Rendering Time: 0 ms