| 1 | db.towns.find( {"sef_url":"winslow-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 6 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.towns.find( {"sef_url":"kailua-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 | 6 |
| 6 | db.ttd_towns.find( {"town_sef_url":"kailua-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.73599243164062,21.399700164794922],"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(1765783389793)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765783389793)","$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 | 75 |
| 11 | db.ttd_towns.find( {"town_sef_url":"kailua-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 9 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 13 | db.events_cache.find( {"_id":"ebe834882fea88e0cc877e402b6bff15"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766469599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 22 |
| 15 | db.events_cache.count( {"_id":"ebe834882fea88e0cc877e402b6bff15"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"ebe834882fea88e0cc877e402b6bff15"} ) | | 0 | 0 | 6 |
| 17 | db.events_cache.insert( {"_id":"ebe834882fea88e0cc877e402b6bff15","town_sef_url":"kailua-hi","data_key":["68b8f82ac3af739f25568274"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":true}","modified":"MongoDate(0.05400000 1765783390)","created":"MongoDate(0.05400000 1765783390)"} , true) | | 0 | 0 | 6 |
| 18 | db.events_cache.find( {"_id":"6e7fd648fe45d855dec0d70421679261"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 13 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766469599)"},"event_id":{"$nin":[76119648]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 17 |
| 20 | db.events_cache.count( {"_id":"6e7fd648fe45d855dec0d70421679261"} ) | | 0 | 0 | 5 |
| 21 | db.events_cache.count( {"_id":"6e7fd648fe45d855dec0d70421679261"} ) | | 0 | 0 | 11 |
| 22 | db.events_cache.insert( {"_id":"6e7fd648fe45d855dec0d70421679261","town_sef_url":"kailua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.16200000 1765783390)","created":"MongoDate(0.16200000 1765783390)"} , true) | | 0 | 0 | 10 |
| 23 | db.events_cache.find( {"_id":"462ad24c2bd637183e0164e798bd321c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 8 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767074399)"},"event_id":{"$nin":[76119648]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 22 |
| 25 | db.events_cache.count( {"_id":"462ad24c2bd637183e0164e798bd321c"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"462ad24c2bd637183e0164e798bd321c"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"462ad24c2bd637183e0164e798bd321c","town_sef_url":"kailua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.25100000 1765783390)","created":"MongoDate(0.25100000 1765783390)"} , true) | | 0 | 0 | 2 |
| 28 | db.events_cache.find( {"_id":"ca8707b14b6f5e0b473ce665be1fb1a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 5 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766123999)"},"event_id":{"$nin":[76119648]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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":"ca8707b14b6f5e0b473ce665be1fb1a1"} ) | | 0 | 0 | 3 |
| 31 | db.events_cache.count( {"_id":"ca8707b14b6f5e0b473ce665be1fb1a1"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"ca8707b14b6f5e0b473ce665be1fb1a1","town_sef_url":"kailua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.29100000 1765783390)","created":"MongoDate(0.29100000 1765783390)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"e4e48492ca293b6ed256727e31b2c93a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1768456799)"},"event_id":{"$nin":[76119648]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 2 |
| 35 | db.events_cache.count( {"_id":"e4e48492ca293b6ed256727e31b2c93a"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"e4e48492ca293b6ed256727e31b2c93a"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"e4e48492ca293b6ed256727e31b2c93a","town_sef_url":"kailua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.30900000 1765783390)","created":"MongoDate(0.30900000 1765783390)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"9f9fbdf25d686c4b38a68dad401cc0bb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766296799)"},"event_id":{"$nin":[76119648]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 1 | 66 |
| 40 | db.events_cache.count( {"_id":"9f9fbdf25d686c4b38a68dad401cc0bb"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"9f9fbdf25d686c4b38a68dad401cc0bb"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"9f9fbdf25d686c4b38a68dad401cc0bb","town_sef_url":"kailua-hi","data_key":["6900a3ef3af6aa547c08399f"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.43200000 1765783390)","created":"MongoDate(0.43200000 1765783390)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"24a6dff017370bff960db8038efff18d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767679199)"},"event_id":{"$nin":[76119648,76281179]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 51 |
| 45 | db.events_cache.count( {"_id":"24a6dff017370bff960db8038efff18d"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"24a6dff017370bff960db8038efff18d"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"24a6dff017370bff960db8038efff18d","town_sef_url":"kailua-hi","data_key":["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","6895714afb5e4bed1fd772c6","691d2a15de4ae56f5a437536"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.55500000 1765783390)","created":"MongoDate(0.55500000 1765783390)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"0c9cbabf5445aa5eeea535866f1b1308"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767679199)"},"event_id":{"$nin":[76119648,76281179,76119643]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 13 |
| 50 | db.events_cache.count( {"_id":"0c9cbabf5445aa5eeea535866f1b1308"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"0c9cbabf5445aa5eeea535866f1b1308"} ) | | 0 | 0 | 2 |
| 52 | db.events_cache.insert( {"_id":"0c9cbabf5445aa5eeea535866f1b1308","town_sef_url":"kailua-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.73599243164062,21.399700164794922],\"has_next_page\":false}","modified":"MongoDate(0.60200000 1765783390)","created":"MongoDate(0.60200000 1765783390)"} , true) | | 0 | 0 | 1 |
| 53 | db.places.find( {"geo":{"$near":[-157.73599243164062,21.399700164794922],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 4 |
| 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-pancakes-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/pancakes\/\" target=\"_blank\">The 8 Best Places for Pancakes 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\/pancakes\/\" target=\"_blank\">Boots and Kimo\u2019s, Kailua, 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\">Boots and Kimo’s is the original home of the macadamia nut pancake, making it a must-stop when seeking out the best pancakes on Hawaii. The pancakes here are thick and fluffy and topped with an… <a href=\"https:\/\/bestthingshi.com\/pancakes\/\" 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-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-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-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-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-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-guided-tours-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/guided-tours\/\" target=\"_blank\">The 10 Best Guided Tours 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\/guided-tours\/\" target=\"_blank\">Kailua Beach Adventures, Kailua, 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\">Get out on the water in your own kayak with a two hour (longer options are available) guided tour. This relaxed time on the water will take you past sea turtle feeding grounds, near bird nesting… <a href=\"https:\/\/bestthingshi.com\/guided-tours\/\" 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":"kailua-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":1765786989,"type":"Event","id":76119648,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-1-2025-12-16-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_SOURCE"},{"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":1765786990,"type":"Event","id":76281179,"title":"Koko Marina Craft and Vendor Fair","url":"\/event\/koko-marina-craft-and-vendor-fair-2025-12-20-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":1765797790,"type":"Event","id":76119643,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-1-2025-12-19-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":1765812190,"type":"Place","id":2010703,"title":"The Island Springtacular Craft and Gift Fair","url":"\/place\/the-island-springtacular-craft-and-gift-fair-kaneohe-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-2.jpg"}],"modified":"MongoDate(0.62200000 1765783390)","created":"MongoDate(0.62200000 1765783390)","_id":ObjectId ("693fb75e90dac3a56c0bce5b")} , true) | | 0 | 0 | 1 |
| 55 | db.events_cache.find( {"_id":"b260fb725a5f06112b378f4b2fbe99c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 56 | db.events_radius_cache.find( {"_id":"f0407082f7e683a6b9ce1580994436c9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 7 |
| 57 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"event_id":{"$nin":[76119648,76281179,76119643]},"geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],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 | 225 |
| 58 | db.events_cache.count( {"_id":"b260fb725a5f06112b378f4b2fbe99c8"} ) | | 0 | 0 | 35 |
| 59 | db.events_cache.count( {"_id":"b260fb725a5f06112b378f4b2fbe99c8"} ) | | 0 | 0 | 2 |
| 60 | db.events_cache.insert( {"_id":"b260fb725a5f06112b378f4b2fbe99c8","town_sef_url":"kailua-hi","data_key":["6853cdf8fb5e4bed1f55d45e","6853cdf9fb5e4bed1f55d558","6853cdf8fb5e4bed1f55d4d6","68b8f82ac3af739f255682c7","685670cdfb5e4bed1f3b1695"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Kailua\",\"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.399700164794922,\"lng\":-157.73599243164062,\"latlng\":\"21.399700164795,-157.73599243164\",\"city\":\"Kailua\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.01100000 1765783391)","created":"MongoDate(0.01100000 1765783391)"} , true) | | 0 | 0 | 1 |
| 61 | db.news.find( {"broadcast":{"$in":["usa","kailua-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":"kailua-hi","group_id":{"$nin":[2010703]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 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 | 1 |
| 65 | db.towns.find( {"sef_url":"kailua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 66 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","kailua-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 67 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 68 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 6 |
| 69 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 70 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 71 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 72 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 73 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
