| 1 | db.towns.find( {"sef_url":"centerton-ar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 8 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 7 |
| 3 | db.towns.find( {"sef_url":"haleiwa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"haleiwa-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 42 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 10 | 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(1765679463409)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765679463409)","$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 |
| 11 | db.ttd_towns.find( {"town_sef_url":"haleiwa-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 6 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 13 | db.events_cache.find( {"_id":"2b4857f1c06bf196b3ea16e8def0f6fa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766296799)"},"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 | 26 |
| 15 | db.events_cache.count( {"_id":"2b4857f1c06bf196b3ea16e8def0f6fa"} ) | | 0 | 0 | 11 |
| 16 | db.events_cache.count( {"_id":"2b4857f1c06bf196b3ea16e8def0f6fa"} ) | | 0 | 0 | 9 |
| 17 | db.events_cache.insert( {"_id":"2b4857f1c06bf196b3ea16e8def0f6fa","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],\"has_next_page\":false}","modified":"MongoDate(0.66400000 1765679463)","created":"MongoDate(0.66400000 1765679463)"} , true) | | 0 | 0 | 11 |
| 18 | db.events_cache.find( {"_id":"1fb4b49814afc80320de945764934cf7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 10 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766555999)"},"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 | 38 |
| 20 | db.events_cache.count( {"_id":"1fb4b49814afc80320de945764934cf7"} ) | | 0 | 0 | 56 |
| 21 | db.events_cache.count( {"_id":"1fb4b49814afc80320de945764934cf7"} ) | | 0 | 0 | 11 |
| 22 | db.events_cache.insert( {"_id":"1fb4b49814afc80320de945764934cf7","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],\"has_next_page\":false}","modified":"MongoDate(0.99900000 1765679463)","created":"MongoDate(0.99900000 1765679463)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"251b1d178e585740d7272990b9cdce33"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1768283999)"},"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 | 98 |
| 25 | db.events_cache.count( {"_id":"251b1d178e585740d7272990b9cdce33"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"251b1d178e585740d7272990b9cdce33"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"251b1d178e585740d7272990b9cdce33","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],\"has_next_page\":false}","modified":"MongoDate(0.28800000 1765679464)","created":"MongoDate(0.28800000 1765679464)"} , true) | | 0 | 0 | 10 |
| 28 | db.events_cache.find( {"_id":"2f87d7e957584093a48bc21a5e99a998"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 9 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766296799)"},"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 | 21 |
| 30 | db.events_cache.count( {"_id":"2f87d7e957584093a48bc21a5e99a998"} ) | | 0 | 0 | 10 |
| 31 | db.events_cache.count( {"_id":"2f87d7e957584093a48bc21a5e99a998"} ) | | 0 | 0 | 7 |
| 32 | db.events_cache.insert( {"_id":"2f87d7e957584093a48bc21a5e99a998","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],\"has_next_page\":false}","modified":"MongoDate(0.39900000 1765679464)","created":"MongoDate(0.39900000 1765679464)"} , true) | | 0 | 0 | 3 |
| 33 | db.events_cache.find( {"_id":"f339674bbfe039ec7323c353a661c239"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 9 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766901599)"},"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 | 16 |
| 35 | db.events_cache.count( {"_id":"f339674bbfe039ec7323c353a661c239"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"f339674bbfe039ec7323c353a661c239"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"f339674bbfe039ec7323c353a661c239","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],\"has_next_page\":false}","modified":"MongoDate(0.48300000 1765679464)","created":"MongoDate(0.48300000 1765679464)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"cafdd216574d948e3f88aaef972d5101"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1765951199)"},"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 | 2 |
| 40 | db.events_cache.count( {"_id":"cafdd216574d948e3f88aaef972d5101"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"cafdd216574d948e3f88aaef972d5101"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"cafdd216574d948e3f88aaef972d5101","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],\"has_next_page\":false}","modified":"MongoDate(0.50400000 1765679464)","created":"MongoDate(0.50400000 1765679464)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"8a0e5e97330d507fbb5e2d53ac3dd490"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1768283999)"},"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 | 2 | 29 |
| 45 | db.events_cache.count( {"_id":"8a0e5e97330d507fbb5e2d53ac3dd490"} ) | | 0 | 0 | 25 |
| 46 | db.events_cache.count( {"_id":"8a0e5e97330d507fbb5e2d53ac3dd490"} ) | | 0 | 0 | 16 |
| 47 | db.events_cache.insert( {"_id":"8a0e5e97330d507fbb5e2d53ac3dd490","town_sef_url":"haleiwa-hi","data_key":["68512af8fb5e4bed1fa7db94"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.10299682617188,21.59280014038086],\"has_next_page\":true}","modified":"MongoDate(0.63600000 1765679464)","created":"MongoDate(0.63600000 1765679464)"} , true) | | 0 | 0 | 2 |
| 48 | db.events_cache.find( {"_id":"299bfbed90bef35a5491ff6988f3283b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 9 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1767506399)"},"event_id":{"$nin":[75794777]},"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 | 44 | 150 |
| 50 | db.events_cache.count( {"_id":"299bfbed90bef35a5491ff6988f3283b"} ) | | 0 | 0 | 12 |
| 51 | db.events_cache.count( {"_id":"299bfbed90bef35a5491ff6988f3283b"} ) | | 0 | 0 | 8 |
| 52 | db.events_cache.insert( {"_id":"299bfbed90bef35a5491ff6988f3283b","town_sef_url":"haleiwa-hi","data_key":["69169295de4ae56f5ad4e42c","68dc909fc3af739f25fd2665","68dde21fc3af739f25c566f7","68dde21fc3af739f25c567c0","68b8f82ac3af739f25568274","68b8f82ac3af739f255682c7","68b8f82ac3af739f25568306","68b8f82ac3af739f25568368","68b8f82bc3af739f2556838b","68d74abcc3af739f25e1e209","68b8f82bc3af739f25568422","68b8f82bc3af739f2556844d","687f4f92fb5e4bed1f73d5fd","68b8f82bc3af739f255684dc","69251312de4ae56f5a2520f5","689d5a3efb5e4bed1f4b017e","68d74abdc3af739f25e1e35b","689ab73efb5e4bed1fded3f3","689d5a3efb5e4bed1f4b01f7","69251312de4ae56f5a2521a4","68d74abdc3af739f25e1e408","68e86e1ec3af739f25218ea7","68a2a04cfb5e4bed1fbe5471","68a2a04cfb5e4bed1fbe5483","68a2a04cfb5e4bed1fbe5491","68a2a04cfb5e4bed1fbe54a8","690ab51cde4ae56f5a840ed7","68639ff5fb5e4bed1fa5e9ff","690ab51cde4ae56f5a840f0c","69266493de4ae56f5ae4877a","6930f092de4ae56f5aa6e8dd","69266493de4ae56f5ae48797","690ab51cde4ae56f5a840f68","690ab51cde4ae56f5a840f77","690c0697de4ae56f5a9c0c24","690c0697de4ae56f5a9c0c3a","690c0697de4ae56f5a9c0c4f","690c0698de4ae56f5a9c0cd5","6917e415de4ae56f5a8ffbe0","6917e415de4ae56f5a8ffbea","6917e415de4ae56f5a8ffbed","6917e415de4ae56f5a8ffc19","6895714afb5e4bed1fd7728d","6895714afb5e4bed1fd772b7"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.10299682617188,21.59280014038086],\"has_next_page\":false}","modified":"MongoDate(0.04700000 1765679465)","created":"MongoDate(0.04700000 1765679465)"} , true) | | 0 | 0 | 2 |
| 53 | db.events_cache.find( {"_id":"78acbf896137d04a6b0ce6e6f3f48723"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1767506399)"},"event_id":{"$nin":[75794777,76057781]},"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 | 24 |
| 55 | db.events_cache.count( {"_id":"78acbf896137d04a6b0ce6e6f3f48723"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"78acbf896137d04a6b0ce6e6f3f48723"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"78acbf896137d04a6b0ce6e6f3f48723","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],\"has_next_page\":false}","modified":"MongoDate(0.12600000 1765679465)","created":"MongoDate(0.12600000 1765679465)"} , true) | | 0 | 0 | 3 |
| 58 | db.places.find( {"geo":{"$near":[-158.10299682617188,21.59280014038086],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 14 | 6 |
| 59 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai Restaurants in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/thai-restaurants\/\" target=\"_blank\">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-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-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-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-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-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-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-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-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-tattoo-parlor-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\">10 Best Tattoo Parlors 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\/tattoo-parlors\/\" target=\"_blank\">Dragon Tattoo, 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\">Dragon Tattoo is the brainchild of renowned tattoo artist Lance McLane, a living legend in the classic American style of tattooing. If you’re in the northern end of Oahu and looking for some… <a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" 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_tag\",\"searchtag\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1765686664,"type":"Event","id":75794777,"title":"Holiday JCCH Craft and Collectibles Fair","url":"\/event\/holiday-jcch-craft-and-collectibles-fair-2025-12-13-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-1.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":1765693864,"type":"Event","id":76057781,"title":"Christmas in Hawai\u2018i with Kimi\u00e9 Miner & Friends","url":"\/event\/christmas-in-hawaii-with-kimie-miner-friends-2025-12-20-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/12\/57\/48\/84_Edp.jpg?v=5"},{"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":1765708265,"type":"Place","id":2192350,"title":"Kalo and Awa Festival","url":"\/place\/kalo-and-awa-festival-haleiwa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-1.jpg"}],"modified":"MongoDate(0.15100000 1765679465)","created":"MongoDate(0.15100000 1765679465)","_id":ObjectId ("693e216937b29f2616035439")} , true) | | 0 | 0 | 7 |
| 60 | db.events_cache.find( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 61 | db.events_radius_cache.find( {"_id":"f282eb7cbcbaae031165fee202638acc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 62 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"event_id":{"$nin":[75794777,76057781]},"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 | 579 |
| 63 | db.events_cache.count( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb"} ) | | 0 | 0 | 25 |
| 64 | db.events_cache.count( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb"} ) | | 0 | 0 | 1 |
| 65 | db.events_cache.insert( {"_id":"ab766b30a8fd3f8d850a7f5843eed7bb","town_sef_url":"haleiwa-hi","data_key":["68fc9c93b968d244290c2f01","68fca36334c9e7cdf6042e6b","68fc9ed5f632dfbd2b06994f","68527c8ffb5e4bed1f027bdc","68527c92fb5e4bed1f02809c"],"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.88200000 1765679465)","created":"MongoDate(0.88200000 1765679465)"} , true) | | 0 | 0 | 5 |
| 66 | 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 | 11 |
| 67 | db.places.find( {"address.town_sef_url":"haleiwa-hi","group_id":{"$nin":[2192350]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 7 |
| 68 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 45 |
| 69 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 70 | db.towns.find( {"sef_url":"haleiwa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 8 |
| 71 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","haleiwa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 72 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 73 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 74 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 7 |
| 75 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
| 76 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 7 |
| 77 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 8 |
| 78 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 6 |
