Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"parsonsfield-me"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"clarence-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	13
6	db.events_cache.find( {"_id":"6782ec83fd10de34effd95b281876a66"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"fdeb3b8eea2345e9790be6221e622ed2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-78.59190368652344,42.98059844970703],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	123
9	db.events_cache.count( {"_id":"6782ec83fd10de34effd95b281876a66"} )	0	1
10	db.events_cache.count( {"_id":"6782ec83fd10de34effd95b281876a66"} )	0	10
11	db.events_cache.insert( {"_id":"6782ec83fd10de34effd95b281876a66","town_sef_url":"clarence-ny","data_key":["68551f3efb5e4bed1fd101f0","690e51b4de4ae56f5a44b263","68c65f65c3af739f25e1e893","690e51b4de4ae56f5a44b267","685670d7fb5e4bed1f3b2aef","687f4f90fb5e4bed1f73d141","6857c252fb5e4bed1f86edbc","68f8fa42293763705803ef78","690e51b4de4ae56f5a44b27e","690d03ccb3cd8acffe0fa42a","685bb756fb5e4bed1fb69f4a","6878b7eafb5e4bed1fd985d1","687f4f91fb5e4bed1f73d401","68f8fa736be57e660e0f24ed","690e51b4de4ae56f5a44b2a1"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clarence 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.98059844970703,\"lng\":-78.59190368652344,\"latlng\":\"42.980598449707,-78.591903686523\",\"city\":\"Clarence\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.21000000 1765826893)","created":"MongoDate(0.21000000 1765826893)"} , true)	0	2
12	db.towns.find( {"sef_url":"clarence-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","clarence-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	9
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Clarence

New York

Clarence Featured Events

The North Tonawanda City Market

Annual Studio Artist Show and Sale

Big Bad Voodoo Daddy

Annual Studio Artist Show and Sale

Newfane United Methodist Church Farmers Market

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

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

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