Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"waialua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"waialua-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","waialua-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"2d51ef46907d7d2eb49c058e1a6d1c1f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"712f196580278207467644e50a893fd6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"waialua-hi","start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767592800)"}} )	0	3
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	0	19
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	3	19
10	db.events_radius_cache.count( {"_id":"712f196580278207467644e50a893fd6"} )	0	1
11	db.events_radius_cache.insert( {"_id":"712f196580278207467644e50a893fd6","radius":25,"modified":"MongoDate(0.85100000 1767054816)","created":"MongoDate(0.85100000 1767054816)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766988000)"},"geo":{"$geoWithin":{"$center":[[-158.1269989013672,21.573699951171875],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( 16 ).skip( 0 )	6	240
13	db.events_cache.count( {"_id":"2d51ef46907d7d2eb49c058e1a6d1c1f"} )	0	1
14	db.events_cache.count( {"_id":"2d51ef46907d7d2eb49c058e1a6d1c1f"} )	0	1
15	db.events_cache.insert( {"_id":"2d51ef46907d7d2eb49c058e1a6d1c1f","town_sef_url":"waialua-hi","data_key":["68a75b6d03a70639b6cf600d","68a75b6d03a70639b6cf6041","68a75b6d03a70639b6cf60d0","68a75b6d03a70639b6cf6136","68a75b7303a70639b6cf927a","69036b214389be6be5f7b252"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Waialua Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":21.573699951171875,\"lng\":-158.1269989013672,\"latlng\":\"21.573699951172,-158.12699890137\",\"city\":\"Waialua\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.12500000 1767054817)","created":"MongoDate(0.12500000 1767054817)"} , true)	0	1

Waialua

Hawaii

Waialua Featured Events

People's Open Market at Waiau District Park

People's Open Market at Waipahu District Park

People's Open Market at Wahiawa District Park

People's Open Market at Mililani District Park

Mayo Clinic Pediatric Days 2026

Diagnostic Imaging Update on Oahu

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 people
rely on AmericanTowns each year to find & share local information.

Waialua Featured Events

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.

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