Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"scarsdale-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/sports-and-recreation"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"scarsdale-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","westchester-county-ny","scarsdale-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"cf9a3b368e79736e7cd55f96082d09cd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"d0f9e3aafe9b410026e6251e629d9181"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"scarsdale-ny","start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1765778400)"}} )	5	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.77749633789062,40.98889923095703],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}} )	19	44
9	db.events_radius_cache.count( {"_id":"d0f9e3aafe9b410026e6251e629d9181"} )	0	1
10	db.events_radius_cache.insert( {"_id":"d0f9e3aafe9b410026e6251e629d9181","radius":7,"modified":"MongoDate(0.94200000 1765253543)","created":"MongoDate(0.94200000 1765253543)"} , true)	0	1
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765173600)"},"tags":"sports-and-recreation","geo":{"$geoWithin":{"$center":[[-73.77749633789062,40.98889923095703],0.10144927536231885]}}}, ["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	7
12	db.events_cache.count( {"_id":"cf9a3b368e79736e7cd55f96082d09cd"} )	0	1
13	db.events_cache.count( {"_id":"cf9a3b368e79736e7cd55f96082d09cd"} )	0	1
14	db.events_cache.insert( {"_id":"cf9a3b368e79736e7cd55f96082d09cd","town_sef_url":"scarsdale-ny","data_key":["69036ad44389be6be5f5ba2a","69036ad64389be6be5f5c5cd","69036add4389be6be5f5eb00","69036ae74389be6be5f626c9","69036ae94389be6be5f62f26","69036aec4389be6be5f63dfc","69036aef4389be6be5f65170","69036af04389be6be5f65769","69036af14389be6be5f66393","69036af54389be6be5f6807e","69036af64389be6be5f6890a","693321114389be6be565a6b0","69036b034389be6be5f6ebe8","69036b064389be6be5f6fcc2","69036b084389be6be5f70bcf"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Scarsdale Featured Events<br>Sports And Recreation\",\"keyword\":\"\",\"radius\":7,\"limit\":15,\"page\":1,\"sef\":\"sports-and-recreation\",\"tags\":\"sports-and-recreation\",\"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\":40.98889923095703,\"lng\":-73.77749633789062,\"latlng\":\"40.988899230957,-73.777496337891\",\"city\":\"Scarsdale\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.97100000 1765253543)","created":"MongoDate(0.97100000 1765253543)"} , true)	0	1

Scarsdale

New York

Scarsdale Featured Events
Sports And Recreation

Westchester Knicks vs. Long Island Nets

Westchester Knicks vs. Long Island Nets

Westchester Knicks vs. Raptors 905

Westchester Knicks vs. Birmingham Squadron

Westchester Knicks vs. Birmingham Squadron

Westchester Knicks vs. Capital City Go-Go

Westchester Knicks vs. Stockton Kings

Westchester Knicks vs. Stockton Kings

Westchester Knicks vs. Greensboro Swarm

Westchester Knicks vs. Windy City Bulls

Westchester Knicks vs. Osceola Magic

World Championship Sumo

Westchester Knicks vs. Grand Rapids Gold

Westchester Knicks vs. Cleveland Charge

Westchester Knicks vs. Cleveland Charge

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.

Scarsdale Featured EventsSports And Recreation

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.

Scarsdale Featured Events
Sports And Recreation

20 million people
rely on AmericanTowns each year to find & share local information.