Qty 
Item #: RB40R-60
7 Loop Bow w/Gold Cord
Package 60
In Stock
22 lbs.
$126.30

Qty 
Item #: RB40BR-24
Brick Red 7 Loop Bow
Package of 24
In Stock
10 lbs.
$52.25

Qty 
Item #: RBH40VA1-SBR
Brick Red Standard Velvet Bows
Package of 24
Out of stock
13 lbs.
$62.40

Qty 
Item #: RB40B-24
Burgundy 7 Loop Bows
Package of 24
In Stock
10 lbs.
$52.25

Qty 
Item #: RB40BGB-60
Burgundy Gold Back 7 Loop Bows
Package of 60
In Stock
22 lbs.
$138.50

Qty 
Item #: RB40BGB-24
Burgundy Gold Back 7 Loop Bows
Package of 24
In Stock
10 lbs.
$56.90

Qty 
Item #: RB40TMB-24
Burgundy/Hunter Green 7 Loop Bows
Package of 24
In Stock
10 lbs.
$52.25

Qty 
Item #: RBH40VA1-SBU
Burgundy Standard Velvet Bows
Pkg. of 24
In Stock
13 lbs.
$62.40

Qty 
Item #: RBH40VBD
Burgundy Velvet Bow with Gold Wired Edge
Pkg. of 12
In Stock
6 lbs.
$50.60

Qty 
Item #: RBH40VGB
Burgundy with Gold Vinyl Back
Pkg. of 12
In Stock
6 lbs.
$42.20

Qty 
Item #: RBH40VR3
Deluxe Red Velvet Bow
Pkg. of 6
In Stock
6 lbs.
$33.70

Qty 
Item #: RBH40VA1-SFB
French Blue Standard Velvet Bows
Pkg. of 24
In Stock
13 lbs.
$62.40

Qty 
Item #: RBH40VR3-W
HB DELUXE RED VELVET BOW-WIRED EDGE
BOX OF 6
In Stock
6 lbs.
$42.20

Qty 
Item #: RBH40VGIV
Ivory with Gold Vinyl Back
Pkg. of 12
In Stock
6 lbs.
$42.20

Qty 
Item #: RBH40MPAST
Metallic Plaid Assortment
Pkg. of 12
In Stock
6 lbs.
$37.95

Qty 
Item #: RB40TMC-24
Multi Color 7 Loop Bows
Package of 24
In Stock
10 lbs.
$52.25

Qty 
Item #: RBH40MPAST-SMC
Multi -Color Metallic Plaid Bows
Pkg. of 24
In Stock
10 lbs.
$75.80

Qty 
Item #: RB40B-60
**NEW** Seven Loop Deluxe Bow-Burgundy
9" wide x 13" long tails -- 60 bows
In Stock
22 lbs.
$126.30

Qty 
Item #: RB40R-24
Red 7 Loop Deluxe Bow
Package of 24
In Stock
10 lbs.
$52.25

Qty 
Item #: RBH40VGAST
Red, Burgundy & Ivory w/ Gold Vinyl Back
Pkg. of 12
In Stock
6 lbs.
$42.20

Qty 
Item #: RBH40IC1-SR
Red Cracked Ice Embossed Mylar Bows
Pkg. of 24
In Stock
10 lbs.
$84.15

Qty 
Item #: RB40RGB-24
Red Gold Back 7 Loop Bows
Package of 24
In Stock
10 lbs.
$56.90

Qty 
Item #: RBH40IC1-SRG
Red/Gold Stripe Cracked Ice Mylar Bows
Pkg. of 24
In Stock
10 lbs.
$84.15

Qty 
Item #: RBH40MPAST-SRG
Red/Green Metallic Plaid Bows
Pkg. og 24
In Stock
10 lbs.
$75.80

Qty 
Item #: RB40TRG-60
Red/Green Plaid
Package of 60
In Stock
22 lbs.
$126.30

Qty 
Item #: RB40TRG-24
Red/Green Plaid 7 Loop Bows
Package of 24
In Stock
10 lbs.
$52.25

Qty 
Item #: RBH40VRD
Red Velvet Bow with Gold Wired Edge
Pkg. of 12
In Stock
6 lbs.
$50.60

Qty 
Item #: RBH40VG1
Red Velvet with Gold Vinly Back Bows
Pkg. of 12
In Stock
6 lbs.
$42.20

Qty 
Item #: RB40A-60
Seven Loop Deluxe Bow
Package of 60 Assortment
In Stock
22 lbs.
$138.50

Qty 
Item #: RB40BR-60
Seven Loop Deluxe Bow
Pkg of 60
In Stock
22 lbs.
$126.30

Qty 
Item #: RB40TMC-60
Seven Loop Deluxe Bow
Multi Color Plaid Package of 60
In Stock
22 lbs.
$126.30

Qty 
Item #: RB40WB-60
Seven Loop Deluxe Bow
Box of 60 Williamsburg Blue
In Stock
22 lbs.
$126.30

Qty 
Item #: RBH40VR1-36
Standard Red Velvet Bow
Package of 36
In Stock
22 lbs.
$90.95

Qty 
Item #: RBH40VA1
Standard Velvet Color Assortment
Pkg. of 12
In Stock
6 lbs.
$32.15

Qty 
Item #: RBH10VR1
Super Large Red Velvet Bow
Pkg. of 4
In Stock
10 lbs.
$39.40

Qty 
Item #: RBH10VR1-W
Super Lg. Red Velvet w/ Gold Wired Edge
Pkg. of 4
In Stock
10 lbs.
$43.90

Qty 
Item #: RB40WB-24
Williamsburg Blue 7 Loop Bow
Package of 24
In Stock
10 lbs.
$52.25


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 12:20 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
195 ms 195 ms 1 /var/www/html/kelcomaine/searchresults.cfm
36.2 ms 9.05 ms 4 /var/www/html/kelcomaine/makemenu.cfm
7.85 ms 7.85 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
6.44 ms 6.44 ms 1 /var/www/html/kelcomaine/getitemsbyclass.cfm
135 ms 3.65 ms 37 /var/www/html/kelcomaine/addtocartform.cfm
2.98 ms 1.49 ms 2 /var/www/html/kelcomaine/getitemwebbrowse.cfm
1.2 ms 1.2 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
1.07 ms 1.07 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.332 ms 0.332 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.165 ms 0.165 ms 1 /var/www/html/kelcomaine/Application.cfc
0.138 ms 0.138 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.114 ms 0.114 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.096 ms 0.096 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.03 ms 0.03 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.024 ms 0.024 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.028 ms 0.014 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.007 ms 0.007 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.004 ms 0.004 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.151 ms 0.004 ms 36 /var/www/html/kelcomaine/addtocartbutton.cfm
0.001 ms 0.001 ms 1 /var/www/html/kelcomaine/addbackorderbutton.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.915 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
372 ms  APPLICATION EXECUTION TIME
15 ms  QUERY EXECUTION TIME
388 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /addtocartform.cfm 1 noanchor 36
variables /addtocartform.cfm 2 NOANCHOR 1
variables /addtocartform.cfm 5 NOANCHOR 37
query /addtocartform.cfm 6 ITEMN 37
variables /addtocartform.cfm 8 QUERY_STRING 37
query /addtocartform.cfm 8 ITEMN 37
query /addtocartform.cfm 12 ONHAND 37
query /addtocartform.cfm 12 RESERVED 37
variables /addtocartform.cfm 12 ALWAYSINSTOCK 1
query /addtocartform.cfm 12 ITEMN 1
query /addtocartform.cfm 12 KIT_AVAILABLE 1
query /addtocartform.cfm 28 BACKORDERMSG 37
query /addtocartform.cfm 29 ITEMN 37
query /addtocartform.cfm 30 ITEMN 37
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 /getitemsbyclass.cfm 63 WEBORDER 1
variables /getitemsbyclass.cfm 67 cfquery 1
variables /getitemsbyclass.cfm 67 catsearch 1
variables /getitemwebbrowse.cfm 1 webclass 2
variables /getitemwebbrowse.cfm 9 WEBCLASS 2
variables /getitemwebbrowse.cfm 10 cfquery 2
variables /getitemwebbrowse.cfm 10 getitemwebbrowse 2
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 /pagetopstatus.cfm 10 WEBCLASS 1
variables /pagetopstatus.cfm 12 GETITEMWEBBROWSE 2
variables /pagetopstatus.cfm 12 SAFETAGS 1
variables /pagetopstatus.cfm 12 BROWSELINKS 1
variables /pagetopstatus.cfm 13 GETITEMWEBBROWSE 1
variables /pagetopstatus.cfm 13 SAFETAGS 1
variables /pagetopstatus.cfm 13 BROWSELINKS 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 17 WEBCLASS 1
variables /searchresults.cfm 19 GETITEMWEBBROWSE 1
variables /searchresults.cfm 20 GETITEMWEBBROWSE 2
variables /searchresults.cfm 20 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
variables /searchresults.cfm 73 BROWSELINKS 1
variables /searchresults.cfm 81 GETWEBCLASS 1
variables /searchresults.cfm 83 catsearch 1
query /searchresults.cfm 84 STYLECODE 37
query /searchresults.cfm 86 ITEMN 74
variables /searchresults.cfm 86 THUMBPATH 37
query /searchresults.cfm 87 PICFILE1 37
query /searchresults.cfm 89 PICFILE1 19
variables /searchresults.cfm 89 THUMBPATH 19
variables /searchresults.cfm 90 THUMBPATH 19
variables /searchresults.cfm 91 THUMBPATH 57
variables /searchresults.cfm 93 THUMBPATH 38
variables /searchresults.cfm 95 THUMBPATH 37
variables /searchresults.cfm 96 THUMBPATH 37
query /searchresults.cfm 99 ITEMN 74
variables /searchresults.cfm 99 THUMBPATH2 37
query /searchresults.cfm 100 PICFILE2 37
variables /searchresults.cfm 108 THUMBPATH2 37
variables /searchresults.cfm 109 THUMBPATH2 37
query /searchresults.cfm 119 OUTFORSEASON 37
query /searchresults.cfm 119 ACTIVE 37
query /searchresults.cfm 121 STYLECODE 37
query /searchresults.cfm 121 TYPE 37
query /searchresults.cfm 138 ORDERED 37
query /searchresults.cfm 173 ITEMN 37
query /searchresults.cfm 178 TYPE 37
query /searchresults.cfm 182 TYPE 37
query /searchresults.cfm 182 ITEMN 37
query /searchresults.cfm 184 WEBDESC 37
query /searchresults.cfm 189 TYPE 37
query /searchresults.cfm 192 ITEMN 37
query /searchresults.cfm 192 TYPE 37
query /searchresults.cfm 194 WEBSIZE 37
query /searchresults.cfm 209 TYPE 37
query /searchresults.cfm 212 TYPE 37
query /searchresults.cfm 212 ITEMN 37
query /searchresults.cfm 214 THUMB 37
query /searchresults.cfm 214 ITEMN 22
variables /searchresults.cfm 216 THUMBPATH 15
query /searchresults.cfm 221 TYPE 37
query /searchresults.cfm 224 TYPE 37
query /searchresults.cfm 224 ITEMN 37
variables /searchresults.cfm 226 THUMBPATH2 37
query /searchresults.cfm 230 TYPE 37
query /searchresults.cfm 230 STYLECODE 37
query /searchresults.cfm 231 RESERVED 37
query /searchresults.cfm 231 ONHAND 37
query /searchresults.cfm 231 KIT_AVAILABLE 1
query /searchresults.cfm 237 WEIGHT 37
query /searchresults.cfm 238 LARGEPACKAGE 37
query /searchresults.cfm 238 largepackage 37
query /searchresults.cfm 242 PRICE 37
query /searchresults.cfm 243 PRICE 37
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 115
arguments /wilsonlib.cfm 33 STR 2898
arguments /wilsonlib.cfm 34 STR 2783
arguments /wilsonlib.cfm 41 STR 41
arguments /wilsonlib.cfm 42 STR 4
arguments /wilsonlib.cfm 43 STR 4
arguments /wilsonlib.cfm 57 STR 12
arguments /wilsonlib.cfm 58 STR 12
arguments /wilsonlib.cfm 62 STR 230
arguments /wilsonlib.cfm 63 STR 115


SQL Queries

getwebclass (Datasource=kelcodbpsql, Time=1.14 ms, Records=1) in /var/www/html/kelcomaine/searchresults.cfm
SELECT classpagetext, classtitle FROM web_class WHERE "webclass" = 'BHA';
getitemwebbrowse (Datasource=kelcodbpsql, Time=1.21 ms, Records=3) in /var/www/html/kelcomaine/getitemwebbrowse.cfm
the following colum(s) are never read within the request:url,picfile,thumb
SELECT
     webdescription,
     pagetitle,
     picfile,
     thumb,
     url
   FROM web_itempage LEFT OUTER JOIN item_webimages ON web_itempage.picfile = item_webimages.itemn, web_pagemaster WHERE webclass = 'BHA' and web_itempage.pageid = web_itempage.pageid and web_pagemaster.site='K';
getmenu (Datasource=kelcodbpsql, Time=0.894 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
getitemwebbrowse (Datasource=kelcodbpsql, Time=1.07 ms, Records=3) in /var/www/html/kelcomaine/getitemwebbrowse.cfm
the following colum(s) are never read within the request:picfile,thumb
SELECT
     webdescription,
     pagetitle,
     picfile,
     thumb,
     url
   FROM web_itempage LEFT OUTER JOIN item_webimages ON web_itempage.picfile = item_webimages.itemn, web_pagemaster WHERE webclass = 'BHA' and web_itempage.pageid = web_itempage.pageid and web_pagemaster.site='K';
getmenu (Datasource=kelcodbpsql, Time=1.52 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.07 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.78 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=6.12 ms, Records=37) in /var/www/html/kelcomaine/getitemsbyclass.cfm
the following colum(s) are never read within the request:line,descbold,typeorder
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,
            ' ' AS backordermsg,
            'N' AS largepackage,
            0 AS line,
            0 AS ordered,
            'G' AS type,
            "web_stylegroup"."page_sequence" AS typeorder,
             0 AS kit_available
      FROM web_stylegroup
      WHERE "web_stylegroup"."web_class" = 'BHA'
      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,
            "item_web"."stylecode" 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_web"."backordermsg" AS backordermsg,
            "item"."largepackage" AS largepackage,
            "worderitem"."line" AS line,
            "worderitem"."ordered" AS ordered,
            "item"."type" AS type,
            '9999' AS typeorder,
       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"."sitecode" = 'K' and "item_web"."web_class" = 'BHA' AND "item"."discontinued" = 'N' AND "item"."not_for_website" = 'N'
      GROUP BY item_web.itemn, webdesc, descbold, websize, picfile1, picfile2, thumb, stylecode, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg
      ORDER BY typeorder,webdesc;
getmenu (Datasource=kelcodbpsql, Time=1.25 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=&SearchClass=BHA
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=&SearchClass=BHA
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=813ad15d-5b5c-4686-8634-77395002bfb1
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=813ad15d-5b5c-4686-8634-77395002bfb1
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-08-19 12:20:33'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_813ad15d-5b5c-4686-8634-77395002bfb1_0
timecreated={ts '2019-08-19 12:20:33'}
urltoken=CFID=813ad15d-5b5c-4686-8634-77395002bfb1&CFTOKEN=0
URL Variables:
SearchClass=BHA
SearchText=
Debug Rendering Time: 0 ms