Pro AV Catalog

Shure Incorporated

Search in Manufacturer
Featured Video
How to Install a Shure Microflex Wireless Access Point
This video will cover best practices when installing the Shure Microflex Wireless Access Point. Knowing where and how to install the MXW Access Point will result in ideal wireless performance. We'll explain mounting options, antenna pattern, and antenna placement.
What's new at Shure Incorporated
Shure Incorporated
5800 W. Touhy Avenue
Niles, IL 60714-4608
(847)600-2000
www.shure.com


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


Execution Time

Total Time Avg Time Count Template
304 ms 304 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/AVCAT/CTL2830/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
282 ms 282 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
233 ms 233 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/Showroom.cfm
130 ms 130 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomMenu.cfm
55 ms 55 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomRFI.cfm
25 ms 25 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier2Cats() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
24 ms 24 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/AVCAT/CTL2830/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
24 ms 24 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(2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomNewsNav.cfm
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(2830, 1) ] 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(2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
6 ms 6 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(2830) ] 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(2830) ] 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], 2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionMRC(2830, MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.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/nomad/base-global-options.cfc | getShowroomOptions(2830, 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 | getPressReleases() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getVideo() ] 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(133388) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
4 ms 4 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/contactus.cfm
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(88) ] 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(shure-incorporated, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.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 | 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(132220) ] 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(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(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(133486) ] 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(133492) ] 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(133501) ] 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(133514) ] 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 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedForDealer() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 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
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/showroom/showroom.cfc | getPromotions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.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 | getNewsCount() ] 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 | getTier3Cats(132324) ] 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 | getTier3Cats(133510) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.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.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/base-global-options.cfc | handleReturnToURL(2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.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/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(2830) ] 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(Contact Shure Incorporated for more information) ] 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(Contact Shure Incorporated for more information) ] 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/CTL2830/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(2830) ] 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 | createDynamicListArray(2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(2830) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(2830) ] 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 | 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/CTL2830/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(2830) ] 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 | 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(203056) ] 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(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 | 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(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 | 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(2830) ] 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/CTL2830/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL2830/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/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
7 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
336 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:04.004
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=0ms, Records=735, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56:04.004
			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:04.004
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2830

Q (Datasource=Ava_Fenster, Time=3ms, Records=8851, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56: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 @ 15:56:04.004
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2830

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

displayAddress2 (Datasource=Ava_Fenster, Time=4ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomRFI.cfm @ 15:56:04.004
			    	select company_address.*, COMPANY_PHONE.Company_Phone
			        from company_address 
			        left outer join COMPANY_PHONE on company_address.Company_ID = COMPANY_PHONE.Company_ID and Phone_Type_ID = 'Display2'
			        where company_address.company_id = 203056 and Address_Type_ID = 'Display2'
			    


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  88    
    
resultsets
nameresultset
 LOCAL.Q  1
GetCategoriesForCatalog_BuildMenu (Datasource=Ava_Fenster, Time=18ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:04.004
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  2830    
 IN  cf_sql_integer  88    
 IN  cf_sql_integer  1    
    
resultsets
nameresultset
 LOCAL.Q  1
getPromotions (Datasource=Ava_Fenster, Time=1ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 15:56:04.004
    
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\CTL2830\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\CTL2830\index.cfm
QUERY_STRING=manufacturer=shure-incorporated&rfi=1
REMOTE_ADDR=216.156.199.36
REMOTE_HOST=216.156.199.36
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AVCAT/CTL2830/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=42459977
CFTOKEN=4c5cce1ac375b304-C6DDACF7-5056-A129-7656C84433DC31D9
USERINFOMRC=0,0
Session Variables:
captcha_key=6E82FDE21CFECDA436A7FDE91D89FC6B
opts=Struct (38)
sessionid=035517C1B58AC6F69F98861E98E73365.cfusion
showroom=Struct (20)
urltoken=CFID=42459977&CFTOKEN=4c5cce1ac375b304-C6DDACF7-5056-A129-7656C84433DC31D9&jsessionid=035517C1B58AC6F69F98861E98E73365.cfusion
userinfo=Struct (8)
userinfomrc=Struct (15)
URL Parameters:
manufacturer=shure-incorporated
rfi=1
Debug Rendering Time: 70 ms