Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"andover-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.towns.find( {"sef_url":"andover-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
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":"8fcdd8e915343b41a4931a218f9f4618"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	6
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-72.36849975585938,41.73849868774414],0.07246376811594203]}}}, ["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 )	8	168
7	db.events_cache.count( {"_id":"8fcdd8e915343b41a4931a218f9f4618"} )	0	1
8	db.events_cache.insert( {"_id":"8fcdd8e915343b41a4931a218f9f4618","town_sef_url":"andover-ct","data_key":["69036aed4389be6be5f64837","69036af04389be6be5f65aed","69036af34389be6be5f672a4","69036af74389be6be5f68dfc","69036afa4389be6be5f6a8c5","69036afd4389be6be5f6c282","69036b014389be6be5f6db4a","69036b074389be6be5f704e6"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Andover Featured Events\",\"keyword\":\"\",\"radius\":5,\"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\":false}","modified":"MongoDate(0.40700000 1766531180)","created":"MongoDate(0.40700000 1766531180)"} , true)	0	2

Andover

Connecticut

Andover Featured Events

Coventry Winter Farmer's Market

Coventry Winter Farmer's Market

Coventry Winter Farmer's Market

Coventry Winter Farmer's Market

Coventry Winter Farmer's Market

Coventry Winter Farmer's Market

Coventry Winter Farmer's Market

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.