| 1 | db.towns.find( {"sef_url":"waialua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.ttd_towns.find( {"town_sef_url":"waialua-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 3 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-158.1269989013672,21.573699951171875],"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(1761800985176)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761800985176)","$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 | 48 |
| 5 | db.ttd_towns.find( {"town_sef_url":"waialua-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 7 | db.events_cache.find( {"_id":"b5fd972574ad2f5d75b913bab61ba6b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 |
| 9 | db.events_cache.count( {"_id":"b5fd972574ad2f5d75b913bab61ba6b1"} ) | | 0 | 0 | 1 |
| 10 | db.events_cache.insert( {"_id":"b5fd972574ad2f5d75b913bab61ba6b1","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.29900000 1761800985)","created":"MongoDate(0.29900000 1761800985)"} , true) | | 0 | 0 | 2 |
| 11 | db.events_cache.find( {"_id":"3c1013d60e65e3e2dafefdb4b7242111"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 17 |
| 13 | db.events_cache.count( {"_id":"3c1013d60e65e3e2dafefdb4b7242111"} ) | | 0 | 0 | 2 |
| 14 | db.events_cache.insert( {"_id":"3c1013d60e65e3e2dafefdb4b7242111","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.35500000 1761800985)","created":"MongoDate(0.35500000 1761800985)"} , true) | | 0 | 0 | 2 |
| 15 | db.events_cache.find( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 16 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 17 |
| 17 | db.events_cache.count( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52"} ) | | 0 | 0 | 2 |
| 18 | db.events_cache.insert( {"_id":"f5765aacf71cc6c83d5b0ff9686c0f52","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.40600000 1761800985)","created":"MongoDate(0.40600000 1761800985)"} , true) | | 0 | 0 | 2 |
| 19 | db.events_cache.find( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 20 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 7 |
| 21 | db.events_cache.count( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"8ba344eab8fc6ee61cdd5c72f0cd7c24","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.44900000 1761800985)","created":"MongoDate(0.44900000 1761800985)"} , true) | | 0 | 0 | 2 |
| 23 | db.events_cache.find( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 132 |
| 25 | db.events_cache.count( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.insert( {"_id":"5cc45e16c5ab1e80fdc67b88a4fd096e","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.62100000 1761800985)","created":"MongoDate(0.62100000 1761800985)"} , true) | | 0 | 0 | 2 |
| 27 | db.events_cache.find( {"_id":"ecdea109d062b9ba7130020930bc8c6c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 28 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 17 |
| 29 | db.events_cache.count( {"_id":"ecdea109d062b9ba7130020930bc8c6c"} ) | | 0 | 0 | 2 |
| 30 | db.events_cache.insert( {"_id":"ecdea109d062b9ba7130020930bc8c6c","town_sef_url":"waialua-hi","data_key":["68ef91e91d742698df02e9cf"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":true}","modified":"MongoDate(0.67900000 1761800985)","created":"MongoDate(0.67900000 1761800985)"} , true) | | 0 | 0 | 2 |
| 31 | db.events_cache.find( {"_id":"6f6741331a6e5f42f640ab029a0a85d0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 32 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76240548]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],1.4492753623188406]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 51 ).skip( 0 ) | | 0 | 51 | 66 |
| 33 | db.events_cache.count( {"_id":"6f6741331a6e5f42f640ab029a0a85d0"} ) | | 0 | 0 | 1 |
| 34 | db.events_cache.insert( {"_id":"6f6741331a6e5f42f640ab029a0a85d0","town_sef_url":"waialua-hi","data_key":["68a7d4aac3af739f25821c57","68d4a79fc3af739f2544f6eb","68a7d4aac3af739f25821cbe","68a7d4aac3af739f25821d52","68a7d4aac3af739f25821e2e","6881f248fb5e4bed1fd3ac30","68b503adc3af739f2549f652","68ca1b9fc3af739f25d7e9fb","68ca1b9fc3af739f25d7eabf","68a92628c3af739f252fb232","68a92628c3af739f252fb28a","68a92628c3af739f252fb2d3","68ce1024c3af739f25eb132f","6881f24ffb5e4bed1fd3b696","68a92628c3af739f252fb3a0","6821b4e5fb5e4bed1fb5d4e0","68ca1ba0c3af739f25d7edb9","6881f252fb5e4bed1fd3ba6b","68ca1ba0c3af739f25d7ef22","68dc909cc3af739f25fd0f89","68ad1aa6c3af739f25f089a9","68dc909cc3af739f25fd109d","68ad1aa6c3af739f25f08a5c","68f1a89ac3af739f25dd52a2","68527c76fb5e4bed1f025396","68dde21cc3af739f25c550fd","682af1cdfb5e4bed1f75bc6e","68dc909cc3af739f25fd1249","68db3f1dc3af739f258524bc","682af1defb5e4bed1f75e2c6","682c412efb5e4bed1f5cfe8b","68dc909cc3af739f25fd13ab","682c4145fb5e4bed1f5d350a","682c414dfb5e4bed1f5d4480","68ca1ba1c3af739f25d7f744","68ca1ba1c3af739f25d7f845","68f0571ec3af739f25945c40","68f0571ec3af739f25945cc8","68941fbefb5e4bed1fb93603","68dc909dc3af739f25fd16da","683429fbfb5e4bed1faafc2d","6853cdebfb5e4bed1f55c504","68917cbefb5e4bed1f58ea5d","68357b80fb5e4bed1f717407","68357b9bfb5e4bed1f71ad9e","68ca1ba1c3af739f25d7fe9a","68dc909dc3af739f25fd1c19","6841595cfb5e4bed1fbab538","68ca1ba1c3af739f25d80042","68ca1ba1c3af739f25d80077"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":true}","modified":"MongoDate(0.88000000 1761800985)","created":"MongoDate(0.88000000 1761800985)"} , true) | | 0 | 0 | 2 |
| 35 | db.events_cache.find( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 36 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76240548,76093295]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 115 |
| 37 | db.events_cache.count( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781"} ) | | 0 | 0 | 2 |
| 38 | db.events_cache.insert( {"_id":"cb8b1c69ea164274c8d8d8f94dbf8781","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.1269989013672,21.573699951171875],\"has_next_page\":false}","modified":"MongoDate(0.12000000 1761800986)","created":"MongoDate(0.12000000 1761800986)"} , true) | | 0 | 0 | 2 |
| 39 | db.places.find( {"geo":{"$near":[-158.1269989013672,21.573699951171875],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 16 | 3 |
| 40 | 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-coffee-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\/coffee-shops-cafes\/\" target=\"_blank\">9 Coolest Coffee 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\/coffee-shops-cafes\/\" target=\"_blank\">Coffee Gallery, Haleiwa, 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\">Tucked inside the North Shore Marketplace sits Coffee Gallery, a cozy shop serving artisanal hand-roasted coffee from Hawaii & beyond, plus a bakery and art exhibits. Be sure to snag a spot on… <a href=\"https:\/\/bestthingshi.com\/coffee-shops-cafes\/\" 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-vegan-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\/vegan-vegetarian-restaurants\/\" target=\"_blank\">10 Best Vegan 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\/vegan-vegetarian-restaurants\/\" target=\"_blank\">The Cosmic Kitchen, Haleiwa, 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\">After just one bite from The Cosmic Kitchen, you’ll be thanking your lucky stars that you found this Haleiwa restaurant. It’s known for some of the best vegan sandwiches around, like its… <a href=\"https:\/\/bestthingshi.com\/vegan-vegetarian-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-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\">Haleiwa Store Lots, Haleiwa, 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\">Shopping is the perfect way to spend a fun and relaxed rainy day. Instead of a garden-variety mall, check out the Haleiwa Store Lots, a shopping center that’s full of local boutiques and unique… <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-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\">Rajanee Thai Cuisine, Haleiwa, 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\"><p>Rajanee Thai Cuisine is small and they don’t offer any indoor seating. But if you’re looking for amazing Thai takeout, this is one of the most popular restaurants in the area.<\/p> <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-educational-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\/educational-activities-for-kids\/\" target=\"_blank\">The 9 Best Educational Activities for Children 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\/educational-activities-for-kids\/\" target=\"_blank\">Pipeline North Shore, Haleiwa, 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\">Hawaii’s surf culture is legendary and there is no better spot to see the best in action than the beaches of Oahu’s North Shore. Check out the site for competitions and surf conditions… <a href=\"https:\/\/bestthingshi.com\/educational-activities-for-kids\/\" 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-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\">Two Thumbs Tattoo, Haleiwa, 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>Who has two thumbs and is fantastic at body piercings? The exceptional piercer at Two Thumbs Tattoo. This Haleiwa shop provides a top-quality visit every time.<\/p> <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-mexican-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\/mexican-restaurants\/\" target=\"_blank\">The 9 Best Mexican 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\/mexican-restaurants\/\" target=\"_blank\">Surf N Salsa, Haleiwa, 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 popular food truck offers both light bites and larger meals to fulfill any size of hunger pangs. For those who have built up an appetite practicing sports all day, the camarones al ajillo plate… <a href=\"https:\/\/bestthingshi.com\/mexican-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-smoothies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/smoothies\/\" target=\"_blank\">9 Best Smoothie 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\/smoothies\/\" target=\"_blank\">Haleiwa Bowls, Haleiwa, 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\">Haleiwa Bowls is as trendy as it is healthy. On the menu, you’ll find 10 different smoothies that are packed with fruits, vegetables, and protein. Menu highlights include the Dirty Paniolo,… <a href=\"https:\/\/bestthingshi.com\/smoothies\/\" 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-bakery-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bakeries\/\" target=\"_blank\">8 Best Bakeries 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\/bakeries\/\" target=\"_blank\">Ted\u2019s Bakery, Haleiwa, Oahu, 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\">During your trip to the North Shore of Oahu to watch the big surf, a stop at Ted’s Bakery is an absolute must. Ted’s bakes many different pies, including flavors that you can’t find… <a href=\"https:\/\/bestthingshi.com\/bakeries\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-thrift-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\/thrift-shops\/\" target=\"_blank\">The 6 Best Thrift 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\/thrift-shops\/\" target=\"_blank\">The Vintage Hawaii, Wahiawa, 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\">The Vintage Hawaii is a highly-curated thrift shop that, together with other local businesses, transformed the once-rundown area. In addition to transforming the neighborhood, the Vintage funds… <a href=\"https:\/\/bestthingshi.com\/thrift-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<\/div>\n<\/div>\n\n\n","town_sef_url":"waialua-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_tag\",\"searchtag\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1761804585,"type":"Event","id":76240548,"title":"MHS Holiday Food and Craft Fair","url":"\/event\/mhs-holiday-food-and-craft-fair-2025-11-22-mililani-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-2.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":1761815385,"type":"Event","id":76093295,"title":"Lettuce","url":"\/event\/lettuce-2025-11-06-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/c95\/9e8f1ccb-6a58-444b-b6b7-b0fd09f2ac95_SOURCE"},{"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":1761829786,"type":"Place","id":2079404,"title":"Tricks and Treats Fall Fest","url":"\/place\/tricks-and-treats-fall-fest-kapolei-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-1.jpg"}],"modified":"MongoDate(0.13500000 1761800986)","created":"MongoDate(0.13500000 1761800986)","_id":ObjectId ("6902f31a1830f2bde009a751")} , true) | | 0 | 0 | 2 |
| 41 | db.events_cache.find( {"_id":"a284da43eaa658c7790a33cc3769640b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 42 | db.events_radius_cache.find( {"_id":"712f196580278207467644e50a893fd6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 43 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76240548,76093295]},"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 | 25 |
| 44 | db.events_cache.count( {"_id":"a284da43eaa658c7790a33cc3769640b"} ) | | 0 | 0 | 1 |
| 45 | db.events_cache.insert( {"_id":"a284da43eaa658c7790a33cc3769640b","town_sef_url":"waialua-hi","data_key":["68172901fb5e4bed1f84b3ba","68187a91fb5e4bed1ffac1de","68187a94fb5e4bed1ffac6be","6849f0607573f1576b6af4d7","68e4b3a352e74058870042df"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Waialua\",\"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\":21.573699951171875,\"lng\":-158.1269989013672,\"latlng\":\"21.573699951172,-158.12699890137\",\"city\":\"Waialua\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.26000000 1761800986)","created":"MongoDate(0.26000000 1761800986)"} , true) | | 0 | 0 | 2 |
| 46 | db.news.find( {"broadcast":{"$in":["usa","waialua-hi","hi","honolulu-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
| 47 | db.places.find( {"address.town_sef_url":"waialua-hi","group_id":{"$nin":[2079404]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 48 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 2 |
| 49 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 50 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waialua-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
