Nr	Query	Num. rows	Took (ms)
1	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/clubs-and-organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.places.find( {"address.town_sef_url":"rochester-nh","tags":"clubs-and-organizations"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	15	3
3	db.events_cache.find( {"_id":"ec9abe7a2e7139ddb65dd4ba56e04ddd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
4	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-70.9738998413086,43.30220031738281],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	307
5	db.events_cache.count( {"_id":"ec9abe7a2e7139ddb65dd4ba56e04ddd"} )	0	1
6	db.events_cache.count( {"_id":"ec9abe7a2e7139ddb65dd4ba56e04ddd"} )	0	1
7	db.events_cache.insert( {"_id":"ec9abe7a2e7139ddb65dd4ba56e04ddd","town_sef_url":"rochester-nh","data_key":["693320fd4389be6be5651da6","68a75b5a03a70639b6ceeec9","693320fe4389be6be5652155","68a75b5a03a70639b6cef209","69036ada4389be6be5f5d8eb","693320ff4389be6be56526e7","693320ff4389be6be565274c","68a75b5c03a70639b6cefcc6","68a75b5c03a70639b6ceff89","68a75b5c03a70639b6ceffa9"],"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\":43.30220031738281,\"lng\":-70.9738998413086,\"latlng\":\"43.302200317383,-70.973899841309\",\"city\":\"Rochester\",\"state\":\"NH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.17000000 1765653722)","created":"MongoDate(0.17000000 1765653722)"} , true)	0	2

Rochester

New Hampshire

Rochester Groups and Organizations

4J's Earthworks

Back Hill Beer Co

Burch Farm

Country Brook kennels and Farm

Greater Rochester Chamber Of Commerce

Happy Time Squares Square Dance Club

Happy Time Squares Square Dance Club

Lions Club of Rochester

Rochester Country Club

Rotary Club of Rochester

Strafford County Family Justice Center

Strafford County Family Justice Center

Strafford County YMCA

The Governor's Inn

Unified Industries Ltd.

Local Events

Candlelight Stroll

Performance: Irving Berlin’s White Christmas

Yule be Groovin' with the Rockingham Groove

Performance: Irving Berlin’s White Christmas

Kneebody

Candlelight Stroll

STRAFFORD WIND SYMPHONY - HARMONY OF HOLIDAYS

Performance: Irving Berlin’s White Christmas

New Hampshire Wildcats Hockey vs. Dartmouth Big Green Hockey

Performance: Irving Berlin’s White Christmas

COVID-19 Resources