| 1 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 14 |
| 2 | db.towns.find( {"sef_url":"waimanalo-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
| 3 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 6 |
| 5 | db.ttd_towns.find( {"town_sef_url":"waimanalo-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 17 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 8 |
| 7 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 10 |
| 8 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
| 9 | 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(1765658303544)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765658303544)","$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 | 39 |
| 10 | db.ttd_towns.find( {"town_sef_url":"waimanalo-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 11 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 12 | db.events_cache.find( {"_id":"9699b83598193d92348bf8d32b6c3dd2"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 13 |
| 13 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766296799)"},"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 | 28 |
| 14 | db.events_cache.count( {"_id":"9699b83598193d92348bf8d32b6c3dd2"} ) | | 0 | 0 | 1 |
| 15 | db.events_cache.count( {"_id":"9699b83598193d92348bf8d32b6c3dd2"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.insert( {"_id":"9699b83598193d92348bf8d32b6c3dd2","town_sef_url":"waimanalo-hi","data_key":["69169295de4ae56f5ad4e42c"],"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.79200000 1765658303)","created":"MongoDate(0.79200000 1765658303)"} , true) | | 0 | 0 | 2 |
| 17 | db.events_cache.find( {"_id":"7c6669ad62a2354732574c8a8e4f635d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 10 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766296799)"},"event_id":{"$nin":[76335628]},"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 | 19 |
| 19 | db.events_cache.count( {"_id":"7c6669ad62a2354732574c8a8e4f635d"} ) | | 0 | 0 | 3 |
| 20 | db.events_cache.count( {"_id":"7c6669ad62a2354732574c8a8e4f635d"} ) | | 0 | 0 | 29 |
| 21 | 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.98600000 1765658303)","created":"MongoDate(0.98600000 1765658303)"} , true) | | 0 | 0 | 1 |
| 22 | db.events_cache.find( {"_id":"492ad9e9f06f4669bee4ce9a909da99c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 7 |
| 23 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1766901599)"},"event_id":{"$nin":[76335628]},"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 | 28 |
| 24 | db.events_cache.count( {"_id":"492ad9e9f06f4669bee4ce9a909da99c"} ) | | 0 | 0 | 37 |
| 25 | db.events_cache.count( {"_id":"492ad9e9f06f4669bee4ce9a909da99c"} ) | | 0 | 0 | 25 |
| 26 | 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.22000000 1765658304)","created":"MongoDate(0.22000000 1765658304)"} , true) | | 0 | 0 | 2 |
| 27 | db.events_cache.find( {"_id":"30444f245d0d508eba18f124688be4f7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 28 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1765951199)"},"event_id":{"$nin":[76335628]},"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 | 2 | 8 |
| 29 | db.events_cache.count( {"_id":"30444f245d0d508eba18f124688be4f7"} ) | | 0 | 0 | 1 |
| 30 | db.events_cache.count( {"_id":"30444f245d0d508eba18f124688be4f7"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.insert( {"_id":"30444f245d0d508eba18f124688be4f7","town_sef_url":"waimanalo-hi","data_key":["68512af8fb5e4bed1fa7db94"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":true}","modified":"MongoDate(0.30000000 1765658304)","created":"MongoDate(0.30000000 1765658304)"} , true) | | 0 | 0 | 17 |
| 32 | db.events_cache.find( {"_id":"6369cc2a19198f552e4f827715a580af"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 9 |
| 33 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1767506399)"},"event_id":{"$nin":[76335628,75794777]},"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 | 42 | 215 |
| 34 | db.events_cache.count( {"_id":"6369cc2a19198f552e4f827715a580af"} ) | | 0 | 0 | 66 |
| 35 | db.events_cache.count( {"_id":"6369cc2a19198f552e4f827715a580af"} ) | | 0 | 0 | 10 |
| 36 | db.events_cache.insert( {"_id":"6369cc2a19198f552e4f827715a580af","town_sef_url":"waimanalo-hi","data_key":["68dde21fc3af739f25c566f7","68dde21fc3af739f25c567c0","68b8f82ac3af739f25568274","68b8f82ac3af739f255682c7","68b8f82ac3af739f25568306","68b8f82ac3af739f25568368","68b8f82bc3af739f2556838b","68d74abcc3af739f25e1e209","68b8f82bc3af739f25568422","68b8f82bc3af739f2556844d","687f4f92fb5e4bed1f73d5fd","68b8f82bc3af739f255684dc","69251312de4ae56f5a2520f5","689d5a3efb5e4bed1f4b017e","68d74abdc3af739f25e1e35b","689ab73efb5e4bed1fded3f3","689d5a3efb5e4bed1f4b01f7","69251312de4ae56f5a2521a4","68d74abdc3af739f25e1e408","68e86e1ec3af739f25218ea7","68a2a04cfb5e4bed1fbe5471","68a2a04cfb5e4bed1fbe5483","68a2a04cfb5e4bed1fbe5491","68a2a04cfb5e4bed1fbe54a8","690ab51cde4ae56f5a840ed7","68639ff5fb5e4bed1fa5e9ff","690ab51cde4ae56f5a840f0c","69266493de4ae56f5ae4877a","6930f092de4ae56f5aa6e8dd","69266493de4ae56f5ae48797","690ab51cde4ae56f5a840f68","690ab51cde4ae56f5a840f77","690c0697de4ae56f5a9c0c24","690c0697de4ae56f5a9c0c3a","690c0697de4ae56f5a9c0c4f","690c0698de4ae56f5a9c0cd5","6917e415de4ae56f5a8ffbe0","6917e415de4ae56f5a8ffbea","6917e415de4ae56f5a8ffbed","6917e415de4ae56f5a8ffc19","6895714afb5e4bed1fd7728d","6895714afb5e4bed1fd772b7"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.7209930419922,21.347900390625],\"has_next_page\":false}","modified":"MongoDate(0.85500000 1765658304)","created":"MongoDate(0.85500000 1765658304)"} , true) | | 0 | 0 | 2 |
| 37 | db.events_cache.find( {"_id":"922e794f16067cf06fc994fa87d9fb83"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 37 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)","$lt":"MongoDate(0.00000000 1767506399)"},"event_id":{"$nin":[76335628,75794777,76119644]},"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 | 16 |
| 39 | db.events_cache.count( {"_id":"922e794f16067cf06fc994fa87d9fb83"} ) | | 0 | 0 | 40 |
| 40 | db.events_cache.count( {"_id":"922e794f16067cf06fc994fa87d9fb83"} ) | | 0 | 0 | 8 |
| 41 | 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.18600000 1765658305)","created":"MongoDate(0.18600000 1765658305)"} , true) | | 0 | 0 | 6 |
| 42 | db.places.find( {"geo":{"$near":[-157.7209930419922,21.347900390625],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 23 |
| 43 | 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’s a popular place to take a break with the family at any time. This 18-hole course is accompanied by a frisbee golf… <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-skate-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\/skate-shops\/\" target=\"_blank\">The 9 Best Skate 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\/skate-shops\/\" target=\"_blank\">808 Skate, 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\">Open for more than 10 years, 808 Skate is owned and run by skaters. They offer the best selection of skateboarding equipment on the island and in their online shop. Decks, wheels, trucks, and… <a href=\"https:\/\/bestthingshi.com\/skate-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-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’s 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-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-cooking-classes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/cooking-classes\/\" target=\"_blank\">10 Best Cooking Classes 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\/cooking-classes\/\" target=\"_blank\">Windward Community College, Kaneohe, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">You don’t have to be a culinary student to learn from the experts at Windward Community College. This local institution proudly offers a one-day baking class to teach you all the basics you… <a href=\"https:\/\/bestthingshi.com\/cooking-classes\/\" 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-breweries-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/breweries\/\" target=\"_blank\">9 Best Breweries 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\/breweries\/\" target=\"_blank\">Lanikai Brewing Company, 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\">Considered by many to be a hidden gem, this small tasting room is worth a visit. Using local ingredients like Lilikoi foraged in the valley and cacao from the Big Island, Lanikai Brewing is committed… <a href=\"https:\/\/bestthingshi.com\/breweries\/\" 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\">808 Tattoo, Kaneohe, 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\">808 Tattoo is a highly awarded tattoo shop that has become a favorite among locals and vacationers alike at both its Kaneohe and Honolulu locations. The shop gladly offers free consultations to make… <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-bubble-tea-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\">6 Best Bubble Tea 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\/bubble-tea\/\" target=\"_blank\">Dragon Tea, 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\">Dragon Tea is a great spot for traditional Chinese dishes and snacks such as tea eggs, fish ball soup, and beef noodle soup. As dessert, they offer a wide range of teas flavored entirely with natural… <a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" 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":1765661903,"type":"Event","id":76335628,"title":"Hawaii's Finest 16 Year Anniversary","url":"\/event\/hawaiis-finest-16-year-anniversary-2025-12-13-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/c9d\/5b517289-8afc-4433-a049-a78310466c9d_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1765661904,"type":"Event","id":75794777,"title":"Holiday JCCH Craft and Collectibles Fair","url":"\/event\/holiday-jcch-craft-and-collectibles-fair-2025-12-13-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-1.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1765672704,"type":"Event","id":76119644,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-2025-12-17-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_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":1765687105,"type":"Place","id":1707403,"title":"Kona Brewing Company","url":"\/place\/kona-brewing-company-honolulu-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"}],"modified":"MongoDate(0.27900000 1765658305)","created":"MongoDate(0.27900000 1765658305)","_id":ObjectId ("693dcec18829d2a0230b0501")} , true) | | 0 | 0 | 1 |
| 44 | db.events_cache.find( {"_id":"b019999cdf1c698270acee6a7f592aff"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 44 |
| 45 | db.events_radius_cache.find( {"_id":"3cbbc099cdbc6fc10db2ce5a8a440dcf"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 74 |
| 46 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"event_id":{"$nin":[76335628,75794777,76119644]},"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 | 738 |
| 47 | db.events_cache.count( {"_id":"b019999cdf1c698270acee6a7f592aff"} ) | | 0 | 0 | 26 |
| 48 | db.events_cache.count( {"_id":"b019999cdf1c698270acee6a7f592aff"} ) | | 0 | 0 | 11 |
| 49 | db.events_cache.insert( {"_id":"b019999cdf1c698270acee6a7f592aff","town_sef_url":"waimanalo-hi","data_key":["68512ad1fb5e4bed1fa78fe4","68fc9bccf957a70c3306dd57","68fc9c93b968d244290c2f01","68512b00fb5e4bed1fa7ed76","68fca36334c9e7cdf6042e6b"],"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.29500000 1765658306)","created":"MongoDate(0.29500000 1765658306)"} , true) | | 0 | 0 | 5 |
| 50 | 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 | 90 |
| 51 | db.places.find( {"address.town_sef_url":"waimanalo-hi","group_id":{"$nin":[1707403]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 9 |
| 52 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 6 |
| 53 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 13 |
| 54 | db.towns.find( {"sef_url":"waimanalo-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 55 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waimanalo-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 7 |
| 56 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 84 |
| 57 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 58 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 11 |
| 59 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 28 |
| 60 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 51 |
| 61 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 16 |
| 62 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
