Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"correll-mn"}, [] ).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":"endicott-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"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.places.find( {"address.town_sef_url":"endicott-ny","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	4	2
7	db.events_cache.find( {"_id":"774241c241e222cb4725ba472aab4700"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"a124e764ca121610e7fdc5a81c31c118"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-76.06549835205078,42.09809875488281],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( 11 ).skip( 0 )	11	261
10	db.events_cache.count( {"_id":"774241c241e222cb4725ba472aab4700"} )	0	7
11	db.events_cache.count( {"_id":"774241c241e222cb4725ba472aab4700"} )	0	2
12	db.events_cache.insert( {"_id":"774241c241e222cb4725ba472aab4700","town_sef_url":"endicott-ny","data_key":["6943e09cde4ae56f5a8bc951","68639ff1fb5e4bed1fa5e150","688b2cd2fb5e4bed1f075b0e","688b2cd7fb5e4bed1f0762f4","688b2cd9fb5e4bed1f076844","688b2cdafb5e4bed1f07694e","68911579fb5e4bed1fbe4bd6","69339393de4ae56f5aea2f70","68917cc1fb5e4bed1f5902d5","69339393de4ae56f5aea2f97"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"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\":42.09809875488281,\"lng\":-76.06549835205078,\"latlng\":\"42.098098754883,-76.065498352051\",\"city\":\"Endicott\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.94300000 1766360156)","created":"MongoDate(0.94300000 1766360156)"} , true)	0	6
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	14
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Endicott

New York

Endicott Groups and Organizations

George F. Johnson Memorial Library

Maine-Endwell Central School District

Union-Endicott Central School District

Union-Endicott High School Drama Club

Local Events

Christmas Eve Candlelight Service

Broome County Regional Farmers Market

Binghamton Black Bears vs. Watertown Wolves

Binghamton Black Bears vs. Watertown Wolves

Binghamton Black Bears vs. Pee Dee Icecats

Binghamton Black Bears vs. Pee Dee Icecats

Binghamton Black Bears vs. Twin City Thunderbirds

Laurel Canyon Band - Tribute To Crosby, Stills, Nash & Young

Binghamton Black Bears vs. Twin City Thunderbirds

Laurel Canyon Band - Tribute To Crosby, Stills, Nash & Young