Sign Up for a Free My-iQ Account
It takes less than a minute, and here's what you'll get:
Save Items to Project Lists
By saving items to project lists, you can easily create, manage and share project lists.
Access MSRP Pricing
Many of our manufacturers provide MSRP pricing. As a registered user you’ll have access to this important piece of information.
Stay Updated
Get updates from manufacturers and stay up to date with the latest news from the industry leading sources.
Easily Compare
Using the comparison tool, you can add a limitless number of products to compare side by side.
Sign up below:
Tell us about yourself

Email is not valid or already exists

Your password needs to contain the following:

  At least six characters
  At least one letter
  At least one number
By clicking Create Your Account you are agreeing to the Terms & Conditions


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


Execution Time

Total Time Avg Time Count Template
117 ms 117 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
102 ms 102 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.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
39 ms 39 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
23 ms 23 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfm
22 ms 22 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
16 ms 16 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration-form.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-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/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/application-request-start.cfc | checkIsNomad(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getEmployerTypes() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.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(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/nomad/myiq-registration/registration.cfc | getPositions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.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(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203198) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(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(203450) ] 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 | getPINOptions(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.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 | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-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 | getLanguageID(en) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.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(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 | handleReturnToURL(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
1 ms 1 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/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/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 | 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 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/myiq-registration/registration.cfc | getCountryOptions(Select Country) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getMaxlengthInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getStateOptions(Work State / Province) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.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-javascript-caller.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/myiq-registration/login-ad.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.css
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
6 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
147 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=47, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 15:51:09.009
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=0ms, Records=735, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:51:09.009
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:51:09.009
			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 @ 15:51:09.009
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:51:09.009
			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 @ 15:51:09.009
			{ 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 @ 15:51:09.009
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:51:09.009
				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 @ 15:51:09.009
			{ CALL GetCatalogDetailALL_PIN }
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:51:09.009
	     	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:51:09.009
			{ 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 @ 15:51:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203122

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:51:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203177

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:51:09.009
			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 @ 15:51:09.009
			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:51:09.009
			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 @ 15:51:09.009
			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 @ 15:51:09.009
			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 @ 15:51:09.009
			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=26) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\myiq-registration\registration.cfc @ 15:51:09.009
			SELECT		Employer_Type_ID,
						Employer_Type_Name
			FROM		MyiQ_Employer_Types
			WHERE		Employer_Type_ID > 10
			ORDER BY	Employer_Type_Name
		
LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=19) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\myiq-registration\registration.cfc @ 15:51:09.009
			SELECT		Position_ID,
						Position_Name
			FROM		MyiQ_Positions
			WHERE		Position_ID > 10
			ORDER BY	Position_Name
		


Stored Procedures

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

    
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=myiq.reg
REMOTE_ADDR=216.156.199.36
REMOTE_HOST=216.156.199.36
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=42458349
CFTOKEN=4dcbfbbc068b52fa-C6B0AB9E-5056-A129-767A26120AC04AAD
USERINFO=0,0
Session Variables:
opts=Struct (37)
sessionid=1DC907CF77041342603729818748A6E4.cfusion
urltoken=CFID=42458349&CFTOKEN=4dcbfbbc068b52fa-C6B0AB9E-5056-A129-767A26120AC04AAD&jsessionid=1DC907CF77041342603729818748A6E4.cfusion
userinfo=Struct (16)
userinfomrc=Struct (3)
URL Parameters:
myiq.reg=
Debug Rendering Time: 53 ms