Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"oakes-nd"}, [] ).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":"babylon-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
6	db.events_cache.find( {"_id":"3ec89cf0f2a666312b9bfb5bcdfe4208"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"e806adb36a48cf9113146393c6a5ff87"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-73.3230972290039,40.69660186767578],0.10144927536231885]}}}, ["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	342
9	db.events_cache.count( {"_id":"3ec89cf0f2a666312b9bfb5bcdfe4208"} )	0	1
10	db.events_cache.count( {"_id":"3ec89cf0f2a666312b9bfb5bcdfe4208"} )	0	1
11	db.events_cache.insert( {"_id":"3ec89cf0f2a666312b9bfb5bcdfe4208","town_sef_url":"babylon-ny","data_key":["685e5a10fb5e4bed1f6211dc","685e5a13fb5e4bed1f621697","685e5a19fb5e4bed1f622315","685fab78fb5e4bed1fb554dd","685fab7bfb5e4bed1fb5593b","68624e8cfb5e4bed1f2f6e2a","68624e8ffb5e4bed1f2f7387","68624e95fb5e4bed1f2f7ebc","68639fe0fb5e4bed1fa5bd9a","68639fe7fb5e4bed1fa5cd35","68639ff1fb5e4bed1fa5e2ea","689c2d000118f5e48e0f6971","6933cbd7de4ae56f5a4a676d","6864f186fb5e4bed1f3a10a7","6864f188fb5e4bed1f3a14b2"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Babylon Featured Events\",\"keyword\":\"\",\"radius\":7,\"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.69660186767578,\"lng\":-73.3230972290039,\"latlng\":\"40.696601867676,-73.323097229004\",\"city\":\"Babylon\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.76500000 1766488071)","created":"MongoDate(0.76500000 1766488071)"} , true)	0	2
12	db.towns.find( {"sef_url":"babylon-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","suffolk-county-ny","babylon-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	3
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

Babylon

New York

Babylon Featured Events

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Fleetwood Macked

Fleetwood Macked

Harry Connick Jr's The Happy Elf

Annie (Touring)

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.

Babylon 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.