Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"cold-spring-harbor-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"cold-spring-harbor-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","suffolk-county-ny","cold-spring-harbor-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"cold-spring-harbor-ny"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	3
6	db.events_cache.find( {"_id":"621406592f6aa7e680f4fdf203b964c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"a6d5ce0609d3e7e4d53a909d242f9efd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"cold-spring-harbor-ny","start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.44920349121094,40.86159896850586],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	4	26
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.44920349121094,40.86159896850586],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	12	26
11	db.events_radius_cache.count( {"_id":"a6d5ce0609d3e7e4d53a909d242f9efd"} )	0	1
12	db.events_radius_cache.insert( {"_id":"a6d5ce0609d3e7e4d53a909d242f9efd","radius":25,"modified":"MongoDate(0.45500000 1766500235)","created":"MongoDate(0.45500000 1766500235)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-73.44920349121094,40.86159896850586],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( 11 ).skip( 0 )	11	37
14	db.events_cache.count( {"_id":"621406592f6aa7e680f4fdf203b964c6"} )	0	1
15	db.events_cache.count( {"_id":"621406592f6aa7e680f4fdf203b964c6"} )	0	1
16	db.events_cache.insert( {"_id":"621406592f6aa7e680f4fdf203b964c6","town_sef_url":"cold-spring-harbor-ny","data_key":["68a75b6703a70639b6cf3b65","68a75b6703a70639b6cf3b86","68a75b6703a70639b6cf3c0b","68a75b6703a70639b6cf3c1e","693321054389be6be5654a18","68a75b6703a70639b6cf3d88","68a75b6703a70639b6cf3dc2","693321054389be6be5654ad9","693321054389be6be5654b41","68a75b6803a70639b6cf3fe9"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":40.86159896850586,\"lng\":-73.44920349121094,\"latlng\":\"40.861598968506,-73.449203491211\",\"city\":\"Cold Spring Harbor\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.51700000 1766500235)","created":"MongoDate(0.51700000 1766500235)"} , true)	0	1

Cold Spring Harbor

New York

Cold Spring Harbor Groups and Organizations

Billy Joel Park & Boat Ramp

Cold Spring Harbor Central School District

Cold Spring Harbor Fish Hatchery and Aquarium

Cold Spring Harbor High School

Cold Spring Harbor Laboratory

Cold Spring Harbor Library

Cold Spring Harbor School District

Cold Spring Harbor State Park

Cold Spring Harbor Village Website

Eagle Dock Beach

Kehillath Shalom Synagogue

Kehillath Shalom Synagogue

Kehillath Shalom Synagogue

Kehillath Shalom Synagogue

Patty Schwarz Studio

Saint John's Christmas Fair

Sea Glass Festival

Society for the Preservation of Long Island Antiquities

St. John's Episcopal Church

The Nature Conservancy - Long Island - Uplands Farm Sanctuary - Chapter Office

Local Events

Harry Connick Jr's The Happy Elf

Performance - Frosty’s Big Day

Performance - Frosty’s Big Day

Annie (Touring)

Afternoon Poetry Club: Holiday Poetry

Annie (Touring)

New York Islanders vs. New Jersey Devils

Stella Blue's Band

Sunil Howlader: Vibrant Reflections: The Art of Sunil Howlader at the Geary Gallery in Darien, CT

Harry Connick Jr's The Happy Elf

COVID-19 Resources