| 1 | db.towns.find( {"sef_url":"saint-clair-mo"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 3 |
| 2 | db.articles.find( {"broadcastto":{"$in":["saint-clair-mo","mo","usa"]},"publish_date":{"$lte":"MongoDate(0.23600000 1765148050)"}}, [] ).sort( {"publish_date":-1} ).limit( 51 ).skip( 0 ) | | 0 | 51 | 5 |
| 3 | db.events_cache.find( {"_id":"3baf45e3965df537e2fda1f1e098cd85"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 4 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1765087200)","$lt":"MongoDate(0.00000000 1765692000)"},"town_sef_url":"saint-clair-mo"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 2 |
| 5 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.98410034179688,38.350101470947266],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765087200)","$lt":"MongoDate(0.00000000 1765951200)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 2 |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.98410034179688,38.350101470947266],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765087200)","$lt":"MongoDate(0.00000000 1765951200)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 4 |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-90.98410034179688,38.350101470947266],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765087200)","$lt":"MongoDate(0.00000000 1766383200)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 7 |
| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-90.98410034179688,38.350101470947266],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.01135446104158256,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765087200)"}}}},{"$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 | 20 |
| 9 | db.events_cache.count( {"_id":"3baf45e3965df537e2fda1f1e098cd85"} ) | | 0 | 0 | 1 |
| 10 | db.events_cache.count( {"_id":"3baf45e3965df537e2fda1f1e098cd85"} ) | | 0 | 0 | 1 |
| 11 | db.events_cache.insert( {"_id":"3baf45e3965df537e2fda1f1e098cd85","data":[{"Event":{"_id":{"title":"Arnold Farmers Market","venue_name":"Arnold Farmers Market","city":"Arnold","state":"MO"},"id":ObjectId ("68793924384bf9134e029b0e"),"city":"Arnold","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 13, 2025 at 10:00am","time_string":"10:00 AM","distance":33.400876016619634,"end":"MongoDate(0.00000000 1765634400)","event_id":75699589,"featured":"","geo":[-90.37519836425781,38.42340087890625],"group_key":"75699589","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Arnold, MO","repeat_id":"","search_text":"Arnold Farmers Market, Arnold Farmers Market, 2400 Bradley Beach Road, North Jeffco Boulevard, Arnold, season wintermarket hourschristmas marketdecember saturday am pmlocation bradley beach road","sef_tail":"\/event\/arnold-farmers-market-2025-12-13-arnold-mo.html","start":"MongoDate(0.00000000 1765620000)","state":"MO","tags":["farmers-market","step-outside","aarp","holiday-event-guide","clubs-and-organizations"],"title":"Arnold Farmers Market","town_sef_url":"arnold-mo","venue_name":"Arnold Farmers Market","dates":{"1":{"start":"MongoDate(0.00000000 1768035600)","date_string":"Saturday, Jan 10, 2026 at 9:00am","sef_tail":"\/event\/arnold-farmers-market-2026-01-10-arnold-mo.html"}}}},{"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":42.18128062542058,"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 Saint Clair 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.350101470947266,\"lng\":-90.98410034179688,\"latlng\":\"38.350101470947,-90.984100341797\",\"count\":0}","modified":"MongoDate(0.32600000 1765148050)","created":"MongoDate(0.32600000 1765148050)"} , true) | | 0 | 0 | 2 |
| 12 | db.places.find( {"geo":{"$near":[-90.98410034179688,38.350101470947266],"$maxDistance":1.4492753623188406},"tags":"dog-park"}, [] ).sort( [] ).limit( 10 ).skip( 0 ) | | 0 | 0 | 2 |
| 13 | db.places.count( {"geo":{"$near":[-90.98410034179688,38.350101470947266],"$maxDistance":1.4492753623188406},"tags":"dog-park"} ) | | 0 | 0 | 1 |
