Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"lewiston-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"lewiston-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","niagara-county-ny","lewiston-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"cfbb2e88949024f0e38b40ed3af2a728"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"15a9f4ef5b1862afae27f5e6b187a86d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"lewiston-ny","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.03890228271484,43.17259979248047],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	1	20
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.03890228271484,43.17259979248047],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	1	29
10	db.events_radius_cache.count( {"_id":"15a9f4ef5b1862afae27f5e6b187a86d"} )	0	1
11	db.events_radius_cache.insert( {"_id":"15a9f4ef5b1862afae27f5e6b187a86d","radius":25,"modified":"MongoDate(0.91900000 1766436869)","created":"MongoDate(0.91900000 1766436869)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-79.03890228271484,43.17259979248047],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	74
13	db.events_cache.count( {"_id":"cfbb2e88949024f0e38b40ed3af2a728"} )	0	2
14	db.events_cache.count( {"_id":"cfbb2e88949024f0e38b40ed3af2a728"} )	0	2
15	db.events_cache.insert( {"_id":"cfbb2e88949024f0e38b40ed3af2a728","town_sef_url":"lewiston-ny","data_key":["69036ae44389be6be5f616e3","693321054389be6be5654923","68a75b6703a70639b6cf3a08","68a75b6703a70639b6cf3c8e","68a75b6703a70639b6cf3e56","693321054389be6be5654ac6","68a75b6803a70639b6cf401f","68a75b6803a70639b6cf40ae","68a75b6803a70639b6cf40c2","68a75b6803a70639b6cf44b8","68a75b6803a70639b6cf4580","68a75b6903a70639b6cf46d0","68a75b6a03a70639b6cf50c6","69036ae74389be6be5f62496","68a75b6a03a70639b6cf5212"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Lewiston 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\":43.17259979248047,\"lng\":-79.03890228271484,\"latlng\":\"43.17259979248,-79.038902282715\",\"city\":\"Lewiston\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.04100000 1766436870)","created":"MongoDate(0.04100000 1766436870)"} , true)	0	2

Lewiston

New York

Lewiston Featured Events

University at Buffalo Bulls Mens Basketball vs. Penn State Behrend Lions Men's Basketball

FINICK

The North Tonawanda City Market

'Twas the Night Before... by Cirque du Soleil

'Twas the Night Before... by Cirque du Soleil

Silver Maple and Gimme Gimme

'Twas the Night Before... by Cirque du Soleil

'Twas the Night Before... by Cirque du Soleil

Newfane United Methodist Church Farmers Market

'Twas the Night Before... by Cirque du Soleil

'Twas the Night Before... by Cirque du Soleil

Great Train Robbery

'Twas the Night Before... by Cirque du Soleil

Girls' Night Christmas

'Twas the Night Before... by Cirque du Soleil

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.

Lewiston 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.