| 1 | db.towns.find( {"sef_url":"big-indian-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"roseville-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"roseville-mi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-82.93609619140625,42.509700775146484],"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(1769840294319)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769840294319)","$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 | 60 |
| 11 | db.ttd_towns.find( {"town_sef_url":"roseville-mi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"3b8b7ba8ba10ad63fabbee3db957f263"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],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 | 35 |
| 15 | db.events_cache.count( {"_id":"3b8b7ba8ba10ad63fabbee3db957f263"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"3b8b7ba8ba10ad63fabbee3db957f263"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"3b8b7ba8ba10ad63fabbee3db957f263","town_sef_url":"roseville-mi","data_key":["68917cc1fb5e4bed1f59006f"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-82.93609619140625,42.509700775146484],\"has_next_page\":true}","modified":"MongoDate(0.45000000 1769840294)","created":"MongoDate(0.45000000 1769840294)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"1ca78d007134e63b1c898986b7d093ed"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"event_id":{"$nin":[75956732]},"tags":"music","geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],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 | 1 | 4 |
| 20 | db.events_cache.count( {"_id":"1ca78d007134e63b1c898986b7d093ed"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"1ca78d007134e63b1c898986b7d093ed"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"1ca78d007134e63b1c898986b7d093ed","town_sef_url":"roseville-mi","data_key":["69200557de4ae56f5af2d1a0"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-82.93609619140625,42.509700775146484],\"has_next_page\":false}","modified":"MongoDate(0.47500000 1769840294)","created":"MongoDate(0.47500000 1769840294)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"0fd8875d0310b4f21a410f466b7f0b04"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770184799)"},"event_id":{"$nin":[75956732,76365039]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],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 | 0 | 1 |
| 25 | db.events_cache.count( {"_id":"0fd8875d0310b4f21a410f466b7f0b04"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"0fd8875d0310b4f21a410f466b7f0b04"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"0fd8875d0310b4f21a410f466b7f0b04","town_sef_url":"roseville-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-82.93609619140625,42.509700775146484],\"has_next_page\":false}","modified":"MongoDate(0.49200000 1769840294)","created":"MongoDate(0.49200000 1769840294)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"01ab6782ae65da08ed29bc6fce3a7327"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1772517599)"},"event_id":{"$nin":[75956732,76365039]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],0.8695652173913043]}}}, ["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 | 0 | 1 |
| 30 | db.events_cache.count( {"_id":"01ab6782ae65da08ed29bc6fce3a7327"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"01ab6782ae65da08ed29bc6fce3a7327"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"01ab6782ae65da08ed29bc6fce3a7327","town_sef_url":"roseville-mi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-82.93609619140625,42.509700775146484],\"has_next_page\":false}","modified":"MongoDate(0.50900000 1769840294)","created":"MongoDate(0.50900000 1769840294)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"6131b1ae3214a44ecd1fa21b0b830e97"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770357599)"},"event_id":{"$nin":[75956732,76365039]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],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 | 1 | 11 |
| 35 | db.events_cache.count( {"_id":"6131b1ae3214a44ecd1fa21b0b830e97"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"6131b1ae3214a44ecd1fa21b0b830e97"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"6131b1ae3214a44ecd1fa21b0b830e97","town_sef_url":"roseville-mi","data_key":["68dc90a1c3af739f25fd3780"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-82.93609619140625,42.509700775146484],\"has_next_page\":false}","modified":"MongoDate(0.54200000 1769840294)","created":"MongoDate(0.54200000 1769840294)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"8c68183da3809ac353fcb7d53d7180f8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[75956732,76365039,76199326]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],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 | 17 |
| 40 | db.events_cache.count( {"_id":"8c68183da3809ac353fcb7d53d7180f8"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"8c68183da3809ac353fcb7d53d7180f8"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"8c68183da3809ac353fcb7d53d7180f8","town_sef_url":"roseville-mi","data_key":["68f991a1c3af739f2535ad95","68a3f1c4fb5e4bed1fd64c64","68d204a6c3af739f25f52a5c","69169298de4ae56f5ad4f023","68941fc1fb5e4bed1fb949c6","68df33a1c3af739f2509f497","68f84021c3af739f25e005bf","690ab51fde4ae56f5a8417ea","6938d995de4ae56f5aaaa15d","693a2b13de4ae56f5a8b0c6d","68917cc1fb5e4bed1f590306","690ab51fde4ae56f5a8417ee","68a3f1c4fb5e4bed1fd64c8c","69169298de4ae56f5ad4f04a","68917cc1fb5e4bed1f590488","68bf8fa6c3af739f25b3823b","68fed7a5c3af739f25713768","6900291dc3af739f259bb7b9","69684f9ab1faf7c56a24a76c","68f2fa20c3af739f2533e26f","68a3f1c4fb5e4bed1fd64ca3","68d204a6c3af739f25f52af1","68b7a6abc3af739f2571f82f","689eabbefb5e4bed1f7b3ffc","68fc34a1c3af739f25227067","6923c196de4ae56f5a41a84e","6938d995de4ae56f5aaaa24b","68f991a1c3af739f2535ae78","689eabbefb5e4bed1f7b4055","68b7a6abc3af739f2571f87c","68f991a1c3af739f2535ae72","6895714afb5e4bed1fd779b5","68d204a6c3af739f25f52b6b","6896c2c5fb5e4bed1f1b55b2","68ccbea9c3af739f2529562e","69572c0ede4ae56f5abd681e","68ccbea9c3af739f25295653","68f2fa20c3af739f2533e37c","69017a9cc3af739f25e4001f","689eabbefb5e4bed1f7b410a","6938d995de4ae56f5aaaa305","68ccbea9c3af739f25295687","6909639ade4ae56f5a1c0eed","6949fd12de4ae56f5aeb6c4a","68bf8fa6c3af739f25b383a4","69017a9cc3af739f25e4007b","69041d9ede4ae56f5ae0eedb","692f9f13de4ae56f5a5236d0","6930f093de4ae56f5aa6f078","6967019cb1faf7c56a6c9b15"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-82.93609619140625,42.509700775146484],\"has_next_page\":true}","modified":"MongoDate(0.58600000 1769840294)","created":"MongoDate(0.58600000 1769840294)"} , true) | | 0 | 0 | 1 |
| 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-playgrounds-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/playgrounds\/\" target=\"_blank\">The 9 Best Playgrounds 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\/playgrounds\/\" target=\"_blank\">Fort Fraser, Fraser, MI<\/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\">Hit Fraser's Steffens Park to check out one of the biggest names in castle-style play structure around: Fort Fraser. Granted, as the name suggests, it's more a fort than a castle, but there's plenty… <a href=\"https:\/\/bestthingsmi.com\/playgrounds\/\" 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-appetizers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/appetizers\/\" target=\"_blank\">7 Best Places for Appetizers 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\/appetizers\/\" target=\"_blank\">Great Baraboo, Clinton Township, 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\">At the Great Baraboo Brewery in Clinton Township, they've taken the standard mozzarella stick and turned it into something staggering. Great Baraboo actually wraps its cheese in a layer of pizza… <a href=\"https:\/\/bestthingsmi.com\/appetizers\/\" 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-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai Restaurants 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\/thai-restaurants\/\" target=\"_blank\">Som Jai Thai Cuisine, Warren, 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\">If you love pork belly and sticky rice, you'll adore Som Jai Thai Cuisine. Regulars say that even the pickiest of eaters—including toddlers—want seconds when they dine here! With a 4.9… <a href=\"https:\/\/bestthingsmi.com\/thai-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\/mi-bakery-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/bakeries\/\" target=\"_blank\">8 Best Bakeries 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\/bakeries\/\" target=\"_blank\">Vito's Bakery, Clinton Township, 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\">We've seen a lot of different bakeries over this piece, but an Italian bakery, that's something new. Vito's Bakery in Clinton Township offers a new and unexpected look at baked goods by focusing on… <a href=\"https:\/\/bestthingsmi.com\/bakeries\/\" 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-karaoke-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\/karaoke-bars\/\" target=\"_blank\">The 6 Best Karaoke Bars 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\/karaoke-bars\/\" target=\"_blank\">Tipsy McStaggers, Warren, 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\">With a name like Tipsy McStaggers, this Warren bar delivers as a high-quality karaoke establishment. This spot has karaoke every night but Sunday. Throw in the impressive array of drinks and food… <a href=\"https:\/\/bestthingsmi.com\/karaoke-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-crossfit-gym-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/crossfit\/\" target=\"_blank\">The 9 Best CrossFit Gyms 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\/crossfit\/\" target=\"_blank\">Motor City CrossFit, Sterling Heights, 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\">Motor City CrossFit has been operating just over a decade now, and it shows in the staff's training and expertise. It's also devoted to get you to come back, thanks to a clear focus on results and… <a href=\"https:\/\/bestthingsmi.com\/crossfit\/\" 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-sports-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\/sports-bars\/\" target=\"_blank\">The 9 Best Sports Bars 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\/sports-bars\/\" target=\"_blank\">Jamboozies Sports Bar and Grill, Sterling Heights, 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\">Featuring a wide array of food and drink—pretzel pizza with the beer cheese dip comes up frequently—and a 107-inch television backed up by 13 smaller screens to show all the gaming,… <a href=\"https:\/\/bestthingsmi.com\/sports-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-rainy-day-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/rainy-day-thingstodo\/\" target=\"_blank\">The 10 Best Rainy Day Activities to Do Michigan!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsmi.com\/rainy-day-thingstodo\/\" target=\"_blank\">DK BeerCade, Harrison Township, 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\">No, this isn't encouragement of casual drunkenness in the midst of terrible weather. The fact is that bars are not what they used to be. No longer dank and smoky holes, bars these days come equipped… <a href=\"https:\/\/bestthingsmi.com\/rainy-day-thingstodo\/\" 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-bubble-tea-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/bubble-tea\/\" target=\"_blank\">6 Best Bubble Tea Places 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\/bubble-tea\/\" target=\"_blank\">Kawaii Bubble Tea, Clinton Township, 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\">At the brightly-decorated and cozy Kawaii Bubble Tea, know that you'll have access to around 400 different flavor combinations. How does that sound? Choose from yummy options like honeydew, matcha,… <a href=\"https:\/\/bestthingsmi.com\/bubble-tea\/\" 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-music-venue-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsmi.com\/music-venues\/\" target=\"_blank\">The 10 Best Live Music Venues 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\/music-venues\/\" target=\"_blank\">Michigan Lottery Amphitheatre at Freedom Hill, Sterling Heights, 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\">Regarded in many ways as similar to Pine Knob Music Theatre (formerly DTE Music Energy Theatre), though located in Sterling Heights, Michigan Lottery Amphitheatre at Freedom Hill is not only operated… <a href=\"https:\/\/bestthingsmi.com\/music-venues\/\" 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":"roseville-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\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769843894,"type":"Event","id":75956732,"title":"Detroit Red Wings vs. Colorado Avalanche","url":"\/event\/detroit-red-wings-vs-colorado-avalanche-2026-01-31-tm-detroit-mi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/015\/c6fbf2ff-8115-4f25-aeae-c61bed8d2015_SOURCE"},{"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":1769843894,"type":"Event","id":76365039,"title":"The Lovin’ Spoonful","url":"\/event\/the-lovin-spoonful-2026-02-07-jb-clinton-township-mi.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2024\/11\/the-lovin8217-spoonful-980x551.png"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"10\",\"days\":\"5\",\"ttl\":\"1\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1769843894,"type":"Event","id":76199326,"title":"Thunderbeard \u2013 Tribute to ZZ Top","url":"\/event\/thunderbeard-tribute-to-zz-top-2026-01-31-tm-mount-clemens-mi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/21\/46\/43_Edp.jpg?v=22"},{"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":1769854694,"type":"Event","id":76062518,"title":"Detroit Pistons vs. Brooklyn Nets","url":"\/event\/detroit-pistons-vs-brooklyn-nets-2026-02-01-tm-detroit-mi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/9e8\/26685b57-d741-40e1-b93d-e780b38a79e8_TABLET_LANDSCAPE_LARGE_16_9.jpg"}],"modified":"MongoDate(0.58900000 1769840294)","created":"MongoDate(0.58900000 1769840294)","_id":ObjectId ("697d9ea6fe571c6bba02b9e0")} , true) | | 0 | 0 | 1 |
| 44 | db.events_cache.find( {"_id":"2ac9c25e6cfbee6ac8228d5cd3fe3edb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 45 | db.events_radius_cache.find( {"_id":"683078fa8010b65aa57bdfab23a55f49"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 46 | db.events.count( {"address.town_sef_url":"roseville-mi","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} ) | | 0 | 0 | 1 |
| 47 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 0 | 16 |
| 48 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 59 | 15 |
| 49 | db.events_radius_cache.count( {"_id":"683078fa8010b65aa57bdfab23a55f49"} ) | | 0 | 0 | 1 |
| 50 | db.events_radius_cache.count( {"_id":"683078fa8010b65aa57bdfab23a55f49"} ) | | 0 | 0 | 1 |
| 51 | db.events_radius_cache.insert( {"_id":"683078fa8010b65aa57bdfab23a55f49","radius":15,"modified":"MongoDate(0.64200000 1769840294)","created":"MongoDate(0.64200000 1769840294)"} , true) | | 0 | 0 | 1 |
| 52 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"event_id":{"$nin":[75956732,76365039,76199326,76062518]},"geo":{"$geoWithin":{"$center":[[-82.93609619140625,42.509700775146484],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( 6 ).skip( 0 ) | | 0 | 6 | 29 |
| 53 | db.events_cache.count( {"_id":"2ac9c25e6cfbee6ac8228d5cd3fe3edb"} ) | | 0 | 0 | 1 |
| 54 | db.events_cache.count( {"_id":"2ac9c25e6cfbee6ac8228d5cd3fe3edb"} ) | | 0 | 0 | 1 |
| 55 | db.events_cache.insert( {"_id":"2ac9c25e6cfbee6ac8228d5cd3fe3edb","town_sef_url":"roseville-mi","data_key":["68cb39adc4766aed420de9bc","69169298de4ae56f5ad4f023","690ab51fde4ae56f5a8417ea","6938d995de4ae56f5aaaa15d","693a2b13de4ae56f5a8b0c6d"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Roseville\",\"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\":42.509700775146484,\"lng\":-82.93609619140625,\"latlng\":\"42.509700775146,-82.936096191406\",\"city\":\"Roseville\",\"state\":\"MI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.68300000 1769840294)","created":"MongoDate(0.68300000 1769840294)"} , true) | | 0 | 0 | 1 |
| 56 | db.news.find( {"broadcast":{"$in":["usa","roseville-mi","mi","macomb-county-mi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 57 | db.places.find( {"address.town_sef_url":"roseville-mi","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 58 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 59 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 60 | db.towns.find( {"sef_url":"roseville-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 61 | db.tokens.find( {"sef_url":{"$in":["usa","mi","macomb-county-mi","roseville-mi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 62 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 63 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 64 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 65 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 66 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 67 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 68 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
