Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gilford-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"gilford-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","nh","belknap-county-nh","gilford-nh"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"gilford-nh"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"1910200981e652203a83c746a0e4657c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"9d1a7be792831ff7c147d94fd0c49f88"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"gilford-nh","start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767592800)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.40750122070312,43.548301696777344],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	0	20
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.40750122070312,43.548301696777344],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	0	20
11	db.events_radius_cache.count( {"_id":"9d1a7be792831ff7c147d94fd0c49f88"} )	0	1
12	db.events_radius_cache.insert( {"_id":"9d1a7be792831ff7c147d94fd0c49f88","radius":25,"modified":"MongoDate(0.03900000 1767050084)","created":"MongoDate(0.03900000 1767050084)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766988000)"},"geo":{"$geoWithin":{"$center":[[-71.40750122070312,43.548301696777344],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 )	5	180
14	db.events_cache.count( {"_id":"1910200981e652203a83c746a0e4657c"} )	0	1
15	db.events_cache.count( {"_id":"1910200981e652203a83c746a0e4657c"} )	0	1
16	db.events_cache.insert( {"_id":"1910200981e652203a83c746a0e4657c","town_sef_url":"gilford-nh","data_key":["68a75b7003a70639b6cf7a1f","68a75b7503a70639b6cf9cb3","69036b054389be6be5f6f52c","6933211a4389be6be565f22b","693321324389be6be5669e26"],"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.548301696777344,\"lng\":-71.40750122070312,\"latlng\":\"43.548301696777,-71.407501220703\",\"city\":\"Gilford\",\"state\":\"NH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.25300000 1767050084)","created":"MongoDate(0.25300000 1767050084)"} , true)	0	2

Gilford

New Hampshire

Gilford Groups and Organizations

Bank of New Hampshire Pavilion

Beans & Greens Harvest Festival

Beans And Greens Farm

Big Banana CSA

Bolduc Park Golf and XC Ski Park

Friends of the Gilford Public Library

Gilford Community Church

Gilford Elementary School

Gilford Farmers' Market

Gilford Health Department

Gilford High School

Gilford Middle School

Gilford Police Department

Gilford Public Library

Gilford School District

Gilford Youth Center

Granite State Music Festival

Gunstock 4th of July Weekend Craft Fair

Gunstock Labor Day Weekend Craft Fair

Gunstock Mountain Resort

Local Events

MANIA: The ABBA Tribute

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

Joshua Tree

Robert Cray Band

Dar Williams and Spencer LaJoye

COVID-19 Resources