Privy 5 New York Mexican/Latin

The only other place to find Mexican and Latin food this authentic and delicious would be in Mexico and parts of Latin America. Even then the quality of the Mexican and Latin cuisine in this city is comparable and sometimes indistinguishable from the food you get in Mexico. Here's a list of the top places to find authentic Mexican and Latin food in this city.

Share |
  • Categories: Restaurants

    Neighborhood: East Village

    Cuisine:Mexican

    23 Avenue A (at 2nd St) New York NY 10009
    (212) 529-2919
    You’ll find a delicious Havana inspired meal at Yerba Buena without any pretension. The fine dining experience begins with the stunning cocktails which include Pisco Guava and Desert Rose just to name a few of the standouts. From the menu you’ll want to try their Palmitos Fritos and the short ribs which are expertly cooked and incredibly tasty. The romantic ambiance and the top notch and phenomena ... read more >
  • Categories: Restaurants

    Neighborhood: West Village

    Cuisine:Mexican

    50 Carmine St New York City NY 10014
    (212) 929-5050
    Cabrito is in fact an eponymous dish served in Latin America and spread to the American Southwest; this is made from the meat of a kid, which is actually a young goat. So Cabrito is more than just a name of a casual cantina in Manhattan, it is also one of their more popularly served meals. Rubbed with sour orange, garlic, and chile, then slow roast in banana leaf. Chef David Schuttenberg has let h ... read more >
  • Categories: Restaurants

    Neighborhood: Union Square

    Cuisine:Mexican

    9 East 18th Street, Union Square between 5th Avenue & Broadway New York City NY 10003
    +1 212 533 3350
    Rosa Mexicano is in actual fact a chain, with each having its own secret gifts. Neither chic, nor intimate like its older brother and sister, it comes across as downright gaudy. A blue tiled water-wall is the centre of attraction and bright primary colors have been blasted on walls. But patrons don't come for the dizzying décor, they come for the rich chunky guacamole – prepared tableside in a tra ... read more >
  • Categories: Restaurants

    Neighborhood: Midtown

    Cuisine:Mexican

    251 W. 50th St. (Between Broadway & 8th Ave) New York City NY 10019
    +1 212 581 1818
    Toloache is nothing to look at from the street, but Broadway has a way of life imitating art, or art imitating life, so nothing is ever as it seems to appear. This is a dedicated Mexican tavern decorated in silver lanterns and hand painted tile. Co-owner chef Julian Medina goes to town on the guacamoles which are mashed to order at the bar, as for the rest, he skips and hops all over Mexico. Oaxac ... read more >
  • Categories: Restaurants

    Neighborhood: East Village

    Cuisine:Mexican

    179 Avenue B 11th & 12th Streets New York City NY 10009
    +1 212 529 6490
    The mahi mahi tacos don't disappoint and in a nice celebrity story, a Mercadito aspiring actress/waitress saw Quentin Tarantino out for a walk, ran up to him, gave him a card and offered a round of drinks on her if he returned. He did, the next day, bringing along Benicio Del Toro – now that's a waitress who thinks on her feet! Patricio Sandoval is the Mexico City born chef-owner and Mercadito is ... read more >
  • Categories: Restaurants

    Neighborhood: Upper East Side

    Cuisine:Mexican

    174 East 82nd Street New York City NY 10028
    +1 212 717 7772
    Situated in the Grand Central Terminal, Lower Dining Concourse you will find Zocalo and they make the best passion fruit margarita to go. This is Julian Medina again, bringing Mexico City to NYC, and because of their immediate location they specialize in the most portable items of food and drink. Although table service is available, burritos and sandwiches are the order of the day for regular Mexi ... 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
3122 ms 3122 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequest(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
1683 ms 1683 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
1683 ms 1683 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
1304 ms 1304 ms 1 D:/www/privy/newyork/views/go/eat.cfm
1303 ms 1303 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
1303 ms 1303 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_multiplelisting.cfm
1272 ms 212 ms 6 D:/Mappings/lib-tag/cuisinetype.cfm
59 ms 59 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
45 ms 45 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
21 ms 0 ms 4005 D:/Mappings/lib-tag/getmaxminusone.cfm
7 ms 7 ms 1 CFC[ D:/www/privy/newyork/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/users.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 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/cfc_services_users_inc.cfm
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
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 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/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/newyork/Application.cfc
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/guestcfc/global_event.cfc | p5thumbnail(original = Zocalo-Uptown-3.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/newyork/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/newyork/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/newyork/Application.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 0 ms 6 D:/Mappings/lib-tag/commaspace.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_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_privy5topplaces.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 = Mercadito-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 = Yerba_Buena_ricekrispies.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = cabrito.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = rosamexicano.jpg) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = toloache06.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.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/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/newyork/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.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
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3128 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:54:35.035
		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/Mexican-Latin
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:54:35.035
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,eat,Mexican-Latin

local.checksession (Datasource=entre360ds, Time=577ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:54:35.035
	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=1101ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:54:36.036
	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:36.036
						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=3ms, Records=32) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:36.036
			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:36.036
			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=59ms, Records=30) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:36.036
			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:36.036
					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) = Mexican-Latin
Parameter #2(CF_SQL_CHAR) = Mexican-Latin
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=43ms, Records=6) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:54:36.036
					SELECT 
						*,
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							privy5codes LIKE '42' OR
							privy5codes LIKE '42,%' OR
							privy5codes LIKE '%,42' OR 
							privy5codes LIKE '%,42,%'
						) 
						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:36.036
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Mexican-Latin

local.retval.comments (Datasource=entre360ds, Time=4ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 09:54:36.036
		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) = 42
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:36.036
	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:36.036
	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:37.037
	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:37.037
	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:37.037
	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:37.037
	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:37.037
	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:37.037
	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:37.037
	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:37.037
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=1ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:54:37.037
	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:37.037
	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:37.037
	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:37.037
	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:37.037
	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:38.038
	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:38.038
	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:38.038
	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:54:38.038
	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:54:38.038
						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/Mexican-Latin
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/eat/Mexican-Latin
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: 37 ms