| 1 | db.towns.find( {"sef_url":"lopez-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 2 | db.events_cache.find( {"_id":"defd3ab90969a9d42cc784a0cf77c750"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 21 |
| 3 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1758171600)","$lt":"MongoDate(0.00000000 1758776400)"},"town_sef_url":"lopez-pa","tags":"running"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 3 |
| 4 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-76.33090209960938,41.458099365234375],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1758171600)","$lt":"MongoDate(0.00000000 1759035600)"},"tags":"running"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 4 |
| 5 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-76.33090209960938,41.458099365234375],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1758171600)","$lt":"MongoDate(0.00000000 1759035600)"},"tags":"running"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 4 |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-76.33090209960938,41.458099365234375],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1758171600)","$lt":"MongoDate(0.00000000 1759467600)"},"tags":"running"}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 25 |
| 7 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-76.33090209960938,41.458099365234375],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.01135446104158256,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1758171600)"},"tags":"running"}}},{"$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"},"time_string":{"$first":"$time_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 ) | | 0 | 1 | 58 |
| 8 | db.events_cache.count( {"_id":"defd3ab90969a9d42cc784a0cf77c750"} ) | | 0 | 0 | 3 |
| 9 | db.events_cache.count( {"_id":"defd3ab90969a9d42cc784a0cf77c750"} ) | | 0 | 0 | 9 |
| 10 | db.events_cache.insert( {"_id":"defd3ab90969a9d42cc784a0cf77c750","data":[{"Event":{"_id":{"title":"Susquehanna Riverwalk Parkrun","venue_name":"Susquehanna Riverwalk","city":"Williamsport","state":"PA"},"id":ObjectId ("68793957384bf9134e034418"),"city":"Williamsport","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Sep 20, 2025 at 9:00am","time_string":"9:00 AM","distance":38.28587365009203,"end":"","event_id":75949143,"featured":"","geo":[-77.0058179,41.2352994],"group_key":"3217864","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Williamsport, PA","repeat_id":"3217864","search_text":"Susquehanna Riverwalk Parkrun, Susquehanna Riverwalk, 100 Hepburn Street, Williamsport, free fun friendly weekly community event walk jog run volunteer spectate ndash ityoutake part enjoyment please come along join whatever your pacecourse infoback course paved susquehanna riverwalk alongside west branch river start finish just east dam close main parking lotsclick here course mapcostnothing itfree please register before first alongclick register","sef_tail":"\/event\/susquehanna-riverwalk-parkrun-2025-09-20-williamsport-pa.html","start":"MongoDate(0.00000000 1758358800)","state":"PA","tags":["step-outside","aarp","running","5ks","walking","sports-and-recreation"],"title":"Susquehanna Riverwalk Parkrun","town_sef_url":"williamsport-pa","venue_name":"Susquehanna Riverwalk","dates":{"1":{"start":"MongoDate(0.00000000 1758963600)","date_string":"Saturday, Sep 27, 2025 at 9:00am","sef_tail":"\/event\/susquehanna-riverwalk-parkrun-2025-09-27-williamsport-pa.html"},"2":{"start":"MongoDate(0.00000000 1759568400)","date_string":"Saturday, Oct 4, 2025 at 9:00am","sef_tail":"\/event\/susquehanna-riverwalk-parkrun-2025-10-04-williamsport-pa.html"},"3":{"start":"MongoDate(0.00000000 1760173200)","date_string":"Saturday, Oct 11, 2025 at 9:00am","sef_tail":"\/event\/susquehanna-riverwalk-parkrun-2025-10-11-williamsport-pa.html"},"4":{"start":"MongoDate(0.00000000 1760778000)","date_string":"Saturday, Oct 18, 2025 at 9:00am","sef_tail":"\/event\/susquehanna-riverwalk-parkrun-2025-10-18-williamsport-pa.html"},"5":{"start":"MongoDate(0.00000000 1761382800)","date_string":"Saturday, Oct 25, 2025 at 9:00am","sef_tail":"\/event\/susquehanna-riverwalk-parkrun-2025-10-25-williamsport-pa.html"}}}}],"params":"{\"title\":\"Upcoming 5Ks, 10Ks, Marathons and more Near Lopez PA\",\"tags\":\"running\",\"keyword\":\"\",\"radius\":45,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show\":15,\"show_limit\":3,\"sort\":\"\",\"days\":365,\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"\",\"min\":20,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"more\":\"yes\",\"autoshowmore\":\"no\",\"link\":\"\",\"showdesc\":\"yes\",\"rankby\":\"distance\",\"type\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"lat\":41.458099365234375,\"lng\":-76.33090209960938,\"latlng\":\"41.458099365234,-76.330902099609\",\"count\":0}","modified":"MongoDate(0.18300000 1758229393)","created":"MongoDate(0.18300000 1758229393)"} , true) | | 0 | 0 | 2 |
| 11 | db.articles.find( {"broadcastto":{"$in":["lopez-pa","pa","usa"]},"publish_date":{"$lte":"MongoDate(0.19100000 1758229393)"},"tags":"hiking"}, [] ).sort( {"publish_date":-1} ).limit( 16 ).skip( 0 ) | | 0 | 16 | 8 |
