Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"oldenburg-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"bethpage-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"f7b1965b6c0d7a431544ba9fa62e0307"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"918d8770cba2b2f74e71ca0bc64e645b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-73.4823989868164,40.7489013671875],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( 16 ).skip( 0 )	16	103
9	db.events_cache.count( {"_id":"f7b1965b6c0d7a431544ba9fa62e0307"} )	0	3
10	db.events_cache.count( {"_id":"f7b1965b6c0d7a431544ba9fa62e0307"} )	0	1
11	db.events_cache.insert( {"_id":"f7b1965b6c0d7a431544ba9fa62e0307","town_sef_url":"bethpage-ny","data_key":["685e5a10fb5e4bed1f6211dc","685e5a13fb5e4bed1f621697","685e5a19fb5e4bed1f622315","69339391de4ae56f5aea2744","685fab78fb5e4bed1fb554dd","685fab7bfb5e4bed1fb5593b","693b55e4de4ae56f5a0704cd","68624e8cfb5e4bed1f2f6e2a","68624e8ffb5e4bed1f2f7387","68624e95fb5e4bed1f2f7ebc","6876154afb5e4bed1f7bb4e7","687f4f98fb5e4bed1f73dff8","68957149fb5e4bed1fd76ff5","68639fe0fb5e4bed1fa5bd9a","68957149fb5e4bed1fd77063"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bethpage Featured Events\",\"keyword\":\"\",\"radius\":15,\"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\":40.7489013671875,\"lng\":-73.4823989868164,\"latlng\":\"40.748901367188,-73.482398986816\",\"city\":\"Bethpage\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.51400000 1766442078)","created":"MongoDate(0.51400000 1766442078)"} , true)	0	2
12	db.towns.find( {"sef_url":"bethpage-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","nassau-county-ny","bethpage-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Bethpage

New York

Bethpage Featured Events

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Santa Fest feat. Ian Asher

Harry Connick Jr's The Happy Elf

Annie (Touring)

Christmas Day Divine Liturgy (Orthodox services in English)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Get the Led Out

Yellow Brick Joel: Piano Men

A Christmas Carol The Musical

Harry Connick Jr's The Happy Elf

A Christmas Carol The Musical

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.

Bethpage Featured Events

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.