Privy 5 New York Business Lunch

If you're looking to make a deal over a Business Lunch, you've come to the right city. This is where deals are made, so it comes as no surprise to find there are plenty of ritzy places to wine and dine potential investors and clients at power and Business Lunch.

Share |
  • Categories: Restaurants

    Neighborhood: Midtown

    Cuisine:American (New)

    24 West 55th Street (between Fifth and Sixth Avenues) New York City NY 10019
    +1 212 767 0555
    Haute California is the cuisine at Michael's Midtown fine food purveyors. Bearing this in mind, Michael McCarty's skill with a fish skillet attracts media moguls, publishers and anyone who has the desire to schmooze. Michael's epitomizes the "power lunch" with its conference room chrome, track lighting, Breuer Cesca seating, collection of contemporary art and wall to wall carpets. Everyone one who ... read more >
  • Categories: Restaurants

    Neighborhood: Upper West Side

    Cuisine:French

    1 Central Park West (at Columbus Circle and West 60th Street), Trump International Hotel and Tower New York City NY 10023
    +1 212 299 3900
    Nougatine is another one of Mr. V's (Jean-Georges Vongerichten), French cuisine, critics' picks, where the food is good and the business is better. This notable chef has created a spot which is somewhat of a hidden gem of a restaurant in New York. The terrazzo floor looks good enough to eat in its resemblance to a huge slab of Nougatine and the dining space is adorned in modern blond-wood and litt ... read more >
  • Categories: Restaurants

    Neighborhood: Theatre District

    Cuisine:American (New), French

    55 West 44th Street New York City NY 10036
    +1 212 391 2400
    If you are looking for a good business lunch, which also features celebrity distractions in the Theatre District, you may find Daniel Boulud's boîte to be fun. Be warned, it is casual, hectic, service can be slow and the rooms are a little small, but the food is worth the wait and this gives you time to talk business. You would be excused for calling the DB Burger a hamburgler, it is a signature d ... read more >
  • Categories: Restaurants

    Neighborhood: Midtown

    Cuisine:French

    151 E 58th St (between 3rd Ave & Lexington Ave) New York City NY 10022
    (212) 644-0202
    If Henry Kissinger and Condoleezza Rice, Government big-guns, can be seen in serious talks over dinner at Le Cirque - it is highly recommended as a hushed business dinner/lunch venue. The cuisine is French, the décor is reserved, but it does look out over the impressive stone courtyard of the Bloomberg corporate headquarters. Don't let the name fool you, this is not a restaurant for over exuberant ... read more >
  • Categories: Restaurants

    Neighborhood: Financial District

    Cuisine:American (Traditional)

    225 Liberty St. 2 World Financial Ctr New York NY 10281
    (212) 945-9400
    Although the Grill Room at the Four Seasons, is a celebrity spotters classic haunt, it is also still an excellent business lunch choice. There might also be better places to eat, but the actual "Grill Room" itself brings together a menagerie of New York power brokers, like lions at feeding time. It's ok, business lunches are on an expense account, so Bloody Mary's and bison carpaccio, Dover sole a ... 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 /newyork/index.cfm
Time Stamp 23-Dec-19 09:48 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
2336 ms 2336 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequest(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
1207 ms 1207 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
1207 ms 1207 ms 1 D:/www/privy/newyork/views/go/eat.cfm
1206 ms 1206 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
1179 ms 236 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
1044 ms 1044 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
1044 ms 1044 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
31 ms 31 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
30 ms 30 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
13 ms 0 ms 3738 D:/Mappings/lib-tag/getmaxminusone.cfm
6 ms 6 ms 1 D:/www/privy/newyork/layouts/go.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 CFC[ D:/www/privy/newyork/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
4 ms 4 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestStart(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/newyork/Application.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/newyork/Application.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/users.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Michael-s-New-York-City-NY--United-States-3.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/newyork/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.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_login_popup.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 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 = DB-BISTRO04.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = Le-Cirque-New-York-NY--United-States-of-America-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 = Nougatine01.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = thegrillroom06.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestEnd(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | endeat(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | init(CFC: newyork.Application) ] from D:/www/privy/newyork/controllers/go.cfc
0 ms 0 ms 5 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/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_privy5cities.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2341 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:48:44.044
		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/BUSINESS-LUNCH
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

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

local.checksession (Datasource=entre360ds, Time=518ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:48:44.044
	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=519ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:48:45.045
	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:48: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

local.retval.query (Datasource=entre360ds, Time=2ms, Records=32) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:48:45.045
			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) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%

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

local.retval.query (Datasource=entre360ds, Time=31ms, Records=30) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:48:45.045
			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) = New York
Parameter #2(CF_SQL_CHAR) = New York

local.retval.getCategory (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:48:45.045
					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) = BUSINESS-LUNCH
Parameter #2(CF_SQL_CHAR) = BUSINESS-LUNCH
Parameter #3(CF_SQL_CHAR) = New York
Parameter #4(CF_SQL_CHAR) = New York,%
Parameter #5(CF_SQL_CHAR) = %,New York
Parameter #6(CF_SQL_CHAR) = %,New York,%

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

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

local.retval.comments (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 09:48:45.045
		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) = 9
Parameter #2(CF_SQL_CHAR) = New York

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

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