Pro AV Catalog

Autocue-QTV

Search in Manufacturer
Featured Video
Autocue on BroadcastShow at IBC 2013 - DSLR Teleprompter Spotlight
Mark Shoesmith, Autocue's Head of Hardware, explains our brand new DSLR teleprompter, it's camera mounting system and our very own prompting app on BroadcastShow at IBC2013. Follow us on twitter: https://twitter.com/AutocueQTV Like us on Facebook: https://www.facebook.com/AutocueQTV Read our blog!: http://www.autocue.com/blog
Autocue-QTV
124 West 30th Street
Suite 312
New York, NY 10001
(212) 929-7755
www.autocue.com
loading


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


Execution Time

Total Time Avg Time Count Template
327 ms 327 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/CTL2575/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
290 ms 290 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
201 ms 201 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/Showroom.cfm
116 ms 116 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomMenu.cfm
44 ms 44 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
39 ms 39 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
28 ms 28 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
27 ms 27 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/CTL2575/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
26 ms 26 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomRFI.cfm
15 ms 15 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier2Cats() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
13 ms 13 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomNewsNav.cfm
11 ms 11 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getShowroomCategories() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
10 ms 10 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getShowroomOptions(2575, 250) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getManufacturer(autocue-qtv, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.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 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/nomad/base-global-options.cfc | getCatalogLevel(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomVideoBox.cfm
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(250) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldURLs(autocue-qtv, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getVideo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getPromotions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
6 ms 6 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/application-request-start.cfc | getTreatmentOptions([complex value], 2575) ] 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(2575, MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
5 ms 5 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/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/application-request-start.cfc | getMRCOptions(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getProdCount() ] 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(132281) ] 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(133505) ] 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(133509) ] 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 | 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 | 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 | 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(132272) ] 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(133471) ] 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(133494) ] 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(133495) ] 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(133496) ] 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(133497) ] 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/showroom/showroommenu.cfc | getTier3Cats(133763) ] 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(133795) ] 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(133797) ] 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 | 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(203169) ] 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(203308) ] 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
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/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
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/UDF/udf_library.cfc | makeMetaDescription(Contact Autocue-QTV for more information) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.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/nomad/base-global-options.cfc | handleReturnToURL(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setArticle(0) ] 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 | setIsDistributor() ] 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 | setVarLink() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.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/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 | makeMetaTitle(Contact Autocue-QTV 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/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 | createDynamicListArray(2575) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.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 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/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 | 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(203225) ] 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 | 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=autocue-qtv) ] 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 | 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(250) ] 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(203225) ] 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/CTL2575/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
6 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
362 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:53.053
			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:53.053
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56:53.053
			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=4ms, Records=8851, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56:53.053
			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:53.053
			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 @ 15:56:53.053
			{ CALL GetALLMRCSAndOptions() }
		
LOCAL.R (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:56:53.053
			SELECT	*
			FROM	VARIABLES.GetALLMRCSAndOptions
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

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

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

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

QMRC (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:53.053
			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=2ms, Records=8744, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:53.053
			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:53.053
				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=0ms, Records=753, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:56:53.053
			{ 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:53.053
	     	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 @ 15:56:53.053
			{ CALL GETAds (
				? ,
				'groupA' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2575

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:56:53.053
			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=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:56:53.053
			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 @ 15:56:53.053
			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 @ 15:56:53.053
			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 @ 15:56:53.053
			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 @ 15:56:53.053
			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 @ 15:56:53.053
			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 @ 15:56:53.053
			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 @ 15:56:53.053
			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=16) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:53.053
			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:53.053
			SELECT	SUM(TIER3_NEW_PRODUCT_COUNT) AS TotalProds
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:53.053
			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) = 203225
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:53.053
			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) = 203225
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:53.053
			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) = 250

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

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

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

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

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

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

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

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

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

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

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

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

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

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 15:56:53.053
			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) = 203225
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=8ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomRFI.cfm @ 15:56:53.053
			    	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 = 203225 and Address_Type_ID = 'Display2'
			    


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  250    
    
resultsets
nameresultset
 LOCAL.Q  1
GetCategoriesForCatalog_BuildMenu (Datasource=Ava_Fenster, Time=10ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 15:56:53.053
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  2575    
 IN  cf_sql_integer  250    
 IN  cf_sql_integer  1    
    
resultsets
nameresultset
 LOCAL.Q  1
getPromotions (Datasource=Ava_Fenster, Time=5ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 15:56:53.053
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  203225    
 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=autocue-qtv&rfi=1
REMOTE_ADDR=23.0.160.47
REMOTE_HOST=23.0.160.47
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=42460227
CFTOKEN=827c72c88977b-C6E52567-5056-A129-76CBF0640F4B02F3
USERINFOMRC=0,0
Session Variables:
captcha_key=59D9B274381419240B032D40FEF25AA7
opts=Struct (38)
sessionid=7FCB215D320BB05D5765B5629C1DADFE.cfusion
showroom=Struct (20)
urltoken=CFID=42460227&CFTOKEN=827c72c88977b-C6E52567-5056-A129-76CBF0640F4B02F3&jsessionid=7FCB215D320BB05D5765B5629C1DADFE.cfusion
userinfo=Struct (8)
userinfomrc=Struct (15)
URL Parameters:
manufacturer=autocue-qtv
rfi=1
Debug Rendering Time: 73 ms