(mongo) 84 queries took 992 ms
Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"princeville-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
3	db.towns.find( {"sef_url":"princeville-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","hi","kauai-county-hi","princeville-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.ttd_towns.find( {"town_sef_url":"princeville-hi","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
7	db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
8	db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.articles.find( {"aggregate":[{"$geoNear":{"near":[-159.47900390625,22.21190071105957],"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(1766874178298)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1766874178298)","$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 )	11	46
10	db.ttd_towns.find( {"town_sef_url":"princeville-hi","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 )	0	2
11	db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.events_cache.find( {"_id":"ce026a05844765b2569ccb5b56ab16e0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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	3
14	db.events_cache.count( {"_id":"ce026a05844765b2569ccb5b56ab16e0"} )	0	9
15	db.events_cache.insert( {"_id":"ce026a05844765b2569ccb5b56ab16e0","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.38700000 1766874178)","created":"MongoDate(0.38700000 1766874178)"} , true)	0	1
16	db.events_cache.find( {"_id":"ab66715deae8efe465a94511eacdf921"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
17	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.21739130434782608]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 2 ).skip( 0 )	0	2
18	db.events_cache.count( {"_id":"ab66715deae8efe465a94511eacdf921"} )	0	1
19	db.events_cache.insert( {"_id":"ab66715deae8efe465a94511eacdf921","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.40400000 1766874178)","created":"MongoDate(0.40400000 1766874178)"} , true)	0	1
20	db.events_cache.find( {"_id":"37a6a484d93568e1dcb892a127e67645"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
21	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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
22	db.events_cache.count( {"_id":"37a6a484d93568e1dcb892a127e67645"} )	0	1
23	db.events_cache.insert( {"_id":"37a6a484d93568e1dcb892a127e67645","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.42100000 1766874178)","created":"MongoDate(0.42100000 1766874178)"} , true)	0	1
24	db.events_cache.find( {"_id":"efbe31999753fdc93b98df80608ed84a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
25	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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	3
26	db.events_cache.count( {"_id":"efbe31999753fdc93b98df80608ed84a"} )	0	1
27	db.events_cache.insert( {"_id":"efbe31999753fdc93b98df80608ed84a","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.44100000 1766874178)","created":"MongoDate(0.44100000 1766874178)"} , true)	0	1
28	db.events_cache.find( {"_id":"3dc51332b830035f6f24a73b49ec5849"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
29	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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	3
30	db.events_cache.count( {"_id":"3dc51332b830035f6f24a73b49ec5849"} )	0	1
31	db.events_cache.insert( {"_id":"3dc51332b830035f6f24a73b49ec5849","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.45900000 1766874178)","created":"MongoDate(0.45900000 1766874178)"} , true)	0	2
32	db.events_cache.find( {"_id":"315183dc2b1b6bc42eb55366c8dbcc04"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
33	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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	3
34	db.events_cache.count( {"_id":"315183dc2b1b6bc42eb55366c8dbcc04"} )	0	1
35	db.events_cache.insert( {"_id":"315183dc2b1b6bc42eb55366c8dbcc04","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.47900000 1766874178)","created":"MongoDate(0.47900000 1766874178)"} , true)	0	1
36	db.events_cache.find( {"_id":"0f1ec8165ac0c2c3d0071eb386bf2b07"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
37	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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	3
38	db.events_cache.count( {"_id":"0f1ec8165ac0c2c3d0071eb386bf2b07"} )	0	1
39	db.events_cache.insert( {"_id":"0f1ec8165ac0c2c3d0071eb386bf2b07","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.50000000 1766874178)","created":"MongoDate(0.50000000 1766874178)"} , true)	0	2
40	db.events_cache.find( {"_id":"5ca3cdd55acef64021e5c6ff6821ef78"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
41	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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
42	db.events_cache.count( {"_id":"5ca3cdd55acef64021e5c6ff6821ef78"} )	0	1
43	db.events_cache.insert( {"_id":"5ca3cdd55acef64021e5c6ff6821ef78","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.51600000 1766874178)","created":"MongoDate(0.51600000 1766874178)"} , true)	0	1
44	db.events_cache.find( {"_id":"f2df38d1bf6402b0f3861c87339a5a56"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
45	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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
46	db.events_cache.count( {"_id":"f2df38d1bf6402b0f3861c87339a5a56"} )	0	1
47	db.events_cache.insert( {"_id":"f2df38d1bf6402b0f3861c87339a5a56","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.53300000 1766874178)","created":"MongoDate(0.53300000 1766874178)"} , true)	0	1
48	db.events_cache.find( {"_id":"c69baba0aaacb35aeeeab90152a52882"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
49	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.43478260869565216]}}}, ["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
50	db.events_cache.count( {"_id":"c69baba0aaacb35aeeeab90152a52882"} )	0	1
51	db.events_cache.insert( {"_id":"c69baba0aaacb35aeeeab90152a52882","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.55200000 1766874178)","created":"MongoDate(0.55200000 1766874178)"} , true)	0	1
52	db.events_cache.find( {"_id":"0309c81f2aa1a68e4adea5cf9ca280ba"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
53	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.6521739130434783]}}}, ["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	3
54	db.events_cache.count( {"_id":"0309c81f2aa1a68e4adea5cf9ca280ba"} )	0	1
55	db.events_cache.insert( {"_id":"0309c81f2aa1a68e4adea5cf9ca280ba","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"45\",\"days\":\"15\",\"show\":1,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.56900000 1766874178)","created":"MongoDate(0.56900000 1766874178)"} , true)	0	1
56	db.events_cache.find( {"_id":"7e6e2e2ec3f547e208a9ff9c289e39ec"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
57	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],1.0869565217391304]}}}, ["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 )	2	276
58	db.events_cache.count( {"_id":"7e6e2e2ec3f547e208a9ff9c289e39ec"} )	0	3
59	db.events_cache.insert( {"_id":"7e6e2e2ec3f547e208a9ff9c289e39ec","town_sef_url":"princeville-hi","data_key":["68a75b6903a70639b6cf49a1"],"sort_order":{"start":1},"params":"{\"radius\":\"75\",\"days\":\"30\",\"show\":1,\"has_next_page\":true}","modified":"MongoDate(0.86400000 1766874178)","created":"MongoDate(0.86400000 1766874178)"} , true)	0	2
60	db.events_cache.find( {"_id":"a7289df8394ce18201b43bb2c15683e8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
61	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"event_id":{"$nin":[75344857]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 )	8	192
62	db.events_cache.count( {"_id":"a7289df8394ce18201b43bb2c15683e8"} )	0	1
63	db.events_cache.insert( {"_id":"a7289df8394ce18201b43bb2c15683e8","town_sef_url":"princeville-hi","data_key":["69036af04389be6be5f657cd","69036af44389be6be5f67cdf","69036af64389be6be5f689b2","69036afd4389be6be5f6beeb","69036b034389be6be5f6ec5e","69036b064389be6be5f6fefa","69036b104389be6be5f73ea5","69036b124389be6be5f74d25"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.29500000 1766874179)","created":"MongoDate(0.29500000 1766874179)"} , true)	0	1
64	db.events_cache.find( {"_id":"5fbe5674cfa2d597f92fb94bf094fec6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
65	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"event_id":{"$nin":[75344857,76199101]},"tags":"music","geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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	41
66	db.events_cache.count( {"_id":"5fbe5674cfa2d597f92fb94bf094fec6"} )	0	1
67	db.events_cache.insert( {"_id":"5fbe5674cfa2d597f92fb94bf094fec6","town_sef_url":"princeville-hi","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-159.47900390625,22.21190071105957],\"cache\":\"+15 minutes\",\"has_next_page\":false}","modified":"MongoDate(0.40200000 1766874179)","created":"MongoDate(0.40200000 1766874179)"} , true)	0	2
68	db.places.find( {"geo":{"$near":[-159.47900390625,22.21190071105957],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 )	11	7
69	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-rainy-day-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" target=\"_blank\">10 Best Rainy Day Activities 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\/rainy-day-thingstodo\/\" target=\"_blank\">Aloha Massage, Princeville, 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\"><p>Looking for a way to relax and refresh on a rainy day? Head to Aloha Massage. This popular Princeville massage parlor will pamper you and make you wish for rain every day.<\/p> <a href=\"https:\/\/bestthingshi.com\/rainy-day-thingstodo\/\" 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-horseback-riding-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\/horseback-riding\/\" target=\"_blank\">10 Best Horseback Riding 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\/horseback-riding\/\" target=\"_blank\">Princeville Ranch, Princeville, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,community-life-bt,community-life-p300,moe,edited-shannen,edited-taylor,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Witness the elegance of Hawaii with an out-of-this-world horseback riding at Princeville Ranch! From kids to adults of all skill levels, the ranch offers lessons in natural horsemanship in both… <a href=\"https:\/\/bestthingshi.com\/article\/horseback-riding\/\" 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-photographers-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\/photographers\/\" target=\"_blank\">10 Best Photographers 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\/photographers\/\" target=\"_blank\">Harneet Bajwa Photography, Princeville, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">places-article-ai,evergreen,directory-bt,directory-p300,moe,edited-jimmy,edited-taylor,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Harneet Bajwa Photography brings clients into the beautiful Kauai landscapes, allowing them to be present in their moments of happiness. With his friendly approach and experienced eye, he captures… <a href=\"https:\/\/bestthingshi.com\/article\/photographers\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/hi-spa-hotel-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/spa-hotels\/\" target=\"_blank\">10 Best Spa Hotels 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\/spa-hotels\/\" target=\"_blank\">Princeville Resort, Princeville, 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\">Princeville Resort is a vacation spot that has everything. It has a ranch for your inner adventurer, a spa for your pampering pleasure, fine dining for your taste buds’ delight, and… <a href=\"https:\/\/bestthingshi.com\/spa-hotels\/\" 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-tacos-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/tacos\/\" target=\"_blank\">10 Best Tacos 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\/tacos\/\" target=\"_blank\">Tropical Taco, Hanalei, 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-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Tropical Taco is the destination for your subsequent taco cravings! With all ingredients freshly prepared daily, you can enjoy fresh fish tacos made with fish caught by local North Shore fishermen.… <a href=\"https:\/\/bestthingshi.com\/tacos\/\" 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-hair-salons-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" target=\"_blank\">10 Best Hair Salons 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\/hair-salons\/\" target=\"_blank\">Styles Studio, Hanalei, 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\">Who says you miss out on some amenities with the small-town life? In Hanalei, you certainly won’t miss out on high-quality hair services, because you have the talented stylists of Styles Studio… <a href=\"https:\/\/bestthingshi.com\/hair-salons\/\" 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-romantic-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\/romantic-places\/\" target=\"_blank\">10 Most Romantic 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\/romantic-places\/\" target=\"_blank\">Hanalei Bay, Hanalei, HI<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Nearly any Hawaiian beach has the makings of a romantic day, but Hanalei Bay is one of the best. Whether you and your sweetheart want to simply relax on the sand, learn to surf, or enjoy a kayaking… <a href=\"https:\/\/bestthingshi.com\/romantic-places\/\" 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-fried-chicken-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" target=\"_blank\">10 Best Places for Fried Chicken 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\/fried-chicken\/\" target=\"_blank\">Happy Talk Lounge, Princeville, 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\">Some restaurants focus on serving delicious food while others focus on creating a fun atmosphere. Happy Talk Lounge manages to do both, serving up mouth-watering eats including fried chicken wings in… <a href=\"https:\/\/bestthingshi.com\/fried-chicken\/\" 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-brunch-spot-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/brunch-spots\/\" target=\"_blank\">10 Best Brunch Spots 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\/brunch-spots\/\" target=\"_blank\">The Spot North Shore, Princeville, 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\">The Spot North Shore isn’t just a brunch spot - it’s the brunch spot in Princeville. It’s best known for its popular bowls, including hot breakfast bowls, acai bowls, and much… <a href=\"https:\/\/bestthingshi.com\/brunch-spots\/\" 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-tacos-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingshi.com\/where-articles-go-to-die\/\" target=\"_blank\">The 7 Best Taco 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\/where-articles-go-to-die\/\" target=\"_blank\">Pat\u2019s Taqueria, Hanalei, 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\">One of several food trucks to make our list, surfer Pat Grenz’s taco truck on Weke Road has a dedicated fan following. Written up in Travel and Leisure, and described by some as a… <a href=\"https:\/\/bestthingshi.com\/where-articles-go-to-die\/\" 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":"princeville-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_category\",\"radius\":\"75\",\"days\":\"30\",\"ttl\":\"8\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1766902978,"type":"Event","id":75344857,"title":"Waimea Town Market","url":"\/event\/waimea-town-market-2025-12-27-waimea-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-farmers-market-22.jpg"},{"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":1766888578,"type":"Event","id":76199101,"title":"Hawaii Rainbow Warriors Mens Basketball vs. Cal State Northridge Mens Basketball","url":"\/event\/hawaii-rainbow-warriors-mens-basketball-vs-cal-state-northridge-mens-basketball-2026-01-24-tm-hanamaulu-hi.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/29516a.jpg"},{"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":1766902979,"type":"Place","id":2200736,"title":"Kauai Island Crafters Fair","url":"\/place\/kauai-island-crafters-fair-lihue-hi.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-fair-1.jpg"}],"modified":"MongoDate(0.42000000 1766874179)","created":"MongoDate(0.42000000 1766874179)","_id":ObjectId ("69505c434f77190e7d03d4fb")} , true)	0	2
70	db.events_cache.find( {"_id":"3ba6068158a87f013909945393469eeb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
71	db.events_radius_cache.find( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
72	db.events.count( {"address.town_sef_url":"princeville-hi","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	2
73	db.events.count( {"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	0	27
74	db.events.count( {"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	0	27
75	db.events_radius_cache.count( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a"} )	0	1
76	db.events_radius_cache.insert( {"_id":"ea6f640587a9eb6285b33d5905bb7b2a","radius":25,"modified":"MongoDate(0.50100000 1766874179)","created":"MongoDate(0.50100000 1766874179)"} , true)	0	1
77	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"event_id":{"$nin":[75344857,76199101]},"geo":{"$geoWithin":{"$center":[[-159.47900390625,22.21190071105957],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 )	6	240
78	db.events_cache.count( {"_id":"3ba6068158a87f013909945393469eeb"} )	0	1
79	db.events_cache.count( {"_id":"3ba6068158a87f013909945393469eeb"} )	0	1
80	db.events_cache.insert( {"_id":"3ba6068158a87f013909945393469eeb","town_sef_url":"princeville-hi","data_key":["68a75b7003a70639b6cf7464","69036af04389be6be5f657cd","68a75b7103a70639b6cf8413","69036af44389be6be5f67cdf","693321104389be6be5659ba0"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Princeville\",\"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\":22.21190071105957,\"lng\":-159.47900390625,\"latlng\":\"22.21190071106,-159.47900390625\",\"city\":\"Princeville\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.76200000 1766874179)","created":"MongoDate(0.76200000 1766874179)"} , true)	0	1
81	db.news.find( {"broadcast":{"$in":["usa","princeville-hi","hi","kauai-county-hi"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 )	6	6
82	db.places.find( {"address.town_sef_url":"princeville-hi","group_id":{"$nin":[2200736]},"group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 )	6	3
83	db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 )	0	2
84	db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 )	40	1

HTTP_HOST: www.devel1.americantowns.com

SERVER_NAME: www.devel1.americantowns.com

Events Around Princeville

Local News Feed

RESTAURANTS

Organizations around Princeville

Princeville Town Facts

School Closings View our updated school closings list.

Local Schools Find education near you.

Local Groups View all the organizations in your community.

Businesses VFind popular businesses near you.

Jobs Looking to work locally? Try these listings we found.

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

School Closings
View our updated school closings list.

Local Schools
Find education near you.

Local Groups
View all the organizations in your community.

Businesses
VFind popular businesses near you.

Jobs
Looking to work locally? Try these listings we found.

20 million people
rely on AmericanTowns each year to find & share local information.