Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"vestal-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	15
2	db.towns.find( {"sef_url":"vestal-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ny","broome-county-ny","vestal-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"10ea4ab352c68d1141eb2f0b1e3e6577"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"b48986d3a73e8bfb82bda30635872514"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.count( {"address.town_sef_url":"vestal-ny","start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768456800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.05480194091797,42.085601806640625],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768716000)"}} )	0	23
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.05480194091797,42.085601806640625],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767852000)","$lt":"MongoDate(0.00000000 1768716000)"}} )	1	23
9	db.events_radius_cache.count( {"_id":"b48986d3a73e8bfb82bda30635872514"} )	0	1
10	db.events_radius_cache.insert( {"_id":"b48986d3a73e8bfb82bda30635872514","radius":25,"modified":"MongoDate(0.18300000 1767882909)","created":"MongoDate(0.18300000 1767882909)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767852000)"},"geo":{"$geoWithin":{"$center":[[-76.05480194091797,42.085601806640625],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	5
12	db.events_cache.count( {"_id":"10ea4ab352c68d1141eb2f0b1e3e6577"} )	0	1
13	db.events_cache.count( {"_id":"10ea4ab352c68d1141eb2f0b1e3e6577"} )	0	1
14	db.events_cache.insert( {"_id":"10ea4ab352c68d1141eb2f0b1e3e6577","town_sef_url":"vestal-ny","data_key":["68a75b7303a70639b6cf8d4f","68a75b7503a70639b6cf9bc3","68a75b7503a70639b6cfa05d","68a75b7703a70639b6cfadcb","68a75b7703a70639b6cfb23c","69036afa4389be6be5f6ab42","68a75b7903a70639b6cfbfb2","68a75b7a03a70639b6cfc35d","69036b0d4389be6be5f726bd","69036b144389be6be5f75b1b","69036b154389be6be5f75edf","69036b154389be6be5f762fe","69036b164389be6be5f765a3","69036b1f4389be6be5f7a5bd","69036b214389be6be5f7b504"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Vestal 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.085601806640625,\"lng\":-76.05480194091797,\"latlng\":\"42.085601806641,-76.054801940918\",\"city\":\"Vestal\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.21400000 1767882909)","created":"MongoDate(0.21400000 1767882909)"} , true)	0	2

Vestal

New York

Vestal Featured Events

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

Binghamton Black Bears vs. Danbury Hat Tricks

Riverdance

Riverdance

Riverdance

Binghamton Black Bears vs. Port Huron Prowlers

Binghamton Black Bears vs. Danbury Hat Tricks

Sal Vulcano: Everything's Fine Tour

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.

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