Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"buffalo-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"buffalo-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","il","sangamon-county-il","buffalo-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"423de50c4556f59f9a546095991dd8ac"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"eace6ac5bcaedefb189d31a45260b079"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"buffalo-il","start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-89.40579986572266,39.85260009765625],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	0	26
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-89.40579986572266,39.85260009765625],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	1	22
9	db.events_radius_cache.count( {"_id":"eace6ac5bcaedefb189d31a45260b079"} )	0	1
10	db.events_radius_cache.insert( {"_id":"eace6ac5bcaedefb189d31a45260b079","radius":25,"modified":"MongoDate(0.52000000 1766530835)","created":"MongoDate(0.52000000 1766530835)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-89.40579986572266,39.85260009765625],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	243
12	db.events_cache.count( {"_id":"423de50c4556f59f9a546095991dd8ac"} )	0	1
13	db.events_cache.count( {"_id":"423de50c4556f59f9a546095991dd8ac"} )	0	1
14	db.events_cache.insert( {"_id":"423de50c4556f59f9a546095991dd8ac","town_sef_url":"buffalo-il","data_key":["68a75b6703a70639b6cf3f6a","68a75b6803a70639b6cf4485","69036aeb4389be6be5f6389b","68a75b6e03a70639b6cf6bb2","69036aec4389be6be5f640ff","69036aed4389be6be5f644ff","68a75b7003a70639b6cf7b3b","68a75b7303a70639b6cf8ca0","69036af24389be6be5f66803","69036af34389be6be5f66d1f","68a75b7503a70639b6cf9add","68a75b7603a70639b6cfa7ac","68a75b7703a70639b6cface7","69036af94389be6be5f69ccb","69036af94389be6be5f6a361"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Buffalo 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\":39.85260009765625,\"lng\":-89.40579986572266,\"latlng\":\"39.852600097656,-89.405799865723\",\"city\":\"Buffalo\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.78600000 1766530835)","created":"MongoDate(0.78600000 1766530835)"} , true)	0	2

Buffalo

Illinois

Buffalo Featured Events

Glucose and Blood Pressure Checks

Bingocize

Lick Creek

Bingocize

Springfield Jr. Blues vs. Fairbanks Ice Dogs

Springfield Jr. Blues vs. Fairbanks Ice Dogs

Bingocize

Bingocize

Springfield Jr. Blues vs. Wisconsin Windigo

Springfield Jr. Blues vs. Wisconsin Windigo

Bingocize

Glucose and Blood Pressure Checks

Bingocize

Springfield Jr. Blues vs. Janesville Jets

Springfield Jr. Blues vs. Janesville Jets

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.

Buffalo 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.