| 1 | db.towns.find( {"sef_url":"kapaa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.towns.find( {"sef_url":"kapaa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","hi","kauai-county-hi","kapaa-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 4 | db.ttd_towns.find( {"town_sef_url":"kapaa-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 | 2 |
| 6 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-159.35299682617188,22.09869956970215],"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(1766427244647)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766427244647)","$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 | 49 |
| 7 | db.ttd_towns.find( {"town_sef_url":"kapaa-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 | 1 |
| 9 | db.events_cache.find( {"_id":"85361b4a8b63f215b8a7de7607f6ea38"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 10 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 2 | 4 |
| 11 | db.events_cache.count( {"_id":"85361b4a8b63f215b8a7de7607f6ea38"} ) | | 0 | 0 | 1 |
| 12 | db.events_cache.insert( {"_id":"85361b4a8b63f215b8a7de7607f6ea38","town_sef_url":"kapaa-hi","data_key":["69036af04389be6be5f657cd"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.74100000 1766427244)","created":"MongoDate(0.74100000 1766427244)"} , true) | | 0 | 0 | 2 |
| 13 | db.events_cache.find( {"_id":"4820db172c6444a915112c28a0faf852"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 58 |
| 15 | db.events_cache.count( {"_id":"4820db172c6444a915112c28a0faf852"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.insert( {"_id":"4820db172c6444a915112c28a0faf852","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.87000000 1766427244)","created":"MongoDate(0.87000000 1766427244)"} , true) | | 0 | 0 | 2 |
| 17 | db.events_cache.find( {"_id":"c426857923454a0e91574f5da7313b2d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 59 |
| 19 | db.events_cache.count( {"_id":"c426857923454a0e91574f5da7313b2d"} ) | | 0 | 0 | 1 |
| 20 | db.events_cache.insert( {"_id":"c426857923454a0e91574f5da7313b2d","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.00600000 1766427245)","created":"MongoDate(0.00600000 1766427245)"} , true) | | 0 | 0 | 2 |
| 21 | db.events_cache.find( {"_id":"8d8a9ebc13ac7dcf2a1584b56bfb94c5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 22 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 |
| 23 | db.events_cache.count( {"_id":"8d8a9ebc13ac7dcf2a1584b56bfb94c5"} ) | | 0 | 0 | 1 |
| 24 | db.events_cache.insert( {"_id":"8d8a9ebc13ac7dcf2a1584b56bfb94c5","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.02600000 1766427245)","created":"MongoDate(0.02600000 1766427245)"} , true) | | 0 | 0 | 2 |
| 25 | db.events_cache.find( {"_id":"c68813af12f5332e6aa01ca51b1c3179"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 26 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 |
| 27 | db.events_cache.count( {"_id":"c68813af12f5332e6aa01ca51b1c3179"} ) | | 0 | 0 | 1 |
| 28 | db.events_cache.insert( {"_id":"c68813af12f5332e6aa01ca51b1c3179","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.04800000 1766427245)","created":"MongoDate(0.04800000 1766427245)"} , true) | | 0 | 0 | 2 |
| 29 | db.events_cache.find( {"_id":"dc5cea26f03e89af50117e312255622b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 265 |
| 31 | db.events_cache.count( {"_id":"dc5cea26f03e89af50117e312255622b"} ) | | 0 | 0 | 2 |
| 32 | db.events_cache.insert( {"_id":"dc5cea26f03e89af50117e312255622b","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.58900000 1766427245)","created":"MongoDate(0.58900000 1766427245)"} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"9576f4c02c28810efabf97f3ab6a15df"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 271 |
| 35 | db.events_cache.count( {"_id":"9576f4c02c28810efabf97f3ab6a15df"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.insert( {"_id":"9576f4c02c28810efabf97f3ab6a15df","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.15100000 1766427246)","created":"MongoDate(0.15100000 1766427246)"} , true) | | 0 | 0 | 2 |
| 37 | db.events_cache.find( {"_id":"f82dcaa1c6ae414f0b5c00868fd96ccb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 0 | 260 |
| 39 | db.events_cache.count( {"_id":"f82dcaa1c6ae414f0b5c00868fd96ccb"} ) | | 0 | 0 | 2 |
| 40 | db.events_cache.insert( {"_id":"f82dcaa1c6ae414f0b5c00868fd96ccb","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.72800000 1766427246)","created":"MongoDate(0.72800000 1766427246)"} , true) | | 0 | 0 | 1 |
| 41 | db.events_cache.find( {"_id":"478940a4b256333e28d59f5b7f9aac26"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 42 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],0.6521739130434783]}}}, ["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 | 311 |
| 43 | db.events_cache.count( {"_id":"478940a4b256333e28d59f5b7f9aac26"} ) | | 0 | 0 | 1 |
| 44 | db.events_cache.insert( {"_id":"478940a4b256333e28d59f5b7f9aac26","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"45\",\"days\":\"15\",\"show\":1,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.31100000 1766427247)","created":"MongoDate(0.31100000 1766427247)"} , true) | | 0 | 0 | 1 |
| 45 | db.events_cache.find( {"_id":"71856e77c003e88c57cad9f3495c379a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 46 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 7 | 200 |
| 47 | db.events_cache.count( {"_id":"71856e77c003e88c57cad9f3495c379a"} ) | | 0 | 0 | 1 |
| 48 | db.events_cache.insert( {"_id":"71856e77c003e88c57cad9f3495c379a","town_sef_url":"kapaa-hi","data_key":["69036af44389be6be5f67cdf","69036af64389be6be5f689b2","69036afd4389be6be5f6beeb","69036b034389be6be5f6ec5e","69036b064389be6be5f6fefa","69036b104389be6be5f73ea5","69036b124389be6be5f74d25"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.68900000 1766427247)","created":"MongoDate(0.68900000 1766427247)"} , true) | | 0 | 0 | 1 |
| 49 | db.events_cache.find( {"_id":"435dec9e34a6acc37a688666cc4e57a7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 50 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098,76199104]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 39 |
| 51 | db.events_cache.count( {"_id":"435dec9e34a6acc37a688666cc4e57a7"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"435dec9e34a6acc37a688666cc4e57a7","town_sef_url":"kapaa-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.35299682617188,22.09869956970215],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.78100000 1766427247)","created":"MongoDate(0.78100000 1766427247)"} , true) | | 0 | 0 | 2 |
| 53 | db.places.find( {"geo":{"$near":[-159.35299682617188,22.09869956970215],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 42 | 9 |
| 54 | 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-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\">JO2 Restaurant, Kapa\u02bba, 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\">In Chef Jean-Marie Josselin’s world, food is art. His dishes, inspired by locally-grown vegetables and the best the sea offers, are a tribute to his native French roots and influenced by… <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-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\">Little Tsunami Tattoo and Art Studio, Kapa\u2019a, 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\">Located in Old Town Kapa’a, Little Tsunami Tattoo brings anything but destruction to those who choose this parlor for their body art. Both of the talented artists at this tattoo shop create… <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\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-swimming-pools-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\/swimming-pools\/\" target=\"_blank\">6 Best Public Swimming Pools 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\/swimming-pools\/\" target=\"_blank\">Kapaa Swimming Pool, Kapaa, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,community-life-bt,community-life-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">There is no better place for scorching hot days than Kapaa Swimming Pool! Take a dive into the water and let the cool water wash over you. Dive in and check out all the wonderful things this public… <a href=\"https:\/\/bestthingshi.com\/article\/swimming-pools\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-hiking-trail-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hiking\/\" target=\"_blank\">10 Best Hiking Trails in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/hiking\/\" target=\"_blank\">Kalalau Trail, Kauai, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,recreation-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">The Kalalau Trail is a well-known destination for Hawaiians and visitors alike. The full trail is a whopping 22 miles long, but you can choose any sections you want. This is a particularly… <a href=\"https:\/\/bestthingshi.com\/hiking\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-bike-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\/bike-shops\/\" target=\"_blank\">The 7 Best Bike 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\/bike-shops\/\" target=\"_blank\">Kauai Cycle, Kapaa, 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\">Not be outdone by their stylish cycling jerseys, Kauai Cycle also offers bicycle repairs and other apparel. Just off the beach path, you will find affordable bike rentals and knowledgeable staff to… <a href=\"https:\/\/bestthingshi.com\/bike-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-tacos-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tacos\/\" target=\"_blank\">10 Best Tacos 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\/tacos\/\" target=\"_blank\">El Taco Feliz, Kapaa, 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,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Taco lovers rejoice! El Taco Feliz is here to make your dreams come true! This delightful restaurant has been serving up delicious tacos that have become the talk of the town. El Taco Feliz offers an… <a href=\"https:\/\/bestthingshi.com\/tacos\/\" 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\">Ganesha Body Piercing and Jewelry, Kapa\u2019a, 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\">Excellence is the name of the game at Ganesha Body Piercing and Jewelry. This appointment-only shop takes great care to make sure every client has a positive experience and receives a safe piercing… <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-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\">The 9 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\">Passion Bakery Caf\u00e9, Kapaa, Kauai, 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\">If your Hawaiian adventure takes you to the Garden Isle of Kauai, be sure to stop by Passion Bakery Café. You’ll find that some of their pastries and bread, such as their mild whole… <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-breakfast-spot-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/breakfast-spots\/\" target=\"_blank\">The 10 Best Breakfast Spots 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\/breakfast-spots\/\" target=\"_blank\">Kountry Kitchen, Kapaa, 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\">One of the best places on the island of Kauai to try the Hawaiian specialty, loco moco, this breakfast spot in Kapaa is worth waiting in line. Try the loco moco with pork, rather than beef, for a… <a href=\"https:\/\/bestthingshi.com\/breakfast-spots\/\" 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\">The 10 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\">Java Kai, Kapaa, Kauai, 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\">You can't miss this neon building in the heart of Kapaa— and that's a good thing! A counter-service coffeehouse that serves a variety of light fare in a space adorned with local art, Java Kai… <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<\/div>\n<\/div>\n\n\n","town_sef_url":"kapaa-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\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1766430844,"type":"Event","id":76199098,"title":"Hawaii Rainbow Warriors Mens Basketball vs. UC Irvine Anteaters Mens Basketball","url":"\/event\/hawaii-rainbow-warriors-mens-basketball-vs-uc-irvine-anteaters-mens-basketball-2026-01-10-tm-hanamaulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/29516a.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":1766441647,"type":"Event","id":76199104,"title":"Hawaii Rainbow Warriors Mens Basketball vs. California Riverside Highlanders Mens Basketball","url":"\/event\/hawaii-rainbow-warriors-mens-basketball-vs-california-riverside-highlanders-mens-basketball-2026-03-05-tm-hanamaulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/29516a.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":1766456047,"type":"Place","id":2196448,"title":"Kauai Matsuri Festival","url":"\/place\/kauai-matsuri-festival-lihue-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-1.jpg"}],"modified":"MongoDate(0.80500000 1766427247)","created":"MongoDate(0.80500000 1766427247)","_id":ObjectId ("69498a6f8b9a70bee9020149")} , true) | | 0 | 0 | 2 |
| 55 | db.events_cache.find( {"_id":"e453b973e64d7ba5a69fb5b53231858d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 56 | db.events_radius_cache.find( {"_id":"3092a04193c553f0c4abac1c494f6732"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 57 | db.events.count( {"address.town_sef_url":"kapaa-hi","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} ) | | 0 | 0 | 2 |
| 58 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 0 | 28 |
| 59 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 0 | 25 |
| 60 | db.events_radius_cache.count( {"_id":"3092a04193c553f0c4abac1c494f6732"} ) | | 0 | 0 | 1 |
| 61 | db.events_radius_cache.insert( {"_id":"3092a04193c553f0c4abac1c494f6732","radius":25,"modified":"MongoDate(0.88500000 1766427247)","created":"MongoDate(0.88500000 1766427247)"} , true) | | 0 | 0 | 1 |
| 62 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76199098,76199104]},"geo":{"$geoWithin":{"$center":[[-159.35299682617188,22.09869956970215],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 | 263 |
| 63 | db.events_cache.count( {"_id":"e453b973e64d7ba5a69fb5b53231858d"} ) | | 0 | 0 | 1 |
| 64 | db.events_cache.count( {"_id":"e453b973e64d7ba5a69fb5b53231858d"} ) | | 0 | 0 | 1 |
| 65 | db.events_cache.insert( {"_id":"e453b973e64d7ba5a69fb5b53231858d","town_sef_url":"kapaa-hi","data_key":["68a75b6903a70639b6cf49a1","68a75b7003a70639b6cf7464","68a75b7103a70639b6cf8413","69036af44389be6be5f67cdf","69036af64389be6be5f689b2"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Kapaa\",\"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\":22.09869956970215,\"lng\":-159.35299682617188,\"latlng\":\"22.098699569702,-159.35299682617\",\"city\":\"Kapaa\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.18600000 1766427248)","created":"MongoDate(0.18600000 1766427248)"} , true) | | 0 | 0 | 1 |
| 66 | db.news.find( {"broadcast":{"$in":["usa","kapaa-hi","hi","kauai-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 6 |
| 67 | db.places.find( {"address.town_sef_url":"kapaa-hi","group_id":{"$nin":[2196448]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 4 |
