Nr	Query	Num. rows	Took (ms)
1	db.pages.find( {"type":"town","slug":{"$in":["events-next-weekend"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.events_cache.find( {"_id":"ae5fc21c6cf3685e459e1d9e3813d244"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
3	db.events_radius_cache.find( {"_id":"3edc07b718070086a36f26af481a0d6a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766383199)"},"address.town_sef_url":"buffalo-ny"}, ["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	2
5	db.events_cache.count( {"_id":"ae5fc21c6cf3685e459e1d9e3813d244"} )	0	1
6	db.events_cache.insert( {"_id":"ae5fc21c6cf3685e459e1d9e3813d244","town_sef_url":"buffalo-ny","data_key":["69036adf4389be6be5f5f7df","693321024389be6be56537cd","69036adf4389be6be5f5f9e8","68a75b6203a70639b6cf1bd3","68a75b6203a70639b6cf1c14","693321024389be6be5653b83","693321034389be6be5653da5","68a75b6403a70639b6cf284e","68a75b6403a70639b6cf28cd","68a75b6403a70639b6cf295b","68a75b6403a70639b6cf2959","69036ae24389be6be5f60a73","68a75b6403a70639b6cf2ce4","68a75b6403a70639b6cf2d16","68a75b6503a70639b6cf3238"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"next-weekend\",\"keyword\":\"\",\"radius\":0,\"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,\"title\":\"{local_city} Events for 12\\\/19\\\/2025 to 12\\\/21\\\/2025\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2025-12-19\",\"searchenddate\":\"2025-12-21\",\"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.54100000 1765524576)","created":"MongoDate(0.54100000 1765524576)"} , true)	0	2

Buffalo

New York

Buffalo Events for 12/19/2025 to 12/21/2025

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

Annual Studio Artist Show and Sale

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

White Christmas

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

Buffalo Sabres vs. New York Islanders

Holiday Pops

White Christmas

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

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

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 Events for 12/19/2025 to 12/21/2025

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.