Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"tariffville-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"0504a621a0245fd7997d48a5009014db"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"372af3df5bafaa0bffee2467ff5e74db"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"tariffville-ct","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.76789855957031,41.90700149536133],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	20
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.76789855957031,41.90700149536133],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	12	26
10	db.events_radius_cache.count( {"_id":"372af3df5bafaa0bffee2467ff5e74db"} )	0	1
11	db.events_radius_cache.count( {"_id":"372af3df5bafaa0bffee2467ff5e74db"} )	0	1
12	db.events_radius_cache.insert( {"_id":"372af3df5bafaa0bffee2467ff5e74db","radius":25,"modified":"MongoDate(0.33800000 1766587894)","created":"MongoDate(0.33800000 1766587894)"} , true)	0	1
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-72.76789855957031,41.90700149536133],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	85
14	db.events_cache.count( {"_id":"0504a621a0245fd7997d48a5009014db"} )	0	1
15	db.events_cache.count( {"_id":"0504a621a0245fd7997d48a5009014db"} )	0	1
16	db.events_cache.insert( {"_id":"0504a621a0245fd7997d48a5009014db","town_sef_url":"tariffville-ct","data_key":["69008b97410059e7d104a40d","69339391de4ae56f5aea2774","692a5912de4ae56f5a9b77d3","69339392de4ae56f5aea2785","68d204a5c3af739f25f51e15","69008b98410059e7d104a40e","68941fc0fb5e4bed1fb94560","69339392de4ae56f5aea27b9","68d204a5c3af739f25f51e3a","691eb3d9de4ae56f5a228ddb","692a5912de4ae56f5a9b7828","69339392de4ae56f5aea2800","68941fc0fb5e4bed1fb94597","69008b98410059e7d104a40f","69339392de4ae56f5aea2832"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Tariffville 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\":41.90700149536133,\"lng\":-72.76789855957031,\"latlng\":\"41.907001495361,-72.76789855957\",\"city\":\"Tariffville\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.44900000 1766587894)","created":"MongoDate(0.44900000 1766587894)"} , true)	0	1
17	db.towns.find( {"sef_url":"tariffville-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
18	db.tokens.find( {"sef_url":{"$in":["usa","ct","hartford-county-ct","tariffville-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2

Tariffville

Connecticut

Tariffville Featured Events

Winterfest and the Tunnel of Lights

Comedy Night at the Hartford Funny Bone with Tony Rock

ROAR! Comedy: New England's Funniest

Comedy Night at the Hartford Funny Bone with Tony Rock

Harlem Globetrotters

Winterfest and the Tunnel of Lights

Springfield Thunderbirds vs. Providence Bruins

Comedy Night at the Hartford Funny Bone with Tony Rock

Harlem Globetrotters

The Breakers – Tom Petty Tribute

ROAR! Comedy: New England's Funniest

Comedy Night at the Hartford Funny Bone with Tony Rock

Springfield Thunderbirds vs. Bridgeport Islanders

Winterfest and the Tunnel of Lights

Comedy Night at the Hartford Funny Bone with Tony Rock

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.

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