Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"kaunakakai-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	13
3	db.towns.find( {"sef_url":"clayville-ri"}, [] ).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":"0aa3b5179c88682320ce0a51043f2516"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	9
7	db.events_radius_cache.find( {"_id":"6238ce6d7e8c22d282f763fc4cf7b377"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
8	db.events.count( {"address.town_sef_url":"clayville-ri","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	11
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.67569732666016,41.77790069580078],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	135
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.67569732666016,41.77790069580078],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	5	75
11	db.events_radius_cache.count( {"_id":"6238ce6d7e8c22d282f763fc4cf7b377"} )	0	3
12	db.events_radius_cache.count( {"_id":"6238ce6d7e8c22d282f763fc4cf7b377"} )	0	28
13	db.events_radius_cache.insert( {"_id":"6238ce6d7e8c22d282f763fc4cf7b377","radius":25,"modified":"MongoDate(0.60200000 1766298841)","created":"MongoDate(0.60200000 1766298841)"} , true)	0	8
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"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	479
15	db.events_cache.count( {"_id":"0aa3b5179c88682320ce0a51043f2516"} )	0	15
16	db.events_cache.count( {"_id":"0aa3b5179c88682320ce0a51043f2516"} )	0	10
17	db.events_cache.insert( {"_id":"0aa3b5179c88682320ce0a51043f2516","town_sef_url":"clayville-ri","data_key":["68fd1a15410059e7d104a3d9","68fd122a843db913e8072f6f","6900bd3fc3af739f2529d1f5","68db17fc695f30aa8809bb51","68f93c9952e7405887004346","68c8ca21c3af739f25291262","6913ef95de4ae56f5a16b2e4","68f94393843db913e8072f51","68f9476e8248d952cc0d23b1","689bba81843db913e8072d53","68fd07c552e7405887004364","69020d52315a2fa2aa0b3ea8","689bc9e2c4766aed420de8d1","690c3ed8de4ae56f5afb9a1e","6944d6b5de4ae56f5a0a3f33"],"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.21100000 1766298842)","created":"MongoDate(0.21100000 1766298842)"} , true)	0	11
18	db.towns.find( {"sef_url":"clayville-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
19	db.tokens.find( {"sef_url":{"$in":["usa","ri","providence-county-ri","clayville-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	3
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Clayville

Rhode Island

Clayville Featured Events

Rhode Island Holiday Light Show

Kinney Azalea Gardens Festival of Trees

Cultural Survival Bazaar on December 21

Flea at Farm Fresh

Fall and Holiday Markets at Farm Fresh

Cirque Dreams Holidaze

Providence College Friars Womens Basketball vs. Georgetown Hoyas Womens Basketball

A Christmas Carol

A Christmas Carol

The 133 Club Blues and Jazz Series

Holiday Lights Spectacular at Roger Williams Park Zoo

Southwick's Zoo Winter Wonderland

Christmas with The Celts

The Kilograms

Tarro Law Associates, PC

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

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.