Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"troy-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"troy-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","rensselaer-county-ny","troy-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.places.find( {"address.town_sef_url":"troy-ny","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	25
6	db.events_cache.find( {"_id":"260588e16620a31df65e4f1577bd0496"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a9e758cb416db3de509a2d5bd3cfb21f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"troy-ny","start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.67659759521484,42.733001708984375],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	24
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.67659759521484,42.733001708984375],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	3	27
11	db.events_radius_cache.count( {"_id":"a9e758cb416db3de509a2d5bd3cfb21f"} )	0	1
12	db.events_radius_cache.insert( {"_id":"a9e758cb416db3de509a2d5bd3cfb21f","radius":25,"modified":"MongoDate(0.66800000 1766274698)","created":"MongoDate(0.66800000 1766274698)"} , true)	0	1
13	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	150
14	db.events_cache.count( {"_id":"260588e16620a31df65e4f1577bd0496"} )	0	1
15	db.events_cache.count( {"_id":"260588e16620a31df65e4f1577bd0496"} )	0	1
16	db.events_cache.insert( {"_id":"260588e16620a31df65e4f1577bd0496","town_sef_url":"troy-ny","data_key":["693321034389be6be5653d75","693321034389be6be5654060","693321044389be6be56544e9","68a75b6503a70639b6cf30b7","693321044389be6be565485b","693321054389be6be56549f9","68a75b6703a70639b6cf3ed6","693321054389be6be5654d7c","693321064389be6be56550aa","69036ae84389be6be5f6280f"],"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.84500000 1766274698)","created":"MongoDate(0.84500000 1766274698)"} , true)	0	1

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

Festival of Trees

Spa City Sunday Farmers' Market

Festival of Trees

Festival of Trees

Champions of Magic: Holiday Spectacular

Festival of Trees

Festival of Trees

moe.

COVID-19 Resources