Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"farlington-ks"}, [] ).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":"auburn-wa"}, [] ).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":"auburn-wa","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
7	db.events_cache.find( {"_id":"310a4498e8d5b7b28f6f6129d138c87e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
8	db.events_radius_cache.find( {"_id":"cbd72d7d430725e184ef33069c808422"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766037600)"},"geo":{"$geoWithin":{"$center":[[-122.22899627685547,47.30739974975586],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	49
10	db.events_cache.count( {"_id":"310a4498e8d5b7b28f6f6129d138c87e"} )	0	8
11	db.events_cache.count( {"_id":"310a4498e8d5b7b28f6f6129d138c87e"} )	0	11
12	db.events_cache.insert( {"_id":"310a4498e8d5b7b28f6f6129d138c87e","town_sef_url":"auburn-wa","data_key":["691c7616ec25c3702a0045bf","691bb5e4de4ae56f5a3c10a7","6857c255fb5e4bed1f86f36f","68bd24e5c3af739f25f54889","6864f181fb5e4bed1f3a0779","6864f182fb5e4bed1f3a0846","68a14ec4fb5e4bed1fa18582","6857c25ffb5e4bed1f8704a4","6902cc1a3394d74e7810b6be","6906f8d7de4ae56f5a3772da"],"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\":47.30739974975586,\"lng\":-122.22899627685547,\"latlng\":\"47.307399749756,-122.22899627686\",\"city\":\"Auburn\",\"state\":\"WA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.81400000 1766120676)","created":"MongoDate(0.81400000 1766120676)"} , true)	0	5
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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

Auburn

Washington

Auburn Groups and Organizations

Auburn High School

Auburn Library

Auburn Mountain View High School

Auburn Riverside High School

Auburn School District

Camellot Elementary School

Cascade Middle School

Chinook Elementary School

Dick Scobee Elementary School

Evergreen Heights Elementary School

Green River College

Hazelwood Elementary School

Ilalko Elementary School

Kilo Middle School

Lake Duloff Elementary School

Lake View Elementary School

Lakeland Elementary School

Lakeland Hills Elementary School

Meredith Hill Elementary School

Mt.Baker Middle School

Local Events

Seattle Christmas Market

Santa Photos at Kent Station Santa House

Los Angeles Rams v Seattle Seahawks

Dusty 45s

Billy Wayne Davis, Monica Nevi , Phil Burton

Billy Wayne Davis, Monica Nevi, Phil Burton

YOB (21 and Over)

Disney Presents The Lion King (Touring)

Handels Messiah w/ Seattle Symphony

Seattle Symphony