Debugging Information
Execution Time
SQL Queries local.getwebpg (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:33:05.005 SELECT * FROM webpg_event WHERE pageid = 1 local.checksession (Datasource=entre360ds, Time=11132ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:33:16.016 SELECT memberguests_login.sessionid FROM memberguests_login WHERE sessionid = ? Query Parameter Value(s) - local.getlogininfo (Datasource=entre360ds, Time=11920ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 11:33:28.028 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) - local.getdb (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 11:33:28.028 SELECT * FROM US_IP WHERE (ip_start_decimal <= ?) AND (? <= ip_end_decimal) Query Parameter Value(s) - local.retval.query (Datasource=entre360ds, Time=17ms, Records=2) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:33:28.028 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) - local.retval.query (Datasource=entre360ds, Time=1ms, Records=11) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:33:28.028 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) - local.retval.query (Datasource=entre360ds, Time=2ms, Records=37) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 11:33:28.028 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) - local.getthelist (Datasource=entre360ds, Time=128ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:29.029 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) - local.getthelist (Datasource=entre360ds, Time=83ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:29.029 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) - local.getthelist (Datasource=entre360ds, Time=154ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:29.029 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) - local.getthelist (Datasource=entre360ds, Time=111ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:29.029 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) - local.getthelist (Datasource=entre360ds, Time=54ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:29.029 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) - local.getthelist (Datasource=entre360ds, Time=742ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:30.030 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) - local.getthelist (Datasource=entre360ds, Time=125ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:30.030 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) - local.getthelist (Datasource=entre360ds, Time=829ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:31.031 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) - local.getthelist (Datasource=entre360ds, Time=890ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:32.032 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) - local.getthelist (Datasource=entre360ds, Time=645ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:33.033 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) - local.getthelist (Datasource=entre360ds, Time=186ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:33.033 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) - local.getthelist (Datasource=entre360ds, Time=422ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:33.033 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) - local.getthelist (Datasource=entre360ds, Time=286ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:34.034 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) - local.getthelist (Datasource=entre360ds, Time=63ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:34.034 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) - local.getthelist (Datasource=entre360ds, Time=36ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:34.034 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) - local.getthelist (Datasource=entre360ds, Time=39ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:34.034 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) - local.getthelist (Datasource=entre360ds, Time=241ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:34.034 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) - local.getthelist (Datasource=entre360ds, Time=714ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:35.035 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) - local.getthelist (Datasource=entre360ds, Time=100ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:35.035 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) - local.getthelist (Datasource=entre360ds, Time=81ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:35.035 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) - local.getthelist (Datasource=entre360ds, Time=485ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:35.035 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) - local.getthelist (Datasource=entre360ds, Time=177ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:36.036 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) - local.getthelist (Datasource=entre360ds, Time=583ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:36.036 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) - local.getthelist (Datasource=entre360ds, Time=1063ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:37.037 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) - local.getthelist (Datasource=entre360ds, Time=85ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:37.037 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) - local.getthelist (Datasource=entre360ds, Time=165ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:37.037 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) - local.getthelist (Datasource=entre360ds, Time=105ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:38.038 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) - local.getthelist (Datasource=entre360ds, Time=165ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:38.038 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) - local.getthelist (Datasource=entre360ds, Time=62ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:38.038 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) - local.getthelist (Datasource=entre360ds, Time=299ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:38.038 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) - local.getthelist (Datasource=entre360ds, Time=128ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:38.038 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) - local.getthelist (Datasource=entre360ds, Time=900ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:39.039 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) - local.getthelist (Datasource=entre360ds, Time=1044ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:40.040 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) - local.getthelist (Datasource=entre360ds, Time=775ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:41.041 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) - local.getthelist (Datasource=entre360ds, Time=402ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:41.041 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) - local.getthelist (Datasource=entre360ds, Time=137ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:42.042 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) - local.getthelist (Datasource=entre360ds, Time=57ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:42.042 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) - local.getthelist (Datasource=entre360ds, Time=1060ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:43.043 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) - local.getthelist (Datasource=entre360ds, Time=519ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:43.043 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) - local.getthelist (Datasource=entre360ds, Time=748ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:44.044 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) - local.getthelist (Datasource=entre360ds, Time=512ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:44.044 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) - local.getthelist (Datasource=entre360ds, Time=589ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:45.045 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) - local.getthelist (Datasource=entre360ds, Time=73ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:45.045 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) - local.getthelist (Datasource=entre360ds, Time=130ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:45.045 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) - local.getthelist (Datasource=entre360ds, Time=395ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:46.046 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) - local.getthelist (Datasource=entre360ds, Time=843ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview_rss.cfm @ 11:33:46.046 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) - Scope Variables Application Variables: applicationname=16674C21BBD774F3F0CD46198107AC84 devmode=false dsn_name=entre360ds dsn_name10=entre360_2011ds event=Struct (26) ipallow=24.199.44.252 magazine_imageupload=/upload/net/privy/www/p5photos/ org.corfield.framework=Struct (3) [email protected] paypal_url=https://www.paypal.com/cgi-bin/webscr recaptcha_private=6LfrQtQSAAAAAGuECx5CZ5jRb4TPBzgrBVTK_IPH recaptcha_public=6LfrQtQSAAAAALsfdvrJmY-JULezQbwYw4ea1nE2 site_addr=www.privy.net upload=/upload/net/privy/www/ upload_magazine=/upload/net/privy/www/p5photos/ upload_root=/upload/net/privy/ CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=d:\www\privy\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/?rss=1?rss=1 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=rss=1 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 URL Parameters: rss=1Debug Rendering Time: 37 ms |