Adour Alain Ducasse - Midtown

Named for the Adour River which flows near the chef''s hometown - Adour Alain Ducasse is evidence to the great chef''s return.

Sushi Yasuda - Midtown East

Sushi Yasuda serves Southeast Asian, Japanese/Sushi cuisine designed to cater for your raw fish cravings.

Marea - Midtown West [ photo via Daniel Krieger ]

Marea means "tide" in Italian and you will struggle to find a more aptly named seafood spot, under the guiding hand of chef Michael White.

Sho Shaun Hergatt - Financial District

Sho Shaun Hergatt located in the heart of New York''s Financial District, serves outstanding contemporary Asian-French cuisine.

Katz''s Deli - Lower East Side [ photo via Yura Dashevsky ]

When seeking sacred deli space, Katz''s is as close as it gets to divine! Home to the best pastrami in NY, this world-famous eatery has been a part of New York, Jewish-American culture since 1888.

Mandarin Oriental - Upper West Side

One of New York''s finest hotels, the Mandarin Oriental features the best of the best. Every possible amenity to cater to your needs is found in it''s Asian themed rooms.

Jazz at the Lincoln Center - Upper West Side [ photo via Daryl Long ]

The Jazz at Lincoln Center experience is a truly holistic jazz experience with a selection of rooms and venues that are guaranteed to cater for all tastes.

Spa at the Four Seasons New York - Midtown East

Rejuvenate at the luxurious Spa at the Four Season New York and all the cares in the world just melt away in your state of relaxation and tranquility.

OTHER PRIVY 5 CITIES

Click here

Are you who we think you are?

  • Looks like we've already got some information from you on file.
  • Enter your password to link Facebook Connect with your existing Privy Guest account.


Debugging Information
ColdFusion Server Standard 2016,0,10,314028
Template /newyork/index.cfm
Time Stamp 23-Dec-19 09:37 AM
Locale English (US)
User Agent Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote IP 172.6.167.56
Host Name 172.6.167.56


Execution Time

Total Time Avg Time Count Template
6054 ms 6054 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequest(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
3529 ms 3529 ms 1 D:/www/privy/newyork/views/go/overview.cfm
3528 ms 3528 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_overview.cfm
2464 ms 2464 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
2463 ms 2463 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
39 ms 39 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | weather(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
25 ms 25 ms 1 D:/www/privy/guestcfc/inc_popular_posts.cfm
14 ms 14 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ConvertXmlToStruct(<?xml version="1.0" encoding="ISO-8859-1"?> <rss version='2.0' xmlns:dc='http://purl.org/dc/elements/1.1/'> <channel> <title>Weather at New York City, Central Park, NY - via NOAA's National Weather Service</title> <link>http://www.weather.gov/xml/current_obs/</link> <lastBuildDate>Mon, 23 Dec 2019 11:51:00 -0500</lastBuildDate> <ttl>60</ttl> <description>Weather conditions from NOAA's National Weather Service. </description> <language>en-us</language> <managingEditor>sdb.support@noaa.gov</managingEditor> <webMaster>w-nws.webmaster@noaa.gov</webMaster> <image> <url>http://www.weather.gov/images/xml_logo.gif</url> <title>NOAA - National Weather Service</title> <link>http://www.weather.gov/xml/current_obs/</link> </image> <item> <title> Fair and 51 F at New York City, Central Park, NY</title> <link>http://w1.weather.gov/data/obhistory/KNYC.html</link> <description> <![CDATA[<img src="http://forecast.weather.gov/images/wtf/small/skc.png" class="noaaWeatherIcon" width="55" height="58" alt="Fair" style="float:left;" /><br />]]> Winds are Variable at 3.5 MPH (3 KT). The pressure is 1018.6 mb and the humidity is 45%. Last Updated on Dec 23 2019, 11:51 am EST. </description> <guid isPermaLink="false">Mon, 23 Dec 2019 11:51:00 -0500</guid> </item> </channel> </rss>, [complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
8 ms 3 ms 3 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
6 ms 6 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
6 ms 6 ms 1 D:/www/privy/newyork/layouts/go.cfm
4 ms 4 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 17) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestStart(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | overview(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
3 ms 3 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | privystar(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.slides, cityguide_slides) ] from D:/www/privy/newyork/Application.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 4 CFC[ D:/www/privy/guestcfc/cfc_helper_view.cfc | getrightaction2(PEOPLE ) ] from D:/www/privy/guestcfc/cfc_helper_view.cfc
0 ms 0 ms 4 CFC[ D:/www/privy/guestcfc/cfc_helper_view.cfc | getrightaction2(SOCIETY+EVENTS ) ] from D:/www/privy/guestcfc/cfc_helper_view.cfc
0 ms 0 ms 3 CFC[ D:/www/privy/guestcfc/global_event.cfc | ip4todecimal(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Afternoon Tea) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(American Comfort Food) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Asian Fusion/Contemporary) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Attractions) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Bar/Lounges) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Barbecue) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Boutique Hotels) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Brunch) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Business Lunch) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Breakfast) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Cantonese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Dim Sum) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Dumplings) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Noodles) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Shanghainese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Sichuan) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Cigar Clubs) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Clubs/Dancing) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Cuban) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Delis) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Dessert/Bakeries) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Greek/Mediterranean) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hot Pot) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hotel Bars) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hotels) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Indian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Italian Pizza) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Italian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Bar Food) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Noodles) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Sushi) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Jazz Clubs) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Karaoke/Noraebang) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Korean BBQ) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Korean) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Mexican/Latin) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Midnight Snack) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(New/American) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Romantic Restaurants) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Rooftop Bar) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Seafood) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Shopping Areas/Malls) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Spa) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Steakhouses) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Taiwanese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Thai) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vegan/Vegetarian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vietnamese Banh Mi) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vietnamese Pho) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vietnamese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(View Bars) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Wine List) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestEnd(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.privystar, cityguide_privystar) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.weather, cityguide_weather) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | endoverview(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | init(CFC: newyork.Application) ] from D:/www/privy/newyork/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | slides(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_privy5cities.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
6058 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.getwebpg (Datasource=entre360ds, Time=3ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:36:56.056
				SELECT * FROM webpg_event WHERE pageid = 1
			
local.checksession (Datasource=entre360ds, Time=1185ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:36:57.057
	SELECT memberguests_login.sessionid 
	FROM memberguests_login 
	WHERE sessionid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB

local.getlogininfo (Datasource=entre360ds, Time=1269ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:36:58.058
	SELECT 
		memberguests_login.memberid,
	 	memberguests_login.logindatetime,
	 	memberguests_login.loginvia,
	 	memberguests_login.logoutdatetime,
	 	memberguests_login.sessionid,
	 	memberguests_login.fbuid,
	 	memberguests_login.fbaccesstoken,
	 	memberguests_login.fbsignedrequest,
	 	memberguests_login.fbexpiresin,
	 	memberguests_login.fbpicture,
	 	memberguests_login.logininviteonly 
	FROM memberguests_login 
	WHERE sessionid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:36:58.058
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176

local.retval.query (Datasource=entre360ds, Time=1ms, Records=14) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:36:58.058
			SELECT * 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND star=1 AND p5=1
			ORDER BY orderstar
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%

local.retval.query (Datasource=entre360ds, Time=2ms, Records=32) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:36:58.058
			SELECT Code, Category, directoryurl, picture2, IntroMiddle, whereto, star, shortenedurl 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND byprivymember=1 AND p5=1
			ORDER BY Category
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%

local.retval.query (Datasource=entre360ds, Time=1ms, Records=53) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:36:58.058
			SELECT Code, Category, directoryurl, picture3, IntroMiddle, whereto 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) 
			AND byprivymember IS NULL 
			AND p5=1 
			ORDER BY Category
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '142' OR
										privy5codes LIKE '142,%' OR
										privy5codes LIKE '%,142' OR 
										privy5codes LIKE '%,142,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=8ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '170' OR
										privy5codes LIKE '170,%' OR
										privy5codes LIKE '%,170' OR 
										privy5codes LIKE '%,170,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '106' OR
										privy5codes LIKE '106,%' OR
										privy5codes LIKE '%,106' OR 
										privy5codes LIKE '%,106,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '157' OR
										privy5codes LIKE '157,%' OR
										privy5codes LIKE '%,157' OR 
										privy5codes LIKE '%,157,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '191' OR
										privy5codes LIKE '191,%' OR
										privy5codes LIKE '%,191' OR 
										privy5codes LIKE '%,191,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '150' OR
										privy5codes LIKE '150,%' OR
										privy5codes LIKE '%,150' OR 
										privy5codes LIKE '%,150,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '99' OR
										privy5codes LIKE '99,%' OR
										privy5codes LIKE '%,99' OR 
										privy5codes LIKE '%,99,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '144' OR
										privy5codes LIKE '144,%' OR
										privy5codes LIKE '%,144' OR 
										privy5codes LIKE '%,144,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '171' OR
										privy5codes LIKE '171,%' OR
										privy5codes LIKE '%,171' OR 
										privy5codes LIKE '%,171,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '145' OR
										privy5codes LIKE '145,%' OR
										privy5codes LIKE '%,145' OR 
										privy5codes LIKE '%,145,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '237' OR
										privy5codes LIKE '237,%' OR
										privy5codes LIKE '%,237' OR 
										privy5codes LIKE '%,237,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '245' OR
										privy5codes LIKE '245,%' OR
										privy5codes LIKE '%,245' OR 
										privy5codes LIKE '%,245,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '117' OR
										privy5codes LIKE '117,%' OR
										privy5codes LIKE '%,117' OR 
										privy5codes LIKE '%,117,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '141' OR
										privy5codes LIKE '141,%' OR
										privy5codes LIKE '%,141' OR 
										privy5codes LIKE '%,141,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '146' OR
										privy5codes LIKE '146,%' OR
										privy5codes LIKE '%,146' OR 
										privy5codes LIKE '%,146,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '101' OR
										privy5codes LIKE '101,%' OR
										privy5codes LIKE '%,101' OR 
										privy5codes LIKE '%,101,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=13ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '123' OR
										privy5codes LIKE '123,%' OR
										privy5codes LIKE '%,123' OR 
										privy5codes LIKE '%,123,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=32ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '119' OR
										privy5codes LIKE '119,%' OR
										privy5codes LIKE '%,119' OR 
										privy5codes LIKE '%,119,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=8ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '168' OR
										privy5codes LIKE '168,%' OR
										privy5codes LIKE '%,168' OR 
										privy5codes LIKE '%,168,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=14ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:58.058
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '167' OR
										privy5codes LIKE '167,%' OR
										privy5codes LIKE '%,167' OR 
										privy5codes LIKE '%,167,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=25ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '91' OR
										privy5codes LIKE '91,%' OR
										privy5codes LIKE '%,91' OR 
										privy5codes LIKE '%,91,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '149' OR
										privy5codes LIKE '149,%' OR
										privy5codes LIKE '%,149' OR 
										privy5codes LIKE '%,149,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=26ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '215' OR
										privy5codes LIKE '215,%' OR
										privy5codes LIKE '%,215' OR 
										privy5codes LIKE '%,215,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=8ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '147' OR
										privy5codes LIKE '147,%' OR
										privy5codes LIKE '%,147' OR 
										privy5codes LIKE '%,147,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=32ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '152' OR
										privy5codes LIKE '152,%' OR
										privy5codes LIKE '%,152' OR 
										privy5codes LIKE '%,152,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=13ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '143' OR
										privy5codes LIKE '143,%' OR
										privy5codes LIKE '%,143' OR 
										privy5codes LIKE '%,143,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=16ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '159' OR
										privy5codes LIKE '159,%' OR
										privy5codes LIKE '%,159' OR 
										privy5codes LIKE '%,159,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=77ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '209' OR
										privy5codes LIKE '209,%' OR
										privy5codes LIKE '%,209' OR 
										privy5codes LIKE '%,209,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=226ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '164' OR
										privy5codes LIKE '164,%' OR
										privy5codes LIKE '%,164' OR 
										privy5codes LIKE '%,164,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=107ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '161' OR
										privy5codes LIKE '161,%' OR
										privy5codes LIKE '%,161' OR 
										privy5codes LIKE '%,161,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=12ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '172' OR
										privy5codes LIKE '172,%' OR
										privy5codes LIKE '%,172' OR 
										privy5codes LIKE '%,172,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=22ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '1' OR
									privy5codes LIKE '1,%' OR
									privy5codes LIKE '%,1' OR 
									privy5codes LIKE '%,1,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=12ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '125' OR
									privy5codes LIKE '125,%' OR
									privy5codes LIKE '%,125' OR 
									privy5codes LIKE '%,125,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=20ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '3' OR
									privy5codes LIKE '3,%' OR
									privy5codes LIKE '%,3' OR 
									privy5codes LIKE '%,3,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=16ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '4' OR
									privy5codes LIKE '4,%' OR
									privy5codes LIKE '%,4' OR 
									privy5codes LIKE '%,4,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=25ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '5' OR
									privy5codes LIKE '5,%' OR
									privy5codes LIKE '%,5' OR 
									privy5codes LIKE '%,5,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=15ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '72' OR
									privy5codes LIKE '72,%' OR
									privy5codes LIKE '%,72' OR 
									privy5codes LIKE '%,72,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=23ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '25' OR
									privy5codes LIKE '25,%' OR
									privy5codes LIKE '%,25' OR 
									privy5codes LIKE '%,25,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=19ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '7' OR
									privy5codes LIKE '7,%' OR
									privy5codes LIKE '%,7' OR 
									privy5codes LIKE '%,7,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=25ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '9' OR
									privy5codes LIKE '9,%' OR
									privy5codes LIKE '%,9' OR 
									privy5codes LIKE '%,9,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=140ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:36:59.059
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '11' OR
									privy5codes LIKE '11,%' OR
									privy5codes LIKE '%,11' OR 
									privy5codes LIKE '%,11,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=144ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '12' OR
									privy5codes LIKE '12,%' OR
									privy5codes LIKE '%,12' OR 
									privy5codes LIKE '%,12,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=91ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '13' OR
									privy5codes LIKE '13,%' OR
									privy5codes LIKE '%,13' OR 
									privy5codes LIKE '%,13,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=50ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '14' OR
									privy5codes LIKE '14,%' OR
									privy5codes LIKE '%,14' OR 
									privy5codes LIKE '%,14,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=17ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '16' OR
									privy5codes LIKE '16,%' OR
									privy5codes LIKE '%,16' OR 
									privy5codes LIKE '%,16,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=22ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '18' OR
									privy5codes LIKE '18,%' OR
									privy5codes LIKE '%,18' OR 
									privy5codes LIKE '%,18,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=24ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '19' OR
									privy5codes LIKE '19,%' OR
									privy5codes LIKE '%,19' OR 
									privy5codes LIKE '%,19,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=28ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '136' OR
									privy5codes LIKE '136,%' OR
									privy5codes LIKE '%,136' OR 
									privy5codes LIKE '%,136,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=20ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '20' OR
									privy5codes LIKE '20,%' OR
									privy5codes LIKE '%,20' OR 
									privy5codes LIKE '%,20,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=14ms, Records=0) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '75' OR
									privy5codes LIKE '75,%' OR
									privy5codes LIKE '%,75' OR 
									privy5codes LIKE '%,75,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=33ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '62' OR
									privy5codes LIKE '62,%' OR
									privy5codes LIKE '%,62' OR 
									privy5codes LIKE '%,62,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=22ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '22' OR
									privy5codes LIKE '22,%' OR
									privy5codes LIKE '%,22' OR 
									privy5codes LIKE '%,22,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=98ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '78' OR
									privy5codes LIKE '78,%' OR
									privy5codes LIKE '%,78' OR 
									privy5codes LIKE '%,78,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=97ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '76' OR
									privy5codes LIKE '76,%' OR
									privy5codes LIKE '%,76' OR 
									privy5codes LIKE '%,76,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=190ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '26' OR
									privy5codes LIKE '26,%' OR
									privy5codes LIKE '%,26' OR 
									privy5codes LIKE '%,26,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=44ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '24' OR
									privy5codes LIKE '24,%' OR
									privy5codes LIKE '%,24' OR 
									privy5codes LIKE '%,24,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=18ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '27' OR
									privy5codes LIKE '27,%' OR
									privy5codes LIKE '%,27' OR 
									privy5codes LIKE '%,27,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=14ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '28' OR
									privy5codes LIKE '28,%' OR
									privy5codes LIKE '%,28' OR 
									privy5codes LIKE '%,28,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=21ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '29' OR
									privy5codes LIKE '29,%' OR
									privy5codes LIKE '%,29' OR 
									privy5codes LIKE '%,29,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=14ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '30' OR
									privy5codes LIKE '30,%' OR
									privy5codes LIKE '%,30' OR 
									privy5codes LIKE '%,30,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=20ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '31' OR
									privy5codes LIKE '31,%' OR
									privy5codes LIKE '%,31' OR 
									privy5codes LIKE '%,31,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=30ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '64' OR
									privy5codes LIKE '64,%' OR
									privy5codes LIKE '%,64' OR 
									privy5codes LIKE '%,64,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=14ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '35' OR
									privy5codes LIKE '35,%' OR
									privy5codes LIKE '%,35' OR 
									privy5codes LIKE '%,35,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=29ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '59' OR
									privy5codes LIKE '59,%' OR
									privy5codes LIKE '%,59' OR 
									privy5codes LIKE '%,59,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=30ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:00.000
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '37' OR
									privy5codes LIKE '37,%' OR
									privy5codes LIKE '%,37' OR 
									privy5codes LIKE '%,37,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=24ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '38' OR
									privy5codes LIKE '38,%' OR
									privy5codes LIKE '%,38' OR 
									privy5codes LIKE '%,38,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=57ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '39' OR
									privy5codes LIKE '39,%' OR
									privy5codes LIKE '%,39' OR 
									privy5codes LIKE '%,39,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=20ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '42' OR
									privy5codes LIKE '42,%' OR
									privy5codes LIKE '%,42' OR 
									privy5codes LIKE '%,42,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=47ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '43' OR
									privy5codes LIKE '43,%' OR
									privy5codes LIKE '%,43' OR 
									privy5codes LIKE '%,43,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=18ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '2' OR
									privy5codes LIKE '2,%' OR
									privy5codes LIKE '%,2' OR 
									privy5codes LIKE '%,2,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=53ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '44' OR
									privy5codes LIKE '44,%' OR
									privy5codes LIKE '%,44' OR 
									privy5codes LIKE '%,44,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=40ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '139' OR
									privy5codes LIKE '139,%' OR
									privy5codes LIKE '%,139' OR 
									privy5codes LIKE '%,139,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=105ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '45' OR
									privy5codes LIKE '45,%' OR
									privy5codes LIKE '%,45' OR 
									privy5codes LIKE '%,45,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=171ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '46' OR
									privy5codes LIKE '46,%' OR
									privy5codes LIKE '%,46' OR 
									privy5codes LIKE '%,46,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=147ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '47' OR
									privy5codes LIKE '47,%' OR
									privy5codes LIKE '%,47' OR 
									privy5codes LIKE '%,47,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=101ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '51' OR
									privy5codes LIKE '51,%' OR
									privy5codes LIKE '%,51' OR 
									privy5codes LIKE '%,51,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=142ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '52' OR
									privy5codes LIKE '52,%' OR
									privy5codes LIKE '%,52' OR 
									privy5codes LIKE '%,52,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=28ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '53' OR
									privy5codes LIKE '53,%' OR
									privy5codes LIKE '%,53' OR 
									privy5codes LIKE '%,53,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=36ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '60' OR
									privy5codes LIKE '60,%' OR
									privy5codes LIKE '%,60' OR 
									privy5codes LIKE '%,60,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=101ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '54' OR
									privy5codes LIKE '54,%' OR
									privy5codes LIKE '%,54' OR 
									privy5codes LIKE '%,54,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=51ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '56' OR
									privy5codes LIKE '56,%' OR
									privy5codes LIKE '%,56' OR 
									privy5codes LIKE '%,56,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=22ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '55' OR
									privy5codes LIKE '55,%' OR
									privy5codes LIKE '%,55' OR 
									privy5codes LIKE '%,55,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=34ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '57' OR
									privy5codes LIKE '57,%' OR
									privy5codes LIKE '%,57' OR 
									privy5codes LIKE '%,57,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.getthelist (Datasource=entre360ds, Time=46ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '58' OR
									privy5codes LIKE '58,%' OR
									privy5codes LIKE '%,58' OR 
									privy5codes LIKE '%,58,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=4ms, Records=39) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = eat
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=8) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = drink
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=2) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = sleep
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=2) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = play
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = shop
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:37:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = relax
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

local.traffic (Datasource=entre360ds, Time=17ms, Records=0) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:37:02.002
	SELECT TOP 4
		magazine_id,
		COUNT(magazine_id) AS hits,
		(
			SELECT directoryurl
	        FROM magazine
	        WHERE magazine.id = magazine_views.magazine_id
		) AS directoryurl
	FROM MAGAZINE_VIEWS
	WHERE
		created>=CONVERT(datetime,'2019-12-22 00:00:00') AND
		created<=CONVERT(datetime,'2019-12-28 23:59:59') AND
		magazine_id!=17
	GROUP BY magazine_id
	ORDER BY COUNT(magazine_id) DESC
local.traffic (Datasource=entre360ds, Time=1ms, Records=4) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:37:02.002
		SELECT TOP 4 directoryurl FROM magazine ORDER BY initpopular DESC
	
local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:37:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-NYE-2011

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:37:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Emily-Cho

local.getMagDB (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:37:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Sara-Mibo-Sohn

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:37:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-Bordeaux-Event-at-Strip-Prime-Shanghai

local.getdb (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:37:02.002
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176

local.dbprivy5topplaces (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 09:37:02.002
	SELECT
		LOCATION.Name,
		LOCATION.LocationId,
		LOCATION.Privy5Codes,
		LOCATION.Privy5Text,
		LOCATION.Thumbnail,
		LOCATION.directoryurl,
		(
			SELECT privy5codes.whereto
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorywhereto2,
		(
			SELECT privy5codes.category
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorytext,
		(
			SELECT privy5codes.directoryurl
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categoryurl
	FROM PRIVY5TOPPLACES INNER JOIN LOCATION ON PRIVY5TOPPLACES.LocationId = LOCATION.LocationId
	WHERE (PRIVY5TOPPLACES.City = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%
Parameter #5(CF_SQL_CHAR) = New York
Parameter #6(CF_SQL_CHAR) = New York,%
Parameter #7(CF_SQL_CHAR) = %,New York
Parameter #8(CF_SQL_CHAR) = %,New York,%
Parameter #9(CF_SQL_CHAR) = New York
Parameter #10(CF_SQL_CHAR) = New York,%
Parameter #11(CF_SQL_CHAR) = %,New York
Parameter #12(CF_SQL_CHAR) = %,New York,%
Parameter #13(CF_SQL_CHAR) = New York

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:37:02.002
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176


Scope Variables

Application Variables:
applicationname=16674C21BBD774F3F0CD46198107AC84
devmode=false
dsn_name=entre360ds
dsn_name10=entre360_2011ds
event=Struct (26)
ipallow=24.199.44.252
magazine_imageupload=/upload/net/privy/www/p5photos/
org.corfield.framework=Struct (3)
paypal_biz=paypal@privy.net
paypal_url=https://www.paypal.com/cgi-bin/webscr
recaptcha_private=6LfrQtQSAAAAAGuECx5CZ5jRb4TPBzgrBVTK_IPH
recaptcha_public=6LfrQtQSAAAAALsfdvrJmY-JULezQbwYw4ea1nE2
site_addr=www.privy.net
upload=/upload/net/privy/www/
upload_magazine=/upload/net/privy/www/p5photos/
upload_root=/upload/net/privy/
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=d:\www\privy\newyork\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,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=en, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=5955090; $Path=/; CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB; $Path=/; DESTINATION=Los%20Angeles; $Path=/; RECENTCITIES=Hong%20Kong%2CShanghai%2CLondon%2CLos%20Angeles%2CNew%20York%2CMacau; $Path=/
HTTP_HOST=www.privy.net
HTTP_REFERER=http://www.privy.net/newyork
HTTP_URL=/newyork/index.cfm/
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/
PATH_TRANSLATED=d:\www\privy\newyork\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/newyork/index.cfm
SERVER_NAME=www.privy.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=5955090
CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
DESTINATION=Los Angeles
RECENTCITIES=Hong Kong,Shanghai,London,Los Angeles,New York,Macau
Session Variables:
cfid=5955090
cftoken=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
sessionid=16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
urltoken=CFID=5955090&CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
Debug Rendering Time: 16 ms