| 1 | db.towns.find( {"sef_url":"kailua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 3 |
| 3 | db.towns.find( {"sef_url":"kailua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","kailua-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 5 | db.ttd_towns.find( {"town_sef_url":"kailua-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 7 | 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(1766459602100)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766459602100)","$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 | 54 |
| 8 | db.ttd_towns.find( {"town_sef_url":"kailua-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 9 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.events_cache.find( {"_id":"bd66cdb3ce02b0fa997401c860c73f69"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 11 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"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 | 16 |
| 12 | db.events_cache.count( {"_id":"bd66cdb3ce02b0fa997401c860c73f69"} ) | | 0 | 0 | 1 |
| 13 | db.events_cache.insert( {"_id":"bd66cdb3ce02b0fa997401c860c73f69","town_sef_url":"kailua-hi","data_key":["69036ae54389be6be5f61b4d"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.21700000 1766459602)","created":"MongoDate(0.21700000 1766459602)"} , true) | | 0 | 0 | 2 |
| 14 | db.events_cache.find( {"_id":"80bdbb8e2d054d89bc62a469f58918c6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 15 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663]},"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 | 52 |
| 16 | db.events_cache.count( {"_id":"80bdbb8e2d054d89bc62a469f58918c6"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"80bdbb8e2d054d89bc62a469f58918c6","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.34000000 1766459602)","created":"MongoDate(0.34000000 1766459602)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"f71ec10fd8312900a15dee1af9f5045f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663]},"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 | 47 |
| 20 | db.events_cache.count( {"_id":"f71ec10fd8312900a15dee1af9f5045f"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.insert( {"_id":"f71ec10fd8312900a15dee1af9f5045f","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.45200000 1766459602)","created":"MongoDate(0.45200000 1766459602)"} , true) | | 0 | 0 | 2 |
| 22 | db.events_cache.find( {"_id":"ef8482313d0cea73bcd5f536e75c76c3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 23 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663]},"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 | 2 |
| 24 | db.events_cache.count( {"_id":"ef8482313d0cea73bcd5f536e75c76c3"} ) | | 0 | 0 | 1 |
| 25 | db.events_cache.insert( {"_id":"ef8482313d0cea73bcd5f536e75c76c3","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.46900000 1766459602)","created":"MongoDate(0.46900000 1766459602)"} , true) | | 0 | 0 | 2 |
| 26 | db.events_cache.find( {"_id":"e150fb0ed6622cc8ad2b71c5c6422d15"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 27 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663]},"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 | 3 |
| 28 | db.events_cache.count( {"_id":"e150fb0ed6622cc8ad2b71c5c6422d15"} ) | | 0 | 0 | 1 |
| 29 | db.events_cache.insert( {"_id":"e150fb0ed6622cc8ad2b71c5c6422d15","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.48900000 1766459602)","created":"MongoDate(0.48900000 1766459602)"} , true) | | 0 | 0 | 2 |
| 30 | db.events_cache.find( {"_id":"6fd2187abc16158e78fa751bf69603b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 31 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663]},"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 | 259 |
| 32 | db.events_cache.count( {"_id":"6fd2187abc16158e78fa751bf69603b1"} ) | | 0 | 0 | 1 |
| 33 | db.events_cache.insert( {"_id":"6fd2187abc16158e78fa751bf69603b1","town_sef_url":"kailua-hi","data_key":["68a75b6b03a70639b6cf5356"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.73599243164062,21.399700164794922],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.97100000 1766459602)","created":"MongoDate(0.97100000 1766459602)"} , true) | | 0 | 0 | 2 |
| 34 | db.events_cache.find( {"_id":"9e44367f62c8703f3d42c1195c634d99"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 35 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663,75798739]},"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 | 51 | 199 |
| 36 | db.events_cache.count( {"_id":"9e44367f62c8703f3d42c1195c634d99"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"9e44367f62c8703f3d42c1195c634d99","town_sef_url":"kailua-hi","data_key":["68a75b6803a70639b6cf4116","68a75b6803a70639b6cf41b9","68a75b6803a70639b6cf42d0","68a75b6803a70639b6cf435b","693321064389be6be56551b4","68a75b6b03a70639b6cf5501","693321064389be6be56553f3","693321074389be6be5655680","693321074389be6be56556dd","693321074389be6be5655771","693321074389be6be5655869","693321074389be6be565595a","693321074389be6be5655a66","693321074389be6be5655bba","693321084389be6be5655e53","693321084389be6be5656145","693321084389be6be5656219","693321084389be6be5656261","693321084389be6be5656309","693321094389be6be5656435","68a75b6f03a70639b6cf707c","68a75b6f03a70639b6cf71c7","68a75b6f03a70639b6cf739a","693321094389be6be5656a42","693321094389be6be5656b55","6933210a4389be6be5656c01","6933210a4389be6be5656cdf","6933210a4389be6be5656d9c","69036aef4389be6be5f6512c","6933210b4389be6be56571cc","69036aef4389be6be5f65464","69036af04389be6be5f6573b","6933210b4389be6be56576a7","69036af04389be6be5f65a81","6933210c4389be6be5657a0e","6933210e4389be6be56589bc","69036af54389be6be5f6802a","69036af64389be6be5f6852f","69036af64389be6be5f688e2","69036af74389be6be5f68d60","69036af74389be6be5f68f5b","693321104389be6be5659c87","693321104389be6be5659d99","69036af84389be6be5f698a8","69036af84389be6be5f69af0","68a75b7703a70639b6cfad35","68a75b7703a70639b6cfafa0","68a75b7703a70639b6cfb1c5","68a75b7803a70639b6cfb3a4","693321124389be6be565b1c0"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.73599243164062,21.399700164794922],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.24300000 1766459603)","created":"MongoDate(0.24300000 1766459603)"} , true) | | 0 | 0 | 2 |
| 38 | db.events_cache.find( {"_id":"ff38992c4ea2949392b1c9e3b62e611d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663,75798739,76264656]},"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 | 51 |
| 40 | db.events_cache.count( {"_id":"ff38992c4ea2949392b1c9e3b62e611d"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.insert( {"_id":"ff38992c4ea2949392b1c9e3b62e611d","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],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.35700000 1766459603)","created":"MongoDate(0.35700000 1766459603)"} , true) | | 0 | 0 | 1 |
| 42 | db.places.find( {"geo":{"$near":[-157.73599243164062,21.399700164794922],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 43 |
| 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-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\">Lanikai Pillbox Trail, Kailua, 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 Kaiwa Ridge is known for being a breathtakingly gorgeous locale, and you can see it all along the Lanikai Pillbox Trail. Take in views of Lanikai and Kailua on this challenging but rather short… <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-rock-climbing-gyms-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\/rock-climbing-gyms\/\" target=\"_blank\">Best Rock Climbing Gyms 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\/rock-climbing-gyms\/\" target=\"_blank\">Volcanic Rock Gym, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-6,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Kailua's premiere bouldering gym is an excellent place for climbers of all ages and ranks. With over a decade in the field, step into the breathtaking world of bouldering. Whether you're a newcomer… <a href=\"https:\/\/bestthingshi.com\/article\/rock-climbing-gyms\/\" 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-juice-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/juice-bars\/\" target=\"_blank\">8 Best Juice Bars in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/juice-bars\/\" target=\"_blank\">Lanikai Juice, Kailua, 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,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Lanikai Juice Hawaii brings a delicious and nutritious way to start your day! With fresh and healthy juices crafted with some of Hawaii's most iconic fruits, you can have all the flavors of the… <a href=\"https:\/\/bestthingshi.com\/article\/juice-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-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\">10 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,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-junk-removal-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\/junk-removal\/\" target=\"_blank\">5 Best Junk Removal Services 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\/junk-removal\/\" target=\"_blank\">Aloha Junk Man, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">The Aloha Junk Man is dedicated to providing superb client services and putting the safety of their clients first. They are fully licensed and insured and strive to preserve the island with donations… <a href=\"https:\/\/bestthingshi.com\/article\/junk-removal\/\" 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-florists-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/florists\/\" target=\"_blank\">9 Best Florists 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\/florists\/\" target=\"_blank\">Pali Florist & Gift Shop, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,moe,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">This family-run florist offers plenty of cheerful flower arrangements and gift baskets for any and all occasions. You can find a selection of exotic blooms for your special moments, as well as… <a href=\"https:\/\/bestthingshi.com\/florists\/\" 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-burritos-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\/burritos\/\" target=\"_blank\">10 Best Burrito Joints 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\/burritos\/\" target=\"_blank\">Bowles Burritos, Kailua, 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-yagee,edited-alli,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Forget traditional plate specials; at Bowles Burritos you get to create your own custom burrito with a hint of local flair. Fast and casual, you'll never want to miss a meal here. <a href=\"https:\/\/bestthingshi.com\/article\/burritos\/\" 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-mojitos-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\/mojitos\/\" target=\"_blank\">Best Mojitos 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\/mojitos\/\" target=\"_blank\">Mojito Cafe, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Try something truly special at Mojito Cafe! Step inside and be delighted by the colorful ambience and amazing aroma of Latin cuisine. Enjoy the freshest and most authentic dishes from the kitchen.… <a href=\"https:\/\/bestthingshi.com\/article\/mojitos\/\" 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-hvac-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\/hvac\/\" target=\"_blank\">10 Best HVAC Companies 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\/hvac\/\" target=\"_blank\">Island Cooling, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Island Cooling, founded in 2008, provides energy-efficient cooling products for comfortable and enjoyable homes. Whether you're looking for quality products that stand the test of time or great… <a href=\"https:\/\/bestthingshi.com\/article\/hvac\/\" 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-movie-theaters-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/movie-theaters\/\" target=\"_blank\">7 Best Movie Theaters 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\/movie-theaters\/\" target=\"_blank\">Kailua Cinemas, Kailua, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,entertainment-bt,entertainment-p300,moe,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Kailua Cinemas is the perfect spot for movie night! Enjoy luxury leather recliners and digital projection and sound in a strip-mall setting. Reserve a seat online and get ready for a fully-renovated… <a href=\"https:\/\/bestthingshi.com\/movie-theaters\/\" 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":1766463202,"type":"Event","id":76227663,"title":"Hawaii Bowl","url":"\/event\/hawaii-bowl-2025-12-24-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/db5\/5acfb9a3-4315-40c6-824f-e0fd31bd5db5_723691_TABLET_LANDSCAPE_LARGE_16_9.jpg"},{"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":1766463202,"type":"Event","id":75798739,"title":"Performance: Island Magic Mike","url":"\/event\/performance-island-magic-mike-2025-12-27-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-theater-6.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":1766474002,"type":"Event","id":76264656,"title":"The Green","url":"\/event\/the-green-1-2026-01-09-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/24\/81\/73_Edp.jpg?v=17"},{"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":1766488403,"type":"Place","id":1421402,"title":"Sea Life Park Hawaii","url":"\/place\/sea-life-park-hawaii-waimanalo-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-aquarium-15.jpg"}],"modified":"MongoDate(0.41800000 1766459603)","created":"MongoDate(0.41800000 1766459603)","_id":ObjectId ("694a08d31dcc4f4b570b8ae1")} , true) | | 0 | 0 | 2 |
| 44 | db.events_cache.find( {"_id":"b260fb725a5f06112b378f4b2fbe99c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 45 | db.events_radius_cache.find( {"_id":"f0407082f7e683a6b9ce1580994436c9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 46 | db.events.count( {"address.town_sef_url":"kailua-hi","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} ) | | 0 | 1 | 2 |
| 47 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 1 | 17 |
| 48 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.73599243164062,21.399700164794922],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} ) | | 0 | 29 | 18 |
| 49 | db.events_radius_cache.count( {"_id":"f0407082f7e683a6b9ce1580994436c9"} ) | | 0 | 0 | 1 |
| 50 | db.events_radius_cache.insert( {"_id":"f0407082f7e683a6b9ce1580994436c9","radius":15,"modified":"MongoDate(0.47900000 1766459603)","created":"MongoDate(0.47900000 1766459603)"} , true) | | 0 | 0 | 1 |
| 51 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"event_id":{"$nin":[76227663,75798739,76264656]},"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 | 192 |
| 52 | db.events_cache.count( {"_id":"b260fb725a5f06112b378f4b2fbe99c8"} ) | | 0 | 0 | 1 |
| 53 | db.events_cache.count( {"_id":"b260fb725a5f06112b378f4b2fbe99c8"} ) | | 0 | 0 | 1 |
| 54 | db.events_cache.insert( {"_id":"b260fb725a5f06112b378f4b2fbe99c8","town_sef_url":"kailua-hi","data_key":["68a75b6603a70639b6cf36dd","68a75b6603a70639b6cf36f3","68a75b6603a70639b6cf3766","68a75b6803a70639b6cf4116","68a75b6803a70639b6cf41b9"],"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.71500000 1766459603)","created":"MongoDate(0.71500000 1766459603)"} , true) | | 0 | 0 | 1 |
| 55 | 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 | 4 |
| 56 | db.places.find( {"address.town_sef_url":"kailua-hi","group_id":{"$nin":[1421402]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 11 |
