| 1 | db.towns.find( {"sef_url":"loop-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"waipahu-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":"waipahu-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":[-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(1769769344666)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769769344666)","$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 | 21 |
| 11 | db.ttd_towns.find( {"town_sef_url":"waipahu-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":"f0fac141b7515b58bdc2196221ae0f95"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770443999)"},"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 | 18 |
| 15 | db.events_cache.count( {"_id":"f0fac141b7515b58bdc2196221ae0f95"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"f0fac141b7515b58bdc2196221ae0f95"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"f0fac141b7515b58bdc2196221ae0f95","town_sef_url":"waipahu-hi","data_key":["6967019cb1faf7c56a6c9981"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"has_next_page\":true}","modified":"MongoDate(0.75400000 1769769344)","created":"MongoDate(0.75400000 1769769344)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"543f59c1f8b84d5e4b3f518153d8de95"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770443999)"},"event_id":{"$nin":[76454525]},"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 | 4 |
| 20 | db.events_cache.count( {"_id":"543f59c1f8b84d5e4b3f518153d8de95"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"543f59c1f8b84d5e4b3f518153d8de95"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"543f59c1f8b84d5e4b3f518153d8de95","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],\"has_next_page\":false}","modified":"MongoDate(0.77900000 1769769344)","created":"MongoDate(0.77900000 1769769344)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"986fb801534061e4ed6031728e018eec"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771048799)"},"event_id":{"$nin":[76454525]},"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 | 6 |
| 25 | db.events_cache.count( {"_id":"986fb801534061e4ed6031728e018eec"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"986fb801534061e4ed6031728e018eec"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"986fb801534061e4ed6031728e018eec","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],\"has_next_page\":false}","modified":"MongoDate(0.80600000 1769769344)","created":"MongoDate(0.80600000 1769769344)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"bb30eafaa383ebf78293ee13e9a600bf"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770098399)"},"event_id":{"$nin":[76454525]},"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 |
| 30 | db.events_cache.count( {"_id":"bb30eafaa383ebf78293ee13e9a600bf"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"bb30eafaa383ebf78293ee13e9a600bf"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"bb30eafaa383ebf78293ee13e9a600bf","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],\"has_next_page\":false}","modified":"MongoDate(0.82800000 1769769344)","created":"MongoDate(0.82800000 1769769344)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"ee9f46599666089ed2e8a84d9f8013a6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1772431199)"},"event_id":{"$nin":[76454525]},"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 | 1 |
| 35 | db.events_cache.count( {"_id":"ee9f46599666089ed2e8a84d9f8013a6"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"ee9f46599666089ed2e8a84d9f8013a6"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"ee9f46599666089ed2e8a84d9f8013a6","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],\"has_next_page\":false}","modified":"MongoDate(0.84700000 1769769344)","created":"MongoDate(0.84700000 1769769344)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"45bb81b4397c768c8cd2b84a3ad40d0f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770271199)"},"event_id":{"$nin":[76454525]},"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 | 13 |
| 40 | db.events_cache.count( {"_id":"45bb81b4397c768c8cd2b84a3ad40d0f"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"45bb81b4397c768c8cd2b84a3ad40d0f"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"45bb81b4397c768c8cd2b84a3ad40d0f","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],\"has_next_page\":false}","modified":"MongoDate(0.88800000 1769769344)","created":"MongoDate(0.88800000 1769769344)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"52dc4ef07fba7ca1a201c23954ed657a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771135199)"},"event_id":{"$nin":[76454525]},"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 | 30 |
| 45 | db.events_cache.count( {"_id":"52dc4ef07fba7ca1a201c23954ed657a"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"52dc4ef07fba7ca1a201c23954ed657a"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"52dc4ef07fba7ca1a201c23954ed657a","town_sef_url":"waipahu-hi","data_key":["6967019cb1faf7c56a6c99ed"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.01100158691406,21.38640022277832],\"has_next_page\":true}","modified":"MongoDate(0.94100000 1769769344)","created":"MongoDate(0.94100000 1769769344)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"887b6ea7ed1e02622a2642b10c714c79"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771653599)"},"event_id":{"$nin":[76454525,76454614]},"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 | 44 | 37 |
| 50 | db.events_cache.count( {"_id":"887b6ea7ed1e02622a2642b10c714c79"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"887b6ea7ed1e02622a2642b10c714c79"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"887b6ea7ed1e02622a2642b10c714c79","town_sef_url":"waipahu-hi","data_key":["6967019cb1faf7c56a6c9a36","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"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.01100158691406,21.38640022277832],\"has_next_page\":false}","modified":"MongoDate(0.03200000 1769769345)","created":"MongoDate(0.03200000 1769769345)"} , true) | | 0 | 0 | 1 |
| 53 | db.events_cache.find( {"_id":"e83eeeaf53feea93ce556a80496fcfea"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1771653599)"},"event_id":{"$nin":[76454525,76454614,76358518]},"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 | 10 |
| 55 | db.events_cache.count( {"_id":"e83eeeaf53feea93ce556a80496fcfea"} ) | | 0 | 0 | 1 |
| 56 | db.events_cache.count( {"_id":"e83eeeaf53feea93ce556a80496fcfea"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"e83eeeaf53feea93ce556a80496fcfea","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],\"has_next_page\":false}","modified":"MongoDate(0.06600000 1769769345)","created":"MongoDate(0.06600000 1769769345)"} , true) | | 0 | 0 | 1 |
| 58 | db.places.find( {"geo":{"$near":[-158.01100158691406,21.38640022277832],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 3 |
| 59 | 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-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-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-pet-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\/pet-stores\/\" target=\"_blank\">10 Best Pet 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\/pet-stores\/\" target=\"_blank\">The Pet Hale, Mililani, 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 Pet Hale is a resource for Hawaiians with furry family members throughout the Mililani area. Not only does this pet shop offer an exceptional array of pet supplies and products but it helps to… <a href=\"https:\/\/bestthingshi.com\/pet-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-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-kids-birthday-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/birthday-party-places-for-kids\/\" target=\"_blank\">7 Best Places for a Kid\u2019s Birthday Party 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\/birthday-party-places-for-kids\/\" target=\"_blank\">iTrampoline, 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\">Active kids of any age will love having a birthday party at iTrampoline and parents will love the air-conditioned, clean space and the staff who set-up and clean-up. After jumping and playing sports,… <a href=\"https:\/\/bestthingshi.com\/birthday-party-places-for-kids\/\" 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-spa-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/spas\/\" target=\"_blank\">10 Best Spas 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\/spas\/\" target=\"_blank\">Naupaka Spa & Wellness Center at Four Seasons Ko Olina, Kapolei, 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\">The Four Seasons has a well-deserved reputation and the facilities at this high-end spa don’t disappoint—35,000 square-feet encompass tennis courts, spas, salons, and indoor and outdoor… <a href=\"https:\/\/bestthingshi.com\/spas\/\" 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-senior-discount-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/senior-discounts\/\" target=\"_blank\">The 10 Best Senior Discounts 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\/senior-discounts\/\" target=\"_blank\">Hampton Inn & Suites, Kapolei, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">In addition to their free hot breakfast and Wi-Fi, Hampton Inn & Suites offers AARP members a 10 percent discount on hotel stays. You can also take advantage of complimentary late check-out with… <a href=\"https:\/\/bestthingshi.com\/senior-discounts\/\" 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":1769772944,"type":"Event","id":76454525,"title":"ARMNHMR (18+ Event)","url":"\/event\/armnhmr-18-event-2026-01-30-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/cc5\/b564516c-d6e9-4ed6-b7a0-a9c35075fcc5_SOURCE"},{"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":1769776544,"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_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769783744,"type":"Event","id":76358518,"title":"Five for Fighting","url":"\/event\/five-for-fighting-1-2026-02-03-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/485\/b5011f2a-c1da-47d9-a9dc-d9db1b5ef485_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":1769798145,"type":"Place","id":1751704,"title":"The Leeward Discovery Fair","url":"\/place\/the-leeward-discovery-fair-pearl-city-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-2.jpg"}],"modified":"MongoDate(0.08400000 1769769345)","created":"MongoDate(0.08400000 1769769345)","_id":ObjectId ("697c8981f98713fc3703a336")} , true) | | 0 | 0 | 2 |
| 60 | db.events_cache.find( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 61 | db.events_radius_cache.find( {"_id":"fee673499f932919f037fe81b1864e30"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 62 | db.events.count( {"address.town_sef_url":"waipahu-hi","start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770357600)"}} ) | | 0 | 0 | 1 |
| 63 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} ) | | 0 | 0 | 19 |
| 64 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.01100158691406,21.38640022277832],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} ) | | 0 | 15 | 19 |
| 65 | db.events_radius_cache.count( {"_id":"fee673499f932919f037fe81b1864e30"} ) | | 0 | 0 | 1 |
| 66 | db.events_radius_cache.count( {"_id":"fee673499f932919f037fe81b1864e30"} ) | | 0 | 0 | 1 |
| 67 | db.events_radius_cache.insert( {"_id":"fee673499f932919f037fe81b1864e30","radius":15,"modified":"MongoDate(0.15600000 1769769345)","created":"MongoDate(0.15600000 1769769345)"} , true) | | 0 | 0 | 1 |
| 68 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)"},"event_id":{"$nin":[76454525,76454614,76358518]},"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 | 88 |
| 69 | db.events_cache.count( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217"} ) | | 0 | 0 | 1 |
| 70 | db.events_cache.count( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217"} ) | | 0 | 0 | 1 |
| 71 | db.events_cache.insert( {"_id":"6d43974a1e9ce5f93c9dc1ef75395217","town_sef_url":"waipahu-hi","data_key":["6967019cb1faf7c56a6c9a36","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19","695dc38db1faf7c56a6c0c5e"],"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.27200000 1769769345)","created":"MongoDate(0.27200000 1769769345)"} , true) | | 0 | 0 | 2 |
| 72 | 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 | 2 |
| 73 | db.places.find( {"address.town_sef_url":"waipahu-hi","group_id":{"$nin":[1751704]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 74 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 75 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 76 | db.towns.find( {"sef_url":"waipahu-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 77 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waipahu-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 78 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 79 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 80 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 81 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 82 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 83 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 84 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
