Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"elma-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events-this-weekend"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"elma-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","elma-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"ae6a4d395821a923df57c2d902ba6511"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"e2b95b78dc37d150145b4929f3e67125"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766383199)"},"geo":{"$geoWithin":{"$center":[[-78.64029693603516,42.85070037841797],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	22
8	db.events_cache.count( {"_id":"ae6a4d395821a923df57c2d902ba6511"} )	0	11
9	db.events_cache.insert( {"_id":"ae6a4d395821a923df57c2d902ba6511","town_sef_url":"elma-ny","data_key":["69036adf4389be6be5f5f7df","693321024389be6be56537cd","69036adf4389be6be5f5f9e8","68a75b6203a70639b6cf1bd3","68a75b6203a70639b6cf1c14","693321024389be6be5653b83","68a75b6203a70639b6cf1efb","69036ae04389be6be5f60215","693321034389be6be5653da5","69036ae14389be6be5f603a5","68a75b6403a70639b6cf284e","68a75b6403a70639b6cf28cd","68a75b6403a70639b6cf2959","68a75b6403a70639b6cf295b","69036ae24389be6be5f60a73"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"this-weekend\",\"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,\"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.85070037841797,\"lng\":-78.64029693603516,\"latlng\":\"42.850700378418,-78.640296936035\",\"city\":\"Elma\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.14800000 1765857705)","created":"MongoDate(0.14900000 1765857705)"} , true)	0	12

Elma

New York

Elma 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

The North Tonawanda City Market

Believe in Crafts Show and Basket Raffle

Annual Studio Artist Show and Sale

Holiday Magic in the Village!

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

White Christmas

Buffalo Sabres vs. New York Islanders

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

Holiday Pops

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.

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