Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"brooks-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"dayton-oh"}, [] ).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":"dayton-oh","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
7	db.events_cache.find( {"_id":"f272a62b10dcd4017c501c29f5a4ec21"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	12
8	db.events_radius_cache.find( {"_id":"165afe235b5627c29b43a537ad339871"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-84.56420135498047,40.01850128173828],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 )	1	306
10	db.events_cache.count( {"_id":"f272a62b10dcd4017c501c29f5a4ec21"} )	0	1
11	db.events_cache.count( {"_id":"f272a62b10dcd4017c501c29f5a4ec21"} )	0	1
12	db.events_cache.insert( {"_id":"f272a62b10dcd4017c501c29f5a4ec21","town_sef_url":"dayton-oh","data_key":["68f6cefbc3af739f255e5cc5"],"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\":40.01850128173828,\"lng\":-84.56420135498047,\"latlng\":\"40.018501281738,-84.56420135498\",\"city\":\"Dayton\",\"state\":\"OH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.64900000 1766033469)","created":"MongoDate(0.64900000 1766033469)"} , true)	0	1
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	11
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

Dayton

Ohio

Dayton Groups and Organizations

American Association of Independent Colleges & Schools ( AAICS )

Archbishop Alter High School Class of 1970 reunion

Belmont Branch Library

Burkhardt Branch Library

Centerville City Schools

Chaminade Julienne Catholic High School

Clark State Community College - Greene Center

Dayton Metro Library

Dayton Metro Library - Main Library

Dayton Public Schools

Dayton View Branch Library

Dominion Academy of Dayton

East Branch Library

International College of Broadcasting

Jefferson Township Local Schools

Kettering College of Medical Arts

Madden Hills Branch Library

Northridge Local Schools

Oakwood City School District

Oakwood City School District

Local Events

Next Generation Leahy