Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gainesville-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"gainesville-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","va","prince-william-county-va","gainesville-va"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"c7359d2325548fd475f8ca1c3909c9be"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"f9935d0ef287fd5e74ffa85ca1320cf0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"gainesville-va","start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.61389923095703,38.79570007324219],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	36
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.61389923095703,38.79570007324219],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	6	36
9	db.events_radius_cache.count( {"_id":"f9935d0ef287fd5e74ffa85ca1320cf0"} )	0	11
10	db.events_radius_cache.insert( {"_id":"f9935d0ef287fd5e74ffa85ca1320cf0","radius":25,"modified":"MongoDate(0.04700000 1766151213)","created":"MongoDate(0.04700000 1766151213)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"geo":{"$geoWithin":{"$center":[[-77.61389923095703,38.79570007324219],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( 16 ).skip( 0 )	16	208
12	db.events_cache.count( {"_id":"c7359d2325548fd475f8ca1c3909c9be"} )	0	1
13	db.events_cache.count( {"_id":"c7359d2325548fd475f8ca1c3909c9be"} )	0	1
14	db.events_cache.insert( {"_id":"c7359d2325548fd475f8ca1c3909c9be","town_sef_url":"gainesville-va","data_key":["68a75b6303a70639b6cf238f","68a75b6303a70639b6cf23a1","68a75b6303a70639b6cf25b6","69036ae14389be6be5f60414","69036ae14389be6be5f60610","68a75b6503a70639b6cf300d","68a75b6503a70639b6cf30f7","68a75b6503a70639b6cf30f3","68a75b6503a70639b6cf3152","69036ae34389be6be5f611fc","69036ae34389be6be5f6132a","693321044389be6be56546a3","69036ae64389be6be5f61f19","68a75b6a03a70639b6cf4d5b","68a75b6a03a70639b6cf4d49"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Gainesville Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"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\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":38.79570007324219,\"lng\":-77.61389923095703,\"latlng\":\"38.795700073242,-77.613899230957\",\"city\":\"Gainesville\",\"state\":\"VA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.28700000 1766151213)","created":"MongoDate(0.28700000 1766151213)"} , true)	0	1

Gainesville

Virginia

Gainesville Featured Events

EatLoco Farmers Market at Ashbrook

Oakton Market

PEC's Gilberts Corner Farmers Market

WBB vs. Princeton

Tchaikovsky's The Nutcracker with the FSO and Fairfax Ballet

EatLoco Farmers Market at Brambleton

Mosaic Sunday Market

PEC's Gilberts Corner Farmers Market

Archwood Green Barns Farmers' Market

MBB vs. Loyola Maryland

Tchaikovsky’s The Nutcracker with the FSO and Fairfax Ballet

Profs & Pints Northern Virginia: How the Nutcracker Came to Life

Live Music: The Cold North

Oakton Market

EatLoco Farmers Market at Ashbrook

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Gainesville Featured Events

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.