Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"clayville-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	16
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.towns.find( {"sef_url":"clayville-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","clayville-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"0aa3b5179c88682320ce0a51043f2516"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"6238ce6d7e8c22d282f763fc4cf7b377"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-71.67569732666016,41.77790069580078],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	66
8	db.events_cache.count( {"_id":"0aa3b5179c88682320ce0a51043f2516"} )	0	2
9	db.events_cache.insert( {"_id":"0aa3b5179c88682320ce0a51043f2516","town_sef_url":"clayville-ri","data_key":["68a75b6703a70639b6cf3dfa","68a75b6803a70639b6cf41b7","69036ae54389be6be5f61d1a","69036ae54389be6be5f61d68","69036ae64389be6be5f61f03","68a75b6803a70639b6cf45f9","69036ae74389be6be5f622eb","68a75b6903a70639b6cf4baa","69036ae74389be6be5f62338","69036ae74389be6be5f6250a","693321064389be6be5655152","69036ae74389be6be5f62568","69036ae84389be6be5f62824","68a75b6b03a70639b6cf5494","69036ae84389be6be5f628e4"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clayville 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\":41.77790069580078,\"lng\":-71.67569732666016,\"latlng\":\"41.777900695801,-71.67569732666\",\"city\":\"Clayville\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.24500000 1766404362)","created":"MongoDate(0.24500000 1766404362)"} , true)	0	2

Clayville

Rhode Island

Clayville Featured Events

Live Music - Matt Martin and the Daydrinkers

Live Music - Dan Lilley and The Keepers

Rhode Island Holiday Light Show

Kinney Azalea Gardens Festival of Trees

Holiday Lights Spectacular at Roger Williams Park Zoo

Paint with Us!

Rhode Island Holiday Light Show

South Kingstown Farmers Market - Kingston

Kinney Azalea Gardens Festival of Trees

Home for the Holidays - Guided History Tour

Day Trill

Holiday Lights Spectacular at Roger Williams Park Zoo

Simon & Garfunkel - On Bleeker St. 12/27/25 SAT DEC 27

Van Halen - Halen CT

John Cafferty & the Beaver Brown Band

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.

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