Pro AV Catalog

Shure Incorporated

Search in Manufacturer
Featured Video
Mike Clink - The Shure
For more than 20 years, record producer and engineer has Mike Clink has worked with artists and bands who has sold over 70 million records worldwide. He has worked with bands like Metallica, Aerosmith, Guns N' Roses and Megadeth among many others. He sat down with Shure to reflect on some of his experiences in the studio and share some insight for aspiring engineers and producers.
What's new at Shure Incorporated
Understanding Mic Specifications - Part 2 - Frequency Response
Video posted on 26-Mar-12
Save to Project
Understanding Mic Specification Part 2 by Shure. We discuss the Frequency Response -- why microphones sound different. Video 2 of 4.


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


Execution Time

Total Time Avg Time Count Template
266 ms 266 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl788/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
246 ms 246 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
199 ms 199 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/Showroom.cfm
142 ms 142 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomMenu.cfm
27 ms 27 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl788/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
24 ms 24 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier2Cats() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
23 ms 23 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
20 ms 20 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getShowroomCategories() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
9 ms 9 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
8 ms 8 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomNewsNav.cfm
8 ms 8 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomVideo.cfm
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(788, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(788) ] 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 | getTreatmentOptions([complex value], 788) ] 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 | getCatalogDetailMRC(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getNewProdCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getNewsCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(133486) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(133492) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
5 ms 5 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomVideoBox.cfm
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getMRCOptions(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionMRC(788, MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getShowroomOptions(788, 88) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getPromotions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(132220) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(133501) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier3Cats(133514) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
4 ms 4 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
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 | getBimCount() ] 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(132253) ] 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(132324) ] 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(132377) ] 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(132397) ] 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(132404) ] 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(133388) ] 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(133463) ] 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(133483) ] 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(133487) ] 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(133490) ] 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(133504) ] 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(133510) ] 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(133854) ] 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(133870) ] 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 | getVideoCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
3 ms 3 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/contactus.cfm
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldURLs(shure-incorporated, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getPressReleases() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(88) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getManufacturer(shure-incorporated, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | createDynamicListArray(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | startSession() ] 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(videos, 2198) ] 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 | setCategoryTree(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCompanyID(203056) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | setMarketID(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
1 ms 1 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 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-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(788) ] 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(Shure Incorporated - Understanding Mic Specifications - Part 2 - Frequency Response - Audio Visual Associates) ] 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(Shure Incorporated - Understanding Mic Specifications - Part 2 - Frequency Response - Audio Visual Associates) ] 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/ctl788/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(788) ] 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 | getCatalogType(788) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateReturnToURL(MRC) ] 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/ctl788/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(788) ] 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(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 | setCatID(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 | 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=shure-incorporated) ] 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(2198) ] 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(88) ] 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(203056) ] 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 | setParentCatID(788) ] 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(P) ] 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/CTL788/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL788/index-top.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/base-javascript-caller.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
5 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
299 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 @ 15:56:55.055
			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 @ 15:56:55.055
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56:55.055
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 788

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

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

qmlcFind (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56:55.055
			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) = shure-incorporated
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=0ms, Records=1, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 15:56:55.055
			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) = shure-incorporated
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:55.055
			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) = 88

QMRC (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:55.055
			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) = 788

Q (Datasource=Ava_Fenster, Time=2ms, Records=8744, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:55.055
			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 @ 15:56:55.055
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 788

MasterGetCatalogDetailMRC (Datasource=Ava_Fenster, Time=1ms, Records=753, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:55.055
			{ CALL GetCatalogDetailALL_MRC }
		
LOCAL.R (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:55.055
	     	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) = 788

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

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=19) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			SELECT	DISTINCT
					TIER2_CATEGORY_DISPLAY_NAME ,
					TIER2_CATEGORY_URL_ID ,
					TIER2_ID ,
					TIER2_PRODUCT_COUNT
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			SELECT	SUM(TIER3_NEW_PRODUCT_COUNT) AS TotalProds
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 203056
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 @ 15:56:55.055
			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) = 203056
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 @ 15:56:55.055
			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) = 88

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			SELECT	SUM(TIER3_PRODUCT_COUNT) AS TotalProds
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 132404

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=7) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 132220

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133492

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133501

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133483

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=14) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133486

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 132324

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133388

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133504

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133510

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 132253

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133487

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
			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) = 133854

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=6) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:56.056
			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) = 132377

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:56.056
			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) = 133870

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:56.056
			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) = 133490

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:56.056
			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) = 133463

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:56.056
			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) = 132397

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:56.056
			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) = 133514

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 15:56:56.056
           	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) = 203056

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=5) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 15:56:56.056
			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) = 203056
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

Preview_Company_Video (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 15:56:56.056
		select Video_ID, video_type_id, video_start_Date, video_source, video_title, video_description
		from video
		where dbo.VIDEO.Video_ID = ?
		order by Modify_Date desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2198

Related_Press_Releases (Datasource=Ava_Fenster, Time=1ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 15:56:56.056
		SELECT DISTINCT dbo.VIDEO.Video_ID, dbo.PRESS_RELEASE.Press_Release_ID, dbo.PRESS_RELEASE.Title, dbo.VIDEO_COMPANY.Video_Mapping_ID, dbo.VIDEO.Video_Title,
		dbo.PRESS_RELEASE.Company_ID,dbo.PRESS_RELEASE.Press_Release_Date
		FROM  dbo.Press_Release_Market
		INNER JOIN dbo.PRESS_RELEASE ON dbo.Press_Release_Market.Press_Release_ID = dbo.PRESS_RELEASE.Press_Release_ID
		LEFT OUTER JOIN dbo.VIDEO
		INNER JOIN dbo.VIDEO_COMPANY ON dbo.VIDEO.Video_ID = dbo.VIDEO_COMPANY.Video_ID
		INNER JOIN dbo.VIDEO_COMPANY AS VIDEO_COMPANY_1 ON dbo.VIDEO.Video_ID = VIDEO_COMPANY_1.Video_ID ON
		dbo.PRESS_RELEASE.Press_Release_ID = dbo.VIDEO_COMPANY.Video_Mapping_Value
		WHERE dbo.VIDEO_COMPANY.Video_Mapping_ID = 'press_release' AND dbo.VIDEO.Video_ID = ?
		AND VIDEO_COMPANY_1.Video_Mapping_ID = 'marketid'
		AND VIDEO_COMPANY_1.Video_Mapping_Value = ?
		AND dbo.Press_Release_Market.Market_ID = ?
		ORDER BY dbo.PRESS_RELEASE.Press_Release_Date DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2198
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 1

Related_products (Datasource=Ava_Fenster, Time=1ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 15:56:56.056
		SELECT	DISTINCT VIDEO_COMPANY.Video_ID,
				VIDEO_COMPANY.Video_Mapping_ID,
				VIDEO_COMPANY.Video_Mapping_Value,
				PRODUCT.Model_Number,
				PRODUCT.Product_Display_Name,
				PRODUCT.Manufacturer_ID,
				PRODUCT.Accessory,
				PRODUCT.Product_URL_ID,
				CATALOG.Catalog_URL_ID
		FROM	VIDEO_COMPANY
				INNER JOIN dbo.PRODUCT
					ON  VIDEO_COMPANY.Video_Mapping_Value = dbo.PRODUCT.Product_ID
						AND VIDEO_COMPANY.Video_Mapping_ID = 'product'
						AND PRODUCT.Discontinued_Date IS NULL
				INNER JOIN MANUFACTURER_LINE_MEMBERS
					ON VIDEO_COMPANY.Video_Mapping_Value = MANUFACTURER_LINE_MEMBERS.Product_ID
				INNER JOIN MANUFACTURER_LINE
					ON MANUFACTURER_LINE_MEMBERS.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID
						AND MANUFACTURER_LINE.Market_ID = ?
				INNER JOIN CATALOG
					ON PRODUCT.Manufacturer_ID = CATALOG.Catalog_Company_ID
						AND CATALOG.Market_ID = ?
		WHERE	VIDEO_COMPANY.Video_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 1
Parameter #3(CF_SQL_INTEGER) = 2198


Stored Procedures

GetCatalogDetail (Datasource=Ava_Fenster, Time=0ms) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 15:56:55.055

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  88    
    
resultsets
nameresultset
 LOCAL.Q  1
GetCategoriesForCatalog_BuildMenu (Datasource=Ava_Fenster, Time=19ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  788    
 IN  cf_sql_integer  88    
 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 @ 15:56:56.056
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  203056    
 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\CTL788\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\CTL788\index.cfm
QUERY_STRING=manufacturer=shure-incorporated&video=2198
REMOTE_ADDR=165.254.210.127
REMOTE_HOST=165.254.210.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/ctl788/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=42460246
CFTOKEN=262185386f0cffab-C6E58FD8-5056-A129-76B602F99E242F43
USERINFOMRC=0,0
Session Variables:
opts=Struct (38)
sessionid=B6E266FF80FB0C4EB22DC414E2F2043E.cfusion
showroom=Struct (20)
urltoken=CFID=42460246&CFTOKEN=262185386f0cffab-C6E58FD8-5056-A129-76B602F99E242F43&jsessionid=B6E266FF80FB0C4EB22DC414E2F2043E.cfusion
userinfo=Struct (8)
userinfomrc=Struct (15)
URL Parameters:
manufacturer=shure-incorporated
video=2198
Debug Rendering Time: 76 ms