Mandarin Hotel - Financial District

Experience the best of San Francisco skyline by night with an overnight stay at Mandarin Oriental. Ideal for tourists, it is nestled right within the heart of the city.

Delfina - Mission District [ photo via Eric Wolfinger ]

A visit to Delfina is a must especially if you enjoy Italian cuisine. Their menu changes everyday giving you a new experience in tasting new dishes each time you come to dine.

The Alembic - Haight-Ashbury [ photo via Jennifer Yin ]

The Alembic is an excellent bar plus dining concept in Haight. The menu is interesting, unique, exciting and well planned.

Remede Spa at The St. Regis Hotel @ SOMA

Remede Spa is known for its many services and expert therapists who make sure that every visit you make is truly a memorable experience.

Press Club - Union Square

Located at the Four Seasons Hotel, Press Club is a bar that has a collection of the best wines from six of northern California''s world class vineyards.

Alexander''s Steakhouse - SOMA

Alexander Steakhouse in San Francisco is everyone''s favorite in as far as steaks are concerned. They have the widest selections of beef that come from corn-fed cows.

Perbacco - Financial District

Perbacco actually means "For Bacchus". As such, you can only expect an overflowing supply of wines. The eatery has actually more to offer than just wines and spirits.

French Laundry - Napa Valley

French Laundry is the legendary restaurant from renowned chef Thomas Keller. If you want more than just great food, French laundry can also offer you a dining experience with nature as your backdrop.

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 /sanfrancisco/index.cfm
Time Stamp 23-Dec-19 10:03 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
35508 ms 35508 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequest(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
21705 ms 21705 ms 1 D:/www/privy/sanfrancisco/views/go/overview.cfm
21684 ms 21684 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_overview.cfm
13267 ms 13267 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
13267 ms 13267 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
377 ms 377 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | weather(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
107 ms 107 ms 1 D:/www/privy/guestcfc/inc_popular_posts.cfm
73 ms 73 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 San Francisco, San Francisco International Airport, CA - via NOAA's National Weather Service</title> <link>http://www.weather.gov/xml/current_obs/</link> <lastBuildDate>Mon, 23 Dec 2019 08:56:00 -0800</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> Partly Cloudy and 47 F at San Francisco, San Francisco International Airport, CA</title> <link>http://w1.weather.gov/data/obhistory/KSFO.html</link> <description> <![CDATA[<img src="http://forecast.weather.gov/images/wtf/small/sct.png" class="noaaWeatherIcon" width="55" height="58" alt="Partly Cloudy" style="float:left;" /><br />]]> Winds are North at 4.6 MPH (4 KT). The pressure is 1013.8 mb and the humidity is 83%. The wind chill is 45. Last Updated on Dec 23 2019, 8:56 am PST. </description> <guid isPermaLink="false">Mon, 23 Dec 2019 08:56:00 -0800</guid> </item> </channel> </rss>, [complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
46 ms 15 ms 3 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
41 ms 41 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
37 ms 37 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
37 ms 37 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.slides, cityguide_slides) ] from D:/www/privy/sanfrancisco/Application.cfc
37 ms 37 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | overview(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
33 ms 33 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | privystar(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
26 ms 26 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
25 ms 25 ms 1 D:/www/privy/sanfrancisco/layouts/go.cfm
16 ms 16 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
16 ms 16 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
16 ms 16 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
15 ms 15 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 17) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestStart(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.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(Beer Specialist) ] 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(Burgers) ] 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 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 Hot Pot) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Roast Duck) ] 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(Clubs/Dancing) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Cocktail Specialists) ] 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(Expense Account Restaurant) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(French) ] 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 Ramen) ] 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(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(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(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/sanfrancisco/Application.cfc | onRequestEnd(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.privystar, cityguide_privystar) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.weather, cityguide_weather) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | endoverview(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | init(CFC: sanfrancisco.Application) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | slides(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
35512 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.getwebpg (Datasource=entre360ds, Time=37ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:02:30.030
				SELECT * FROM webpg_event WHERE pageid = 1
			
local.checksession (Datasource=entre360ds, Time=6868ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 10:02:37.037
	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=6345ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 10:02:43.043
	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=16ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:02:43.043
						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=33ms, Records=8) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:02:43.043
			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) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%

local.retval.query (Datasource=entre360ds, Time=1ms, Records=42) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:02:43.043
			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) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%

local.retval.query (Datasource=entre360ds, Time=25ms, Records=48) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:02:43.043
			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) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%

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

local.getthelist (Datasource=entre360ds, Time=753ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:45.045
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '174' OR
										privy5codes LIKE '174,%' OR
										privy5codes LIKE '%,174' OR 
										privy5codes LIKE '%,174,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=126ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:45.045
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '148' OR
										privy5codes LIKE '148,%' OR
										privy5codes LIKE '%,148' OR 
										privy5codes LIKE '%,148,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

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

local.getthelist (Datasource=entre360ds, Time=1331ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:46.046
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '185' OR
										privy5codes LIKE '185,%' OR
										privy5codes LIKE '%,185' OR 
										privy5codes LIKE '%,185,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=751ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:47.047
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '188' OR
										privy5codes LIKE '188,%' OR
										privy5codes LIKE '%,188' OR 
										privy5codes LIKE '%,188,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=620ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '183' OR
										privy5codes LIKE '183,%' OR
										privy5codes LIKE '%,183' OR 
										privy5codes LIKE '%,183,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=100ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '155' OR
										privy5codes LIKE '155,%' OR
										privy5codes LIKE '%,155' OR 
										privy5codes LIKE '%,155,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=166ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=206ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '162' OR
										privy5codes LIKE '162,%' OR
										privy5codes LIKE '%,162' OR 
										privy5codes LIKE '%,162,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=48ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '160' OR
										privy5codes LIKE '160,%' OR
										privy5codes LIKE '%,160' OR 
										privy5codes LIKE '%,160,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=55ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '176' OR
										privy5codes LIKE '176,%' OR
										privy5codes LIKE '%,176' OR 
										privy5codes LIKE '%,176,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=35ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:48.048
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '180' OR
										privy5codes LIKE '180,%' OR
										privy5codes LIKE '%,180' OR 
										privy5codes LIKE '%,180,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=83ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:49.049
									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) = San Francisco

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

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

local.getthelist (Datasource=entre360ds, Time=25ms, Records=3) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:49.049
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '169' OR
										privy5codes LIKE '169,%' OR
										privy5codes LIKE '%,169' OR 
										privy5codes LIKE '%,169,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=43ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:49.049
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '182' OR
										privy5codes LIKE '182,%' OR
										privy5codes LIKE '%,182' OR 
										privy5codes LIKE '%,182,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

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

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

local.getthelist (Datasource=entre360ds, Time=277ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:49.049
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '158' OR
										privy5codes LIKE '158,%' OR
										privy5codes LIKE '%,158' OR 
										privy5codes LIKE '%,158,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=765ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:50.050
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '184' OR
										privy5codes LIKE '184,%' OR
										privy5codes LIKE '%,184' OR 
										privy5codes LIKE '%,184,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=566ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '140' OR
										privy5codes LIKE '140,%' OR
										privy5codes LIKE '%,140' OR 
										privy5codes LIKE '%,140,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=403ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=64ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '165' OR
										privy5codes LIKE '165,%' OR
										privy5codes LIKE '%,165' OR 
										privy5codes LIKE '%,165,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=33ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '104' OR
										privy5codes LIKE '104,%' OR
										privy5codes LIKE '%,104' OR 
										privy5codes LIKE '%,104,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=36ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=72ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '156' OR
										privy5codes LIKE '156,%' OR
										privy5codes LIKE '%,156' OR 
										privy5codes LIKE '%,156,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=268ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:51.051
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '175' OR
										privy5codes LIKE '175,%' OR
										privy5codes LIKE '%,175' OR 
										privy5codes LIKE '%,175,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=63ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:52.052
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '192' OR
										privy5codes LIKE '192,%' OR
										privy5codes LIKE '%,192' OR 
										privy5codes LIKE '%,192,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=153ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:52.052
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '190' OR
										privy5codes LIKE '190,%' OR
										privy5codes LIKE '%,190' OR 
										privy5codes LIKE '%,190,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=189ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:52.052
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '153' OR
										privy5codes LIKE '153,%' OR
										privy5codes LIKE '%,153' OR 
										privy5codes LIKE '%,153,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=199ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:52.052
									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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=70ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:52.052
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '178' OR
										privy5codes LIKE '178,%' OR
										privy5codes LIKE '%,178' OR 
										privy5codes LIKE '%,178,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=67ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:52.052
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '177' OR
										privy5codes LIKE '177,%' OR
										privy5codes LIKE '%,177' OR 
										privy5codes LIKE '%,177,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=987ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:53.053
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '154' OR
										privy5codes LIKE '154,%' OR
										privy5codes LIKE '%,154' OR 
										privy5codes LIKE '%,154,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=70ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:53.053
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '243' OR
										privy5codes LIKE '243,%' OR
										privy5codes LIKE '%,243' OR 
										privy5codes LIKE '%,243,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=72ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:53.053
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '173' OR
										privy5codes LIKE '173,%' OR
										privy5codes LIKE '%,173' OR 
										privy5codes LIKE '%,173,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=444ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '246' OR
										privy5codes LIKE '246,%' OR
										privy5codes LIKE '%,246' OR 
										privy5codes LIKE '%,246,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=48ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '166' OR
										privy5codes LIKE '166,%' OR
										privy5codes LIKE '%,166' OR 
										privy5codes LIKE '%,166,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=35ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '132' OR
										privy5codes LIKE '132,%' OR
										privy5codes LIKE '%,132' OR 
										privy5codes LIKE '%,132,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=23ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=28ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=27ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=31ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=28ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
								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) = San Francisco

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

local.getthelist (Datasource=entre360ds, Time=174ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:54.054
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=421ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:55.055
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=261ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:55.055
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '8' OR
									privy5codes LIKE '8,%' OR
									privy5codes LIKE '%,8' OR 
									privy5codes LIKE '%,8,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getthelist (Datasource=entre360ds, Time=25ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:55.055
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=94ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:55.055
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=32ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:55.055
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=448ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:56.056
								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) = San Francisco

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

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

local.getthelist (Datasource=entre360ds, Time=162ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=366ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=100ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

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

local.getthelist (Datasource=entre360ds, Time=45ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

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

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

local.getthelist (Datasource=entre360ds, Time=36ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=31ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=74ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:57.057
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=704ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:58.058
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=1097ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:02:59.059
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=476ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03: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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=85ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03: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) = San Francisco

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

local.getthelist (Datasource=entre360ds, Time=28ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03: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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=51ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:00.000
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=69ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:00.000
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=20ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:00.000
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=46ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:00.000
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=103ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:00.000
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=232ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03: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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=673ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03: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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=491ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:02.002
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=647ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:02.002
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=879ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:03.003
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=423ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:04.004
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=80ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:04.004
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=92ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:04.004
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=94ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:04.004
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=329ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:04.004
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=697ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
								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) = San Francisco

local.getthelist (Datasource=entre360ds, Time=110ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
								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) = San Francisco

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=42ms, Records=36) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
					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) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=38ms, Records=7) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
					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) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=2) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
					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) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
					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) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
					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) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 10:03:05.005
					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) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.traffic (Datasource=entre360ds, Time=65ms, Records=0) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 10:03:05.005
	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=0ms, Records=4) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 10:03:05.005
		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 @ 10:03:05.005
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-NYE-2011

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

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

local.getMagDB (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 10:03:06.006
						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=14ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:03:06.006
						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=41ms, Records=0) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 10:03:06.006
	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) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%
Parameter #5(CF_SQL_CHAR) = San Francisco
Parameter #6(CF_SQL_CHAR) = San Francisco,%
Parameter #7(CF_SQL_CHAR) = %,San Francisco
Parameter #8(CF_SQL_CHAR) = %,San Francisco,%
Parameter #9(CF_SQL_CHAR) = San Francisco
Parameter #10(CF_SQL_CHAR) = San Francisco,%
Parameter #11(CF_SQL_CHAR) = %,San Francisco
Parameter #12(CF_SQL_CHAR) = %,San Francisco,%
Parameter #13(CF_SQL_CHAR) = San Francisco

local.getdb (Datasource=entre360ds, Time=16ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:03:06.006
						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\sanfrancisco\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/sanfrancisco
HTTP_URL=/sanfrancisco/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\sanfrancisco\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sanfrancisco/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: 140 ms