| 1 | db.towns.find( {"sef_url":"brocket-nd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"paia-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 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"paia-hi","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":[-156.3730010986328,20.904499053955078],"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(1769740347783)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769740347783)","$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 |
| 11 | db.ttd_towns.find( {"town_sef_url":"paia-hi","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":"0b599cfe2379a78a2ecef275ad8fa870"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770357599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 3 |
| 15 | db.events_cache.count( {"_id":"0b599cfe2379a78a2ecef275ad8fa870"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"0b599cfe2379a78a2ecef275ad8fa870"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"0b599cfe2379a78a2ecef275ad8fa870","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.84100000 1769740347)","created":"MongoDate(0.84100000 1769740347)"} , true) | | 0 | 0 | 1 |
| 18 | db.events_cache.find( {"_id":"6ef91616f5a455a9818d8ae00c2a864e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770616799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 3 |
| 20 | db.events_cache.count( {"_id":"6ef91616f5a455a9818d8ae00c2a864e"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"6ef91616f5a455a9818d8ae00c2a864e"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"6ef91616f5a455a9818d8ae00c2a864e","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.86200000 1769740347)","created":"MongoDate(0.86200000 1769740347)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"a52334463b0e39051423dfa31eeb3f1f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1772344799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 3 |
| 25 | db.events_cache.count( {"_id":"a52334463b0e39051423dfa31eeb3f1f"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"a52334463b0e39051423dfa31eeb3f1f"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"a52334463b0e39051423dfa31eeb3f1f","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.88200000 1769740347)","created":"MongoDate(0.88200000 1769740347)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"56e54d85844bae2834c6863fbfd2f01c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770357599)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 2 |
| 30 | db.events_cache.count( {"_id":"56e54d85844bae2834c6863fbfd2f01c"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"56e54d85844bae2834c6863fbfd2f01c"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"56e54d85844bae2834c6863fbfd2f01c","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.90100000 1769740347)","created":"MongoDate(0.90100000 1769740347)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"c6591c6ac6812d69501219b15280842a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770962399)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 3 |
| 35 | db.events_cache.count( {"_id":"c6591c6ac6812d69501219b15280842a"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"c6591c6ac6812d69501219b15280842a"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"c6591c6ac6812d69501219b15280842a","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.92300000 1769740347)","created":"MongoDate(0.92300000 1769740347)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"e2480f7871e77662c92baa03adca7f7f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770011999)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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":"e2480f7871e77662c92baa03adca7f7f"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"e2480f7871e77662c92baa03adca7f7f"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"e2480f7871e77662c92baa03adca7f7f","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.94100000 1769740347)","created":"MongoDate(0.94100000 1769740347)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"7fa584b3e7456dbad84c9aa2f4fbd338"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1772344799)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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":"7fa584b3e7456dbad84c9aa2f4fbd338"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"7fa584b3e7456dbad84c9aa2f4fbd338"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"7fa584b3e7456dbad84c9aa2f4fbd338","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.95500000 1769740347)","created":"MongoDate(0.95500000 1769740347)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"77ce9c2fce971d3081202ae094fb7f68"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770184799)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 3 |
| 50 | db.events_cache.count( {"_id":"77ce9c2fce971d3081202ae094fb7f68"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"77ce9c2fce971d3081202ae094fb7f68"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"77ce9c2fce971d3081202ae094fb7f68","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.97500000 1769740347)","created":"MongoDate(0.97500000 1769740347)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"26b680bf88fc19fa00c55c35c3914209"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1771048799)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 3 |
| 55 | db.events_cache.count( {"_id":"26b680bf88fc19fa00c55c35c3914209"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"26b680bf88fc19fa00c55c35c3914209"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"26b680bf88fc19fa00c55c35c3914209","town_sef_url":"paia-hi","data_key":["6892ce41fb5e4bed1f90b526"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":true}","modified":"MongoDate(0.99600000 1769740347)","created":"MongoDate(0.99600000 1769740347)"} , true) | | 0 | 0 | 1 |
| 58 | db.events_cache.find( {"_id":"e9d1db7d4b52859c8d9f2fb720ac233c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 59 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1771567199)"},"event_id":{"$nin":[75793616]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 38 |
| 60 | db.events_cache.count( {"_id":"e9d1db7d4b52859c8d9f2fb720ac233c"} ) | | 0 | 0 | 1 |
| 61 | db.events_cache.count( {"_id":"e9d1db7d4b52859c8d9f2fb720ac233c"} ) | | 0 | 0 | 1 |
| 62 | db.events_cache.insert( {"_id":"e9d1db7d4b52859c8d9f2fb720ac233c","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.08500000 1769740348)","created":"MongoDate(0.08500000 1769740348)"} , true) | | 0 | 0 | 1 |
| 63 | db.events_cache.find( {"_id":"13b601c5bf85a42c2e8b5f0bba0c5d0a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 64 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1771567199)"},"event_id":{"$nin":[75793616]},"tags":"music","geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 7 |
| 65 | db.events_cache.count( {"_id":"13b601c5bf85a42c2e8b5f0bba0c5d0a"} ) | | 0 | 0 | 1 |
| 66 | db.events_cache.count( {"_id":"13b601c5bf85a42c2e8b5f0bba0c5d0a"} ) | | 0 | 0 | 1 |
| 67 | db.events_cache.insert( {"_id":"13b601c5bf85a42c2e8b5f0bba0c5d0a","town_sef_url":"paia-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-156.3730010986328,20.904499053955078],\"has_next_page\":false}","modified":"MongoDate(0.11300000 1769740348)","created":"MongoDate(0.11300000 1769740348)"} , true) | | 0 | 0 | 1 |
| 68 | db.places.find( {"geo":{"$near":[-156.3730010986328,20.904499053955078],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 47 | 2 |
| 69 | 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-french-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\/french-restaurants\/\" target=\"_blank\">7 Best French 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\/french-restaurants\/\" target=\"_blank\">Cafe des Amis, Paia, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-shannen,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">When is a pancake not a pancake? When it’s a crepe. And crepes — sweet and savory — highlight the fare here. This compact restaurant is open for lunch and dinner and provides a… <a href=\"https:\/\/bestthingshi.com\/french-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-themed-bars-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/theme-bars\/\" target=\"_blank\">The Best Theme Bars 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\/theme-bars\/\" target=\"_blank\">Paia Bay Coffee & Bar, Paia, 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\">Part coffee shop, part cocktail bar, part restaurant, Paia Bay Coffee & Bar is tucked away “in the heart of Paia Town.” A gathering place for local artists and surfers, this space… <a href=\"https:\/\/bestthingshi.com\/theme-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\/hi-antique-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/antique-stores\/\" target=\"_blank\">7 Best Antique 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\/antique-stores\/\" target=\"_blank\">Indigo Paia, 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\">This husband and wife team carefully curate artwork and fashion items at their small boutique in Paia. A bit more expensive than many other spots on their list, many items arrive from India and other… <a href=\"https:\/\/bestthingshi.com\/antique-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\">Paia Inn, Paia, 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\"><p>If you’re looking for a chic Hawaiian paradise, Paia Inn is the perfect place to book. It has the look of a cozy cottage but all the amenities of a luxury hotel.<\/p> <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-seafood-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/seafood-restaurants\/\" target=\"_blank\">The 10 Best Seafood 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\/seafood-restaurants\/\" target=\"_blank\">Mama\u2019s Fish House Restaurant & Inn, Paia, 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\">This beachfront, family-owned restaurant and inn serves locally-caught seafood in outdoor and indoor dining spaces decorated to reflect Hawaii’s incredible natural diversity. The owners… <a href=\"https:\/\/bestthingshi.com\/seafood-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-bike-shops-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bike-shops\/\" target=\"_blank\">7 Best Bike 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\/bike-shops\/\" target=\"_blank\">Maui Cyclery, Paia, 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\">This sleek shop is located in a quaint Maui beach town, perfect for strapping your surfboard to your bicycle and riding down to the beach for an early surf session. On your way through the town,… <a href=\"https:\/\/bestthingshi.com\/bike-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-margaritas-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/margaritas\/\" target=\"_blank\">7 Best Places for Margaritas 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\/margaritas\/\" target=\"_blank\">Milagros Food Company, Paia, 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\">Milagros Food Company offers nine different margarita options all served to your preference of either blended or on the rocks, or salted or sugared rim. One of the several standout margarita options… <a href=\"https:\/\/bestthingshi.com\/margaritas\/\" 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-indian-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\/indian-food\/\" target=\"_blank\">The Best Indian 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\/indian-food\/\" target=\"_blank\">Caf\u00e9 des Amis, Paia, 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\">Café des Amis is a unique restaurant that offers an extremely varied selection of dishes on their menu, with a particular focus on Italian, Indian, and French food. For those ordering Indian,… <a href=\"https:\/\/bestthingshi.com\/indian-food\/\" 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-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\/restaurants\/\" target=\"_blank\">12 Best 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\/restaurants\/\" target=\"_blank\">Flatbread Company, Paia, 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\">In a town filled with character and charm, Flatbread Company is the crown jewel. You can expect wood-fired pizzas made with organic ingredients and free-range meats all cooked in traditional clay… <a href=\"https:\/\/bestthingshi.com\/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-gelato-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/gelato\/\" target=\"_blank\">The 8 Best Spots for Gelato 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\/gelato\/\" target=\"_blank\">Paia Gelato, Paia, 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\">Go big at Paia Gelato and order a large, which gets you three flavors of gelato in a cup. Sample their sparkling dragonfruit gelato, or perhaps try stracciatella. Whatever you decide, you know the… <a href=\"https:\/\/bestthingshi.com\/gelato\/\" 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":"paia-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":1769747547,"type":"Event","id":75793616,"title":"Broadway\u2019s Eric Gilliom - White Hawaiian","url":"\/event\/broadways-eric-gilliom-white-hawaiian-2026-02-01-kihei-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.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":1769769148,"type":"Place","id":1433877,"title":"Maui Nui Botanical Gardens","url":"\/place\/maui-nui-botanical-gardens-kahului-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-botanical-garden-7.jpg"}],"modified":"MongoDate(0.12500000 1769740348)","created":"MongoDate(0.12500000 1769740348)","_id":ObjectId ("697c183cf4b6f8fe9a012808")} , true) | | 0 | 0 | 1 |
| 70 | db.events_cache.find( {"_id":"0ea63075e238854b54e52b2c340a4fd5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 71 | db.events_radius_cache.find( {"_id":"779618ef5026a881511f28ffaf915820"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 72 | db.events.count( {"address.town_sef_url":"paia-hi","start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770271200)"}} ) | | 0 | 0 | 1 |
| 73 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} ) | | 0 | 0 | 21 |
| 74 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} ) | | 0 | 1 | 20 |
| 75 | db.events_radius_cache.count( {"_id":"779618ef5026a881511f28ffaf915820"} ) | | 0 | 0 | 1 |
| 76 | db.events_radius_cache.count( {"_id":"779618ef5026a881511f28ffaf915820"} ) | | 0 | 0 | 1 |
| 77 | db.events_radius_cache.insert( {"_id":"779618ef5026a881511f28ffaf915820","radius":25,"modified":"MongoDate(0.18900000 1769740348)","created":"MongoDate(0.18900000 1769740348)"} , true) | | 0 | 0 | 1 |
| 78 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"event_id":{"$nin":[75793616]},"geo":{"$geoWithin":{"$center":[[-156.3730010986328,20.904499053955078],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 | 4 |
| 79 | db.events_cache.count( {"_id":"0ea63075e238854b54e52b2c340a4fd5"} ) | | 0 | 0 | 1 |
| 80 | db.events_cache.count( {"_id":"0ea63075e238854b54e52b2c340a4fd5"} ) | | 0 | 0 | 1 |
| 81 | db.events_cache.insert( {"_id":"0ea63075e238854b54e52b2c340a4fd5","town_sef_url":"paia-hi","data_key":["689c08befb5e4bed1f1f9a3c","689c08befb5e4bed1f1f9bc3","68a5d7dac3af739f256e8835","68a5433ffb5e4bed1febcc9a","68ae4c87c3af739f25822bdb"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Paia\",\"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.904499053955078,\"lng\":-156.3730010986328,\"latlng\":\"20.904499053955,-156.37300109863\",\"city\":\"Paia\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.20400000 1769740348)","created":"MongoDate(0.20400000 1769740348)"} , true) | | 0 | 0 | 1 |
| 82 | db.news.find( {"broadcast":{"$in":["usa","paia-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 |
| 83 | db.places.find( {"address.town_sef_url":"paia-hi","group_id":{"$nin":[1433877]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 84 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 85 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 86 | db.towns.find( {"sef_url":"paia-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 87 | db.tokens.find( {"sef_url":{"$in":["usa","hi","maui-county-hi","paia-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 88 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 89 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 90 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 91 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 92 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 93 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 94 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
