Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hettinger-nd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"upper-jay-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	3
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":"53ae88f234b8f694a4c4ca6065b34fc7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	9
7	db.events_radius_cache.find( {"_id":"9b491f5ef920b21ba6d467bdf483a598"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	11
8	db.events.count( {"address.town_sef_url":"upper-jay-ny","start":{"$gte":"MongoDate(0.00000000 1766037600)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.77570343017578,44.33610153198242],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766037600)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	50
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.77570343017578,44.33610153198242],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766037600)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	109
11	db.events_radius_cache.count( {"_id":"9b491f5ef920b21ba6d467bdf483a598"} )	0	1
12	db.events_radius_cache.count( {"_id":"9b491f5ef920b21ba6d467bdf483a598"} )	0	1
13	db.events_radius_cache.insert( {"_id":"9b491f5ef920b21ba6d467bdf483a598","radius":25,"modified":"MongoDate(0.29700000 1766060816)","created":"MongoDate(0.29700000 1766060816)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766037600)"},"geo":{"$geoWithin":{"$center":[[-73.77570343017578,44.33610153198242],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 )	16	455
15	db.events_cache.count( {"_id":"53ae88f234b8f694a4c4ca6065b34fc7"} )	0	1
16	db.events_cache.count( {"_id":"53ae88f234b8f694a4c4ca6065b34fc7"} )	0	9
17	db.events_cache.insert( {"_id":"53ae88f234b8f694a4c4ca6065b34fc7","town_sef_url":"upper-jay-ny","data_key":["685bb758fb5e4bed1fb6a1cc","685bb758fb5e4bed1fb6a28d","6864f186fb5e4bed1f3a0f92","6864f186fb5e4bed1f3a102b","690cc6806d856105c6061841","69157956de4ae56f5a227c36","686e2c00fb5e4bed1fcfa977","686e2c01fb5e4bed1fcfaa63","6877666dfb5e4bed1fb4cfdb","6877666efb5e4bed1fb4d040","6880a143fb5e4bed1f955152","6880a143fb5e4bed1f9551d0","6889db89fb5e4bed1fad468f","6889db89fb5e4bed1fad4773","6892ce40fb5e4bed1f90b19b"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Upper Jay 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\":44.33610153198242,\"lng\":-73.77570343017578,\"latlng\":\"44.336101531982,-73.775703430176\",\"city\":\"Upper Jay\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.01200000 1766060817)","created":"MongoDate(0.01200000 1766060817)"} , true)	0	1
18	db.towns.find( {"sef_url":"upper-jay-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","ny","essex-county-ny","upper-jay-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6

Upper Jay

New York

Upper Jay Featured Events

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

North Country New Year Festival

JIM

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

Early Eucharist

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.

Upper Jay 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.