Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"prosser-wa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	17
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"bakersfield-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	20
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.places.find( {"address.town_sef_url":"bakersfield-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	3
7	db.events_cache.find( {"_id":"74837e2a96ba1e20c1c18d6c2d7fdfd2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"46702946cea798df80a530bba0abf7ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-119.01899719238281,35.3734016418457],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	216
10	db.events_cache.count( {"_id":"74837e2a96ba1e20c1c18d6c2d7fdfd2"} )	0	29
11	db.events_cache.count( {"_id":"74837e2a96ba1e20c1c18d6c2d7fdfd2"} )	0	2
12	db.events_cache.insert( {"_id":"74837e2a96ba1e20c1c18d6c2d7fdfd2","town_sef_url":"bakersfield-ca","data_key":["6938d993de4ae56f5aaa953d","68639fe0fb5e4bed1fa5bdc8","68639ff5fb5e4bed1fa5ea4e","6877a5247573f132ba50821c","68834428fb5e4bed1f2254d8","6864f18efb5e4bed1f3a2040","6883442cfb5e4bed1f225e5e","6883442dfb5e4bed1f225f85","68e5cb1fc3af739f25c77f27","6883442ffb5e4bed1f2263d2"],"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\":35.3734016418457,\"lng\":-119.01899719238281,\"latlng\":\"35.373401641846,-119.01899719238\",\"city\":\"Bakersfield\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.59700000 1766418638)","created":"MongoDate(0.59700000 1766418638)"} , true)	0	11
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	13
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
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	4
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9

Bakersfield

California

Bakersfield Groups and Organizations

Bakersfield Christian High School

Bakersfield City School District

Bakersfield City School District

Bakersfield College

Beale Memorial Library

Beardsley School District

Beardsley School District

California Child Search

California State University Bakersfield

Chipman Junior High School

Compton Junior High School

Discover Elementary School

Downtown Elementary School

Edison School District

Edison School District

Eleanor Wilson Branch Library

Fairfax School District

Fairview Elementary School

Fresno Pacific University- Bakersfield Center

Fruitvale School District

Local Events

DIVORCED DAD ROCK NIGHT Holiday Edition

From The Farmhouse Farmers Market

Riverlakes Farmers Market

Shafter Farmers Market

Bakersfield Condors vs. San Diego Gulls

Haggin Oaks Farmers Market

Bakersfield Condors vs. San Jose Barracuda

Bakersfield Condors vs. San Jose Barracuda

Bobby Lee: LIVE

Bakersfield Condors vs. Ontario Reign