Privy 5 San Francisco Patrick Chung

Partner, NEA

Patrick Chung joined NEA in 2004 and is co-head of NEA's Consumer investing practice, focusing on Internet and mobile investments across stage. He is a director of 23andMe, eeGeo, Loopt, GoodGuide, Pixelberry and Refocus Imaging, and is actively involved with Vuze, Nurien and the firm's venture growth activities. Prior to joining NEA, Patrick helped to grow ZEFER, an Internet services firm (acquired by NEC) to more than $100 million in annual revenues and more than 700 people across six global offices. Prior to ZEFER, Patrick was with McKinsey & Company, where he specialized in hardware, software, and services companies. Patrick received a joint JD-MBA degree from Harvard Business School and Harvard Law School, where he served as an Editor of the Harvard Law Review. Patrick was a Commonwealth Scholar at Oxford University, where he earned a Master of Science degree. Patrick Chung earned his A.B. degree at Harvard University in Environmental Science. He is a member of the New York and Massachusetts bars, and a member of the Committee to Visit Harvard College.

Privy 5 San Francisco Patrick Chung
Share |
  • Categories: Restaurants

    Neighborhood: South Bay

    Cuisine:Mediterranean

    430 Kipling St Palo Alto CA 94301
    (650) 328-6722
    Zibibbo is one of the best Mediterranean restaurants in the Bay Area with a great atmosphere, great food, and great service. Try to get balcony seating here where it affords you a view of the open kitchen where you can see your chefs preparing what you're ordering. To start off, havethe pomegranate salad. It is a simple salad and yet the ingredients make it irresistibly delicious. A trip to Zibibb ... read more >
  • Categories: Restaurants

    Neighborhood: South Bay

    Cuisine:Cuban

    463 S California Ave Palo Alto CA 94306
    (650) 326-7762
    La Bodeguita del Medio is one of the finer Cuban restaurants in all of the Bay Area. The atmosphere is both relaxing and upscale. With both a restaurant and bar area, La Bodeguita del Medio is perfect for almost any occasion. Among the cocktails you should have are the Mojitos which are top notch. As for food, you'll want to try their empanadas filled with tender meat and great sauces. Also try th ... read more >
  • Categories: Restaurants

    Neighborhood: Pacific Heights

    Cuisine:French, Italian

    1701 Octavia Street San Francisco CA 94133
    +1 415 775 8500
    Quince is a splendid restaurant that caters to people with craving for Mediterranean cuisine. Upon entering the restaurant, you will be greeted by the aroma of authentic Mediterranean herbs wafting from the kitchen. They have chicken, beef, seafood and lamb dishes that are cooked and prepared to perfection. Their melon gazpacho with mint and cucumber is a mouth watering appetizer that will kick of ... read more >
  • Categories: Restaurants

    Neighborhood: Mission District

    Cuisine:American (New), Mediterranean

    2534 Mission Street San Francisco CA 94110
    +1 415 648 7600
    Foreign Cinema is the definition of unassuming. You pass by Foreign Cinema several times and never realize that there exists this excellent restaurant in Mission. From the outside it looks like a plain wall but once in you will find a beautiful space with super high ceilings and concrete walls, unique light bundles and open air space between the patio and the inside. It's bright, cheerful filled w ... read more >
  • Categories: Restaurants

    Neighborhood: Japantown

    Cuisine:Japanese, Japanese Sushi

    1737 Post Street (between Webster and Fillmore streets) San Francisco CA 94115
    +1 415 563 1030
    Isobune Sushi is quite simply one of the best and authentic sushi boat restaurants in the Bay Area. That being said, if you don't want to dine with novelty of picking your sushi off a sushi boat, you can always ask the wait staff and order a la carte for your favorite sashimi, sushi, and rolls. This way you can be sure the kitchen prepares it just the way you like it. If you do decide to dine at t ... read more >

write a comment

Comments (0)

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:52 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
13190 ms 13190 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequest(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
8774 ms 8774 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
8773 ms 8773 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
3585 ms 3585 ms 1 D:/www/privy/sanfrancisco/views/go/eat.cfm
3582 ms 3582 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
3582 ms 3582 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
3502 ms 700 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
388 ms 388 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
281 ms 281 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
50 ms 50 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
40 ms 20 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
38 ms 38 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
36 ms 36 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
36 ms 0 ms 7476 D:/Mappings/lib-tag/getmaxminusone.cfm
35 ms 35 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/sanfrancisco/Application.cfc
20 ms 20 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
20 ms 4 ms 5 D:/Mappings/lib-tag/commaspace.cfm
14 ms 14 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/sanfrancisco/Application.cfc
6 ms 6 ms 1 D:/www/privy/sanfrancisco/layouts/go.cfm
5 ms 5 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestStart(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
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
2 ms 2 ms 1 CFC[ D:/www/privy/sanfrancisco/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/users.cfc
2 ms 2 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = QUINCE002_CAG246x350.JPG) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = mezzanine.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = zibibbo.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_services_users_inc.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_comments.cfm
0 ms 0 ms 2 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 | p5thumbnail(original = isobunesushi.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = labodeguita.jpg) ] 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.mapjsheader, cityguide_mapjsheader) ] 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.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | endeat(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 | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/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/cfc_services_users.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_login_popup.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_privy5cities.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
9 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
13204 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 10:52:38.038
		SELECT directoryurl,whereto 
		FROM privy5codes 
		WHERE (shortenedurl=?) AND 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go/eat/Patrick-Chung
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.getwebpg (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:52:38.038
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,Patrick-Chung

local.checksession (Datasource=entre360ds, Time=2338ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 10:52:40.040
	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=6395ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 10:52:47.047
	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=37ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:52:47.047
						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=36ms, Records=42) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:52:47.047
			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=19ms, Records=36) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:52:47.047
			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 
				AND whereto = ? 
			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,%
Parameter #5(CF_SQL_CHAR) = eat

local.retval.query (Datasource=entre360ds, Time=281ms, Records=31) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:52:47.047
			SELECT PRIVY5NEIGHBORHOODS.neighborhood, PRIVY5NEIGHBORHOODS.closestprivycity, PRIVY5NEIGHBORHOODS.directoryurl 
			FROM PRIVY5NEIGHBORHOODS 
			WHERE 
				PRIVY5NEIGHBORHOODS.closestprivycity = ? 
				AND ltrim(rtrim(PRIVY5NEIGHBORHOODS.neighborhood)) IN 
				(
					SELECT ltrim(rtrim(LOCATION.Neighborhood))
					FROM LOCATION
					WHERE 
						(LOCATION.p5 = 1) AND 
						(LOCATION.ClosestPrivyCity = ?) AND 
						(
							categorywhereto LIKE 'eat' OR
							categorywhereto LIKE 'eat,%' OR
							categorywhereto LIKE '%,eat' OR 
							categorywhereto LIKE '%,eat,%'
						)		 
					GROUP BY ltrim(rtrim(LOCATION.Neighborhood))
				)		
				
			ORDER BY PRIVY5NEIGHBORHOODS.neighborhood  
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco

local.retval.getCategory (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:52:47.047
					SELECT * 
					FROM privy5codes 
					WHERE 
						(
							directoryurl = ? OR 
							shortenedurl = ?
						) AND 
						(
							City LIKE ? OR 
							City LIKE ? OR
							City LIKE ? OR 
							City LIKE ?
						) 
						 
						AND p5=1
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Patrick-Chung
Parameter #2(CF_SQL_CHAR) = Patrick-Chung
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,%

local.retval.getlistinglocation (Datasource=entre360ds, Time=364ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:52:47.047
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					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.getid (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 10:52:47.047
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Patrick-Chung

local.retval.comments (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 10:52:47.047
		SELECT 
			MEMBERGUESTS.memberid,
			isnull(MEMBERGUESTS.firstname,'')+' '+isnull(MEMBERGUESTS.lastname,'') AS personname, 
			MEMBERGUESTS.picture,
			MEMBERGUESTS.fbid,
			MEMBERGUESTS.gender,
			MEMBERGUESTS_COMMENTS.commentid,
			MEMBERGUESTS_COMMENTS.comment,
			MEMBERGUESTS_COMMENTS.commentdate
		FROM MEMBERGUESTS_COMMENTS 
			INNER JOIN MEMBERGUESTS ON MEMBERGUESTS_COMMENTS.memberid = MEMBERGUESTS.memberid 
		WHERE 
			
			MEMBERGUESTS_COMMENTS.privy5codes = ? AND 
			MEMBERGUESTS_COMMENTS.privy5codescity = ? 
			AND MEMBERGUESTS_COMMENTS.commentshow = 1 
		ORDER BY MEMBERGUESTS_COMMENTS.commentdate DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 178
Parameter #2(CF_SQL_CHAR) = San Francisco

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:47.047
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:47.047
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=0ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:48.048
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:48.048
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:48.048
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=0ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:48.048
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:48.048
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:48.048
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=0ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:49.049
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:50.050
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:50.050
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=0ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:50.050
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:51.051
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:51.051
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=0ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 10:52:51.051
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 10:52:51.051
	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=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:52:51.051
						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)
[email protected]
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/go/eat/Patrick-Chung
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/Patrick-Chung
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: 83 ms