Welcome to the New AV-iQ

Search the World's Most Powerful AV Product Database
with over 447,477 Products from Hundreds of Manufacturers

New Products

Every day, manufacturers in AV-iQ introduce new products to the marketplace. Here's an easy way to search a list of those products from the last 90 days or view last month's new product announcements.

Featured Case Study

Adwar Video provides a complete multi-faceted Audio Visual system for a premier presentation space.

The Founders Auditorium at Medgar Evers College is an important dual-use instructional and performance venue for the school. Educational instruction and lectures are given by day. Plays and concerts are performed after hours. The challenge was to provide a system that covered all of these roles while remaining easy to use.

Enter search words
New Products
Featured Case Study
Sponsors
AMX BOXLIGHT Da-Lite Screen Company, Inc. Chief Califone International, Inc. Sony Professional Solutions of America Crestron Electronics, Inc. Eiki International, Inc Cables to Go Williams Sound
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 SpinitarPro Sound & VideoAvidex Industries, LLCTechnical Innovation, LLC

Recent News

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


Debugging Information
ColdFusion Server Enterprise 10,0,16,293499
Template /avcat/ctl1642/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
284 ms 284 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
269 ms 269 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
190 ms 190 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfm
83 ms 83 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/categories.cfm
51 ms 51 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/featured.cfm
48 ms 48 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header.cfm
45 ms 45 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav.cfm
38 ms 38 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
26 ms 26 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getCategoriesJSONToQuery() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
23 ms 23 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
17 ms 17 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(1642) ] 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(1642, 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(1642) ] 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(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionRRC(1642, RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierOnes() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/news.cfm
5 ms 5 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/providers.cfm
5 ms 5 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/welcome-pin.cfm
4 ms 4 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
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeatured() ] 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(203180) ] 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 | getFeaturedDetail(206548) ] 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(133883) ] 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(133884) ] 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(133885) ] 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(133888) ] 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(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(133896) ] 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(133897) ] 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(133898) ] 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(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(203450) ] 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 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/contactus.cfm
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203122) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203146) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203428) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(305760) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getProviders() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133886) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133887) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133890) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133894) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133895) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.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(203130) ] 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(203202) ] 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(207407) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 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
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 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 | getPINOptions(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(RRC) ] 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 | getExclusionKeyList() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.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/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-google-analytics-code.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-javascript-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products-content.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getCatalogType(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-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(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.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.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/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-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/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/home/Slide2.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
8 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
317 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:19.019
			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:19.019
			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:19.019
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

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

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

Q (Datasource=Ava_Fenster, Time=2ms, Records=8744, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:19.019
			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:19.019
				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=4, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:19.019
			{ CALL GetCatalogDetailALL_PIN }
		
LOCAL.R (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:19.019
	     	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 @ 11:54:19.019
			{ CALL GETAds (
				? ,
				'groupK' ,
				'0' ,
				'0'
			) }
		
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\nomad\topnav\mans.cfc @ 11:54:19.019
			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=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:19.019
			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) = 203450

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:19.019
			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=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:19.019
			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=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:19.019
			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 @ 11:54:19.019
			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 @ 11:54:19.019
			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=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:19.019
			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=2ms, Records=10) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			{ CALL GETAds (
				? ,
				'groupA',
				'0',
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

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

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

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

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

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

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

LOCAL.TierOnes (Datasource=Ava_Fenster, Time=4ms, Records=16) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			SELECT		DISTINCT
						TIER1_ID ,
						
						
							TIER1_NAME ,
							UPPER(TIER1_NAME) AS OrderName
						
						
			FROM		VARIABLES.GetCategories
			ORDER BY	OrderName ASC
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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 @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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 @ 11:54:19.019
			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=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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 @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			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 @ 11:54:19.019
			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=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 11:54:19.019
			{ CALL GETAds (
				? ,
				'listing',
				'0',
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  1642    
    
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=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\CTL1642\index.cfm
QUERY_STRING=
REMOTE_ADDR=204.2.187.68
REMOTE_HOST=204.2.187.68
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.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=42381048
CFTOKEN=255f17f6b8710713-BE3876C6-5056-A129-7635B1AF51E0FEE5
USERINFO=0,0
Session Variables:
opts=Struct (37)
sessionid=E784461D44A1B68B10BA97721095BF4B.cfusion
urltoken=CFID=42381048&CFTOKEN=255f17f6b8710713-BE3876C6-5056-A129-7635B1AF51E0FEE5&jsessionid=E784461D44A1B68B10BA97721095BF4B.cfusion
userinfo=Struct (16)
userinfomrc=Struct (3)
Debug Rendering Time: 67 ms