| 1 | db.towns.find( {"sef_url":"haleiwa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 10 |
| 2 | db.towns.find( {"sef_url":"haleiwa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","haleiwa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 31 |
| 4 | db.ttd_towns.find( {"town_sef_url":"haleiwa-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 5 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-158.10299682617188,21.59280014038086],"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(1765787294123)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765787294123)","$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 | 47 |
| 7 | db.ttd_towns.find( {"town_sef_url":"haleiwa-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.events_cache.find( {"_id":"faa576df9598e3206bd9ebab6ae9f963"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 10 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 11 | db.events_cache.count( {"_id":"faa576df9598e3206bd9ebab6ae9f963"} ) | | 0 | 0 | 1 |
| 12 | db.events_cache.insert( {"_id":"faa576df9598e3206bd9ebab6ae9f963","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.20500000 1765787294)","created":"MongoDate(0.20500000 1765787294)"} , true) | | 0 | 0 | 1 |
| 13 | db.events_cache.find( {"_id":"399424f67a53d9193e1ef65ccce8b55e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 13 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 15 | db.events_cache.count( {"_id":"399424f67a53d9193e1ef65ccce8b55e"} ) | | 0 | 0 | 6 |
| 16 | db.events_cache.insert( {"_id":"399424f67a53d9193e1ef65ccce8b55e","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.26000000 1765787294)","created":"MongoDate(0.26000000 1765787294)"} , true) | | 0 | 0 | 1 |
| 17 | db.events_cache.find( {"_id":"5d87123edbe7f427971a7a222f9a5b2c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 19 | db.events_cache.count( {"_id":"5d87123edbe7f427971a7a222f9a5b2c"} ) | | 0 | 0 | 1 |
| 20 | db.events_cache.insert( {"_id":"5d87123edbe7f427971a7a222f9a5b2c","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.28500000 1765787294)","created":"MongoDate(0.28500000 1765787294)"} , true) | | 0 | 0 | 1 |
| 21 | db.events_cache.find( {"_id":"63c6c16630a8e9fdf8da9a1b21744b2e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 22 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 23 | db.events_cache.count( {"_id":"63c6c16630a8e9fdf8da9a1b21744b2e"} ) | | 0 | 0 | 1 |
| 24 | db.events_cache.insert( {"_id":"63c6c16630a8e9fdf8da9a1b21744b2e","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.30200000 1765787294)","created":"MongoDate(0.30200000 1765787294)"} , true) | | 0 | 0 | 1 |
| 25 | db.events_cache.find( {"_id":"189e890721788656910d9f96755dd289"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 26 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 27 | db.events_cache.count( {"_id":"189e890721788656910d9f96755dd289"} ) | | 0 | 0 | 1 |
| 28 | db.events_cache.insert( {"_id":"189e890721788656910d9f96755dd289","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.32500000 1765787294)","created":"MongoDate(0.32500000 1765787294)"} , true) | | 0 | 0 | 1 |
| 29 | db.events_cache.find( {"_id":"debdfd0fa6bead420c11c9ebb68b0d44"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 31 | db.events_cache.count( {"_id":"debdfd0fa6bead420c11c9ebb68b0d44"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"debdfd0fa6bead420c11c9ebb68b0d44","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.34800000 1765787294)","created":"MongoDate(0.34800000 1765787294)"} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"2e6def6c22e904ae49489a7cd083ba8e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 | 5 |
| 35 | db.events_cache.count( {"_id":"2e6def6c22e904ae49489a7cd083ba8e"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.insert( {"_id":"2e6def6c22e904ae49489a7cd083ba8e","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.37400000 1765787294)","created":"MongoDate(0.37400000 1765787294)"} , true) | | 0 | 0 | 2 |
| 37 | db.events_cache.find( {"_id":"fc48054afada5891ea2d653275fe0797"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 39 | db.events_cache.count( {"_id":"fc48054afada5891ea2d653275fe0797"} ) | | 0 | 0 | 1 |
| 40 | db.events_cache.insert( {"_id":"fc48054afada5891ea2d653275fe0797","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.39400000 1765787294)","created":"MongoDate(0.39400000 1765787294)"} , true) | | 0 | 0 | 1 |
| 41 | db.events_cache.find( {"_id":"504f4aefed427ef1fd4988b9dd21b0b9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 42 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 |
| 43 | db.events_cache.count( {"_id":"504f4aefed427ef1fd4988b9dd21b0b9"} ) | | 0 | 0 | 1 |
| 44 | db.events_cache.insert( {"_id":"504f4aefed427ef1fd4988b9dd21b0b9","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.41600000 1765787294)","created":"MongoDate(0.41600000 1765787294)"} , true) | | 0 | 0 | 1 |
| 45 | db.events_cache.find( {"_id":"4073d5e150742b9ca73d6ec22b930225"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 46 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 | 12 |
| 47 | db.events_cache.count( {"_id":"4073d5e150742b9ca73d6ec22b930225"} ) | | 0 | 0 | 1 |
| 48 | db.events_cache.insert( {"_id":"4073d5e150742b9ca73d6ec22b930225","town_sef_url":"haleiwa-hi","data_key":["69036add4389be6be5f5eb50"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.45500000 1765787294)","created":"MongoDate(0.45500000 1765787294)"} , true) | | 0 | 0 | 2 |
| 49 | db.events_cache.find( {"_id":"42744f9f6fabe1323d04e404ca64868a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 50 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"event_id":{"$nin":[76119648]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 | 172 |
| 51 | db.events_cache.count( {"_id":"42744f9f6fabe1323d04e404ca64868a"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"42744f9f6fabe1323d04e404ca64868a","town_sef_url":"haleiwa-hi","data_key":["69036add4389be6be5f5ed68","69036add4389be6be5f5ee6a","69036ade4389be6be5f5f149","69036ade4389be6be5f5f2d1","69036ade4389be6be5f5f531","69036ade4389be6be5f5f6e5","69036adf4389be6be5f5f9e0","68a75b6203a70639b6cf1d2b","69036ae04389be6be5f5fff9","693321034389be6be5653c53","68a75b6403a70639b6cf29d7","69036ae24389be6be5f60a15","68a75b6403a70639b6cf2d47","68a75b6403a70639b6cf2dcc","693321044389be6be565439c","69036ae34389be6be5f61330","69036ae54389be6be5f61b4d","68a75b6803a70639b6cf4116","68a75b6803a70639b6cf41b9","68a75b6803a70639b6cf42d0","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"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.69900000 1765787294)","created":"MongoDate(0.69900000 1765787294)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"2715631aad686d30f5cb1c45f2d317c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"event_id":{"$nin":[76119648,76387055]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 | 53 |
| 55 | db.events_cache.count( {"_id":"2715631aad686d30f5cb1c45f2d317c6"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.insert( {"_id":"2715631aad686d30f5cb1c45f2d317c6","town_sef_url":"haleiwa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.10299682617188,21.59280014038086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.81700000 1765787294)","created":"MongoDate(0.81700000 1765787294)"} , true) | | 0 | 0 | 1 |
| 57 | db.places.find( {"geo":{"$near":[-158.10299682617188,21.59280014038086],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 14 | 6 |
| 58 | 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-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\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-food-truck-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/food-truck\/\" target=\"_blank\">10 Most Delicious Food Trucks 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\/food-truck\/\" target=\"_blank\">The Elephant Truck, Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,moe,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Tucked away in Haleiwa on the island of Oahu, The Elephant Truck is your chance to dine in Thailand without leaving the North Shore. This offbeat truck offers a variety of dishes including poke… <a href=\"https:\/\/bestthingshi.com\/food-truck\/\" 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-florists-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/florists\/\" target=\"_blank\">9 Best Florists 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\/florists\/\" target=\"_blank\">Lulu's Lei and Bouquets, Haleiwa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,moe,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Lulu\u2019s Lei + Bouquets offers floral design and consultation for birthdays, weddings, and any other special occasion. If you\u2019re looking for something a little different, this is the place to visit.… <a href=\"https:\/\/bestthingshi.com\/florists\/\" 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<\/div>\n<\/div>\n\n\n","town_sef_url":"haleiwa-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":1765798094,"type":"Event","id":76119648,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-1-2025-12-16-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_SOURCE"},{"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":1765801694,"type":"Event","id":76387055,"title":"TUMUA: The Chee Hoo Tour","url":"\/event\/tumua-the-chee-hoo-tour-2025-12-28-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/0be\/79cd515a-e6f7-4ca3-8d8d-efaea95060be_TABLET_LANDSCAPE_LARGE_16_9.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":1765816094,"type":"Place","id":2210803,"title":"Ka'ala Flea Market and Fair","url":"\/place\/kaala-flea-market-and-fair-wahiawa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-1.jpg"}],"modified":"MongoDate(0.83500000 1765787294)","created":"MongoDate(0.83500000 1765787294)","_id":ObjectId ("693fc69eee0140ad9e07cc57")} , true) | | 0 | 0 | 2 |
| 59 | db.events_cache.find( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 60 | db.events_radius_cache.find( {"_id":"f282eb7cbcbaae031165fee202638acc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 4 |
| 61 | db.events.count( {"address.town_sef_url":"haleiwa-hi","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} ) | | 0 | 0 | 2 |
| 62 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} ) | | 0 | 0 | 32 |
| 63 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} ) | | 0 | 5 | 35 |
| 64 | db.events_radius_cache.count( {"_id":"f282eb7cbcbaae031165fee202638acc"} ) | | 0 | 0 | 1 |
| 65 | db.events_radius_cache.insert( {"_id":"f282eb7cbcbaae031165fee202638acc","radius":25,"modified":"MongoDate(0.94000000 1765787294)","created":"MongoDate(0.94000000 1765787294)"} , true) | | 0 | 0 | 1 |
| 66 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"event_id":{"$nin":[76119648,76387055]},"geo":{"$geoWithin":{"$center":[[-158.10299682617188,21.59280014038086],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 | 253 |
| 67 | db.events_cache.count( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb"} ) | | 0 | 0 | 1 |
| 68 | db.events_cache.count( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb"} ) | | 0 | 0 | 1 |
| 69 | db.events_cache.insert( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb","town_sef_url":"haleiwa-hi","data_key":["68a75b5d03a70639b6cf0531","68a75b5d03a70639b6cf056f","68a75b5d03a70639b6cf05f3","68a75b5d03a70639b6cf064e","68a75b5f03a70639b6cf10ae"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Haleiwa\",\"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.59280014038086,\"lng\":-158.10299682617188,\"latlng\":\"21.592800140381,-158.10299682617\",\"city\":\"Haleiwa\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.22100000 1765787295)","created":"MongoDate(0.22100000 1765787295)"} , true) | | 0 | 0 | 1 |
| 70 | db.news.find( {"broadcast":{"$in":["usa","haleiwa-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 | 5 |
| 71 | db.places.find( {"address.town_sef_url":"haleiwa-hi","group_id":{"$nin":[2210803]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 4 |
