Season: Summer
Market Hours:
May 24 - October, 2025
Saturdays, 8AM - 12PM
Location: 100 Pennsylvania Avenue
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.events.find( {"sef_tail":"\/event\/irwin-farm-market-2025-09-13-irwin-pa.html"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 2 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"sef_tail":{"$ne":"\/event\/irwin-farm-market-2025-09-13-irwin-pa.html"},"title":"Irwin Farm Market","venue_name":"Irwin Farm Market","city":"Irwin","state":"PA"}, ["start","date_string","sef_tail"] ).sort( {"start":1} ).limit( 0 ).skip( 0 ) | 0 | 0 | 2 | |
| 3 | db.pages.find( {"slug":{"$in":["event-detail","event-detail\/irwin-farm-market-2025-09-13-irwin-pa.html"]},"site.hostname":{"$in":["step"]},"type":"content"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 4 | db.events_cache.find( {"_id":"5b14a9d1c59323ee2556fb67722889a3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 5 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"},"town_sef_url":"westville-sc"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 0 | 2 | |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-80.59870147705078,34.456199645996094],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 0 | 2 | |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-80.59870147705078,34.456199645996094],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 0 | 3 | |
| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-80.59870147705078,34.456199645996094],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1766815200)"}}}},{"$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":3}]}, [] ).sort( {"start":1,"id":1} ).limit( 3 ).skip( 0 ) | 0 | 1 | 12 | |
| 9 | db.events_cache.count( {"_id":"5b14a9d1c59323ee2556fb67722889a3"} ) | 0 | 0 | 1 | |
| 10 | db.events_cache.count( {"_id":"5b14a9d1c59323ee2556fb67722889a3"} ) | 0 | 0 | 1 | |
| 11 | db.events_cache.insert( {"_id":"5b14a9d1c59323ee2556fb67722889a3","data":[{"Event":{"_id":{"title":"Lancaster County Farmers Market","venue_name":"Lancaster County Farmers Market","city":"Lancaster","state":"SC"},"id":ObjectId ("68793928384bf9134e02acfe"),"city":"Lancaster","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 27, 2025 at 7:00am","time_string":"7:00 AM","distance":19.699542251432664,"end":"MongoDate(0.00000000 1766840400)","event_id":75768839,"featured":"","geo":[-80.72229766845703,34.722198486328125],"group_key":"3214310","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Lancaster, SC","repeat_id":"3214310","search_text":"Lancaster County Farmers Market, Lancaster County Farmers Market, 1920 Pageland Highway, Lancaster, season summer wintermarket hoursmaynbsp saturdays only from pmjunenbsp thursdays pmjuly augustnbsp tuesdays pmseptember octobernbsp pmnovember decembernbsp while supplies lastlocation pageland highway lancaster","sef_tail":"\/event\/lancaster-county-farmers-market-2025-12-27-lancaster-sc.html","start":"MongoDate(0.00000000 1766818800)","state":"SC","tags":["farmers-market","step-outside","aarp","clubs-and-organizations","bronze","2025-updated"],"title":"Lancaster County Farmers Market","town_sef_url":"lancaster-sc","venue_name":"Lancaster County Farmers Market","dates":[]}}],"params":"{\"show\":3,\"max-miles\":\"25\",\"max-days\":\"120\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"irwin-farm-market-2025-09-13-irwin-pa.html\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"120\",\"images\":\"yes\",\"message\":\"\",\"min\":20,\"title\":\"\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"more\":\"yes\",\"autoshowmore\":\"no\",\"link\":\"\",\"showdesc\":\"yes\",\"rankby\":\"distance\",\"type\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"lat\":34.456199645996094,\"lng\":-80.59870147705078,\"latlng\":\"34.456199645996,-80.598701477051\",\"count\":0}","modified":"MongoDate(0.02600000 1766863853)","created":"MongoDate(0.02600000 1766863853)"} , true) | 0 | 0 | 2 |
