Privy 5 Shanghai Andrew BigBee

VP Sales APAC, Palm Computing Inc.

Privy 5 Shanghai Andrew BigBee
Share |
  • Categories: Restaurants

    Neighborhood: Pudong

    Cuisine:Italian

    2967 Bin Jiang Da Dao Shanghai Pudong District
    +86 21 5054 1265
    Great wood fired pizzas and even tastier pastas, with outdoor seating available on fine evenings that make a trip here more than worthwhile. If you’re dining indoors though, you still may get a great view comparable to dining al fresco. With a number of restaurants spanning the continents, you’d expect the food at the Kitchen Salvatore Cuomo to be top-notch. Fortunately, the food at this particula ... read more >
  • Categories: Restaurants

    Neighborhood: Bund

    Cuisine:Asian Fusion/Pan-Asian

    1-3 Maojiayuan Lu near Zhongshan Dong Er Lu Shanghai Huangpu District
    +86 21 6080-2918
    The sleek and modern Table No. 1 restaurant in the Waterhouse hotel in South Bund houses the latest culinary creations from the mind of renowned chef Jason Atherton. The tables at Table No.1 are fashioned in a communal style so that the creative and tantalizing dishes, specifically created for sharing purposes, can be enjoyed by all members in your dining party. The menu features European classics ... read more >
  • Categories: Restaurants

    Neighborhood: Bund

    Cuisine:Chinese Beijing/Roast Duck, Chinese Shanghainese

    199 Huang Pu Lu Hyatt on the Bund Shanghai Huangpu District
    +86 21 6393 1234 x6318
    Arguably the best Peking duck in town. Or, at least that's what Privy members William Wong and Carol Lin seem to believe in their glowing reviews for Xindalu. Carol even goes as far as to call it a "must-stop" for entertaining guests which makes perfect sense when considering this restaurant offers fantastic Peking duck in a non-traditional and comfortable dining environment. The casual setting me ... read more >
  • Categories: Restaurants

    Neighborhood: Changning

    Cuisine:Chinese Shanghainese

    1221 Yan An West Road (Fan Yu Lu) Shanghai Changning District
    +86 21 6213 6585
    1221 Restaurant on Ya’an Xi road near Jiangsu train station in Changning is one of the most notable restaurants in town that presents fine dining in Shanghainese cuisine. The renowned restaurant has a big following of both expats and local clients as they have consistently wowed patrons for the past 8 years that they have immaculately and artistically presented the flavors of Shanghainese food. As ... read more >
  • Categories: Restaurants

    Neighborhood: French Concession

    Cuisine:Japanese, Japanese Sushi

    No. 20 Donghu Lu cross: Huaihai Zhong Lu Shanghai Xuhui District
    +86 21 5404 7705
    Great sushi and sashimi served here. Experts in omakase, much of the seafood is imported from Japan at Sushi Oyama but is still just as fresh. If you choose the omakase option, you’re at the mercy of the chef’s choice of dishes. But you certainly won’t be disappointed. In addition to sushi, there are some fine starters and desserts too. Both the quality of the food and the service are impeccable. ... 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 11:38 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
25869 ms 25869 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequest(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
17165 ms 17165 ms 1 D:/www/privy/shanghai/views/go/eat.cfm
17144 ms 17144 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
17144 ms 17144 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
14777 ms 2955 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
7761 ms 7761 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
7761 ms 7761 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
2247 ms 2247 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
398 ms 398 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
316 ms 0 ms 11481 D:/Mappings/lib-tag/getmaxminusone.cfm
248 ms 248 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
110 ms 110 ms 1 CFC[ D:/www/privy/shanghai/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/users.cfc
89 ms 89 ms 1 D:/www/privy/guestcfc/cfc_services_users_inc.cfm
53 ms 53 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
53 ms 53 ms 1 D:/www/privy/shanghai/layouts/go.cfm
51 ms 51 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequestStart(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
41 ms 41 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
38 ms 38 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/shanghai/Application.cfc
37 ms 37 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
23 ms 12 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
20 ms 20 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
17 ms 17 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = kitchesavatore.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
16 ms 16 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Table1_sucklingpig.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
13 ms 13 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = sushi oyama.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/shanghai/Application.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
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 = 1221.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = restaurants_content_21.jpg) ] 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.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/controllers/go.cfc | endeat(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 5 D:/Mappings/lib-tag/commaspace.cfm
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/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_comments.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
25922 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

11:38:49.049 - 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=13ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 11:38:25.025
		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/ANDREW-BIGBEE
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=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:38:25.025
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,ANDREW-BIGBEE

local.checksession (Datasource=entre360ds, Time=4781ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:38:29.029
	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=2977ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:38:32.032
	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=1ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:38:32.032
						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=2ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:38:32.032
			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=37ms, Records=25) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:38:32.032
			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) = eat

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

local.retval.getCategory (Datasource=entre360ds, Time=36ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:38:33.033
					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) = ANDREW-BIGBEE
Parameter #2(CF_SQL_CHAR) = ANDREW-BIGBEE
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=362ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:38:33.033
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '68' OR
							privy5codes LIKE '68,%' OR
							privy5codes LIKE '%,68' OR 
							privy5codes LIKE '%,68,%'
						) 
						AND (Location.ClosestPrivyCity=?)  
						 
						AND (Location.P5=1)
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getid (Datasource=entre360ds, Time=21ms, Records=1) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 11:38:33.033
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = ANDREW-BIGBEE

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

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:33.033
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:33.033
	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 @ 11:38:35.035
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=1ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:35.035
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:35.035
	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 @ 11:38:36.036
	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 @ 11:38:36.036
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:36.036
	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 @ 11:38:38.038
	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 @ 11:38:39.039
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:39.039
	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 @ 11:38:42.042
	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 @ 11:38:43.043
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:43.043
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=1ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:38:47.047
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=577ms, Records=17) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 11:38:49.049
	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=20ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:38:50.050
						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\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/eat/ANDREW-BIGBEE
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/ANDREW-BIGBEE
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: 637 ms