Nr	Query	Num. rows	Took (ms)
1	db.places.find( {"address.town_sef_url":"pittsfield-nh"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	13	7
2	db.events_cache.find( {"_id":"e83649d05a0e805e5ec07dbbeae4d657"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
3	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767247200)"},"geo":{"$geoWithin":{"$center":[[-71.33090209960938,43.305301666259766],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	233
4	db.events_cache.count( {"_id":"e83649d05a0e805e5ec07dbbeae4d657"} )	0	1
5	db.events_cache.count( {"_id":"e83649d05a0e805e5ec07dbbeae4d657"} )	0	1
6	db.events_cache.insert( {"_id":"e83649d05a0e805e5ec07dbbeae4d657","town_sef_url":"pittsfield-nh","data_key":["68a75b7003a70639b6cf7a1f","68a75b7503a70639b6cf9cc2","68a75b7503a70639b6cf9cb3","6933210f4389be6be5659863","69036af84389be6be5f699f8","693321144389be6be565c499","69036b054389be6be5f6f504","69036b064389be6be5f6fc16","693321184389be6be565e212","69036b064389be6be5f70086"],"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\":43.305301666259766,\"lng\":-71.33090209960938,\"latlng\":\"43.30530166626,-71.330902099609\",\"city\":\"Pittsfield\",\"state\":\"NH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.23500000 1767298517)","created":"MongoDate(0.23500000 1767298517)"} , true)	0	2

Pittsfield

New Hampshire

Pittsfield Groups and Organizations

Appleview Orchard

Easter Bunny Hop and Craft and Vendor Fair

Frank J Lyman, Public Boat Ramp

Josiah Carpenter Library

Lily Lake (Pond) Public Boat Access

Pittsfield Chamber Of Commerce

Pittsfield Health Department

Pittsfield Middle High School

Pittsfield Rotary Hot Air Balloon Rally

Saint Stephen's Episcopal Church Of Pittsfield

Suncook Valley Rotary Hot Air Balloon Rally

Sunrise Farmers Market

Town Of Pittsfield

Local Events

MANIA: The ABBA Tribute

The Fab Four

The Fab Four: Tribute to the Beatles' "Help!" and the Hits

Hard Target and Shapethrower

Dancing With The Stars: Live! - 2026 Tour

moe.

Who’s Bad – Ultimate Michael Jackson Tribute

Who’s Bad – Ultimate Michael Jackson Tribute

Combat Zone 91

Who’s Bad – Ultimate Michael Jackson Tribute

COVID-19 Resources