Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"zigzag-or"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"meriden-nh"}, [] ).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	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"df357028ea4d96adbe84037cfba857ce"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	4
7	db.events_radius_cache.find( {"_id":"51303e93f53854207a6db7255204e3d2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"meriden-nh","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	0	3
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.25260162353516,43.54389953613281],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	29
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.25260162353516,43.54389953613281],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	3	46
11	db.events_radius_cache.count( {"_id":"51303e93f53854207a6db7255204e3d2"} )	0	14
12	db.events_radius_cache.count( {"_id":"51303e93f53854207a6db7255204e3d2"} )	0	4
13	db.events_radius_cache.insert( {"_id":"51303e93f53854207a6db7255204e3d2","radius":25,"modified":"MongoDate(0.55500000 1765871496)","created":"MongoDate(0.55500000 1765871496)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-72.25260162353516,43.54389953613281],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	255
15	db.events_cache.count( {"_id":"df357028ea4d96adbe84037cfba857ce"} )	0	11
16	db.events_cache.count( {"_id":"df357028ea4d96adbe84037cfba857ce"} )	0	2
17	db.events_cache.insert( {"_id":"df357028ea4d96adbe84037cfba857ce","town_sef_url":"meriden-nh","data_key":["68957149fb5e4bed1fd76d8a","68efffbc69adceb60507b88d","68957149fb5e4bed1fd76e99","68957149fb5e4bed1fd76ea3","68efffbc69adceb60507b88e","68efffbc69adceb60507b88f","68fd3adc34c9e7cdf6042e70","68fd3b32b968d244290c2f07","68e71ca0c3af739f25e5974c","68fd3b79c863fab8a2052f05","68e71ca0c3af739f25e597fc","68e71ca1c3af739f25e59b14","68e71ca1c3af739f25e59cb4","68e71ca1c3af739f25e59d69","68e71ca1c3af739f25e5a17b"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Meriden 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\":43.54389953613281,\"lng\":-72.25260162353516,\"latlng\":\"43.543899536133,-72.252601623535\",\"city\":\"Meriden\",\"state\":\"NH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.96000000 1765871496)","created":"MongoDate(0.96000000 1765871496)"} , true)	0	1
18	db.towns.find( {"sef_url":"meriden-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","nh","sullivan-county-nh","meriden-nh"]}}, [] ).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	2

Meriden

New Hampshire

Meriden Featured Events

Live Music: J Michael Kelley

Winter Celebration on the Farm

Live Music: Sammy B

Live Music - Jim Yeager

Winter Celebration on the Farm

Winter Celebration on the Farm

Peter and Wendy

Peter and Wendy

Dartmouth Big Green Hockey vs. Arizona State Sun Devils Hockey

Peter and Wendy

Dartmouth Big Green Hockey vs. Arizona State Sun Devils Hockey

Dartmouth Big Green Hockey vs. Harvard Crimson Hockey

Dartmouth Big Green Hockey vs. Clarkson Golden Knights Mens Hockey

Dartmouth Big Green Hockey vs. St. Lawrence Saints Hockey

Dartmouth Big Green Hockey vs. Union College Garnet Chargers Hockey

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.

Meriden 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.