Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"endicott-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"endicott-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","broome-county-ny","endicott-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"endicott-ny","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	4	9
6	db.events_cache.find( {"_id":"774241c241e222cb4725ba472aab4700"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"a124e764ca121610e7fdc5a81c31c118"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"endicott-ny","start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.06549835205078,42.09809875488281],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	0	25
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.06549835205078,42.09809875488281],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	2	25
11	db.events_radius_cache.count( {"_id":"a124e764ca121610e7fdc5a81c31c118"} )	0	1
12	db.events_radius_cache.insert( {"_id":"a124e764ca121610e7fdc5a81c31c118","radius":25,"modified":"MongoDate(0.93000000 1766502172)","created":"MongoDate(0.93000000 1766502172)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-76.06549835205078,42.09809875488281],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	264
14	db.events_cache.count( {"_id":"774241c241e222cb4725ba472aab4700"} )	0	1
15	db.events_cache.count( {"_id":"774241c241e222cb4725ba472aab4700"} )	0	2
16	db.events_cache.insert( {"_id":"774241c241e222cb4725ba472aab4700","town_sef_url":"endicott-ny","data_key":["68a75b6a03a70639b6cf4c65","68a75b6e03a70639b6cf676c","68a75b7303a70639b6cf8d4f","68a75b7503a70639b6cf9bc3","68a75b7503a70639b6cfa05d","68a75b7703a70639b6cfadcb","68a75b7703a70639b6cfb23c","69036afa4389be6be5f6ab42","68a75b7903a70639b6cfbfb2","68a75b7a03a70639b6cfc35d"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"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\":42.09809875488281,\"lng\":-76.06549835205078,\"latlng\":\"42.098098754883,-76.065498352051\",\"city\":\"Endicott\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.21700000 1766502173)","created":"MongoDate(0.21700000 1766502173)"} , true)	0	2

Endicott

New York

Endicott Groups and Organizations

George F. Johnson Memorial Library

Maine-Endwell Central School District

Union-Endicott Central School District

Union-Endicott High School Drama Club

Local Events

Broome County Regional Farmers Market

Binghamton Black Bears vs. Watertown Wolves

Binghamton Black Bears vs. Watertown Wolves

Binghamton Black Bears vs. Pee Dee Icecats

Binghamton Black Bears vs. Pee Dee Icecats

Binghamton Black Bears vs. Twin City Thunderbirds

Binghamton Black Bears vs. Twin City Thunderbirds

Josh Johnson: The Flowers Tour

Binghamton Black Bears vs. Indiana Sentinels

Binghamton Black Bears vs. Indiana Sentinels

COVID-19 Resources