Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"waterford-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.places.find( {"address.town_sef_url":"waterford-va","tags":"clubs-and-organizations"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	8	2
3	db.events_cache.find( {"_id":"cf59f888213a1eafc068d938ced981d8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
4	db.events_radius_cache.find( {"_id":"744e9fc4a6943f615d7957c859b7bca3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"geo":{"$geoWithin":{"$center":[[-77.61150360107422,39.18830108642578],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 11 ).skip( 0 )	11	21
6	db.events_cache.count( {"_id":"cf59f888213a1eafc068d938ced981d8"} )	0	1
7	db.events_cache.insert( {"_id":"cf59f888213a1eafc068d938ced981d8","town_sef_url":"waterford-va","data_key":["681728fcfb5e4bed1f84ab57","689d9d67410059e7d104a211","6893ae79fb5e4bed1f540697","68c8ca1dc3af739f2528e675","689afa8c843db913e8072d2f","6893ae79fb5e4bed1f540705","68187a99fb5e4bed1ffacf6b","68c8ca1dc3af739f2528e75d","6819cc47fb5e4bed1f9a9665","6819cc58fb5e4bed1f9ab358"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"clubs-and-organizations\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":39.18830108642578,\"lng\":-77.61150360107422,\"latlng\":\"39.188301086426,-77.611503601074\",\"city\":\"Waterford\",\"state\":\"VA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.92700000 1761813596)","created":"MongoDate(0.92700000 1761813596)"} , true)	0	2

Waterford

Virginia

Waterford Groups and Organizations

8 Chains North Winery

Corcoran Vineyards

Farmers Market at Wheatland Spring Farm and Brewery

Journey Through Hallowed Ground National Scenic Byway

Nova Ridge Vineyards

Terra Nebulo Vineyard

Tree and Leaf CSA

Village Winery

Local Events

Herndon Farmers Market

Cox Farms Fall Festival

Summers Farm Fall Festival

The Messer Chups Halloween Party

Cox Farms Fall Festival

Summers Farm Fall Festival

Brunswick Main Street Farmers Market

Mr Scary Halloween with Lynch Mob

Reston Farmers Market

EatLoco Farmers Market at Ashbrook