Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"grover-beach-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	25
3	db.towns.find( {"sef_url":"lewiston-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	25
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	18
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	12
6	db.events_cache.find( {"_id":"cfbb2e88949024f0e38b40ed3af2a728"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	6
7	db.events_radius_cache.find( {"_id":"15a9f4ef5b1862afae27f5e6b187a86d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"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	412
9	db.events_cache.count( {"_id":"cfbb2e88949024f0e38b40ed3af2a728"} )	0	14
10	db.events_cache.count( {"_id":"cfbb2e88949024f0e38b40ed3af2a728"} )	0	7
11	db.events_cache.insert( {"_id":"cfbb2e88949024f0e38b40ed3af2a728","town_sef_url":"lewiston-ny","data_key":["685a658efb5e4bed1f655a28","68f907b6fd969f5f110551c4","690e51b4de4ae56f5a44b2d1","68f1a89dc3af739f25dd6c17","687f4f93fb5e4bed1f73d6c3","685bb758fb5e4bed1fb6a127","6878b7ecfb5e4bed1fd988c5","687f4f93fb5e4bed1f73d740","68f8faaf52e7405887004344","685bb758fb5e4bed1fb6a168","687f4f94fb5e4bed1f73d8e9","68f1a89ec3af739f25dd6d35","687f4f95fb5e4bed1f73d9cb","68d74abdc3af739f25e1e3f5","685bb760fb5e4bed1fb6b2f2"],"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.48200000 1766252738)","created":"MongoDate(0.48200000 1766252738)"} , true)	0	2
12	db.towns.find( {"sef_url":"lewiston-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","niagara-county-ny","lewiston-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	11
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	9
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
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	2
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9

Lewiston

New York

Lewiston Featured Events

The North Tonawanda City Market

Believe in Crafts Show and Basket Raffle

Annual Studio Artist Show and Sale

Niagara Univ. Purple Eagles Men's Basketball v. Houghton Highlanders

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

White Christmas

Buffalo Sabres vs. New York Islanders

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

Holiday Pops

White Christmas

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

Niagara University Purple Eagles Womens Basketball vs. St. Peters Peacocks Womens Basketball

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

Canisius University Women's Basketball vs Siena

White Christmas

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

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.