Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"deferiet-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/the-wizard-of-oz-at-sphere-3-2025-12-21-tm-las-vegas-nv.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"deferiet-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","jefferson-county-ny","deferiet-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"b9bfb42c4535430d23ca6deb9953d1e8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"6d5a23510d39f80b2fdda335c553df92"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"deferiet-ny","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.68340301513672,44.03260040283203],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	26
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.68340301513672,44.03260040283203],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	27
10	db.events_radius_cache.count( {"_id":"6d5a23510d39f80b2fdda335c553df92"} )	0	1
11	db.events_radius_cache.insert( {"_id":"6d5a23510d39f80b2fdda335c553df92","radius":25,"modified":"MongoDate(0.54800000 1766356288)","created":"MongoDate(0.54800000 1766356288)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-75.68340301513672,44.03260040283203],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	211
13	db.events_cache.count( {"_id":"b9bfb42c4535430d23ca6deb9953d1e8"} )	0	1
14	db.events_cache.count( {"_id":"b9bfb42c4535430d23ca6deb9953d1e8"} )	0	1
15	db.events_cache.insert( {"_id":"b9bfb42c4535430d23ca6deb9953d1e8","town_sef_url":"deferiet-ny","data_key":["693321054389be6be5654e93","693321064389be6be565528c","693321094389be6be5656379","693321094389be6be565665c","6933210d4389be6be5658529","6933210f4389be6be56598f7","693321114389be6be565a593","693321114389be6be565ab99","693321184389be6be565de82","693321184389be6be565e33a","6933211c4389be6be5660765","6933211c4389be6be5660c97","6933211e4389be6be5661ba1","6933211e4389be6be566200f","6933211f4389be6be56623f6"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Deferiet Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"the-wizard-of-oz-at-sphere-3-2025-12-21-tm-las-vegas-nv.html\",\"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\":44.03260040283203,\"lng\":-75.68340301513672,\"latlng\":\"44.032600402832,-75.683403015137\",\"city\":\"Deferiet\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.77900000 1766356288)","created":"MongoDate(0.77900000 1766356288)"} , true)	0	1

Deferiet

New York

Deferiet Featured Events

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Danbury Hat Tricks

Watertown Wolves vs. Port Huron Prowlers

Watertown Wolves vs. Port Huron Prowlers

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Danbury Hat Tricks

Watertown Wolves vs. Port Huron Prowlers

Watertown Wolves vs. Port Huron Prowlers

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.

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