Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"brookfield-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/sports-and-recreation"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"brookfield-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ct","fairfield-county-ct","brookfield-ct"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"fd5bdd163bba9e9ed9ab4dd4ae171506"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765519200)"},"tags":"sports-and-recreation","geo":{"$geoWithin":{"$center":[[-73.40959930419922,41.482398986816406],0.14492753623188406]}}}, ["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	7
7	db.events_cache.count( {"_id":"fd5bdd163bba9e9ed9ab4dd4ae171506"} )	0	1
8	db.events_cache.insert( {"_id":"fd5bdd163bba9e9ed9ab4dd4ae171506","town_sef_url":"brookfield-ct","data_key":["68a75b5703a70639b6cee33d","68a75b6903a70639b6cf4761","68a75b6b03a70639b6cf53e1","68a75b7003a70639b6cf7cf3","68a75b7103a70639b6cf802e","68a75b7503a70639b6cf9cc8","68a75b7903a70639b6cfc0a1","68a75b7a03a70639b6cfc36f","68a75b7b03a70639b6cfce1c","68a75b7b03a70639b6cfd11b","69036b0c4389be6be5f71edd","69036b114389be6be5f745b5","69036b124389be6be5f749f7","69036b174389be6be5f76e36","69036b204389be6be5f7ada4"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Brookfield Featured Events<br>Sports And Recreation\",\"keyword\":\"\",\"radius\":10,\"limit\":15,\"page\":1,\"sef\":\"sports-and-recreation\",\"tags\":\"sports-and-recreation\",\"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\":41.482398986816406,\"lng\":-73.40959930419922,\"latlng\":\"41.482398986816,-73.409599304199\",\"city\":\"Brookfield\",\"state\":\"CT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.47400000 1765528859)","created":"MongoDate(0.47400000 1765528859)"} , true)	0	2

Brookfield

Connecticut

Brookfield Featured Events
Sports And Recreation

Danbury Hat Tricks vs. Binghamton Black Bears

Danbury Hat Tricks vs. Port Huron Prowlers

Danbury Hat Tricks vs. Port Huron Prowlers

Danbury Hat Tricks vs. Watertown Wolves

Danbury Hat Tricks vs. Watertown Wolves

Danbury Hat Tricks vs. Watertown Wolves

Danbury Hat Tricks vs. Watertown Wolves

Danbury Hat Tricks vs. Watertown Wolves

Danbury Hat Tricks vs. Indiana Sentinels

Danbury Hat Tricks vs. Indiana Sentinels

Danbury Hat Tricks vs. Binghamton Black Bears

Danbury Hat Tricks vs. Blue Ridge Bobcats

Danbury Hat Tricks vs. Blue Ridge Bobcats

Danbury Hat Tricks vs. Binghamton Black Bears

Danbury Hat Tricks vs. Binghamton Black Bears

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.

Brookfield Featured EventsSports And Recreation

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.

Brookfield Featured Events
Sports And Recreation

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