Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"green-valley-az"}, [] ).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":"bloomfield-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":"a50fb88b5b48e40cfd340d5951689426"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767247200)"},"geo":{"$geoWithin":{"$center":[[-77.42780303955078,42.8932991027832],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	167
8	db.events_cache.count( {"_id":"a50fb88b5b48e40cfd340d5951689426"} )	0	1
9	db.events_cache.count( {"_id":"a50fb88b5b48e40cfd340d5951689426"} )	0	1
10	db.events_cache.insert( {"_id":"a50fb88b5b48e40cfd340d5951689426","town_sef_url":"bloomfield-ny","data_key":["68b6552ac3af739f25c027aa","69017a9bc3af739f25e3f622","6930f092de4ae56f5aa6eb5e","68f6ee9bc3af739f25829423","68b6552bc3af739f25c0283e","68f6ee9bc3af739f2582947d","68f6ee9bc3af739f258294ea","68f6ee9bc3af739f25829532","6938d994de4ae56f5aaa9c0a","68f6ee9bc3af739f258295be","6930f092de4ae56f5aa6ece1","68f6ee9bc3af739f25829645","68f6ee9bc3af739f25829669","68f6ee9bc3af739f2582968d","69017a9bc3af739f25e3f9b6"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bloomfield 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.8932991027832,\"lng\":-77.42780303955078,\"latlng\":\"42.893299102783,-77.427803039551\",\"city\":\"Bloomfield\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.06400000 1767323330)","created":"MongoDate(0.06400000 1767323330)"} , true)	0	1
11	db.towns.find( {"sef_url":"bloomfield-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.tokens.find( {"sef_url":{"$in":["usa","ny","ontario-county-ny","bloomfield-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Bloomfield

New York

Bloomfield Featured Events

Rochester Americans vs Laval Rocket

Baklava Express

Rochester Knighthawks vs. Buffalo Bandits

Monty Python's Spamalot (Touring)

Rochester Americans vs Syracuse Crunch

Monty Python's Spamalot (Touring)

Monty Python's Spamalot (Touring)

Monty Python's Spamalot (Touring)

Junkyardfieldtrip Deluxe

Monty Python's Spamalot (Touring)

Rochester Knighthawks vs. Toronto Rock

Monty Python's Spamalot (Touring)

Monty Python's Spamalot (Touring)

Monty Python's Spamalot (Touring)

Old Blind Dogs

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.

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