| 1 | db.towns.find( {"sef_url":"mcbh-kaneohe-bay-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 | 8 |
| 3 | db.towns.find( {"sef_url":"mcbh-kaneohe-bay-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","mcbh-kaneohe-bay-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 3 | 1 |
| 5 | db.ttd_towns.find( {"town_sef_url":"mcbh-kaneohe-bay-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 | 2 |
| 7 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 8 |
| 8 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-157.75502014160156,21.388479232788086],"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(1767120526631)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1767120526631)","$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 | 72 |
| 10 | db.ttd_towns.find( {"town_sef_url":"mcbh-kaneohe-bay-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 11 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 12 | db.events_cache.find( {"_id":"cbcf5b9825d608a9a0711e4b7f6ecfa1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 13 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 15 |
| 14 | db.events_cache.count( {"_id":"cbcf5b9825d608a9a0711e4b7f6ecfa1"} ) | | 0 | 0 | 1 |
| 15 | db.events_cache.insert( {"_id":"cbcf5b9825d608a9a0711e4b7f6ecfa1","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["693321074389be6be5655a66"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.75300000 1767120526)","created":"MongoDate(0.75300000 1767120526)"} , true) | | 0 | 0 | 2 |
| 16 | db.events_cache.find( {"_id":"0aaff87b80dc116d109d01298c792892"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 17 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 |
| 18 | db.events_cache.count( {"_id":"0aaff87b80dc116d109d01298c792892"} ) | | 0 | 0 | 2 |
| 19 | db.events_cache.insert( {"_id":"0aaff87b80dc116d109d01298c792892","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.87400000 1767120526)","created":"MongoDate(0.87400000 1767120526)"} , true) | | 0 | 0 | 2 |
| 20 | db.events_cache.find( {"_id":"6fa7eb3a805a729b68e6e29776c54c5e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 21 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 53 |
| 22 | db.events_cache.count( {"_id":"6fa7eb3a805a729b68e6e29776c54c5e"} ) | | 0 | 0 | 1 |
| 23 | db.events_cache.insert( {"_id":"6fa7eb3a805a729b68e6e29776c54c5e","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.00700000 1767120527)","created":"MongoDate(0.00700000 1767120527)"} , true) | | 0 | 0 | 2 |
| 24 | db.events_cache.find( {"_id":"d31530008fce154369ea11b510c32139"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 25 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 3 |
| 26 | db.events_cache.count( {"_id":"d31530008fce154369ea11b510c32139"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"d31530008fce154369ea11b510c32139","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.02600000 1767120527)","created":"MongoDate(0.02600000 1767120527)"} , true) | | 0 | 0 | 2 |
| 28 | db.events_cache.find( {"_id":"6d2c3e7c77107a13e64e0e27194f8765"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 |
| 30 | db.events_cache.count( {"_id":"6d2c3e7c77107a13e64e0e27194f8765"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.insert( {"_id":"6d2c3e7c77107a13e64e0e27194f8765","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.04400000 1767120527)","created":"MongoDate(0.04400000 1767120527)"} , true) | | 0 | 0 | 1 |
| 32 | db.events_cache.find( {"_id":"6ca174aeeb07665bcdf868ba17db8c3c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 33 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 276 |
| 34 | db.events_cache.count( {"_id":"6ca174aeeb07665bcdf868ba17db8c3c"} ) | | 0 | 0 | 1 |
| 35 | db.events_cache.insert( {"_id":"6ca174aeeb07665bcdf868ba17db8c3c","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["693321074389be6be5655bba"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.34000000 1767120527)","created":"MongoDate(0.34000000 1767120527)"} , true) | | 0 | 0 | 1 |
| 36 | db.events_cache.find( {"_id":"515aaa88f1815b4cfc221181812366dd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 37 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785,76304788]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 252 |
| 38 | db.events_cache.count( {"_id":"515aaa88f1815b4cfc221181812366dd"} ) | | 0 | 0 | 1 |
| 39 | db.events_cache.insert( {"_id":"515aaa88f1815b4cfc221181812366dd","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["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","693321124389be6be565b2ab","693321124389be6be565b342","693321134389be6be565b4c3","693321134389be6be565b7cf","693321134389be6be565baaa","693321134389be6be565bb14","68a75b7a03a70639b6cfc322","693321144389be6be565c020","68a75b7a03a70639b6cfc679","69036afe4389be6be5f6c616","69036afe4389be6be5f6c7cd","693321174389be6be565d512","693321174389be6be565d7b0","693321174389be6be565d968"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.67800000 1767120527)","created":"MongoDate(0.67800000 1767120527)"} , true) | | 0 | 0 | 3 |
| 40 | db.events_cache.find( {"_id":"0725a00ee36e8c907af9ee6ed0cc238b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 41 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785,76304788,76370724]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 |
| 42 | db.events_cache.count( {"_id":"0725a00ee36e8c907af9ee6ed0cc238b"} ) | | 0 | 0 | 1 |
| 43 | db.events_cache.insert( {"_id":"0725a00ee36e8c907af9ee6ed0cc238b","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.75502014160156,21.388479232788086],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.80100000 1767120527)","created":"MongoDate(0.80100000 1767120527)"} , true) | | 0 | 0 | 2 |
| 44 | db.places.find( {"geo":{"$near":[-157.75502014160156,21.388479232788086],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 91 |
| 45 | 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":"mcbh-kaneohe-bay-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":1767124126,"type":"Event","id":76304785,"title":"Big Daddy Kane With Live Band","url":"\/event\/big-daddy-kane-with-live-band-2025-12-30-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/e9f\/ef625275-3e8e-42bd-8f1f-fd1fbe9dfe9f_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":1767124127,"type":"Event","id":76304788,"title":"Big Daddy Kane With Live Band","url":"\/event\/big-daddy-kane-with-live-band-1-2025-12-30-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/e9f\/ef625275-3e8e-42bd-8f1f-fd1fbe9dfe9f_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":1767134927,"type":"Event","id":76370724,"title":"Wheatus","url":"\/event\/wheatus-2026-01-12-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/4d8\/d00906ca-e871-451f-8c2d-da5864d164d8_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":1767149327,"type":"Place","id":2222342,"title":"Ahuimanu Fun Fair","url":"\/place\/ahuimanu-fun-fair-kaneohe-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-1.jpg"}],"modified":"MongoDate(0.91100000 1767120527)","created":"MongoDate(0.91100000 1767120527)","_id":ObjectId ("69541e8f75f302d6070774f1")} , true) | | 0 | 0 | 3 |
| 46 | db.events_cache.find( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 47 | db.events_radius_cache.find( {"_id":"93223d51dff2f0402d3098dec21cd8df"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 48 | db.events.count( {"address.town_sef_url":"mcbh-kaneohe-bay-hi","start":{"$gte":"MongoDate(0.00000000 1767074400)","$lt":"MongoDate(0.00000000 1767679200)"}} ) | | 0 | 0 | 2 |
| 49 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767074400)","$lt":"MongoDate(0.00000000 1767938400)"}} ) | | 0 | 0 | 20 |
| 50 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767074400)","$lt":"MongoDate(0.00000000 1767938400)"}} ) | | 0 | 17 | 19 |
| 51 | db.events_radius_cache.count( {"_id":"93223d51dff2f0402d3098dec21cd8df"} ) | | 0 | 0 | 1 |
| 52 | db.events_radius_cache.insert( {"_id":"93223d51dff2f0402d3098dec21cd8df","radius":15,"modified":"MongoDate(0.98000000 1767120527)","created":"MongoDate(0.98000000 1767120527)"} , true) | | 0 | 0 | 1 |
| 53 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"event_id":{"$nin":[76304785,76304788,76370724]},"geo":{"$geoWithin":{"$center":[[-157.75502014160156,21.388479232788086],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 | 271 |
| 54 | db.events_cache.count( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd"} ) | | 0 | 0 | 1 |
| 55 | db.events_cache.count( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.insert( {"_id":"392f79d5dacb4a6b9a0c0007e91157dd","town_sef_url":"mcbh-kaneohe-bay-hi","data_key":["68a75b6d03a70639b6cf600d","693321084389be6be5655e53","693321084389be6be5656145","693321084389be6be5656219","693321084389be6be5656261"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Mcbh Kaneohe Bay\",\"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.388479232788086,\"lng\":-157.75502014160156,\"latlng\":\"21.388479232788,-157.7550201416\",\"city\":\"Mcbh Kaneohe Bay\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.39800000 1767120528)","created":"MongoDate(0.39800000 1767120528)"} , true) | | 0 | 0 | 2 |
| 57 | db.news.find( {"broadcast":{"$in":["usa","mcbh-kaneohe-bay-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 | 9 |
| 58 | db.places.find( {"address.town_sef_url":"mcbh-kaneohe-bay-hi","group_id":{"$nin":[2222342]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 0 | 2 |
| 59 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 2 |
| 60 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
