Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"great-river-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"great-river-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ny","suffolk-county-ny","great-river-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"0b4998cf048894388fa3561e948775d4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"dd391cccda369b83156272d3049b50ed"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767333600)","$lt":"MongoDate(0.00000000 1767592799)"},"geo":{"$geoWithin":{"$center":[[-73.15630340576172,40.718101501464844],0.21739130434782608]}}}, ["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 )	9	9
7	db.events_cache.count( {"_id":"0b4998cf048894388fa3561e948775d4"} )	0	1
8	db.events_cache.insert( {"_id":"0b4998cf048894388fa3561e948775d4","town_sef_url":"great-river-ny","data_key":["68a75b6e03a70639b6cf6bbd","693321084389be6be56562a6","693321084389be6be56562ee","68a75b6e03a70639b6cf6da9","68a75b6f03a70639b6cf6f23","68a75b6f03a70639b6cf7007","68a75b6f03a70639b6cf7124","68a75b6f03a70639b6cf7258","68a75b6f03a70639b6cf72d4"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"next-weekend\",\"keyword\":\"\",\"radius\":15,\"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 1\\\/2\\\/2026 to 1\\\/4\\\/2026\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2026-01-02\",\"searchenddate\":\"2026-01-04\",\"lat\":40.718101501464844,\"lng\":-73.15630340576172,\"latlng\":\"40.718101501465,-73.156303405762\",\"city\":\"Great River\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.17100000 1766916198)","created":"MongoDate(0.17100000 1766916198)"} , true)	0	2

Great River

New York

Great River Events for 1/2/2026 to 1/4/2026

Harry Connick Jr's The Happy Elf

Dementia Caregiver Support Group

Country Line Dancing

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

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.

Great River Events for 1/2/2026 to 1/4/2026

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.