Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"guilderland-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"guilderland-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ny","albany-county-ny","guilderland-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.places.find( {"address.town_sef_url":"guilderland-ny"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	13	3
5	db.events_cache.find( {"_id":"131e4dec328efe6f5d1fc9203a8524b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"6bc79e7faa0687246dbd46469253f706"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"guilderland-ny","start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.91169738769531,42.70429992675781],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	41
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.91169738769531,42.70429992675781],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766124000)","$lt":"MongoDate(0.00000000 1766988000)"}} )	12	43
10	db.events_radius_cache.count( {"_id":"6bc79e7faa0687246dbd46469253f706"} )	0	1
11	db.events_radius_cache.insert( {"_id":"6bc79e7faa0687246dbd46469253f706","radius":25,"modified":"MongoDate(0.09600000 1766173577)","created":"MongoDate(0.09600000 1766173577)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"geo":{"$geoWithin":{"$center":[[-73.91169738769531,42.70429992675781],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	196
13	db.events_cache.count( {"_id":"131e4dec328efe6f5d1fc9203a8524b1"} )	0	1
14	db.events_cache.count( {"_id":"131e4dec328efe6f5d1fc9203a8524b1"} )	0	1
15	db.events_cache.insert( {"_id":"131e4dec328efe6f5d1fc9203a8524b1","town_sef_url":"guilderland-ny","data_key":["69036adf4389be6be5f5f731","693321024389be6be56537bb","693321034389be6be5653d75","693321034389be6be5654060","693321044389be6be56544e9","693321044389be6be565485b","693321054389be6be56549f9","68a75b6703a70639b6cf3ed6","693321054389be6be5654d7c","693321064389be6be56550aa"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"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.70429992675781,\"lng\":-73.91169738769531,\"latlng\":\"42.704299926758,-73.911697387695\",\"city\":\"Guilderland\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.33600000 1766173577)","created":"MongoDate(0.33600000 1766173577)"} , true)	0	1

Guilderland

New York

Guilderland Groups and Organizations

Christs Church Of The Capital District

Guilderland Chamber Of Commerce

Guilderland Farmers Market

Guilderland Fire Department

Guilderland Market

Guilderland Public Library

Guilderland YMCA

Nott Road Park

River of Life Church

Town Of Guilderland Senior Services

Town of Guilderland

Western Turnpike Golf Course

Winter Witches Festival

Local Events

Peak

Festival of Trees

Festival of Trees

Living Wreckage

Festival of Trees

Festival of Trees

Festival of Trees

Champions of Magic: Holiday Spectacular

Festival of Trees

Festival of Trees

COVID-19 Resources