Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"middletown-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"middletown-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ct","middlesex-county-ct","middletown-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"5ecb54fd5243893f43fe526abc68cb02"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"ac063bc040c63a21738a443a79f94af3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"middletown-ct","start":{"$gte":"MongoDate(0.00000000 1767247200)","$lt":"MongoDate(0.00000000 1767852000)"}} )	5	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.6509017944336,41.547401428222656],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767247200)","$lt":"MongoDate(0.00000000 1768111200)"}} )	7	19
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.6509017944336,41.547401428222656],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767247200)","$lt":"MongoDate(0.00000000 1768111200)"}} )	9	23
10	db.events_radius_cache.count( {"_id":"ac063bc040c63a21738a443a79f94af3"} )	0	1
11	db.events_radius_cache.insert( {"_id":"ac063bc040c63a21738a443a79f94af3","radius":25,"modified":"MongoDate(0.69700000 1767281113)","created":"MongoDate(0.69700000 1767281113)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767247200)"},"geo":{"$geoWithin":{"$center":[[-72.6509017944336,41.547401428222656],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	216
13	db.events_cache.count( {"_id":"5ecb54fd5243893f43fe526abc68cb02"} )	0	1
14	db.events_cache.count( {"_id":"5ecb54fd5243893f43fe526abc68cb02"} )	0	1
15	db.events_cache.insert( {"_id":"5ecb54fd5243893f43fe526abc68cb02","town_sef_url":"middletown-ct","data_key":["69036aeb4389be6be5f63d99","69036aec4389be6be5f63f30","69036aec4389be6be5f63fe6","69036aec4389be6be5f64063","69036aed4389be6be5f6438e","69036aed4389be6be5f6453a","69036aee4389be6be5f64a4d","69036aee4389be6be5f64b1f","69036aee4389be6be5f64c75","69036aee4389be6be5f64da9","69036aee4389be6be5f64e64","69036aef4389be6be5f65047","69036aef4389be6be5f6507f","69036aef4389be6be5f65096","6933210a4389be6be5656f5b"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Middletown 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.547401428222656,\"lng\":-72.6509017944336,\"latlng\":\"41.547401428223,-72.650901794434\",\"city\":\"Middletown\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.96900000 1767281113)","created":"MongoDate(0.96900000 1767281113)"} , true)	0	1

Middletown

Connecticut

Middletown Featured Events

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

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

Hartford Wolfpack vs. Providence Bruins

Quinnipiac Bobcats Mens Ice Hockey vs. Harvard Crimson Hockey

UConn Huskies Womens Basketball vs. Seton Hall Pirates Womens Basketball

Quinnipiac Bobcats Mens Ice Hockey vs. Dartmouth Big Green Hockey

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

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

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

UConn Huskies Womens Basketball vs. St. Johns Red Storm Womens Basketball

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

Kayo Dot

UConn Huskies Hockey vs. UMass Lowell River Hawks Hockey

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

R&B ONLY LIVE - Wallingford, CT

COVID-19 Resources

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.

Middletown Featured Events

COVID-19 Resources

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.