Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"owenton-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	34
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	22
3	db.towns.find( {"sef_url":"bronx-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	21
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"f1c5ba3f64e7f645e925315fc1955fa0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	7
7	db.events_radius_cache.find( {"_id":"310014b65fbeff099884d63f4fef49f0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-73.86479949951172,40.84479904174805],0.10144927536231885]}}}, ["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	410
9	db.events_cache.count( {"_id":"f1c5ba3f64e7f645e925315fc1955fa0"} )	0	7
10	db.events_cache.count( {"_id":"f1c5ba3f64e7f645e925315fc1955fa0"} )	0	9
11	db.events_cache.insert( {"_id":"f1c5ba3f64e7f645e925315fc1955fa0","town_sef_url":"bronx-ny","data_key":["68f1a89dc3af739f25dd6bf1","685a659dfb5e4bed1f657493","685a65b7fb5e4bed1f65a37d","691d2a14de4ae56f5a437088","68f1a89ec3af739f25dd6cf7","685bb75efb5e4bed1fb6af4f","685bb761fb5e4bed1fb6b41b","685bb770fb5e4bed1fb6d1d7","691e7b97de4ae56f5a80fe8a","68f1a89ec3af739f25dd6db3","685d0874fb5e4bed1f1a084f","68e71ca0c3af739f25e59670","68f1a89ec3af739f25dd6e71","685e5a15fb5e4bed1f621aa7","68f1a89ec3af739f25dd6eb2"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bronx Featured Events\",\"keyword\":\"\",\"radius\":7,\"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\":40.84479904174805,\"lng\":-73.86479949951172,\"latlng\":\"40.844799041748,-73.864799499512\",\"city\":\"Bronx\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.11000000 1766221083)","created":"MongoDate(0.11000000 1766221083)"} , true)	0	5
12	db.towns.find( {"sef_url":"bronx-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","bronx-county-ny","bronx-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
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	14
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

Bronx

New York

Bronx Featured Events

Classic Tour at Yankee Stadium

Sunnyside Greenmarket

Exhibition - Urban Stomp: Dreams and Defiance on the Dance Floor

Amateur Night Holiday Special: Presented By Coca-Cola

Classic Tour at Yankee Stadium

Jackson Heights Greenmarket

Riverdale Y Sunday Market

Exhibition - Urban Stomp: Dreams and Defiance on the Dance Floor

Ishay Ribo

Classic Tour at Yankee Stadium

Exhibition - Urban Stomp: Dreams and Defiance on the Dance Floor

Fordham Rams Mens Basketball vs. New Haven Chargers Mens Basketball

Classic Tour at Yankee Stadium

Exhibition - Urban Stomp: Dreams and Defiance on the Dance Floor

Classic Tour at Yankee Stadium

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.

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