Retail Items

Choose Sub-category Below
    
    Magic Carpet
    Flags


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /browseproducts.cfm (/var/www/html/kelcomaine/browseproducts.cfm)
Time Stamp Oct 22, 2019 1:57 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.3 ms 13.3 ms 1 /var/www/html/kelcomaine/browseproductspage.cfm
34 ms 8.52 ms 4 /var/www/html/kelcomaine/makemenu.cfm
1.97 ms 1.97 ms 1 /var/www/html/kelcomaine/getitemwebbrowse.cfm
1.32 ms 1.32 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
1.11 ms 1.11 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
1.01 ms 1.01 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
2.28 ms 0.456 ms 5 /var/www/html/kelcomaine/showproductthumbnail.cfm
0.308 ms 0.308 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.136 ms 0.136 ms 1 /var/www/html/kelcomaine/Application.cfc
0.119 ms 0.119 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.104 ms 0.104 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.075 ms 0.075 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.029 ms 0.029 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.016 ms 0.016 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.019 ms 0.009 ms 2 /var/www/html/kelcomaine/WEB-INF/lucee/context/Component.cfc
0.008 ms 0.008 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$init
0.007 ms 0.007 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/browseproducts.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.373 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
49.7 ms  APPLICATION EXECUTION TIME
6.21 ms  QUERY EXECUTION TIME
56.3 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 /browseproducts.cfm 5 GROUPNAME 1
variables /browseproducts.cfm 11 GETITEMWEBBROWSE 1
variables /browseproducts.cfm 11 BROWSEPAGE 1
variables /browseproducts.cfm 12 BROWSEURL 1
variables /browseproducts.cfm 12 GETITEMWEBBROWSE 1
variables /browseproducts.cfm 13 BROWSEPAGE 1
variables /browseproductspage.cfm 1 LASTGROUPNAME 1
variables /browseproductspage.cfm 2 LEFTCOLUMN 1
variables /browseproductspage.cfm 3 CENTERCOLUMN 1
variables /browseproductspage.cfm 4 RIGHTCOLUMN 1
variables /browseproductspage.cfm 6 getitemwebbrowse 1
variables /browseproductspage.cfm 7 ROWHTML 5
variables /browseproductspage.cfm 8 ROWHTML 5
variables /browseproductspage.cfm 10 GETITEMWEBBROWSE 5
variables /browseproductspage.cfm 14 GETITEMWEBBROWSE 5
variables /browseproductspage.cfm 14 LASTGROUPNAME 5
variables /browseproductspage.cfm 15 ROWHTML 1
variables /browseproductspage.cfm 16 GETITEMWEBBROWSE 1
variables /browseproductspage.cfm 17 GETITEMWEBBROWSE 1
variables /browseproductspage.cfm 17 LASTGROUPNAME 1
variables /browseproductspage.cfm 18 ROWHTML 1
variables /browseproductspage.cfm 21 GETITEMWEBBROWSE 10
variables /browseproductspage.cfm 21 ROWHTML 5
variables /browseproductspage.cfm 21 SAFETAGS 5
variables /browseproductspage.cfm 23 ROWHTML 5
variables /browseproductspage.cfm 24 GETITEMWEBBROWSE 5
variables /browseproductspage.cfm 25 ROWHTML 5
variables /browseproductspage.cfm 25 LEFTCOLUMN 5
variables /browseproductspage.cfm 27 GETITEMWEBBROWSE 5
variables /browseproductspage.cfm 30 GETITEMWEBBROWSE 5
variables /browseproductspage.cfm 36 BROWSELINKS 1
variables /browseproductspage.cfm 38 LEFTCOLUMN 1
variables /browseproductspage.cfm 41 CENTERCOLUMN 1
variables /browseproductspage.cfm 43 RIGHTCOLUMN 1
variables /getitemwebbrowse.cfm 27 groupname 1
variables /getitemwebbrowse.cfm 39 GROUPNAME 1
variables /getitemwebbrowse.cfm 40 cfquery 1
variables /getitemwebbrowse.cfm 40 getitemwebbrowse 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 2 browseurl 1
variables /pagetopstatus.cfm 5 browsepage 1
variables /pagetopstatus.cfm 6 BROWSELINKS 2
variables /pagetopstatus.cfm 6 SAFETAGS 1
variables /pagetopstatus.cfm 6 BROWSEURL 1
variables /pagetopstatus.cfm 6 BROWSEPAGE 1
variables /showproductthumbnail.cfm 1 GETITEMWEBBROWSE 5
variables /showproductthumbnail.cfm 2 GETITEMWEBBROWSE 1
variables /showproductthumbnail.cfm 2 ROWHTML 1
variables /showproductthumbnail.cfm 4 GETITEMWEBBROWSE 4
variables /showproductthumbnail.cfm 4 THUMBPATH 4
variables /showproductthumbnail.cfm 5 THUMBPATH 4
variables /showproductthumbnail.cfm 6 THUMBPATH 12
variables /showproductthumbnail.cfm 8 THUMBPATH 4
variables /showproductthumbnail.cfm 9 THUMBPATH 4
variables /showproductthumbnail.cfm 9 IMAGESRC 4
variables /showproductthumbnail.cfm 10 IMAGESRC 4
arguments /wilsonlib.cfm 25 STR 6
arguments /wilsonlib.cfm 33 STR 89
arguments /wilsonlib.cfm 34 STR 83
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 12
arguments /wilsonlib.cfm 63 STR 6


SQL Queries

getitemwebbrowse (Datasource=kelcodbpsql, Time=1.58 ms, Records=5) in /var/www/html/kelcomaine/getitemwebbrowse.cfm
SELECT
     webdescription,
     pagetitle,
     picfile,
     thumb,
     url,
     webclass,
     webdescription,
     1 AS table_column,
     groupname
   FROM web_itempage LEFT OUTER JOIN item_webimages ON web_itempage.picfile = item_webimages.itemn, web_pagemaster WHERE web_itempage.groupname = 'Retail Items' and web_itempage.pageid = web_pagemaster.pageid ORDER BY groupseq;
getmenu (Datasource=kelcodbpsql, Time=0.828 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.31 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.879 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.736 ms, Records=1) in /var/www/html/kelcomaine/getwebblock.cfm
select block_text from web_block where block_key='Kelco Store'
getmenu (Datasource=kelcodbpsql, Time=0.875 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/browseproducts.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/browseproducts.cfm
query_string=groupname=Retail%20Items
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://www.kelcomaine.com/browseproducts.cfm?groupname=Retail%20Items
script_name=/browseproducts.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=6d83b7dc-fde2-49bb-9ae8-1ad9f57e1d47
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=6d83b7dc-fde2-49bb-9ae8-1ad9f57e1d47
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-10-22 13:57:28'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_6d83b7dc-fde2-49bb-9ae8-1ad9f57e1d47_0
timecreated={ts '2019-10-22 13:57:28'}
urltoken=CFID=6d83b7dc-fde2-49bb-9ae8-1ad9f57e1d47&CFTOKEN=0
URL Variables:
groupname=Retail Items
Debug Rendering Time: 0 ms