Wednesday, Oct 1, 2025 at 8:00am
Season: Summer
Market Hours:
April 19 - October 25, 2025
Wednesday and Saturday, 8am - 12pm
Location: corner of 2nd and Douglas Streets
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.events.find( {"sef_tail":"\/event\/downtown-lees-summit-farmers-market-2025-10-01-lees-summit-mo.html"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"sef_tail":{"$ne":"\/event\/downtown-lees-summit-farmers-market-2025-10-01-lees-summit-mo.html"},"title":"Downtown Lee's Summit Farmers Market","venue_name":"","city":"Lees Summit","state":"MO"}, ["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\/downtown-lees-summit-farmers-market-2025-10-01-lees-summit-mo.html"]},"site.hostname":{"$in":["step"]},"type":"content"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 4 | db.events_cache.find( {"_id":"e5becdc5a4d4b48aa4d91be5f8bc09bf"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 5 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767247200)"},"town_sef_url":"lancaster-sc"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 1 | 2 | |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-80.7739028930664,34.72570037841797],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767506400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 1 | 3 | |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-80.7739028930664,34.72570037841797],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767506400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 2 | 4 | |
| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-80.7739028930664,34.72570037841797],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1766642400)"}}}},{"$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 | 3 | 13 | |
| 9 | db.events_cache.count( {"_id":"e5becdc5a4d4b48aa4d91be5f8bc09bf"} ) | 0 | 0 | 1 | |
| 10 | db.events_cache.count( {"_id":"e5becdc5a4d4b48aa4d91be5f8bc09bf"} ) | 0 | 0 | 1 | |
| 11 | db.events_cache.insert( {"_id":"e5becdc5a4d4b48aa4d91be5f8bc09bf","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":2.9438412479003526,"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":[]}},{"Event":{"_id":{"title":"Union County Farmers' Market","venue_name":"","city":"Monroe","state":"NC"},"id":ObjectId ("687938f1384bf9134e01cae8"),"city":"Monroe","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 27, 2025 at 8:00am","time_string":"8:00 AM","distance":23.443270237807294,"end":"MongoDate(0.00000000 1766836800)","event_id":75066340,"featured":"","geo":[-80.54959869384766,35.01029968261719],"group_key":"3205166","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Monroe, NC","repeat_id":"3205166","search_text":"Union County Farmers' Market, , 805 Skyway Drive, Monroe, seasonnbspsummer market hours april december saturdays from pm locationnbspskyway drive monroe","sef_tail":"\/event\/union-county-farmers-market-2025-12-27-monroe-nc.html","start":"MongoDate(0.00000000 1766822400)","state":"NC","tags":["farmers-market","step-outside","aarp","clubs-and-organizations","2025-updated"],"title":"Union County Farmers' Market","town_sef_url":"monroe-nc","venue_name":"","dates":[]}},{"Event":{"_id":{"title":"Waxhaw Farmer's Market","venue_name":"","city":"Waxhaw","state":"NC"},"id":ObjectId ("687938f2384bf9134e01cd7f"),"city":"Waxhaw","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 27, 2025 at 9:00am","time_string":"9:00 AM","distance":14.083372380482126,"end":"MongoDate(0.00000000 1766836800)","event_id":75072504,"featured":"","geo":[-80.73590087890625,34.92689895629883],"group_key":"3205335","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Waxhaw, NC","repeat_id":"3205335","search_text":"Waxhaw Farmer's Market, , 27283 Waxhaw Parkway, Waxhaw, market hours seasonnbspsummer april december saturdays pmnbsp locationnbsp waxhaw parkway","sef_tail":"\/event\/waxhaw-farmers-market-2025-12-27-waxhaw-nc.html","start":"MongoDate(0.00000000 1766826000)","state":"NC","tags":["farmers-market","step-outside","aarp","clubs-and-organizations","2025-updated"],"title":"Waxhaw Farmer's Market","town_sef_url":"waxhaw-nc","venue_name":"","dates":[]}}],"params":"{\"show\":3,\"max-miles\":\"25\",\"max-days\":\"120\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"downtown-lees-summit-farmers-market-2025-10-01-lees-summit-mo.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.72570037841797,\"lng\":-80.7739028930664,\"latlng\":\"34.725700378418,-80.773902893066\",\"count\":2}","modified":"MongoDate(0.70800000 1766686541)","created":"MongoDate(0.70800000 1766686541)"} , true) | 0 | 0 | 2 |
