| 1 | db.towns.find( {"sef_url":"rehoboth-beach-de"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"pearl-harbor-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"pearl-harbor-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-157.94700622558594,21.35140037536621],"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(1769863971688)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769863971688)","$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 | 19 |
| 11 | db.ttd_towns.find( {"town_sef_url":"pearl-harbor-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 21 |
| 15 | db.events_cache.count( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1","town_sef_url":"pearl-harbor-hi","data_key":["6967019cb1faf7c56a6c99ed"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":true}","modified":"MongoDate(0.76400000 1769863971)","created":"MongoDate(0.76400000 1769863971)"} , true) | | 0 | 0 | 1 |
| 18 | db.events_cache.find( {"_id":"71b4c56a2bad9fcec875713bf29a82c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"event_id":{"$nin":[76454614]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 4 |
| 20 | db.events_cache.count( {"_id":"71b4c56a2bad9fcec875713bf29a82c8"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"71b4c56a2bad9fcec875713bf29a82c8"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"71b4c56a2bad9fcec875713bf29a82c8","town_sef_url":"pearl-harbor-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":false}","modified":"MongoDate(0.78500000 1769863971)","created":"MongoDate(0.78500000 1769863971)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"fff3dd6ae1b21fd1d348290ed5777107"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771135199)"},"event_id":{"$nin":[76454614]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 5 |
| 25 | db.events_cache.count( {"_id":"fff3dd6ae1b21fd1d348290ed5777107"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"fff3dd6ae1b21fd1d348290ed5777107"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"fff3dd6ae1b21fd1d348290ed5777107","town_sef_url":"pearl-harbor-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":false}","modified":"MongoDate(0.80900000 1769863971)","created":"MongoDate(0.80900000 1769863971)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"348f8b5c9a300693e91c108c6338bc6d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770184799)"},"event_id":{"$nin":[76454614]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events_cache.count( {"_id":"348f8b5c9a300693e91c108c6338bc6d"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"348f8b5c9a300693e91c108c6338bc6d"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"348f8b5c9a300693e91c108c6338bc6d","town_sef_url":"pearl-harbor-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":false}","modified":"MongoDate(0.82200000 1769863971)","created":"MongoDate(0.82200000 1769863971)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"6ab2bebe0bf9aa8fd8468780017c9cd6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1772517599)"},"event_id":{"$nin":[76454614]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 1 |
| 35 | db.events_cache.count( {"_id":"6ab2bebe0bf9aa8fd8468780017c9cd6"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"6ab2bebe0bf9aa8fd8468780017c9cd6"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"6ab2bebe0bf9aa8fd8468780017c9cd6","town_sef_url":"pearl-harbor-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":false}","modified":"MongoDate(0.83500000 1769863971)","created":"MongoDate(0.83500000 1769863971)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"7e3e43f3c46c57994c6ec14c3db38b83"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770357599)"},"event_id":{"$nin":[76454614]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 19 |
| 40 | db.events_cache.count( {"_id":"7e3e43f3c46c57994c6ec14c3db38b83"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"7e3e43f3c46c57994c6ec14c3db38b83"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"7e3e43f3c46c57994c6ec14c3db38b83","town_sef_url":"pearl-harbor-hi","data_key":["6967019cb1faf7c56a6c9a36"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":true}","modified":"MongoDate(0.87300000 1769863971)","created":"MongoDate(0.87300000 1769863971)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[76454614,76454534]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 46 | 38 |
| 45 | db.events_cache.count( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d","town_sef_url":"pearl-harbor-hi","data_key":["691e7b9ade4ae56f5a810ba4","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19","695dc38db1faf7c56a6c0c5e","69041d9ede4ae56f5ae0eecf","69251314de4ae56f5a252aaf","69041d9ede4ae56f5ae0eef6","689ab740fb5e4bed1fdee435","691d2a16de4ae56f5a437e49","6967019cb1faf7c56a6c9c92","689c08befb5e4bed1f1f9c5e","68fae321c3af739f25d95935","68fae321c3af739f25d95954","6944b711de4ae56f5ab96c5a","6967019cb1faf7c56a6c9d83","6944b711de4ae56f5ab96c8c","6944b711de4ae56f5ab96c98","6944b711de4ae56f5ab96cc0","69339394de4ae56f5aea31dc","6960668eb1faf7c56a141027","694f4310de4ae56f5a0c3166","69339394de4ae56f5aea322f","6967019db1faf7c56a6c9e8b","69339394de4ae56f5aea325c","6960668eb1faf7c56a1410b0","693cce13de4ae56f5ae98669","69339394de4ae56f5aea3298","6967019db1faf7c56a6c9f68","6960668fb1faf7c56a141147","694f4310de4ae56f5a0c31fb","691e7b9ade4ae56f5a811029","6960668fb1faf7c56a14119d","695dc38eb1faf7c56a6c1005","692f9f13de4ae56f5a523992","692f9f13de4ae56f5a5239a7","6967019db1faf7c56a6ca097","6938d997de4ae56f5aaaa9dd","6960668fb1faf7c56a14121c","69266495de4ae56f5ae493ed","6938d997de4ae56f5aaaab2a","6960668fb1faf7c56a14126f","69266495de4ae56f5ae4941e","6960668fb1faf7c56a141326","6967019db1faf7c56a6ca21d","695f150fb1faf7c56aac1a4f"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":false}","modified":"MongoDate(0.96300000 1769863971)","created":"MongoDate(0.96300000 1769863971)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"1ec8105ef05993b62cc7ac49388a9cfe"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[76454614,76454534,76356081]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],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 | 7 |
| 50 | db.events_cache.count( {"_id":"1ec8105ef05993b62cc7ac49388a9cfe"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"1ec8105ef05993b62cc7ac49388a9cfe"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"1ec8105ef05993b62cc7ac49388a9cfe","town_sef_url":"pearl-harbor-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":false}","modified":"MongoDate(0.99100000 1769863971)","created":"MongoDate(0.99100000 1769863971)"} , true) | | 0 | 0 | 1 |
| 53 | db.places.find( {"geo":{"$near":[-157.94700622558594,21.35140037536621],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 3 |
| 54 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-tattoo-parlor-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\">10 Best Tattoo Parlors in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\">TNT Tattoo and Body Piercings, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Tattoos, body piercings, whatever your flavor may be, TNT Tattoo can deliver. This popular tattoo parlor in the Honolulu suburb of Aiea is a destination for outstanding artwork of any size and… <a href=\"https:\/\/bestthingshi.com\/tattoo-parlors\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-italian-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/italian-restaurants\/\" target=\"_blank\">9 Best Italian Restaurants in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/italian-restaurants\/\" target=\"_blank\">Paesano Ristorante Italiano, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Enjoy great Italian food with the warm and welcoming Hawaiian atmosphere at Paesano Ristorante Italiano. This Aiea restaurant embodies the spirit of aloha and will make you feel like family from the… <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-shopping-outlet-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\">The 10 Best Shopping Malls and Outlets 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\/shopping-outlets\/\" target=\"_blank\">Pearlridge, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">As the second largest shopping center in Hawaii, Pearlridge offers a wide array of shops, restaurants, a movie theater, and weekly farmers’ market. After stopping at Aloha Soap Factory,… <a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" 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-crossfit-gym-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/crossfit\/\" target=\"_blank\">The 6 Best CrossFit 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\/crossfit\/\" target=\"_blank\">CrossFit Zeus, Aiea, 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\">Join this friendly, welcoming gym open to all levels that encourages all participants to cheer on other gym members during workouts. A variety of different classes are available at this box including… <a href=\"https:\/\/bestthingshi.com\/crossfit\/\" 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-mini-golf-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\">8 Best Mini Golf Courses in Hawaii<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\">Tropics Mini Golf, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Embrace the tropical atmosphere of Hawaii at Tropics Mini Golf. This award-winning mini golf course is in high demand. Check it out for a cool 18 holes with the family or host your next birthday… <a href=\"https:\/\/bestthingshi.com\/mini-golf\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-craft-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/craft-stores\/\" target=\"_blank\">9 Best Craft Stores 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\/craft-stores\/\" target=\"_blank\">Crafts Way LLC., Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">For all of your floral crafts, head to Crafts Way, which stocks foam, clay, and silk artificial flowers that are specially handcrafted. These flowers look very real and can be used in floral crafts… <a href=\"https:\/\/bestthingshi.com\/craft-stores\/\" 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-bike-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\/bike-shops\/\" target=\"_blank\">7 Best Bike 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\/bike-shops\/\" target=\"_blank\">The Bike Shop, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">With three locations on Oahu, the Bike Shop is convenient as well as community-friendly. Offering group rides (in certain seasons) and friendly advice for newbies, this shop has too many reasons to… <a href=\"https:\/\/bestthingshi.com\/bike-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-consignment-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\/consignment-shops\/\" target=\"_blank\">Best Consignment 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\/consignment-shops\/\" target=\"_blank\">Cater Kids, Waipahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Stop by anytime from 10 a.m. to 4 p.m. to consign gently used baby items, such as clothing and gear, to earn cash on the spot. Clothing and gear must all be in great condition and can range from size… <a href=\"https:\/\/bestthingshi.com\/consignment-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-kid-dentist-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/kid-friendly-dentists\/\" target=\"_blank\">7 Best Kid-Friendly Dentists 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\/kid-friendly-dentists\/\" target=\"_blank\">Aiea Pediatric Dental Center, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Dr. Derek Tom is the main dentist seeing patients at Aiea Pediatric Dental Center. He uses the latest dental technology, such as CO2 lasers and soft tissue surgery, to treat children and families… <a href=\"https:\/\/bestthingshi.com\/kid-friendly-dentists\/\" 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-shoe-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/shoe-stores\/\" target=\"_blank\">The 9 Best Shoe Stores 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\/shoe-stores\/\" target=\"_blank\">The Ultimate Foot Store, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">The Ultimate Foot Store is great for people who are on their feet all day, as they focus on orthotic footwear. In addition to shoe brands such as Birkenstock, Brooks, Vionic, and Hoka, the Ultimate… <a href=\"https:\/\/bestthingshi.com\/shoe-stores\/\" 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":"pearl-harbor-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":1769867571,"type":"Event","id":76454614,"title":"GEESE","url":"\/event\/geese-2026-01-31-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/e9f\/1ffb711c-f066-4afa-b36d-77260e885e9f_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":1769867571,"type":"Event","id":76454534,"title":"ARMNHMR (18+ Event)","url":"\/event\/armnhmr-18-event-2026-01-31-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/cc5\/b564516c-d6e9-4ed6-b7a0-a9c35075fcc5_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":1769878371,"type":"Event","id":76356081,"title":"Josh Groban","url":"\/event\/josh-groban-2026-02-07-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/92b\/53132b4d-9976-4fc2-96d5-8e978427392b_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":1769892771,"type":"Place","id":1786934,"title":"Hale Koa Hotel Oktoberfest","url":"\/place\/hale-koa-hotel-oktoberfest-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-beer-festival-2.jpg"}],"modified":"MongoDate(0.00500000 1769863972)","created":"MongoDate(0.00500000 1769863972)","_id":ObjectId ("697dfb24b919ad5e9d076926")} , true) | | 0 | 0 | 1 |
| 55 | db.events_cache.find( {"_id":"9babea863864cb32ee4ade7f02e918b9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 56 | db.events_radius_cache.find( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 57 | db.events.count( {"address.town_sef_url":"pearl-harbor-hi","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} ) | | 0 | 0 | 1 |
| 58 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 0 | 16 |
| 59 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 14 | 15 |
| 60 | db.events_radius_cache.count( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b"} ) | | 0 | 0 | 1 |
| 61 | db.events_radius_cache.count( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b"} ) | | 0 | 0 | 1 |
| 62 | db.events_radius_cache.insert( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b","radius":25,"modified":"MongoDate(0.05900000 1769863972)","created":"MongoDate(0.05900000 1769863972)"} , true) | | 0 | 0 | 1 |
| 63 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"event_id":{"$nin":[76454614,76454534,76356081]},"geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],0.36231884057971014]}}}, ["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 | 78 |
| 64 | db.events_cache.count( {"_id":"9babea863864cb32ee4ade7f02e918b9"} ) | | 0 | 0 | 1 |
| 65 | db.events_cache.count( {"_id":"9babea863864cb32ee4ade7f02e918b9"} ) | | 0 | 0 | 1 |
| 66 | db.events_cache.insert( {"_id":"9babea863864cb32ee4ade7f02e918b9","town_sef_url":"pearl-harbor-hi","data_key":["691e7b9ade4ae56f5a810ba4","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19","695dc38db1faf7c56a6c0c5e"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Pearl Harbor\",\"keyword\":\"\",\"radius\":25,\"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.35140037536621,\"lng\":-157.94700622558594,\"latlng\":\"21.351400375366,-157.94700622559\",\"city\":\"Pearl Harbor\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.15600000 1769863972)","created":"MongoDate(0.15600000 1769863972)"} , true) | | 0 | 0 | 1 |
| 67 | db.news.find( {"broadcast":{"$in":["usa","pearl-harbor-hi","hi","honolulu-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 68 | db.places.find( {"address.town_sef_url":"pearl-harbor-hi","group_id":{"$nin":[1786934]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 1 | 1 |
| 69 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 70 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 71 | db.towns.find( {"sef_url":"pearl-harbor-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 72 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","pearl-harbor-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 73 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 74 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 75 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 76 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 77 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 78 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 79 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
