Silver The Family Clothesline |

home > sds design, boxercraft, sportula, prism promotions, lokai

Filters  

Type

Sort By
Items per page:

Now Viewing 1 -6 of 6 Items

Sort By
Items per page:

Now Viewing 1 -6 of 6 Items


Officially Licensed Penn State Clothing, Apparel and Merchandise

Need help? Call us 888-237-1946

Returns Gift Cards Customer Service Need Help? Call Us 888-237-1946
0 Sign In

Debugging Information
ColdFusion Server Standard 2021,0,16,330307
Template /category.cfm
Time Stamp 24-Sep-24 05:11 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 172.70.127.105
Host Name 172.70.127.105

Execution Time

Total Time Avg Time Count Template
250 ms 250 ms 1 top level C:\websites\FamilyClothesLine\category.cfm
78 ms 78 ms 1 C:/websites/FamilyClothesLine/includes/footer.cfm
46 ms 46 ms 1 C:/websites/FamilyClothesLine/includes/sidenav.cfm
32 ms 32 ms 1 C:/websites/FamilyClothesLine/includes/header.cfm
31 ms 31 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc | getALLBrandsFromOverallQuery([complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
16 ms 16 ms 1 C:/websites/FamilyClothesLine/Application.cfm
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getChildren(3F9597FE-155D-2292-05E8913CE1548D0A) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(183DF292-155D-2292-05CD90B735988F90) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CCFCD-155D-2292-0525FBB21D88F78C) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CD112-155D-2292-05D3835227C916B1) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
15 ms 15 ms 1 C:/websites/FamilyClothesLine/includes/views/departments.cfm
15 ms 15 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getPagesByTag(homepage, 9D8C4EC2-155D-2292-0553F4E061215B96, 20) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 C:/websites/FamilyClothesLine/functions/categoryfunctions.cfm
0 ms 0 ms 1 C:/websites/FamilyClothesLine/includes/application/check_db.cfm
0 ms 0 ms 1 C:/websites/FamilyClothesLine/includes/application/create_query_string.cfm
0 ms 0 ms 1 C:/websites/FamilyClothesLine/includes/application/paypal_config.cfm
0 ms 0 ms 1 C:/websites/FamilyClothesLine/includes/application/url_variable_defaults.cfm
0 ms 0 ms 6 C:/websites/FamilyClothesLine/includes/views/thumbnails.cfm
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cart.cfc | getCartQtyTotal() ] from C:/websites/FamilyClothesLine/functions/cart.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc | createLowerPagination(6, 1, 32, 5, https://www.pennstateclothes.com/all-products/browse/brand/sds-design,boxercraft,sportula,prism-promotions,lokai/color/silver, [complex value], [complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc | seoTagGenerator(false, check, [complex value], [complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(17B239A1-155D-2292-0511D9290403C1F4) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(17B6794D-155D-2292-057225F49C7C6629) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(17D68E89-155D-2292-054557E1D340E780) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(6DB63DB6-155D-2292-055A9BC44BA8A9E1) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8C4D64-155D-2292-057BD50838A99E44) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CA66B-155D-2292-05DE8B8AB7B7713C) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CB0E6-155D-2292-0583324B1B016B6B) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CB7F4-155D-2292-054C1ED3FABCF731) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CB84F-155D-2292-05707305148F2AC9) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CB957-155D-2292-058B97FF271F2C79) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CC048-155D-2292-056970FA6984D7F3) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CC0BB-155D-2292-0522EFDD9954F2CE) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CC0EC-155D-2292-05A3E8C5C5F88E8B) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CC11C-155D-2292-05E840C5D0DCDB59) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CCF27-155D-2292-055AD9DC216B7FE8) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CCF52-155D-2292-0598D81371BC6686) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CCF7D-155D-2292-05E2CD3025D163D5) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CCFA5-155D-2292-055603E678ECA072) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CD025-155D-2292-05EF10583C25003F) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CD0BD-155D-2292-054CCD5667F7D9EA) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CD0E8-155D-2292-054CD3CC2B771CEE) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getPagetByTitleAndParentId(sds-design,boxercraft,sportula,prism-promotions,lokai, 9D8C4EC2-155D-2292-0553F4E061215B96) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/tracking.cfc | googleTrackingPixel(UA-901015-1) ] from C:/websites/FamilyClothesLine/functions/tracking.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(25-to-50) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 8 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(DUMMYSIZE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(L) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(M) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(NAVY/PINK TOMB) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(NAVY/SILVER) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(PINK SOPHIA PLAID) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(S) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(XL) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(XS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(XXL) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(YS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(YXL) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | resolveUrlVar(sds-design,boxercraft,sportula,prism-promotions,lokai) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 3 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | resolveUrlVar(silver) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(Homepage Featured) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(Kids) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(Mens) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(Womens) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(SDS DESIGN,BOXERCRAFT,SPORTULA,PRISM PROMOTIONS,LOKAI) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(SILVER) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(sds design,boxercraft,sportula,prism promotions,lokai) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
266 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

session.settings (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\Application.cfm @ 17:11:47.047
SELECT * from web_settings with (nolock) WHERE web_settings_id = 1
getQueryStr (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 17:11:47.047
select * from web_category_mappings where url='all-products' or url='/all-products'
Getwebdepts (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 17:11:47.047
select * from application.getWebTaxonomy where upper(web_url)=?  and sort_position<>'NO'
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) =

GetALLProducts (Datasource=celerantSQL, Time=31ms, Records=6) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 17:11:47.047
SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(web_taxonomy_id) as web_taxonomy_id
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(team) as team
		, max(league) as league
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(alternateteam) as alternateteam
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(weight) as weight
		, max(attr1list) as attr1list
		, max(hexlist) as hexlist
		, max(sizelist) as sizelist
		, max(name) as name
		, max(inventorytype) as inventorytype
		, max(GOOGLEPRODUCTTAXONOMY) as GOOGLEPRODUCTTAXONOMY
		, max(gender) as gender
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(isFeaturedItem) as isFeaturedItem
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		
		
		FROM [dbo].[web_all_products] WHERE pictureid is not null
		   
		
                        	and (
                        	
                        		upper(Brand) LIKE 'SDS%DESIGN'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'BOXERCRAFT'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'SPORTULA'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'PRISM%PROMOTIONS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'LOKAI'
                            	)
                         and upper(attr1list) like '%SILVER,%' GROUP BY STYLE_ID
		ORDER BY sortposition
results (Datasource=, Time=0ms, Records=6) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 17:11:47.047
SELECT * FROM GetALLProducts ORDER BY
		new desc, picture_id desc
GetALLBrands (Datasource=celerantSQL, Time=31ms, Records=51) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 17:11:47.047
SELECT distinct style_id
		
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		
		FROM [dbo].[web_all_products] 
        WHERE pictureid is not null

		and upper(attr1list) like '%SILVER,%' GROUP BY STYLE_ID
results (Datasource=, Time=0ms, Records=16) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 17:11:47.047
SELECT Upper(brand) as brand,branddisplay, count(distinct
              
                style_id
              
              ) as itemCount 
              FROM GetALLBrands
              WHERE Brand>''
              GROUP BY brand,branddisplay 
              order by brand asc
getThis (Datasource=muraDB, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:47.047
SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS, credits
		    FROM tcontent
		    WHERE (parentID = '9D8C4EC2-155D-2292-0553F4E061215B96') and (urltitle = 'sds-design,boxercraft,sportula,prism-promotions,lokai') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2024-09-24 17:11:47.0' and displaystop>='2024-09-24 17:11:47.0') 
		    )
getThis (Datasource=muraDB, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:47.047
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '183DF292-155D-2292-05CD90B735988F90') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:47.047
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '17B239A1-155D-2292-0511D9290403C1F4') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:47.047
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '17B6794D-155D-2292-057225F49C7C6629') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:47.047
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '17D68E89-155D-2292-054557E1D340E780') AND (active = 1)
getThis (Datasource=muraDB, Time=16ms, Records=3) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:47.047
SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, METAKEYWORDS, METADESC, HTMLTITLE, credits, target
            FROM tcontent
            WHERE (parentID = '3F9597FE-155D-2292-05E8913CE1548D0A') AND (active = 1)
            ORDER BY orderno
checkTaxonomyLevel (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 17:11:47.047
select dept, typ, subtyp_1, subtyp_2, subtyp_3,category_style from application.getWebTaxonomy where 
		
		dept='' and typ='' and subtyp_1='' and subtyp_2='' and subtyp_3='' 
		order by dept asc, typ asc, subtyp_1 asc, subtyp_2 asc, subtyp_3 asc
getFilterItems (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:47.047
SELECT
        
        pricerange as price
        
        , count(distinct
        
          style_id
        
        ) as itemCount FROM getproducts WHERE
        
        pricerange
        
        >''
        
        GROUP BY
        
        pricerange order by pricerange asc
getFilterItems (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:47.047
select * from temp order by ranking asc
getFilterItems (Datasource=, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:47.047
select distinct
        
          sizeList
          
        from getproducts where
        
          sizeList
          
        >'' group by  
        
          sizeList
getTaxTree (Datasource=celerantSQL, Time=0ms, Records=12) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 17:11:47.047
SELECT dept, web_url 
                FROM tb_web_taxonomy 
                WHERE dept>'' and typ='EMPTY' and dept<>'EMPTY'  
                ORDER BY sort_position
getCurrentDept (Datasource=celerantSQL, Time=15ms, Records=4) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 17:11:48.048
SELECT DISTINCT dept, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept<>'EMPTY' 
				and style_id IN (12616,12184,10013,10012,9976,9965)
                GROUP BY dept
this.GetFilterQuery (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:48.048
SELECT pricerange as price, count(distinct
  
    style_id
  
  ) as itemCount FROM GETPRODUCTS WHERE pricerange > ''
	GROUP BY pricerange order by pricerange asc
this.GetFilterQuery (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:48.048
select * from temp order by ranking asc
getColors (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:48.048
select distinct hexLIST 
        from getproducts 
        group by hexLIST
getSizes (Datasource=, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:48.048
select distinct sizeList 
	from GETPRODUCTS 
	where sizeList <>''  
	group by sizeList
getSizes (Datasource=celerantSQL, Time=31ms, Records=8) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 17:11:48.048
SELECT DISTINCT siz, max(size_order) as size_order
		FROM tb_size_entries
		WHERE upper(siz) IN ('M','L','XXL','S','XS','XL','YS','YXL') and upper(siz) <> 'NS' and upper(siz) <> 'N/S'
		GROUP BY siz
		ORDER BY max(size_order), siz
getThis (Datasource=muraDB, Time=15ms, Records=13) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS, credits
		    FROM tcontent
		    WHERE (parentID = '9D8C4EC2-155D-2292-0553F4E061215B96') and (tags like '%homepage%') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2024-09-24 17:11:48.0' and displaystop>='2024-09-24 17:11:48.0') 
		    ) ORDER BY orderno
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB7F4-155D-2292-054C1ED3FABCF731') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC048-155D-2292-056970FA6984D7F3') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC0BB-155D-2292-0522EFDD9954F2CE') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '6DB63DB6-155D-2292-055A9BC44BA8A9E1') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8C4D64-155D-2292-057BD50838A99E44') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB957-155D-2292-058B97FF271F2C79') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB0E6-155D-2292-0583324B1B016B6B') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCF27-155D-2292-055AD9DC216B7FE8') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB84F-155D-2292-05707305148F2AC9') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC0EC-155D-2292-05A3E8C5C5F88E8B') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CA66B-155D-2292-05DE8B8AB7B7713C') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD025-155D-2292-05EF10583C25003F') AND (active = 1)
getThis (Datasource=muraDB, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD112-155D-2292-05D3835227C916B1') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD0E8-155D-2292-054CD3CC2B771CEE') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD0BD-155D-2292-054CCD5667F7D9EA') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC11C-155D-2292-05E840C5D0DCDB59') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCF52-155D-2292-0598D81371BC6686') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCFA5-155D-2292-055603E678ECA072') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCF7D-155D-2292-05E2CD3025D163D5') AND (active = 1)
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 17:11:48.048
SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCFCD-155D-2292-0525FBB21D88F78C') AND (active = 1)
getWebTaxonomy (Datasource=celerantSQL, Time=0ms, Records=448) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
select * from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and sort_position<>'NO' and len(web_url)>0
getDepts (Datasource=celerantSQL, Time=0ms, Records=10) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT  dept,SHORT_DESC,LONG_DESCRIPTION, web_url from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and typ='EMPTY' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=9) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='MENS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='WOMENS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='KIDS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=6) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='JERSEYS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=15ms, Records=3) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='TSHIRTS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=22) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='SPORTS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='SWEATSHIRTS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='HEADWEAR' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=23) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='SOUVENIRS' Order By SORT_POSITION ASC
getTyps (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 17:11:48.048
SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='FOOTWEAR' Order By SORT_POSITION ASC

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O="CloudFlare, Inc.", OU=CloudFlare Origin SSL Certificate Authority, L=San Francisco, S=California
CERT_SERVER_SUBJECT=O="CloudFlare, Inc.", OU=CloudFlare Origin CA, CN=CloudFlare Origin Certificate
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\websites\FamilyClothesLine\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O="CloudFlare, Inc.", OU=CloudFlare Origin SSL Certificate Authority, L=San Francisco, S=California
HTTPS_SERVER_SUBJECT=O="CloudFlare, Inc.", OU=CloudFlare Origin CA, CN=CloudFlare Origin Certificate
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2; CFID=19049; __cflb=02DiuH7CwonCo2wcgBjAszNcmNicJwt5v4XHqLpB5v4oe; CFGLOBALS=urltoken%3DCFID%23%3D19049%26CFTOKEN%23%3Dc451654e6a27747%2D7AC14D5D%2D9711%2D28E7%2D1EFC9561A656A9D2%23lastvisit%3D%7Bts%20%272024%2D09%2D24%2017%3A11%3A43%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272024%2D09%2D24%2017%3A11%3A43%27%7D%23cftoken%3Dc451654e6a27747%2D7AC14D5D%2D9711%2D28E7%2D1EFC9561A656A9D2%23cfid%3D19049%23; CFID=19049; CFTOKEN=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2
HTTP_HOST=www.pennstateclothes.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=all-products/browse/brand/sds-design,boxercraft,sportula,prism-promotions,lokai/color/silver
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=216.98.3.62
PATH_INFO=
PATH_TRANSLATED=C:\websites\FamilyClothesLine\category.cfm
QUERY_STRING=mapping=all-products/browse/brand/sds-design,boxercraft,sportula,prism-promotions,lokai/color/silver
REMOTE_ADDR=172.70.127.105
REMOTE_HOST=172.70.127.105
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.pennstateclothes.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=19049
cftoken=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2
hitcount=2
lastvisit={ts '2024-09-24 17:11:43'}
timecreated={ts '2024-09-24 17:11:43'}
urltoken=CFID=19049&CFTOKEN=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2

Cookie Variables:
CFGLOBALS=urltoken=CFID#=19049&CFTOKEN#=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2#lastvisit={ts '2024-09-24 17:11:43'}#hitcount=2#timecreated={ts '2024-09-24 17:11:43'}#cftoken=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2#cfid=19049#
CFID=19049
CFTOKEN=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2
__cflb=02DiuH7CwonCo2wcgBjAszNcmNicJwt5v4XHqLpB5v4oe

Form Fields:
KWORD=

Session Variables:
cartstatus=NEW
cfid=19049
cftoken=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2
checkout=Struct (4)
couponreset=NO
cs=https://www.pennstateclothes.com/all-products/browse/brand/sds-design,boxercraft,sportula,prism-promotions,lokai/color/silver
customer_id=
customerdiscount=0
display_cc=YES
displaycount=32
email=
employeeloggedin=false
first_name=
getheaders=,
getwebtaxonomy=Query (447)
last_name=
memberloggedin=N
myreturnurl=https://www.pennstateclothes.com/all-products/browse/brand/sds-design,boxercraft,sportula,prism-promotions,lokai/color/silver
password=
phone=
pickupstore=1
qualifyingpromoitems=0
sessionid=PENNSTATECLOTHESRESPONSIVE5_19049_c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2
settings=Query (1)
shipmethodlist=0,1
urltoken=CFID=19049&CFTOKEN=c451654e6a27747-7AC14D5D-9711-28E7-1EFC9561A656A9D2
username=
website=Struct (1)

URL Parameters:
mapping=all-products/browse/brand/sds-design,boxercraft,sportula,prism-promotions,lokai/color/silver
Debug Rendering Time: 31 ms