Saturday, Nov 22, 2025 at 7:30am
Season: Summer and Fall
Market Hours:
April 26, 2025 - November 29, 2025
Saturdays, 7:30AM - 1PM
Location: Main Street between Clark and Monroe Streets
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.events.find( {"sef_tail":"\/event\/the-saint-charles-market-2025-11-22-saint-charles-mo.html"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 5 | |
| 2 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"sef_tail":{"$ne":"\/event\/the-saint-charles-market-2025-11-22-saint-charles-mo.html"},"title":"The Saint Charles Market","venue_name":"","city":"Saint Charles","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\/the-saint-charles-market-2025-11-22-saint-charles-mo.html"]},"site.hostname":{"$in":["step"]},"type":"content"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 4 | db.events_cache.find( {"_id":"fe4bc62fbf4d89fe540ecd1fa5a4aad2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 5 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767247200)"},"town_sef_url":"santa-anna-tx"}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | 0 | 0 | 3 | |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-99.32219696044922,31.737300872802734],"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 | 0 | 2 | |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-99.32219696044922,31.737300872802734],"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 | 0 | 2 | |
| 8 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-99.32219696044922,31.737300872802734],"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 | 1 | 7 | |
| 9 | db.events_cache.count( {"_id":"fe4bc62fbf4d89fe540ecd1fa5a4aad2"} ) | 0 | 0 | 1 | |
| 10 | db.events_cache.count( {"_id":"fe4bc62fbf4d89fe540ecd1fa5a4aad2"} ) | 0 | 0 | 1 | |
| 11 | db.events_cache.insert( {"_id":"fe4bc62fbf4d89fe540ecd1fa5a4aad2","data":[{"Event":{"_id":{"title":"Wilderness Survival Hike","venue_name":"Lake Brownwood State Park","city":"Brownwood","state":"TX"},"id":ObjectId ("687938cb384bf9134e011d34"),"city":"Brownwood","cvent_id":null,"cvent_status":null,"date_string":"Friday, Dec 26, 2025 at 1:30pm","time_string":"1:30 PM","distance":19.721008527166788,"end":"MongoDate(0.00000000 1766761200)","event_id":74095407,"featured":"","geo":[-98.99440002441406,31.67799949645996],"group_key":"3183130","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Brownwood, TX","repeat_id":"3183130","search_text":"Wilderness Survival Hike, Lake Brownwood State Park, 200 State Highway Park Road 15, Brownwood, join ranger learn about plants other resources native people used areaknow what natural could help survive wild fungi utilized comanche apache peoples their survival before luxuries have today resources early european settlers will covered well science behind medicinal discussed use safety efficacy where meet texas trailhead what bring sturdy walking shoes sense curiosity this program free with park entrance program weather dependentcontactgeorge dudichgeorgedudichtpwdtexasgov","sef_tail":"\/event\/wilderness-survival-hike-2025-12-26-brownwood-tx.html","start":"MongoDate(0.00000000 1766755800)","state":"TX","tags":["step-outside","aarp","hiking-trail","sports-and-recreation","campground","fishing-hole","jet-ski","picknicking","swim-place","water-skiing","picnicking","extreme-adventure","bronze","hiking","camping","fishing","water-sports"],"title":"Wilderness Survival Hike","town_sef_url":"brownwood-tx","venue_name":"Lake Brownwood State Park","dates":[]}}],"params":"{\"show\":3,\"max-miles\":\"25\",\"max-days\":\"120\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"the-saint-charles-market-2025-11-22-saint-charles-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\":31.737300872802734,\"lng\":-99.32219696044922,\"latlng\":\"31.737300872803,-99.322196960449\",\"count\":0}","modified":"MongoDate(0.13500000 1766651581)","created":"MongoDate(0.13500000 1766651581)"} , true) | 0 | 0 | 2 |
