Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"dunstable-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
3	db.towns.find( {"sef_url":"endwell-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"d221686f3cc51383734c358b1fb31a90"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a60371c20e4666c2bffebbe378f02fa4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"endwell-ny","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.07530212402344,42.14099884033203],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	0	20
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.07530212402344,42.14099884033203],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	3	20
11	db.events_radius_cache.count( {"_id":"a60371c20e4666c2bffebbe378f02fa4"} )	0	1
12	db.events_radius_cache.count( {"_id":"a60371c20e4666c2bffebbe378f02fa4"} )	0	1
13	db.events_radius_cache.insert( {"_id":"a60371c20e4666c2bffebbe378f02fa4","radius":25,"modified":"MongoDate(0.04900000 1766384215)","created":"MongoDate(0.04900000 1766384215)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-76.07530212402344,42.14099884033203],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	244
15	db.events_cache.count( {"_id":"d221686f3cc51383734c358b1fb31a90"} )	0	11
16	db.events_cache.count( {"_id":"d221686f3cc51383734c358b1fb31a90"} )	0	7
17	db.events_cache.insert( {"_id":"d221686f3cc51383734c358b1fb31a90","town_sef_url":"endwell-ny","data_key":["6943e09cde4ae56f5a8bc951","68639ff1fb5e4bed1fa5e150","688b2cd2fb5e4bed1f075b0e","688b2cd7fb5e4bed1f0762f4","688b2cd9fb5e4bed1f076844","688b2cdafb5e4bed1f07694e","68911579fb5e4bed1fbe4bd6","69339393de4ae56f5aea2f70","68917cc1fb5e4bed1f5902d5","69339393de4ae56f5aea2f97","68dde221c3af739f25c5780c","689965cffb5e4bed1f95435c","689ab740fb5e4bed1fdee4d7","68b6358ac3af739f259e2bee","68ef05a1c3af739f254c15df"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Endwell 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.14099884033203,\"lng\":-76.07530212402344,\"latlng\":\"42.140998840332,-76.075302124023\",\"city\":\"Endwell\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.52500000 1766384215)","created":"MongoDate(0.52500000 1766384215)"} , true)	0	10
18	db.towns.find( {"sef_url":"endwell-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
19	db.tokens.find( {"sef_url":{"$in":["usa","ny","broome-county-ny","endwell-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	10
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Endwell

New York

Endwell Featured Events

Christmas Eve Candlelight Service

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

Laurel Canyon Band - Tribute To Crosby, Stills, Nash & Young

Binghamton Black Bears vs. Twin City Thunderbirds

Laurel Canyon Band - Tribute To Crosby, Stills, Nash & Young

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

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.

Endwell Featured Events

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.