Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mercedes-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"lake-clear-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":"c523cdff74056c9a195270b71fe021e7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"1f46c16365065856968880a379406775"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"lake-clear-ny","start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768370400)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.23159790039062,44.3661994934082],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768629600)"}} )	0	21
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.23159790039062,44.3661994934082],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768629600)"}} )	2	16
11	db.events_radius_cache.count( {"_id":"1f46c16365065856968880a379406775"} )	0	1
12	db.events_radius_cache.count( {"_id":"1f46c16365065856968880a379406775"} )	0	1
13	db.events_radius_cache.insert( {"_id":"1f46c16365065856968880a379406775","radius":25,"modified":"MongoDate(0.92500000 1767817790)","created":"MongoDate(0.92500000 1767817790)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767765600)"},"geo":{"$geoWithin":{"$center":[[-74.23159790039062,44.3661994934082],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	191
15	db.events_cache.count( {"_id":"c523cdff74056c9a195270b71fe021e7"} )	0	1
16	db.events_cache.count( {"_id":"c523cdff74056c9a195270b71fe021e7"} )	0	1
17	db.events_cache.insert( {"_id":"c523cdff74056c9a195270b71fe021e7","town_sef_url":"lake-clear-ny","data_key":["6877666dfb5e4bed1fb4cfdb","6877666efb5e4bed1fb4d040","6880a143fb5e4bed1f955152","6880a143fb5e4bed1f9551d0","6889db89fb5e4bed1fad468f","6889db89fb5e4bed1fad4773","6892ce40fb5e4bed1f90b19b","6892ce40fb5e4bed1f90b23f","69157957de4ae56f5a228099","69157957de4ae56f5a2280e4","689c08befb5e4bed1f1f98c1","689c08befb5e4bed1f1f9951","69157957de4ae56f5a2280f7","69157957de4ae56f5a228132","69157957de4ae56f5a22813d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Lake Clear 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.3661994934082,\"lng\":-74.23159790039062,\"latlng\":\"44.366199493408,-74.231597900391\",\"city\":\"Lake Clear\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.13500000 1767817791)","created":"MongoDate(0.13500000 1767817791)"} , true)	0	1
18	db.towns.find( {"sef_url":"lake-clear-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","ny","franklin-county-ny","lake-clear-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Lake Clear

New York

Lake Clear Featured Events

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

Early Eucharist

Family Eucharist

The Blind Owl Band and Jatoba

The Blind Owl Band and Folkfaces

Early Eucharist

Family Eucharist

Arthur Buezo and Tyler Westcott

Come Back To Earth: Mac Miller Live Band Tribute and Coyote Reverie

Annie in the Water and Double Tiger

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.

Lake Clear 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.