| 1 | db.towns.find( {"sef_url":"troy-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.articles.find( {"broadcastto":{"$in":["troy-mo","mo","usa"]},"publish_date":{"$lte":"MongoDate(0.36600000 1764977872)"}}, [] ).sort( {"publish_date":-1} ).limit( 51 ).skip( 0 ) | | 0 | 51 | 4 |
| 3 | db.events_cache.find( {"_id":"193b6ffe7e9854dc39550ae7df6b2384"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 4 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765519200)"},"town_sef_url":"troy-mo"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 3 |
| 5 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.97570037841797,38.98139953613281],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765778400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 2 |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.97570037841797,38.98139953613281],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765778400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 3 |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.97570037841797,38.98139953613281],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1766210400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 6 |
| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-90.97570037841797,38.98139953613281],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.01135446104158256,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)"}}}},{"$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 | 2 | 19 |
| 9 | db.events_cache.count( {"_id":"193b6ffe7e9854dc39550ae7df6b2384"} ) | | 0 | 0 | 1 |
| 10 | db.events_cache.count( {"_id":"193b6ffe7e9854dc39550ae7df6b2384"} ) | | 0 | 0 | 1 |
| 11 | db.events_cache.insert( {"_id":"193b6ffe7e9854dc39550ae7df6b2384","data":[{"Event":{"_id":{"title":"U City Farmers Market","venue_name":"Heman Park","city":"Saint Louis","state":"MO"},"id":ObjectId ("68793927384bf9134e02a706"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 6, 2025 at 10:00am","time_string":"10:00 AM","distance":41.34088289347652,"end":"MongoDate(0.00000000 1765029600)","event_id":75735296,"featured":"","geo":[-90.3213821,38.6693809],"group_key":"75735296","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Saint Louis, MO","repeat_id":"","search_text":"U City Farmers Market, Heman Park, 7210 Olive Boulevard, Saint Louis, season wintermarket hoursholiday marketdecember saturday am pmlocation outdoors heman park olive blvd louis near centennial commons recplex city swimming pool","sef_tail":"\/event\/u-city-farmers-market-2025-12-06-saint-louis-mo.html","start":"MongoDate(0.00000000 1765015200)","state":"MO","tags":["farmers-market","step-outside","aarp","holiday-event-guide","clubs-and-organizations"],"title":"U City Farmers Market","town_sef_url":"saint-louis-mo","venue_name":"Heman Park","dates":[]}},{"Event":{"_id":{"title":"U City Farmers Market","venue_name":"Heman Park Community Center","city":"Saint Louis","state":"MO"},"id":ObjectId ("68793927384bf9134e02a708"),"city":"Saint Louis","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Jan 10, 2026 at 9:30am","time_string":"9:30 AM","distance":41.81039229100182,"end":"MongoDate(0.00000000 1768048200)","event_id":75735301,"featured":"","geo":[-90.3157113,38.6636411],"group_key":"3214166","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Saint Louis, MO","repeat_id":"3214166","search_text":"U City Farmers Market, Heman Park Community Center, 975 Pennsylvania Ave, Saint Louis, season wintermarket hourswinter marketjanuary march nd saturday am pmlocation indoors hpcc heman park community center pennsylvania ave louis monbsp","sef_tail":"\/event\/u-city-farmers-market-2026-01-10-saint-louis-mo.html","start":"MongoDate(0.00000000 1768037400)","state":"MO","tags":["farmers-market","step-outside","aarp","clubs-and-organizations","2025-updated"],"title":"U City Farmers Market","town_sef_url":"saint-louis-mo","venue_name":"Heman Park Community Center","dates":[]}}],"params":"{\"title\":\"Events Near Troy MO\",\"keyword\":\"\",\"radius\":45,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"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\":38.98139953613281,\"lng\":-90.97570037841797,\"latlng\":\"38.981399536133,-90.975700378418\",\"count\":0}","modified":"MongoDate(0.46100000 1764977872)","created":"MongoDate(0.46100000 1764977872)"} , true) | | 0 | 0 | 2 |
