Nr	Query	Num. rows	Took (ms)
1	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.places.find( {"address.town_sef_url":"marlborough-ma"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
3	db.events_cache.find( {"_id":"b3c7dc9aea35478ab7e62b0769d2e678"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
4	db.events_radius_cache.find( {"_id":"99507ad31492674336dce463519df99e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
5	db.events.count( {"address.town_sef_url":"marlborough-ma","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	1
6	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.54620361328125,42.35020065307617],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	0	37
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.54620361328125,42.35020065307617],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	0	26
8	db.events_radius_cache.count( {"_id":"99507ad31492674336dce463519df99e"} )	0	1
9	db.events_radius_cache.insert( {"_id":"99507ad31492674336dce463519df99e","radius":25,"modified":"MongoDate(0.63400000 1766861294)","created":"MongoDate(0.63400000 1766861294)"} , true)	0	2
10	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"geo":{"$geoWithin":{"$center":[[-71.54620361328125,42.35020065307617],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	178
11	db.events_cache.count( {"_id":"b3c7dc9aea35478ab7e62b0769d2e678"} )	0	1
12	db.events_cache.count( {"_id":"b3c7dc9aea35478ab7e62b0769d2e678"} )	0	1
13	db.events_cache.insert( {"_id":"b3c7dc9aea35478ab7e62b0769d2e678","town_sef_url":"marlborough-ma","data_key":["69036ae74389be6be5f6265a","69036ae84389be6be5f628e4","693321064389be6be565530d","69036ae94389be6be5f62d7d","693321074389be6be5655a19","693321084389be6be5655e03","693321084389be6be5655f2c","69036aeb4389be6be5f63b83","69036aec4389be6be5f64052","69036aec4389be6be5f642ef"],"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\":42.35020065307617,\"lng\":-71.54620361328125,\"latlng\":\"42.350200653076,-71.546203613281\",\"city\":\"Marlborough\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.87500000 1766861294)","created":"MongoDate(0.87500000 1766861294)"} , true)	0	2

Marlborough

Massachusetts

Marlborough Groups and Organizations

Articulators Toastmasters Club

Assabet River Rail Trail

BayPath Elder Services, Inc.

Chamber Music MetroWest

Child Protection Resources

City Of Marlborough

Cochran Wrenn Duo

Colonial Garden Club Of Marlborough

Cornerstone Community Church

Epiphany Horse Sales

Firefly's BBQ - Dante's

First Church Of Christ, Scientist

First Church in Marlborough

First United Methodist Church

Folk Art Festival of New England

Forekicks Outdoor and Indoor Sports Company

Friends of the Marlborough Public Library

GFWC Marlborough Junior Woman's Club

Ghiloni Park

Ghost Light Players of the Metrowest

Local Events

Worcester Railers vs. Adirondack Thunder | HOME FOR THE HOLIDAYS GAME1

John Cafferty & the Beaver Brown Band

Bellas Bartok w/ Woody & the Rebel Alliance

Worcester Railers vs. Adirondack Thunder | HOME FOR THE HOLIDAYS GAME2

Big Emms Live

Off The Rails Presents: Honky Tonk New Years Eve

MEGA REVEILLON NYE FAVELA ENCANTADA

Consider the Source w/ Minka - New Year's Eve

Bentley Falcons Hockey vs. Holy Cross Crusaders Hockey

Holy Cross Crusaders Hockey vs. Bentley Falcons Hockey

COVID-19 Resources