Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"newport-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/sparkling-lights-at-the-breakers-2025-12-13-newport-ri.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"newport-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","ri","newport-county-ri","newport-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"8b9b7c7396dd7c24469073e3a1dae5b5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"4c2579863245c36aedee285b81a57d50"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"newport-ri","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	7	3
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.30950164794922,41.47549819946289],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	9	35
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.30950164794922,41.47549819946289],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	16	33
10	db.events_radius_cache.count( {"_id":"4c2579863245c36aedee285b81a57d50"} )	0	1
11	db.events_radius_cache.insert( {"_id":"4c2579863245c36aedee285b81a57d50","radius":15,"modified":"MongoDate(0.07400000 1765863317)","created":"MongoDate(0.07400000 1765863317)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-71.30950164794922,41.47549819946289],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	408
13	db.events_cache.count( {"_id":"8b9b7c7396dd7c24469073e3a1dae5b5"} )	0	2
14	db.events_cache.count( {"_id":"8b9b7c7396dd7c24469073e3a1dae5b5"} )	0	1
15	db.events_cache.insert( {"_id":"8b9b7c7396dd7c24469073e3a1dae5b5","town_sef_url":"newport-ri","data_key":["69036add4389be6be5f5eaaa","69036ade4389be6be5f5f290","69036adf4389be6be5f5f7d4","69036adf4389be6be5f5f8af","68a75b6203a70639b6cf1c85","68a75b6303a70639b6cf217b","69036ae14389be6be5f60245","69036ae14389be6be5f60621","68a75b6403a70639b6cf2c6e","69036ae34389be6be5f60f69","69036ae34389be6be5f61352","69036ae34389be6be5f6133e","69036ae34389be6be5f61338","69036ae44389be6be5f6161c","69036ae44389be6be5f616b0"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Newport Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"sparkling-lights-at-the-breakers-2025-12-13-newport-ri.html\",\"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.47549819946289,\"lng\":-71.30950164794922,\"latlng\":\"41.475498199463,-71.309501647949\",\"city\":\"Newport\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.51600000 1765863317)","created":"MongoDate(0.51600000 1765863317)"} , true)	0	1

Newport

Rhode Island

Newport Featured Events

Rhode Island Rams Mens Basketball vs. Canisius Golden Griffins Mens Basketball

Sparkling Lights at The Breakers

Kinney Azalea Gardens Festival of Trees

Holiday Lantern Tour

Show - The Bit Players

South Kingstown Farmers Market - Kingston

Kinney Azalea Gardens Festival of Trees

Holiday Lantern Tour

Show - The Bit Players

Kinney Azalea Gardens Festival of Trees

Night Magic!

Holiday Lantern Tour

Sparkling Lights at The Breakers

Rhode Island Rams Mens Basketball vs. Northeastern Huskies Mens Basketball

Sparkling Lights at The Breakers

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.

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