Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 193 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
Notice (8): Undefined index: searchdate [APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80]Code Context$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59"));if(!empty($this->params['days']))$start_cond['$lt'] = new MongoDate(strtotime($this->params['searchdate']." 23:59:59 + ".$this->params['days']." days")) ;$count = false $grouped = false $start_cond = array( '$gte' => object(MongoDate) { sec => (int) 1765778400 usec => (int) 0 } )EventsComponent::create_search_condition() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 80 EventsComponent::search() - APP/Plugin/Core/Controller/Component/EventsComponent.php, line 43 TtdController::process_rule() - APP/Controller/TtdController.php, line 174 TtdController::get_ttd_slots() - APP/Controller/TtdController.php, line 111 TtdController::view() - APP/Controller/TtdController.php, line 71 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11
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… Read More
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… Read More
The Ultimate Foot Store is great for people who are on their feet all day, as they focus on orthotic footwear. In addition to shoe brands such as Birkenstock, Brooks, Vionic, and Hoka, the Ultimate… Read More
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… Read More
Tea Time Taiwan is an authentic Taiwanese dessert place specialized in bubble tea, smoothies, puddings, and honey toast. The menu is huge here, with orders ranging from simple, like black tea, to… Read More
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… Read More
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,… Read More
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,… Read More
Aloha Stadium Swap Meet is the largest outdoor flea market in Hawaii and it is open on Wednesday, Saturday, and Sunday mornings and early afternoons. At this marketplace, you’ll find local… Read More
You will definitely say, “yum” with every spoonful of gelato at Via Gelato in Honolulu. Their spectacular flavors include butterbeer, chai, pumpkin chocolate pretzel, and salted caramel… Read More
Notice (8): Trying to access array offset on value of type null [APP/Plugin/Core/Controller/Component/PlacesComponent.php, line 68]Code Contextif($params['tags'])$options['conditions']['tags'] = $params['tags'];else if($this->params['tags_logical'])$params = array( 'show' => (int) 5, 'title' => 'Organizations around Hickam Afb', 'images' => false, 'group_type' => 'organization', 'sort' => 'created', 'sort_rule' => '-1', 'keyword' => '', 'radius' => null, 'limit' => (int) 15, 'page' => (int) 1, 'sef' => '', 'tags' => '', 'tags_logical' => '', 'terms' => '', 'show_limit' => (int) 3, 'days' => '', 'max-days' => (int) 365, 'max-miles' => (int) 45, 'message' => '[message to follow]', 'min' => (int) 50, 'prompt' => '', 'height' => '', 'width' => '', 'data_id' => '', 'more' => true, 'type' => '', 'autoshowmore' => false, 'link' => '', 'showdesc' => '', 'rankby' => '', 'empty-message' => '', 'ad_slots' => '', 'see-more-title' => '', 'searchdate' => '', 'searchenddate' => '', 'lat' => (float) 21.33930015564, 'lng' => (float) -157.9409942627, 'latlng' => '21.33930015564,-157.9409942627', 'city' => 'Hickam AFB', 'state' => 'HI', 'theme' => '', 'page_type' => 'town' ) $options = array( 'page' => (int) 1, 'limit' => (int) 5, 'order' => array( 'created' => (int) -1 ), 'conditions' => array( 'address.town_sef_url' => 'hickam-afb-hi' ) )PlacesComponent::search() - APP/Plugin/Core/Controller/Component/PlacesComponent.php, line 68 PlacesController::local() - APP/Controller/PlacesController.php, line 52 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 CakeObject::requestAction() - CORE/Cake/Core/CakeObject.php, line 104 Modules::render() - APP/Lib/Modules.php, line 23 include - APP/View/Elements/display.ctp, line 14 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 Controller::render() - CORE/Cake/Controller/Controller.php, line 963 AppController::renderPage() - APP/Controller/AppController.php, line 224 TownsController::displayTown() - APP/Controller/TownsController.php, line 11 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Hickam AFB, Hawaii. You can view Hickam AFB venues that host many Hickam AFB HI events every year.
You can find a ton of properties for sale if you search the Hickam AFB page on Zillow. Currently Hickam AFB has an average listing price for homes for sale on the market of $895,501. More real estate facts about Hickam AFB: The number of properties currently for sale in Hickam AFB is 3,118. The median homes for sale listing price is $453,333. This is broken down with the number of three bedroom houses in Hickam AFB consisting of 813 with an average listing price for these house of $743,821. Out of the 419 houses that are four bedroom the average listing price for Hickam AFB is $1,318,262. Interest rates for Hickam AFB are at historic lows as well.
Hickam AFB Hawaii has a latitude of 21.33930015564 and a longitude of -157.9409942627. View the full profile
On Yahoo, Yelp, SuperPages, AmericanTowns and 25 other directories!
Add your social media links and bio and promote your discounts, menus, events.
Be sure your listing is up on all the key local directories with all your important content (social links and product info).
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | db.towns.find( {"sef_url":"reed-point-mt"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 4 | |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 18 | |
| 3 | db.towns.find( {"sef_url":"hickam-afb-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 116 | |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 14 | |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 26 | |
| 6 | db.ttd_towns.find( {"town_sef_url":"hickam-afb-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 3 | |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 8 | |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 13 | |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 10 | |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-157.9409942626953,21.33930015563965],"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(1765820442663)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765820442663)","$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 | 89 | |
| 11 | db.ttd_towns.find( {"town_sef_url":"hickam-afb-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 | 12 | |
| 13 | db.events_cache.find( {"_id":"f54ecbac2f064b2b90fa03384afea73c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766469599)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 2 | 35 | |
| 15 | db.events_cache.count( {"_id":"f54ecbac2f064b2b90fa03384afea73c"} ) | 0 | 0 | 62 | |
| 16 | db.events_cache.count( {"_id":"f54ecbac2f064b2b90fa03384afea73c"} ) | 0 | 0 | 6 | |
| 17 | db.events_cache.insert( {"_id":"f54ecbac2f064b2b90fa03384afea73c","town_sef_url":"hickam-afb-hi","data_key":["68b8f82ac3af739f25568274"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":true}","modified":"MongoDate(0.00500000 1765820443)","created":"MongoDate(0.00500000 1765820443)"} , true) | 0 | 0 | 18 | |
| 18 | db.events_cache.find( {"_id":"e101452ddc2114272a14f8df6a538749"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 17 | |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766469599)"},"event_id":{"$nin":[76119648]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],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 | 8 | |
| 20 | db.events_cache.count( {"_id":"e101452ddc2114272a14f8df6a538749"} ) | 0 | 0 | 2 | |
| 21 | db.events_cache.count( {"_id":"e101452ddc2114272a14f8df6a538749"} ) | 0 | 0 | 1 | |
| 22 | db.events_cache.insert( {"_id":"e101452ddc2114272a14f8df6a538749","town_sef_url":"hickam-afb-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":false}","modified":"MongoDate(0.11300000 1765820443)","created":"MongoDate(0.11300000 1765820443)"} , true) | 0 | 0 | 2 | |
| 23 | db.events_cache.find( {"_id":"16ed7140f68c4f4c6f606f18d96d6098"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 6 | |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767074399)"},"event_id":{"$nin":[76119648]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],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 | 25 | |
| 25 | db.events_cache.count( {"_id":"16ed7140f68c4f4c6f606f18d96d6098"} ) | 0 | 0 | 5 | |
| 26 | db.events_cache.count( {"_id":"16ed7140f68c4f4c6f606f18d96d6098"} ) | 0 | 0 | 5 | |
| 27 | db.events_cache.insert( {"_id":"16ed7140f68c4f4c6f606f18d96d6098","town_sef_url":"hickam-afb-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":false}","modified":"MongoDate(0.25600000 1765820443)","created":"MongoDate(0.25600000 1765820443)"} , true) | 0 | 0 | 11 | |
| 28 | db.events_cache.find( {"_id":"3586b86a59b9b462bc8a05fabac4907f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766123999)"},"event_id":{"$nin":[76119648]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 ) | 0 | 0 | 5 | |
| 30 | db.events_cache.count( {"_id":"3586b86a59b9b462bc8a05fabac4907f"} ) | 0 | 0 | 6 | |
| 31 | db.events_cache.count( {"_id":"3586b86a59b9b462bc8a05fabac4907f"} ) | 0 | 0 | 9 | |
| 32 | db.events_cache.insert( {"_id":"3586b86a59b9b462bc8a05fabac4907f","town_sef_url":"hickam-afb-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":false}","modified":"MongoDate(0.32300000 1765820443)","created":"MongoDate(0.32300000 1765820443)"} , true) | 0 | 0 | 11 | |
| 33 | db.events_cache.find( {"_id":"66cb8ed4ba074a14ea50a17860d815d1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 8 | |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1768456799)"},"event_id":{"$nin":[76119648]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],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 | 10 | |
| 35 | db.events_cache.count( {"_id":"66cb8ed4ba074a14ea50a17860d815d1"} ) | 0 | 0 | 4 | |
| 36 | db.events_cache.count( {"_id":"66cb8ed4ba074a14ea50a17860d815d1"} ) | 0 | 0 | 3 | |
| 37 | db.events_cache.insert( {"_id":"66cb8ed4ba074a14ea50a17860d815d1","town_sef_url":"hickam-afb-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":false}","modified":"MongoDate(0.38700000 1765820443)","created":"MongoDate(0.38700000 1765820443)"} , true) | 0 | 0 | 15 | |
| 38 | db.events_cache.find( {"_id":"262db53d16fe3b0c83b3ffd9869ca01f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 8 | |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766296799)"},"event_id":{"$nin":[76119648]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],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 | 158 | |
| 40 | db.events_cache.count( {"_id":"262db53d16fe3b0c83b3ffd9869ca01f"} ) | 0 | 0 | 2 | |
| 41 | db.events_cache.count( {"_id":"262db53d16fe3b0c83b3ffd9869ca01f"} ) | 0 | 0 | 6 | |
| 42 | db.events_cache.insert( {"_id":"262db53d16fe3b0c83b3ffd9869ca01f","town_sef_url":"hickam-afb-hi","data_key":["68b8f82ac3af739f255682c7"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":true}","modified":"MongoDate(0.60900000 1765820443)","created":"MongoDate(0.60900000 1765820443)"} , true) | 0 | 0 | 1 | |
| 43 | db.events_cache.find( {"_id":"2b7b760fd46f0c2f01f0c6c9fe9702c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 1 | |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767679199)"},"event_id":{"$nin":[76119648,76119647]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],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 | 40 | 54 | |
| 45 | db.events_cache.count( {"_id":"2b7b760fd46f0c2f01f0c6c9fe9702c8"} ) | 0 | 0 | 33 | |
| 46 | db.events_cache.count( {"_id":"2b7b760fd46f0c2f01f0c6c9fe9702c8"} ) | 0 | 0 | 10 | |
| 47 | db.events_cache.insert( {"_id":"2b7b760fd46f0c2f01f0c6c9fe9702c8","town_sef_url":"hickam-afb-hi","data_key":["68b8f82ac3af739f25568306","68b8f82ac3af739f25568368","68b8f82bc3af739f2556838b","68d74abcc3af739f25e1e209","68b8f82bc3af739f25568422","68b8f82bc3af739f2556844d","687f4f92fb5e4bed1f73d5fd","68b8f82bc3af739f255684dc","69251312de4ae56f5a2520f5","689d5a3efb5e4bed1f4b017e","68d74abdc3af739f25e1e35b","689ab73efb5e4bed1fded3f3","689d5a3efb5e4bed1f4b01f7","69251312de4ae56f5a2521a4","68d74abdc3af739f25e1e408","68e86e1ec3af739f25218ea7","68a2a04cfb5e4bed1fbe5471","68a2a04cfb5e4bed1fbe5483","68a2a04cfb5e4bed1fbe5491","68a2a04cfb5e4bed1fbe54a8","690ab51cde4ae56f5a840ed7","68639ff5fb5e4bed1fa5e9ff","690ab51cde4ae56f5a840f0c","69266493de4ae56f5ae4877a","6930f092de4ae56f5aa6e8dd","69266493de4ae56f5ae48797","690ab51cde4ae56f5a840f68","690ab51cde4ae56f5a840f77","690c0697de4ae56f5a9c0c24","690c0697de4ae56f5a9c0c3a","690c0697de4ae56f5a9c0c4f","690c0698de4ae56f5a9c0cd5","6917e415de4ae56f5a8ffbe0","6917e415de4ae56f5a8ffbea","6917e415de4ae56f5a8ffbed","6917e415de4ae56f5a8ffc19","6895714afb5e4bed1fd7728d","6895714afb5e4bed1fd772b7","6895714afb5e4bed1fd772c6","691d2a15de4ae56f5a437536"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":false}","modified":"MongoDate(0.83400000 1765820443)","created":"MongoDate(0.83400000 1765820443)"} , true) | 0 | 0 | 25 | |
| 48 | db.events_cache.find( {"_id":"3271cbe58798c58a1b663072a5968f8f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 2 | |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1767679199)"},"event_id":{"$nin":[76119648,76119647,76346581]},"tags":"music","geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],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 | 41 | |
| 50 | db.events_cache.count( {"_id":"3271cbe58798c58a1b663072a5968f8f"} ) | 0 | 0 | 3 | |
| 51 | db.events_cache.count( {"_id":"3271cbe58798c58a1b663072a5968f8f"} ) | 0 | 0 | 56 | |
| 52 | db.events_cache.insert( {"_id":"3271cbe58798c58a1b663072a5968f8f","town_sef_url":"hickam-afb-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-157.9409942626953,21.33930015563965],\"has_next_page\":false}","modified":"MongoDate(0.06800000 1765820444)","created":"MongoDate(0.06800000 1765820444)"} , true) | 0 | 0 | 11 | |
| 53 | db.places.find( {"geo":{"$near":[-157.9409942626953,21.33930015563965],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 ) | 0 | 51 | 25 | |
| 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-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-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-shoe-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/shoe-stores\/\" target=\"_blank\">The 9 Best Shoe Stores in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/shoe-stores\/\" target=\"_blank\">The Ultimate Foot Store, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">The Ultimate Foot Store is great for people who are on their feet all day, as they focus on orthotic footwear. In addition to shoe brands such as Birkenstock, Brooks, Vionic, and Hoka, the Ultimate… <a href=\"https:\/\/bestthingshi.com\/shoe-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\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-bubble-tea-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\">6 Best Bubble Tea Places in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\">Tea Time Taiwan, Pearl City, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Tea Time Taiwan is an authentic Taiwanese dessert place specialized in bubble tea, smoothies, puddings, and honey toast. The menu is huge here, with orders ranging from simple, like black tea, to… <a href=\"https:\/\/bestthingshi.com\/bubble-tea\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-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-shopping-outlet-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\">The 10 Best Shopping Malls and Outlets in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\">Pearlridge, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">As the second largest shopping center in Hawaii, Pearlridge offers a wide array of shops, restaurants, a movie theater, and weekly farmers’ market. After stopping at Aloha Soap Factory,… <a href=\"https:\/\/bestthingshi.com\/shopping-outlets\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-thrift-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/thrift-shops\/\" target=\"_blank\">The 6 Best Thrift Stores in Hawaii!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingshi.com\/thrift-shops\/\" target=\"_blank\">Aloha Stadium Swap Meet & Marketplace, Aiea, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Aloha Stadium Swap Meet is the largest outdoor flea market in Hawaii and it is open on Wednesday, Saturday, and Sunday mornings and early afternoons. At this marketplace, you’ll find local… <a href=\"https:\/\/bestthingshi.com\/thrift-shops\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-gelato-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/gelato\/\" target=\"_blank\">The 8 Best Spots for Gelato 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\/gelato\/\" target=\"_blank\">Via Gelato, Honolulu, 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\">You will definitely say, “yum” with every spoonful of gelato at Via Gelato in Honolulu. Their spectacular flavors include butterbeer, chai, pumpkin chocolate pretzel, and salted caramel… <a href=\"https:\/\/bestthingshi.com\/gelato\/\" 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":"hickam-afb-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":1765824042,"type":"Event","id":76119648,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-1-2025-12-16-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_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":1765824043,"type":"Event","id":76119647,"title":"Jake\u00a0Shimabukuro's Holidays In Hawai\u02bbi","url":"\/event\/jake-shimabukuros-holidays-in-hawaii-2025-12-16-tm-honolulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/796\/66db7215-d93a-445f-a780-c3ec70626796_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":1765834843,"type":"Event","id":76346581,"title":"Iam Tongi","url":"\/event\/iam-tongi-1-2026-01-02-tm-honolulu-hi.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/13\/29\/84\/13_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":1765849244,"type":"Place","id":1285747,"title":"Pacific Aviation Museum Pearl Harbor","url":"\/place\/pacific-aviation-museum-pearl-harbor-honolulu-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-museum-25.jpg"}],"modified":"MongoDate(0.17700000 1765820444)","created":"MongoDate(0.17700000 1765820444)","_id":ObjectId ("6940481c30888c46ad0a0102")} , true) | 0 | 0 | 7 | |
| 55 | db.events_cache.find( {"_id":"8baaad8055a8671ae0641d4329db22cc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 0 | 10 | |
| 56 | db.events_radius_cache.find( {"_id":"30181e1da772d0671ee8049a3b59bee6"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 65 | |
| 57 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"event_id":{"$nin":[76119648,76119647,76346581]},"geo":{"$geoWithin":{"$center":[[-157.9409942626953,21.33930015563965],0.10144927536231885]}}}, ["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 | 758 | |
| 58 | db.events_cache.count( {"_id":"8baaad8055a8671ae0641d4329db22cc"} ) | 0 | 0 | 42 | |
| 59 | db.events_cache.count( {"_id":"8baaad8055a8671ae0641d4329db22cc"} ) | 0 | 0 | 11 | |
| 60 | db.events_cache.insert( {"_id":"8baaad8055a8671ae0641d4329db22cc","town_sef_url":"hickam-afb-hi","data_key":["68551f3dfb5e4bed1fd101a1","68551f40fb5e4bed1fd105b8","68d74abcc3af739f25e1e209","685913a4fb5e4bed1fd995a7","6900aa91d749a9cd1b06ef5f"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Hickam AFB\",\"keyword\":\"\",\"radius\":7,\"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.33930015563965,\"lng\":-157.9409942626953,\"latlng\":\"21.33930015564,-157.9409942627\",\"city\":\"Hickam AFB\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.22100000 1765820445)","created":"MongoDate(0.22100000 1765820445)"} , true) | 0 | 0 | 1 | |
| 61 | db.news.find( {"broadcast":{"$in":["usa","hickam-afb-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 | 11 | |
| 62 | db.places.find( {"address.town_sef_url":"hickam-afb-hi","group_id":{"$nin":[1285747]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | 0 | 3 | 7 | |
| 63 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | 0 | 0 | 9 | |
| 64 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | 0 | 40 | 10 | |
| 65 | db.towns.find( {"sef_url":"hickam-afb-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 8 | |
| 66 | db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","hickam-afb-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | 0 | 4 | 10 | |
| 67 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 10 | |
| 68 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 69 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 42 | |
| 70 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 20 | |
| 71 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 2 | |
| 72 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 6 | |
| 73 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | 0 | 1 | 1 |





