Thursday, Oct 23, 2025 at 10:00am
Season: Summer And Fall
Market Hours
April 24 - November 13, 2025
Thursdays, 10am - 2pm
Location: Farrington Square - at the intersection of New and Morton Streets
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.events.find( {"sef_tail":"\/event\/bethlehem-farmers-market-2025-10-23-bethlehem-pa.html"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"sef_tail":{"$ne":"\/event\/bethlehem-farmers-market-2025-10-23-bethlehem-pa.html"},"title":"Bethlehem Farmers' Market","venue_name":"Farrington Square","city":"Bethlehem","state":"PA"}, ["start","date_string","sef_tail"] ).sort( {"start":1} ).limit( 0 ).skip( 0 ) | 0 | 0 | 1 | |
| 3 | db.pages.find( {"slug":{"$in":["event-detail","event-detail\/bethlehem-farmers-market-2025-10-23-bethlehem-pa.html"]},"site.hostname":{"$in":["step"]},"type":"content"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 | |
| 4 | db.events_cache.find( {"_id":"b3914aabcc4ffc4fd49c36e07ee5b6c8"}, [] ).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 | 2 | |
| 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 | 5 | |
| 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 | 9 | |
| 9 | db.events_cache.count( {"_id":"b3914aabcc4ffc4fd49c36e07ee5b6c8"} ) | 0 | 0 | 1 | |
| 10 | db.events_cache.count( {"_id":"b3914aabcc4ffc4fd49c36e07ee5b6c8"} ) | 0 | 0 | 1 | |
| 11 | db.events_cache.insert( {"_id":"b3914aabcc4ffc4fd49c36e07ee5b6c8","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\":\"bethlehem-farmers-market-2025-10-23-bethlehem-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.72570037841797,\"lng\":-80.7739028930664,\"latlng\":\"34.725700378418,-80.773902893066\",\"count\":2}","modified":"MongoDate(0.86800000 1766686541)","created":"MongoDate(0.86800000 1766686541)"} , true) | 0 | 0 | 2 |
