Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"andover-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"andover-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ct","tolland-county-ct","andover-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"7a84079a50d33230d6b67e7156136376"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767420000)"},"geo":{"$geoWithin":{"$center":[[-72.36849975585938,41.73849868774414],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	173
7	db.events_cache.count( {"_id":"7a84079a50d33230d6b67e7156136376"} )	0	6
8	db.events_cache.insert( {"_id":"7a84079a50d33230d6b67e7156136376","town_sef_url":"andover-ct","data_key":["69036aed4389be6be5f6438e","69036aed4389be6be5f64837","69036aed4389be6be5f648d1","69036aee4389be6be5f64a4d","69036aee4389be6be5f64b1f","69036aee4389be6be5f64c75","69036aee4389be6be5f64da9","69036aee4389be6be5f64e64","69036aef4389be6be5f6507f","69036aef4389be6be5f65096","69036aef4389be6be5f65594","69036af04389be6be5f656cc","6933210b4389be6be56575d8","69036af04389be6be5f65a35","69036af04389be6be5f65aed"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Andover 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\":41.73849868774414,\"lng\":-72.36849975585938,\"latlng\":\"41.738498687744,-72.368499755859\",\"city\":\"Andover\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.02600000 1767449817)","created":"MongoDate(0.02600000 1767449817)"} , true)	0	2

Andover

Connecticut

Andover Featured Events

UConn Huskies Womens Basketball vs. Seton Hall Pirates Womens Basketball

Coventry Winter Farmer's Market

UConn Huskies Mens Basketball vs. Marquette Golden Eagles Mens Basketball

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

UConn Huskies Womens Basketball vs. St. Johns Red Storm Womens Basketball

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

UConn Huskies Hockey vs. UMass Lowell River Hawks Hockey

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

UConn Huskies Mens Basketball vs. DePaul Blue Demons Mens Basketball

Hartford Wolfpack vs. Providence Bruins

Changes In Latitudes (Jimmy Buffett Tribute)

Luciano

Coventry Winter Farmer's Market

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.

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