Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"annville-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"annville-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","lebanon-county-pa","annville-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"d82a8cf94d098e57d44ad73bbdcd616c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"3d2c986ab907b785b96d024ec07ae8db"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"annville-pa","start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767506400)"}} )	0	1
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.50990295410156,40.33100128173828],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	0	16
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.50990295410156,40.33100128173828],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	4	13
9	db.events_radius_cache.count( {"_id":"3d2c986ab907b785b96d024ec07ae8db"} )	0	1
10	db.events_radius_cache.insert( {"_id":"3d2c986ab907b785b96d024ec07ae8db","radius":25,"modified":"MongoDate(0.88700000 1766951518)","created":"MongoDate(0.88700000 1766951518)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766901600)"},"geo":{"$geoWithin":{"$center":[[-76.50990295410156,40.33100128173828],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	188
12	db.events_cache.count( {"_id":"d82a8cf94d098e57d44ad73bbdcd616c"} )	0	1
13	db.events_cache.count( {"_id":"d82a8cf94d098e57d44ad73bbdcd616c"} )	0	1
14	db.events_cache.insert( {"_id":"d82a8cf94d098e57d44ad73bbdcd616c","town_sef_url":"annville-pa","data_key":["68a75b6c03a70639b6cf59d1","69036ae94389be6be5f62cbb","69036ae94389be6be5f62e04","68a75b6c03a70639b6cf5c8e","69036ae94389be6be5f62fee","693321074389be6be5655827","68a75b6d03a70639b6cf6001","693321074389be6be5655a0a","693321084389be6be5655d1f","693321084389be6be56561f1","693321084389be6be56562cc","69036aed4389be6be5f64547","69036aee4389be6be5f64920","69036af04389be6be5f65784","6933210b4389be6be56576c3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Annville 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\":40.33100128173828,\"lng\":-76.50990295410156,\"latlng\":\"40.331001281738,-76.509902954102\",\"city\":\"Annville\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.10500000 1766951519)","created":"MongoDate(0.10500000 1766951519)"} , true)	0	2

Annville

Pennsylvania

Annville Featured Events

Masonic Village Farm Market

Elf - The Musical

Hershey Bears vs. Charlotte Checkers

Stephen Kellogg

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Lancaster Central Market

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Hershey Bears vs. Rockford IceHogs

Hershey Bears vs. Rockford IceHogs

Hershey Bears vs. Cleveland Monsters

Willy Blaze and the Bad News Crew

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.

Annville Featured Events

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.

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