Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"freeborn-mn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"andover-nj"}, [] ).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":"7be0272281a3a876100f7e4419a5a768"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767852000)"},"geo":{"$geoWithin":{"$center":[[-74.74199676513672,40.985801696777344],0.14492753623188406]}}}, ["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	290
8	db.events_cache.count( {"_id":"7be0272281a3a876100f7e4419a5a768"} )	0	1
9	db.events_cache.count( {"_id":"7be0272281a3a876100f7e4419a5a768"} )	0	1
10	db.events_cache.insert( {"_id":"7be0272281a3a876100f7e4419a5a768","town_sef_url":"andover-nj","data_key":["68d71ccc293763705803eef4","68e9411f8675dc6605051788","68baf6ac69adceb60507b575","68c9e9da51efd7469a00b9cb","68f158eff632dfbd2b06990c","6902aa4607edb82851099c5c","68e754e2c3af739f2514dc6b","690455dbde4ae56f5a346467","695c7211de4ae56f5a66626c","695c7211de4ae56f5a6662ad","695c7211de4ae56f5a6662e5","695c7211de4ae56f5a6662ff","695c7211de4ae56f5a66631b","695c7211de4ae56f5a66632f","695c7212de4ae56f5a666453"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Andover Featured Events\",\"keyword\":\"\",\"radius\":10,\"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\":40.985801696777344,\"lng\":-74.74199676513672,\"latlng\":\"40.985801696777,-74.741996765137\",\"city\":\"Andover\",\"state\":\"NJ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.12500000 1767889926)","created":"MongoDate(0.12500000 1767889926)"} , true)	0	1
11	db.towns.find( {"sef_url":"andover-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.tokens.find( {"sef_url":{"$in":["usa","nj","sussex-county-nj","andover-nj"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Andover

New Jersey

Andover Featured Events

Queensryche

The Lords Of 52nd Street

Vic DiBitetto

Dar Williams

Lotus Land: The American Rush Tribute

Let's Hang On!

Steve Kimock, Jackie Greene and more

Béla Fleck, Edmar Castañeda and more

Sussex County Miners vs. Down East Bird Dawgs

Sussex County Miners vs. Down East Bird Dawgs

Sussex County Miners vs. Down East Bird Dawgs

Sussex County Miners vs. Tri-City ValleyCats

Sussex County Miners vs. Tri-City ValleyCats

Sussex County Miners vs. Tri-City ValleyCats

Sussex County Miners vs. Brockton Rox

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.

Andover 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.