Privy 5 San Francisco Chinese Cantonese

You won't find a shortage of Chinese Cantonese restaurants in the Chinatown areas of the city, but, where exactly are the can't miss, top-notch Chinese Cantonese restaurants? You'll have to check out our list to find the answer.

Share |
  • Categories: Restaurants

    Neighborhood: SoMa

    1148 Mission St (between 7th St & Julia St) San Francisco CA 94103
    (415) 863-6008
    You come to Heaven’s Dog for the Cantonese food but you’ll be interested and perhaps surprised to learn that Heaven’s Dog is home to cocktails that are in a word, heavenly. In fact, people talk of these specialty cocktails and rank them as some of the best in San Francisco. Two of the better ones include the Gin Fizz Tropical and the Bumble Bee Cocktail. Unlike other Cantonese restaurants, Heaven’ ... read more >
  • Categories: Restaurants

    Neighborhood: Sunset District

    Cuisine:Seafood

    1420 Irving St (between 15th Ave & 16th Ave) San Francisco CA 94122
    (415) 665-8210
    South Sea Seafood Village is one of the classiest Cantonese and Dim Sum restaurants in San Francisco and is always satisfying when it comes to the food. At South Sea Seafood Village you can order from the dim sum trays brought around or you can order from the list provided on your table. To be certain you get everything you want, you’ll want to order from the kitchen directly. Some of the more del ... read more >
  • Categories: Restaurants

    Neighborhood: Richmond District

    6255 Geary Boulevard San Francisco CA 94121
    +1 415 387 8338
    Mayflower Seafood Restaurant is a great option for Cantonese food in San Francisco. Mayflower Seafood Restaurant is straightforward Chinese food and doesn’t deviate from making delicious dishes. If you’re lucky enough to visit when they have it, the seasonal pumpkin soup is an absolute must-try. The crab soup is also delicious and the noodles with crab features a good amount of crab pieces. Mayflo ... read more >
  • Categories: Restaurants

    Neighborhood: Chinatown

    Cuisine:Seafood

    631 Kearny Street San Francisco CA 94108
    +1 415 982 7877
    At R&G Lounge you’ll find authentic Cantonese cuisine in high form as this restaurant is possibly the best Cantonese restaurant not only in San Francisco but in all of California. Located in the heart of San Francisco Chinatown, R&G Lounge houses dishes that embodies true Cantonese tastes and preferences in a way that appeals to all comers. Each week you’ll find classic and also innovative dishes ... read more >
  • Categories: Restaurants

    Neighborhood: Chinatown

    1300 Stockton Street San Francisco CA 94133
    +1 415 982 6020
    One of the best aspects of Yuet Lee is the simple fact that it is open until 3am which makes it truly convenient to those craving Chinese food at odd hours of the night. However, another plus is that Yuet Lee serves up some authentic tasting Chinese food that really hits the spot. Beef with tomato over rice and chicken broth noodles are tasty as well as the egg noodles that are plentiful and go gr ... read more >

write a comment

Comments (0)

OTHER PRIVY 5 CITIES

Click here

Are you who we think you are?

  • Looks like we've already got some information from you on file.
  • Enter your password to link Facebook Connect with your existing Privy Guest account.


Debugging Information
ColdFusion Server Standard 2016,0,10,314028
Template /sanfrancisco/index.cfm
Time Stamp 23-Dec-19 11:05 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
5013 ms 5013 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequest(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
3552 ms 3552 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
3551 ms 3551 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
1299 ms 1299 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
1299 ms 1299 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
1299 ms 1299 ms 1 D:/www/privy/sanfrancisco/views/go/eat.cfm
1264 ms 253 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
57 ms 57 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
55 ms 55 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
17 ms 9 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
17 ms 17 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
17 ms 17 ms 1 D:/www/privy/sanfrancisco/layouts/go.cfm
14 ms 14 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
13 ms 13 ms 1 CFC[ D:/www/privy/newyork/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/users.cfc
10 ms 0 ms 3204 D:/Mappings/lib-tag/getmaxminusone.cfm
8 ms 8 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestStart(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
8 ms 8 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
5 ms 5 ms 1 D:/www/privy/guestcfc/cfc_services_users_inc.cfm
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
4 ms 4 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/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
4 ms 4 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
4 ms 4 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/sanfrancisco/Application.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Mayflower-San-Francisco-CA--United-States-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 = yuetlee.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
1 ms 1 ms 2 D:/Mappings/lib-tag/commaspace.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
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 = R---G-Lounge-1.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = South-Sea-Seafood-Village-3.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = heavensdog.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestEnd(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | endeat(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | init(CFC: sanfrancisco.Application) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_cityguide.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
5022 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=5ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 11:05:22.022
		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-CANTONESE
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

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

local.checksession (Datasource=entre360ds, Time=1981ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:05:24.024
	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=1560ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:05:26.026
	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=3ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:05:26.026
						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=4ms, Records=42) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:05:26.026
			SELECT Code, Category, directoryurl, picture2, IntroMiddle, whereto, star, shortenedurl 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND byprivymember=1 AND p5=1
			ORDER BY Category
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%

local.retval.query (Datasource=entre360ds, Time=1ms, Records=36) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:05:26.026
			SELECT Code, Category, directoryurl, picture3, IntroMiddle, whereto 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) 
			AND byprivymember IS NULL 
			AND p5=1 
				AND whereto = ? 
			ORDER BY Category
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%
Parameter #5(CF_SQL_CHAR) = eat

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

local.retval.getCategory (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:05:26.026
					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-CANTONESE
Parameter #2(CF_SQL_CHAR) = CHINESE-CANTONESE
Parameter #3(CF_SQL_CHAR) = San Francisco
Parameter #4(CF_SQL_CHAR) = San Francisco,%
Parameter #5(CF_SQL_CHAR) = %,San Francisco
Parameter #6(CF_SQL_CHAR) = %,San Francisco,%

local.retval.getlistinglocation (Datasource=entre360ds, Time=54ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:05:26.026
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '12' OR
							privy5codes LIKE '12,%' OR
							privy5codes LIKE '%,12' OR 
							privy5codes LIKE '%,12,%'
						) 
						AND (Location.ClosestPrivyCity=?)  
						 
						AND (Location.P5=1)
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

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

local.retval.comments (Datasource=entre360ds, Time=5ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 11:05:26.026
		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) = 12
Parameter #2(CF_SQL_CHAR) = San Francisco

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:05:26.026
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:05:26.026
	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:05:26.026
	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:05:26.026
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:05:26.026
	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:05:26.026
	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:05:26.026
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:05:26.026
	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:05:27.027
	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:05:27.027
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:05:27.027
	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:05:27.027
	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:05:27.027
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:05:27.027
	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:05:27.027
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=7ms, Records=0) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 11:05:27.027
	SELECT
		LOCATION.Name,
		LOCATION.LocationId,
		LOCATION.Privy5Codes,
		LOCATION.Privy5Text,
		LOCATION.Thumbnail,
		LOCATION.directoryurl,
		(
			SELECT privy5codes.whereto
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorywhereto2,
		(
			SELECT privy5codes.category
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorytext,
		(
			SELECT privy5codes.directoryurl
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categoryurl
	FROM PRIVY5TOPPLACES INNER JOIN LOCATION ON PRIVY5TOPPLACES.LocationId = LOCATION.LocationId
	WHERE (PRIVY5TOPPLACES.City = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%
Parameter #5(CF_SQL_CHAR) = San Francisco
Parameter #6(CF_SQL_CHAR) = San Francisco,%
Parameter #7(CF_SQL_CHAR) = %,San Francisco
Parameter #8(CF_SQL_CHAR) = %,San Francisco,%
Parameter #9(CF_SQL_CHAR) = San Francisco
Parameter #10(CF_SQL_CHAR) = San Francisco,%
Parameter #11(CF_SQL_CHAR) = %,San Francisco
Parameter #12(CF_SQL_CHAR) = %,San Francisco,%
Parameter #13(CF_SQL_CHAR) = San Francisco

local.getdb (Datasource=entre360ds, Time=13ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:05:27.027
						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\sanfrancisco\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=en, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=5955090; $Path=/; CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB; $Path=/; DESTINATION=Los%20Angeles; $Path=/; RECENTCITIES=Hong%20Kong%2CShanghai%2CLondon%2CLos%20Angeles%2CNew%20York%2CMacau; $Path=/
HTTP_HOST=www.privy.net
HTTP_REFERER=http://www.privy.net/sanfrancisco
HTTP_URL=/sanfrancisco/index.cfm/go/eat/CHINESE-CANTONESE
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/CHINESE-CANTONESE
PATH_TRANSLATED=d:\www\privy\sanfrancisco\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sanfrancisco/index.cfm
SERVER_NAME=www.privy.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=5955090
CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
DESTINATION=Los Angeles
RECENTCITIES=Hong Kong,Shanghai,London,Los Angeles,New York,Macau
Session Variables:
cfid=5955090
cftoken=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
sessionid=16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
urltoken=CFID=5955090&CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
Debug Rendering Time: 31 ms