Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"fairfield-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.towns.find( {"sef_url":"fairfield-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ca","solano-county-ca","fairfield-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"a20c25df46b54285845f266764d24fb2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"bdfea6ce4fed4ce37ce69a3c86215212"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"fairfield-ca","start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767506400)"}} )	1	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-122.03399658203125,38.27320098876953],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	1	16
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-122.03399658203125,38.27320098876953],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	3	19
10	db.events_radius_cache.count( {"_id":"bdfea6ce4fed4ce37ce69a3c86215212"} )	0	1
11	db.events_radius_cache.insert( {"_id":"bdfea6ce4fed4ce37ce69a3c86215212","radius":25,"modified":"MongoDate(0.24000000 1766938676)","created":"MongoDate(0.24000000 1766938676)"} , true)	0	1
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766901600)"},"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( 16 ).skip( 0 )	16	202
13	db.events_cache.count( {"_id":"a20c25df46b54285845f266764d24fb2"} )	0	1
14	db.events_cache.count( {"_id":"a20c25df46b54285845f266764d24fb2"} )	0	1
15	db.events_cache.insert( {"_id":"a20c25df46b54285845f266764d24fb2","town_sef_url":"fairfield-ca","data_key":["68a75b6b03a70639b6cf57d8","69036ae94389be6be5f62d3d","69036ae94389be6be5f62efd","693321074389be6be56558ac","693321074389be6be5655976","68a75b6d03a70639b6cf6028","68a75b6d03a70639b6cf6094","68a75b6d03a70639b6cf60ae","693321074389be6be5655a95","693321074389be6be5655be1","693321084389be6be5655d3b","693321084389be6be5655dd5","69036aeb4389be6be5f63d56","68a75b6f03a70639b6cf7445","68a75b7003a70639b6cf7505"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Fairfield Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"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\":\"\",\"empty-message\":\"\",\"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.47600000 1766938676)","created":"MongoDate(0.47600000 1766938676)"} , true)	0	1

Fairfield

California

Fairfield Featured Events

Martinez Farmers' Market

Anuhea

Anuhea

Brian Culbertson's New Year's Celebration

Brian Culbertson's New Year's Celebration

Napa Farmers Market

Kaiser Vacaville Farmers Market

Concord Farmers Market

Brian Culbertson's New Year's Celebration

Brian Culbertson's New Year's Celebration

Free Uber, Lyft, and Cab Rides by Wells Call Injury Lawyers

Brian Culbertson's New Year's Celebration

Brian Culbertson's New Year's Celebration

Seeds I class: Winter - Disney's Frozen Kids

Kaiser Vacaville Farmers Market

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Fairfield Featured Events

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.