Privy 5 Shanghai Wine List

Some of the fine dining restaurants in the city offer a great selection of wines from their Wine List. However, there are also a large number of stand alone wine bars to choose from. If you're looking for a restaurant or bar with an impressive Wine List, here are the best.

Share |
  • Categories: Night Life,  Restaurants

    Neighborhood: People's Square

    Cuisine:European

    57 Jiangyin Lu 1-2/F, Wine Residence near Huangpi Bei Lu Shanghai Huangpu District
    +86 21 6318-0057
    With the wine list being freed up a little recently, this venue is worth a visit for its taster menu, which is now coupled with the wine, for a reasonable price. The wine list has always been an expansive one here, with some 700 choices on offer. Locally sourced ingredients are also strongly emphasized, so when it comes to the food, quality is central. Nice open clean venue too, nothing too earthy ... read more >
  • Categories: Restaurants

    Neighborhood: Pudong

    Cuisine:European

    100 Century Avenue 87/F, Shanghai World Financial Center near Dongtai Lu Shanghai Pudong District
    +86 21 6888-1234
    You will find many rustic European favorites at this emporium. The wine list is extensive, with plenty on offer that includes organic and bio-dynamic beverages. The elegant environment adds all to the atmosphere, with the provincial offerings from the Continent at odds with the fact that you’re in a Shanghai high rise. You can enjoy seared scallops or black cod while reflecting on the irony. Good ... read more >
  • Categories: Night Life,  Restaurants

    Neighborhood: People's Square

    Cuisine:Greek

    Silver Court Building, 6th Floor, No 228 Xizang Nan Lu (near Huaihai Dong Lu, Entrance Via Fraser Residence on Shouning Lu Shanghai Huangpu District

    Local Language Address: 上海市西藏南路228号永银大厦6楼,入口位于寿宁路

    +86 21 6334 3288
    The Fat Olive Wine and Mezze Bar, the only wine bar in Shanghai with a Greek twist, a cool space in the middle of downtown Shanghai overlooking the old city with the Pudong skyline in the background. Casual, chic, yet warm and intimate, you can remain indoors surrounded by rustic wood during the winter months and the perfect venue for alfresco dining during the warm month (voted best Alfresco by ... read more >
  • Categories: Restaurants

    Neighborhood: Jing An

    Cuisine:Italian

    1376 Nanjing Xi Lu The Portman Ritz-Carlton Hotel, Shanghai Center Shanghai Jing An District
    +86 21 6279 8888
    Champagne and sparkling wines, reds, whites , and dessert wines are all featured at this restaurant. About two hundred wines in all, some of them available in half bottles. Some of them are Italian, in keeping with the cuisine, and some aren’t. But they’re all good. “Spaghetti with Black Truffle Sauce, Fresh Sardines, Fresh Artichokes”, “Venison Rossini-style with Pumpkin Confit and Pan-fried Goos ... read more >
  • Categories: Night Life,  Restaurants

    Neighborhood: Jing An

    Cuisine:American (New), Italian

    462 Dagu Road near Shimen Yi Lu Shanghai Jing An District

    Local Language Address: 大沽路462号

    +86 21 3311 3205
    Why go for quantity when you can go for quality? That's what the people at Just Grapes thought when they created this wine lounge. While this wine bar may not have the most extensive list, it does boast some of the most flavorful wines in following with their belief that the best things come in pairs. This is especially the case with the wines at Just Grapes as they provide a menu of food offering ... read more >

write a comment

Comments (0)

PRIVY TOP 5 PLACES IN SHANGHAI

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 /shanghai/index.cfm
Time Stamp 23-Dec-19 12:19 PM
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
30491 ms 30491 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequest(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
16692 ms 16692 ms 1 D:/www/privy/shanghai/views/go/drink.cfm
16690 ms 16690 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
16690 ms 16690 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
16130 ms 3226 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
13522 ms 13522 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
13522 ms 13522 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
508 ms 508 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
197 ms 0 ms 19224 D:/Mappings/lib-tag/getmaxminusone.cfm
142 ms 142 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
73 ms 73 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequestStart(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
55 ms 55 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
42 ms 42 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
37 ms 37 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
22 ms 22 ms 1 D:/www/privy/shanghai/layouts/go.cfm
21 ms 21 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
20 ms 20 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
9 ms 5 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
6 ms 6 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
4 ms 4 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
4 ms 4 ms 1 CFC[ D:/www/privy/shanghai/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/users.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 0 ms 5 D:/Mappings/lib-tag/commaspace.cfm
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Picture 28.png) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = just grapes.jpg) ] from D:/www/privy/guestcfc/global_event.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_login_popup.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_comments.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.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 = _V5E9847.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = palladio.png) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequestEnd(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | drink(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | enddrink(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | init(CFC: shanghai.Application) ] from D:/www/privy/shanghai/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/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/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_privy5cities.cfm
37 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
30601 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:19:08.008 - Application Exception - in D:/www/privy/guestcfc/inc_privy5topplaces.cfm : line 85
	    An exception occurred while trying to write the image.
	    


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=20ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 12:18: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/drink/WINE-LIST
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.getwebpg (Datasource=entre360ds, Time=37ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:18:38.038
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,drink,WINE-LIST

local.checksession (Datasource=entre360ds, Time=6721ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:18:45.045
	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=6758ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:18:51.051
	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=5ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:18: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

local.retval.query (Datasource=entre360ds, Time=42ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:18:51.051
			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) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%

local.retval.query (Datasource=entre360ds, Time=4ms, Records=7) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:18:51.051
			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) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%
Parameter #5(CF_SQL_CHAR) = drink

local.retval.query (Datasource=entre360ds, Time=54ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:18:52.052
			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 'drink' OR
							categorywhereto LIKE 'drink,%' OR
							categorywhereto LIKE '%,drink' OR 
							categorywhereto LIKE '%,drink,%'
						)		 
					GROUP BY ltrim(rtrim(LOCATION.Neighborhood))
				)		
				
			ORDER BY PRIVY5NEIGHBORHOODS.neighborhood  
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai

local.retval.getCategory (Datasource=entre360ds, Time=4ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:18:52.052
					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) = WINE-LIST
Parameter #2(CF_SQL_CHAR) = WINE-LIST
Parameter #3(CF_SQL_CHAR) = Shanghai
Parameter #4(CF_SQL_CHAR) = Shanghai,%
Parameter #5(CF_SQL_CHAR) = %,Shanghai
Parameter #6(CF_SQL_CHAR) = %,Shanghai,%

local.retval.getlistinglocation (Datasource=entre360ds, Time=137ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:18:52.052
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					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) = Shanghai

local.getid (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 12:18:52.052
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = WINE-LIST

local.retval.comments (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 12:18:52.052
		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) = 58
Parameter #2(CF_SQL_CHAR) = Shanghai

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:18:52.052
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:18:52.052
	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 @ 12:18:55.055
	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 @ 12:18:56.056
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:18:56.056
	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 @ 12:18:58.058
	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 @ 12:18:58.058
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:18:58.058
	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 @ 12:19:04.004
	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 @ 12:19:05.005
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:19:05.005
	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 @ 12:19:05.005
	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 @ 12:19:05.005
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:19:05.005
	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 @ 12:19:07.007
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=91ms, Records=17) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 12:19:08.008
	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) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%
Parameter #5(CF_SQL_CHAR) = Shanghai
Parameter #6(CF_SQL_CHAR) = Shanghai,%
Parameter #7(CF_SQL_CHAR) = %,Shanghai
Parameter #8(CF_SQL_CHAR) = %,Shanghai,%
Parameter #9(CF_SQL_CHAR) = Shanghai
Parameter #10(CF_SQL_CHAR) = Shanghai,%
Parameter #11(CF_SQL_CHAR) = %,Shanghai
Parameter #12(CF_SQL_CHAR) = %,Shanghai,%
Parameter #13(CF_SQL_CHAR) = Shanghai

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:19:08.008
						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\shanghai\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/shanghai
HTTP_URL=/shanghai/index.cfm/go/drink/WINE-LIST
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/drink/WINE-LIST
PATH_TRANSLATED=d:\www\privy\shanghai\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/shanghai/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: 286 ms