Privy 5 Los Angeles Chinese Shanghainese

As well as being characterized as seafood heavy, Chinese Shanghainese cuisine has other great traits. There are numerous Chinese Shanghainese restaurants in the city, featuring food from one of the easternmost cities on the planet in one of the westernmost.

Share |
  • Categories: Restaurants

    Neighborhood: San Gabriel Valley

    Cuisine:Chinese Shanghainese

    140 W Valley Blvd #211 San Gabriel CA 91776
    (626) 288-0991
    "The pan fried pork bun is superb. Eat it like a dumpling so that you can fully appreciate the juices. Lotus root is honeyed to perfection in another dish. Speaking of sweetness, a dessert soup enhanced with black sesame seed is fantastic. It’s great for a romantic meal, but the venue is particularly conducive to entertaining larger gatherings."
  • Categories: Restaurants

    Neighborhood: San Gabriel Valley

    Cuisine:Chinese Shanghainese

    301 W Valley Blvd Ste 112 San Gabriel CA 91776
    (626) 284-4769
    "Shanghai steamed dumplings here. It’s northern cuisine at its finest. The dumplings come in perfect portions of ten, but they’re a little big, so they’re good for sharing. Full of the natural pork flavors you may not find in other venues, where there are spices and herbs such as ginger enhancing the filling which means that they are extremely tasty. Also, a standout item on the menu is their Lion ... read more >
  • Categories: Restaurants

    Neighborhood: San Gabriel Valley

    Cuisine:Chinese Shanghainese

    828 W Valley Blvd Alhambra CA 91803
    (626) 588-2284
    Some of the best Kung Pao chicken here, and the creative honey shrimp is pretty good and attractive to Western tastes. It may help if you have some Chinese here, but the food is good in any language so you don’t have to take great care if you mistakenly order something you didn’t think you’d like as you'll find that you probably will end up enjoying it. The prices are so reasonable and the menu is ... read more >
  • Categories: Restaurants

    Neighborhood: San Gabriel Valley

    Cuisine:Chinese Shanghainese

    156 S San Gabriel Blvd San Gabriel CA 91776
    (626) 291-2233
    Shanghai short ribs are deliciously cooked first and then marinated in a sweet sauce. Battered and deep fried before being stir fried, a lot of trouble has gone into creating these bite sized pieces of deliciousness. There is a great selection of both Shanghai and more general Chinese dishes on the menu. Round things out with the fermented rice dessert soup with black sesame rice balls and you’ll ... read more >
  • Categories: Restaurants

    Neighborhood: San Gabriel Valley

    Cuisine:Chinese Shanghainese

    301 W Valley Blvd San Gabriel CA 91776
    (626) 308-9238
    "The people who come here regularly always order the Shanghai noodles. This may be a gross generalization, even a slight, perhaps, on the regulars who prefer the delicious bite sized pork or crabmeat dumplings (xlbs) or the quite fragrant and utterly tasty scallion pancakes. However, it might be a good idea to be a noodles fan if you find yourself here. They’re very tasty. The dumplings are golden ... read more >

write a comment

Comments (0)

PRIVY TOP 5 PLACES IN LOS ANGELES

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 /losangeles/index.cfm
Time Stamp 23-Dec-19 09:24 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
2422 ms 2422 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | onRequest(/losangeles/index.cfm) ] from D:/www/privy/losangeles/Application.cfc
1284 ms 1284 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
1284 ms 1284 ms 1 D:/www/privy/losangeles/views/go/eat.cfm
1283 ms 1283 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
1133 ms 227 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
1040 ms 1040 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/losangeles/controllers/go.cfc
1040 ms 1040 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
124 ms 124 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
38 ms 38 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
36 ms 36 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
11 ms 0 ms 3738 D:/Mappings/lib-tag/getmaxminusone.cfm
5 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
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
5 ms 5 ms 1 D:/www/privy/losangeles/layouts/go.cfm
4 ms 4 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | onRequestStart(/losangeles/index.cfm) ] from D:/www/privy/losangeles/Application.cfc
4 ms 4 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/losangeles/controllers/go.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/losangeles/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/losangeles/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/users.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = J & J Restaurant 3.JPG) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = meilongvillage.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = wokandnoodle.jpeg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/losangeles/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/losangeles/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | endeat(rc = [complex value]) ] from D:/www/privy/losangeles/controllers/go.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 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 = shanghai restaurant1.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = wangjia.jpeg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | onRequestEnd(/losangeles/index.cfm) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | init(CFC: losangeles.Application) ] from D:/www/privy/losangeles/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2428 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 @ 09:24:35.035
		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/CHINESE-SHANGHAINESE
Parameter #2(CF_SQL_CHAR) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.getwebpg (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:24:35.035
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,CHINESE-SHANGHAINESE

local.checksession (Datasource=entre360ds, Time=518ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:24:36.036
	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=516ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:24:36.036
	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 @ 09:24:36.036
						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=55) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:24:36.036
			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) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%

local.retval.query (Datasource=entre360ds, Time=1ms, Records=41) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:24:36.036
			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) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #5(CF_SQL_CHAR) = eat

local.retval.query (Datasource=entre360ds, Time=35ms, Records=14) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:24:36.036
			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) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles

local.retval.getCategory (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:24:36.036
					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) = CHINESE-SHANGHAINESE
Parameter #2(CF_SQL_CHAR) = CHINESE-SHANGHAINESE
Parameter #3(CF_SQL_CHAR) = Los Angeles
Parameter #4(CF_SQL_CHAR) = Los Angeles,%
Parameter #5(CF_SQL_CHAR) = %,Los Angeles
Parameter #6(CF_SQL_CHAR) = %,Los Angeles,%

local.retval.getlistinglocation (Datasource=entre360ds, Time=37ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:24:36.036
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '18' OR
							privy5codes LIKE '18,%' OR
							privy5codes LIKE '%,18' OR 
							privy5codes LIKE '%,18,%'
						) 
						AND (Location.ClosestPrivyCity=?)  
						 
						AND (Location.P5=1)
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getid (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 09:24:36.036
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CHINESE-SHANGHAINESE

local.retval.comments (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 09:24:36.036
		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) = 18
Parameter #2(CF_SQL_CHAR) = Los Angeles

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:24: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 @ 09:24: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 @ 09:24: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 @ 09:24: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 @ 09:24:36.036
	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 @ 09:24:37.037
	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 @ 09:24:37.037
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:24:37.037
	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 @ 09:24:37.037
	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 @ 09:24:37.037
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:24:37.037
	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 @ 09:24:37.037
	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 @ 09:24:37.037
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:24:37.037
	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 @ 09:24:37.037
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=112ms, Records=22) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 09:24:37.037
	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) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #5(CF_SQL_CHAR) = Los Angeles
Parameter #6(CF_SQL_CHAR) = Los Angeles,%
Parameter #7(CF_SQL_CHAR) = %,Los Angeles
Parameter #8(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #9(CF_SQL_CHAR) = Los Angeles
Parameter #10(CF_SQL_CHAR) = Los Angeles,%
Parameter #11(CF_SQL_CHAR) = %,Los Angeles
Parameter #12(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #13(CF_SQL_CHAR) = Los Angeles

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:24:37.037
						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\losangeles\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/losangeles
HTTP_URL=/losangeles/index.cfm/go/eat/CHINESE-SHANGHAINESE
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/CHINESE-SHANGHAINESE
PATH_TRANSLATED=d:\www\privy\losangeles\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/losangeles/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: 36 ms