Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"saint-marys-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	28
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	60
3	db.towns.find( {"sef_url":"erving-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	18
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	35
6	db.events_cache.find( {"_id":"d5fd4e0fb7a6c5ab42c708c860ea990c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	56
7	db.events_radius_cache.find( {"_id":"ae7a4c5f52e5b10a2a481f53e242495d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	11
8	db.events.count( {"address.town_sef_url":"erving-ma","start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.39820098876953,42.599700927734375],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	114
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.39820098876953,42.599700927734375],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	4	73
11	db.events_radius_cache.count( {"_id":"ae7a4c5f52e5b10a2a481f53e242495d"} )	0	4
12	db.events_radius_cache.count( {"_id":"ae7a4c5f52e5b10a2a481f53e242495d"} )	0	8
13	db.events_radius_cache.insert( {"_id":"ae7a4c5f52e5b10a2a481f53e242495d","radius":25,"modified":"MongoDate(0.38700000 1766181451)","created":"MongoDate(0.38700000 1766181451)"} , true)	0	11
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"geo":{"$geoWithin":{"$center":[[-72.39820098876953,42.599700927734375],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	271
15	db.events_cache.count( {"_id":"d5fd4e0fb7a6c5ab42c708c860ea990c"} )	0	1
16	db.events_cache.count( {"_id":"d5fd4e0fb7a6c5ab42c708c860ea990c"} )	0	1
17	db.events_cache.insert( {"_id":"d5fd4e0fb7a6c5ab42c708c860ea990c","town_sef_url":"erving-ma","data_key":["68f39ce4410059e7d104a3b4","6893ae7dfb5e4bed1f5418a2","6871e66d7573f16cf8571ef1","68f39d468248d952cc0d23a6","6871e66d7573f16cf8571ef2","68f39d6f8675dc66050517d5","6893ae7dfb5e4bed1f541a22","6871e66d7573f16cf8571ef3","68fd4cfccf29e58a420c4d02","6871e66e7573f16cf8571ef4","690d9057de4ae56f5a18df34","6893ae7dfb5e4bed1f541b4c","689ab73ffb5e4bed1fded84e","6893ae7dfb5e4bed1f541bdd","6933cbd8de4ae56f5a4a709b"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Erving Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"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\":42.599700927734375,\"lng\":-72.39820098876953,\"latlng\":\"42.599700927734,-72.39820098877\",\"city\":\"Erving\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.74300000 1766181451)","created":"MongoDate(0.74300000 1766181451)"} , true)	0	1
18	db.towns.find( {"sef_url":"erving-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","ma","franklin-county-ma","erving-ma"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Erving

Massachusetts

Erving Featured Events

The Nutcracker

Brattleboro Winter Farmers' Market

Transcendent Ink - The Nature Of Queer Belonging

The Nutcracker

Transcendent Ink - The Nature Of Queer Belonging

The Nutcracker

Brattleboro Winter Farmers' Market

Transcendent Ink - The Nature Of Queer Belonging

Wine Tasting in the Market

Transcendent Ink - The Nature Of Queer Belonging

Mind Left Body and The Giant’s Harp

Brattleboro Winter Farmers' Market

UMass Minutemen Hockey vs. Boston University Terriers Mens Ice Hockey

Brattleboro Winter Farmers' Market

Eggy

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.

Erving Featured Events

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.