Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"clay-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"clay-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","onondaga-county-ny","clay-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"41c978927b7fa8e3c9313d9c649ba6ea"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"8ed154900c42cb1fe52eacbcb497e788"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"clay-ny","start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768111200)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.17279815673828,43.18600082397461],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768370400)"}} )	0	17
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.17279815673828,43.18600082397461],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767506400)","$lt":"MongoDate(0.00000000 1768370400)"}} )	20	14
10	db.events_radius_cache.count( {"_id":"8ed154900c42cb1fe52eacbcb497e788"} )	0	1
11	db.events_radius_cache.insert( {"_id":"8ed154900c42cb1fe52eacbcb497e788","radius":15,"modified":"MongoDate(0.24600000 1767546178)","created":"MongoDate(0.24600000 1767546178)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767506400)"},"geo":{"$geoWithin":{"$center":[[-76.17279815673828,43.18600082397461],0.21739130434782608]}}}, ["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	133
13	db.events_cache.count( {"_id":"41c978927b7fa8e3c9313d9c649ba6ea"} )	0	1
14	db.events_cache.count( {"_id":"41c978927b7fa8e3c9313d9c649ba6ea"} )	0	1
15	db.events_cache.insert( {"_id":"41c978927b7fa8e3c9313d9c649ba6ea","town_sef_url":"clay-ny","data_key":["68a75b6f03a70639b6cf72f9","693321094389be6be56568a4","693321094389be6be565697b","693321094389be6be5656a6c","69036aee4389be6be5f64bc1","68a75b7003a70639b6cf77b0","69036aee4389be6be5f64d8e","69036aee4389be6be5f64ec5","69036aef4389be6be5f64f9f","69036aef4389be6be5f652d6","69036aef4389be6be5f655e6","68a75b7103a70639b6cf7f72","69036af04389be6be5f658ba","6933210b4389be6be565761f","69036af04389be6be5f65b3e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clay Featured Events\",\"keyword\":\"\",\"radius\":15,\"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\":43.18600082397461,\"lng\":-76.17279815673828,\"latlng\":\"43.186000823975,-76.172798156738\",\"city\":\"Clay\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.41000000 1767546178)","created":"MongoDate(0.41100000 1767546178)"} , true)	0	2

Clay

New York

Clay Featured Events

Miracle On 34th Street – The Musical (Touring)

Jazz Jam

Open mic hosted by Attamizk & friends

J AND THE TIE DYERS

MJ (Touring)

Syracuse Crunch vs. Rochester Americans

MJ (Touring)

Syracuse University Women's Basketball vs. Virginia Tech Hokies Womens Basketball

MJ (Touring)

MJ (Touring)

MJ (Touring)

Syracuse Crunch vs. Laval Rocket

MJ (Touring)

Dangerous Type

MJ (Touring)

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.

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