How Does Your Brain Score? Take the Staying Sharp Brain Health Assessment

Find things to do around Pickering

helpful resources

We hear you

Real Possibilities is a trademark of AARP.

FIND IT FAST

Advertisement

JOIN OR RENEW
AARP TODAY

  • JOIN FOR JUST $16 A YEAR
  • Immediate access to your member benefits
  • Discounts on travel and everyday savings
  • Subscription to the award-winning AARP The Magazine
  • An ally on the issues that matter most to you in Pickering
  • Free membership for your spouse or partner
  • JOIN/RENEW NOW

LOCAL SERVICES

Advertisement

Contact
AARP Missouri

Email: MOAARP@aarp.org
More Info: Contact Us

(mongo) 29 queries took 1114 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1db.default_tokens.find( [], [] ).sort( [] ).limit( 1 ).skip( 0 )012
2db.towns.find( {"sef_url":"pickering-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 )012
3db.pages.find( {"slug":"home","type":"town"}, [] ).sort( [] ).limit( 1 ).skip( 0 )012
4db.modules.find( {"name":"Head"}, [] ).sort( [] ).limit( 1 ).skip( 0 )012
5db.modules.find( {"name":"Bottom"}, [] ).sort( [] ).limit( 1 ).skip( 0 )012
6db.blogs_posts.find( {"post_tag":{"$in":["caregiving","healthy-living","savings-and-planning","work-and-jobs","life-reimagined","all","mo"]},"blog_type":"10up","published":"1","post_terms":{"$ne":"espanol"},"$or":[{"priority":{"$gte":"1"}},{"post_date":{"$gte":1500699600}}]}, [] ).sort( {"priority":-1,"post_date":-1} ).limit( 8 ).skip( 0 )0013
7db.blogs_posts.find( {"post_tag":{"$in":["caregiving","healthy-living","savings-and-planning","work-and-jobs","life-reimagined","all","mo"]},"post_terms":{"$ne":"espanol"},"blog_type":{"$ne":"10up"},"published":"1","post_id":{"$nin":[]},"post_url":{"$nin":[]}}, [] ).sort( {"priority":-1,"post_date":-1} ).limit( 8 ).skip( 0 )088
8db.events_cache.find( {"key":"7926f963add46f0773f830b61726da39"}, [] ).sort( [] ).limit( 1 ).skip( 0 )003
9db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1506488400)"},"town_sef_url":"pickering-mo","$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )00151
10db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953573,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1506747600)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )008
11db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471942,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1506747600)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )008
12db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0063080339119903,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1507179600)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )0021
13db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.011354461041583,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1537419600)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )00123
14db.events.find( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.011354461041583,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)"},"$and":[{"tags":"ticketmaster"},{"tags":{"$ne":"alternative-and-indie"}},{"tags":{"$ne":"clubs-and-dance"}},{"tags":{"$ne":"hard-rock"}},{"tags":{"$ne":"metal"}},{"tags":{"$ne":"more-music"}},{"tags":{"$ne":"rap-and-hiphop"}}]}}},{"$sort":{"start":1,"id":1}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"},"id":{"$first":"$_id"},"city":{"$first":"$city"},"cvent_id":{"$first":"$cvent_id"},"cvent_status":{"$first":"$cvent_status"},"date_string":{"$first":"$date_string"},"distance":{"$first":"$distance"},"end":{"$first":"$end"},"event_id":{"$first":"$event_id"},"featured":{"$first":"$featured"},"geo":{"$first":"$geo"},"group_key":{"$first":"$group_key"},"image_url":{"$first":"$image_url"},"location_string":{"$first":"$location_string"},"repeat_id":{"$first":"$repeat_id"},"search_text":{"$first":"$search_text"},"sef_tail":{"$first":"$sef_tail"},"start":{"$first":"$start"},"state":{"$first":"$state"},"tags":{"$first":"$tags"},"title":{"$first":"$title"},"town_sef_url":{"$first":"$town_sef_url"},"venue_name":{"$first":"$venue_name"},"dates":{"$push":{"start":"$start","date_string":"$date_string","sef_tail":"$sef_tail"}}}},{"$sort":{"start":1,"id":1}},{"$sort":{"start":1,"id":1}},{"$skip":0},{"$limit":15}]}, [] ).sort( {"start":1,"id":1} ).limit( 15 ).skip( 0 )00187
15db.events_cache.insert( {"key":"7926f963add46f0773f830b61726da39","data":[],"params":"{\"keyword\":\"\",\"tags\":\"\",\"tags_logical\":{\"$and\":[{\"tags\":\"ticketmaster\"},{\"tags\":{\"$ne\":\"alternative-and-indie\"}},{\"tags\":{\"$ne\":\"clubs-and-dance\"}},{\"tags\":{\"$ne\":\"hard-rock\"}},{\"tags\":{\"$ne\":\"metal\"}},{\"tags\":{\"$ne\":\"more-music\"}},{\"tags\":{\"$ne\":\"rap-and-hiphop\"}}]},\"terms\":\"\",\"page\":1,\"show\":15,\"show_limit\":3,\"limit\":15,\"sort\":\"\",\"days\":365,\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":\"3\",\"radius\":45,\"title\":\"\",\"more\":\"yes\",\"showfeature\":\"yes\",\"link\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"care-min\":8,\"tek-min\":8,\"ds-min\":8,\"lat\":40.451999664307,\"lng\":-94.845596313477,\"latlng\":\"40.451999664307,-94.845596313477\",\"count\":0}","modified":"MongoDate(0.38200000 1505969899)","created":"MongoDate(0.38200000 1505969899)","_id":ObjectId ("59c346eb1bc48f934f8bab19")} , true)0015
16db.events_cache.find( {"key":"6d2bcd91d7d316b20c6dddb6d38d0769"}, [] ).sort( [] ).limit( 1 ).skip( 0 )006
17db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1506488400)"},"town_sef_url":"pickering-mo","tags":"aarp-ae"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )0020
18db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953573,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1506747600)"},"tags":"aarp-ae"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )007
19db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471942,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1506747600)"},"tags":"aarp-ae"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )0020
20db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0063080339119903,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1507179600)"},"tags":"aarp-ae"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )0013
21db.events.count( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.011354461041583,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)","$lt":"MongoDate(0.00000000 1537419600)"},"tags":"aarp-ae"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} )01187
22db.events.find( {"aggregate":[{"$geoNear":{"near":[-94.845596313477,40.451999664307],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.011354461041583,"limit":5000,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1505883600)"},"tags":"aarp-ae"}}},{"$sort":{"start":1,"id":1}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"},"id":{"$first":"$_id"},"city":{"$first":"$city"},"cvent_id":{"$first":"$cvent_id"},"cvent_status":{"$first":"$cvent_status"},"date_string":{"$first":"$date_string"},"distance":{"$first":"$distance"},"end":{"$first":"$end"},"event_id":{"$first":"$event_id"},"featured":{"$first":"$featured"},"geo":{"$first":"$geo"},"group_key":{"$first":"$group_key"},"image_url":{"$first":"$image_url"},"location_string":{"$first":"$location_string"},"repeat_id":{"$first":"$repeat_id"},"search_text":{"$first":"$search_text"},"sef_tail":{"$first":"$sef_tail"},"start":{"$first":"$start"},"state":{"$first":"$state"},"tags":{"$first":"$tags"},"title":{"$first":"$title"},"town_sef_url":{"$first":"$town_sef_url"},"venue_name":{"$first":"$venue_name"},"dates":{"$push":{"start":"$start","date_string":"$date_string","sef_tail":"$sef_tail"}}}},{"$sort":{"start":1,"id":1}},{"$sort":{"start":1,"id":1}},{"$skip":0},{"$limit":15}]}, [] ).sort( {"start":1,"id":1} ).limit( 15 ).skip( 0 )01280
23db.events_cache.count( {"_id":ObjectId ("59c346eb1bc48f934f8bab19")} )014
24db.events_cache.count( {"_id":ObjectId ("59c346eb1bc48f934f8bab19")} )015
25db.events_cache.update( {"_id":ObjectId ("59c346eb1bc48f934f8bab19")}, {"$set":{"key":"6d2bcd91d7d316b20c6dddb6d38d0769","data":[{"Event":{"_id":{"title":"Winefest","venue_name":"North Griffith park","city":"Mound City","state":"MO"},"id":ObjectId ("59b79d7e25afd816715e6919"),"city":"Mound City","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 30, 2017 at 11:30am","distance":29.271697417896,"end":"MongoDate(0.00000000 1506816000)","event_id":58900280,"featured":"","geo":[-95.2321429,40.1484028],"group_key":"58900280","image_url":"https:\/\/local-aarp-americantownscom.netdna-ssl.com\/img\/template\/thumbs\/generic-icon.jpg","location_string":"Mound City, MO","repeat_id":"","search_text":"Winefest, North Griffith park, 474-498 Nebraska Street, Mound City, northwest winefest major fundraiser missouri enterprise facilitationseptember griffin park mound city will overflowing with vendors wine enthusiasts many more most wineries involved this fest have been deemed winners missourirsquogovernor award winning winesnbsp each winery unique taste grape varieties specialty named wines some made cityrsquograpesfestival welcomes thousands visitors guests encouraged visit booths enjoy tastings shop various local admission includes tasting glass souvenir there also tables food guests able bottles musical entertainment","sef_tail":"\/event\/winefest-2017-09-30-mound-city-mo.html","start":"MongoDate(0.00000000 1506789000)","state":"MO","tags":["wine-festival","festival","aarp","arts-and-entertainment","aarp-ae","aarp-festivals","aarp-food-festivals"],"title":"Winefest","town_sef_url":"mound-city-mo","venue_name":"North Griffith park","dates":[]}}],"params":"{\"keyword\":\"\",\"tags\":\"aarp-ae\",\"tags_logical\":{\"$and\":[{\"tags\":\"ticketmaster\"},{\"tags\":{\"$ne\":\"alternative-and-indie\"}},{\"tags\":{\"$ne\":\"clubs-and-dance\"}},{\"tags\":{\"$ne\":\"hard-rock\"}},{\"tags\":{\"$ne\":\"metal\"}},{\"tags\":{\"$ne\":\"more-music\"}},{\"tags\":{\"$ne\":\"rap-and-hiphop\"}}]},\"terms\":\"\",\"page\":1,\"show\":15,\"show_limit\":3,\"limit\":15,\"sort\":\"\",\"days\":365,\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":\"3\",\"radius\":45,\"title\":\"\",\"more\":\"yes\",\"showfeature\":\"yes\",\"link\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"care-min\":8,\"tek-min\":8,\"ds-min\":8,\"lat\":40.451999664307,\"lng\":-94.845596313477,\"latlng\":\"40.451999664307,-94.845596313477\",\"count\":1}","modified":"MongoDate(0.05900000 1505969900)"}}, {"multiple":false} )007
26db.modules.find( {"name":"Cvent New Widget Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )015
27db.events_cache.find( {"key":"61b5207e30c08b8ef1e00b8ea6d883eb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )016
28db.modules.find( {"name":"HP - Blog - Learn More"}, [] ).sort( [] ).limit( 1 ).skip( 0 )014
29db.modules.find( {"name":"Navbar AARPe"}, [] ).sort( [] ).limit( 1 ).skip( 0 )013