Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hauppauge-ny"}, [] ).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":"hauppauge-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","suffolk-county-ny","hauppauge-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"hauppauge-ny"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"9675dd931c851cdf0c7c0e42f521acd3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"5150e586c33f41e7e6799b22593ea7c2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766901600)"},"geo":{"$geoWithin":{"$center":[[-73.20860290527344,40.823001861572266],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( 11 ).skip( 0 )	11	67
9	db.events_cache.count( {"_id":"9675dd931c851cdf0c7c0e42f521acd3"} )	0	1
10	db.events_cache.insert( {"_id":"9675dd931c851cdf0c7c0e42f521acd3","town_sef_url":"hauppauge-ny","data_key":["68a75b6b03a70639b6cf5733","68a75b6c03a70639b6cf59a9","68a75b6c03a70639b6cf5ab9","68a75b6c03a70639b6cf5aae","693321074389be6be56559f0","693321074389be6be5655bda","693321084389be6be5655d63","693321084389be6be5655edd","693321084389be6be565602f","68a75b6e03a70639b6cf6926"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"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\":40.823001861572266,\"lng\":-73.20860290527344,\"latlng\":\"40.823001861572,-73.208602905273\",\"city\":\"Hauppauge\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.64900000 1766933861)","created":"MongoDate(0.64900000 1766933861)"} , true)	0	2

Hauppauge

New York

Hauppauge Groups and Organizations

AARP Events on Long Island

Adelphi University Hauppauge Center

American Access Care Of Suffolk County

Angela's House

Bretton Woods Elementary School

Calvary Lutheran Church of Hauppauge

Chamber of Horrors NY

Chambers of Hell

Family Wellness Center

Fragrance X

Hauppauge Craft And Gift Fair

Hauppauge Fire Department

Hauppauge High School

Hauppauge Middle School

Hauppauge Public Library

Hauppauge School District

Hauppauge Soccer Club

Rotary Club of Hauppauge

Saint Thomas More RC Church

SoLuna Studio

Local Events

Melville Coins, Stamps, Cards and Collectibles Show

Performance - Frosty’s Big Day

A Christmas Carol The Musical

Performance - Annie

Ancient Wisdom: Outlook for 2026

FREESTYLE EVE

Fly Me To The Croon: A Swingin' New Year's Eve

Fly Me To The Croon: A Swingin' New Year's Eve

NEW YEARS EVE 2026 "THE GREATEST SHOW "

Trivia Night at Tap Room Patchogue

COVID-19 Resources