Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"felda-fl"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.towns.find( {"sef_url":"middlefield-ct"}, [] ).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	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"6b012a9a2bddd6f2e417d2e8146eb6f8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	4
7	db.events_radius_cache.find( {"_id":"7c84fc85f7f53c17f1b0294dccf215ee"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	48
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-72.7123031616211,41.51599884033203],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	220
9	db.events_cache.count( {"_id":"6b012a9a2bddd6f2e417d2e8146eb6f8"} )	0	1
10	db.events_cache.count( {"_id":"6b012a9a2bddd6f2e417d2e8146eb6f8"} )	0	10
11	db.events_cache.insert( {"_id":"6b012a9a2bddd6f2e417d2e8146eb6f8","town_sef_url":"middlefield-ct","data_key":["68fa2c52c3af739f25167b32","68efdde669adceb60507b889","68efdce7d749a9cd1b06ef17","68fa2c52c3af739f25167b82","68efdd4b3af6aa547c08394f","68fa2c52c3af739f25167b8b","68fa2c52c3af739f25167b91","68efdde669adceb60507b88a","69339391de4ae56f5aea2774","68efdc57cbafdd55bb06c2cf","69339392de4ae56f5aea2785","68d204a5c3af739f25f51e15","68efdc6a695f30aa8809bbbe","6905a759de4ae56f5a2c1e1b","69339392de4ae56f5aea27b9"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Middlefield 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.51599884033203,\"lng\":-72.7123031616211,\"latlng\":\"41.515998840332,-72.712303161621\",\"city\":\"Middlefield\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.63500000 1766489303)","created":"MongoDate(0.63500000 1766489303)"} , true)	0	4
12	db.towns.find( {"sef_url":"middlefield-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ct","middlesex-county-ct","middlefield-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Middlefield

Connecticut

Middlefield Featured Events

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Irving Berlin's White Christmas

Irving Berlin's White Christmas

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Irving Berlin's White Christmas

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Chip Rutan: “Space and Time” @ CT State Community College Middlesex

Irving Berlin's White Christmas

Comedy Night at the Hartford Funny Bone with Tony Rock

Irving Berlin's White Christmas

Comedy Night at the Hartford Funny Bone with Tony Rock

Harlem Globetrotters

Irving Berlin's White Christmas

Bingo Loco

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.

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