Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rochester-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/yesterday-and-today-2025-12-11-tm-omaha-ne.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.towns.find( {"sef_url":"rochester-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
5	db.tokens.find( {"sef_url":{"$in":["usa","nh","strafford-county-nh","rochester-nh"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"c0bd9d4e3dbdbfce6e4aefea547f10c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	6
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"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( 16 ).skip( 0 )	16	250
8	db.events_cache.count( {"_id":"c0bd9d4e3dbdbfce6e4aefea547f10c8"} )	0	2
9	db.events_cache.insert( {"_id":"c0bd9d4e3dbdbfce6e4aefea547f10c8","town_sef_url":"rochester-nh","data_key":["69036ae54389be6be5f619ef","68a75b6903a70639b6cf467f","68a75b6a03a70639b6cf522a","69036ae84389be6be5f62885","68a75b6b03a70639b6cf5541","69036ae84389be6be5f62b90","68a75b6c03a70639b6cf5b66","693321074389be6be5655700","693321074389be6be56558c3","68a75b6c03a70639b6cf5ed3","693321084389be6be5655e3c","693321084389be6be5655e73","693321084389be6be5656095","68a75b6f03a70639b6cf70e2","68a75b6f03a70639b6cf73bc"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Rochester Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"yesterday-and-today-2025-12-11-tm-omaha-ne.html\",\"tags\":\"\",\"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\":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.68900000 1766511776)","created":"MongoDate(0.68900000 1766511776)"} , true)	0	6

Rochester

New Hampshire

Rochester Featured Events

Warren Wolf's Christmas Vibes

Juston McKinney’s Comedy Year In Review 2025

Juston McKinney’s Comedy Year In Review 2025

Jazz The Halls: ELEW Plays Sting and the Season

Juston McKinney’s Comedy Year In Review 2025

Sunday Jazz Brunch at Jimmy's

Juston McKinney’s Comedy Year In Review 2025

The Mallett Brothers Band (GA)

Local Artist Series: New Legacy Swing Band

Juston McKinney’s Comedy Year In Review 2025

NYE 2025 with BT ALC BIG BAND (Dinner Package)

A New Year's Eve Celebration

NYE 2025 with BT ALC BIG BAND (Countdown Package)

New Hampshire Wildcats Hockey vs. Colgate University Raiders Hockey

New Hampshire Wildcats Hockey vs. Colgate University Raiders Hockey

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.

Rochester Featured Events

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.

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