Over 447,338 Products

AV-iQ is the largest, most comprehensive database of AV product information ever assembled and delivers that information with powerful search tools. AV installers, designers, architects and sales professional have come to trust AV-iQ as the fastest and best way to begin their projects.

Featured New Product

Fixed Frame Screen

Parallax Thin features the Parallax 0.8 surface for standard throw projection, and ships already assembled with a thin-bezeled frame.

See new products from the last 90 days or last month's new product announcement.

Featured Case Study

in Clinton, NJ
by Kramer Electronics USA, Inc.
Putting into practice an effective S.T.E.A.M. program is a challenge at any level, but Valdosta State University was able to master it by creating a high−technology interface using Kramer Electronics products. S.T.E.A.M., which stands for Science, Technology, Engineering, Arts, and Mathematics, is the core discipline subject group for today’s technology−driven education and workforce readiness.
Free My-iQ Account
Featured New Product
Featured Case Study
Sponsors
Chief Crestron Electronics, Inc. ClearOne Audio Visual Furniture International Inc. AmpliVox Sound Systems Sony Professional Solutions of America Eiki International, Inc Da-Lite Screen Company, Inc.
Your Search Ends Here
All the Product Information You Need All in One Place

Browse Categories

Find an AV Service Provider

Search the Best Pro-AV Service Providers in Your Area

  • 1. What Type of AV Service?
  • 2. Enter Your Zip Code
Featured Service Providers VISTACOMSpinitarAvidex Industries, LLCAVI-SPLFord Audio-Video

Recent News

All of the Latest News from Important Voices in the AV Industry


Debugging Information
ColdFusion Server Enterprise 10,0,19,298511
Template /avcat/ctl1642/index.cfm
Time Stamp 26-Sep-16 03:02 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.196.223.42
Host Name 54.196.223.42


Execution Time

Total Time Avg Time Count Template
355 ms 355 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
339 ms 339 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
230 ms 230 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfm
103 ms 103 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/categories.cfm
57 ms 57 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header.cfm
53 ms 53 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav.cfm
51 ms 51 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/featured.cfm
47 ms 47 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
28 ms 28 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getCategoriesJSONToQuery() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
27 ms 27 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
24 ms 24 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/welcome-pin.cfm
19 ms 19 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
18 ms 18 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/Slide2.cfm
17 ms 17 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedProductForSlide() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
11 ms 11 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfm
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(1642, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierOnes() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getCountryOptions(Select Country) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedProductsForSlideMasterQuery() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailPIN(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203255) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(300113) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133883) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133884) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133885) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133886) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133887) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133888) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133895) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133896) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133897) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133898) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203122) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203603) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
5 ms 5 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/news.cfm
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getPINOptions(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionRRC(1642, RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203054) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203122) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203130) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203198) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133889) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133890) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133891) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133892) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133893) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133894) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203130) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203198) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(204646) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(207407) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/providers.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/nomad/base-global-options.cfc | handleReturnToURL(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.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/home/Slide1.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/application-request-go.cfc | getCatalog(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
1 ms 1 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
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | createDynamicListArray(1642) ] 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/contact/contact.cfc | getBasicUserInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getProdCount() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getProviders() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
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(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getIsLoggedIn(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getMarketID(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getUserID(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaDescription(The most complete audio visual equipment, AV service providers directory and industry resource center including AV equipment, installations, dealers, rentals, service providers, case studies, news and more!) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaKeywords(audio visual equipment AV services providers directory resource installations dealers rentals 3D cameras displays projectors screens mounts video production presentation systems content delivery digital signage test measurement signal management furniture consoles media manufacturers - AV-iQ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaTitle(Audio Visual Equipment, AV Service Providers Directory and Resource Center - AV-iQ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/avcat/ctl1642/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(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(1642) ] 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(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/avcat/ctl1642/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/base.cfc | createFacebookMetaData([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getStateOptions(Select State, ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.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/nomad/base-bad-css.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bottom-nav.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-footer.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-ad-setup.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-region-selector.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/zip-modal.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/exitmessage/exitmessage.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/Slide3.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/feed/feed-1.txt
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/feed/feed-2.txt
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/feed/feed-3.txt
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/feed/feed-4.txt
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home-lower-ad.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home-upper-ad.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/yoursearch.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
7 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
390 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=48, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 15:02:13.013
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=0ms, Records=163, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:13.013
			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:02:13.013
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=8767, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:13.013
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
LOCAL.R (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:13.013
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	[LOCAL].Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:13.013
			{ CALL ctlGetPINOptions(
				?
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

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

MasterGetCatalogDetailPIN (Datasource=Ava_Fenster, Time=0ms, Records=9, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:13.013
			{ CALL GetCatalogDetailALL_PIN }
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:13.013
	     	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	MasterGetCatalogDetailPIN
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

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

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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) = 203130

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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) = 203603

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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) = 207407

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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) = 203202

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:13.013
			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

VARIABLES.R (Datasource=Ava_Fenster, Time=4ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT 		Product_ID  ,
						Model_Number ,
						Product_Display_Name ,
						Short_Description ,
						Manufacturer_ID ,
						Catalog_Display_Name ,
						Image_Name ,
						Catalog_URL_ID ,
						Product_URL_ID ,
						Language_ID ,
						RowNumber ,
						RRC_ID
			FROM 		VARIABLES.MasterQuery
			WHERE 		RRC_ID = 1642 
							AND Language_ID = 1 
						
			ORDER BY	RowNumber
		
VARIABLES.S (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
				SELECT 		*
				FROM 		VARIABLES.R
				WHERE 		RowNumber = 5 
Q (Datasource=Ava_Fenster, Time=2ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			{ CALL GETAds (
				? ,
				'groupA',
				'0',
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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) = 203130

Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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) = 203255

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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) = 300113

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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) = 203054

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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) = 203202

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			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.TierOnes (Datasource=Ava_Fenster, Time=5ms, Records=16) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						TIER1_ID ,
						
						
							TIER1_NAME ,
							UPPER(TIER1_NAME) AS OrderName
						
						
			FROM		VARIABLES.GetCategories
			ORDER BY	OrderName ASC
		
LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133883

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133884

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133885

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133886

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133887

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133888

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133889

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133890

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133891

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133892

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133893

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133894

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133895

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133896

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133897

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133898

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=5, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
			{ CALL GETAds (
				? ,
				'listing',
				'0',
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.GetCountries (Datasource=Ava_Fenster, Time=4ms, Records=245) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base.cfc @ 15:02:13.013
			SELECT 		Country_Code_ID ,
						Country_Abbr , 
						Country
			FROM 		Country_Code
			ORDER BY 	Country
		


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  1642    
    
resultsets
nameresultset
 LOCAL.Q  1
GetProductFeatureHomepage (Datasource=Ava_Fenster, Time=5ms) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
    
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\CTL1642\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=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=www.av-iq.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL1642\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.196.223.42
REMOTE_HOST=54.196.223.42
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/ctl1642/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=39318103
CFTOKEN=76646e3566ce1fad-0EBF028F-5056-A165-5432E14599DA6AEC
USERINFO=0,0
Session Variables:
opts=Struct (41)
sessionid=B767676D030F03F0B83A679FC39CCCC7.catalogs
urltoken=CFID=39318103&CFTOKEN=76646e3566ce1fad-0EBF028F-5056-A165-5432E14599DA6AEC&jsessionid=B767676D030F03F0B83A679FC39CCCC7.catalogs
userinfo=Struct (14)
userinfomrc=Struct (2)
userinforrcpvd=Struct (0)
Debug Rendering Time: 91 ms