Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"esperance-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"esperance-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","ny","montgomery-county-ny","esperance-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"dde7f3f275f2a50ac33d3d2ebb22b7c4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"142d44667e9072d43c6f5e34f04b93a4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.count( {"address.town_sef_url":"esperance-ny","start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768111200)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.25650024414062,42.760799407958984],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768370400)"}} )	0	24
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.25650024414062,42.760799407958984],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768370400)"}} )	0	12
9	db.events_radius_cache.count( {"_id":"142d44667e9072d43c6f5e34f04b93a4"} )	0	1
10	db.events_radius_cache.insert( {"_id":"142d44667e9072d43c6f5e34f04b93a4","radius":25,"modified":"MongoDate(0.71200000 1767585787)","created":"MongoDate(0.71200000 1767585787)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767506400)"},"geo":{"$geoWithin":{"$center":[[-74.25650024414062,42.760799407958984],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	10
12	db.events_cache.count( {"_id":"dde7f3f275f2a50ac33d3d2ebb22b7c4"} )	0	1
13	db.events_cache.count( {"_id":"dde7f3f275f2a50ac33d3d2ebb22b7c4"} )	0	2
14	db.events_cache.insert( {"_id":"dde7f3f275f2a50ac33d3d2ebb22b7c4","town_sef_url":"esperance-ny","data_key":["693321094389be6be5656b2a","6933210a4389be6be5656c85","6933210a4389be6be5656d37","6933210a4389be6be5656e11","6933210b4389be6be565716a","6933210b4389be6be565736c","6933210b4389be6be565764b","6933210b4389be6be565781d","69036af94389be6be5f69dfc","693321114389be6be565a73c","693321154389be6be565c7b1","69036aff4389be6be5f6ccca","69036b0d4389be6be5f72b01","6933211c4389be6be5660cf1","69036b134389be6be5f7563f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Esperance 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\":42.760799407958984,\"lng\":-74.25650024414062,\"latlng\":\"42.760799407959,-74.256500244141\",\"city\":\"Esperance\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.74400000 1767585787)","created":"MongoDate(0.74400000 1767585787)"} , true)	0	1

Esperance

New York

Esperance Featured Events

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Get the Led Out

Disciple of The Garden - Tribute to Soundgarden, Audioslave & Chris Cornell

Lakeview

Dancing with the Stars: Live! - 2026 Tour

Brit Floyd

Maddox Batson

Rainbow Kitten Surprise and Common People

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.

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