Saturday, Dec 20, 2025 at 7:00am
Season: Summer - Winter
Market Hours:
May 2025: Saturdays only from 7 am to 1 pm
June 2025: Thursdays and Saturdays from 7 am to 1 pm
July and August 2025: Tuesdays, Thursdays, and Saturdays from 7 am to 1 pm
September and October 2025: Thursdays and Saturdays from 7 am to 1 pm
November and December 2025: Saturdays only from 7 am to 1 pm (or while supplies last)
Location: 1920 Pageland Highway, Lancaster, SC 29720
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.events.find( {"sef_tail":"\/event\/lancaster-county-farmers-market-2025-12-20-lancaster-sc.html"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 6 | |
| 2 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1764914400)"},"sef_tail":{"$ne":"\/event\/lancaster-county-farmers-market-2025-12-20-lancaster-sc.html"},"title":"Lancaster County Farmers Market","venue_name":"Lancaster County Farmers Market","city":"Lancaster","state":"SC"}, ["start","date_string","sef_tail"] ).sort( {"start":1} ).limit( 0 ).skip( 0 ) | 0 | 3 | 4 | |
| 3 | db.towns.find( {"sef_url":"lancaster-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 4 | db.pages.find( {"slug":{"$in":["event-detail","event-detail\/lancaster-county-farmers-market-2025-12-20-lancaster-sc.html"]},"site.hostname":{"$in":["step"]},"type":"content"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 5 | db.events_cache.find( {"_id":"278fcbeac11b7a16a80d7ff982fcaf2e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 6 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765519200)"},"town_sef_url":"lancaster-sc"}},{"$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.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765778400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 1 | 3 | |
| 8 | 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 1764914400)","$lt":"MongoDate(0.00000000 1765778400)"}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 2 | 5 | |
| 9 | 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 1764914400)"}}}},{"$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 | 16 | |
| 10 | db.events_cache.count( {"_id":"278fcbeac11b7a16a80d7ff982fcaf2e"} ) | 0 | 0 | 1 | |
| 11 | db.events_cache.count( {"_id":"278fcbeac11b7a16a80d7ff982fcaf2e"} ) | 0 | 0 | 4 | |
| 12 | db.events_cache.insert( {"_id":"278fcbeac11b7a16a80d7ff982fcaf2e","data":[{"Event":{"_id":{"title":"Lancaster County Farmers Market","venue_name":"Lancaster County Farmers Market","city":"Lancaster","state":"SC"},"id":ObjectId ("68793928384bf9134e02acfb"),"city":"Lancaster","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 6, 2025 at 7:00am","time_string":"7:00 AM","distance":2.9438412479003526,"end":"MongoDate(0.00000000 1765026000)","event_id":75768836,"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-06-lancaster-sc.html","start":"MongoDate(0.00000000 1765004400)","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":{"1":{"start":"MongoDate(0.00000000 1765609200)","date_string":"Saturday, Dec 13, 2025 at 7:00am","sef_tail":"\/event\/lancaster-county-farmers-market-2025-12-13-lancaster-sc.html"},"2":{"start":"MongoDate(0.00000000 1766214000)","date_string":"Saturday, Dec 20, 2025 at 7:00am","sef_tail":"\/event\/lancaster-county-farmers-market-2025-12-20-lancaster-sc.html"},"3":{"start":"MongoDate(0.00000000 1766818800)","date_string":"Saturday, Dec 27, 2025 at 7:00am","sef_tail":"\/event\/lancaster-county-farmers-market-2025-12-27-lancaster-sc.html"}}}},{"Event":{"_id":{"title":"Union County Farmers' Market","venue_name":"","city":"Monroe","state":"NC"},"id":ObjectId ("687938f1384bf9134e01cae5"),"city":"Monroe","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 6, 2025 at 8:00am","time_string":"8:00 AM","distance":23.443270237807294,"end":"MongoDate(0.00000000 1765022400)","event_id":75066337,"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-06-monroe-nc.html","start":"MongoDate(0.00000000 1765008000)","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":{"1":{"start":"MongoDate(0.00000000 1765612800)","date_string":"Saturday, Dec 13, 2025 at 8:00am","sef_tail":"\/event\/union-county-farmers-market-2025-12-13-monroe-nc.html"},"2":{"start":"MongoDate(0.00000000 1766217600)","date_string":"Saturday, Dec 20, 2025 at 8:00am","sef_tail":"\/event\/union-county-farmers-market-2025-12-20-monroe-nc.html"},"3":{"start":"MongoDate(0.00000000 1766822400)","date_string":"Saturday, Dec 27, 2025 at 8:00am","sef_tail":"\/event\/union-county-farmers-market-2025-12-27-monroe-nc.html"}}}},{"Event":{"_id":{"title":"Waxhaw Farmer's Market","venue_name":"","city":"Waxhaw","state":"NC"},"id":ObjectId ("687938f2384bf9134e01cd7c"),"city":"Waxhaw","cvent_id":null,"cvent_status":null,"date_string":"Saturday, Dec 6, 2025 at 9:00am","time_string":"9:00 AM","distance":14.083372380482126,"end":"MongoDate(0.00000000 1765022400)","event_id":75072501,"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-06-waxhaw-nc.html","start":"MongoDate(0.00000000 1765011600)","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":{"1":{"start":"MongoDate(0.00000000 1765616400)","date_string":"Saturday, Dec 13, 2025 at 9:00am","sef_tail":"\/event\/waxhaw-farmers-market-2025-12-13-waxhaw-nc.html"},"2":{"start":"MongoDate(0.00000000 1766221200)","date_string":"Saturday, Dec 20, 2025 at 9:00am","sef_tail":"\/event\/waxhaw-farmers-market-2025-12-20-waxhaw-nc.html"},"3":{"start":"MongoDate(0.00000000 1766826000)","date_string":"Saturday, Dec 27, 2025 at 9:00am","sef_tail":"\/event\/waxhaw-farmers-market-2025-12-27-waxhaw-nc.html"}}}}],"params":"{\"show\":3,\"max-miles\":\"25\",\"max-days\":\"120\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"lancaster-county-farmers-market-2025-12-20-lancaster-sc.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.73500000 1764968752)","created":"MongoDate(0.73500000 1764968752)"} , true) | 0 | 0 | 5 |
