Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"evans-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.towns.find( {"sef_url":"newport-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.towns.find( {"sef_url":"newport-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.tokens.find( {"sef_url":{"$in":["usa","ri","newport-county-ri","newport-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"adc4ff60d71f61daae716a05b6bed1cf"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"4c2579863245c36aedee285b81a57d50"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"newport-ri","start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766556000)"}} )	9	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.30950164794922,41.47549819946289],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766815200)"}} )	12	31
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.30950164794922,41.47549819946289],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766815200)"}} )	19	22
11	db.events_radius_cache.count( {"_id":"4c2579863245c36aedee285b81a57d50"} )	0	1
12	db.events_radius_cache.insert( {"_id":"4c2579863245c36aedee285b81a57d50","radius":15,"modified":"MongoDate(0.16700000 1765978194)","created":"MongoDate(0.16700000 1765978194)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"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	224
14	db.events_cache.count( {"_id":"adc4ff60d71f61daae716a05b6bed1cf"} )	0	1
15	db.events_cache.count( {"_id":"adc4ff60d71f61daae716a05b6bed1cf"} )	0	1
16	db.events_cache.insert( {"_id":"adc4ff60d71f61daae716a05b6bed1cf","town_sef_url":"newport-ri","data_key":["69036ade4389be6be5f5f290","69036adf4389be6be5f5f7d4","69036adf4389be6be5f5f8af","68a75b6203a70639b6cf1c85","68a75b6303a70639b6cf217b","69036ae14389be6be5f60245","69036ae14389be6be5f60621","68a75b6403a70639b6cf2c6e","69036ae34389be6be5f60f69","69036ae34389be6be5f61352","69036ae34389be6be5f6133e","69036ae34389be6be5f61338","69036ae44389be6be5f6161c","69036ae44389be6be5f616b0","69036ae54389be6be5f618ea"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Newport 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\":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.41600000 1765978194)","created":"MongoDate(0.41600000 1765978194)"} , true)	0	2

Newport

Rhode Island

Newport Featured Events

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

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.