Nr	Query	Num. rows	Took (ms)
1	db.pages.find( {"type":"town","slug":{"$in":["events","events\/restaurants"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.events_cache.find( {"_id":"49306fce720564819350b06b60772f44"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
3	db.events_radius_cache.find( {"_id":"e509705c7ce8ffdd0ee6f5df6c1f86bd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
4	db.events.count( {"address.town_sef_url":"andover-ma","start":{"$gte":"MongoDate(0.00000000 1765519200)","$lt":"MongoDate(0.00000000 1766124000)"}} )	0	2
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	56
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	44
7	db.events_radius_cache.count( {"_id":"e509705c7ce8ffdd0ee6f5df6c1f86bd"} )	0	1
8	db.events_radius_cache.insert( {"_id":"e509705c7ce8ffdd0ee6f5df6c1f86bd","radius":25,"modified":"MongoDate(0.91600000 1765600434)","created":"MongoDate(0.91600000 1765600434)"} , true)	0	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765519200)"},"tags":"restaurants","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( 16 ).skip( 0 )	6	3
10	db.events_cache.count( {"_id":"49306fce720564819350b06b60772f44"} )	0	1
11	db.events_cache.count( {"_id":"49306fce720564819350b06b60772f44"} )	0	1
12	db.events_cache.insert( {"_id":"49306fce720564819350b06b60772f44","town_sef_url":"andover-ma","data_key":["693321004389be6be5652d39","693321014389be6be56531af","693321024389be6be5653487","693321054389be6be56548b8","693321054389be6be5654bcd","693321074389be6be5655857"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Andover Featured Events<br>Restaurants\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"restaurants\",\"tags\":\"restaurants\",\"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\":42.65660095214844,\"lng\":-71.1405029296875,\"latlng\":\"42.656600952148,-71.140502929688\",\"city\":\"Andover\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.93800000 1765600434)","created":"MongoDate(0.93800000 1765600434)"} , true)	0	1

Andover

Massachusetts

Andover Featured Events
Restaurants

Michael’s Harborside Hosts Free Music Bingo

Michael’s Harborside in Newburyport Hosts FREE Trivia Nights

Michael’s Harborside in Newburyport Presents FREE Live Music Nights

Michael’s Harborside Hosts Free Music Bingo

Michael’s Harborside in Newburyport Hosts FREE Trivia Nights

Michael’s Harborside Hosts Free Music Bingo

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 EventsRestaurants

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.

Andover Featured Events
Restaurants

20 million people
rely on AmericanTowns each year to find & share local information.