Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"tuleta-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"fairfield-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":"fairfield-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	3
7	db.events_cache.find( {"_id":"4dc0dfeddacb022ea1e78b353fd473e0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"bdfea6ce4fed4ce37ce69a3c86215212"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-122.03399658203125,38.27320098876953],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	199
10	db.events_cache.count( {"_id":"4dc0dfeddacb022ea1e78b353fd473e0"} )	0	1
11	db.events_cache.count( {"_id":"4dc0dfeddacb022ea1e78b353fd473e0"} )	0	1
12	db.events_cache.insert( {"_id":"4dc0dfeddacb022ea1e78b353fd473e0","town_sef_url":"fairfield-ca","data_key":["685a6597fb5e4bed1f6567db","685a65a8fb5e4bed1f65878c","685a65a8fb5e4bed1f6587a9","68b7a6aac3af739f2571ec4d","68b7a6aac3af739f2571ecf0","685bb764fb5e4bed1fb6b979","69277dd2de4ae56f5af6870d","69324210de4ae56f5af02bcc","685e5a11fb5e4bed1f621384","685f73987573f1be27015525"],"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.27320098876953,\"lng\":-122.03399658203125,\"latlng\":\"38.27320098877,-122.03399658203\",\"city\":\"Fairfield\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.63900000 1766261164)","created":"MongoDate(0.63900000 1766261164)"} , 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	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

Fairfield

California

Fairfield Groups and Organizations

Amy Blanc Site

Anna Kyle Elementary School

Armijo High School

B. Gale Wilson School

Center Elementary School

Fairfield Civic Center Library

Fairfield-Suisun Unified School District

Golden West Middle School

Grange Middle School

Holy Spirit School

K.I. Jones Elementary School

Laurel Creek School

Mundy Elementary School

Oakbrook Elementary School

Solano Community College

Solano County Office Of Education

Suisun Elementary School

Sullivan Middle School

Tolenas Elementary School

Travis Unified School District

Local Events

Napa Farmers Market

Vacaville Farmers Market

Vallejo Farmers' Market

Greg Adams and East Bay Soul Sweet Soul Christmas

Greg Adams and East Bay Soul Sweet Soul Christmas

Martinez Farmers' Market

Christmas Mixer for Single Professionals, 40+

Last Hive w Royal Jelly Jive at Blue Note Napa

Napa Farmers Market

Kaiser Vacaville Farmers Market