| 1 | db.towns.find( {"sef_url":"waipahu-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.towns.find( {"sef_url":"waipahu-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waipahu-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 4 | db.ttd_towns.find( {"town_sef_url":"waipahu-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 5 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-158.01100158691406,21.38640022277832],"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(1766589149261)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766589149261)","$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 | 56 |
| 7 | db.ttd_towns.find( {"town_sef_url":"waipahu-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 9 | db.events_cache.find( {"_id":"e254b62b3878f9ad38878561fa5a2848"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 10 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 |
| 11 | db.events_cache.count( {"_id":"e254b62b3878f9ad38878561fa5a2848"} ) | | 0 | 0 | 1 |
| 12 | db.events_cache.insert( {"_id":"e254b62b3878f9ad38878561fa5a2848","town_sef_url":"waipahu-hi","data_key":["69036ae54389be6be5f61b4d"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.37400000 1766589149)","created":"MongoDate(0.37400000 1766589149)"} , true) | | 0 | 0 | 2 |
| 13 | db.events_cache.find( {"_id":"455b26c98b09eb89e6915293affcf40d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 8 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 66 |
| 15 | db.events_cache.count( {"_id":"455b26c98b09eb89e6915293affcf40d"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.insert( {"_id":"455b26c98b09eb89e6915293affcf40d","town_sef_url":"waipahu-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.52500000 1766589149)","created":"MongoDate(0.52500000 1766589149)"} , true) | | 0 | 0 | 2 |
| 17 | db.events_cache.find( {"_id":"be1bc1c19fdb4e4d63d1422409b17c0e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 59 |
| 19 | db.events_cache.count( {"_id":"be1bc1c19fdb4e4d63d1422409b17c0e"} ) | | 0 | 0 | 2 |
| 20 | db.events_cache.insert( {"_id":"be1bc1c19fdb4e4d63d1422409b17c0e","town_sef_url":"waipahu-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.65300000 1766589149)","created":"MongoDate(0.65300000 1766589149)"} , true) | | 0 | 0 | 2 |
| 21 | db.events_cache.find( {"_id":"2d2cb23478c6ca9ddc54320d63d9ea1a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 22 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 |
| 23 | db.events_cache.count( {"_id":"2d2cb23478c6ca9ddc54320d63d9ea1a"} ) | | 0 | 0 | 1 |
| 24 | db.events_cache.insert( {"_id":"2d2cb23478c6ca9ddc54320d63d9ea1a","town_sef_url":"waipahu-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.67300000 1766589149)","created":"MongoDate(0.67300000 1766589149)"} , true) | | 0 | 0 | 1 |
| 25 | db.events_cache.find( {"_id":"50742ed0d602fb7f3b2eb00180dfb2ba"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 26 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 |
| 27 | db.events_cache.count( {"_id":"50742ed0d602fb7f3b2eb00180dfb2ba"} ) | | 0 | 0 | 1 |
| 28 | db.events_cache.insert( {"_id":"50742ed0d602fb7f3b2eb00180dfb2ba","town_sef_url":"waipahu-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.69000000 1766589149)","created":"MongoDate(0.69000000 1766589149)"} , true) | | 0 | 0 | 2 |
| 29 | db.events_cache.find( {"_id":"ed3824ea7421cf24dfd5454f7606c355"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 292 |
| 31 | db.events_cache.count( {"_id":"ed3824ea7421cf24dfd5454f7606c355"} ) | | 0 | 0 | 2 |
| 32 | db.events_cache.insert( {"_id":"ed3824ea7421cf24dfd5454f7606c355","town_sef_url":"waipahu-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.34500000 1766589150)","created":"MongoDate(0.34500000 1766589150)"} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"96eca7682cad7b3346a5cdfa27459db1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 9 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 316 |
| 35 | db.events_cache.count( {"_id":"96eca7682cad7b3346a5cdfa27459db1"} ) | | 0 | 0 | 2 |
| 36 | db.events_cache.insert( {"_id":"96eca7682cad7b3346a5cdfa27459db1","town_sef_url":"waipahu-hi","data_key":["68a75b6803a70639b6cf4116"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.72000000 1766589150)","created":"MongoDate(0.72000000 1766589150)"} , true) | | 0 | 0 | 2 |
| 37 | db.events_cache.find( {"_id":"40949e589460314cbeb1898ba10821a8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663,76071093]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 290 |
| 39 | db.events_cache.count( {"_id":"40949e589460314cbeb1898ba10821a8"} ) | | 0 | 0 | 1 |
| 40 | db.events_cache.insert( {"_id":"40949e589460314cbeb1898ba10821a8","town_sef_url":"waipahu-hi","data_key":["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","693321124389be6be565b2ab"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.12300000 1766589151)","created":"MongoDate(0.12300000 1766589151)"} , true) | | 0 | 0 | 2 |
| 41 | db.events_cache.find( {"_id":"5bf4fc63e7a84abfa8ec661d0aed1dc8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 42 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663,76071093,76199260]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 57 |
| 43 | db.events_cache.count( {"_id":"5bf4fc63e7a84abfa8ec661d0aed1dc8"} ) | | 0 | 0 | 1 |
| 44 | db.events_cache.insert( {"_id":"5bf4fc63e7a84abfa8ec661d0aed1dc8","town_sef_url":"waipahu-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.01100158691406,21.38640022277832],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.25300000 1766589151)","created":"MongoDate(0.25300000 1766589151)"} , true) | | 0 | 0 | 2 |
| 45 | db.places.find( {"geo":{"$near":[-158.01100158691406,21.38640022277832],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 35 |
| 46 | 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-dog-kennel-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/dog-kennels\/\" target=\"_blank\">10 Best Dog Kennels 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\/dog-kennels\/\" target=\"_blank\">Kama'aina K9 Adventures, Waipahu, 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\">Doggie dreams come true at the island's first pup theme park! Spanning 2.5 acres, this doggie destination offers daycare, overnight care, training, board and train, grooming, and special events. A… <a href=\"https:\/\/bestthingshi.com\/dog-kennels\/\" 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-tutoring-services-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\/tutoring-services\/\" target=\"_blank\">5 Best Tutoring 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\/tutoring-services\/\" target=\"_blank\">Quick Stars Tutoring, Waipahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-options,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Quick Stars Tutoring is the perfect solution for quality one-on-one tutoring. With tutors that are highly qualified in every subject from pre-school to college level, Quick Stars Tutoring offers… <a href=\"https:\/\/bestthingshi.com\/article\/tutoring-services\/\" 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-roofers-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\/roofers\/\" target=\"_blank\">10 Best Roofers 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\/roofers\/\" target=\"_blank\">Kapili Solar Roofing, Waipahu, 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\">This company is here to provide freedom and a brighter future with their innovative services. They specialize in roofing, painting, waterproofing, and solar-powered roofing options, providing only… <a href=\"https:\/\/bestthingshi.com\/article\/roofers\/\" 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\">Oahu Bouldering Gym, Waipahu, 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\">Climb the walls and reach for the sky at Oahu Bouldering. Whether you're a seasoned rock climber or a novice looking to get out of a rut when it comes to exercise, everyone is welcome. With top rope… <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-plumbers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/plumbers\/\" target=\"_blank\">10 Best Plumbers 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\/plumbers\/\" target=\"_blank\">Emergency Plumbing & Solar, Waipahu, 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\">They are equipped with advanced technology to provide each of their customers with excellent plumbing services. Their team is committed to helping their community with high-quality services.… <a href=\"https:\/\/bestthingshi.com\/plumbers\/\" 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-painters-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\/painters\/\" target=\"_blank\">6 Best Painters 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\/painters\/\" target=\"_blank\">Kapili Solar Roofing & Painting, Waipahu, 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\">Kapili Solar Roofing & Painting makes exterior and interior painting look easy! With their expert staff, you'll know your painting needs are taken care of. Their excellent service and quality… <a href=\"https:\/\/bestthingshi.com\/article\/painters\/\" 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-dry-cleaners-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\/dry-cleaners\/\" target=\"_blank\">5 Best Dry Cleaners 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\/dry-cleaners\/\" target=\"_blank\">Aloha Dry Cleaners and Laundry, Waipahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Aloha Dry Cleaners and Laundry is an island oasis for laundry needs. Bring in your clothes to get expertly washed and folded for an affordable price. Enjoy a little slice of the Aloha spirit for all… <a href=\"https:\/\/bestthingshi.com\/article\/dry-cleaners\/\" 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-barber-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\/article\/barber-shops\/\" target=\"_blank\">10 Best Barber 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\/article\/barber-shops\/\" target=\"_blank\">Blend House, Pearl City, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-yagee,edited-alli,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">At Blend House, experienced barbers strive to create the perfect look for those seeking a new hairstyle. With precise cuts, blended fades, and attention to detail, clients can ensure that their… <a href=\"https:\/\/bestthingshi.com\/article\/barber-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-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\">Flo's Min Florists Inc., Pearl City, 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 relaxed flower shop offers a selection of wonderful arrangements and gift baskets that you can pick up or have delivered. From bright and vibrant hues to subtle and muted colors, Flo's Min… <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-swim-lessons-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\/swim-lessons\/\" target=\"_blank\">5 Best Swim Instructors 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\/swim-lessons\/\" target=\"_blank\">L\u0113\u02bbahi Swim School, Pearl City, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,community-life-bt,community-life-p300,moe,limited-options,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">L\u0113\u2018ahi Swim School is the perfect place for budding swimmers to learn! With two instructors per class at select levels, students can expect a nurturing and engaging learning environment. Get ready to… <a href=\"https:\/\/bestthingshi.com\/article\/swim-lessons\/\" 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":"waipahu-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":1766592749,"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\":\"15\",\"days\":\"15\",\"ttl\":\"2\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1766596350,"type":"Event","id":76071093,"title":"A Charlie Brown Christmas","url":"\/event\/a-charlie-brown-christmas-2025-12-24-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/08\/86\/13_Edp.jpg?v=4"},{"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":1766603550,"type":"Event","id":76199260,"title":"Rickie Lee Jones","url":"\/event\/rickie-lee-jones-2026-01-29-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/418\/17cab6dc-5d87-4b0f-826b-4d699ac26418_SOURCE"},{"rule":"{\"content_type\":\"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":1766617951,"type":"Place","id":2185147,"title":"Oahu Foodies Feastival","url":"\/place\/oahu-foodies-feastival-aiea-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-food-festival-2.jpg"}],"modified":"MongoDate(0.31500000 1766589151)","created":"MongoDate(0.31500000 1766589151)","_id":ObjectId ("694c02df63b98e37730067e6")} , true) | | 0 | 0 | 2 |
| 47 | db.events_cache.find( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 48 | db.events_radius_cache.find( {"_id":"fee673499f932919f037fe81b1864e30"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 49 | db.events.count( {"address.town_sef_url":"waipahu-hi","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} ) | | 0 | 3 | 2 |
| 50 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} ) | | 0 | 10 | 27 |
| 51 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} ) | | 0 | 38 | 30 |
| 52 | db.events_radius_cache.count( {"_id":"fee673499f932919f037fe81b1864e30"} ) | | 0 | 0 | 1 |
| 53 | db.events_radius_cache.insert( {"_id":"fee673499f932919f037fe81b1864e30","radius":15,"modified":"MongoDate(0.41100000 1766589151)","created":"MongoDate(0.41100000 1766589151)"} , true) | | 0 | 0 | 2 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663,76071093,76199260]},"geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],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 | 197 |
| 55 | db.events_cache.count( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217","town_sef_url":"waipahu-hi","data_key":["68a75b6803a70639b6cf41b9","68a75b6803a70639b6cf42d0","68a75b6803a70639b6cf435b","68a75b6803a70639b6cf43b1","68a75b6803a70639b6cf4401"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Waipahu\",\"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.38640022277832,\"lng\":-158.01100158691406,\"latlng\":\"21.386400222778,-158.01100158691\",\"city\":\"Waipahu\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.65800000 1766589151)","created":"MongoDate(0.65800000 1766589151)"} , true) | | 0 | 0 | 2 |
| 58 | db.news.find( {"broadcast":{"$in":["usa","waipahu-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 | 5 |
| 59 | db.places.find( {"address.town_sef_url":"waipahu-hi","group_id":{"$nin":[2185147]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 4 |
