Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"van-lear-ky"}, [] ).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":"troy-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":"troy-ny","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	2
7	db.events_cache.find( {"_id":"260588e16620a31df65e4f1577bd0496"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"a9e758cb416db3de509a2d5bd3cfb21f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-73.67659759521484,42.733001708984375],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	369
10	db.events_cache.count( {"_id":"260588e16620a31df65e4f1577bd0496"} )	0	63
11	db.events_cache.count( {"_id":"260588e16620a31df65e4f1577bd0496"} )	0	109
12	db.events_cache.insert( {"_id":"260588e16620a31df65e4f1577bd0496","town_sef_url":"troy-ny","data_key":["690cf64ee57c2af57402c5c1","69154116de4ae56f5aadf85e","685bb76cfb5e4bed1fb6c945","690cf64ee57c2af57402c5c2","690cf64ee57c2af57402c5c3","690cf64ee57c2af57402c5c4","687f4f97fb5e4bed1f73ddf9","690cf64ee57c2af57402c5c7","690cf64ee57c2af57402c5c8","68c0e124c3af739f253dc75b"],"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.733001708984375,\"lng\":-73.67659759521484,\"latlng\":\"42.733001708984,-73.676597595215\",\"city\":\"Troy\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.78500000 1766240063)","created":"MongoDate(0.78500000 1766240063)"} , true)	0	9
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	38
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	20
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	14
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	26

Troy

New York

Troy Groups and Organizations

Brunswick Brittonkill Central School District

Friends Of The Troy Public Library

Heatly School

Hudson Valley Community College

Lansingburgh Central School District

Morning Star Montessori School

New York State Theater Institute

Redemption Christian Academy

Rensselaer Polytechnic Institute

The Sage College

Troy Public Library

Troy Public Library - Lansingburgh Branch

Troy School District

Wynantskill Union Free School District

Local Events

Festival of Trees

Living Wreckage

Spa City Sunday Farmers' Market

Festival of Trees

Festival of Trees

Festival of Trees

Champions of Magic: Holiday Spectacular

Festival of Trees

Festival of Trees

moe.