| 1 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 7 |
| 2 | db.towns.find( {"sef_url":"pahoa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 5 | db.ttd_towns.find( {"town_sef_url":"pahoa-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 7 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 8 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-154.94700622558594,19.49410057067871],"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(1765702930880)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765702930880)","$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 | 20 |
| 10 | db.ttd_towns.find( {"town_sef_url":"pahoa-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 11 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 12 | db.events_cache.find( {"_id":"71619ff0aaa1964d35e48371c4437c8e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 13 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766383199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 24 |
| 14 | db.events_cache.count( {"_id":"71619ff0aaa1964d35e48371c4437c8e"} ) | | 0 | 0 | 6 |
| 15 | db.events_cache.count( {"_id":"71619ff0aaa1964d35e48371c4437c8e"} ) | | 0 | 0 | 2 |
| 16 | db.events_cache.insert( {"_id":"71619ff0aaa1964d35e48371c4437c8e","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.02000000 1765702931)","created":"MongoDate(0.02000000 1765702931)"} , true) | | 0 | 0 | 1 |
| 17 | db.events_cache.find( {"_id":"202ee010b15833907388ff382e9c39e2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766642399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 18 |
| 19 | db.events_cache.count( {"_id":"202ee010b15833907388ff382e9c39e2"} ) | | 0 | 0 | 1 |
| 20 | db.events_cache.count( {"_id":"202ee010b15833907388ff382e9c39e2"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.insert( {"_id":"202ee010b15833907388ff382e9c39e2","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.06700000 1765702931)","created":"MongoDate(0.06700000 1765702931)"} , true) | | 0 | 0 | 1 |
| 22 | db.events_cache.find( {"_id":"b070de05f6bc961e4240c89432db35aa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 23 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1768370399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 44 |
| 24 | db.events_cache.count( {"_id":"b070de05f6bc961e4240c89432db35aa"} ) | | 0 | 0 | 1 |
| 25 | db.events_cache.count( {"_id":"b070de05f6bc961e4240c89432db35aa"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.insert( {"_id":"b070de05f6bc961e4240c89432db35aa","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.16600000 1765702931)","created":"MongoDate(0.16600000 1765702931)"} , true) | | 0 | 0 | 1 |
| 27 | db.events_cache.find( {"_id":"460b4b925b312a0fa9ed6687480613a8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 28 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766383199)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 |
| 29 | db.events_cache.count( {"_id":"460b4b925b312a0fa9ed6687480613a8"} ) | | 0 | 0 | 1 |
| 30 | db.events_cache.count( {"_id":"460b4b925b312a0fa9ed6687480613a8"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.insert( {"_id":"460b4b925b312a0fa9ed6687480613a8","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.18900000 1765702931)","created":"MongoDate(0.18900000 1765702931)"} , true) | | 0 | 0 | 1 |
| 32 | db.events_cache.find( {"_id":"99af91f13a82db84d0f19c2080e8be7a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 33 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766987999)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 7 |
| 34 | db.events_cache.count( {"_id":"99af91f13a82db84d0f19c2080e8be7a"} ) | | 0 | 0 | 1 |
| 35 | db.events_cache.count( {"_id":"99af91f13a82db84d0f19c2080e8be7a"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.insert( {"_id":"99af91f13a82db84d0f19c2080e8be7a","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.21700000 1765702931)","created":"MongoDate(0.21700000 1765702931)"} , true) | | 0 | 0 | 1 |
| 37 | db.events_cache.find( {"_id":"a0e5138f0a9c6bd1bf087dedf3e2d1e7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766037599)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 |
| 39 | db.events_cache.count( {"_id":"a0e5138f0a9c6bd1bf087dedf3e2d1e7"} ) | | 0 | 0 | 1 |
| 40 | db.events_cache.count( {"_id":"a0e5138f0a9c6bd1bf087dedf3e2d1e7"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.insert( {"_id":"a0e5138f0a9c6bd1bf087dedf3e2d1e7","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.23300000 1765702931)","created":"MongoDate(0.23300000 1765702931)"} , true) | | 0 | 0 | 1 |
| 42 | db.events_cache.find( {"_id":"a42ec9375cb9f56c8f530a35d2023b62"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 43 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1768370399)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 2 |
| 44 | db.events_cache.count( {"_id":"a42ec9375cb9f56c8f530a35d2023b62"} ) | | 0 | 0 | 1 |
| 45 | db.events_cache.count( {"_id":"a42ec9375cb9f56c8f530a35d2023b62"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.insert( {"_id":"a42ec9375cb9f56c8f530a35d2023b62","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.25000000 1765702931)","created":"MongoDate(0.25000000 1765702931)"} , true) | | 0 | 0 | 1 |
| 47 | db.events_cache.find( {"_id":"cf29241fb96e9fb9fe268c2fc5000102"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 48 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766210399)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 19 |
| 49 | db.events_cache.count( {"_id":"cf29241fb96e9fb9fe268c2fc5000102"} ) | | 0 | 0 | 1 |
| 50 | db.events_cache.count( {"_id":"cf29241fb96e9fb9fe268c2fc5000102"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.insert( {"_id":"cf29241fb96e9fb9fe268c2fc5000102","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.29900000 1765702931)","created":"MongoDate(0.29900000 1765702931)"} , true) | | 0 | 0 | 1 |
| 52 | db.events_cache.find( {"_id":"28e343808fc35bcae196a78506b8f907"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 53 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1767074399)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 1 | 38 |
| 54 | db.events_cache.count( {"_id":"28e343808fc35bcae196a78506b8f907"} ) | | 0 | 0 | 1 |
| 55 | db.events_cache.count( {"_id":"28e343808fc35bcae196a78506b8f907"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.insert( {"_id":"28e343808fc35bcae196a78506b8f907","town_sef_url":"pahoa-hi","data_key":["6900a16ff957a70c3306dd68"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.40000000 1765702931)","created":"MongoDate(0.40000000 1765702931)"} , true) | | 0 | 0 | 1 |
| 57 | db.events_cache.find( {"_id":"8e486b73a3bf275e195b40894c9f08f3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 58 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1767592799)"},"event_id":{"$nin":[76281178]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 37 |
| 59 | db.events_cache.count( {"_id":"8e486b73a3bf275e195b40894c9f08f3"} ) | | 0 | 0 | 1 |
| 60 | db.events_cache.count( {"_id":"8e486b73a3bf275e195b40894c9f08f3"} ) | | 0 | 0 | 1 |
| 61 | db.events_cache.insert( {"_id":"8e486b73a3bf275e195b40894c9f08f3","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.50200000 1765702931)","created":"MongoDate(0.50200000 1765702931)"} , true) | | 0 | 0 | 1 |
| 62 | db.events_cache.find( {"_id":"03a030cd186d2c7815571a03d3ddb03e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 63 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1767592799)"},"event_id":{"$nin":[76281178]},"tags":"music","geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 15 |
| 64 | db.events_cache.count( {"_id":"03a030cd186d2c7815571a03d3ddb03e"} ) | | 0 | 0 | 1 |
| 65 | db.events_cache.count( {"_id":"03a030cd186d2c7815571a03d3ddb03e"} ) | | 0 | 0 | 1 |
| 66 | db.events_cache.insert( {"_id":"03a030cd186d2c7815571a03d3ddb03e","town_sef_url":"pahoa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-154.94700622558594,19.49410057067871],\"has_next_page\":false}","modified":"MongoDate(0.54400000 1765702931)","created":"MongoDate(0.54400000 1765702931)"} , true) | | 0 | 0 | 1 |
| 67 | db.places.find( {"geo":{"$near":[-154.94700622558594,19.49410057067871],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 12 | 2 |
| 68 | 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-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai 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\/thai-restaurants\/\" target=\"_blank\">Ning\u2019s Thai Cuisine, Pahoa, HI<\/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\">Ning’s Thai Cuisine is said to be the most authentic Thai restaurant on the Big Island. Their best-rated dishes are Som Tum and Sweet Basil Seafood Stir Fry. They offer dine-in and takeout… <a href=\"https:\/\/bestthingshi.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\/hi-hair-salons-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" target=\"_blank\">10 Best Hair Salons 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\/hair-salons\/\" target=\"_blank\">Synergy Hair Salon, P\u0101hoa, 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\">From the moment you walk into Synergy Hair Salon, you’ll feel like family. This local salon offers barbershop services as well as hair salon services, making it the best place for anyone who… <a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" 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\">Bryan Booth Fine Furniture Antiques & Restoration, Hilo, 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\">If you’re on the hunt for something truly unique for your home, you can find one-of-a-kind treasures at Bryan Booth Fine Furniture. Hawaiian local Bryan Booth is constantly on a quest for… <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-unique-hotels-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/unique-hotels\/\" target=\"_blank\">10 Most Unique Hotels 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\/unique-hotels\/\" target=\"_blank\">The Bali House and Cottage, Kehena, 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\">For many, privacy is the ultimate treat when they go on vacation. If that sounds like a dream to you, head to The Bali House and Cottage along Kehena Beach. This charming rental gives you the space… <a href=\"https:\/\/bestthingshi.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\/hi-boat-tour-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/boat-tours\/\" target=\"_blank\">The 10 Best Boat Tours 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\/boat-tours\/\" target=\"_blank\">Kalapana Cultural Tours, Pahoa, 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\">Kalapana Cultural Tours takes adventurers ages 10 to 65 on a U.S. Coast Guard approved passenger boat to see lava flowing into the ocean. Two tours are available daily—departures at 4 a.m. and… <a href=\"https:\/\/bestthingshi.com\/boat-tours\/\" 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-milkshakes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/milkshakes\/\" target=\"_blank\">7 Best Places for Milkshakes 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\/milkshakes\/\" target=\"_blank\">Da Hawaiian Brain Freeze, Hilo, 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\">This small shop attracts locals, beachgoers and event attendees galore. With a shop based around cold desserts, this is the place to get a shake. Whether you go with their famous ube-pia shake, which… <a href=\"https:\/\/bestthingshi.com\/milkshakes\/\" 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\">Cafe Pesto, Hilo, 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\">Sometimes the best things come in small packages, and that’s the case at Cafe Pesto. This intimate Italian restaurant in Hilo serves up some of the most amazing pasta and saffron risotto… <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-comedy-clubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/comedy-clubs\/\" target=\"_blank\">6 Best Comedy Clubs 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\/comedy-clubs\/\" target=\"_blank\">Hilo Town Tavern, Hilo, 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\">Hilo Town Tavern is the place to see live comedy in Hilo. The atmosphere is a bit more like a dive, but with good food and great vibes. Acts ranging from local to famous from the islands and beyond… <a href=\"https:\/\/bestthingshi.com\/comedy-clubs\/\" 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-cooking-classes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/cooking-classes\/\" target=\"_blank\">10 Best Cooking Classes 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\/cooking-classes\/\" target=\"_blank\">Kulaniapia Farms, Hilo, HI<\/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\">The crew at Kulaniapia Farms is passionate about plant-based foods and about spreading the tastiness and healthfulness of these foods. They do exactly this through their expert cooking classes,… <a href=\"https:\/\/bestthingshi.com\/cooking-classes\/\" 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-fried-chicken-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">10 Best Fried Chicken Joints in Hawaii for 2025!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">Asami\u2019s Kitchen, Hilo, 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\">Asami’s Kitchen is a unique and beloved local restaurant that is an okazuya, a deli-style restaurant. Along with plenty of traditional favorites, this long-standing Hilo institution serves up… <a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" 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":"pahoa-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\":\"15\",\"days\":\"15\",\"ttl\":\"2\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1765710131,"type":"Event","id":76281178,"title":"Makers Market Hui","url":"\/event\/makers-market-hui-2025-12-21-pahoa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-2.jpg"},{"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":1765731731,"type":"Place","id":2214025,"title":"Hala Festival","url":"\/place\/hala-festival-pahoa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-2.jpg"}],"modified":"MongoDate(0.55500000 1765702931)","created":"MongoDate(0.55500000 1765702931)","_id":ObjectId ("693e7d13a016a618da09eb76")} , true) | | 0 | 0 | 1 |
| 69 | db.events_cache.find( {"_id":"ac632f8a636a31796291ae833725cffe"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 70 | db.events_radius_cache.find( {"_id":"c0424fe70876fc01ada29d0ff098620a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 71 | db.events.count( {"address.town_sef_url":"pahoa-hi","start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766296800)"}} ) | | 0 | 1 | 1 |
| 72 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} ) | | 0 | 3 | 43 |
| 73 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} ) | | 0 | 3 | 40 |
| 74 | db.events_radius_cache.count( {"_id":"c0424fe70876fc01ada29d0ff098620a"} ) | | 0 | 0 | 1 |
| 75 | db.events_radius_cache.count( {"_id":"c0424fe70876fc01ada29d0ff098620a"} ) | | 0 | 0 | 1 |
| 76 | db.events_radius_cache.insert( {"_id":"c0424fe70876fc01ada29d0ff098620a","radius":25,"modified":"MongoDate(0.66400000 1765702931)","created":"MongoDate(0.66400000 1765702931)"} , true) | | 0 | 0 | 1 |
| 77 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"event_id":{"$nin":[76281178]},"geo":{"$geoWithin":{"$center":[[-154.94700622558594,19.49410057067871],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 | 3 | 3 |
| 78 | db.events_cache.count( {"_id":"ac632f8a636a31796291ae833725cffe"} ) | | 0 | 0 | 20 |
| 79 | db.events_cache.count( {"_id":"ac632f8a636a31796291ae833725cffe"} ) | | 0 | 0 | 5 |
| 80 | db.events_cache.insert( {"_id":"ac632f8a636a31796291ae833725cffe","town_sef_url":"pahoa-hi","data_key":["68527c8ffb5e4bed1f027bfe","685bb75cfb5e4bed1fb6a9e7","6864f189fb5e4bed1f3a1693"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Pahoa\",\"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\":19.49410057067871,\"lng\":-154.94700622558594,\"latlng\":\"19.494100570679,-154.94700622559\",\"city\":\"Pahoa\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.72000000 1765702931)","created":"MongoDate(0.72000000 1765702931)"} , true) | | 0 | 0 | 10 |
| 81 | db.news.find( {"broadcast":{"$in":["usa","pahoa-hi","hi","hawaii-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 50 |
| 82 | db.places.find( {"address.town_sef_url":"pahoa-hi","group_id":{"$nin":[2214025]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 9 |
| 83 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 5 |
| 84 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 85 | db.towns.find( {"sef_url":"pahoa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 86 | db.tokens.find( {"sef_url":{"$in":["usa","hi","hawaii-county-hi","pahoa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 87 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 88 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 89 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 90 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 91 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 92 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 3 |
| 93 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
