| 1 | db.towns.find( {"sef_url":"pearl-harbor-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.ttd_towns.find( {"town_sef_url":"pearl-harbor-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 3 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | 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(1761746286396)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761746286396)","$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 | 43 |
| 5 | db.ttd_towns.find( {"town_sef_url":"pearl-harbor-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 7 | db.events_cache.find( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 8 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"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 | 35 |
| 9 | db.events_cache.count( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1"} ) | | 0 | 0 | 1 |
| 10 | db.events_cache.insert( {"_id":"e8df6e024620b006b3b418b7f0a6dcd1","town_sef_url":"pearl-harbor-hi","data_key":["685bb723fb5e4bed1fb64fb7"],"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.52100000 1761746286)","created":"MongoDate(0.52100000 1761746286)"} , true) | | 0 | 0 | 2 |
| 11 | db.events_cache.find( {"_id":"71b4c56a2bad9fcec875713bf29a82c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75853720]},"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 | 105 |
| 13 | db.events_cache.count( {"_id":"71b4c56a2bad9fcec875713bf29a82c8"} ) | | 0 | 0 | 1 |
| 14 | 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.76200000 1761746286)","created":"MongoDate(0.76300000 1761746286)"} , true) | | 0 | 0 | 2 |
| 15 | db.events_cache.find( {"_id":"fff3dd6ae1b21fd1d348290ed5777107"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 16 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75853720]},"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 | 110 |
| 17 | db.events_cache.count( {"_id":"fff3dd6ae1b21fd1d348290ed5777107"} ) | | 0 | 0 | 1 |
| 18 | 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.01600000 1761746287)","created":"MongoDate(0.01600000 1761746287)"} , true) | | 0 | 0 | 2 |
| 19 | db.events_cache.find( {"_id":"348f8b5c9a300693e91c108c6338bc6d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 20 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75853720]},"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 | 2 | 15 |
| 21 | db.events_cache.count( {"_id":"348f8b5c9a300693e91c108c6338bc6d"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"348f8b5c9a300693e91c108c6338bc6d","town_sef_url":"pearl-harbor-hi","data_key":["68e3b9361f575976390b7788"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":true}","modified":"MongoDate(0.05500000 1761746287)","created":"MongoDate(0.05500000 1761746287)"} , true) | | 0 | 0 | 3 |
| 23 | db.events_cache.find( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75853720,76214463]},"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 | 51 | 204 |
| 25 | db.events_cache.count( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.insert( {"_id":"5c3525b91aa65b8b6bb9138d36d89e4d","town_sef_url":"pearl-harbor-hi","data_key":["685bb724fb5e4bed1fb651e2","68a7d4aac3af739f25821c57","68a7d4aac3af739f25821cbe","68d4a79fc3af739f2544f6eb","68a7d4aac3af739f25821d52","6881f248fb5e4bed1fd3ac30","68a7d4aac3af739f25821e2e","68b503adc3af739f2549f652","68ca1b9fc3af739f25d7e9fb","68ca1b9fc3af739f25d7eabf","68a92628c3af739f252fb232","68a92628c3af739f252fb28a","68a92628c3af739f252fb2d3","68ce1024c3af739f25eb132f","6881f24ffb5e4bed1fd3b696","68a92628c3af739f252fb3a0","6821b4e5fb5e4bed1fb5d4e0","68ca1ba0c3af739f25d7edb9","6881f252fb5e4bed1fd3ba6b","68ca1ba0c3af739f25d7ef22","68ad1aa6c3af739f25f089a9","68ad1aa6c3af739f25f08a5c","68f1a89ac3af739f25dd52a2","68527c76fb5e4bed1f025396","68dde21cc3af739f25c550fd","682af1cdfb5e4bed1f75bc6e","68db3f1dc3af739f258524bc","682af1defb5e4bed1f75e2c6","682c412efb5e4bed1f5cfe8b","682c4145fb5e4bed1f5d350a","682c414dfb5e4bed1f5d4480","68ca1ba1c3af739f25d7f744","68ca1ba1c3af739f25d7f845","68f0571ec3af739f25945c40","68f0571ec3af739f25945cc8","68941fbefb5e4bed1fb93603","683429fbfb5e4bed1faafc2d","6853cdebfb5e4bed1f55c504","68917cbefb5e4bed1f58ea5d","68357b80fb5e4bed1f717407","68357b9bfb5e4bed1f71ad9e","68ca1ba1c3af739f25d7fe9a","6841595cfb5e4bed1fbab538","68dc909dc3af739f25fd1c19","68ca1ba1c3af739f25d80042","68ca1ba1c3af739f25d80077","68d5f925c3af739f25932bba","68d5f925c3af739f25932c46","683d6512fb5e4bed1f078dfd","68e5cb1dc3af739f25c76908"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.94700622558594,21.35140037536621],\"has_next_page\":true}","modified":"MongoDate(0.43800000 1761746287)","created":"MongoDate(0.43800000 1761746287)"} , true) | | 0 | 0 | 2 |
| 27 | db.events_cache.find( {"_id":"1ec8105ef05993b62cc7ac49388a9cfe"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 28 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75853720,76214463,76162062]},"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 | 120 |
| 29 | db.events_cache.count( {"_id":"1ec8105ef05993b62cc7ac49388a9cfe"} ) | | 0 | 0 | 1 |
| 30 | 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.68600000 1761746287)","created":"MongoDate(0.68600000 1761746287)"} , true) | | 0 | 0 | 2 |
| 31 | db.places.find( {"geo":{"$near":[-157.94700622558594,21.35140037536621],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 6 |
| 32 | 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-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-thrift-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\/thrift-shops\/\" target=\"_blank\">The 6 Best Thrift 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\/thrift-shops\/\" target=\"_blank\">Aloha Stadium Swap Meet & Marketplace, 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\">Aloha Stadium Swap Meet is the largest outdoor flea market in Hawaii and it is open on Wednesday, Saturday, and Sunday mornings and early afternoons. At this marketplace, you’ll find local… <a href=\"https:\/\/bestthingshi.com\/thrift-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-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-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-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-bubble-tea-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\">6 Best Bubble Tea Places in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\">Tea Time Taiwan, Pearl City, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Tea Time Taiwan is an authentic Taiwanese dessert place specialized in bubble tea, smoothies, puddings, and honey toast. The menu is huge here, with orders ranging from simple, like black tea, to… <a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" 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<\/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":1761749886,"type":"Event","id":75853720,"title":"Johnny Stimson","url":"\/event\/johnny-stimson-2025-10-29-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/12\/59\/62\/74_Edp.jpg?v=12"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1761749887,"type":"Event","id":76214463,"title":"Hawai'i Food and Wine Festival - Slanted and Phan-tastic: A Celebration of Charles Phan","url":"\/event\/hawaii-food-and-wine-festival-slanted-and-phantastic-a-celebration-of-charles-phan-2025-10-30-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-wine-festival-1.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1761760687,"type":"Event","id":76162062,"title":"Exotica Reborn: The WAITIKI 7 Live\u00a0","url":"\/event\/exotica-reborn-the-waitiki-7-live-2025-11-27-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/18\/20\/23_Edp.jpg?v=13"},{"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":1761775087,"type":"Place","id":2202536,"title":"MOHS Music Booster Winter Craft Fair","url":"\/place\/mohs-music-booster-winter-craft-fair-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-2.jpg"}],"modified":"MongoDate(0.71200000 1761746287)","created":"MongoDate(0.71200000 1761746287)","_id":ObjectId ("69021d6fcc47e87bcb04726a")} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"9babea863864cb32ee4ade7f02e918b9"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events_radius_cache.find( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 35 | db.events.count( {"address.town_sef_url":"pearl-harbor-hi","start":{"$gte":"MongoDate(0.00000000 1761714000)","$lt":"MongoDate(0.00000000 1762322400)"}} ) | | 0 | 0 | 1 |
| 36 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1761714000)","$lt":"MongoDate(0.00000000 1762581600)"}} ) | | 0 | 11 | 91 |
| 37 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.94700622558594,21.35140037536621],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1761714000)","$lt":"MongoDate(0.00000000 1762581600)"}} ) | | 0 | 61 | 87 |
| 38 | db.events_radius_cache.count( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b"} ) | | 0 | 0 | 1 |
| 39 | db.events_radius_cache.insert( {"_id":"7fe9729db4e1e4a898291e2579fbbc1b","radius":15,"modified":"MongoDate(0.92900000 1761746287)","created":"MongoDate(0.92900000 1761746287)"} , true) | | 0 | 0 | 2 |
| 40 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75853720,76214463,76162062]},"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( 6 ).skip( 0 ) | | 0 | 6 | 166 |
| 41 | db.events_cache.count( {"_id":"9babea863864cb32ee4ade7f02e918b9"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.count( {"_id":"9babea863864cb32ee4ade7f02e918b9"} ) | | 0 | 0 | 1 |
| 43 | db.events_cache.insert( {"_id":"9babea863864cb32ee4ade7f02e918b9","town_sef_url":"pearl-harbor-hi","data_key":["6815d793fb5e4bed1feb37dd","6815d796fb5e4bed1feb3c10","6815d786fb5e4bed1feb1375","685bb724fb5e4bed1fb651e2","681728fffb5e4bed1f84afa0"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Pearl Harbor\",\"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.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.15300000 1761746288)","created":"MongoDate(0.15300000 1761746288)"} , true) | | 0 | 0 | 2 |
| 44 | 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 | 3 |
| 45 | db.places.find( {"address.town_sef_url":"pearl-harbor-hi","group_id":{"$nin":[2202536]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 1 | 2 |
| 46 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 2 |
| 47 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 48 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","pearl-harbor-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
