Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"swarthmore-pa"}, [] ).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":"waterbury-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":"waterbury-ct","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	8	2
7	db.events_cache.find( {"_id":"49414a4899e28e1e8f06a7b32eb678cd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"0130a086c3b21b6c5c0bb0775b567883"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-73.04080200195312,41.55590057373047],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( 11 ).skip( 0 )	11	177
10	db.events_cache.count( {"_id":"49414a4899e28e1e8f06a7b32eb678cd"} )	0	1
11	db.events_cache.count( {"_id":"49414a4899e28e1e8f06a7b32eb678cd"} )	0	1
12	db.events_cache.insert( {"_id":"49414a4899e28e1e8f06a7b32eb678cd","town_sef_url":"waterbury-ct","data_key":["6905a759de4ae56f5a2c1e1b","68957149fb5e4bed1fd77001","68963d06fb5e4bed1f99b4ab","6933cbd7de4ae56f5a4a6767","6905a759de4ae56f5a2c1e64","68ba49a9c3af739f257d81b4","689c08bdfb5e4bed1f1f9403","69366ed4de4ae56f5a910188","69374fd1de4ae56f5a680ae8","68ba49a9c3af739f257d8343"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"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.55590057373047,\"lng\":-73.04080200195312,\"latlng\":\"41.55590057373,-73.040802001953\",\"city\":\"Waterbury\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.05300000 1766452824)","created":"MongoDate(0.05300000 1766452824)"} , 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	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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

Waterbury

Connecticut

Waterbury Groups and Organizations

Holy Cross High School

Ivy Bridge Group

Literacy Volunteers of Greater Waterbury, Inc.

Naugatuck Valley Community College

Post University

Post University Online

Silas Bronson Library

Waterbury Public Schools

Local Events

Bingo Loco

The Disco Biscuits

The Disco Biscuits

Spring Heeled Jack

Bingo Loco

Quinnipiac Bobcats Mens Ice Hockey vs. Concordia Stingers Mens Hockey

John Oliver Live

New Year's Eve: Cartagena Party at Barracuda Bistro and Bar

New Year's Eve: Cartagena Party at Barracuda Bistro & Bar

Quinnipiac Bobcats Mens Ice Hockey vs. Harvard Crimson Hockey