Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"colora-md"}, [] ).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":"ottawa-il"}, [] ).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":"ottawa-il","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	1
7	db.events_cache.find( {"_id":"d2d70c87ea0238909e02a86ec12da08e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	10
8	db.events_radius_cache.find( {"_id":"9d4ac27f0aee0def6b7b5d9ecb197301"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"geo":{"$geoWithin":{"$center":[[-88.84120178222656,41.353599548339844],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 )	0	206
10	db.events_cache.count( {"_id":"d2d70c87ea0238909e02a86ec12da08e"} )	0	1
11	db.events_cache.count( {"_id":"d2d70c87ea0238909e02a86ec12da08e"} )	0	1
12	db.events_cache.insert( {"_id":"d2d70c87ea0238909e02a86ec12da08e","town_sef_url":"ottawa-il","data_key":[],"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.353599548339844,\"lng\":-88.84120178222656,\"latlng\":\"41.35359954834,-88.841201782227\",\"city\":\"Ottawa\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.62900000 1766145348)","created":"MongoDate(0.62900000 1766145348)"} , 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	2
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

Ottawa

Illinois

Ottawa Groups and Organizations

Central Intermediate School

Deer Park School

Deer Park School District

Jefferson Elememtary School

Lincoln Elementary School

Marquette Academy

McKinley Elementary School

Ottawa Elementary School District No.141

Ottawa High School Booster Club

Ottawa Opportunity School

Reddick Public Library District

Shepherd Middle School

St. Patrick School

The Rock Regional Church