| 1 | db.towns.find( {"sef_url":"overland-park-ks"}, [] ).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":"puunene-hi"}, [] ).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 | 2 |
| 6 | db.ttd_towns.find( {"town_sef_url":"puunene-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 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 | 2 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-156.45199584960938,20.862899780273438],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"HI"}}},{"$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(1766279907343)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766279907343)","$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 | 27 |
| 11 | db.ttd_towns.find( {"town_sef_url":"puunene-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 9 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"2d6e80ac71a6261142d3e9ffe6308e0a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766901599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 19 |
| 15 | db.events_cache.count( {"_id":"2d6e80ac71a6261142d3e9ffe6308e0a"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"2d6e80ac71a6261142d3e9ffe6308e0a"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"2d6e80ac71a6261142d3e9ffe6308e0a","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.44200000 1766279907)","created":"MongoDate(0.44200000 1766279907)"} , true) | | 0 | 0 | 1 |
| 18 | db.events_cache.find( {"_id":"97ff7ff9dec9d63829c6c97e54dab083"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767160799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 22 |
| 20 | db.events_cache.count( {"_id":"97ff7ff9dec9d63829c6c97e54dab083"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"97ff7ff9dec9d63829c6c97e54dab083"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"97ff7ff9dec9d63829c6c97e54dab083","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.50300000 1766279907)","created":"MongoDate(0.50300000 1766279907)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"69e4290103ec8ff73bd6e466baca8427"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1768888799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 60 |
| 25 | db.events_cache.count( {"_id":"69e4290103ec8ff73bd6e466baca8427"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"69e4290103ec8ff73bd6e466baca8427"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"69e4290103ec8ff73bd6e466baca8427","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.63700000 1766279907)","created":"MongoDate(0.63700000 1766279907)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"1e50f91a8a597afc9d54f5431fef3e6b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766901599)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 0 | 6 |
| 30 | db.events_cache.count( {"_id":"1e50f91a8a597afc9d54f5431fef3e6b"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"1e50f91a8a597afc9d54f5431fef3e6b"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"1e50f91a8a597afc9d54f5431fef3e6b","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.66500000 1766279907)","created":"MongoDate(0.66500000 1766279907)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"e09a72a93e114d3d9565dcafc35da6f3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767506399)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 6 |
| 35 | db.events_cache.count( {"_id":"e09a72a93e114d3d9565dcafc35da6f3"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"e09a72a93e114d3d9565dcafc35da6f3"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"e09a72a93e114d3d9565dcafc35da6f3","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.69000000 1766279907)","created":"MongoDate(0.69000000 1766279907)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"421980c8d4bb14b9abf71b599189412c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766555999)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 |
| 40 | db.events_cache.count( {"_id":"421980c8d4bb14b9abf71b599189412c"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"421980c8d4bb14b9abf71b599189412c"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"421980c8d4bb14b9abf71b599189412c","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.70700000 1766279907)","created":"MongoDate(0.70700000 1766279907)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"c6c8003a90c035fc926362a0207ab65c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1768888799)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 |
| 45 | db.events_cache.count( {"_id":"c6c8003a90c035fc926362a0207ab65c"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"c6c8003a90c035fc926362a0207ab65c"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"c6c8003a90c035fc926362a0207ab65c","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.72300000 1766279907)","created":"MongoDate(0.72300000 1766279907)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"3ea4d823aee1dd4ed7a8560d34837249"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766728799)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 13 |
| 50 | db.events_cache.count( {"_id":"3ea4d823aee1dd4ed7a8560d34837249"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"3ea4d823aee1dd4ed7a8560d34837249"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"3ea4d823aee1dd4ed7a8560d34837249","town_sef_url":"puunene-hi","data_key":["685bb775fb5e4bed1fb6dae2"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.76300000 1766279907)","created":"MongoDate(0.76300000 1766279907)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"c65a6173ef51d57a3fe3c298447b175b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1768111199)"},"event_id":{"$nin":[75793610]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 33 | 42 |
| 55 | db.events_cache.count( {"_id":"c65a6173ef51d57a3fe3c298447b175b"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"c65a6173ef51d57a3fe3c298447b175b"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"c65a6173ef51d57a3fe3c298447b175b","town_sef_url":"puunene-hi","data_key":["689d5a3efb5e4bed1f4b017e","689d5a3efb5e4bed1f4b01f7","68e86e1ec3af739f25218ea7","68a2a04cfb5e4bed1fbe5471","68a2a04cfb5e4bed1fbe5483","68a2a04cfb5e4bed1fbe5491","68a2a04cfb5e4bed1fbe54a8","690ab51cde4ae56f5a840ed7","690ab51cde4ae56f5a840f0c","69266493de4ae56f5ae4877a","69266493de4ae56f5ae48797","690ab51cde4ae56f5a840f68","690ab51cde4ae56f5a840f77","690c0697de4ae56f5a9c0c24","690c0697de4ae56f5a9c0c3a","690c0697de4ae56f5a9c0c4f","690c0698de4ae56f5a9c0cd5","69460892de4ae56f5aeccf58","6917e415de4ae56f5a8ffbe0","6917e415de4ae56f5a8ffbea","6917e415de4ae56f5a8ffbed","6917e415de4ae56f5a8ffc19","6895714afb5e4bed1fd7728d","6895714afb5e4bed1fd772b7","6895714afb5e4bed1fd772c6","691d2a15de4ae56f5a437536","690c0698de4ae56f5a9c0d61","690c0698de4ae56f5a9c0d6a","690ab51cde4ae56f5a8411a1","68f84020c3af739f25dff23c","68f84020c3af739f25dff28f","68f84020c3af739f25dff332","68f84020c3af739f25dff38f"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.87500000 1766279907)","created":"MongoDate(0.87500000 1766279907)"} , true) | | 0 | 0 | 1 |
| 58 | db.events_cache.find( {"_id":"c598c663aeca45656f358772ee26bf8b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1768111199)"},"event_id":{"$nin":[75793610,76300283]},"tags":"music","geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 0 | 22 |
| 60 | db.events_cache.count( {"_id":"c598c663aeca45656f358772ee26bf8b"} ) | | 0 | 0 | 1 |
| 61 | db.events_cache.count( {"_id":"c598c663aeca45656f358772ee26bf8b"} ) | | 0 | 0 | 1 |
| 62 | db.events_cache.insert( {"_id":"c598c663aeca45656f358772ee26bf8b","town_sef_url":"puunene-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-156.45199584960938,20.862899780273438],\"has_next_page\":false}","modified":"MongoDate(0.92700000 1766279907)","created":"MongoDate(0.92700000 1766279907)"} , true) | | 0 | 0 | 6 |
| 63 | db.places.find( {"geo":{"$near":[-156.45199584960938,20.862899780273438],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 2 |
| 64 | 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\/hi-piercing-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" target=\"_blank\">10 Best Piercing Shops in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" target=\"_blank\">Queen of Hearts, Kahului, HI<\/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\">Don’t settle for anything less than royalty for your next piercing; go to Queen of Hearts. This Kahului shop is the local go-to for piercings and tattoos alike, with high-quality jewelry and a… <a href=\"https:\/\/bestthingshi.com\/piercing-shops\/\" 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\/hi-italian-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/italian-restaurants\/\" target=\"_blank\">9 Best Italian Restaurants in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/italian-restaurants\/\" target=\"_blank\">Marco\u2019s Grill and Deli, Kahului, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">For 30 years, Marco’s Grill and Deli has been a destination in Kahului for fantastic Italian food and it remains so today. This fun and unpretentious restaurant is perfect for a casual dinner… <a href=\"https:\/\/bestthingshi.com\/italian-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\/hi-cake-shop-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/cake-shops\/\" target=\"_blank\">7 Best Cake Shops in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/cake-shops\/\" target=\"_blank\">Sweet on Maui, Kahului, HI<\/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\">Are you feeling sweet on Maui? It’s hard for anyone not to fall in love with the idyllic island, especially after you’ve tasted the cakes in this local shop. Sweet on Maui bakes up… <a href=\"https:\/\/bestthingshi.com\/cake-shops\/\" 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\/hi-noodle-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/noodles\/\" target=\"_blank\">8 Best Noodle Places in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/noodles\/\" target=\"_blank\">Tin Roof Maui, Kahului, HI<\/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\">Tin Roof is a bright and airy family owned business that offers really affordable meals that definitely don’t skimp on flavor. Mains can be made with rice or garlic noodles, depending on your… <a href=\"https:\/\/bestthingshi.com\/noodles\/\" 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\/hi-live-theater-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/live-theater\/\" target=\"_blank\">9 Best Live Theater Venues in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/live-theater\/\" target=\"_blank\">Maui OnStage, Wailuku, HI<\/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\">Voted \u201cBest Live Theater\u201d on Maui, this theater opened in 1928 and has Spanish Mission-style architecture. The theater also hosts classes, workshops and one night only events, so make sure to check… <a href=\"https:\/\/bestthingshi.com\/live-theater\/\" 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\/hi-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:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">10 Best Rainy Day Activities in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">Maui Ocean Center, Wailuku, HI<\/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\">You don’t have to go diving or snorkeling to connect with Hawaii’s ocean life. Enjoy the turtle lagoon, learn about the humpbacks of Hawaii, and immerse yourself in the shark tunnel at… <a href=\"https:\/\/bestthingshi.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\/hi-historic-theaters-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/historic-theaters\/\" target=\"_blank\">The 6 Best Historic Theaters in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/historic-theaters\/\" target=\"_blank\">Iao Theater, Wailuku, HI<\/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\">Iao Theater follows the architectural style of Spanish Mission, with a large front balcony featuring prominently on the façade. The theater was built in 1928 and once held performances by… <a href=\"https:\/\/bestthingshi.com\/historic-theaters\/\" 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\/hi-hardware-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hardware-stores\/\" target=\"_blank\">6 Best Hardware Stores in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/hardware-stores\/\" target=\"_blank\">Bamboo Maui, Wailuku, HI<\/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\">Approximately 20 years ago, Bamboo Maui opened as the first locally-owned business to sell bamboo floor, ceiling paneling, and other bamboo goods. To help install your new bamboo floor, they also… <a href=\"https:\/\/bestthingshi.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\/hi-furniture-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/furniture-stores\/\" target=\"_blank\">10 Best Furniture Stores in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/furniture-stores\/\" target=\"_blank\">Kimo\u2019s Furniture, Kahului, HI<\/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\">Kimo’s Furniture is a popular favorite on Maui, and for plenty of good reasons. For one, it carries a wide selection of high-quality furniture that’s in stock and ready to enhance your… <a href=\"https:\/\/bestthingshi.com\/furniture-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\/hi-public-golf-courses-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/public-golf-courses\/\" target=\"_blank\">9 Best Public Golf Courses in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/public-golf-courses\/\" target=\"_blank\">Kahili Golf Course, Wailuku, HI<\/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 golf course is a good value for teeing off on Maui. Value doesn’t mean skimping, though. You’ll enjoy fully outfitted carts with GPS and touch screen ability. The course is… <a href=\"https:\/\/bestthingshi.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<\/div>\n<\/div>\n\n\n","town_sef_url":"puunene-hi","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_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":1766283507,"type":"Event","id":75793610,"title":"Broadway\u2019s Eric Gilliom - White Hawaiian","url":"\/event\/broadways-eric-gilliom-white-hawaiian-2025-12-21-kihei-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.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":1766294307,"type":"Event","id":76300283,"title":"Sammy Johnson","url":"\/event\/sammy-johnson-1-2025-12-29-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/28\/03\/73_Edp.jpg?v=6"},{"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":1766308707,"type":"Place","id":1699994,"title":"Made in Maui County Festival","url":"\/place\/made-in-maui-county-festival-kahului-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-2.jpg"}],"modified":"MongoDate(0.94900000 1766279907)","created":"MongoDate(0.94900000 1766279907)","_id":ObjectId ("69474ae368c873c7c80b60b4")} , true) | | 0 | 0 | 1 |
| 65 | db.events_cache.find( {"_id":"5505980428c365c5b781cc410c16b02e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 66 | db.events_radius_cache.find( {"_id":"fe1b1a41f3d3096a73d38c530c3a1af8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 67 | db.events.count( {"address.town_sef_url":"puunene-hi","start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766815200)"}} ) | | 0 | 0 | 5 |
| 68 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} ) | | 0 | 0 | 49 |
| 69 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} ) | | 0 | 4 | 39 |
| 70 | db.events_radius_cache.count( {"_id":"fe1b1a41f3d3096a73d38c530c3a1af8"} ) | | 0 | 0 | 1 |
| 71 | db.events_radius_cache.count( {"_id":"fe1b1a41f3d3096a73d38c530c3a1af8"} ) | | 0 | 0 | 4 |
| 72 | db.events_radius_cache.insert( {"_id":"fe1b1a41f3d3096a73d38c530c3a1af8","radius":25,"modified":"MongoDate(0.10000000 1766279908)","created":"MongoDate(0.10000000 1766279908)"} , true) | | 0 | 0 | 10 |
| 73 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"event_id":{"$nin":[75793610,76300283]},"geo":{"$geoWithin":{"$center":[[-156.45199584960938,20.862899780273438],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 | 343 |
| 74 | db.events_cache.count( {"_id":"5505980428c365c5b781cc410c16b02e"} ) | | 0 | 0 | 1 |
| 75 | db.events_cache.count( {"_id":"5505980428c365c5b781cc410c16b02e"} ) | | 0 | 0 | 1 |
| 76 | db.events_cache.insert( {"_id":"5505980428c365c5b781cc410c16b02e","town_sef_url":"puunene-hi","data_key":["685a658efb5e4bed1f655a55","68639fdefb5e4bed1fa5baa2","6864f19bfb5e4bed1f3a3e1c","686e2c04fb5e4bed1fcfb084","68776670fb5e4bed1fb4d557"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Puunene\",\"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\":20.862899780273438,\"lng\":-156.45199584960938,\"latlng\":\"20.862899780273,-156.45199584961\",\"city\":\"Puunene\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.47500000 1766279908)","created":"MongoDate(0.47500000 1766279908)"} , true) | | 0 | 0 | 1 |
| 77 | db.news.find( {"broadcast":{"$in":["usa","puunene-hi","hi","maui-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 78 | db.places.find( {"address.town_sef_url":"puunene-hi","group_id":{"$nin":[1699994]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 1 | 1 |
| 79 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 80 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 81 | db.towns.find( {"sef_url":"puunene-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 82 | db.tokens.find( {"sef_url":{"$in":["usa","hi","maui-county-hi","puunene-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 83 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 84 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 85 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 86 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 87 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 88 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 89 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
