| 1 | db.towns.find( {"sef_url":"derwent-oh"}, [] ).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":"jbphh-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":"jbphh-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 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 | 2 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-157.94332885742188,21.33905029296875],"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(1769924182395)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769924182395)","$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 | 29 |
| 11 | db.ttd_towns.find( {"town_sef_url":"jbphh-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":"c10367f5f1f31dfedac4c8102921eee3"}, [] ).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.94332885742188,21.33905029296875],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 |
| 15 | db.events_cache.count( {"_id":"c10367f5f1f31dfedac4c8102921eee3"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"c10367f5f1f31dfedac4c8102921eee3"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"c10367f5f1f31dfedac4c8102921eee3","town_sef_url":"jbphh-hi","data_key":["6967019cb1faf7c56a6c99ed"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":true}","modified":"MongoDate(0.50600000 1769924182)","created":"MongoDate(0.50600000 1769924182)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"22df5afefb23854765de7d61c449d174"}, [] ).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.94332885742188,21.33905029296875],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 | 22 |
| 20 | db.events_cache.count( {"_id":"22df5afefb23854765de7d61c449d174"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"22df5afefb23854765de7d61c449d174"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"22df5afefb23854765de7d61c449d174","town_sef_url":"jbphh-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":false}","modified":"MongoDate(0.55500000 1769924182)","created":"MongoDate(0.55500000 1769924182)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"7af6535b60f22c6f5dc968514ec2aaa7"}, [] ).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.94332885742188,21.33905029296875],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 | 10 |
| 25 | db.events_cache.count( {"_id":"7af6535b60f22c6f5dc968514ec2aaa7"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"7af6535b60f22c6f5dc968514ec2aaa7"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"7af6535b60f22c6f5dc968514ec2aaa7","town_sef_url":"jbphh-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":false}","modified":"MongoDate(0.59400000 1769924182)","created":"MongoDate(0.59400000 1769924182)"} , true) | | 0 | 0 | 2 |
| 28 | db.events_cache.find( {"_id":"2e02c109aceb2628ddf88b0dfd98cab3"}, [] ).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.94332885742188,21.33905029296875],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":"2e02c109aceb2628ddf88b0dfd98cab3"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"2e02c109aceb2628ddf88b0dfd98cab3"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"2e02c109aceb2628ddf88b0dfd98cab3","town_sef_url":"jbphh-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":false}","modified":"MongoDate(0.61500000 1769924182)","created":"MongoDate(0.61500000 1769924182)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"fa567aa33f90380f32d09a4c2ce6c51f"}, [] ).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.94332885742188,21.33905029296875],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":"fa567aa33f90380f32d09a4c2ce6c51f"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"fa567aa33f90380f32d09a4c2ce6c51f"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"fa567aa33f90380f32d09a4c2ce6c51f","town_sef_url":"jbphh-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":false}","modified":"MongoDate(0.63300000 1769924182)","created":"MongoDate(0.63300000 1769924182)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"3df6fe7a32d92947a55ab4f077b1050a"}, [] ).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.94332885742188,21.33905029296875],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 | 20 |
| 40 | db.events_cache.count( {"_id":"3df6fe7a32d92947a55ab4f077b1050a"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"3df6fe7a32d92947a55ab4f077b1050a"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"3df6fe7a32d92947a55ab4f077b1050a","town_sef_url":"jbphh-hi","data_key":["6967019cb1faf7c56a6c9a36"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":true}","modified":"MongoDate(0.68300000 1769924182)","created":"MongoDate(0.68300000 1769924182)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"95a0372441da1446c498fd52a7d57766"}, [] ).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.94332885742188,21.33905029296875],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 | 61 |
| 45 | db.events_cache.count( {"_id":"95a0372441da1446c498fd52a7d57766"} ) | | 0 | 0 | 4 |
| 46 | db.events_cache.count( {"_id":"95a0372441da1446c498fd52a7d57766"} ) | | 0 | 0 | 15 |
| 47 | db.events_cache.insert( {"_id":"95a0372441da1446c498fd52a7d57766","town_sef_url":"jbphh-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.94332885742188,21.33905029296875],\"has_next_page\":false}","modified":"MongoDate(0.86800000 1769924182)","created":"MongoDate(0.86800000 1769924182)"} , true) | | 0 | 0 | 9 |
| 48 | db.events_cache.find( {"_id":"54f1b5631764d10efb0e26b48ef53519"}, [] ).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,76454527]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.94332885742188,21.33905029296875],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 | 15 |
| 50 | db.events_cache.count( {"_id":"54f1b5631764d10efb0e26b48ef53519"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"54f1b5631764d10efb0e26b48ef53519"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"54f1b5631764d10efb0e26b48ef53519","town_sef_url":"jbphh-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.94332885742188,21.33905029296875],\"has_next_page\":false}","modified":"MongoDate(0.92200000 1769924182)","created":"MongoDate(0.92200000 1769924182)"} , true) | | 0 | 0 | 1 |
| 53 | db.places.find( {"geo":{"$near":[-157.94332885742188,21.33905029296875],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 12 |
| 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-sporting-goods-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/sporting-goods-stores\/\" target=\"_blank\">The 10 Best Sporting Goods 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\/sporting-goods-stores\/\" target=\"_blank\">Soccer Locker, Honolulu, 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\">Shop local and be rewarded with savings on a great selection of kids’ and adults’ cleats and soccer uniforms. Referees are also not neglected, as Soccer Loccer has a large selection of… <a href=\"https:\/\/bestthingshi.com\/sporting-goods-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":"jbphh-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":1769927782,"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":1769927782,"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":1769938582,"type":"Event","id":76454527,"title":"Circle Jerks","url":"\/event\/circle-jerks-2026-02-21-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/1e4\/8535c7e2-780e-4dd1-a3fd-0e3b3ef231e4_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":1769952982,"type":"Place","id":1761062,"title":"Sake Appreciation Festival","url":"\/place\/sake-appreciation-festival-honolulu-hi.html","image_url":"https:\/\/cdn-p300.americantowns.com\/img\/generic-icon.jpg"}],"modified":"MongoDate(0.95200000 1769924182)","created":"MongoDate(0.95200000 1769924182)","_id":ObjectId ("697ee656b7b8f1860a0f7ec9")} , true) | | 0 | 0 | 3 |
| 55 | db.events_cache.find( {"_id":"958d85092cacac8e9e51794aaf766ba3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 56 | db.events_radius_cache.find( {"_id":"6de56366c04b1faffe9a886f68676793"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 57 | db.events.count( {"address.town_sef_url":"jbphh-hi","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} ) | | 0 | 0 | 1 |
| 58 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.94332885742188,21.33905029296875],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 1 | 24 |
| 59 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-157.94332885742188,21.33905029296875],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 14 | 36 |
| 60 | db.events_radius_cache.count( {"_id":"6de56366c04b1faffe9a886f68676793"} ) | | 0 | 0 | 1 |
| 61 | db.events_radius_cache.count( {"_id":"6de56366c04b1faffe9a886f68676793"} ) | | 0 | 0 | 1 |
| 62 | db.events_radius_cache.insert( {"_id":"6de56366c04b1faffe9a886f68676793","radius":25,"modified":"MongoDate(0.04800000 1769924183)","created":"MongoDate(0.04800000 1769924183)"} , true) | | 0 | 0 | 1 |
| 63 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"event_id":{"$nin":[76454614,76454534,76454527]},"geo":{"$geoWithin":{"$center":[[-157.94332885742188,21.33905029296875],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 | 30 |
| 64 | db.events_cache.count( {"_id":"958d85092cacac8e9e51794aaf766ba3"} ) | | 0 | 0 | 1 |
| 65 | db.events_cache.count( {"_id":"958d85092cacac8e9e51794aaf766ba3"} ) | | 0 | 0 | 1 |
| 66 | db.events_cache.insert( {"_id":"958d85092cacac8e9e51794aaf766ba3","town_sef_url":"jbphh-hi","data_key":["691e7b9ade4ae56f5a810ba4","691e7b9ade4ae56f5a810bdb","691e7b9ade4ae56f5a810bfd","691e7b9ade4ae56f5a810c19","695dc38db1faf7c56a6c0c5e"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Jbphh\",\"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.33905029296875,\"lng\":-157.94332885742188,\"latlng\":\"21.339050292969,-157.94332885742\",\"city\":\"Jbphh\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.14600000 1769924183)","created":"MongoDate(0.14600000 1769924183)"} , true) | | 0 | 0 | 1 |
| 67 | db.news.find( {"broadcast":{"$in":["usa","jbphh-hi","hi","honolulu-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 5 |
| 68 | db.places.find( {"address.town_sef_url":"jbphh-hi","group_id":{"$nin":[1761062]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 1 | 3 |
| 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":"jbphh-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 72 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","jbphh-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 3 | 2 |
| 73 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 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 |
