Most of the print and plaid ribbons on this page are Weather Resistant and can withstand normal outside weather conditions. Some are Weather Sensitive which means they can handle only minimal exposure to outside weather conditions and are really best for indoor use. Please check the product description before ordering if you intend to use these ribbons outdoors.


Qty 
Item #: R40DWIBRLN
Burlap Natural Color Wire Edge #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$25.70

Qty 
Item #: RP09DWIST
Candy Cane Stripes
1 1/2" wide 50 yard roll
In Stock
0.8 lbs.
$14.40

Qty 
Item #: RP40DWIST
Candy Cane Stripes
2 1/2" wide 50 yard roll
In Stock
1 lbs.
$21.00

Qty 
Item #: R40DWIHB
Holly Natural Color Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$25.70

Qty 
Item #: R40DWILIN
Natural Beige Linen Ribbon Wire Edge #40
2-5/8" wide 50 yard roll
In Stock
1 lbs.
$22.05

Qty 
Item #: R40DWIBT
Plaid Brushed Muslin Red/Emerald #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$21.30

Qty 
Item #: R40PWPBGG
Plaid Burgandy/Green/Gold Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$21.00

Qty 
Item #: R40TMB
Plaid Burgundy / Hunter Green #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$15.95

Qty 
Item #: R09TMB
Plaid Burgundy / Hunter Green #9
1 1/2" wide 25 yard roll
In Stock
0.2 lbs.
$9.35

Qty 
Item #: R40DWIXM
Plaid Country Christmas Wire Edge #40
2 1/2" wide 25 yard roll
Out of stock
1 lbs.
$18.45

Qty 
Item #: R40WP25
Plaid Ivory/Red/Hunter Green Woolen #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$22.30

Qty 
Item #: R40TMC
Plaid Multi Color Plaid #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$15.95

Qty 
Item #: R09TMC
Plaid Multi Color Ribbon #9
1 1/2" wide 25 yard roll
In Stock
0.2 lbs.
$9.35

Qty 
Item #: RP40PMP
Plaid Red/Gold/Green Gold Edge #40
2 1/2" wide 50 yard roll
In Stock
1 lbs.
$17.35

Qty 
Item #: RP09PTP
Plaid Red/Gold/Green Gold Edge #9
1 1/2" wide 50 yard roll
In Stock
1 lbs.
$12.65

Qty 
Item #: RP40PTP
Plaid Red/Gold/Green Gold Edge #9
2 1/2" wide 50 yard roll
In Stock
1 lbs.
$16.95

Qty 
Item #: RP09PMP
Plaid Red/Gold/Green Gold Edge #9
1 1/2" wide 50 yard roll
In Stock
1 lbs.
$12.65

Qty 
Item #: R40TRG
Plaid Red/Green Metallic Ribbon #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$15.95

Qty 
Item #: R09TRG
Plaid Red/Green Ribbon #9
1 1/2" wide 25 yard roll
In Stock
0.2 lbs.
$9.35

Qty 
Item #: R40MWSPR25
Plaid Red Scotch Muslin Ribbon #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$22.30

Qty 
Item #: R40CLWS
Print Classic Holiday #40 Red/Gold/Sheer
2 1/2" wide 25 yard roll
In Stock
0.4 lbs.
$37.05

Qty 
Item #: R40DWICGB
Print Country Gingham Burgundy #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$17.40

Qty 
Item #: R40DWICGR
Print Country Gingham Red #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$17.40

Qty 
Item #: R40PWCC
Print Flashy Candy Cane Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$21.10

Qty 
Item #: RP40MCB
Print McBurgundy Plaid #40
2 1/2" 50 yard roll
In Stock
1 lbs.
$17.10

Qty 
Item #: RP09MCB
Print McBurgundy Plaid #9
1 1/2" 50 yard roll
In Stock
1 lbs.
$12.00

Qty 
Item #: R40DWIBC25
Print Red/Black Check #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$22.35

Qty 
Item #: R40TWGS25
Print Red Velvet Gold Stars Wire #40
2 5/8" wide 25 yard roll
In Stock
0.8 lbs.
$22.55

Qty 
Item #: R40MWRWC25
Print Red/White Checked Muslin #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$21.30

Qty 
Item #: R40DWICC25
Print Red/White/Silver Candy Cane #40
2 5/8" wide 25 yard roll
In Stock
0.8 lbs.
$22.60

Qty 
Item #: R09DWICC25
Print Red/White/Silver Candy Cane #9
1 1/2" wide 25 yard roll
In Stock
0.6 lbs.
$11.20

Qty 
Item #: R40WSBW
Print Silver Pine Cones
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$21.65

Qty 
Item #: R40SHSB25
Print Silver Snowflack Ribbon #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$21.95

Qty 
Item #: R40DWISF
Print Silver Snowflake Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$22.90

Qty 
Item #: R40PWSM
Print Sparkling Snowman Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$21.10

Qty 
Item #: R40TWSS25
Velvet Blue w/Stars #40 Silver Edge
2 1/2" X 25 yard roll
In Stock
0.8 lbs.
$22.55

Qty 
Item #: R40TWBS25
Velvet White w/Stars #40 Wire Edge
2 1/2" X 25 yard roll
In Stock
0.8 lbs.
$22.55

Qty 
Item #: R40DWIBK
Wild Buck Ribbon #40
2 1/2" X 25 yard roll
In Stock
1 lbs.
$21.30


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:21 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
255 ms 255 ms 1 /var/www/html/kelcomaine/searchresults.cfm
9.5 ms 9.5 ms 1 /var/www/html/kelcomaine/getitemsbyclass.cfm
37.3 ms 9.33 ms 4 /var/www/html/kelcomaine/makemenu.cfm
8.89 ms 8.89 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
140 ms 3.68 ms 38 /var/www/html/kelcomaine/addtocartform.cfm
2.97 ms 1.48 ms 2 /var/www/html/kelcomaine/getitemwebbrowse.cfm
1.21 ms 1.21 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
1.19 ms 1.19 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
0.346 ms 0.346 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.159 ms 0.159 ms 1 /var/www/html/kelcomaine/Application.cfc
0.149 ms 0.149 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.121 ms 0.121 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.111 ms 0.111 ms 1 /var/www/html/kelcomaine/pagetop.cfm
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$checkUserAgentContains
0.024 ms 0.024 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.017 ms 0.017 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.005 ms 0.005 ms 1 /var/www/html/kelcomaine/searchcheckparam.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/wilsonlib.cfm
0.002 ms 0.002 ms 1 /var/www/html/kelcomaine/addbackorderbutton.cfm
0.071 ms 0.001 ms 37 /var/www/html/kelcomaine/addtocartbutton.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.995 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
438 ms  APPLICATION EXECUTION TIME
19 ms  QUERY EXECUTION TIME
458 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /addtocartform.cfm 1 noanchor 37
variables /addtocartform.cfm 2 NOANCHOR 1
variables /addtocartform.cfm 5 NOANCHOR 38
query /addtocartform.cfm 6 ITEMN 38
variables /addtocartform.cfm 8 QUERY_STRING 38
query /addtocartform.cfm 8 ITEMN 38
query /addtocartform.cfm 12 ONHAND 38
query /addtocartform.cfm 12 RESERVED 38
variables /addtocartform.cfm 12 ALWAYSINSTOCK 1
query /addtocartform.cfm 12 ITEMN 1
query /addtocartform.cfm 12 KIT_AVAILABLE 1
query /addtocartform.cfm 28 BACKORDERMSG 38
query /addtocartform.cfm 29 ITEMN 38
query /addtocartform.cfm 30 ITEMN 38
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 getitemwebbrowse 2
variables /getitemwebbrowse.cfm 10 cfquery 2
variables /getwebblock.cfm 2 BLOCK 1
variables /getwebblock.cfm 3 cfquery 1
variables /getwebblock.cfm 3 getwebblock 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_URL 4
variables /makemenu.cfm 44 PREV_MENUTEXT 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_URL 25
variables /makemenu.cfm 53 PREV_MENUTEXT 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 GETMENU 28
variables /makemenu.cfm 60 PREV_URL 28
variables /makemenu.cfm 61 PREV_MENUTEXT 28
variables /makemenu.cfm 61 GETMENU 28
variables /makemenu.cfm 65 SUBMENU 2
variables /makemenu.cfm 67 PREV_URL 1
variables /makemenu.cfm 67 PREV_MENUTEXT 1
variables /makemenu.cfm 71 PREV_MENUTEXT 1
variables /makemenu.cfm 71 PREV_URL 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 cfquery 1
variables /searchresults.cfm 4 getwebclass 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 38
query /searchresults.cfm 86 ITEMN 76
variables /searchresults.cfm 86 THUMBPATH 38
query /searchresults.cfm 87 PICFILE1 38
query /searchresults.cfm 89 PICFILE1 13
variables /searchresults.cfm 89 THUMBPATH 13
variables /searchresults.cfm 90 THUMBPATH 13
variables /searchresults.cfm 91 THUMBPATH 39
variables /searchresults.cfm 93 THUMBPATH 26
variables /searchresults.cfm 95 THUMBPATH 38
variables /searchresults.cfm 96 THUMBPATH 38
query /searchresults.cfm 99 ITEMN 76
variables /searchresults.cfm 99 THUMBPATH2 38
query /searchresults.cfm 100 PICFILE2 38
variables /searchresults.cfm 108 THUMBPATH2 38
variables /searchresults.cfm 109 THUMBPATH2 38
query /searchresults.cfm 119 OUTFORSEASON 38
query /searchresults.cfm 119 ACTIVE 38
query /searchresults.cfm 121 STYLECODE 38
query /searchresults.cfm 121 TYPE 38
query /searchresults.cfm 138 ORDERED 38
query /searchresults.cfm 173 ITEMN 38
query /searchresults.cfm 178 TYPE 38
query /searchresults.cfm 182 TYPE 38
query /searchresults.cfm 182 ITEMN 38
query /searchresults.cfm 184 WEBDESC 38
query /searchresults.cfm 189 TYPE 38
query /searchresults.cfm 192 ITEMN 38
query /searchresults.cfm 192 TYPE 38
query /searchresults.cfm 194 WEBSIZE 38
query /searchresults.cfm 209 TYPE 38
query /searchresults.cfm 212 TYPE 38
query /searchresults.cfm 212 ITEMN 38
query /searchresults.cfm 214 THUMB 38
query /searchresults.cfm 214 ITEMN 34
variables /searchresults.cfm 216 THUMBPATH 4
query /searchresults.cfm 221 TYPE 38
query /searchresults.cfm 224 TYPE 38
query /searchresults.cfm 224 ITEMN 38
variables /searchresults.cfm 226 THUMBPATH2 38
query /searchresults.cfm 230 TYPE 38
query /searchresults.cfm 230 STYLECODE 38
query /searchresults.cfm 231 RESERVED 38
query /searchresults.cfm 231 ONHAND 38
query /searchresults.cfm 231 KIT_AVAILABLE 1
query /searchresults.cfm 237 WEIGHT 38
query /searchresults.cfm 238 LARGEPACKAGE 38
query /searchresults.cfm 238 largepackage 38
query /searchresults.cfm 242 PRICE 38
query /searchresults.cfm 243 PRICE 38
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 118
arguments /wilsonlib.cfm 33 STR 3530
arguments /wilsonlib.cfm 34 STR 3412
arguments /wilsonlib.cfm 41 STR 41
arguments /wilsonlib.cfm 42 STR 3
arguments /wilsonlib.cfm 43 STR 3
arguments /wilsonlib.cfm 57 STR 82
arguments /wilsonlib.cfm 58 STR 82
arguments /wilsonlib.cfm 62 STR 236
arguments /wilsonlib.cfm 63 STR 118


SQL Queries

getwebclass (Datasource=kelcodbpsql, Time=1.13 ms, Records=1) in /var/www/html/kelcomaine/searchresults.cfm
SELECT classpagetext, classtitle FROM web_class WHERE "webclass" = 'RPP';
getitemwebbrowse (Datasource=kelcodbpsql, Time=1.13 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 = 'RPP' and web_itempage.pageid = web_itempage.pageid and web_pagemaster.site='K';
getmenu (Datasource=kelcodbpsql, Time=0.975 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.13 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 = 'RPP' and web_itempage.pageid = web_itempage.pageid and web_pagemaster.site='K';
getmenu (Datasource=kelcodbpsql, Time=1.83 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.29 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.899 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=9.15 ms, Records=38) 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" = 'RPP'
      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" = 'RPP' 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.5 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=RPP
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=RPP
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=2562adc0-142a-4471-b8fd-1933361c18d9
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=2562adc0-142a-4471-b8fd-1933361c18d9
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-08-19 12:21:17'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_2562adc0-142a-4471-b8fd-1933361c18d9_0
timecreated={ts '2019-08-19 12:21:17'}
urltoken=CFID=2562adc0-142a-4471-b8fd-1933361c18d9&CFTOKEN=0
URL Variables:
SearchClass=RPP
SearchText=
Debug Rendering Time: 0 ms