Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"colonie-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"colonie-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","albany-county-ny","colonie-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"b1e47d1e65528545ea497e5f13afb4fc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"5412cc6c9de6090c39a16bc137b23e2f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-73.83580017089844,42.72010040283203],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
8	db.events_cache.count( {"_id":"b1e47d1e65528545ea497e5f13afb4fc"} )	0	1
9	db.events_cache.insert( {"_id":"b1e47d1e65528545ea497e5f13afb4fc","town_sef_url":"colonie-ny","data_key":["693321054389be6be5654d7c","693321064389be6be56550aa","69036ae84389be6be5f6280f","69036ae94389be6be5f62fe2","693321094389be6be5656b2a","6933210a4389be6be5656c85","6933210a4389be6be5656d37","69036aef4389be6be5f64fcd","6933210a4389be6be5656e11","69036aef4389be6be5f65205","6933210b4389be6be565716a","6933210b4389be6be565736c","6933210b4389be6be565764b","6933210b4389be6be565781d","69036af14389be6be5f65fc6"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Colonie 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\":42.72010040283203,\"lng\":-73.83580017089844,\"latlng\":\"42.720100402832,-73.835800170898\",\"city\":\"Colonie\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.23700000 1766636559)","created":"MongoDate(0.23700000 1766636559)"} , true)	0	3

Colonie

New York

Colonie Featured Events

Festival of Trees

Festival of Trees

moe.

Gov't Mule

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Eggy & Real Estate - Hell Froze Over Shows 2026

Monty Python Spamalot (Touring)

Siena Saints Mens Basketball vs. Merrimack College Warriors Men's Basketball

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

Monty Python Spamalot (Touring)

State Champs - Around The World And Back

COVID-19 Resources

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.

Colonie Featured Events

COVID-19 Resources

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.