Privy 5 San Francisco Dessert/Bakeries

Dessert places and bakeries are almost everywhere you go in this city. With that said, you need a guide that will take you to the top Dessert/Bakeries amongst the hundreds of choices and luckily for you, we've set you on your way with 5 amazing dessert places and bakeries.

Share |
  • Categories: Restaurants

    Neighborhood: Noe Valley

    Cuisine:Desserts

    688 San Jose Ave (between Valley St & 29th St) San Francisco CA 94110
    (415) 648-2300
    Mitchell’s has been perfecting the art of ice cream making for half a century now. The shop gained popularity with their wonderful flavors that neighboring restaurants and establishments started to order from them making the family business flourish until today earning plenty of awards and being featured on many magazines and shows. Exotic flavors that use tropical ingredients like yam and jackfru ... read more >
  • Categories: Restaurants

    Neighborhood: East Bay

    Cuisine:Desserts

    4226 Piedmont Ave (between Entrada Ave & Ridgeway Ave) Oakland CA 94611
    (510) 658-7000
    Fenton’s have been serving handmade ice cream for well over a century and it continues to be as popular as ever. Their deliciously made ice cream has become so beloved that Fenton's Creamery even made it's way into Pixar's "Up." The family-friendly and welcoming restaurant has everything including breakfast specials, special kids menu, salads, burgers and of course their famous ice cream flavors. ... read more >
  • Categories: Restaurants

    Neighborhood: Chinatown

    Cuisine:Desserts

    1029 Grant Ave (between Jackson St & Pacific Ave) San Francisco CA 94113
    (415) 781-2627
    One would think that people outside this hole in the wall shop are lining up for a premiere movie showing because of the very long line of eager pastry shoppers that just can’t get enough of their famous tarts. The Chinese bakery is said to have the best egg tarts on this side of the hemisphere. Other mouth watering treats include the coconut lemon roll, barbecue pork buns and moon cakes. The shop ... read more >
  • Categories: Restaurants

    Neighborhood: Mission District

    Cuisine:Desserts

    3692 18th Street (between Dolores St & Oakwood St) San Francisco CA 94110
    +1 415 626 5600
    Bi-rite is a creamery and bakeshop rolled into one sweet lovers’ haven. They offer all organic products like sorbets, ice creams, sundaes, ice cream cakes and pies, and many other baked goodies. They make everything in their own shop including their very own marshmallows and source ingredients from local farms so one can be sure of quality and freshness. Drop by and surprise yourself with the Pops ... read more >
  • Categories: Restaurants

    Neighborhood: Mission District

    Cuisine:Cafe/Coffee/Tea/Bakery

    600 Guerrero Street (at 18th Street) San Francisco CA 94110
    +1 415 487 2600
    Tartine Bakery and Cafe will surely capture anybody’s dessert palate and a James Beard Award says it all. Culinary superstar couple Elisabeth Prueitt and Chad Robertson have made a quite a name in the industry and have authored great cookbooks. Their shop takes pride in sourcing local and organic ingredients in creating their delightful menu. Have a quiche or pastry for breakfast, pastrami or pros ... 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:11 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
11555 ms 11555 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequest(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
8434 ms 8434 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
8434 ms 8434 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
8434 ms 8434 ms 1 D:/www/privy/sanfrancisco/views/go/eat.cfm
8351 ms 1670 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
2429 ms 2429 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
2429 ms 2429 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
451 ms 451 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
154 ms 154 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
123 ms 0 ms 9879 D:/Mappings/lib-tag/getmaxminusone.cfm
28 ms 28 ms 1 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
26 ms 13 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 | p5thumbnail(original = birite.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
19 ms 19 ms 1 CFC[ D:/www/privy/sanfrancisco/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/users.cfc
17 ms 17 ms 1 D:/www/privy/guestcfc/cfc_services_users_inc.cfm
16 ms 16 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
16 ms 16 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
13 ms 13 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
13 ms 13 ms 1 D:/www/privy/sanfrancisco/layouts/go.cfm
10 ms 10 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
9 ms 9 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/sanfrancisco/Application.cfc
7 ms 7 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Store 2.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
5 ms 5 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestStart(/sanfrancisco/index.cfm) ] 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
2 ms 2 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
2 ms 2 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
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/sanfrancisco/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/sanfrancisco/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/sanfrancisco/Application.cfc
1 ms 0 ms 5 D:/Mappings/lib-tag/commaspace.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_comments.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
0 ms 0 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | ip4todecimal(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = banana cream pie 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 = fentons_bananasplit.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = goldengatebakery.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.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/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 CFC[ D:/www/privy/sanfrancisco/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/sanfrancisco/services/cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
11562 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 @ 11:11:06.006
		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/Dessert-Bakeries
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=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:11:06.006
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,Dessert-Bakeries

local.checksession (Datasource=entre360ds, Time=904ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:11:06.006
	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=1508ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:11:08.008
	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=16ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:11:08.008
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176

local.retval.query (Datasource=entre360ds, Time=27ms, Records=42) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:11:08.008
			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=2ms, Records=36) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:11:08.008
			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=451ms, Records=31) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:11:09.009
			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=4ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:11:09.009
					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) = Dessert-Bakeries
Parameter #2(CF_SQL_CHAR) = Dessert-Bakeries
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=150ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:11:09.009
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '22' OR
							privy5codes LIKE '22,%' OR
							privy5codes LIKE '%,22' OR 
							privy5codes LIKE '%,22,%'
						) 
						AND (Location.ClosestPrivyCity=?)  
						 
						AND (Location.P5=1)
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

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

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

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:11:09.009
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:11:09.009
	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:11:09.009
	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:11:09.009
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:11:09.009
	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:11:10.010
	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:11:11.011
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=9ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:11:11.011
	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:11:11.011
	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:11:12.012
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:11:12.012
	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:11:14.014
	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:11:16.016
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:11:16.016
	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:11:17.017
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 11:11:17.017
	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=9ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:11:17.017
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176


Scope Variables

Application Variables:
applicationname=16674C21BBD774F3F0CD46198107AC84
devmode=false
dsn_name=entre360ds
dsn_name10=entre360_2011ds
event=Struct (26)
ipallow=24.199.44.252
magazine_imageupload=/upload/net/privy/www/p5photos/
org.corfield.framework=Struct (3)
[email protected]
paypal_url=https://www.paypal.com/cgi-bin/webscr
recaptcha_private=6LfrQtQSAAAAAGuECx5CZ5jRb4TPBzgrBVTK_IPH
recaptcha_public=6LfrQtQSAAAAALsfdvrJmY-JULezQbwYw4ea1nE2
site_addr=www.privy.net
upload=/upload/net/privy/www/
upload_magazine=/upload/net/privy/www/p5photos/
upload_root=/upload/net/privy/
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=d:\www\privy\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/Dessert-Bakeries
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/Dessert-Bakeries
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: 96 ms