Privy 5 Shanghai Japanese Sushi

Sushi is incredibly popular in this city and that means numerous Japanese Sushi restaurants specialize in providing sushi. But only the best make our lists and you'll want to read on for descriptions of these top Japanese Sushi restaurants.

Share |
  • Categories: Restaurants

    Neighborhood: Pudong

    Cuisine:Japanese, Japanese Sushi

    33 Fucheng Lu 2F, Tower 2, Pudong Shangri-La Shanghai Pudong District
    +86 21 6882 8888 x 260
    There’s nothing wrong with liking all-you-can-eat sushi but for the Japanese sushi connoisseur there is the Nadaman at the Pudong Shangri-La Hotel for a truly upscale and unforgettable sushi dining experience. As the opposite of all-you-can-eat, Nadaman specializes in what the Japanese call “Kaiseki-ryori,” perhaps the most formal of all Japanese meals. It comes in several courses and the highligh ... read more >
  • Categories: Restaurants

    Neighborhood: Hongqiao

    Cuisine:Japanese, Japanese Sushi

    3911 Hongmei Lu House 9 near Yan'an Xi Lu Shanghai Changning District
    +86 21 6261 6179
    All you can drink is one of the features here, but you’ll want to make sure that your taste buds aren’t deadened by the beer or sake before you’ve finished your meal. The floors have tatami mats that echo the traditional style of Japan. You can do hot pot here, but the salmon sashimi is a star dish. Teppanyaki beef and pork cutlets are two of the heavier items on the menu if the fish is too light. ... read more >
  • Categories: Restaurants

    Neighborhood: N/A

    Cuisine:Japanese, Japanese Sushi

    58 Maoming Rd. (S) 2/F Okura Garden Hotel Shanghai Shanghai 200020
    +86 21 6415 1111
    This new and elegant restaurant venue in the Okura Garden Hotel provides a great range of Japanese dishes at great prices. Reds, blacks and white, with lighting that is bright without being garish, all make for an interesting environment for you and friends to enjoy a meal. Or, if you prefer private dining, Yamazato has a number of private rooms with distinct Japanese style. For starters there’s a ... 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 >
  • Categories: Restaurants

    Neighborhood: Jing An

    Cuisine:Japanese, Japanese Soba/Udon, Japanese Sushi

    98 Yanping Lu Bldg C Near Xinzha Lu Shanghai Jing An District
    +86 21 5175 9819
    Once you have a taste of their sashimi, you’ll find yourself happy you chose to eat at Shoka. It is a restaurant that prides itself on providing an excellent dining experience. With samba music, good salad, and sushi that is the perfect mix of filling and rice you’ll understand why. The tempura prawns and the noodle dishes are delicious. Beef is offered too, as well as a variety of grilled meat. T ... 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:06 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
17447 ms 17447 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequest(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
12508 ms 12508 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
12508 ms 12508 ms 1 D:/www/privy/shanghai/views/go/eat.cfm
12507 ms 12507 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
11952 ms 2390 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
4793 ms 4793 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
4793 ms 4793 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
513 ms 513 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
113 ms 0 ms 12549 D:/Mappings/lib-tag/getmaxminusone.cfm
52 ms 52 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
47 ms 47 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
12 ms 12 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
9 ms 9 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/shanghai/Application.cfc
6 ms 3 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 D:/www/privy/shanghai/layouts/go.cfm
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
4 ms 4 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequestStart(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.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
2 ms 2 ms 1 CFC[ D:/www/privy/shanghai/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/users.cfc
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 = Nadaman Japanese Restaurant-7636.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = shoka.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 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.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_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 = hatsuhana.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = sushi oyama.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = yamazato.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 5 D:/Mappings/lib-tag/commaspace.cfm
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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
17452 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:06:41.041 - 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=1ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 12:06:24.024
		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/JAPANESE-SUSHI
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 @ 12:06:24.024
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,JAPANESE-SUSHI

local.checksession (Datasource=entre360ds, Time=2386ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:06:27.027
	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=2401ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:06:29.029
	SELECT 
		memberguests_login.memberid,
	 	memberguests_login.logindatetime,
	 	memberguests_login.loginvia,
	 	memberguests_login.logoutdatetime,
	 	memberguests_login.sessionid,
	 	memberguests_login.fbuid,
	 	memberguests_login.fbaccesstoken,
	 	memberguests_login.fbsignedrequest,
	 	memberguests_login.fbexpiresin,
	 	memberguests_login.fbpicture,
	 	memberguests_login.logininviteonly 
	FROM memberguests_login 
	WHERE sessionid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB

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

local.retval.query (Datasource=entre360ds, Time=1ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:06:29.029
			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=1ms, Records=25) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:06:29.029
			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=47ms, Records=18) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:06:29.029
			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=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:06:29.029
					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) = JAPANESE-SUSHI
Parameter #2(CF_SQL_CHAR) = JAPANESE-SUSHI
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=50ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:06:29.029
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					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) = Shanghai

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

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

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:06:29.029
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:06:29.029
	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:06:30.030
	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:06:30.030
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:06:30.030
	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:06:32.032
	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:06: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 @ 12:06: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 @ 12:06:35.035
	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:06: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 @ 12:06: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 @ 12:06:40.040
	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:06:40.040
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=1ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:06:40.040
	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:06:41.041
	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:06:41.041
	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:06:42.042
						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/JAPANESE-SUSHI
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/JAPANESE-SUSHI
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: 137 ms