Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"firth-ne"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.counties.find( {"sef_url":"middlesex-county-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.counties.find( {"sef_url":"middlesex-county-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
6	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
7	db.events_cache.find( {"_id":"d333268799125aec170d3b8ce7be0f24"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"b46d6b23e0a529da2c95ae2d08b420dd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
9	db.events.count( {"address.town_sef_url":"middlesex-county-ct","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	1
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.5416030883789,41.4556999206543],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	12	42
11	db.events.count( {"geo":{"$geoWithin":{"$center":[[-72.5416030883789,41.4556999206543],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	26	38
12	db.events_radius_cache.count( {"_id":"b46d6b23e0a529da2c95ae2d08b420dd"} )	0	1
13	db.events_radius_cache.count( {"_id":"b46d6b23e0a529da2c95ae2d08b420dd"} )	0	1
14	db.events_radius_cache.insert( {"_id":"b46d6b23e0a529da2c95ae2d08b420dd","radius":15,"modified":"MongoDate(0.56500000 1765789779)","created":"MongoDate(0.56500000 1765789779)"} , true)	0	1
15	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-72.5416030883789,41.4556999206543],0.21739130434782608]}}}, ["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	377
16	db.events_cache.count( {"_id":"d333268799125aec170d3b8ce7be0f24"} )	0	11
17	db.events_cache.count( {"_id":"d333268799125aec170d3b8ce7be0f24"} )	0	10
18	db.events_cache.insert( {"_id":"d333268799125aec170d3b8ce7be0f24","town_sef_url":"middlesex-county-ct","data_key":["68fa2c51c3af739f251679ba","68fa2c51c3af739f251679f9","68fa2c51c3af739f25167a03","68efdd4b3af6aa547c08394d","68efdcc86be57e660e0f24a4","68fa2c51c3af739f25167a1d","68efddbdcbafdd55bb06c2d1","68efdcc86be57e660e0f24a5","68fa2c51c3af739f25167a60","6914954be57c2af57402c5d9","6900870e52e740588700439b","68efdc57cbafdd55bb06c2cd","6914954be57c2af57402c5da","6900870bbe1965690609e553","68efdc6a695f30aa8809bbbd"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Middlesex County Featured Events\",\"keyword\":\"\",\"radius\":15,\"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.4556999206543,\"lng\":-72.5416030883789,\"latlng\":\"41.455699920654,-72.541603088379\",\"city\":\"Middlesex County\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.10500000 1765789780)","created":"MongoDate(0.10500000 1765789780)"} , true)	0	1
19	db.towns.find( {"sef_url":"middlesex-county-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	10
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
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	2
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

Middlesex County

Connecticut

Middlesex County Featured Events

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

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

Irving Berlin's White Christmas

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

Winter Festival Holiday Market

North Pole Express

Irving Berlin's White Christmas

Winter Festival Holiday Market

North Pole Express

Irving Berlin's White Christmas

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.

Middlesex County 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.