| 1 | db.towns.find( {"sef_url":"ewa-beach-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.towns.find( {"sef_url":"ewa-beach-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","ewa-beach-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 4 | db.ttd_towns.find( {"town_sef_url":"ewa-beach-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 5 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 6 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-158.00999450683594,21.312400817871094],"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(1766566531747)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766566531747)","$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 | 49 |
| 7 | db.ttd_towns.find( {"town_sef_url":"ewa-beach-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.events_cache.find( {"_id":"dc886a3af580270908bc08c081dfa72b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 10 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 2 | 16 |
| 11 | db.events_cache.count( {"_id":"dc886a3af580270908bc08c081dfa72b"} ) | | 0 | 0 | 1 |
| 12 | db.events_cache.insert( {"_id":"dc886a3af580270908bc08c081dfa72b","town_sef_url":"ewa-beach-hi","data_key":["69036ae54389be6be5f61b4d"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.84300000 1766566531)","created":"MongoDate(0.84300000 1766566531)"} , true) | | 0 | 0 | 2 |
| 13 | db.events_cache.find( {"_id":"29f6168bc581d5954ed1e66219736b28"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 55 |
| 15 | db.events_cache.count( {"_id":"29f6168bc581d5954ed1e66219736b28"} ) | | 0 | 0 | 2 |
| 16 | db.events_cache.insert( {"_id":"29f6168bc581d5954ed1e66219736b28","town_sef_url":"ewa-beach-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.96500000 1766566531)","created":"MongoDate(0.96500000 1766566531)"} , true) | | 0 | 0 | 1 |
| 17 | db.events_cache.find( {"_id":"76c9b7444b6b324c2813a0f19d880cda"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 18 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 53 |
| 19 | db.events_cache.count( {"_id":"76c9b7444b6b324c2813a0f19d880cda"} ) | | 0 | 0 | 1 |
| 20 | db.events_cache.insert( {"_id":"76c9b7444b6b324c2813a0f19d880cda","town_sef_url":"ewa-beach-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.08600000 1766566532)","created":"MongoDate(0.08600000 1766566532)"} , true) | | 0 | 0 | 2 |
| 21 | db.events_cache.find( {"_id":"63db4f61459c2c1a1fa15816741045c3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 22 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 0 | 2 |
| 23 | db.events_cache.count( {"_id":"63db4f61459c2c1a1fa15816741045c3"} ) | | 0 | 0 | 1 |
| 24 | db.events_cache.insert( {"_id":"63db4f61459c2c1a1fa15816741045c3","town_sef_url":"ewa-beach-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.10400000 1766566532)","created":"MongoDate(0.10400000 1766566532)"} , true) | | 0 | 0 | 2 |
| 25 | db.events_cache.find( {"_id":"e76f02e2b9cbe81cec39a3012ffb3f3d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 26 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],0.8695652173913043]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | | 0 | 0 | 2 |
| 27 | db.events_cache.count( {"_id":"e76f02e2b9cbe81cec39a3012ffb3f3d"} ) | | 0 | 0 | 1 |
| 28 | db.events_cache.insert( {"_id":"e76f02e2b9cbe81cec39a3012ffb3f3d","town_sef_url":"ewa-beach-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.12300000 1766566532)","created":"MongoDate(0.12300000 1766566532)"} , true) | | 0 | 0 | 1 |
| 29 | db.events_cache.find( {"_id":"082c86700d353d9152bede1414e755e3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 289 |
| 31 | db.events_cache.count( {"_id":"082c86700d353d9152bede1414e755e3"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"082c86700d353d9152bede1414e755e3","town_sef_url":"ewa-beach-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.69100000 1766566532)","created":"MongoDate(0.69100000 1766566532)"} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"d148ec2b2abb9b7dc7d9065b103c31ec"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 261 |
| 35 | db.events_cache.count( {"_id":"d148ec2b2abb9b7dc7d9065b103c31ec"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.insert( {"_id":"d148ec2b2abb9b7dc7d9065b103c31ec","town_sef_url":"ewa-beach-hi","data_key":["68a75b6803a70639b6cf4116"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.00700000 1766566533)","created":"MongoDate(0.00700000 1766566533)"} , true) | | 0 | 0 | 1 |
| 37 | db.events_cache.find( {"_id":"53580dca420c4b047f00b47a6f98a06d"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 38 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663,76071093]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 231 |
| 39 | db.events_cache.count( {"_id":"53580dca420c4b047f00b47a6f98a06d"} ) | | 0 | 0 | 1 |
| 40 | db.events_cache.insert( {"_id":"53580dca420c4b047f00b47a6f98a06d","town_sef_url":"ewa-beach-hi","data_key":["68a75b6803a70639b6cf41b9","68a75b6803a70639b6cf42d0","68a75b6803a70639b6cf435b","693321064389be6be56551b4","68a75b6b03a70639b6cf5501","693321064389be6be56553f3","693321074389be6be5655680","693321074389be6be56556dd","693321074389be6be5655771","693321074389be6be5655869","693321074389be6be565595a","693321074389be6be5655a66","693321074389be6be5655bba","693321084389be6be5655e53","693321084389be6be5656145","693321084389be6be5656219","693321084389be6be5656261","693321084389be6be5656309","693321094389be6be5656435","68a75b6f03a70639b6cf707c","68a75b6f03a70639b6cf71c7","68a75b6f03a70639b6cf739a","693321094389be6be5656a42","693321094389be6be5656b55","6933210a4389be6be5656c01","6933210a4389be6be5656cdf","6933210a4389be6be5656d9c","69036aef4389be6be5f6512c","6933210b4389be6be56571cc","69036aef4389be6be5f65464","69036af04389be6be5f6573b","6933210b4389be6be56576a7","69036af04389be6be5f65a81","6933210c4389be6be5657a0e","6933210e4389be6be56589bc","69036af54389be6be5f6802a","69036af64389be6be5f6852f","69036af64389be6be5f688e2","69036af74389be6be5f68d60","69036af74389be6be5f68f5b","693321104389be6be5659c87","693321104389be6be5659d99","69036af84389be6be5f698a8","69036af84389be6be5f69af0","68a75b7703a70639b6cfad35","68a75b7703a70639b6cfafa0","68a75b7703a70639b6cfb1c5","68a75b7803a70639b6cfb3a4","693321124389be6be565b1c0","693321124389be6be565b2ab"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":true}","modified":"MongoDate(0.31900000 1766566533)","created":"MongoDate(0.31900000 1766566533)"} , true) | | 0 | 0 | 2 |
| 41 | db.events_cache.find( {"_id":"a189c5cf17aa7202385c05edaf2e635a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 42 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663,76071093,76300282]},"tags":"music","geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 56 |
| 43 | db.events_cache.count( {"_id":"a189c5cf17aa7202385c05edaf2e635a"} ) | | 0 | 0 | 1 |
| 44 | db.events_cache.insert( {"_id":"a189c5cf17aa7202385c05edaf2e635a","town_sef_url":"ewa-beach-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-158.00999450683594,21.312400817871094],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.44400000 1766566533)","created":"MongoDate(0.44400000 1766566533)"} , true) | | 0 | 0 | 1 |
| 45 | db.places.find( {"geo":{"$near":[-158.00999450683594,21.312400817871094],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | | 0 | 51 | 22 |
| 46 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-tax-prep-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/tax-prep-services\/\" target=\"_blank\">6 Best Tax Prep Services in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/tax-prep-services\/\" target=\"_blank\">Ragasa Tax Service, Ewa Beach, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-6,edited-cynthia,edited-alli,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">The best place to go if you need a tax and bookkeeping specialist is Ragasa Tax Service. They provide a trustworthy range of services that are adapted to the requirements of people and companies. Let… <a href=\"https:\/\/bestthingshi.com\/article\/tax-prep-services\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-veterinarians-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/veterinarians\/\" target=\"_blank\">9 Best Veterinarians 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\/veterinarians\/\" target=\"_blank\">Animal House Veterinary Center, Ewa Beach, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,moe,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">At the Animal House Veterinary Center, pets are treated like family. The hospital is staffed by skilled doctors and technicians who are capable of handling the most complicated and demanding medical… <a href=\"https:\/\/bestthingshi.com\/veterinarians\/\" 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-burritos-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/burritos\/\" target=\"_blank\">10 Best Burrito Joints in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/burritos\/\" target=\"_blank\">Frida's Hawaii, Ewa Beach, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,edited-yagee,edited-alli,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Discover the delicious taste of traditional Mexican cuisine at Frida's Hawaii. This family-owned restaurant offers an amazing selection of burritos. Choose from the classic burrito, Frida's burrito,… <a href=\"https:\/\/bestthingshi.com\/article\/burritos\/\" 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-cake-shop-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/cake-shops\/\" target=\"_blank\">9 Best Cake 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\/cake-shops\/\" target=\"_blank\">Z\u2019s Bakery and Deli, Ewa Beach, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">In Ewa Beach, whether you’re in the mood for something sweet or savory, head to Z’s Bakery and Deli. Along with custom cakes and impressive wedding cakes, Z’s Bakery and Deli offers… <a href=\"https:\/\/bestthingshi.com\/cake-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-swimming-pools-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/swimming-pools\/\" target=\"_blank\">6 Best Public Swimming Pools in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/swimming-pools\/\" target=\"_blank\">Scott Pool, Honolulu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,community-life-bt,community-life-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">A brilliant spot for a water-filled day with family or friends is Scott Pool! Spend some quality time relaxing in the pool, wading pool, or playground area, or take on the 120-foot water slide or the… <a href=\"https:\/\/bestthingshi.com\/article\/swimming-pools\/\" 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-sea-food-market-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/seafood-markets\/\" target=\"_blank\">5 Best Seafood Markets in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/seafood-markets\/\" target=\"_blank\">Nico's Fish Market Hickam, Honolulu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The freshest spot to get your seafood fix is at Nico's Fish Market! They proudly use locally sourced fish from this morning's auction block in everything from sauces to sushi platters. Take pleasure… <a href=\"https:\/\/bestthingshi.com\/article\/seafood-markets\/\" 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-dog-kennel-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/dog-kennels\/\" target=\"_blank\">10 Best Dog Kennels in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/dog-kennels\/\" target=\"_blank\">Kama'aina K9 Adventures, Waipahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Doggie dreams come true at the island's first pup theme park! Spanning 2.5 acres, this doggie destination offers daycare, overnight care, training, board and train, grooming, and special events. A… <a href=\"https:\/\/bestthingshi.com\/dog-kennels\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-tutoring-services-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/tutoring-services\/\" target=\"_blank\">5 Best Tutoring Services in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/tutoring-services\/\" target=\"_blank\">Quick Stars Tutoring, Waipahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,limited-options,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Quick Stars Tutoring is the perfect solution for quality one-on-one tutoring. With tutors that are highly qualified in every subject from pre-school to college level, Quick Stars Tutoring offers… <a href=\"https:\/\/bestthingshi.com\/article\/tutoring-services\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-oyster-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/oysters\/\" target=\"_blank\">6 Best Places for Oysters 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\/oysters\/\" target=\"_blank\">Mitch's Fish Market & Sushi Bar, Honolulu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,food-drink-bt,food-drink-p300,moe,limited-options,edited-cynthia,edited-taylor,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Mitch's Sushi in Honolulu is the sushi bar where the freshest seafood is served up with a twist! Get your taste buds ready for some of the best raw oysters around, and feel right at home in the… <a href=\"https:\/\/bestthingshi.com\/oysters\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-roofers-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/article\/roofers\/\" target=\"_blank\">10 Best Roofers in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/article\/roofers\/\" target=\"_blank\">Kapili Solar Roofing, Waipahu, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-chira,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">This company is here to provide freedom and a brighter future with their innovative services. They specialize in roofing, painting, waterproofing, and solar-powered roofing options, providing only… <a href=\"https:\/\/bestthingshi.com\/article\/roofers\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n\n\n","town_sef_url":"ewa-beach-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":1766570131,"type":"Event","id":76227663,"title":"Hawaii Bowl","url":"\/event\/hawaii-bowl-2025-12-24-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/db5\/5acfb9a3-4315-40c6-824f-e0fd31bd5db5_723691_TABLET_LANDSCAPE_LARGE_16_9.jpg"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"15\",\"days\":\"15\",\"ttl\":\"2\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1766573732,"type":"Event","id":76071093,"title":"A Charlie Brown Christmas","url":"\/event\/a-charlie-brown-christmas-2025-12-24-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/08\/86\/13_Edp.jpg?v=4"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1766580933,"type":"Event","id":76300282,"title":"Sammy Johnson","url":"\/event\/sammy-johnson-1-2025-12-27-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/28\/03\/73_Edp.jpg?v=6"},{"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":1766595333,"type":"Place","id":2237295,"title":"Festival Street Eats","url":"\/place\/festival-street-eats-ewa-beach-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-food-festival-2.jpg"}],"modified":"MongoDate(0.48100000 1766566533)","created":"MongoDate(0.48100000 1766566533)","_id":ObjectId ("694baa85c6f43055e00f4003")} , true) | | 0 | 0 | 2 |
| 47 | db.events_cache.find( {"_id":"87edd03a144b832af0cd1611ad1812a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 48 | db.events_radius_cache.find( {"_id":"5902c98f1af4721ad3817bdb1975044c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.count( {"address.town_sef_url":"ewa-beach-hi","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} ) | | 0 | 1 | 1 |
| 50 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} ) | | 0 | 5 | 22 |
| 51 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} ) | | 0 | 38 | 25 |
| 52 | db.events_radius_cache.count( {"_id":"5902c98f1af4721ad3817bdb1975044c"} ) | | 0 | 0 | 1 |
| 53 | db.events_radius_cache.insert( {"_id":"5902c98f1af4721ad3817bdb1975044c","radius":15,"modified":"MongoDate(0.55900000 1766566533)","created":"MongoDate(0.55900000 1766566533)"} , true) | | 0 | 0 | 2 |
| 54 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"event_id":{"$nin":[76227663,76071093,76300282]},"geo":{"$geoWithin":{"$center":[[-158.00999450683594,21.312400817871094],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 | 145 |
| 55 | db.events_cache.count( {"_id":"87edd03a144b832af0cd1611ad1812a1"} ) | | 0 | 0 | 2 |
| 56 | db.events_cache.count( {"_id":"87edd03a144b832af0cd1611ad1812a1"} ) | | 0 | 0 | 1 |
| 57 | db.events_cache.insert( {"_id":"87edd03a144b832af0cd1611ad1812a1","town_sef_url":"ewa-beach-hi","data_key":["68a75b6803a70639b6cf41b9","68a75b6803a70639b6cf42d0","68a75b6803a70639b6cf435b","68a75b6803a70639b6cf43b1","68a75b6803a70639b6cf4401"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Ewa Beach\",\"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.312400817871094,\"lng\":-158.00999450683594,\"latlng\":\"21.312400817871,-158.00999450684\",\"city\":\"Ewa Beach\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.74000000 1766566533)","created":"MongoDate(0.74000000 1766566533)"} , true) | | 0 | 0 | 2 |
| 58 | db.news.find( {"broadcast":{"$in":["usa","ewa-beach-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 | 7 |
| 59 | db.places.find( {"address.town_sef_url":"ewa-beach-hi","group_id":{"$nin":[2237295]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
