Muse 2 (M2) - Nanjing Xi Lu

Muse 2 or M2 is a widely popular Shanghai hot spot and is part of a trilogy of successful nightlife venues from the Muse entertainment line. M2 combines a restaurant, lounge, and nightclub all ...

Lounge 18 - Bund

A newer addition to the Bund''s nightlife, Lounge 18 distinguishes itself from the usual lounge by offering a unique concept of incorporating the classic Shanghai night life with modern furniture and ...

The Strip Prime Steakhouse - Xintiandi

For steak lovers, this steakhouse has some of the best cuts of meat in all of Shanghai. Diners who are fans of Roosevelt Prime Steakhouse will be excited to know that ...

Bar Rouge - Bund

Bar Rouge invaded the Shanghai nightlife scene with the premise of bringing the "French tough" into Shanghainese clubbing. The classy, sleek, and ...

Jean Georges - Bund

One step into this elegant restaurant and you''ll immediately notice the grandeur of old Shanghai meeting romantic French influence.

Dining Room in Park Hyatt - Pudong

You''ll find authentic European cuisine in an elegant and serene restaurant at the Dining Room. While you dine, you''ll be able to enjoy spectacular views of the city.

Table No. 1

The sleek and modern Table No. 1 restaurant in the Waterhouse hotel in South Bund houses the latest culinary creations from the mind of renowned chef Jason Atherton.

C''est Cupcake - Hongqiao

Featuring jaw-dropping design and presentation and utilizing only the finest ingredients, each cupcake at this Shanghai cupcakery is made with intricate care to design a delicious and decadent treat.

PRIVY TOP 5 PLACES IN SHANGHAI

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 /shanghai/index.cfm
Time Stamp 23-Dec-19 09:04 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
2195 ms 2195 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequest(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
1065 ms 1065 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
1065 ms 1065 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
731 ms 731 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_overview.cfm
731 ms 731 ms 1 D:/www/privy/shanghai/views/go/overview.cfm
376 ms 376 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | weather(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
370 ms 370 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
24 ms 24 ms 1 D:/www/privy/guestcfc/inc_popular_posts.cfm
17 ms 17 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ConvertXmlToStruct(<?xml version="1.0" encoding="utf-8"?><rss version="2.0"><channel><title>Longshengzhuang Zhen, China latest weather forecast</title><link>https://www.worldweatheronline.com/weather.aspx?q=Longshengzhuang Zhen, China</link><description>Longshengzhuang Zhen, China current weather observation and today and tomorrow weather summary Powered by World Weather Online (http://www.worldweatheronline.com)</description><item><title>Current weather: Partly cloudy</title><description><![CDATA[<img src="http://cdn.worldweatheronline.net/images/wsymbols01_png_64/wsymbol_0004_black_low_cloud.png" align="top" /><br />Temp: -12&deg;c (10&deg;f)<br />Wind: S at 4 mph (6 kmph)]]></description><link>https://www.worldweatheronline.com/weather.aspx?q=Longshengzhuang Zhen, China</link></item><item><title>Today's weather: Patchy moderate snow</title><description><![CDATA[<img src="http://cdn.worldweatheronline.net/images/wsymbols01_png_64/wsymbol_0020_cloudy_with_heavy_snow.png" align="top" /><br />High: -6&deg;c (22&deg;f); Low: -13&deg;c (8&deg;f)<br />Wind: SSW at 5 mph (8 kmph)]]></description><link>https://www.worldweatheronline.com/weather.aspx?q=Longshengzhuang Zhen, China&amp;day=0</link></item><item><title>Tomorrow's weather: Partly cloudy</title><description><![CDATA[<img src="http://cdn.worldweatheronline.net/images/wsymbols01_png_64/wsymbol_0002_sunny_intervals.png" align="top" /><br />High: -6&deg;c (22&deg;f); Low: -11&deg;c (12&deg;f)<br />Wind: NW at 4 mph (7 kmph)]]></description><link>https://www.worldweatheronline.com/weather.aspx?q=Longshengzhuang Zhen, China&amp;day=1</link></item></channel></rss>, [complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
6 ms 2 ms 3 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/shanghai/layouts/go.cfm
4 ms 4 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequestStart(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 17) ] 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/shanghai/controllers/go.cfc | overview(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.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/shanghai/Application.cfc | service(cityguide.slides, cityguide_slides) ] from D:/www/privy/shanghai/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | privystar(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
0 ms 0 ms 4 CFC[ D:/www/privy/guestcfc/cfc_helper_view.cfc | getrightaction2(PEOPLE ) ] from D:/www/privy/guestcfc/cfc_helper_view.cfc
0 ms 0 ms 4 CFC[ D:/www/privy/guestcfc/cfc_helper_view.cfc | getrightaction2(SOCIETY+EVENTS ) ] from D:/www/privy/guestcfc/cfc_helper_view.cfc
0 ms 0 ms 3 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 | ucaseOnFirstChar(Asian Fusion/Contemporary) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Attractions) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Bar/Lounges) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Brunch) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Burgers) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Business Lunch) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Cantonese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Dim Sum) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Dumplings) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Hot Pot) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Shanghainese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Sichuan) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Clubs/Dancing) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Cocktail Specialists) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Dessert/Bakeries) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Foot Massage) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(French) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hotel Bars) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hotels) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Indian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Italian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Noodles) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Sushi) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Jazz Clubs) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Mexican/Latin) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(New/American) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Romantic Restaurants) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Seafood) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Shopping Areas/Malls) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Spa) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Steakhouses) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Taiwanese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Thai) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vietnamese Pho) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(View Bars) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Wine List) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequestEnd(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.privystar, cityguide_privystar) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.weather, cityguide_weather) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | endoverview(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | init(CFC: shanghai.Application) ] from D:/www/privy/shanghai/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | slides(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
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
2200 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

09:04:02.002 - Application Exception - in D:/www/privy/guestcfc/inc_privy5topplaces.cfm : line 85
	    An exception occurred while trying to write the image.
	    


SQL Queries

local.getwebpg (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:04:00.000
				SELECT * FROM webpg_event WHERE pageid = 1
			
local.checksession (Datasource=entre360ds, Time=525ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:04:00.000
	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=525ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:04:01.001
	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:04:01.001
						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=2) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:04:01.001
			SELECT * 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND star=1 AND p5=1
			ORDER BY orderstar
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%

local.retval.query (Datasource=entre360ds, Time=1ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:04:01.001
			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) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%

local.retval.query (Datasource=entre360ds, Time=1ms, Records=37) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:04:01.001
			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 
			ORDER BY Category
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '68' OR
										privy5codes LIKE '68,%' OR
										privy5codes LIKE '%,68' OR 
										privy5codes LIKE '%,68,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '129' OR
										privy5codes LIKE '129,%' OR
										privy5codes LIKE '%,129' OR 
										privy5codes LIKE '%,129,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '133' OR
										privy5codes LIKE '133,%' OR
										privy5codes LIKE '%,133' OR 
										privy5codes LIKE '%,133,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '69' OR
										privy5codes LIKE '69,%' OR
										privy5codes LIKE '%,69' OR 
										privy5codes LIKE '%,69,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '70' OR
										privy5codes LIKE '70,%' OR
										privy5codes LIKE '%,70' OR 
										privy5codes LIKE '%,70,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '71' OR
										privy5codes LIKE '71,%' OR
										privy5codes LIKE '%,71' OR 
										privy5codes LIKE '%,71,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '124' OR
										privy5codes LIKE '124,%' OR
										privy5codes LIKE '%,124' OR 
										privy5codes LIKE '%,124,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '67' OR
										privy5codes LIKE '67,%' OR
										privy5codes LIKE '%,67' OR 
										privy5codes LIKE '%,67,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '66' OR
										privy5codes LIKE '66,%' OR
										privy5codes LIKE '%,66' OR 
										privy5codes LIKE '%,66,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '3' OR
									privy5codes LIKE '3,%' OR
									privy5codes LIKE '%,3' OR 
									privy5codes LIKE '%,3,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '4' OR
									privy5codes LIKE '4,%' OR
									privy5codes LIKE '%,4' OR 
									privy5codes LIKE '%,4,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '5' OR
									privy5codes LIKE '5,%' OR
									privy5codes LIKE '%,5' OR 
									privy5codes LIKE '%,5,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '7' OR
									privy5codes LIKE '7,%' OR
									privy5codes LIKE '%,7' OR 
									privy5codes LIKE '%,7,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '8' OR
									privy5codes LIKE '8,%' OR
									privy5codes LIKE '%,8' OR 
									privy5codes LIKE '%,8,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '12' OR
									privy5codes LIKE '12,%' OR
									privy5codes LIKE '%,12' OR 
									privy5codes LIKE '%,12,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '13' OR
									privy5codes LIKE '13,%' OR
									privy5codes LIKE '%,13' OR 
									privy5codes LIKE '%,13,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '14' OR
									privy5codes LIKE '14,%' OR
									privy5codes LIKE '%,14' OR 
									privy5codes LIKE '%,14,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '15' OR
									privy5codes LIKE '15,%' OR
									privy5codes LIKE '%,15' OR 
									privy5codes LIKE '%,15,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '18' OR
									privy5codes LIKE '18,%' OR
									privy5codes LIKE '%,18' OR 
									privy5codes LIKE '%,18,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '19' OR
									privy5codes LIKE '19,%' OR
									privy5codes LIKE '%,19' OR 
									privy5codes LIKE '%,19,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '20' OR
									privy5codes LIKE '20,%' OR
									privy5codes LIKE '%,20' OR 
									privy5codes LIKE '%,20,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '21' OR
									privy5codes LIKE '21,%' OR
									privy5codes LIKE '%,21' OR 
									privy5codes LIKE '%,21,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '22' OR
									privy5codes LIKE '22,%' OR
									privy5codes LIKE '%,22' OR 
									privy5codes LIKE '%,22,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '48' OR
									privy5codes LIKE '48,%' OR
									privy5codes LIKE '%,48' OR 
									privy5codes LIKE '%,48,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '23' OR
									privy5codes LIKE '23,%' OR
									privy5codes LIKE '%,23' OR 
									privy5codes LIKE '%,23,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:01.001
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '26' OR
									privy5codes LIKE '26,%' OR
									privy5codes LIKE '%,26' OR 
									privy5codes LIKE '%,26,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '24' OR
									privy5codes LIKE '24,%' OR
									privy5codes LIKE '%,24' OR 
									privy5codes LIKE '%,24,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '27' OR
									privy5codes LIKE '27,%' OR
									privy5codes LIKE '%,27' OR 
									privy5codes LIKE '%,27,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '28' OR
									privy5codes LIKE '28,%' OR
									privy5codes LIKE '%,28' OR 
									privy5codes LIKE '%,28,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '30' OR
									privy5codes LIKE '30,%' OR
									privy5codes LIKE '%,30' OR 
									privy5codes LIKE '%,30,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '64' OR
									privy5codes LIKE '64,%' OR
									privy5codes LIKE '%,64' OR 
									privy5codes LIKE '%,64,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '35' OR
									privy5codes LIKE '35,%' OR
									privy5codes LIKE '%,35' OR 
									privy5codes LIKE '%,35,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '59' OR
									privy5codes LIKE '59,%' OR
									privy5codes LIKE '%,59' OR 
									privy5codes LIKE '%,59,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '2' OR
									privy5codes LIKE '2,%' OR
									privy5codes LIKE '%,2' OR 
									privy5codes LIKE '%,2,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '44' OR
									privy5codes LIKE '44,%' OR
									privy5codes LIKE '%,44' OR 
									privy5codes LIKE '%,44,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '45' OR
									privy5codes LIKE '45,%' OR
									privy5codes LIKE '%,45' OR 
									privy5codes LIKE '%,45,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '46' OR
									privy5codes LIKE '46,%' OR
									privy5codes LIKE '%,46' OR 
									privy5codes LIKE '%,46,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '47' OR
									privy5codes LIKE '47,%' OR
									privy5codes LIKE '%,47' OR 
									privy5codes LIKE '%,47,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '51' OR
									privy5codes LIKE '51,%' OR
									privy5codes LIKE '%,51' OR 
									privy5codes LIKE '%,51,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '52' OR
									privy5codes LIKE '52,%' OR
									privy5codes LIKE '%,52' OR 
									privy5codes LIKE '%,52,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=8ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '53' OR
									privy5codes LIKE '53,%' OR
									privy5codes LIKE '%,53' OR 
									privy5codes LIKE '%,53,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '55' OR
									privy5codes LIKE '55,%' OR
									privy5codes LIKE '%,55' OR 
									privy5codes LIKE '%,55,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '57' OR
									privy5codes LIKE '57,%' OR
									privy5codes LIKE '%,57' OR 
									privy5codes LIKE '%,57,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '58' OR
									privy5codes LIKE '58,%' OR
									privy5codes LIKE '%,58' OR 
									privy5codes LIKE '%,58,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=2ms, Records=25) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = eat
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=7) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = drink
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = sleep
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = play
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = shop
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=2) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:04:02.002
					SELECT * 
					FROM privy5codes 
					WHERE WhereTo=? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND ByPrivyMember IS NULL AND p5=1
					ORDER BY Category
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = relax
Parameter #2(CF_SQL_CHAR) = Shanghai
Parameter #3(CF_SQL_CHAR) = Shanghai,%
Parameter #4(CF_SQL_CHAR) = %,Shanghai
Parameter #5(CF_SQL_CHAR) = %,Shanghai,%

local.traffic (Datasource=entre360ds, Time=16ms, Records=0) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:04:02.002
	SELECT TOP 4
		magazine_id,
		COUNT(magazine_id) AS hits,
		(
			SELECT directoryurl
	        FROM magazine
	        WHERE magazine.id = magazine_views.magazine_id
		) AS directoryurl
	FROM MAGAZINE_VIEWS
	WHERE
		created>=CONVERT(datetime,'2019-12-22 00:00:00') AND
		created<=CONVERT(datetime,'2019-12-28 23:59:59') AND
		magazine_id!=17
	GROUP BY magazine_id
	ORDER BY COUNT(magazine_id) DESC
local.traffic (Datasource=entre360ds, Time=1ms, Records=4) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:04:02.002
		SELECT TOP 4 directoryurl FROM magazine ORDER BY initpopular DESC
	
local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:04:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-NYE-2011

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:04:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Emily-Cho

local.getMagDB (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:04:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Sara-Mibo-Sohn

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:04:02.002
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-Bordeaux-Event-at-Strip-Prime-Shanghai

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:04:02.002
						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.dbprivy5topplaces (Datasource=entre360ds, Time=70ms, Records=17) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 09:04:02.002
	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) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%
Parameter #5(CF_SQL_CHAR) = Shanghai
Parameter #6(CF_SQL_CHAR) = Shanghai,%
Parameter #7(CF_SQL_CHAR) = %,Shanghai
Parameter #8(CF_SQL_CHAR) = %,Shanghai,%
Parameter #9(CF_SQL_CHAR) = Shanghai
Parameter #10(CF_SQL_CHAR) = Shanghai,%
Parameter #11(CF_SQL_CHAR) = %,Shanghai
Parameter #12(CF_SQL_CHAR) = %,Shanghai,%
Parameter #13(CF_SQL_CHAR) = Shanghai

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:04:02.002
						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)
paypal_biz=paypal@privy.net
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\shanghai\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=/
HTTP_HOST=www.privy.net
HTTP_REFERER=
HTTP_URL=/shanghai/index.cfm/
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/
PATH_TRANSLATED=d:\www\privy\shanghai\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/shanghai/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
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: 15 ms