| 1 | db.towns.find( {"sef_url":"south-hill-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.articles.find( {"broadcastto":{"$in":["south-hill-va","va","usa"]},"publish_date":{"$lte":"MongoDate(0.34100000 1765183483)"}}, [] ).sort( {"publish_date":-1} ).limit( 51 ).skip( 0 ) | | 0 | 51 | 4 |
| 3 | db.events_cache.find( {"_id":"6469afafa15cd06729ff2b3b95a90544"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 4 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1765778400)"},"town_sef_url":"south-hill-va"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 3 |
| 5 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-78.04638671875,36.752220153808594],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 2 |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-78.04638671875,36.752220153808594],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 2 |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-78.04638671875,36.752220153808594],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766469600)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 0 | 5 |
| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-78.04638671875,36.752220153808594],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.01135446104158256,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1765173600)"}}}},{"$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 | 30 |
| 9 | db.events_cache.count( {"_id":"6469afafa15cd06729ff2b3b95a90544"} ) | | 0 | 0 | 1 |
| 10 | db.events_cache.count( {"_id":"6469afafa15cd06729ff2b3b95a90544"} ) | | 0 | 0 | 1 |
| 11 | db.events_cache.insert( {"_id":"6469afafa15cd06729ff2b3b95a90544","data":[{"Event":{"_id":{"title":"Vance County Regional Farmers Market","venue_name":"","city":"Henderson","state":"NC"},"id":ObjectId ("687938f1384bf9134e01c914"),"city":"Henderson","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 13, 2025 at 8:00am","time_string":"8:00 AM","distance":35.67034453294905,"end":"MongoDate(0.00000000 1765630800)","event_id":75062895,"featured":"","geo":[-78.40640258789062,36.32529830932617],"group_key":"3205012","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Henderson, NC","repeat_id":"3205012","search_text":"Vance County Regional Farmers Market, , 210 Southpark Drive, Henderson, seasonnbspyear round market hours december saturdaysnbspam pm june august wednesdays am locationnbspsouthpark drive","sef_tail":"\/event\/vance-county-regional-farmers-market-2025-12-13-henderson-nc.html","start":"MongoDate(0.00000000 1765612800)","state":"NC","tags":["farmers-market","step-outside","aarp","clubs-and-organizations","2025-updated"],"title":"Vance County Regional Farmers Market","town_sef_url":"henderson-nc","venue_name":"","dates":[]}},{"Event":{"_id":{"title":"Drakes Branch Farmers Market","venue_name":"Drakes Branch Farmers Market","city":"Drakes Branch","state":"VA"},"id":ObjectId ("68793933384bf9134e02d6ee"),"city":"Drakes Branch","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 13, 2025 at 10:00am","time_string":"10:00 AM","distance":34.93411512419218,"end":"MongoDate(0.00000000 1765634400)","event_id":75809386,"featured":"","geo":[-78.6014563,36.9928352],"group_key":"75809386","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Drakes Branch, VA","repeat_id":"","search_text":"Drakes Branch Farmers Market, Drakes Branch Farmers Market, 150 Depot Street, Drakes Branch, season spring summer market hours april september friday am special october november december saturdays locationnbspunder pavilion depot street drakes branch","sef_tail":"\/event\/drakes-branch-farmers-market-2025-12-13-drakes-branch-va.html","start":"MongoDate(0.00000000 1765620000)","state":"VA","tags":["farmers-market","step-outside","aarp","clubs-and-organizations"],"title":"Drakes Branch Farmers Market","town_sef_url":"drakes-branch-va","venue_name":"Drakes Branch Farmers Market","dates":[]}}],"params":"{\"title\":\"Events Near South Hill VA\",\"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\":36.752220153808594,\"lng\":-78.04638671875,\"latlng\":\"36.752220153809,-78.04638671875\",\"count\":0}","modified":"MongoDate(0.43800000 1765183483)","created":"MongoDate(0.43800000 1765183483)"} , true) | | 0 | 0 | 2 |
| 12 | db.places.find( {"geo":{"$near":[-78.04638671875,36.752220153808594],"$maxDistance":1.4492753623188406},"tags":"farmers-market"}, [] ).sort( [] ).limit( 10 ).skip( 0 ) | | 0 | 0 | 2 |
| 13 | db.places.count( {"geo":{"$near":[-78.04638671875,36.752220153808594],"$maxDistance":1.4492753623188406},"tags":"farmers-market"} ) | | 0 | 0 | 1 |
