Pro AV Catalog

Lutron Electronics Company, Inc.

Redo, Renew, and Refresh with Lutron at KBIS 2012
Article posted on Apr 25, 2012
Save to Project

get inspired with the newest ideas in light and shade control, plus colored accessories

Coopersburg, PA (April 24, 2012) — Light control manufacturer Lutron Electronics will be showcasing its latest energy-saving light and shade controls at the Kitchen & Bath Industry Show, taking place April 24-26, 2012 at McCormick Place in Chicago, Ill. Lutron will be located at booth #1275.

Lutron will be showing attendees how to “Redo, Renew and Refresh” their spaces with the latest products, including the new Serena® battery-powered window shades, the Maestro® occupancy sensing switch and the Satin Colors_ collection of phone jacks, cable jacks, receptacles, fan controls in more than 20 trending colors.

Lutron will also be hosting two seminars:

Managing and Maximizing the Effects of Lighting
 

  • 4-6pm on Monday, April 23
  • Presented by: Staci Quirk, Product Marketing Manager, Lutron
  • CEUs: 0.2; NKBA Hours: 2 – registration required
  • In this interactive session, you'll discover how to enrich your kitchen and bath designs with the right lighting techniques and lights sources—as well as learn how lighting control creates more beautiful, comfortable, and functional spaces, all while saving energy.
  • At the conclusion of this session, you will have the ability to:
    • identify key light sources and fixtures and explain where they work best in an application
    • describe lighting legislation and codes
    • explain how simple lighting control solutions can improve your design and enhance your client's lifestyle


New Shading Innovations to Enhance Your Business
 

  • 12:30-1pm on Wednesday, April 25th
  • NKBA Booth - Center Stage - Booth #2131
  • discussion will focus on the new, lower cost automated shading solutions from Lutron
  • presented by David Weinstein, Vice-President, New Business Development, Lutron
  • free of charge - no registration required


 

loading


Debugging Information
ColdFusion Server Enterprise 10,0,16,293499
Template /avcat/CTL2575/index.cfm
Time Stamp 04-Aug-15 11:55 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 204.2.187.68
Host Name 204.2.187.68


Execution Time

Total Time Avg Time Count Template
243 ms 243 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/CTL2575/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
213 ms 213 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
119 ms 119 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/Showroom.cfm
60 ms 60 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomMenu.cfm
48 ms 48 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
42 ms 42 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
29 ms 29 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
28 ms 28 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/CTL2575/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
23 ms 23 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier2Cats() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
18 ms 18 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getShowroomCategories() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
12 ms 12 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(2575, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
8 ms 8 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomNewsNav.cfm
7 ms 7 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomArticle.cfm
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionMRC(2575, MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailMRC(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getMRCOptions(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getShowroomOptions(2575, 575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(132315) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203169) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203308) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomVideoBox.cfm
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getManufacturer(lutron-electronics-company, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldURLs(lutron-electronics-company, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getPressReleases() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getPromotions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getVideo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getNewProdCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getNewsCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getProdCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(133502) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203122) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203164) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203198) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203348) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203550) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(204646) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/contactus.cfm
3 ms 3 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getBimCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getVideoCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedForDealer() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | createDynamicListArray(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateReturnToURL(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | getBotWords() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/list/list.cfc | makeListButton(Articles, 7575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/list/list.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCatID(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL2575/index-top.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-javascript-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products-content.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getCatalogType(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getIsLoggedIn(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getMarketID(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getUserID(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc | makeMetaDescription(Technical Innovation, LLC - Lutron Electronics Company, Inc. - Redo, Renew, and Refresh with Lutron at KBIS 2012 ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc | makeMetaTitle(Technical Innovation, LLC - Lutron Electronics Company, Inc. - Redo, Renew, and Refresh with Lutron at KBIS 2012 ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/avcat/CTL2575/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getLanguageID(en) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleLanguage(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldDomain(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | setCurrentCatID([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | startSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/avcat/CTL2575/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getExclusionKeyList() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc | checkLiveSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc | getCatalogType(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | clearSessionVars() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setArticle(7575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCategoryTree(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCompanyID(203567) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setFAS(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setIsDistributor() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setKeyword(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNewProds(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNewProdsMonth(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNewProdsYear(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNews(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setPageURL(index.cfm?manufacturer=lutron-electronics-company) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProduct(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProductEmail(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProductEmailConf(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProducts(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setRFI(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setSubCatID(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setVarLink() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setVideo(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getProfileCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setChildCatID(575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setCompanyID(203567) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setLanguageID(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setMarketID(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setParentCatID(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setShowroomLevel(A) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL2575/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bad-css.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-google-analytics-code.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/countries.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/states.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
9 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
281 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=47, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 11:55:04.004
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=1ms, Records=735, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

Q (Datasource=Ava_Fenster, Time=3ms, Records=8851, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

VARIABLES.GetALLMRCSAndOptions (Datasource=Ava_Fenster, Time=0ms, Records=755, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			{ CALL GetALLMRCSAndOptions() }
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			SELECT	*
			FROM	VARIABLES.GetALLMRCSAndOptions
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

qmlcFind (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:55:04.004
			SELECT	Catalog.catalog_id,
					Catalog_type_id
			FROM	Catalog
			WHERE	Catalog_url_id = ?
					AND (Catalog_type_id = 'mcs' OR catalog_type_id = 'mlc')
					AND Market_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = lutron-electronics-company
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 11:55:04.004
			SELECT	Catalog.catalog_id,
					Catalog_type_id
	        FROM	Catalog
	        WHERE	Catalog_url_id = ?
					AND (Catalog_type_id = 'mcs' OR Catalog_type_id = 'mlc')
					AND Market_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = lutron-electronics-company
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:55:04.004
			SELECT	CATALOG.Catalog_ID,
					Catalog.Catalog_Type_ID,
					CATALOG_OPTIONS.Catalog_Option_Char,
					CASE WHEN catalog.catalog_Type_ID = 'MCS' THEN ctlOptionPrem.RFI ELSE ctlOptionBasic.RFI END as RFI,
					CASE WHEN catalog.catalog_Type_ID = 'MCS' THEN ctlOptionPrem.Dealer_Locator ELSE ctlOptionBasic.Dealer_Locator END as Dealer_Locator,
					CASE WHEN catalog.catalog_Type_ID = 'MCS' THEN ctlOptionPrem.Show_MSRP ELSE ctlOptionBasic.Show_MSRP END as Show_MSRP
			FROM	Catalog
					JOIN CATALOG_OPTIONS
						ON CATALOG_OPTIONS.Catalog_ID = CATALOG.Catalog_ID
					LEFT OUTER JOIN ctlOption_MCS ctlOptionPrem
						ON ctlOptionPrem.ctlOwner_ID = CATALOG.Catalog_ID
					LEFT OUTER JOIN ctlOption_MLC ctlOptionBasic
						ON ctlOptionBasic.ctlOwner_ID = CATALOG.Catalog_ID
			WHERE	Catalog.catalog_id = ?
					AND CATALOG_OPTIONS.Option_ID = 'level'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 575

QMRC (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:55:04.004
			SELECT	CATALOG.Catalog_ID,
					ctlOption.RFI,
					ctlOption.Show_MSRP
			FROM	catalog
					JOIN ctlOption_MRC ctlOption
						ON ctlOption.ctlOwner_ID = CATALOG.Catalog_ID
			WHERE	Catalog.catalog_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

Q (Datasource=Ava_Fenster, Time=5ms, Records=8744, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:55:04.004
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:55:04.004
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

MasterGetCatalogDetailMRC (Datasource=Ava_Fenster, Time=1ms, Records=753, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:55:04.004
			{ CALL GetCatalogDetailALL_MRC }
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:55:04.004
	     	SELECT	CATALOG_ADDRESS1 ,
					CATALOG_ADDRESS2 ,
					CATALOG_ADDRESS3 ,
					CATALOG_CITY ,
					CATALOG_COMPANY_ID ,
					CATALOG_COUNTRY ,
					CATALOG_DISPLAY_NAME ,
					CATALOG_EMAIL_ADDRESS ,
					CATALOG_ID ,
					CATALOG_PHONE ,
					CATALOG_POSTCODE ,
					CATALOG_STATE_PROVINCE ,
					CATALOG_TYPE_ID ,
					CATALOG_URL ,
					CATALOG_URL_ID ,
					CATEGORY_TREE_ID ,
					COMPANY_DESCRIPTION ,
					CURRENCY_ID	 ,
					MARKET_ID ,
					PROFILE_ID ,
					VISION_IMPORT_ID
			FROM	MasterGetCatalogDetailMRC
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=9, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			{ CALL GETAds (
				? ,
				'groupA' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203169

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203550

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203177

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203122

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 204646

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203308

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203198

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203164

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:55:04.004
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203348

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	DISTINCT
					TIER2_CATEGORY_DISPLAY_NAME ,
					TIER2_CATEGORY_URL_ID ,
					TIER2_ID ,
					TIER2_PRODUCT_COUNT
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	SUM(TIER3_NEW_PRODUCT_COUNT) AS TotalProds
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	COUNT(DISTINCT	a.Press_Release_id) AS cnt
			FROM	Press_Release a
					INNER JOIN press_release_market b
						ON a.press_release_id = b.press_release_id
			WHERE	Company_ID = ?
					AND Market_id = ?
					AND Press_Release_Type_ID = 'Company_News'
					AND (Press_Release_Date > DATEADD(d,-365,GETDATE()) AND Press_Release_Date < getDate())
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203567
Parameter #2(cf_sql_integer) = 1

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	COUNT(DISTINCT a.Video_ID) AS cnt
			FROM	VIDEO a
					INNER JOIN VIDEO_COMPANY b
						ON a.Video_ID = b.Video_ID
			WHERE	a.Video_Company_ID = ?
					AND b.Video_Mapping_Value = ?
					AND b.Video_Mapping_ID = 'marketid'
					AND a.Video_Active = 1
					AND a.Video_Start_Date < GETDATE()
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203567
Parameter #2(cf_sql_integer) = 1

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	COUNT(a.Document_ID) as cnt
			FROM	documents a
			WHERE	a.Document_Type_ID = 'bim'
					AND a.Manufacturer_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 575

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	SUM(TIER3_PRODUCT_COUNT) AS TotalProds
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	TIER3_CATEGORY_DISPLAY_NAME ,
					TIER3_CATEGORY_URL_ID ,
					TIER3_ID ,
					TIER3_PRODUCT_COUNT
			FROM	VARIABLES.ShowroomCategoriesQuery
			WHERE	TIER2_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 132315

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
			SELECT	TIER3_CATEGORY_DISPLAY_NAME ,
					TIER3_CATEGORY_URL_ID ,
					TIER3_ID ,
					TIER3_PRODUCT_COUNT
			FROM	VARIABLES.ShowroomCategoriesQuery
			WHERE	TIER2_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133502

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 11:55:04.004
           	SELECT		DISTINCT TOP 1
			   			Video.Video_ID,
			   			Video.Video_Type_ID,
			   			Video.Video_Title,
			   			Video.Video_Description,
			   			Case When Video_Type_ID = 'upload' then VideoImageURL ELSE Image_Path END AS Image_Path,
			   			Image_Name,
			   			NEWID()
            FROM		Video
						LEFT OUTER JOIN IMAGES
							ON images.image_id = video.video_image_id
			WHERE		video_active = '1'
           				AND video_company_id = ?
            ORDER BY	NEWID()
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203567

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=5) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 11:55:04.004
			SELECT		TOP 5
						a.Press_Release_id, Title
			FROM		Press_Release a
						INNER JOIN press_release_market b
							ON a.press_release_id = b.press_release_id
			WHERE		Company_ID = ?
						AND Press_Release_Type_ID = 'Company_News'
			        	AND (Press_Release_Date > ? AND Press_Release_Date <?)
	    		    	AND market_id = ?
			ORDER BY	Press_Release_Date DESC, Title
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203567
Parameter #2(cf_sql_date) = {ts '2014-08-04 00:00:00'}
Parameter #3(cf_sql_date) = {ts '2015-08-04 00:00:00'}
Parameter #4(cf_sql_integer) = 1

Press_Release (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomArticle.cfm @ 11:55:04.004
		Select Press_Release_ID, Title, Press_Release_Date, Content, Press_Release.Image_id, Image_Name, Image_Path, press_release_external_url, press_release_external_url_name
		from Press_Release
		left outer join images on images.image_id = Press_Release.Image_id
		where Press_Release_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7575

Press_Release_Product (Datasource=Ava_Fenster, Time=1ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomArticle.cfm @ 11:55:05.005
		SELECT DISTINCT dbo.PRESS_RELEASE_PRODUCT.Press_Release_ID, dbo.PRESS_RELEASE_PRODUCT.Product_ID, 
		dbo.product_translation.Model_Part_Number as Model_Number,
	    dbo.product_translation.Product_Display_Name,
		dbo.PRODUCT.Manufacturer_ID, dbo.PRODUCT.Accessory, dbo.PRODUCT.Product_URL_ID
		FROM  dbo.PRESS_RELEASE_PRODUCT
		INNER JOIN dbo.PRODUCT ON dbo.PRESS_RELEASE_PRODUCT.Product_ID = dbo.PRODUCT.Product_ID
		INNER JOIN dbo.PRODUCT_TRANSLATION ON PRODUCT_TRANSLATION.Product_ID = dbo.PRODUCT.Product_ID
		INNER JOIN dbo.MANUFACTURER_LINE_MEMBERS ON dbo.PRESS_RELEASE_PRODUCT.Product_ID = dbo.MANUFACTURER_LINE_MEMBERS.Product_ID
		INNER JOIN dbo.MANUFACTURER_LINE ON dbo.MANUFACTURER_LINE_MEMBERS.Manufacturer_Line_ID = dbo.MANUFACTURER_LINE.Manufacturer_Line_ID
		WHERE dbo.PRESS_RELEASE_PRODUCT.Press_Release_ID = ?
		AND dbo.MANUFACTURER_LINE.Market_ID = ?
		AND dbo.PRODUCT_TRANSLATION.Language_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7575
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 1


Stored Procedures

GetCatalogDetail (Datasource=Ava_Fenster, Time=3ms) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 11:55:04.004

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  575    
    
resultsets
nameresultset
 LOCAL.Q  1
GetCategoriesForCatalog_BuildMenu (Datasource=Ava_Fenster, Time=17ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:55:04.004
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  2575    
 IN  cf_sql_integer  575    
 IN  cf_sql_integer  1    
    
resultsets
nameresultset
 LOCAL.Q  1
getPromotions (Datasource=Ava_Fenster, Time=2ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 11:55:04.004
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  203567    
 IN  cf_sql_integer  1    
    
resultsets
nameresultset
 LOCAL.Q  1


Scope Variables

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=E:\inetpub\wwwroot\avcatalogs\avcat\CTL2575\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
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-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=TE, keep-alive
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL2575\index.cfm
QUERY_STRING=manufacturer=lutron-electronics-company&prid=7575
REMOTE_ADDR=204.2.187.68
REMOTE_HOST=204.2.187.68
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/CTL2575/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=42381268
CFTOKEN=4aa99a4807a14c55-BE3F574A-5056-A129-7656C9ABF2A5DF3F
USERINFOMRC=0,0
Session Variables:
opts=Struct (38)
sessionid=4B4E665B3BC8DAB5637EF281174005A7.cfusion
showroom=Struct (20)
urltoken=CFID=42381268&CFTOKEN=4aa99a4807a14c55-BE3F574A-5056-A129-7656C9ABF2A5DF3F&jsessionid=4B4E665B3BC8DAB5637EF281174005A7.cfusion
userinfo=Struct (8)
userinfomrc=Struct (15)
URL Parameters:
manufacturer=lutron-electronics-company
prid=7575
Debug Rendering Time: 100 ms