| 1 | db.towns.find( {"sef_url":"waikoloa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.ttd_towns.find( {"town_sef_url":"waikoloa-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 3 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | 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(1761835331620)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761835331620)","$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 | 38 |
| 5 | db.ttd_towns.find( {"town_sef_url":"waikoloa-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 7 | db.events_cache.find( {"_id":"f2ec51eccc8eef1ae86079fefda79568"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 12 |
| 9 | db.events_cache.count( {"_id":"f2ec51eccc8eef1ae86079fefda79568"} ) | | 0 | 0 | 1 |
| 10 | db.events_cache.insert( {"_id":"f2ec51eccc8eef1ae86079fefda79568","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],\"has_next_page\":false}","modified":"MongoDate(0.71800000 1761835331)","created":"MongoDate(0.71800000 1761835331)"} , true) | | 0 | 0 | 2 |
| 11 | db.events_cache.find( {"_id":"95e9943bdc1873ca3efcd89d65d6d260"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 11 |
| 13 | db.events_cache.count( {"_id":"95e9943bdc1873ca3efcd89d65d6d260"} ) | | 0 | 0 | 2 |
| 14 | db.events_cache.insert( {"_id":"95e9943bdc1873ca3efcd89d65d6d260","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],\"has_next_page\":false}","modified":"MongoDate(0.75400000 1761835331)","created":"MongoDate(0.75400000 1761835331)"} , true) | | 0 | 0 | 2 |
| 15 | db.events_cache.find( {"_id":"6d4a6a5ce3f0f223fc22fd440963653f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 16 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 9 |
| 17 | db.events_cache.count( {"_id":"6d4a6a5ce3f0f223fc22fd440963653f"} ) | | 0 | 0 | 1 |
| 18 | db.events_cache.insert( {"_id":"6d4a6a5ce3f0f223fc22fd440963653f","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],\"has_next_page\":false}","modified":"MongoDate(0.78800000 1761835331)","created":"MongoDate(0.78800000 1761835331)"} , true) | | 0 | 0 | 2 |
| 19 | db.events_cache.find( {"_id":"e8635b762afb038fcbe207509aa1c3ee"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 20 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 9 |
| 21 | db.events_cache.count( {"_id":"e8635b762afb038fcbe207509aa1c3ee"} ) | | 0 | 0 | 2 |
| 22 | db.events_cache.insert( {"_id":"e8635b762afb038fcbe207509aa1c3ee","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],\"has_next_page\":false}","modified":"MongoDate(0.82300000 1761835331)","created":"MongoDate(0.82300000 1761835331)"} , true) | | 0 | 0 | 2 |
| 23 | db.events_cache.find( {"_id":"874129746656a093d79acc099dce72af"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 9 |
| 25 | db.events_cache.count( {"_id":"874129746656a093d79acc099dce72af"} ) | | 0 | 0 | 2 |
| 26 | db.events_cache.insert( {"_id":"874129746656a093d79acc099dce72af","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],\"has_next_page\":false}","modified":"MongoDate(0.85900000 1761835331)","created":"MongoDate(0.85900000 1761835331)"} , true) | | 0 | 0 | 2 |
| 27 | db.events_cache.find( {"_id":"fee3106fb5e07e14806050215dafb5a9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 28 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 8 |
| 29 | db.events_cache.count( {"_id":"fee3106fb5e07e14806050215dafb5a9"} ) | | 0 | 0 | 2 |
| 30 | db.events_cache.insert( {"_id":"fee3106fb5e07e14806050215dafb5a9","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],\"has_next_page\":false}","modified":"MongoDate(0.89400000 1761835331)","created":"MongoDate(0.89400000 1761835331)"} , true) | | 0 | 0 | 2 |
| 31 | db.events_cache.find( {"_id":"16f782f1fb5487c8767b1b42db419c02"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 32 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"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 | 2 | 13 |
| 33 | db.events_cache.count( {"_id":"16f782f1fb5487c8767b1b42db419c02"} ) | | 0 | 0 | 1 |
| 34 | db.events_cache.insert( {"_id":"16f782f1fb5487c8767b1b42db419c02","town_sef_url":"waikoloa-hi","data_key":["68e8adbfb968d244290c2e94"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-155.83700561523438,19.829200744628906],\"has_next_page\":true}","modified":"MongoDate(0.93500000 1761835331)","created":"MongoDate(0.93500000 1761835331)"} , true) | | 0 | 0 | 2 |
| 35 | db.events_cache.find( {"_id":"0251f33557db6e44bd654c4dbe6aea41"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 36 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76229215]},"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 | 0 | 19 |
| 37 | db.events_cache.count( {"_id":"0251f33557db6e44bd654c4dbe6aea41"} ) | | 0 | 0 | 2 |
| 38 | db.events_cache.insert( {"_id":"0251f33557db6e44bd654c4dbe6aea41","town_sef_url":"waikoloa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-155.83700561523438,19.829200744628906],\"has_next_page\":false}","modified":"MongoDate(0.15900000 1761835332)","created":"MongoDate(0.15900000 1761835332)"} , true) | | 0 | 0 | 2 |
| 39 | db.events_cache.find( {"_id":"5d81adcd11c1f209318443354b206383"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 40 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76229215]},"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 | 25 |
| 41 | db.events_cache.count( {"_id":"5d81adcd11c1f209318443354b206383"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"5d81adcd11c1f209318443354b206383","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],\"has_next_page\":false}","modified":"MongoDate(0.22700000 1761835332)","created":"MongoDate(0.22700000 1761835332)"} , true) | | 0 | 0 | 2 |
| 43 | db.places.find( {"geo":{"$near":[-155.83700561523438,19.829200744628906],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 20 | 4 |
| 44 | 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-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\">5 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,edited-cynthia,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-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\">Herbivores Vegan Cafe, Kailua-Kona, 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>Herbivores Vegan Cafe is designed with vegans in mind, but the food is so delicious that anyone will enjoy it. Check it out for wraps, pizzas, burgers, and more.<\/p> <a href=\"https:\/\/bestthingshi.com\/vegan-vegetarian-restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-rainy-day-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">10 Best Rainy Day Activities in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">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\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, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-shannen,edited-cynthia,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-hair-salons-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" target=\"_blank\">10 Best Hair 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\/hair-salons\/\" target=\"_blank\">Christina\u2019s Hair Salon and Studio, Kailua-Kona, 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\">If you want a hair salon with personal attention and a welcoming vibe on top of outstanding hairstyling talent, head to Christina’s Hair Salon and Studio. This Kailua Kona welcomes all for a… <a href=\"https:\/\/bestthingshi.com\/hair-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-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\">Lady Luck Tattoo and Body Piercing, Kailua Kona, 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\">You don’t need luck to get a great piercing at Lady Luck Tattoo and Body Piercing, because the professional artists at this Kailua shop will see to that. Head in for piercings for your eyebrow,… <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-furniture-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/furniture-stores\/\" target=\"_blank\">10 Best Furniture Stores in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/furniture-stores\/\" target=\"_blank\">Furnishings by Debi, Kailua-Kona, 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\">Furnishings by Debi is a unique twist on your typical furniture store. Focusing on high-end consignments, this shop is the perfect place to find pre-loved treasures at a quality level you won’t… <a href=\"https:\/\/bestthingshi.com\/furniture-stores\/\" 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-pet-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/pet-stores\/\" target=\"_blank\">10 Best Pet Stores in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/pet-stores\/\" target=\"_blank\">Kona Raw Pet Food Co-Op, Kailua Kona, 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\">Every pet parent who tries to give their pet the benefit of a raw diet knows that this is no easy feat. Kona Raw Pet Food Co-Op is a specialty pet store that aims to make this journey easier for pet… <a href=\"https:\/\/bestthingshi.com\/pet-stores\/\" 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-live-theater-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/live-theater\/\" target=\"_blank\">9 Best Live Theater Venues 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\/live-theater\/\" target=\"_blank\">Kahilu Theatre, Kamuela, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Kahilu Theatre in Kamuela presents a wide range of live performances, from talented musicians to ballet to musical theater. The theatre prides itself on being a place “where community,… <a href=\"https:\/\/bestthingshi.com\/live-theater\/\" 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_tag\",\"searchtag\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1761842531,"type":"Event","id":76229215,"title":"Honokaa Renaissance Faire","url":"\/event\/honokaa-renaissance-faire-2025-11-08-honokaa-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-1.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":1761864132,"type":"Place","id":1678670,"title":"Kaua'i Music Festival","url":"\/place\/kauai-music-festival-kamuela-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"}],"modified":"MongoDate(0.24500000 1761835332)","created":"MongoDate(0.24500000 1761835332)","_id":ObjectId ("690379447fd8456fbd079090")} , true) | | 0 | 0 | 2 |
| 45 | db.events_cache.find( {"_id":"66662c1503c74c5554d2cf298ab4e277"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 46 | db.events_radius_cache.find( {"_id":"8e5ed53bba396d717731f43519db143f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 47 | db.events.count( {"address.town_sef_url":"waikoloa-hi","start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762408800)"}} ) | | 0 | 2 | 3 |
| 48 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762668000)"}} ) | | 0 | 3 | 73 |
| 49 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-155.83700561523438,19.829200744628906],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762668000)"}} ) | | 0 | 6 | 65 |
| 50 | db.events_radius_cache.count( {"_id":"8e5ed53bba396d717731f43519db143f"} ) | | 0 | 0 | 1 |
| 51 | db.events_radius_cache.insert( {"_id":"8e5ed53bba396d717731f43519db143f","radius":25,"modified":"MongoDate(0.41700000 1761835332)","created":"MongoDate(0.41700000 1761835332)"} , true) | | 0 | 0 | 2 |
| 52 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[76229215]},"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 | 17 |
| 53 | db.events_cache.count( {"_id":"66662c1503c74c5554d2cf298ab4e277"} ) | | 0 | 0 | 1 |
| 54 | db.events_cache.count( {"_id":"66662c1503c74c5554d2cf298ab4e277"} ) | | 0 | 0 | 2 |
| 55 | db.events_cache.insert( {"_id":"66662c1503c74c5554d2cf298ab4e277","town_sef_url":"waikoloa-hi","data_key":["68187a7ffb5e4bed1ffaa750","6819cc42fb5e4bed1f9a9008","6819cc4dfb5e4bed1f9a9ee3","683d9e907573f111e776e780","681b1e69fb5e4bed1f28c5fc"],"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.45900000 1761835332)","created":"MongoDate(0.45900000 1761835332)"} , true) | | 0 | 0 | 1 |
| 56 | 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 | 3 |
| 57 | db.places.find( {"address.town_sef_url":"waikoloa-hi","group_id":{"$nin":[1678670]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 58 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 2 |
| 59 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 60 | db.tokens.find( {"sef_url":{"$in":["usa","hi","hawaii-county-hi","waikoloa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
