Yu Yuan
Categories: Shopping

132 Anren Jie

near Fuyou Lu

ShanghaiNanshi District

China

Privy 5 Overview

Share |

For a slice of "old Shanghai" you'll want to visit Yu Yuan, an open-air market, and take in the history that is represented at this age-old locale. While not far from the shops of the French Concession, Yu Yuan is a more traditional shopping experience. At first glance, it doesn't look like much until you realize how much there truly is to experience. Among the numerous opportunities to shop Chinese fare, there is a huge attraction known as Yuyuan Garden which, if you purchase a admission ticket, is a serene and beautiful place to visit. With the ponds, bridges, trees, and houses it's a nice sight if you're overwhelmed by the shopping. There are also interesting gift and souvenir shops as well as the great variety of food options here including some pretty good xiao long bao. If that doesn't suit you, there is also a large food court will likely be quite the experience with so many Chinese dishes here. With so much going on it could be easy to get lost so make sure you've got a good sense of navigation before you take on this shopping expedition.

TYPE: Shopping Districts, Fashion, Antiques

Price Range: Not Sure

Attire: Casual

Takes Reservations: No

Parking: Street

Takeout: No

Delivers: No

Accept Credit Cards: Not Sure

Good For Groups: Yes

Good For Kids: Yes

Waiter Service: No

write a comment

Comments (0)
  • WHO'S BEEN HERE (1)

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 12:12 PM
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
16966 ms 16966 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | onRequest(/shanghai/index.cfm) ] from D:/www/privy/shanghai/Application.cfc
10341 ms 10341 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
10341 ms 10341 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_singlelisting.cfm
10341 ms 10341 ms 1 D:/www/privy/shanghai/views/go/shop.cfm
9469 ms 9469 ms 1 D:/Mappings/lib-tag/cuisinetype.cfm
4902 ms 4902 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
4902 ms 4902 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
1147 ms 1147 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
791 ms 132 ms 6 D:/Mappings/lib-tag/categorygroup.cfm
232 ms 232 ms 1 CFC[ D:/www/privy/shanghai/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/users.cfc
203 ms 203 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
126 ms 0 ms 6432 D:/Mappings/lib-tag/getmaxminusone.cfm
64 ms 64 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | shop(rc = [complex value]) ] from D:/www/privy/shanghai/controllers/go.cfc
61 ms 61 ms 1 D:/www/privy/guestcfc/inc_popular_posts.cfm
37 ms 37 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/shanghai/Application.cfc
27 ms 27 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/shanghai/Application.cfc
20 ms 20 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
17 ms 17 ms 1 CFC[ D:/www/privy/shanghai/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
17 ms 17 ms 1 D:/www/privy/shanghai/layouts/go.cfm
16 ms 8 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
16 ms 16 ms 1 D:/www/privy/guestcfc/cfc_services_users_inc.cfm
15 ms 15 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
14 ms 14 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
5 ms 5 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, 16) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
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 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | imgp(picture = , fbid = , gender = F, fbaccesstoken = , width = 50) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | ip4todecimal(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | p5thumbnail(original = yu-yuan.JPG, type = 3) ] 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.mapjsheader, cityguide_mapjsheader) ] 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.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/shanghai/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/shanghai/controllers/go.cfc | endshop(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 | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/shanghai/services/cityguide.cfc
0 ms 0 ms 1 D:/Mappings/lib-tag/commaspace.cfm
0 ms 0 ms 1 D:/Mappings/lib-tag/hoursop.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_users.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_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_comments.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
16973 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 @ 12:12:10.010
		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/shop/Yu-Yuan
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.getwebpg (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:12:10.010
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,shop,Yu-Yuan

local.checksession (Datasource=entre360ds, Time=2412ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:12:13.013
	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=2476ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:12:15.015
	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=1ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:12:15.015
						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=20ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:15.015
			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=17ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:15.015
			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) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai,%
Parameter #3(CF_SQL_CHAR) = %,Shanghai
Parameter #4(CF_SQL_CHAR) = %,Shanghai,%
Parameter #5(CF_SQL_CHAR) = shop

local.retval.query (Datasource=entre360ds, Time=203ms, Records=3) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:16.016
			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 'shop' OR
							categorywhereto LIKE 'shop,%' OR
							categorywhereto LIKE '%,shop' OR 
							categorywhereto LIKE '%,shop,%'
						)		 
					GROUP BY ltrim(rtrim(LOCATION.Neighborhood))
				)		
				
			ORDER BY PRIVY5NEIGHBORHOODS.neighborhood  
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai
Parameter #2(CF_SQL_CHAR) = Shanghai

local.retval.getCategory (Datasource=entre360ds, Time=16ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:16.016
					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) = Yu-Yuan
Parameter #2(CF_SQL_CHAR) = Yu-Yuan
Parameter #3(CF_SQL_CHAR) = Shanghai
Parameter #4(CF_SQL_CHAR) = Shanghai,%
Parameter #5(CF_SQL_CHAR) = %,Shanghai
Parameter #6(CF_SQL_CHAR) = %,Shanghai,%

local.retval.getlocation (Datasource=entre360ds, Time=188ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:16.016
					SELECT 
						*, 
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						(
							SELECT AVG(MyReviews.Star) AS avgstar
	            			FROM myreviews, MEMBER  
	            			WHERE 
								MYREVIEWS.MemberId = member.MemberID AND 
								MyReviews.LocationId= location.locationid AND
								member.can_login=1
						) AS averagestar,
						(
							SELECT COUNT(MyReviews.myreviewid) 
	        				FROM myreviews, MEMBER  
	        				WHERE 
								MYREVIEWS.MemberId = member.MemberID AND 
								MyReviews.LocationId= location.locationid AND
								member.can_login=1
						) AS manyreviews,
						(
							SELECT TOP 1 signaturedishes 
							FROM myreviews 
							WHERE 
								myreviews.LocationId = location.locationid AND 
								myreviews.signaturedishes IS NOT NULL AND 
								myreviews.signaturedishes != ''
						) AS signaturedishes,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							locationid = ? OR 
							directoryurl = ?
						)
						AND (Location.ClosestPrivyCity=?)
						 
						AND (Location.P5=1)
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Yu-Yuan
Parameter #2(CF_SQL_CHAR) = Yu-Yuan
Parameter #3(CF_SQL_CHAR) = Shanghai

local.findprivy5category (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:16.016
						SELECT Code, category 
						FROM privy5codes 
						WHERE Code =
							? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 46

local.retval.p5memberlovethis (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:16.016
						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 
						  
						AND 
						(
							
									Code = ? 
						)
							
						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,%
Parameter #5(cf_sql_integer) = 46

local.retval.getrelatedlocation_singlecategory (Datasource=entre360ds, Time=543ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:16.016
						SELECT 
							*,
							(
								SELECT privy5codes.whereto 
								FROM privy5codes
								WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
							) AS categorywhereto2, 
							(
								SELECT AVG(MyReviews.Star) AS avgstar
		            			FROM myreviews, MEMBER  
		            			WHERE 
									MYREVIEWS.MemberId = member.MemberID AND 
									MyReviews.LocationId= location.locationid AND
									member.can_login=1
							) AS averagestar,
							(
								SELECT COUNT(MyReviews.myreviewid) 
		        				FROM myreviews, MEMBER  
		        				WHERE 
									MYREVIEWS.MemberId = member.MemberID AND 
									MyReviews.LocationId= location.locationid AND
									member.can_login=1
							) AS manyreviews,
							(
								SELECT TOP 1 signaturedishes 
								FROM myreviews 
								WHERE 
									myreviews.LocationId = location.locationid AND 
									myreviews.signaturedishes IS NOT NULL AND 
									myreviews.signaturedishes != ''
							) AS signaturedishes,
							
							'' AS buttonselection	 
							
						FROM location 
						WHERE 
							(Location.ClosestPrivyCity=?) AND
							(Location.P5=1) AND
							( 
									Location.privy5codes LIKE '46' OR
									Location.privy5codes LIKE '46,%' OR
									Location.privy5codes LIKE '%,46' OR 
									Location.privy5codes LIKE '%,46,%' 
							)
					
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.retval.getrelatedlocation (Datasource=entre360ds, Time=329ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:17.017
						SELECT 
							*,
							(
								SELECT privy5codes.whereto 
								FROM privy5codes
								WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
							) AS categorywhereto2, 
							(
								SELECT AVG(MyReviews.Star) AS avgstar
		            			FROM myreviews, MEMBER  
		            			WHERE 
									MYREVIEWS.MemberId = member.MemberID AND 
									MyReviews.LocationId= location.locationid AND
									member.can_login=1
							) AS averagestar,
							(
								SELECT COUNT(MyReviews.myreviewid) 
		        				FROM myreviews, MEMBER  
		        				WHERE 
									MYREVIEWS.MemberId = member.MemberID AND 
									MyReviews.LocationId= location.locationid AND
									member.can_login=1
							) AS manyreviews,
							(
								SELECT TOP 1 signaturedishes 
								FROM myreviews 
								WHERE 
									myreviews.LocationId = location.locationid AND 
									myreviews.signaturedishes IS NOT NULL AND 
									myreviews.signaturedishes != ''
							) AS signaturedishes,
							
							'' AS buttonselection	 
							
						FROM location 
						WHERE 
							(Location.ClosestPrivyCity=?) AND
							(Location.P5=1) 
							   
							AND
							( 
								
									Location.privy5codes LIKE '46' OR
									Location.privy5codes LIKE '46,%' OR
									Location.privy5codes LIKE '%,46' OR 
									Location.privy5codes LIKE '%,46,%' 
							)
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shanghai

local.retval.getlocationphotos (Datasource=entre360ds, Time=62ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:17.017
		            	SELECT FileUploadLogs.* 
						FROM FileUploadLogs INNER JOIN MEMBER ON FileUploadLogs.MemberId = MEMBER.MemberID 
						WHERE FileUploadLogs.LocationId = ?
						ORDER BY FileUploadLogs.Created DESC
		        	
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = F320A030-9902-F058-CA38BE821A49742E

local.retval.getp5bookmark1 (Datasource=entre360ds, Time=3ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:17.017
							SELECT 
								MEMBERGUESTS.memberid, 
								MEMBERGUESTS_PLACES.placeid, 
								MEMBERGUESTS.firstname, 
								MEMBERGUESTS.picture,
								MEMBERGUESTS.fbid,
								MEMBERGUESTS.gender
							FROM MEMBERGUESTS_PLACES INNER JOIN MEMBERGUESTS ON MEMBERGUESTS_PLACES.memberid = MEMBERGUESTS.memberid 
							WHERE MEMBERGUESTS_PLACES.placeid = ? AND wantorbeen=2
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = F320A030-9902-F058-CA38BE821A49742E

local.retval.getp5bookmark2 (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 12:12:17.017
							SELECT 
								MEMBERGUESTS.memberid, 
								MEMBERGUESTS_PLACES.placeid, 
								MEMBERGUESTS.firstname, 
								MEMBERGUESTS.picture,
								MEMBERGUESTS.fbid,
								MEMBERGUESTS.gender
							FROM MEMBERGUESTS_PLACES INNER JOIN MEMBERGUESTS ON MEMBERGUESTS_PLACES.memberid = MEMBERGUESTS.memberid 
							WHERE MEMBERGUESTS_PLACES.placeid = ? AND wantorbeen=1
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = F320A030-9902-F058-CA38BE821A49742E

local.getid (Datasource=entre360ds, Time=17ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 12:12:17.017
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Yu-Yuan

local.getid (Datasource=entre360ds, Time=198ms, Records=1) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 12:12:17.017
						SELECT locationid 
						FROM location 
						WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Yu-Yuan

local.retval.comments (Datasource=entre360ds, Time=16ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 12:12:17.017
		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.locationid = ? 
			AND MEMBERGUESTS_COMMENTS.commentshow = 1 
		ORDER BY MEMBERGUESTS_COMMENTS.commentdate DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = F320A030-9902-F058-CA38BE821A49742E

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:12:17.017
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 12:12:17.017
	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 @ 12:12:23.023
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
findcategory (Datasource=entre360ds, Time=1ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=17ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=1ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=2ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=24ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=15ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=20ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=17ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=18ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=38ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=14ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=20ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=19ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=17ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=8ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=38ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=6ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=23ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=16ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=57ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=17ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=17ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=19ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=20ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=17ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=73ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=109ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) =

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=1) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Shopping Districts

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Shopping Districts

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=16ms, Records=1) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Fashion

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Fashion

findcategory (Datasource=entre360ds, Time=0ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=0ms, Records=1) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Antiques

findfeature1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Antiques

findcategory (Datasource=entre360ds, Time=13ms, Records=30) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT Category FROM locationcategory WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findfeature (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
    		SELECT feature FROM locationfeature WHERE GroupCategory=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping

findcategory1 (Datasource=entre360ds, Time=1ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT Category 
            FROM locationcategory 
            WHERE GroupCategory=? AND Category=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Arts

findfeature1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\Mappings\lib-tag\categorygroup.cfm @ 12:12:27.027
            SELECT feature 
            FROM locationfeature 
            WHERE GroupCategory=? AND feature=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Shopping
Parameter #2(CF_SQL_CHAR) = Arts

local.traffic (Datasource=entre360ds, Time=29ms, Records=0) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 12:12:27.027
	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=0ms, Records=4) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 12:12:27.027
		SELECT TOP 4 directoryurl FROM magazine ORDER BY initpopular DESC
	
local.getMagDB (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 12:12:27.027
						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 @ 12:12:27.027
						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 @ 12:12:27.027
						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 @ 12:12:27.027
						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=13ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:12:27.027
						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=/; 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/shanghai
HTTP_URL=/shanghai/index.cfm/go/shop/Yu-Yuan
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/shop/Yu-Yuan
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
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: 182 ms