| 1 | db.towns.find( {"sef_url":"waikoloa-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.articles.find( {"broadcastto":{"$in":["waikoloa-hi","hi","usa"]},"publish_date":{"$lte":"MongoDate(0.00700000 1764991045)"},"tags":"hiking"}, [] ).sort( {"featured":-1,"publish_date":-1} ).limit( 2 ).skip( 0 ) | | 0 | 2 | 3 |
| 3 | db.articles.find( {"broadcastto":{"$in":["waikoloa-hi","hi","usa"]},"publish_date":{"$lte":"MongoDate(0.00700000 1764991045)"},"article_id":{"$ne":1826},"tags":"hiking"}, [] ).sort( {"publish_date":-1} ).limit( 16 ).skip( 0 ) | | 0 | 16 | 7 |
| 4 | db.events_cache.find( {"_id":"da48e5e03ec31a16b088a7f576d10095"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 5 | db.events.count( {"aggregate":[{"$match":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765519200)"},"town_sef_url":"waikoloa-hi","tags":{"$in":["hiking","walking"]}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 1 | 3 |
| 6 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-155.83700561523438,19.829200744628906],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0017662494953572872,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765778400)"},"tags":{"$in":["hiking","walking"]}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 1 | 5 |
| 7 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-155.83700561523438,19.829200744628906],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.0037848203471941865,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1765778400)"},"tags":{"$in":["hiking","walking"]}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 1 | 5 |
| 8 | db.events.count( {"aggregate":[{"$geoNear":{"near":[-155.83700561523438,19.829200744628906],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.006308033911990311,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)","$lt":"MongoDate(0.00000000 1766210400)"},"tags":{"$in":["hiking","walking"]}}}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"}}}]} ) | | 0 | 1 | 5 |
| 9 | db.events.find( {"aggregate":[{"$geoNear":{"near":[-155.83700561523438,19.829200744628906],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.01135446104158256,"spherical":true,"query":{"start":{"$gte":"MongoDate(0.00000000 1764914400)"},"tags":{"$in":["hiking","walking"]}}}},{"$sort":{"start":1,"id":1}},{"$group":{"_id":{"title":"$title","venue_name":"$venue_name","city":"$city","state":"$state"},"id":{"$first":"$_id"},"city":{"$first":"$city"},"cvent_id":{"$first":"$cvent_id"},"cvent_status":{"$first":"$cvent_status"},"date_string":{"$first":"$date_string"},"time_string":{"$first":"$time_string"},"distance":{"$first":"$distance"},"end":{"$first":"$end"},"event_id":{"$first":"$event_id"},"featured":{"$first":"$featured"},"geo":{"$first":"$geo"},"group_key":{"$first":"$group_key"},"image_url":{"$first":"$image_url"},"location_string":{"$first":"$location_string"},"repeat_id":{"$first":"$repeat_id"},"search_text":{"$first":"$search_text"},"sef_tail":{"$first":"$sef_tail"},"start":{"$first":"$start"},"state":{"$first":"$state"},"tags":{"$first":"$tags"},"title":{"$first":"$title"},"town_sef_url":{"$first":"$town_sef_url"},"venue_name":{"$first":"$venue_name"},"dates":{"$push":{"start":"$start","date_string":"$date_string","sef_tail":"$sef_tail"}}}},{"$sort":{"start":1,"id":1}},{"$sort":{"start":1,"id":1}},{"$skip":0},{"$limit":3}]}, [] ).sort( {"start":1,"id":1} ).limit( 3 ).skip( 0 ) | | 0 | 1 | 12 |
| 10 | db.events_cache.count( {"_id":"da48e5e03ec31a16b088a7f576d10095"} ) | | 0 | 0 | 1 |
| 11 | db.events_cache.count( {"_id":"da48e5e03ec31a16b088a7f576d10095"} ) | | 0 | 0 | 4 |
| 12 | db.events_cache.insert( {"_id":"da48e5e03ec31a16b088a7f576d10095","data":[{"Event":{"_id":{"title":"Huaka'i - Guided Hikes","venue_name":"Waikoloa Dry Forest Preserve","city":"Waikoloa","state":"HI"},"id":ObjectId ("6879392e384bf9134e02c673"),"city":"Waikoloa","cvent_id":null,"cvent_status":null,"date_string":"Friday, Dec 5, 2025 at 4:30pm","time_string":"4:30 PM","distance":6.79312591755024,"end":"","event_id":75795427,"featured":"","geo":[-155.7972543,19.9200151],"group_key":"3214731","image_url":"https:\/\/cdn-step.americantowns.com\/img\/generic-icon.jpg","location_string":"Waikoloa, HI","repeat_id":"3214731","search_text":"Huaka'i - Guided Hikes, Waikoloa Dry Forest Preserve, Quarry Road, Waikoloa, join huakalsquowaikoloa forest preserve where learn about waik\u014dunique lowland forest that working restore these guided hikes across lava yoursquoancient wiliwili trees sweeping views kohala k\u012bpuka have been revegetated with many native species volunteers wdfi staff offer sunset tours first friday each month these begin pm novemberfebruary front gate conclude viewing refreshments hana hale openpavilion tours will include walking over uneven terrain exposed areas weather hot dry occasionally very windy rainy please arrive prepared wearing sturdy closetoed shoes protection bringing refillable water bottle donations encouraged","sef_tail":"\/event\/huakai-guided-hikes-2025-12-05-waikoloa-hi.html","start":"MongoDate(0.00000000 1764952200)","state":"HI","tags":["hiking-trail","aarp","step-outside","pr-email","sports-and-recreation","hiking"],"title":"Huaka'i - Guided Hikes","town_sef_url":"waikoloa-hi","venue_name":"Waikoloa Dry Forest Preserve","dates":[]}}],"params":"{\"tags\":{\"$in\":[\"hiking\",\"walking\"]},\"show\":3,\"title\":\"Hiking Events Near You\",\"keyword\":\"\",\"radius\":45,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":365,\"images\":\"yes\",\"max-days\":365,\"max-miles\":45,\"message\":\"\",\"min\":20,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"more\":\"yes\",\"autoshowmore\":\"no\",\"link\":\"\",\"showdesc\":\"yes\",\"rankby\":\"distance\",\"type\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"lat\":19.829200744628906,\"lng\":-155.83700561523438,\"latlng\":\"19.829200744629,-155.83700561523\",\"count\":1}","modified":"MongoDate(0.10900000 1764991045)","created":"MongoDate(0.10900000 1764991045)"} , true) | | 0 | 0 | 2 |
| 13 | db.articles.find( {"broadcastto":{"$in":["waikoloa-hi","hi","usa"]},"publish_date":{"$lte":"MongoDate(0.11400000 1764991045)"},"$or":[{"tags":"hiking"},{"tags":"hiking-featured"}]}, [] ).sort( {"featured":-1,"publish_date":-1} ).limit( 2 ).skip( 0 ) | | 0 | 2 | 1 |
| 14 | db.places.find( {"geo":{"$near":[-155.83700561523438,19.829200744628906],"$maxDistance":1.4492753623188406},"tags":"hiking"}, [] ).sort( [] ).limit( 10 ).skip( 0 ) | | 0 | 0 | 2 |
| 15 | db.places.count( {"geo":{"$near":[-155.83700561523438,19.829200744628906],"$maxDistance":1.4492753623188406},"tags":"hiking"} ) | | 0 | 0 | 2 |
