| 1 | db.towns.find( {"sef_url":"mackinac-island-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"waimanalo-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"waimanalo-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-157.7209930419922,21.347900390625],"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(1769587066163)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769587066163)","$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 | 22 |
| 11 | db.ttd_towns.find( {"town_sef_url":"waimanalo-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"9699b83598193d92348bf8d32b6c3dd2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1770271199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 | 16 |
| 15 | db.events_cache.count( {"_id":"9699b83598193d92348bf8d32b6c3dd2"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"9699b83598193d92348bf8d32b6c3dd2"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"9699b83598193d92348bf8d32b6c3dd2","town_sef_url":"waimanalo-hi","data_key":["695f150db1faf7c56aac120d"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":true}","modified":"MongoDate(0.23500000 1769587066)","created":"MongoDate(0.23500000 1769587066)"} , true) | | 0 | 0 | 1 |
| 18 | db.events_cache.find( {"_id":"7c6669ad62a2354732574c8a8e4f635d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1770271199)"},"event_id":{"$nin":[76450592]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 |
| 20 | db.events_cache.count( {"_id":"7c6669ad62a2354732574c8a8e4f635d"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"7c6669ad62a2354732574c8a8e4f635d"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"7c6669ad62a2354732574c8a8e4f635d","town_sef_url":"waimanalo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.25700000 1769587066)","created":"MongoDate(0.25700000 1769587066)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"492ad9e9f06f4669bee4ce9a909da99c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1770875999)"},"event_id":{"$nin":[76450592]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 0 | 5 |
| 25 | db.events_cache.count( {"_id":"492ad9e9f06f4669bee4ce9a909da99c"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"492ad9e9f06f4669bee4ce9a909da99c"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"492ad9e9f06f4669bee4ce9a909da99c","town_sef_url":"waimanalo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.28200000 1769587066)","created":"MongoDate(0.28200000 1769587066)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"30444f245d0d508eba18f124688be4f7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1769925599)"},"event_id":{"$nin":[76450592]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 | 1 |
| 30 | db.events_cache.count( {"_id":"30444f245d0d508eba18f124688be4f7"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"30444f245d0d508eba18f124688be4f7"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"30444f245d0d508eba18f124688be4f7","town_sef_url":"waimanalo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.29900000 1769587066)","created":"MongoDate(0.29900000 1769587066)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"f5a9c67444ab3284286cbce73c608f06"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1772258399)"},"event_id":{"$nin":[76450592]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 | 1 |
| 35 | db.events_cache.count( {"_id":"f5a9c67444ab3284286cbce73c608f06"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"f5a9c67444ab3284286cbce73c608f06"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"f5a9c67444ab3284286cbce73c608f06","town_sef_url":"waimanalo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.31400000 1769587066)","created":"MongoDate(0.31400000 1769587066)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"4257d6c0bfe2761afd40143c117f91fe"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1770098399)"},"event_id":{"$nin":[76450592]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 | 2 | 14 |
| 40 | db.events_cache.count( {"_id":"4257d6c0bfe2761afd40143c117f91fe"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"4257d6c0bfe2761afd40143c117f91fe"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"4257d6c0bfe2761afd40143c117f91fe","town_sef_url":"waimanalo-hi","data_key":["68dc90a1c3af739f25fd3615"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":true}","modified":"MongoDate(0.34600000 1769587066)","created":"MongoDate(0.34600000 1769587066)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"6369cc2a19198f552e4f827715a580af"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1771480799)"},"event_id":{"$nin":[76450592,76199260]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 | 41 | 36 |
| 45 | db.events_cache.count( {"_id":"6369cc2a19198f552e4f827715a580af"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"6369cc2a19198f552e4f827715a580af"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"6369cc2a19198f552e4f827715a580af","town_sef_url":"waimanalo-hi","data_key":["68dc90a1c3af739f25fd3639","6967019cb1faf7c56a6c9981","6967019cb1faf7c56a6c99ed","6967019cb1faf7c56a6c9a36","691e7b9ade4ae56f5a810ba4","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19","695dc38db1faf7c56a6c0c5e","69041d9ede4ae56f5ae0eecf","69251314de4ae56f5a252aaf","69041d9ede4ae56f5ae0eef6","689ab740fb5e4bed1fdee435","691d2a16de4ae56f5a437e49","6967019cb1faf7c56a6c9c92","689c08befb5e4bed1f1f9c5e","68fae321c3af739f25d95935","68fae321c3af739f25d95954","6944b711de4ae56f5ab96c5a","6967019cb1faf7c56a6c9d83","6944b711de4ae56f5ab96c8c","6944b711de4ae56f5ab96c98","6944b711de4ae56f5ab96cc0","69339394de4ae56f5aea31dc","6960668eb1faf7c56a141027","694f4310de4ae56f5a0c3166","69339394de4ae56f5aea322f","6967019db1faf7c56a6c9e8b","69339394de4ae56f5aea325c","6960668eb1faf7c56a1410b0","693cce13de4ae56f5ae98669","69339394de4ae56f5aea3298","6967019db1faf7c56a6c9f68","6960668fb1faf7c56a141147","694f4310de4ae56f5a0c31fb","691e7b9ade4ae56f5a811029","6960668fb1faf7c56a14119d","695dc38eb1faf7c56a6c1005","692f9f13de4ae56f5a523992","692f9f13de4ae56f5a5239a7","6967019db1faf7c56a6ca097"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.44900000 1769587066)","created":"MongoDate(0.44900000 1769587066)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"922e794f16067cf06fc994fa87d9fb83"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1771480799)"},"event_id":{"$nin":[76450592,76199260,76451350]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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 | 11 |
| 50 | db.events_cache.count( {"_id":"922e794f16067cf06fc994fa87d9fb83"} ) | | 0 | 0 | 13 |
| 51 | db.events_cache.count( {"_id":"922e794f16067cf06fc994fa87d9fb83"} ) | | 0 | 0 | 10 |
| 52 | db.events_cache.insert( {"_id":"922e794f16067cf06fc994fa87d9fb83","town_sef_url":"waimanalo-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.58000000 1769587066)","created":"MongoDate(0.58000000 1769587066)"} , true) | | 0 | 0 | 3 |
| 53 | db.places.find( {"geo":{"$near":[-157.7209930419922,21.347900390625],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 5 |
| 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-mini-golf-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\">8 Best Mini Golf Courses 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\/mini-golf\/\" target=\"_blank\">Bellows Mini Golf, Waimanalo, 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\">Bellows Mini Golf is located on Bellows Air Force Base in Waimanalo, and it\u2019s a popular place to take a break with the family at any time. This 18-hole course is accompanied by a frisbee golf or disc… <a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" 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-italian-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/italian-restaurants\/\" target=\"_blank\">9 Best Italian 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\/italian-restaurants\/\" target=\"_blank\">Baci Bistro, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Give yourself a treat with a luxe night out at Baci Bistro. This upscale Italian restaurant has a well-curated menu of all your Italian favorites, but be sure to leave some room for its legendary… <a href=\"https:\/\/bestthingshi.com\/italian-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-romantic-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\/romantic-places\/\" target=\"_blank\">10 Most Romantic Places in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/romantic-places\/\" target=\"_blank\">Lanikai Beach, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,edited-shannen,valentines-day,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Lanikai Beach is one of those incredible, out-of-this-world beaches you see in movies and wonder if it\u2019s real. This pristine beach provides the perfect place to kick back and relax with your… <a href=\"https:\/\/bestthingshi.com\/romantic-places\/\" 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-antique-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/antique-stores\/\" target=\"_blank\">7 Best Antique 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\/antique-stores\/\" target=\"_blank\">Ali\u2019i Antiques, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">This shop has two locations on the big island and has been in business for almost 30 years. The first shop carries everything from European art glass to collectible figurines and pottery for those… <a href=\"https:\/\/bestthingshi.com\/antique-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-speakeasies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/speakeasy-bars\/\" target=\"_blank\">7 Best Speakeasies 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\/speakeasy-bars\/\" target=\"_blank\">Gaslamp, Kailua, 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\">Gaslamp has taken Kailua’s nightlife by storm. It’s the town’s only hidden speakeasy and it does not disappoint. Located inside the Kailua Town Pub and Grill, Gaslamp is known for… <a href=\"https:\/\/bestthingshi.com\/speakeasy-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-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\">Loyalty Tattoo, Kailua, 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 can get quality piercings you’ll be able to wear for a lifetime at Loyalty Tattoo. Along with custom tattoos, Loyalty Tattoo offers a range of body piercings as well as custom body… <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-paint-and-wine-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/paint-and-wine\/\" target=\"_blank\">Best Paint & Wine Spots in Hawaii 2026!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/paint-and-wine\/\" target=\"_blank\">Create a Canvas Oahu, Honolulu, 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\">Create a Canvas is a mobile art studio that brings painting and wine night to you. Get together with a group of friends and reserve a location (homes, parks, recreational center, etc.) and the staff… <a href=\"https:\/\/bestthingshi.com\/paint-and-wine\/\" 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-fried-chicken-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">10 Best Fried Chicken Joints in Hawaii for 2026!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">Lahaina Chicken Factory, Honolulu, 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\">Chicken is the name of the game at Lahaina Chicken Factory. Specializing in fried chicken and roast chicken, this popular favorite features individual combos as well as \u201cFamily Paks\u201d to satisfy the… <a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" 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\">J Salon, Honolulu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\"><p>J Salon is the perfect destination for incredible hair with a chic and trendy atmosphere. Feel like the fashionista you are at Honolulu\u2019s well-known J Salon.<\/p> <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-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\">Umeke Market, Honolulu, 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 you\u2019re in Honolulu, you don\u2019t have to look far for great vegan food. Umeke Market is the perfect spot to pick up a quick yet delicious lunch, with vegan dishes ranging from spaghetti to Korean… <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<\/div>\n<\/div>\n\n\n","town_sef_url":"waimanalo-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":1769590666,"type":"Event","id":76450592,"title":"East Side Jam","url":"\/event\/east-side-jam-2026-01-28-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/12\/78\/80\/54_Edp.jpg?v=6"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"10\",\"days\":\"5\",\"ttl\":\"1\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1769590666,"type":"Event","id":76199260,"title":"Rickie Lee Jones","url":"\/event\/rickie-lee-jones-2026-01-29-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/418\/17cab6dc-5d87-4b0f-826b-4d699ac26418_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769601466,"type":"Event","id":76451350,"title":"Hawaii Rainbow Warriors Baseball vs. Gonzaga Bulldogs Baseball","url":"\/event\/hawaii-rainbow-warriors-baseball-vs-gonzaga-bulldogs-baseball-2026-02-16-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/093\/c74cfd95-af21-4e64-9f85-47677b951093_105651_TABLET_LANDSCAPE_LARGE_16_9.jpg"},{"rule":"{\"content_type\":\"group_category\",\"radius\":\"10\",\"ttl\":\"8\",\"israndom\":1,\"group_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-1.jpg\",\"days\":1}","expiration":1769615866,"type":"Place","id":2163586,"title":"Koko Marina Craft and Vendor Fair","url":"\/place\/koko-marina-craft-and-vendor-fair-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-2.jpg"}],"modified":"MongoDate(0.61100000 1769587066)","created":"MongoDate(0.61100000 1769587066)","_id":ObjectId ("6979c17ae430abdc9b047f7c")} , true) | | 0 | 0 | 2 |
| 55 | db.events_cache.find( {"_id":"b019999cdf1c698270acee6a7f592aff"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 56 | db.events_radius_cache.find( {"_id":"3cbbc099cdbc6fc10db2ce5a8a440dcf"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 57 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)"},"event_id":{"$nin":[76450592,76199260,76451350]},"geo":{"$geoWithin":{"$center":[[-157.7209930419922,21.347900390625],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( 6 ).skip( 0 ) | | 0 | 6 | 160 |
| 58 | db.events_cache.count( {"_id":"b019999cdf1c698270acee6a7f592aff"} ) | | 0 | 0 | 4 |
| 59 | db.events_cache.count( {"_id":"b019999cdf1c698270acee6a7f592aff"} ) | | 0 | 0 | 1 |
| 60 | db.events_cache.insert( {"_id":"b019999cdf1c698270acee6a7f592aff","town_sef_url":"waimanalo-hi","data_key":["68dc90a1c3af739f25fd3639","6967019cb1faf7c56a6c9981","6967019cb1faf7c56a6c99ed","6967019cb1faf7c56a6c9a36","691e7b9ade4ae56f5a810ba4"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Waimanalo\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":21.347900390625,\"lng\":-157.7209930419922,\"latlng\":\"21.347900390625,-157.72099304199\",\"city\":\"Waimanalo\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.82800000 1769587066)","created":"MongoDate(0.82800000 1769587066)"} , true) | | 0 | 0 | 1 |
| 61 | db.news.find( {"broadcast":{"$in":["usa","waimanalo-hi","hi","honolulu-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 62 | db.places.find( {"address.town_sef_url":"waimanalo-hi","group_id":{"$nin":[2163586]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 63 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 64 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 3 |
| 65 | db.towns.find( {"sef_url":"waimanalo-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 66 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waimanalo-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 67 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 3 |
| 68 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 10 |
| 69 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 6 |
| 70 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
| 71 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 12 |
| 72 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 73 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
