| 1 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.towns.find( {"sef_url":"waialua-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 | 3 |
| 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.towns.find( {"sef_url":"waialua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waialua-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 7 | db.ttd_towns.find( {"town_sef_url":"waialua-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | 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(1766649257427)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766649257427)","$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 | 64 |
| 10 | db.ttd_towns.find( {"town_sef_url":"waialua-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 11 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 12 | db.events_cache.find( {"_id":"94c86b2378ce5b96b92682afaa66b250"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 13 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"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 | 4 |
| 14 | db.events_cache.count( {"_id":"94c86b2378ce5b96b92682afaa66b250"} ) | | 0 | 0 | 1 |
| 15 | db.events_cache.insert( {"_id":"94c86b2378ce5b96b92682afaa66b250","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.52600000 1766649257)","created":"MongoDate(0.52600000 1766649257)"} , true) | | 0 | 0 | 2 |
| 16 | db.events_cache.find( {"_id":"c3e00e3946e8ded33726fef89e42668b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 17 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"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 | 4 |
| 18 | db.events_cache.count( {"_id":"c3e00e3946e8ded33726fef89e42668b"} ) | | 0 | 0 | 1 |
| 19 | db.events_cache.insert( {"_id":"c3e00e3946e8ded33726fef89e42668b","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.54900000 1766649257)","created":"MongoDate(0.54900000 1766649257)"} , true) | | 0 | 0 | 1 |
| 20 | db.events_cache.find( {"_id":"0c67ea1071ac3486d525836fd9e37f3b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 21 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"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 | 6 |
| 22 | db.events_cache.count( {"_id":"0c67ea1071ac3486d525836fd9e37f3b"} ) | | 0 | 0 | 1 |
| 23 | db.events_cache.insert( {"_id":"0c67ea1071ac3486d525836fd9e37f3b","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.57100000 1766649257)","created":"MongoDate(0.57100000 1766649257)"} , true) | | 0 | 0 | 1 |
| 24 | db.events_cache.find( {"_id":"5e1be8c26ae74b6f29d672db71e7bdb6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 25 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"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 | 3 |
| 26 | db.events_cache.count( {"_id":"5e1be8c26ae74b6f29d672db71e7bdb6"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"5e1be8c26ae74b6f29d672db71e7bdb6","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.58900000 1766649257)","created":"MongoDate(0.58900000 1766649257)"} , true) | | 0 | 0 | 2 |
| 28 | db.events_cache.find( {"_id":"ab4a35b7bb6667fbf69e417fdf1dbe2a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"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 | 6 |
| 30 | db.events_cache.count( {"_id":"ab4a35b7bb6667fbf69e417fdf1dbe2a"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.insert( {"_id":"ab4a35b7bb6667fbf69e417fdf1dbe2a","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.61600000 1766649257)","created":"MongoDate(0.61600000 1766649257)"} , true) | | 0 | 0 | 2 |
| 32 | db.events_cache.find( {"_id":"a1a98a1ad21391068d2b0d921ec5d0cb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 33 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"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 | 0 | 3 |
| 34 | db.events_cache.count( {"_id":"a1a98a1ad21391068d2b0d921ec5d0cb"} ) | | 0 | 0 | 1 |
| 35 | db.events_cache.insert( {"_id":"a1a98a1ad21391068d2b0d921ec5d0cb","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.63400000 1766649257)","created":"MongoDate(0.63400000 1766649257)"} , true) | | 0 | 0 | 1 |
| 36 | db.events_cache.find( {"_id":"b49d814c434e42aec65b414d4b77cb02"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 37 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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 |
| 38 | db.events_cache.count( {"_id":"b49d814c434e42aec65b414d4b77cb02"} ) | | 0 | 0 | 1 |
| 39 | db.events_cache.insert( {"_id":"b49d814c434e42aec65b414d4b77cb02","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.64800000 1766649257)","created":"MongoDate(0.64800000 1766649257)"} , true) | | 0 | 0 | 1 |
| 40 | db.events_cache.find( {"_id":"ca1fd02fdd13d1c009b92a4ba60cb8bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 41 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"tags":"arts-and-entertainment","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 | 5 |
| 42 | db.events_cache.count( {"_id":"ca1fd02fdd13d1c009b92a4ba60cb8bb"} ) | | 0 | 0 | 1 |
| 43 | db.events_cache.insert( {"_id":"ca1fd02fdd13d1c009b92a4ba60cb8bb","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.67000000 1766649257)","created":"MongoDate(0.67000000 1766649257)"} , true) | | 0 | 0 | 1 |
| 44 | db.events_cache.find( {"_id":"fcf49f9e75c5346f9f1b6c88e146c8cd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 45 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"tags":"arts-and-entertainment","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 | 5 |
| 46 | db.events_cache.count( {"_id":"fcf49f9e75c5346f9f1b6c88e146c8cd"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"fcf49f9e75c5346f9f1b6c88e146c8cd","town_sef_url":"waialua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.69200000 1766649257)","created":"MongoDate(0.69200000 1766649257)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"ce830eb4003a4157f1819c7397c6a8cb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.43478260869565216]}}}, ["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 | 13 |
| 50 | db.events_cache.count( {"_id":"ce830eb4003a4157f1819c7397c6a8cb"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.insert( {"_id":"ce830eb4003a4157f1819c7397c6a8cb","town_sef_url":"waialua-hi","data_key":["68a75b6803a70639b6cf42d0"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-158.1269989013672,21.573699951171875],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.72000000 1766649257)","created":"MongoDate(0.72000000 1766649257)"} , true) | | 0 | 0 | 1 |
| 52 | db.events_cache.find( {"_id":"8c1dcf6999238124be22b3a213b34075"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 53 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76071090]},"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 | 222 |
| 54 | db.events_cache.count( {"_id":"8c1dcf6999238124be22b3a213b34075"} ) | | 0 | 0 | 1 |
| 55 | db.events_cache.insert( {"_id":"8c1dcf6999238124be22b3a213b34075","town_sef_url":"waialua-hi","data_key":["68a75b6803a70639b6cf435b","693321064389be6be56551b4","68a75b6b03a70639b6cf5501","693321064389be6be56553f3","693321074389be6be5655680","693321074389be6be56556dd","693321074389be6be5655771","693321074389be6be5655869","693321074389be6be565595a","693321074389be6be5655a66","693321074389be6be5655bba","693321084389be6be5655e53","693321084389be6be5656145","693321084389be6be5656219","693321084389be6be5656261","693321084389be6be5656309","693321094389be6be5656435","68a75b6f03a70639b6cf707c","68a75b6f03a70639b6cf71c7","68a75b6f03a70639b6cf739a","693321094389be6be5656a42","693321094389be6be5656b55","6933210a4389be6be5656c01","6933210a4389be6be5656cdf","6933210a4389be6be5656d9c","69036aef4389be6be5f6512c","6933210b4389be6be56571cc","69036aef4389be6be5f65464","69036af04389be6be5f6573b","69036af04389be6be5f657cd","6933210b4389be6be56576a7","69036af04389be6be5f65a81","6933210c4389be6be5657a0e","6933210e4389be6be56589bc","69036af44389be6be5f67cdf","69036af54389be6be5f6802a","69036af64389be6be5f6852f","69036af64389be6be5f688e2","69036af64389be6be5f689b2","69036af74389be6be5f68d60","69036af74389be6be5f68f5b","693321104389be6be5659c87","693321104389be6be5659d99","69036af84389be6be5f698a8","69036af84389be6be5f69af0","68a75b7703a70639b6cfad35","68a75b7703a70639b6cfafa0","68a75b7703a70639b6cfb1c5","68a75b7803a70639b6cfb3a4","693321124389be6be565b1c0"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.1269989013672,21.573699951171875],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.01600000 1766649258)","created":"MongoDate(0.01600000 1766649258)"} , true) | | 0 | 0 | 2 |
| 56 | db.events_cache.find( {"_id":"6e06c67116e0eadd4a8ee090bde710c0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 57 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76071090,76383923]},"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 | 43 |
| 58 | db.events_cache.count( {"_id":"6e06c67116e0eadd4a8ee090bde710c0"} ) | | 0 | 0 | 1 |
| 59 | db.events_cache.insert( {"_id":"6e06c67116e0eadd4a8ee090bde710c0","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.11500000 1766649258)","created":"MongoDate(0.11500000 1766649258)"} , true) | | 0 | 0 | 1 |
| 60 | db.places.find( {"geo":{"$near":[-158.1269989013672,21.573699951171875],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 16 | 6 |
| 61 | 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-honey-farms-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/honey-farms-apiaries\/\" target=\"_blank\">6 Best Honey Farms and Apiaries 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\/article\/honey-farms-apiaries\/\" target=\"_blank\">Hawaii Queen Bees, Waialua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Hawaii Queen Bees is an exceptional place to get your hands on some of the freshest local honey in Waialua! Located on the north shore of Oahu, they have an unheard-of variety of plants and trees to… <a href=\"https:\/\/bestthingshi.com\/article\/honey-farms-apiaries\/\" 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-hiking-trail-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hiking\/\" target=\"_blank\">10 Best Hiking Trails 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\/hiking\/\" target=\"_blank\">Kaena Point, Waialua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\"><p>The view from Kaena Point is one you won’t want to miss. To get there, venture along the 3.5-mile trail that follows an old railroad and dirt road.<\/p> <a href=\"https:\/\/bestthingshi.com\/hiking\/\" 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-horseback-riding-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/horseback-riding\/\" target=\"_blank\">10 Best Horseback Riding Services 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\/article\/horseback-riding\/\" target=\"_blank\">Hawaii Polo Oceanfront Trail Rides, Waialua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,community-life-bt,community-life-p300,moe,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Soak in the breathtaking beauty of the North Shore of Oahu while on horseback! From expert trainers and polo ponies, this horseback ride offers an experience not found anywhere else in Hawaii. Ride… <a href=\"https:\/\/bestthingshi.com\/article\/horseback-riding\/\" 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-tree-service-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/tree-services\/\" target=\"_blank\">4 Best Tree Services 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\/article\/tree-services\/\" target=\"_blank\">Hawaii Tree Co., Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Hawaii Tree Co. is perfect for those who need professional and affordable arbor care. Whether you have a towering tree in need of some TLC, or some smaller branches that need to be trimmed back,… <a href=\"https:\/\/bestthingshi.com\/article\/tree-services\/\" 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-art-gallery-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/art-galleries\/\" target=\"_blank\">7 Best Art Galleries 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\/art-galleries\/\" target=\"_blank\">Clark Little Gallery, Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,entertainment-bt,entertainment-p300,moe,edited-taylor,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Visitors to this charming gallery will be treated to a wonderful staff and a stunning collection of artwork, including the amazing photography of Clark Little. Get up close to the different styles of… <a href=\"https:\/\/bestthingshi.com\/art-galleries\/\" 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-roofers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/roofers\/\" target=\"_blank\">10 Best Roofers 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\/article\/roofers\/\" target=\"_blank\">FBC Roofing, Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">FBC Roofing is your one-stop shop for roof repair and service needs! With years of solid roofs and free roof inspections, they help families protect their homes and make sure all repairs are done… <a href=\"https:\/\/bestthingshi.com\/article\/roofers\/\" 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-nature-centers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/nature-centers\/\" target=\"_blank\">Best Nature Centers 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\/nature-centers\/\" target=\"_blank\">Waimea Valley, Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,community-life-bt,community-life-p300,moe,limited-options,edited-yagee,edited-alli,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Waimea Valley is a wondrous, living pu'uhonua filled with sacred Hawaiian history and vibrant traditions that continue to be honored and perpetuated. Step inside and experience the true meaning of… <a href=\"https:\/\/bestthingshi.com\/nature-centers\/\" 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-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<\/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_category\",\"radius\":\"30\",\"days\":\"15\",\"ttl\":\"3\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1766660057,"type":"Event","id":76071090,"title":"A Charlie Brown Christmas","url":"\/event\/a-charlie-brown-christmas-1-2025-12-25-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/08\/86\/13_Edp.jpg?v=4"},{"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":1766663657,"type":"Event","id":76383923,"title":"Seven Suns","url":"\/event\/seven-suns-2026-01-18-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/32\/35\/83_Edp.jpg?v=3"},{"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":1766678058,"type":"Place","id":2197959,"title":"Makahiki festival","url":"\/place\/makahiki-festival-haleiwa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-1.jpg"}],"modified":"MongoDate(0.13100000 1766649258)","created":"MongoDate(0.13100000 1766649258)","_id":ObjectId ("694cedaa0dbd5e9aa20b0bfd")} , true) | | 0 | 0 | 2 |
| 62 | db.events_cache.find( {"_id":"a284da43eaa658c7790a33cc3769640b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 63 | db.events_radius_cache.find( {"_id":"712f196580278207467644e50a893fd6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 64 | db.events.count( {"address.town_sef_url":"waialua-hi","start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 0 | 2 |
| 65 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767506400)"}} ) | | 0 | 0 | 25 |
| 66 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766642400)","$lt":"MongoDate(0.00000000 1767506400)"}} ) | | 0 | 6 | 21 |
| 67 | db.events_radius_cache.count( {"_id":"712f196580278207467644e50a893fd6"} ) | | 0 | 0 | 1 |
| 68 | db.events_radius_cache.insert( {"_id":"712f196580278207467644e50a893fd6","radius":25,"modified":"MongoDate(0.20600000 1766649258)","created":"MongoDate(0.20600000 1766649258)"} , true) | | 0 | 0 | 2 |
| 69 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766642400)"},"event_id":{"$nin":[76071090,76383923]},"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 | 246 |
| 70 | db.events_cache.count( {"_id":"a284da43eaa658c7790a33cc3769640b"} ) | | 0 | 0 | 1 |
| 71 | db.events_cache.count( {"_id":"a284da43eaa658c7790a33cc3769640b"} ) | | 0 | 0 | 1 |
| 72 | db.events_cache.insert( {"_id":"a284da43eaa658c7790a33cc3769640b","town_sef_url":"waialua-hi","data_key":["68a75b6803a70639b6cf43b1","68a75b6803a70639b6cf4401","68a75b6b03a70639b6cf56d1","68a75b6b03a70639b6cf572d","68a75b6b03a70639b6cf572a"],"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.49100000 1766649258)","created":"MongoDate(0.49100000 1766649258)"} , true) | | 0 | 0 | 2 |
| 73 | 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 | 7 |
| 74 | db.places.find( {"address.town_sef_url":"waialua-hi","group_id":{"$nin":[2197959]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 5 |
