| 1 | db.towns.find( {"sef_url":"charlestown-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.towns.find( {"sef_url":"charlestown-ri"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","ri","washington-county-ri","charlestown-ri"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 4 | db.ttd_towns.find( {"town_sef_url":"charlestown-ri","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 5 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-71.64099884033203,41.385501861572266],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"RI"}}},{"$project":{"title":1,"homepage_title":1,"tags":1,"image_url":1,"distance":1,"page_path":1,"path":1,"article_hostname":1,"text":1,"publish_date":1,"site_canonical":1,"sections.title":1,"sections.geo":1,"sections.text":1}},{"$addFields":{"days_since":{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766644248076)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766644248076)","$publish_date"]},86400000]}]}}},{"$sort":{"relevance_score":1,"_id":1}},{"$skip":0},{"$limit":11}]}, ["article_id","title","homepage_title","tags","image_url","path","article_hostname","sef_tail","page_path","text","publish_date","site_canonical","sections.title","sections.text"] ).sort( {"relevance_score":1,"_id":1} ).limit( 11 ).skip( 0 ) | | 0 | 11 | 308 |
| 7 | db.ttd_towns.find( {"town_sef_url":"charlestown-ri","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 9 | db.events_cache.find( {"_id":"58681c2f7db3062a30bcbeb340f681ae"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 10 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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( 2 ).skip( 0 ) | | 0 | 2 | 8 |
| 11 | db.events_cache.count( {"_id":"58681c2f7db3062a30bcbeb340f681ae"} ) | | 0 | 0 | 1 |
| 12 | db.events_cache.insert( {"_id":"58681c2f7db3062a30bcbeb340f681ae","town_sef_url":"charlestown-ri","data_key":["69036aea4389be6be5f6366d"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.44000000 1766644248)","created":"MongoDate(0.44000000 1766644248)"} , true) | | 0 | 0 | 1 |
| 13 | db.events_cache.find( {"_id":"8620674eb89c73f0d5bd78b3d6b0d21f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76203179]},"tags":"music","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],0.14492753623188406]}}}, ["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( 2 ).skip( 0 ) | | 0 | 2 | 50 |
| 15 | db.events_cache.count( {"_id":"8620674eb89c73f0d5bd78b3d6b0d21f"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.insert( {"_id":"8620674eb89c73f0d5bd78b3d6b0d21f","town_sef_url":"charlestown-ri","data_key":["6933210f4389be6be5659528"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.52900000 1766644248)","created":"MongoDate(0.52900000 1766644248)"} , true) | | 0 | 0 | 2 |
| 17 | db.events_cache.find( {"_id":"d8dc9b5dbbb129b09f7985197a07c6be"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76203179,76322388]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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( 2 ).skip( 0 ) | | 0 | 2 | 2 |
| 19 | db.events_cache.count( {"_id":"d8dc9b5dbbb129b09f7985197a07c6be"} ) | | 0 | 0 | 1 |
| 20 | db.events_cache.insert( {"_id":"d8dc9b5dbbb129b09f7985197a07c6be","town_sef_url":"charlestown-ri","data_key":["69036ae54389be6be5f61d68"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-71.64099884033203,41.385501861572266],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.54900000 1766644248)","created":"MongoDate(0.54900000 1766644248)"} , true) | | 0 | 0 | 2 |
| 21 | db.events_cache.find( {"_id":"c701e3e1a1a40ffbed7124b5f8bc7805"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 22 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76203179,76322388,76276144]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],1.4492753623188406]}}}, ["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( 51 ).skip( 0 ) | | 0 | 51 | 21 |
| 23 | db.events_cache.count( {"_id":"c701e3e1a1a40ffbed7124b5f8bc7805"} ) | | 0 | 0 | 1 |
| 24 | db.events_cache.insert( {"_id":"c701e3e1a1a40ffbed7124b5f8bc7805","town_sef_url":"charlestown-ri","data_key":["68a75b6903a70639b6cf47f8","69036ae64389be6be5f62176","69036ae64389be6be5f621bf","693321064389be6be5654f5f","693321064389be6be5654fcd","693321064389be6be5654fd8","68a75b6903a70639b6cf48c2","693321064389be6be5655024","693321064389be6be565503f","69036ae74389be6be5f62429","69036ae74389be6be5f6247f","693321064389be6be5655152","69036ae74389be6be5f625c7","68a75b6b03a70639b6cf525b","69036ae74389be6be5f6265a","68a75b6b03a70639b6cf52f9","68a75b6b03a70639b6cf53d7","69036ae84389be6be5f6270d","69036ae84389be6be5f62754","68a75b6b03a70639b6cf556b","68a75b6b03a70639b6cf55af","69036ae84389be6be5f628af","69036ae84389be6be5f62926","693321064389be6be565530d","693321064389be6be5655388","68a75b6b03a70639b6cf55fe","68a75b6b03a70639b6cf560b","68a75b6b03a70639b6cf564a","69036ae84389be6be5f62abb","68a75b6b03a70639b6cf5667","693321064389be6be56554ad","693321064389be6be56554b6","69036ae84389be6be5f62b2a","69036ae94389be6be5f62c96","68a75b6c03a70639b6cf5ac7","69036ae94389be6be5f62d7d","68a75b6c03a70639b6cf5b2a","69036ae94389be6be5f62da9","68a75b6c03a70639b6cf5c00","693321074389be6be565569f","693321074389be6be56556ef","68a75b6c03a70639b6cf5cb8","69036ae94389be6be5f63012","693321074389be6be5655724","693321074389be6be5655742","69036ae94389be6be5f63070","693321074389be6be5655797","69036ae94389be6be5f630b8","68a75b6c03a70639b6cf5dc7","69036ae94389be6be5f63142"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-71.64099884033203,41.385501861572266],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.59900000 1766644248)","created":"MongoDate(0.59900000 1766644248)"} , true) | | 0 | 0 | 1 |
| 25 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-historic-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/historic-restaurants\/\" target=\"_blank\">8 Best Historic Restaurants in Rhode Island<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/historic-restaurants\/\" target=\"_blank\">The Charlestown Rathskeller, Charlestown, RI <\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Almost a century old, the Charlestown Rathskeller brings with it all of the allure and intrigue of the past. This traditional speakeasy features recently restored 80-year-old murals and a… <a href=\"https:\/\/bestthingsri.com\/historic-restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-fish-and-chips-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/article\/fish-and-chips\/\" target=\"_blank\">10 Best Places to get Fish and Chips in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/article\/fish-and-chips\/\" target=\"_blank\">The Breachway Grill, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The Breachway Grill is the place for fish and chips that are bursting with flavor! Happily dig into some of the tastiest fish and chips with their scratch-cooked recipes. Every meal has the freshest… <a href=\"https:\/\/bestthingsri.com\/article\/fish-and-chips\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-camping-spots-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/camping\/\" target=\"_blank\">The 15 Best Camping Spots in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/camping\/\" target=\"_blank\">Burlingame State Park and Campground, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">This campground can be found right next to Watchuag Pond in Charlestown, a scenic little body of water hidden in miles of rocky forest area. They offer 50 fireplaces, toilets, have clean drinking… <a href=\"https:\/\/bestthingsri.com\/camping\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-state-parks-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/state-parks\/\" target=\"_blank\">10 Best State Parks in Rhode Island<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/state-parks\/\" target=\"_blank\">Burlingame State Park, Charlestown, RI <\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Perhaps the most rustic and certainly the largest of the parks featured here, this 3,100-acre park consists of the rocky woodlands that envelop Watchaug Pond. Featuring a tucked-away campground with… <a href=\"https:\/\/bestthingsri.com\/state-parks\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-crab-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/crab-restaurants\/\" target=\"_blank\">The 9 Best Places for Crab in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/crab-restaurants\/\" target=\"_blank\">Nordic Lodge, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Eat away at some giant king crab legs at the Nordic Lodge—a classic New England seafood restaurant located in Charlestown. The meat is so perfectly juicy and delicious that you’ll need to… <a href=\"https:\/\/bestthingsri.com\/crab-restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-hardware-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/hardware-stores\/\" target=\"_blank\">The 8 Best Hardware Stores in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/hardware-stores\/\" target=\"_blank\">Compass Hardware, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\"><p>You’ll be guaranteed to find a good deal at this independent hardware store! Come here for home supplies, contractor supplies, and coal and propane, which they can even deliver!<\/p> <a href=\"https:\/\/bestthingsri.com\/hardware-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-nature-centers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/nature-centers\/\" target=\"_blank\">The 10 Best Nature Centers in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/nature-centers\/\" target=\"_blank\">Frosty Drew Observatory & Science Center, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">This property was given to the town of Charlestown after a U.S. Naval Landing Field was closed in 1973. It now serves to educate community members of all ages about nature, in particular marine… <a href=\"https:\/\/bestthingsri.com\/nature-centers\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-buffets-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/buffets\/\" target=\"_blank\">The 8 Best Buffets in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/buffets\/\" target=\"_blank\">The Nordic Lodge, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">So, let’s be clear. There are buffets, and then there are seafood buffets. Get unlimited amounts of succulent lobster, delicate crab, shrimp, scallops, oysters, and more. Seriously, we are… <a href=\"https:\/\/bestthingsri.com\/buffets\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-speakeasies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/speakeasy-bars\/\" target=\"_blank\">The Best Speakeasies in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/speakeasy-bars\/\" target=\"_blank\">Charlestown Rathskeller, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The Rathskeller has put a great deal of effort into restoring the building that once housed a speakeasy in the back woods of Charlestown. Now, the restaurant is open seven days a week for lunch and… <a href=\"https:\/\/bestthingsri.com\/speakeasy-bars\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ri-iced-coffee-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsri.com\/iced-coffee\/\" target=\"_blank\">10 Best Spots for Iced Coffee in Rhode Island!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsri.com\/iced-coffee\/\" target=\"_blank\">Dave's Coffee, Charlestown, RI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Dave's Coffee is a funky, quirky spot for those looking to take a break and enjoy a freshly brewed iced cup of joe. The laid-back cafe offers a variety of java drinks, from classic RI coffee milk to… <a href=\"https:\/\/bestthingsri.com\/iced-coffee\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n\n\n","town_sef_url":"charlestown-ri","title":"Hiking!","subtitle":"Maps, directions and reviews for hiking around {local_city_state}!","image_url":"{\"0\":{\"content_type\":\"movie\",\"movie\":\"\/movie\/black-panther-wakanda-forever-297863\/\",\"title\":\"Black Panther: Wakanda Forever\",\"thumbnail\":\"https:\/\/www.movienewsletters.net\/photos\/297863R4.jpg\"},\"1\":{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster","url":"\/{town_sef_url}\/hiking\/","slots":[{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1766647848,"type":"Event","id":76203179,"title":"Rhode Island Rams Mens Basketball vs. Loyola Ramblers Mens Basketball","url":"\/event\/rhode-island-rams-mens-basketball-vs-loyola-ramblers-mens-basketball-2025-12-31-tm-narragansett-ri.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/197485a.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1766647848,"type":"Event","id":76322388,"title":"Crooked Coast","url":"\/event\/crooked-coast-2026-01-23-jb-south-kingstown-ri.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2023\/02\/crooked-coast-980x551.png"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1766647848,"type":"Event","id":76276144,"title":"Kinney Azalea Gardens Festival of Trees","url":"\/event\/kinney-azalea-gardens-festival-of-trees-2025-12-26-kingston-ri.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-1.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1766658648,"type":"Event","id":76377666,"title":"Thirty 6 Red","url":"\/event\/thirty-6-red-2025-12-26-tm-foxboro-ma.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/677\/c58dd0af-cda8-49b2-bdaf-068540c3a677_106541_TABLET_LANDSCAPE_LARGE_16_9.jpg"}],"modified":"MongoDate(0.60300000 1766644248)","created":"MongoDate(0.60300000 1766644248)","_id":ObjectId ("694cda18ae8f45030e04303d")} , true) | | 0 | 0 | 1 |
| 26 | db.events_cache.find( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 27 | db.events_radius_cache.find( {"_id":"c7a00d5ed78f8353749c2514527335c0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 28 | db.events.count( {"address.town_sef_url":"charlestown-ri","start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 0 | 1 |
| 29 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767506400)"}} ) | | 0 | 0 | 28 |
| 30 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767506400)"}} ) | | 0 | 12 | 28 |
| 31 | db.events_radius_cache.count( {"_id":"c7a00d5ed78f8353749c2514527335c0"} ) | | 0 | 0 | 1 |
| 32 | db.events_radius_cache.insert( {"_id":"c7a00d5ed78f8353749c2514527335c0","radius":25,"modified":"MongoDate(0.68200000 1766644248)","created":"MongoDate(0.68200000 1766644248)"} , true) | | 0 | 0 | 2 |
| 33 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76203179,76322388,76276144,76377666]},"geo":{"$geoWithin":{"$center":[[-71.64099884033203,41.385501861572266],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( 6 ).skip( 0 ) | | 0 | 6 | 207 |
| 34 | db.events_cache.count( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9"} ) | | 0 | 0 | 1 |
| 35 | db.events_cache.count( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.insert( {"_id":"e8f070a8ac5367b2337bf9bdd5cea0a9","town_sef_url":"charlestown-ri","data_key":["69036ae54389be6be5f61e8d","69036ae54389be6be5f61e91","68a75b6903a70639b6cf4791","68a75b6903a70639b6cf4baa","69036ae74389be6be5f62338"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Charlestown\",\"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.385501861572266,\"lng\":-71.64099884033203,\"latlng\":\"41.385501861572,-71.640998840332\",\"city\":\"Charlestown\",\"state\":\"RI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.92400000 1766644248)","created":"MongoDate(0.92400000 1766644248)"} , true) | | 0 | 0 | 1 |
| 37 | db.news.find( {"broadcast":{"$in":["usa","charlestown-ri","ri","washington-county-ri"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 8 |
| 38 | db.places.find( {"address.town_sef_url":"charlestown-ri","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
