Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"brogue-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
2	db.towns.find( {"sef_url":"brogue-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	14
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","york-county-pa","brogue-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
4	db.events_cache.find( {"_id":"4a8f9f6ad3426d8fb3a693102bbf6e73"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
5	db.events_radius_cache.find( {"_id":"7de0d30e585e82fe75c821371f03971f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-76.4845962524414,39.87220001220703],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	28
7	db.events_cache.count( {"_id":"4a8f9f6ad3426d8fb3a693102bbf6e73"} )	0	6
8	db.events_cache.insert( {"_id":"4a8f9f6ad3426d8fb3a693102bbf6e73","town_sef_url":"brogue-pa","data_key":["69036ae54389be6be5f618a2","69036ae54389be6be5f619ea","69036ae64389be6be5f620eb","69036ae74389be6be5f62449","693321064389be6be5655267","69036ae84389be6be5f6283e","69036ae84389be6be5f62929","69036ae94389be6be5f62cbb","69036ae94389be6be5f62fee","68a75b6c03a70639b6cf5c8e","693321074389be6be5655c8b","6933210a4389be6be5656bc1","69036aef4389be6be5f6564b","6933210b4389be6be56576c3","6933210b4389be6be56577d3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Brogue Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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\":39.87220001220703,\"lng\":-76.4845962524414,\"latlng\":\"39.872200012207,-76.484596252441\",\"city\":\"Brogue\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.92500000 1766528056)","created":"MongoDate(0.92500000 1766528056)"} , true)	0	2

Brogue

Pennsylvania

Brogue Featured Events
Arts And Entertainment

Elf - The Musical

Elf - The Musical

Elf - The Musical

Elf - The Musical

Savage Cabaret Burlesque Revue

Elf - The Musical

Christmas With Absolute Adele

Elf - The Musical

Elf - The Musical

Stephen Kellogg

Exhibit: Christmas Cards and Postcards

Exhibit: Christmas Cards and Postcards

50's Dance Party

Willy Blaze and the Bad News Crew

Exhibit: Christmas Cards and Postcards

COVID-19 Resources

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.

Brogue Featured EventsArts And Entertainment

COVID-19 Resources

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.

Brogue Featured Events
Arts And Entertainment

20 million people
rely on AmericanTowns each year to find & share local information.