Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"altona-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"upperville-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"a1ae62e1bee8cb57e6a31183f04b9c4e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"9b7f4198d6c36150de949c71c5b279d1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)"},"geo":{"$geoWithin":{"$center":[[-77.88480377197266,38.994300842285156],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	177
9	db.events_cache.count( {"_id":"a1ae62e1bee8cb57e6a31183f04b9c4e"} )	0	1
10	db.events_cache.count( {"_id":"a1ae62e1bee8cb57e6a31183f04b9c4e"} )	0	1
11	db.events_cache.insert( {"_id":"a1ae62e1bee8cb57e6a31183f04b9c4e","town_sef_url":"upperville-va","data_key":["6933cbd9de4ae56f5a4a79e9","6913ef96de4ae56f5a16bbca","6892ce40fb5e4bed1f90b201","6896c2c4fb5e4bed1f1b5441","690aed59de4ae56f5ae027fe","692156d6de4ae56f5a9cab74","689c08befb5e4bed1f1f992b","689ffd45fb5e4bed1f956a89","68e5cb20c3af739f25c78a29","694b9f6cde4ae56f5a029755","68a5433ffb5e4bed1febca8b","68a9068ac3af739f250a46fd","691bd896de4ae56f5a7c1498","68ae4c87c3af739f25822c41","68b24109c3af739f2526ed1a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Upperville 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.994300842285156,\"lng\":-77.88480377197266,\"latlng\":\"38.994300842285,-77.884803771973\",\"city\":\"Upperville\",\"state\":\"VA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.17700000 1769814212)","created":"MongoDate(0.17700000 1769814212)"} , true)	0	1
12	db.towns.find( {"sef_url":"upperville-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","va","fauquier-county-va","upperville-va"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Upperville

Virginia

Upperville Featured Events

Jackyl and MotorSmoke

The Reagan Years

Worship: Holy Eucharist

Worship on Wednesdays

The Koffin Kats and Playboy Manbaby

Tell Me Lies – The Fleetwood Mac Experience

Worship: Holy Eucharist

Worship on Wednesdays

TREY KENNEDY - THE RELATABLE TOUR

Rapidan Trout Unlimited 36th Annual Fly Fishing Show

Worship: Holy Eucharist

Worship on Wednesdays

Fitz and The Tantrums

Worship: Holy Eucharist

Worship on Wednesdays

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.

Upperville Featured Events

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.