Nr	Query	Num. rows	Took (ms)
1	db.places.find( {"address.town_sef_url":"andover-ma","tags":"clubs-and-organizations"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	13	16
2	db.events_cache.find( {"_id":"dff4e960b738f5c8c794a2393eaeb195"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
3	db.events_radius_cache.find( {"_id":"f754e30a6282270a77204e30590f4e70"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
4	db.events.count( {"address.town_sef_url":"andover-ma","start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766124000)"}} )	0	1
5	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.1405029296875,42.65660095214844],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766383200)"}} )	3	42
6	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.1405029296875,42.65660095214844],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766383200)"}} )	9	42
7	db.events_radius_cache.count( {"_id":"f754e30a6282270a77204e30590f4e70"} )	0	1
8	db.events_radius_cache.insert( {"_id":"f754e30a6282270a77204e30590f4e70","radius":25,"modified":"MongoDate(0.00900000 1765576537)","created":"MongoDate(0.00900000 1765576537)"} , true)	0	2
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765519200)"},"geo":{"$geoWithin":{"$center":[[-71.1405029296875,42.65660095214844],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	19
10	db.events_cache.count( {"_id":"dff4e960b738f5c8c794a2393eaeb195"} )	0	1
11	db.events_cache.count( {"_id":"dff4e960b738f5c8c794a2393eaeb195"} )	0	1
12	db.events_cache.insert( {"_id":"dff4e960b738f5c8c794a2393eaeb195","town_sef_url":"andover-ma","data_key":["693320fc4389be6be56516bd","68a75b5703a70639b6cedee7","693320fc4389be6be565172c","68a75b5703a70639b6cedf6c","69036ad64389be6be5f5c4de","69036ad64389be6be5f5c54f","68a75b5703a70639b6cee088","68a75b5703a70639b6cee139","68a75b5703a70639b6cee15f","68a75b5703a70639b6cee1a0"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"clubs-and-organizations\",\"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\":42.65660095214844,\"lng\":-71.1405029296875,\"latlng\":\"42.656600952148,-71.140502929688\",\"city\":\"Andover\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.05700000 1765576537)","created":"MongoDate(0.05700000 1765576537)"} , true)	0	3

Andover

Massachusetts

Andover Groups and Organizations

AVIS - Andover Village Improvement Society

Andover Farmers Market

Andover Historical Society

Andover Rotary Club

Andover Sister Towns Association

Andover Village Improvement Society

Appalacian Mountain Club, Andover Committee

Great Women To Know

Lawrence Rotary Club

League Of Women Voters Of Andover/North Andover

Lion's Heart Andover - Local Teen Volunteer Opportunities

Newcomers and Neighbors of the Andovers

The Fresh Air Fund

Local Events

SoWa Winter Festival

Exhibition: Portia Zvavahera

Santa's Brickmas Adventure at LEGO® Discovery Center Boston

Charles River Farmers Market at Charles Hotel

Junction 18 / Rebuilder / Choke Up / Unseemlier

3rd Annual LET'S ROCK CANCER 2025

Performance - Harry Potter and the Cursed Child

Avery Anna

Preview Performance: Wonder

Moon Hooch with Octave Cat (18+)

COVID-19 Resources