(mongo) 59 queries took 1020 ms
Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rose-city-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.ttd_towns.find( {"town_sef_url":"rose-city-mi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
4	db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
6	db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
7	db.articles.find( {"aggregate":[{"$geoNear":{"near":[-84.11620330810547,44.42150115966797],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"MI"}}},{"$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(1761837415688)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761837415688)","$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 )	11	105
8	db.ttd_towns.find( {"town_sef_url":"rose-city-mi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 )	0	3
9	db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
10	db.events_cache.find( {"_id":"1e585cadede4bca5f35ebb6caab20368"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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	4
12	db.events_cache.count( {"_id":"1e585cadede4bca5f35ebb6caab20368"} )	0	2
13	db.events_cache.insert( {"_id":"1e585cadede4bca5f35ebb6caab20368","town_sef_url":"rose-city-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.85500000 1761837415)","created":"MongoDate(0.85500000 1761837415)"} , true)	0	2
14	db.events_cache.find( {"_id":"753a6823bc7e8c7d9b8fc5c6ad8022c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
15	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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	3
16	db.events_cache.count( {"_id":"753a6823bc7e8c7d9b8fc5c6ad8022c8"} )	0	1
17	db.events_cache.insert( {"_id":"753a6823bc7e8c7d9b8fc5c6ad8022c8","town_sef_url":"rose-city-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.87800000 1761837415)","created":"MongoDate(0.87800000 1761837415)"} , true)	0	1
18	db.events_cache.find( {"_id":"d5e51e099376292725bdb81462ebf209"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
19	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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	4
20	db.events_cache.count( {"_id":"d5e51e099376292725bdb81462ebf209"} )	0	2
21	db.events_cache.insert( {"_id":"d5e51e099376292725bdb81462ebf209","town_sef_url":"rose-city-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.90300000 1761837415)","created":"MongoDate(0.90300000 1761837415)"} , true)	0	2
22	db.events_cache.find( {"_id":"c9c4ed6cce50ffc91caa68a15d8ab0a4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
23	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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	3
24	db.events_cache.count( {"_id":"c9c4ed6cce50ffc91caa68a15d8ab0a4"} )	0	1
25	db.events_cache.insert( {"_id":"c9c4ed6cce50ffc91caa68a15d8ab0a4","town_sef_url":"rose-city-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.92500000 1761837415)","created":"MongoDate(0.92500000 1761837415)"} , true)	0	2
26	db.events_cache.find( {"_id":"c46d1e4258a7b58994850ccbb5deabf2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
27	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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	4
28	db.events_cache.count( {"_id":"c46d1e4258a7b58994850ccbb5deabf2"} )	0	1
29	db.events_cache.insert( {"_id":"c46d1e4258a7b58994850ccbb5deabf2","town_sef_url":"rose-city-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.94900000 1761837415)","created":"MongoDate(0.94900000 1761837415)"} , true)	0	2
30	db.events_cache.find( {"_id":"8091ac668c63239fbc12204ce542354a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
31	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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 )	1	4
32	db.events_cache.count( {"_id":"8091ac668c63239fbc12204ce542354a"} )	0	1
33	db.events_cache.insert( {"_id":"8091ac668c63239fbc12204ce542354a","town_sef_url":"rose-city-mi","data_key":["68ff4400b71bc004bd06baac"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.97200000 1761837415)","created":"MongoDate(0.97200000 1761837415)"} , true)	0	2
34	db.events_cache.find( {"_id":"4ba5ce3b01e4fb19919f5d1a3461aa26"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
35	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76278577]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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 )	51	491
36	db.events_cache.count( {"_id":"4ba5ce3b01e4fb19919f5d1a3461aa26"} )	0	2
37	db.events_cache.insert( {"_id":"4ba5ce3b01e4fb19919f5d1a3461aa26","town_sef_url":"rose-city-mi","data_key":["68911572fb5e4bed1fbdba20","6892ce3cfb5e4bed1f908d90","68911572fb5e4bed1fbdc39c","68911573fb5e4bed1fbdc83a","68f6ee95c3af739f258269f2","6820632bfb5e4bed1ffff820","68957146fb5e4bed1fd74b91","68911574fb5e4bed1fbddd85","686cda16fb5e4bed1f71e3b7","6826fb0bfb5e4bed1fdd9c18","682af1cdfb5e4bed1f75bb31","682c4134fb5e4bed1f5d0eef","68f6ee97c3af739f25827998","685670c2fb5e4bed1f3b0413","68a5433cfb5e4bed1febb2ec","68a5433cfb5e4bed1febb405","68911575fb5e4bed1fbe0c43","68917cbefb5e4bed1f58eaaf","68f9919dc3af739f25359667","683d6512fb5e4bed1f078d81","68911576fb5e4bed1fbe1720","68639fd1fb5e4bed1fa5a532","6847f09afb5e4bed1f033e70","68d4a7a3c3af739f25450c96","68b10f27c3af739f25c5bbd1","68a9262ac3af739f252fc9af","68911577fb5e4bed1fbe2f31","68d4a7a3c3af739f25451010","68400701fb5e4bed1f7585d6","68f9919fc3af739f2535a1bf","68911577fb5e4bed1fbe32e8","685913aefb5e4bed1fd9a4e0","68911577fb5e4bed1fbe361f","68f6ee9ac3af739f25828ff4","68911578fb5e4bed1fbe3a98","68f6ee9bc3af739f25829199","68911578fb5e4bed1fbe3c6a","68911578fb5e4bed1fbe3cf6","68911578fb5e4bed1fbe3d9c","68f6ee9bc3af739f25829341","68911578fb5e4bed1fbe3ed2","68e5cb1fc3af739f25c780ee","68c8ca22c3af739f25291b03","68f6ee9bc3af739f258296ff","68f6ee9bc3af739f258299f6","68f6ee9bc3af739f25829b5c","68917cc1fb5e4bed1f590306","6895714afb5e4bed1fd779b5","6896c2c5fb5e4bed1f1b55b2","69017a9cc3af739f25e4007b"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":true}","modified":"MongoDate(0.04200000 1761837417)","created":"MongoDate(0.04200000 1761837417)"} , true)	0	1
38	db.events_cache.find( {"_id":"6da29e737cb756081ace35c1bddc0430"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
39	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76278577,76016718]},"tags":"music","geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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 )	16	118
40	db.events_cache.count( {"_id":"6da29e737cb756081ace35c1bddc0430"} )	0	2
41	db.events_cache.insert( {"_id":"6da29e737cb756081ace35c1bddc0430","town_sef_url":"rose-city-mi","data_key":["68d8d45fc3af739f2564a4b0","682af1b8fb5e4bed1f758af8","68a6f99dc3af739f2569bd95","68c26ae4c3af739f25d442bc","68cba567c3af739f25f702c6","68e6035bc3af739f25f7e06a","68d38e62c3af739f25653d9d","68d782e2c3af739f253fe1e5","68c65f65c3af739f25e1e540","689ce6e5fb5e4bed1fda11e2","68cba569c3af739f25f7132c","68e754e0c3af739f2514d305","68ef3dddc3af739f2585ab4d","68e754e0c3af739f2514d33c","68e754e2c3af739f2514da3f","68f483dec3af739f25f39911"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-84.11620330810547,44.42150115966797],\"has_next_page\":false}","modified":"MongoDate(0.28000000 1761837417)","created":"MongoDate(0.28000000 1761837417)"} , true)	0	2
42	db.places.find( {"geo":{"$near":[-84.11620330810547,44.42150115966797],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 )	2	3
43	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\/mi-shopping-outlet-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/shopping-outlets\/\" target=\"_blank\">The 7 Best Shopping Outlets and Malls in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/shopping-outlets\/\" target=\"_blank\">Outlets at West Branch, West Branch, MI<\/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\">Outlets at West Branch has recently—late December 2017 recently—undergone a change of ownership. A variety of changes have been put into place and a lot of excellent things are to come.… <a href=\"https:\/\/bestthingsmi.com\/shopping-outlets\/\" 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\/mi-golf-courses-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/public-golf-courses\/\" target=\"_blank\">The 10 Best Golf Courses in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/public-golf-courses\/\" target=\"_blank\">Forest Dunes, Roscommon, MI<\/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\">Golf Magazine, every two years, builds a list of the best golf courses in every state. Topping that list most recently was none other than Roscommon's own Forest Dunes. Featuring hotel options, real… <a href=\"https:\/\/bestthingsmi.com\/public-golf-courses\/\" 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\/mi-craft-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/craft-stores\/\" target=\"_blank\">8 Best Craft Stores in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/craft-stores\/\" target=\"_blank\">Arnie's Arts 'n' Crafts, Houghton Lake, MI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Arnie's Arts 'n' Crafts in Houghton Lake has been in operation since 1975, which speaks wonderfully about its overall longevity. Naturally, a business like that doesn't stay in operation for better… <a href=\"https:\/\/bestthingsmi.com\/craft-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\/mi-animal-shelter-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/animal-shelters\/\" target=\"_blank\">8 Best Animal Shelters in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/animal-shelters\/\" target=\"_blank\">AuSable Valley Animal Shelter, Grayling, MI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Head on up to Grayling for a look at the AuSable Valley Animal Shelter, which offers a slate of fundraising events for those looking to party in support of some great animals. With a comparatively… <a href=\"https:\/\/bestthingsmi.com\/animal-shelters\/\" 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\/mi-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/bars\/\" target=\"_blank\">10 Best Bars in Michigan: 2024 Edition!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/bars\/\" target=\"_blank\">Talley's Log Cabin Bar, Lewiston, MI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Home of the Talley Burger, and the man known as the most beloved man in Lewiston by some reports, owner Bird Smith, Talley's Log Cabin Bar represents a fairly normal bar. It has simple but delicious… <a href=\"https:\/\/bestthingsmi.com\/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\/mi-unique-hotels-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/unique-hotels\/\" target=\"_blank\">The 10 Coolest (and Most Unique) Hotels in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/unique-hotels\/\" target=\"_blank\">North Branch Outing Club, Grayling, MI<\/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\">Head on up to Grayling for one of the most natural times you've ever spent in a hotel. Near the Au Sable River, the North Branch Outing Club has previously played host to famous names like Henry Ford… <a href=\"https:\/\/bestthingsmi.com\/unique-hotels\/\" 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\/mi-trivia-nights-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/trivia\/\" target=\"_blank\">The 7 Best Trivia Nights in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/trivia\/\" target=\"_blank\">Paul's Pub, Johannesburg, MI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Paul’s Pub not only offers an awesome trivia night but also an extensive menu of soups, salads, sandwiches, and much more. From broasted chicken to appetizers, there’s an impressive range… <a href=\"https:\/\/bestthingsmi.com\/trivia\/\" 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\/mi-resorts-couples-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/resorts-for-couples\/\" target=\"_blank\">10 Best Hotels and Resorts for Couples in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/resorts-for-couples\/\" target=\"_blank\">Huron House, Oscoda, MI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Come check out the Oscoda bed and breakfast awarded multiple times by Bedandbreakfast.com, as well as winner of “Best Romantic Getaway” by VacationIdea. It's also one of the 50 best… <a href=\"https:\/\/bestthingsmi.com\/resorts-for-couples\/\" 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\/mi-boat-rentals-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/boat-rentals\/\" target=\"_blank\">8 Best Boat Rentals in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/boat-rentals\/\" target=\"_blank\">American Oak Resort, Houghton Lake, MI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Head up to Houghton Lake to check out lake operations as only the Upper Peninsula can offer. Featuring your choice of pontoon boat, waverunner, or fishing boats, as well as the option to rent tubes… <a href=\"https:\/\/bestthingsmi.com\/boat-rentals\/\" 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\/mi-pancakes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/pancakes\/\" target=\"_blank\">The 8 Best Places for Pancakes in Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/pancakes\/\" target=\"_blank\">Linwood Corners Caf\u00e9, Linwood, MI<\/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\">Linwood Corners in Linwood is something of a celebrity. They took top honors for pancakes in the Tri-Cities from WNEM Channel 5, so that's definitely a point in their favor. They're served in the… <a href=\"https:\/\/bestthingsmi.com\/pancakes\/\" 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":"rose-city-mi","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\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1761841015,"type":"Event","id":76278577,"title":"Candy Cane Lane Christmas Market and Festival","url":"\/event\/candy-cane-lane-christmas-market-and-festival-2025-12-13-west-branch-mi.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":1761851815,"type":"Event","id":76016718,"title":"Saginaw Spirit vs. Kitchener Rangers","url":"\/event\/saginaw-spirit-vs-kitchener-rangers-2025-12-13-tm-saginaw-mi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/ec4\/e5066377-4678-48d5-b61f-c47d3ebd6ec4_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1761851817,"type":"Event","id":76221348,"title":"Saving Abel and REDBURN","url":"\/event\/saving-abel-and-redburn-2025-11-19-jb-bay-city-mi.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2023\/01\/saving-abel-980x551.png"},{"rule":"{\"content_type\":\"group_category\",\"radius\":\"10\",\"ttl\":\"8\",\"israndom\":1,\"group_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-1.jpg\",\"days\":1}","expiration":1761866217,"type":"Place","id":79101,"title":"Rose City RV Center","url":"\/place\/rose-city-rv-center-rose-city-mi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"}],"modified":"MongoDate(0.29500000 1761837417)","created":"MongoDate(0.29500000 1761837417)","_id":ObjectId ("69038169f9614a1eba090f4b")} , true)	0	2
44	db.events_cache.find( {"_id":"f75c27a568491304ede4bc1230f2a452"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
45	db.events_radius_cache.find( {"_id":"75dd73b1477a5edfcac9fdc0f19ec537"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
46	db.events.count( {"address.town_sef_url":"rose-city-mi","start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762408800)"}} )	0	2
47	db.events.count( {"geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762668000)"}} )	0	97
48	db.events.count( {"geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762668000)"}} )	0	91
49	db.events_radius_cache.count( {"_id":"75dd73b1477a5edfcac9fdc0f19ec537"} )	0	1
50	db.events_radius_cache.insert( {"_id":"75dd73b1477a5edfcac9fdc0f19ec537","radius":25,"modified":"MongoDate(0.51900000 1761837417)","created":"MongoDate(0.51900000 1761837417)"} , true)	0	2
51	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76278577,76016718,76221348]},"geo":{"$geoWithin":{"$center":[[-84.11620330810547,44.42150115966797],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	5
52	db.events_cache.count( {"_id":"f75c27a568491304ede4bc1230f2a452"} )	0	2
53	db.events_cache.count( {"_id":"f75c27a568491304ede4bc1230f2a452"} )	0	1
54	db.events_cache.insert( {"_id":"f75c27a568491304ede4bc1230f2a452","town_sef_url":"rose-city-mi","data_key":[],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Rose City\",\"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\":44.42150115966797,\"lng\":-84.11620330810547,\"latlng\":\"44.421501159668,-84.116203308105\",\"city\":\"Rose City\",\"state\":\"MI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.54500000 1761837417)","created":"MongoDate(0.54500000 1761837417)"} , true)	0	2
55	db.news.find( {"broadcast":{"$in":["usa","rose-city-mi","mi","ogemaw-county-mi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 )	6	4
56	db.places.find( {"address.town_sef_url":"rose-city-mi","group_id":{"$nin":[79101]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 )	6	2
57	db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 )	0	2
58	db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 )	40	1
59	db.tokens.find( {"sef_url":{"$in":["usa","mi","ogemaw-county-mi","rose-city-mi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2

HTTP_HOST: www.devel1.americantowns.com

SERVER_NAME: www.devel1.americantowns.com

Rose City Featured Events

Local News Feed

RESTAURANTS

Organizations around Rose City

Rose City Town Facts

School Closings View our updated school closings list.

Local Schools Find education near you.

Local Groups View all the organizations in your community.

Businesses VFind popular businesses near you.

Jobs Looking to work locally? Try these listings we found.

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.

School Closings
View our updated school closings list.

Local Schools
Find education near you.

Local Groups
View all the organizations in your community.

Businesses
VFind popular businesses near you.

Jobs
Looking to work locally? Try these listings we found.

20 million people
rely on AmericanTowns each year to find & share local information.