Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gastonia-nc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"elmira-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
6	db.events_cache.find( {"_id":"52c495266b55e799e40e29a9b703edba"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"76555c7dbb5f78189e9ca1dead8ae4df"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1768456800)"},"geo":{"$geoWithin":{"$center":[[-76.8125,42.09560012817383],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	204
9	db.events_cache.count( {"_id":"52c495266b55e799e40e29a9b703edba"} )	0	5
10	db.events_cache.count( {"_id":"52c495266b55e799e40e29a9b703edba"} )	0	1
11	db.events_cache.insert( {"_id":"52c495266b55e799e40e29a9b703edba","town_sef_url":"elmira-ny","data_key":["68a3f1c3fb5e4bed1fd64934","68a3f1c3fb5e4bed1fd64941","68a3f1c4fb5e4bed1fd649b1","691e7b98de4ae56f5a8105f6","68a3f1c4fb5e4bed1fd649c5","691d2a16de4ae56f5a4379a9","68a3f1c4fb5e4bed1fd64c34","68a3f1c4fb5e4bed1fd64c3f","68a3f1c4fb5e4bed1fd64c67","68a3f1c4fb5e4bed1fd64c7b","68a3f1c4fb5e4bed1fd64d63","68a3f1c4fb5e4bed1fd64d8b","68a3f1c4fb5e4bed1fd64e61","68a3f1c4fb5e4bed1fd65133","68aba988c3af739f2572b8a3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Elmira 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.09560012817383,\"lng\":-76.8125,\"latlng\":\"42.095600128174,-76.8125\",\"city\":\"Elmira\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.57600000 1768521157)","created":"MongoDate(0.57700000 1768521157)"} , true)	0	1
12	db.towns.find( {"sef_url":"elmira-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","chemung-county-ny","elmira-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	5
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Elmira

New York

Elmira Featured Events

The Buzz v. Maine Nordiques

Elmira Aviators vs. Johnstown Tomahawks

The Buzz v. Maine Nordiques

Gladius Fights

Elmira Aviators vs. Johnstown Tomahawks

Shake, Rattle & Roll - Dueling Pianos

The Buzz v. Maine Nordiques

Elmira Aviators vs. Danbury Jr. Hat Tricks

The Buzz v. Maine Nordiques

Elmira Aviators vs. Danbury Jr. Hat Tricks

Elmira Aviators vs. New Hampshire Mountain Kings

Elmira Aviators vs. New Hampshire Mountain Kings

The Buzz v. Norwich Sea Captains

The Buzz v. Norwich Sea Captains

The Buzz v. Long Beach Sharks

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.

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