Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"andover-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"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	1
5	db.places.find( {"address.town_sef_url":"andover-ct"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	16	4
6	db.events_cache.find( {"_id":"9fee16b1bc8674965b9f41f5065e787e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"7d7a0631cd67d39d221c41ea3efbce41"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"andover-ct","start":{"$gte":"MongoDate(0.00000000 1767160800)","$lt":"MongoDate(0.00000000 1767765600)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.36849975585938,41.73849868774414],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767160800)","$lt":"MongoDate(0.00000000 1768024800)"}} )	1	19
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.36849975585938,41.73849868774414],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767160800)","$lt":"MongoDate(0.00000000 1768024800)"}} )	3	19
11	db.events_radius_cache.count( {"_id":"7d7a0631cd67d39d221c41ea3efbce41"} )	0	1
12	db.events_radius_cache.insert( {"_id":"7d7a0631cd67d39d221c41ea3efbce41","radius":25,"modified":"MongoDate(0.48100000 1767161661)","created":"MongoDate(0.48100000 1767161661)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767160800)"},"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( 11 ).skip( 0 )	11	108
14	db.events_cache.count( {"_id":"9fee16b1bc8674965b9f41f5065e787e"} )	0	1
15	db.events_cache.count( {"_id":"9fee16b1bc8674965b9f41f5065e787e"} )	0	1
16	db.events_cache.insert( {"_id":"9fee16b1bc8674965b9f41f5065e787e","town_sef_url":"andover-ct","data_key":["69036aea4389be6be5f63658","69036aea4389be6be5f6368a","69036aea4389be6be5f63792","69036aeb4389be6be5f63a7e","69036aeb4389be6be5f63d99","69036aec4389be6be5f63f30","69036aec4389be6be5f63fe6","69036aed4389be6be5f6438e","69036aed4389be6be5f64837","69036aed4389be6be5f648d1"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"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.62700000 1767161661)","created":"MongoDate(0.62700000 1767161661)"} , true)	0	1

Andover

Connecticut

Andover Groups and Organizations

Andover Elementary School

Andover Farmer's Market

Andover Public Library

Andover Sportman's Club

Andover Volunteer Fire Department

Andover Volunteer Fire Department

Circle K

Circle K

Circle K

First Congregational Church United Church of Christ

Hurst Farmily Farm

Mad Dog Laces

Scott's Tree Farm

The Fresh Air Fund

Town Of Andover

Town Of Andover

Local Events

UConn Huskies Hockey vs. LIU Sharks Mens Ice Hockey

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

Hartford Wolfpack vs. Bridgeport Islanders

lespecial, Leon Trout and more

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

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

Hartford Wolfpack vs. Providence Bruins

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

COVID-19 Resources