Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"clarence-center-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"ef4b51e26fba1196d956f74fe77b0386"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"1e1ea0ae21a99175735c32cbd6cc4d4f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"clarence-center-ny","start":{"$gte":"MongoDate(0.00000000 1766037600)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.63719940185547,43.010398864746094],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766037600)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	52
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.63719940185547,43.010398864746094],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766037600)","$lt":"MongoDate(0.00000000 1766901600)"}} )	4	45
10	db.events_radius_cache.count( {"_id":"1e1ea0ae21a99175735c32cbd6cc4d4f"} )	0	1
11	db.events_radius_cache.count( {"_id":"1e1ea0ae21a99175735c32cbd6cc4d4f"} )	0	1
12	db.events_radius_cache.insert( {"_id":"1e1ea0ae21a99175735c32cbd6cc4d4f","radius":25,"modified":"MongoDate(0.32200000 1766100285)","created":"MongoDate(0.32200000 1766100285)"} , true)	0	1
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766037600)"},"geo":{"$geoWithin":{"$center":[[-78.63719940185547,43.010398864746094],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	94
14	db.events_cache.count( {"_id":"ef4b51e26fba1196d956f74fe77b0386"} )	0	1
15	db.events_cache.count( {"_id":"ef4b51e26fba1196d956f74fe77b0386"} )	0	1
16	db.events_cache.insert( {"_id":"ef4b51e26fba1196d956f74fe77b0386","town_sef_url":"clarence-center-ny","data_key":["6857c252fb5e4bed1f86edbc","68f8fa42293763705803ef78","690e51b4de4ae56f5a44b27e","690d03ccb3cd8acffe0fa42a","685bb756fb5e4bed1fb69f4a","6878b7eafb5e4bed1fd985d1","687f4f91fb5e4bed1f73d401","68f8fa736be57e660e0f24ed","690e51b4de4ae56f5a44b2a1","68d74abcc3af739f25e1e264","685bb757fb5e4bed1fb69fec","687f4f92fb5e4bed1f73d598","69200555de4ae56f5af2c802","685a658efb5e4bed1f655a28","68f907b6fd969f5f110551c4"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clarence Center 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.010398864746094,\"lng\":-78.63719940185547,\"latlng\":\"43.010398864746,-78.637199401855\",\"city\":\"Clarence Center\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.44400000 1766100285)","created":"MongoDate(0.44400000 1766100285)"} , true)	0	1
17	db.towns.find( {"sef_url":"clarence-center-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","clarence-center-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Clarence Center

New York

Clarence Center Featured Events

The North Tonawanda City Market

Holiday Pops

Annual Studio Artist Show and Sale

Bricks and Brews

White Christmas

Buffalo Sabres vs. Philadelphia Flyers

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

Holiday Pops

Annual Studio Artist Show and Sale

Canisius University Women's Basketball vs Saint Peter's

White Christmas

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

Shai Hulud

The North Tonawanda City Market

Believe in Crafts Show and Basket Raffle

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.

Clarence Center Featured Events

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.