Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"shreveport-la"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	17
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"derby-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	5
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	8
6	db.events_cache.find( {"_id":"c3a542ee72b53f3080e51060bf1e1fc7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"b4aade0f94a5bc8d853610fb1cd9cf4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-78.97579956054688,42.679100036621094],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	119
9	db.events_cache.count( {"_id":"c3a542ee72b53f3080e51060bf1e1fc7"} )	0	1
10	db.events_cache.count( {"_id":"c3a542ee72b53f3080e51060bf1e1fc7"} )	0	1
11	db.events_cache.insert( {"_id":"c3a542ee72b53f3080e51060bf1e1fc7","town_sef_url":"derby-ny","data_key":["687f4f95fb5e4bed1f73d9cb","68d74abdc3af739f25e1e3f5","685bb760fb5e4bed1fb6b2f2","68f8fae1c863fab8a2052ee1","687f4f95fb5e4bed1f73dac3","687f4f95fb5e4bed1f73db40","68d35625c3af739f2502068c","69157955de4ae56f5a227b77","687f4f96fb5e4bed1f73dd11","687f4f97fb5e4bed1f73ddeb","69103356de4ae56f5a25fff5","687f4f97fb5e4bed1f73de14","687f4f97fb5e4bed1f73de30","687f4f98fb5e4bed1f73deca","687f4f98fb5e4bed1f73df78"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Derby 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.679100036621094,\"lng\":-78.97579956054688,\"latlng\":\"42.679100036621,-78.975799560547\",\"city\":\"Derby\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.18700000 1766358862)","created":"MongoDate(0.18700000 1766358862)"} , true)	0	2
12	db.towns.find( {"sef_url":"derby-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","erie-county-ny","derby-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
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

Derby

New York

Derby Featured Events

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

Canisius University Women's Basketball vs Siena

White Christmas

Holiday Pops

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

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

University at Buffalo Bulls Mens Basketball vs. Penn State Behrend Lions Men's Basketball

FINICK

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

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

Silver Maple and Gimme Gimme

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

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

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

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

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.

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