Privy 5 New York Midnight Snack

When it's late and nothing else is open and you want something delicious to eat, you need a place that specializes in Midnight Snacks that taste good. We've made a list for the night owls out there that you don't want to miss.

Share |
  • Categories: Restaurants

    Neighborhood: East Village

    Cuisine:Pizza

    328 E 14th Street (between 1st Ave & 2nd Ave) New York NY 10003
    (212) 228-2004
    Frequented by David Chang of Momofuku fame and Keith Richards, you know what he is famous for don't you? Artichoke Basille's Pizza & Brewery fans read like a papal blessing; these young entrepreneurs have made it into the New York Times, as well as other just as venerable publications. Unassuming though the store-front may be, it is what is inside that counts; this hotbed has made pizza history an ... read more >
  • Categories: Restaurants

    Neighborhood: Upper West Side

    Cuisine:Fast Food, Hot Dogs

    2090 Broadway (between 72nd St & 73rd St) New York City NY 10023
    (212) 799-0243
    You would be forgiven for thinking Gray's Papaya is another health food shop, but you might be surprised when you find a hot dog shop instead. This is one of the top dog, hot dog spots with the snappiest, tastiest dogs in town. The name, which is emblazoned above the door in what appears to be mile high signage, stems from a mysterious papaya cocktail they serve that they claim does wonders for yo ... read more >
  • Categories: Restaurants

    Neighborhood: Midtown

    Cuisine:Halal

    1319 Avenue of the Americas 53rd Street and 6th Avenue New York City NY 10079
    In the downtown Theatre District (near the water feature) you will find the 53rd and 6th Halal Cart – it is great street vendor for late nights, and the white sauce is awesome, so you find queues lining up no matter the hour and this starts well before it opens at 7pm. This is street meat at its best with a lamb and chicken platter on rice with white sauce, costing a mere $6. The red sauce is hot ... read more >
  • Categories: Restaurants

    Neighborhood: Greenwich Village

    Cuisine:Middle Eastern

    119 MacDougal Street New York City NY
    (212) 674-8685
    There is something about getting a falafel fix or even shawarma in pita that works extra well after a late night out on the town. Mamoun's Falafel on St. Marks place is one of the best cheap street eats spots in NYC. The falafel is exploding with flavour – moist on the inside, crunchy and golden on the outside, the pita is fresh and they offer an extensive range of Middle Eastern food. With a hot ... read more >
  • Categories: Restaurants

    Neighborhood: East Village

    Cuisine:Belgian

    123 2nd Ave (between 7th St & St Marks Pl) New York NY 10003
    (212) 674-1234
    Pommes Frites; tater tots these are not and as small as this gourmet French fry shop is, it still turns out the best Belgian fries in town. Faux 19th-century French wood paneling, kitsch 60's Parisian pop tunes and sacks of potatoes decorate what is essentially a counter and register. But the compelling scent of the twice fried tubers, make this popular place too hard to pass up. They cook real ta ... 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:54 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
3835 ms 3835 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequest(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
1980 ms 1980 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
1979 ms 1979 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
1766 ms 1766 ms 1 D:/www/privy/newyork/views/go/eat.cfm
1765 ms 1765 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
1765 ms 1765 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
1735 ms 347 ms 5 D:/Mappings/lib-tag/cuisinetype.cfm
38 ms 38 ms 1 CFC[ D:/www/privy/seoul/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/seoul/services/cityguide.cfc
30 ms 30 ms 1 CFC[ D:/www/privy/seoul/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/seoul/services/cityguide.cfc
18 ms 0 ms 5607 D:/Mappings/lib-tag/getmaxminusone.cfm
7 ms 7 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestStart(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
5 ms 5 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
5 ms 3 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
5 ms 5 ms 1 D:/www/privy/newyork/layouts/go.cfm
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 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
2 ms 2 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | eat(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/seoul/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/seoul/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/seoul/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/seoul/services/users.cfc
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 | p5thumbnail(original = 53rd and 6th.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = artichoke-artichoke-spinach.JPG) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = l1120.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/seoul/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/seoul/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_views_comments.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 = ny_grays_papaya_hot_dogs_1_162.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = pommesfritesdefault.gif) ] 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.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5neighborhood, cityguide_p5neighborhood) ] 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/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] 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 1 CFC[ D:/www/privy/seoul/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/seoul/services/cityguide.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/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_login_popup.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_privy5cities.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3844 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=3ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 09:54: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/MIDNIGHT-SNACK
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=5ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:54:44.044
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,MIDNIGHT-SNACK

local.checksession (Datasource=entre360ds, Time=844ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:54: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=1127ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:54:46.046
	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:54: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

local.retval.query (Datasource=entre360ds, Time=2ms, Records=32) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:46.046
			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:54:46.046
			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=30ms, Records=30) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:46.046
			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=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:46.046
					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) = MIDNIGHT-SNACK
Parameter #2(CF_SQL_CHAR) = MIDNIGHT-SNACK
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=36ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:46.046
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '43' OR
							privy5codes LIKE '43,%' OR
							privy5codes LIKE '%,43' OR 
							privy5codes LIKE '%,43,%'
						) 
						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:54:46.046
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = MIDNIGHT-SNACK

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

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:54: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:54:46.046
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=1ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:54: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:54: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:54: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:54: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:54: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:54: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:54: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:54:47.047
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:54:47.047
	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:54:47.047
	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:54:47.047
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:54:47.047
	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:54:47.047
	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 @ 09:54:47.047
	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=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:54:47.047
						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/MIDNIGHT-SNACK
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/MIDNIGHT-SNACK
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: 49 ms