Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hauula-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"hauula-hi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","hi","honolulu-county-hi","hauula-hi"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"hauula-hi"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"fa7c2fc1905e7648e9014b230e27ef1a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"d766922470448964f16a79505d8f8962"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767074400)"},"geo":{"$geoWithin":{"$center":[[-157.906005859375,21.60689926147461],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( 11 ).skip( 0 )	11	217
9	db.events_cache.count( {"_id":"fa7c2fc1905e7648e9014b230e27ef1a"} )	0	1
10	db.events_cache.insert( {"_id":"fa7c2fc1905e7648e9014b230e27ef1a","town_sef_url":"hauula-hi","data_key":["68a75b6d03a70639b6cf600d","68a75b6d03a70639b6cf6041","68a75b6d03a70639b6cf60d0","68a75b6d03a70639b6cf6136","693321074389be6be5655a66","693321074389be6be5655bba","693321084389be6be5655e53","693321084389be6be5656145","693321084389be6be5656219","693321084389be6be5656261"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":21.60689926147461,\"lng\":-157.906005859375,\"latlng\":\"21.606899261475,-157.90600585938\",\"city\":\"Hauula\",\"state\":\"HI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.46000000 1767101094)","created":"MongoDate(0.46000000 1767101094)"} , true)	0	2

Hauula

Hawaii

Hauula Groups and Organizations

Hauula Elementary School

Hauula Loop Trail

Hauula Seventh-day Adventist Church

Kountry Kraft and Kaukau

Local 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

Big Daddy Kane With Live Band

Big Daddy Kane With Live Band

Big Daddy Kane With Live Band

Big Daddy Kane With Live Band

Iam Tongi

Iam Tongi

COVID-19 Resources