Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"north-versailles-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["holiday-events-and-festivals"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"north-versailles-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","allegheny-county-pa","north-versailles-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"54ea0c74a5914189d4fc0a351999dced"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765432800)"},"tags":"holiday-event-guide","geo":{"$geoWithin":{"$center":[[-79.81179809570312,40.38119888305664],1.0869565217391304]}}}, ["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( 11 ).skip( 0 )	11	35
7	db.events_cache.count( {"_id":"54ea0c74a5914189d4fc0a351999dced"} )	0	1
8	db.events_cache.insert( {"_id":"54ea0c74a5914189d4fc0a351999dced","town_sef_url":"north-versailles-pa","data_key":["69036ad54389be6be5f5bd57","69036ad54389be6be5f5bd5a","69036ad54389be6be5f5c2cc","69036ad54389be6be5f5c2ce","69036ad54389be6be5f5c2e0","69036ad74389be6be5f5c91b","69036ad84389be6be5f5cf37","69036ad84389be6be5f5d05b","69036ad94389be6be5f5d414","69036ad94389be6be5f5d579"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Find Pennsylvania 2025 Christmas & Holiday Events!\",\"tags\":\"holiday-event-guide\",\"radius\":75,\"keyword\":\"\",\"limit\":15,\"page\":1,\"sef\":\"\",\"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.38119888305664,\"lng\":-79.81179809570312,\"latlng\":\"40.381198883057,-79.811798095703\",\"city\":\"North Versailles\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.48500000 1765487154)","created":"MongoDate(0.48500000 1765487154)"} , true)	0	2
9	db.news.find( {"broadcast":{"$in":["usa","north-versailles-pa","pa","allegheny-county-pa"]}}, [] ).sort( {"publish_date":-1} ).limit( 4 ).skip( 0 )	4	2

2025 Holiday Events!

Find Pennsylvania 2025 Christmas & Holiday Events!

COVID-19 Resources

School Closings View our updated school closings list.

Local Schools Find education near you.

Local Groups View all the organizations in your community.

Businesses VFind popular businesses near you.

Jobs Looking to work locally? Try these listings we found.

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.

School Closings
View our updated school closings list.

Local Schools
Find education near you.

Local Groups
View all the organizations in your community.

Businesses
VFind popular businesses near you.

Jobs
Looking to work locally? Try these listings we found.

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