Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"fort-campbell-ky"}, [] ).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.towns.find( {"sef_url":"east-hampton-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"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	1
6	db.places.find( {"address.town_sef_url":"east-hampton-ct","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	2
7	db.events_cache.find( {"_id":"ae1fd10936336dafae2760d7af168fdf"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"b60236d69ce66d525884c1253ce7c74a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-72.489501953125,41.56769943237305],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( 11 ).skip( 0 )	11	669
10	db.events_cache.count( {"_id":"ae1fd10936336dafae2760d7af168fdf"} )	0	21
11	db.events_cache.count( {"_id":"ae1fd10936336dafae2760d7af168fdf"} )	0	15
12	db.events_cache.insert( {"_id":"ae1fd10936336dafae2760d7af168fdf","town_sef_url":"east-hampton-ct","data_key":["68fa2c52c3af739f25167b2c","68fa2c52c3af739f25167b32","68efdde669adceb60507b889","68efdce7d749a9cd1b06ef17","68fa2c52c3af739f25167b82","68efdd4b3af6aa547c08394f","68fa2c52c3af739f25167b8b","68fa2c52c3af739f25167b91","68efdde669adceb60507b88a","69339391de4ae56f5aea2774"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":41.56769943237305,\"lng\":-72.489501953125,\"latlng\":\"41.567699432373,-72.489501953125\",\"city\":\"East Hampton\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.01600000 1766436183)","created":"MongoDate(0.01600000 1766436183)"} , true)	0	2
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

East Hampton

Connecticut

East Hampton Groups and Organizations

East Hampton Center School

East Hampton High School

East Hampton Middle School

East Hampton Public Library

East Hampton Public Schools

Memorial Elementary School

Local Events

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

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