Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"chrisney-in"}, [] ).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":"pleasanton-ca"}, [] ).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":"pleasanton-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	2
7	db.events_cache.find( {"_id":"a5b9eff60a07850289958ff9b45afc54"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"f2626cfba8596afc038e6af85f5e38ac"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-121.89700317382812,37.67599868774414],0.21739130434782608]}}}, ["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	232
10	db.events_cache.count( {"_id":"a5b9eff60a07850289958ff9b45afc54"} )	0	1
11	db.events_cache.count( {"_id":"a5b9eff60a07850289958ff9b45afc54"} )	0	1
12	db.events_cache.insert( {"_id":"a5b9eff60a07850289958ff9b45afc54","town_sef_url":"pleasanton-ca","data_key":["691e6a05de4ae56f5a54bd8b","68e07a95c3af739f253d93a8","69161081de4ae56f5a997bca","69161081de4ae56f5a997bce","69161081de4ae56f5a997bfa","69161081de4ae56f5a997bfe","68639ff2fb5e4bed1fa5e3f0","68639ff2fb5e4bed1fa5e4ba","68639ff2fb5e4bed1fa5e51b","68639ff2fb5e4bed1fa5e57b"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"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\":37.67599868774414,\"lng\":-121.89700317382812,\"latlng\":\"37.675998687744,-121.89700317383\",\"city\":\"Pleasanton\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.54800000 1766415983)","created":"MongoDate(0.54800000 1766415983)"} , 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	4
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	5

Pleasanton

California

Pleasanton Groups and Organizations

Alisal Elementary School

Donlon Elementary School

Fairlands Elementary School

Foothill High School

Hearst Elementary School

Henry P. Mohr Elementary School

Lydikson Elementary School

Pleasanton Middle School

Pleasanton Public Library

Pleasanton Unified School District

Thomas Hart Middle School

Valley View Elementary School

Village High School

Walnut Grove Elementary School

Local Events

Gingerbread House Decorating at McGrail

Tuesdays on the Terrace at McGrail

"Our Members" Art Show

"Our Members" Art Show

"Our Members" Art Show

"Our Members" Art Show

Castro Valley Farmers' Market

Danville Farmers Market

Hayward Farmers Market

Niles Freemont Farmers' Market