Privy 5 San Francisco Jeremy Lin

New York Knicks NBA Player

Jeremy Lin is the first Chinese/Taiwanese-American basketball player in the NBA. The California native, was an all state basketball player for Palo Alto High School, garnering several player of the year awards, and went on to Harvard University, setting numerous records on the court, while graduating with a degree in Economics. As an undrafted free agent, he made his rookie debut with his hometown Golden State Warriors in the 2010-11 season. From his spectacular performance against #1 pick John Wall in the NBA Summer League to hooping it up with the Warriors and NBA D-League Reno Bighorns, Jeremy Lin has been turning heads ever since. What makes Jeremy Lin such a success story is the seemingly insurmountable odds that he overcame to accomplish his dream of playing in the NBA. Jeremy Lin is the first full Asian-American player in the NBA in over 50 years, and first player from Harvard in over 50 years. Jeremy currently plays for the New York Knicks in Madison Square Garden. When he is not balling, you can probably find him playing Halo with his buddies, going to church with his friends, or at In 'n Out eating his favorite Double-Double with grilled onions and animal style fries. Linsanity!

To follow Jeremy Lin's amazing journey, visit his official site http://www.jlin7.com/ or follow him on Facebook: http://www.facebook.com/jeremylin7 and
Twitter: http://twitter.com/jlin7
You can also catch exclusive videos of Jeremy Lin at
http://www.youtube.com/user/Thejlin7

Privy 5 San Francisco Jeremy Lin
Privy Star
Share |
  • Categories: Restaurants

    Neighborhood: South Bay

    Cuisine:Korean BBQ

    1092 E El Camino Real Ste 1 Sunnyvale CA 94087
    (408) 554-9292
    Being inside Palace BBQ Buffet will treat you to an assortment of Korean BBQ fit for a king. No wonder, it was given such name. Very tender meat marinated to perfection, is what they serve best. Their sparer ribs barbecue is such a blast too. Their grills are unbelievable as it is able to cook up a BBQ in a jiffy. You should try their buffet if you want to get a taste of other Korean dishes and ma ... read more >
  • Categories: Restaurants

    Neighborhood: South Bay

    Cuisine:Burgers, Fast Food

    1159 North Rengstorff Avenue Mountain View 94043
    (800) 786-1000
    In-N-Out has always had a reputation of serving up fresh, quality burgers and the popularity of this burger chain is now at astronomical levels. Often imitated but never duplicated, In-N-Out makes some of the better burgers you'll ever sink your teeth into. Whether it's their famous Double-Double burger or their wonderfully fresh cut fries, you'll find yourself in burger heaven when at In-N-Out. P ... read more >
  • Categories: Restaurants

    Neighborhood: South Bay

    Cuisine:American (New)

    375 University Avenue Palo Alto CA 94301
    +1 650 473 9622
    As you'd expect, the cheesecake at The Cheesecake Factory is really good. This hugely popular restaurant continually serves up some of the finer cheesecakes you'll have and you'll often see people carrying out whole cakes or having a slice after dinner. But The Cheesecake Factory is much more than just dessert. Their menu spans all cuisines and each dish comes with very generous portions to make t ... read more >
  • Categories: Restaurants

    Neighborhood: South Bay

    Cuisine:Japanese Sushi

    1477 Plymouth St Mountain View CA 94041
    (650) 967-9279
    It doesn't get better than Hon Sushi for some of the biggest sushi rolls you'll find in the Bay Area. It gets even better when you compare the prices of Hon Sushi to other sushi places and then realize how much of a bang you get for your buck. Their tuna is spectacular and they have a variety of items on their menu. Plus, Hon Sushi is perfect for party planning with its generous portions. Also, Je ... read more >
  • Categories: Restaurants

    Neighborhood: South Bay

    900 High St Palo Alto San Francisco CA 94301
    (650) 323-3175
    You'll be like Daniel Day Lewis from the film "There Will Be Blood" when you come to Peninsula Creamery in the Bay Area. That is, you'll be wanting to drink some milkshakes up because at Peninsula Creamery it's all about the milkshakes. However, the restaurant also excels at stellar sandwiches, cookies, tuna melts and grilled cheese sandwiches. It has a cozy diner feel where you can enjoy your cr ... read more >

OTHER PRIVY 5 CITIES


Debugging Information
ColdFusion Server Standard 2016,0,10,314028
Template /sanfrancisco/index.cfm
Time Stamp 23-Dec-19 11:32 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
11960 ms 11960 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequest(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
8119 ms 8119 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
8118 ms 8118 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
3615 ms 3615 ms 1 D:/www/privy/sanfrancisco/views/jeremylin/overview.cfm
3614 ms 3614 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
3614 ms 3614 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
3530 ms 706 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
90 ms 90 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestStart(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
85 ms 0 ms 3204 D:/Mappings/lib-tag/getmaxminusone.cfm
75 ms 75 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
53 ms 53 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
52 ms 52 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
46 ms 46 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
37 ms 37 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
37 ms 37 ms 1 D:/www/privy/sanfrancisco/layouts/jeremylin.cfm
31 ms 16 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
31 ms 31 ms 1 CFC[ D:/www/privy/seoul/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/seoul/services/users.cfc
20 ms 20 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
17 ms 17 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
16 ms 16 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
15 ms 15 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
14 ms 14 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = inNout02.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = palace.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.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 = PeninsulaCreamery04.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Picture 2.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = chesecakefactory071.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.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.p5memberlist, cityguide_p5memberlist) ] 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 4 D:/Mappings/lib-tag/commaspace.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.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
36 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
12086 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=20ms, Records=1) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 11:32:33.033
		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) = jeremylin
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=53ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:32:33.033
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = jeremylin,overview,jeremylin

local.checksession (Datasource=entre360ds, Time=5614ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:32:39.039
	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=2434ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:32:41.041
	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=14ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:32:41.041
						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=42) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:32:41.041
			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=0ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:32:41.041
			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) = jeremylin.overview

local.retval.query (Datasource=entre360ds, Time=74ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:32:41.041
			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 'jeremylin' OR
							categorywhereto LIKE 'jeremylin,%' OR
							categorywhereto LIKE '%,jeremylin' OR 
							categorywhereto LIKE '%,jeremylin,%'
						)		 
					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:32:41.041
					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) = jeremylin
Parameter #2(CF_SQL_CHAR) = jeremylin
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=44ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:32:41.041
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '195' OR
							privy5codes LIKE '195,%' OR
							privy5codes LIKE '%,195' OR 
							privy5codes LIKE '%,195,%'
						) 
						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=0) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 11:32:41.041
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = jeremylin

local.getid (Datasource=entre360ds, Time=30ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 11:32:41.041
						SELECT locationid 
						FROM location 
						WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = jeremylin

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:41.041
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:41.041
	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:32:42.042
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:42.042
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:42.042
	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:32:42.042
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:43.043
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:43.043
	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:32:43.043
	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:32:43.043
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:43.043
	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:32:44.044
	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:32:44.044
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 11:32:44.044
	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:32:45.045
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.dbprivy5topplaces (Datasource=entre360ds, Time=20ms, Records=0) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 11:32:45.045
	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=16ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:32:45.045
						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/jeremylin
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/jeremylin
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: 163 ms