Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sharpsburg-oh"}, [] ).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":"auburn-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
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":"auburn-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	9	3
7	db.events_cache.find( {"_id":"0414e45eec2f0f18a8681260d94dd13e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"a960067aa5216d90ad7717f165277b73"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-121.07599639892578,38.893001556396484],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	143
10	db.events_cache.count( {"_id":"0414e45eec2f0f18a8681260d94dd13e"} )	0	1
11	db.events_cache.count( {"_id":"0414e45eec2f0f18a8681260d94dd13e"} )	0	1
12	db.events_cache.insert( {"_id":"0414e45eec2f0f18a8681260d94dd13e","town_sef_url":"auburn-ca","data_key":["6924bb2ede4ae56f5a6af26b","68551f40fb5e4bed1fd105da","68c0e124c3af739f253dc14e","69403d71de4ae56f5a6f2adf","685670d0fb5e4bed1f3b1be1","685670d0fb5e4bed1f3b1c36","6857c258fb5e4bed1f86f6fc","6857c25dfb5e4bed1f87004a","685913a8fb5e4bed1fd99b65","6901b2dbc3af739f25187eb9"],"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\":38.893001556396484,\"lng\":-121.07599639892578,\"latlng\":\"38.893001556396,-121.07599639893\",\"city\":\"Auburn\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.94000000 1765864099)","created":"MongoDate(0.94000000 1765864099)"} , 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	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

Auburn

California

Auburn Groups and Organizations

Auburn Library

California Child Search

Joseph Parish School

Maidu High School

Parkside Church

Pine Hills Adventist School

Placer High School

Placer School for Adults

Placer Union High School District

Local Events

Character Development Play Theory Workshop

Roseville Fountains Farmers' Market

Cirque Musica

Capital Storytelling with John Aubert- Intro to True, Personal Storytelling. 12/16 6pm

Palladio Folsom Farmers Market

Kaiser Riverside Farmers Market

Kaiser Eureka Farmers Market

Rock Monsterz: 80's Rock Tribute

Denio's Farmers Market

Parabellum, Aether Element and more