| 1 | db.towns.find( {"sef_url":"waikoloa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.towns.find( {"sef_url":"waikoloa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","hi","hawaii-county-hi","waikoloa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 4 | db.ttd_towns.find( {"town_sef_url":"waikoloa-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":[-155.83700561523438,19.829200744628906],"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(1766453481479)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766453481479)","$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 | 60 |
| 7 | db.ttd_towns.find( {"town_sef_url":"waikoloa-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 9 | db.events_cache.find( {"_id":"b994442f45a588451cf373d760b432e2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 10 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 |
| 11 | db.events_cache.count( {"_id":"b994442f45a588451cf373d760b432e2"} ) | | 0 | 0 | 1 |
| 12 | db.events_cache.insert( {"_id":"b994442f45a588451cf373d760b432e2","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.60500000 1766453481)","created":"MongoDate(0.60500000 1766453481)"} , true) | | 0 | 0 | 4 |
| 13 | db.events_cache.find( {"_id":"1f2c49b076d79c53b3478ed5251723fc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 |
| 15 | db.events_cache.count( {"_id":"1f2c49b076d79c53b3478ed5251723fc"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.insert( {"_id":"1f2c49b076d79c53b3478ed5251723fc","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.63400000 1766453481)","created":"MongoDate(0.63400000 1766453481)"} , true) | | 0 | 0 | 1 |
| 17 | db.events_cache.find( {"_id":"fa8d6d9b5d95cf43822462d4610e2ca8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 |
| 19 | db.events_cache.count( {"_id":"fa8d6d9b5d95cf43822462d4610e2ca8"} ) | | 0 | 0 | 1 |
| 20 | db.events_cache.insert( {"_id":"fa8d6d9b5d95cf43822462d4610e2ca8","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.65700000 1766453481)","created":"MongoDate(0.65700000 1766453481)"} , true) | | 0 | 0 | 1 |
| 21 | db.events_cache.find( {"_id":"b25936e43224244526c972cae0674537"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 22 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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":"b25936e43224244526c972cae0674537"} ) | | 0 | 0 | 1 |
| 24 | db.events_cache.insert( {"_id":"b25936e43224244526c972cae0674537","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.67900000 1766453481)","created":"MongoDate(0.67900000 1766453481)"} , true) | | 0 | 0 | 1 |
| 25 | db.events_cache.find( {"_id":"586109c99f7e52909da492567ec052fd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 26 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 |
| 27 | db.events_cache.count( {"_id":"586109c99f7e52909da492567ec052fd"} ) | | 0 | 0 | 1 |
| 28 | db.events_cache.insert( {"_id":"586109c99f7e52909da492567ec052fd","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.70800000 1766453481)","created":"MongoDate(0.70800000 1766453481)"} , true) | | 0 | 0 | 1 |
| 29 | db.events_cache.find( {"_id":"18866ea16c2eb09778f55696009e2c2f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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":"18866ea16c2eb09778f55696009e2c2f"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"18866ea16c2eb09778f55696009e2c2f","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.72900000 1766453481)","created":"MongoDate(0.72900000 1766453481)"} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"84da7325cc260ae71a6d76d097def14f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 3 |
| 35 | db.events_cache.count( {"_id":"84da7325cc260ae71a6d76d097def14f"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.insert( {"_id":"84da7325cc260ae71a6d76d097def14f","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.76100000 1766453481)","created":"MongoDate(0.76100000 1766453481)"} , true) | | 0 | 0 | 9 |
| 37 | db.events_cache.find( {"_id":"c63762ce6ce07417ea730fa14b9c7e4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 4 |
| 39 | db.events_cache.count( {"_id":"c63762ce6ce07417ea730fa14b9c7e4b"} ) | | 0 | 0 | 1 |
| 40 | db.events_cache.insert( {"_id":"c63762ce6ce07417ea730fa14b9c7e4b","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.78900000 1766453481)","created":"MongoDate(0.78900000 1766453481)"} , true) | | 0 | 0 | 1 |
| 41 | db.events_cache.find( {"_id":"6749814d0edca02c72848266c5e75242"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 42 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 7 |
| 43 | db.events_cache.count( {"_id":"6749814d0edca02c72848266c5e75242"} ) | | 0 | 0 | 1 |
| 44 | db.events_cache.insert( {"_id":"6749814d0edca02c72848266c5e75242","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.82800000 1766453481)","created":"MongoDate(0.82800000 1766453481)"} , true) | | 0 | 0 | 2 |
| 45 | db.events_cache.find( {"_id":"4aaf3050bd257b09768c9b605a7160a9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 46 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 1 | 4 |
| 47 | db.events_cache.count( {"_id":"4aaf3050bd257b09768c9b605a7160a9"} ) | | 0 | 0 | 1 |
| 48 | db.events_cache.insert( {"_id":"4aaf3050bd257b09768c9b605a7160a9","town_sef_url":"waikoloa-hi","data_key":["68a75b6d03a70639b6cf629a"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.85200000 1766453481)","created":"MongoDate(0.85200000 1766453481)"} , true) | | 0 | 0 | 1 |
| 49 | db.events_cache.find( {"_id":"71308ca22369dbfa5a3339f4714955d9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 50 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[75794813]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 1 | 249 |
| 51 | db.events_cache.count( {"_id":"71308ca22369dbfa5a3339f4714955d9"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"71308ca22369dbfa5a3339f4714955d9","town_sef_url":"waikoloa-hi","data_key":["693321224389be6be5663daa"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.31800000 1766453482)","created":"MongoDate(0.31800000 1766453482)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"2b5d1d3d44cacd4e4a287b96f4b80366"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[75794813,76356084]},"tags":"music","geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 44 |
| 55 | db.events_cache.count( {"_id":"2b5d1d3d44cacd4e4a287b96f4b80366"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.insert( {"_id":"2b5d1d3d44cacd4e4a287b96f4b80366","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-155.83700561523438,19.829200744628906],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.43100000 1766453482)","created":"MongoDate(0.43100000 1766453482)"} , true) | | 0 | 0 | 1 |
| 57 | db.places.find( {"geo":{"$near":[-155.83700561523438,19.829200744628906],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 20 | 8 |
| 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-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\">Charley\u2019s Thai Cuisine, Waikoloa, 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\">Charley’s Thai Cuisine is a popular restaurant among tourists since they’re close to popular hotels and other tourist attractions. You can dine in or order takeout — either way,… <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-fish-and-chips-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\/fish-and-chips\/\" target=\"_blank\">10 Best Places to get Fish and Chips 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\/fish-and-chips\/\" target=\"_blank\">Island fish and chips, Waikoloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Get a taste of the tropics at Island Fish & Chips! Located lakeside at the Waikoloa Beach Resort Kings' Shops, this is the location to take a break and pamper your tastebuds with an order of some… <a href=\"https:\/\/bestthingshi.com\/article\/fish-and-chips\/\" 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-tanning-salon-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tanning-salons\/\" target=\"_blank\">7 Best Tanning Salons 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\/tanning-salons\/\" target=\"_blank\">KOR Salon, Waikoloa Village, 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\">KOR Salon is here to make you feel great and is the perfect place if you're looking for a quick spray tan , or an entire day of pampering. KOR Salon is also highly knowledgeable and caring so you can… <a href=\"https:\/\/bestthingshi.com\/tanning-salons\/\" 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-movie-theaters-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/movie-theaters\/\" target=\"_blank\">7 Best Movie Theaters 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\/movie-theaters\/\" target=\"_blank\">Waik\u014dloa Luxury Cinemas, Waikoloa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,entertainment-bt,entertainment-p300,moe,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Waik\u014dloa Luxury Cinemas offers an exclusive movie experience with a unique open-air bistro. Enjoy delicious food and drink all fairly priced available for purchase. Come for a night out with the… <a href=\"https:\/\/bestthingshi.com\/movie-theaters\/\" 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-wine-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/wine-bars\/\" target=\"_blank\">The Best Wine Bars in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/wine-bars\/\" target=\"_blank\">Aloha Wine Bar, Waikoloa, 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\">The Aloha Wine Bar is a small area attached to a market and deli and is one of the few late-night spots near the Kohala resort area on the big island. Although it’s fairly casual, it is a good… <a href=\"https:\/\/bestthingshi.com\/wine-bars\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-french-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/french-restaurants\/\" target=\"_blank\">7 Best French Restaurants in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/french-restaurants\/\" target=\"_blank\">La Bourgogne, Kailua-Kona, Hawaii, 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\">Step inside this small but intimate family-run restaurant, and you leave behind Hawaii for a moment in the Fresh countryside. The fare is traditional French specialties from the frog legs to escargot… <a href=\"https:\/\/bestthingshi.com\/french-restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-tax-prep-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\/tax-prep-services\/\" target=\"_blank\">6 Best Tax Prep 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\/tax-prep-services\/\" target=\"_blank\">Block Advisors, Kailua Kona, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-6,edited-cynthia,edited-alli,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">From the convenience and security of your home, Block Advisors certified tax professionals are available to assist you with all of your small company tax needs. They are placing tax preparation in… <a href=\"https:\/\/bestthingshi.com\/article\/tax-prep-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-tutoring-services-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\/tutoring-services\/\" target=\"_blank\">5 Best Tutoring 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\/tutoring-services\/\" target=\"_blank\">Customized Curriculum, Kailua Kona, 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-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Customized Curriculum offers a flawless personalized solution for all your education struggles! Professional tutoring and parent curriculum coaching will provide you with the tools to reach victory… <a href=\"https:\/\/bestthingshi.com\/article\/tutoring-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-chinese-food-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\/chinese-food\/\" target=\"_blank\">10 Best Chinese Food 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\/article\/chinese-food\/\" target=\"_blank\">Kona Chinese BBQ, Kailua Kona, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">East meets West in an intriguing way at Kona's Chinese BBQ. Enjoy the ideal dinner with the ideal balance of sweet and savory flavors at this restaurant that offers a special mix of Chinese and… <a href=\"https:\/\/bestthingshi.com\/article\/chinese-food\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-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\">KBXtreme Premier Entertainment Center, Kailua-Kona, 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\">No matter what your favorite form of entertainment is, chances are that you’ll find it at KBXtreme Premier Entertainment Center. Rock the bowling lanes, sip on signature cocktails, show up your… <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<\/div>\n<\/div>\n\n\n","town_sef_url":"waikoloa-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":1766464281,"type":"Event","id":75794813,"title":"Under The New Moon at Ka\u02bbukulaelae","url":"\/event\/under-the-new-moon-at-kaukulaelae-2025-12-30-kailua-kona-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.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":1766467881,"type":"Event","id":76356084,"title":"Anjelah Johnson-Reyes: The Family Reunion Tour","url":"\/event\/anjelah-johnsonreyes-the-family-reunion-tour-2026-03-27-tm-kahului-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/26b\/26d9497c-925f-4ae8-b859-751a4944826b_SOURCE"},{"rule":"{\"content_type\":\"group_category\",\"radius\":\"10\",\"ttl\":\"8\",\"israndom\":1,\"group_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-1.jpg\",\"days\":1}","expiration":1766482282,"type":"Place","id":1434203,"title":"Dolphin Quest","url":"\/place\/dolphin-quest-waikoloa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-swim-place-3.jpg"}],"modified":"MongoDate(0.45100000 1766453482)","created":"MongoDate(0.45100000 1766453482)","_id":ObjectId ("6949f0ea839e0b4204051eb5")} , true) | | 0 | 0 | 2 |
| 59 | db.events_cache.find( {"_id":"66662c1503c74c5554d2cf298ab4e277"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 60 | db.events_radius_cache.find( {"_id":"8e5ed53bba396d717731f43519db143f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 61 | db.events.count( {"address.town_sef_url":"waikoloa-hi","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} ) | | 0 | 1 | 2 |
| 62 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 2 | 18 |
| 63 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 5 | 18 |
| 64 | db.events_radius_cache.count( {"_id":"8e5ed53bba396d717731f43519db143f"} ) | | 0 | 0 | 1 |
| 65 | db.events_radius_cache.insert( {"_id":"8e5ed53bba396d717731f43519db143f","radius":25,"modified":"MongoDate(0.51300000 1766453482)","created":"MongoDate(0.51300000 1766453482)"} , true) | | 0 | 0 | 1 |
| 66 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[75794813,76356084]},"geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],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 | 252 |
| 67 | db.events_cache.count( {"_id":"66662c1503c74c5554d2cf298ab4e277"} ) | | 0 | 0 | 1 |
| 68 | db.events_cache.count( {"_id":"66662c1503c74c5554d2cf298ab4e277"} ) | | 0 | 0 | 1 |
| 69 | db.events_cache.insert( {"_id":"66662c1503c74c5554d2cf298ab4e277","town_sef_url":"waikoloa-hi","data_key":["68a75b6703a70639b6cf3a8a","68a75b6703a70639b6cf3c14","68a75b6903a70639b6cf4a1b","68a75b6903a70639b6cf4b5e","68a75b6b03a70639b6cf5870"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Waikoloa\",\"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\":19.829200744628906,\"lng\":-155.83700561523438,\"latlng\":\"19.829200744629,-155.83700561523\",\"city\":\"Waikoloa\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.78100000 1766453482)","created":"MongoDate(0.78100000 1766453482)"} , true) | | 0 | 0 | 1 |
| 70 | db.news.find( {"broadcast":{"$in":["usa","waikoloa-hi","hi","hawaii-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":"waikoloa-hi","group_id":{"$nin":[1434203]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
