Contact Us: 305-669-1117 / info@midtownvideo.com

Sales

Pro AV Catalog

ELMO USA Corp.


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


Execution Time

Total Time Avg Time Count Template
228 ms 228 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl704/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
204 ms 204 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
141 ms 141 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/Showroom.cfm
82 ms 82 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomMenu.cfm
25 ms 25 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl704/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
25 ms 25 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
21 ms 21 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
17 ms 17 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
13 ms 13 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getTier2Cats() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(704) ] 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(704, 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(704) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getShowroomCategories() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
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-request-start.cfc | handleOldURLs(elmo-usa, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
7 ms 7 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomNewsNav.cfm
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 704) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getShowroomOptions(704, 93) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(704) ] 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(704, 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(704) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getMRCOptions(704) ] 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 | getTier3Cats(132299) ] 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(133388) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203126) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomVideoBox.cfm
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getPromotions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | getVideo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getNewProdCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | 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(132295) ] 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(132349) ] 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(133506) ] 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(133507) ] 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(133768) ] 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(203152) ] 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(203623) ] 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-request-go.cfc | getCatalog(93) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getManufacturer(elmo-usa, 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 | getPressReleases() ] 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 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getMarketID(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.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-session.cfc | updateReturnToURL(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | getBotWords() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(704) ] 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 | init() ] 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(203061) ] 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 | getNewsCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroommenu.cfc | getVideoCount() ] 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/topnav/products-content.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getCatalogType(704) ] 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 | 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(ELMO USA Corp. - Use the ELMO wireless tablet as a Mobile Interactive Whiteboard - Midtown Video) ] 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(ELMO USA Corp. - Use the ELMO wireless tablet as a Mobile Interactive Whiteboard - Midtown Video) ] 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/ctl704/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(704) ] 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(704) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(704) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(704) ] 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/ctl704/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 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/list/list.cfc | makeListButton(videos, 1316) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/list/list.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(704) ] 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 | 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 | 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=elmo-usa) ] 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(1316) ] 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(93) ] 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(203061) ] 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(704) ] 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/CTL704/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL704/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
260 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=47, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 11:54:26.026
			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 @ 11:54:26.026
			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 @ 11:54:26.026
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 704

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

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

qmlcFind (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:26.026
			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) = elmo-usa
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 @ 11:54:26.026
			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) = elmo-usa
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:26.026
			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) = 93

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

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

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

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

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:26.026
			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) = 203152

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:26.026
			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) = 203126

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:26.026
			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) = 203623

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=10) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:54:26.026
			SELECT	DISTINCT
					TIER2_CATEGORY_DISPLAY_NAME ,
					TIER2_CATEGORY_URL_ID ,
					TIER2_ID ,
					TIER2_PRODUCT_COUNT
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:54:26.026
			SELECT	SUM(TIER3_NEW_PRODUCT_COUNT) AS TotalProds
			FROM	VARIABLES.ShowroomCategoriesQuery
		
LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=1, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:54:26.026
			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) = 203061
Parameter #2(cf_sql_integer) = 1

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=1, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:54:26.026
			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) = 203061
Parameter #2(cf_sql_integer) = 1

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:54:26.026
			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) = 93

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

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

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

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

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

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

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

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroom.cfc @ 11:54:26.026
			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) = 203061
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 @ 11:54:26.026
		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) = 1316

Related_Press_Releases (Datasource=Ava_Fenster, Time=2ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 11:54:26.026
		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) = 1316
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 1

Related_products (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 11:54:26.026
		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) = 1316


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  93    
    
resultsets
nameresultset
 LOCAL.Q  1
GetCategoriesForCatalog_BuildMenu (Datasource=Ava_Fenster, Time=7ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\showroommenu.cfc @ 11:54:26.026
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  704    
 IN  cf_sql_integer  93    
 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 @ 11:54:26.026
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  203061    
 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\CTL704\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\CTL704\index.cfm
QUERY_STRING=manufacturer=elmo-usa&video=1316
REMOTE_ADDR=204.2.187.68
REMOTE_HOST=204.2.187.68
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/ctl704/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=42381076
CFTOKEN=dad726ff011f9c9d-BE397CC0-5056-A129-76415CABCA47978A
USERINFOMRC=0,0
Session Variables:
opts=Struct (38)
sessionid=4341ADC5042B71A16DF79B78D2505B80.cfusion
showroom=Struct (20)
urltoken=CFID=42381076&CFTOKEN=dad726ff011f9c9d-BE397CC0-5056-A129-76415CABCA47978A&jsessionid=4341ADC5042B71A16DF79B78D2505B80.cfusion
userinfo=Struct (8)
userinfomrc=Struct (15)
URL Parameters:
manufacturer=elmo-usa
video=1316
Debug Rendering Time: 70 ms