Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"buffalo-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"buffalo-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","buffalo-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"ef3e9dc07aa7b213f37707667ae0926e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-78.87789916992188,42.88690185546875],0.07246376811594203]}}}, ["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	96
7	db.events_cache.count( {"_id":"ef3e9dc07aa7b213f37707667ae0926e"} )	0	1
8	db.events_cache.insert( {"_id":"ef3e9dc07aa7b213f37707667ae0926e","town_sef_url":"buffalo-ny","data_key":["693321004389be6be5652e88","693321014389be6be5653145","68a75b5f03a70639b6cf0df8","69036ade4389be6be5f5f217","693321014389be6be56533ee","693321024389be6be565343e","68a75b6003a70639b6cf13ee","68a75b6003a70639b6cf153a","68a75b6003a70639b6cf150d","69036adf4389be6be5f5f7df","693321024389be6be56537cd","69036adf4389be6be5f5f9e8","68a75b6203a70639b6cf1bd3","68a75b6203a70639b6cf1c14","693321024389be6be5653b83"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Buffalo Featured Events\",\"keyword\":\"\",\"radius\":5,\"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\":42.88690185546875,\"lng\":-78.87789916992188,\"latlng\":\"42.886901855469,-78.877899169922\",\"city\":\"Buffalo\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.47700000 1765846517)","created":"MongoDate(0.47700000 1765846517)"} , true)	0	1

Buffalo

New York

Buffalo Featured Events

Annual Studio Artist Show and Sale

Annual Studio Artist Show and Sale

'Twas the Night Before... by Cirque du Soleil

Holiday Pops

Annual Studio Artist Show and Sale

Bricks and Brews

Buffalo Sabres vs. Philadelphia Flyers

'Twas the Night Before... by Cirque du Soleil

White Christmas

Holiday Pops

Annual Studio Artist Show and Sale

Canisius University Women's Basketball vs Saint Peter's

White Christmas

'Twas the Night Before... by Cirque du Soleil

Shai Hulud

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.