Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"schuylkill-haven-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"schuylkill-haven-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","schuylkill-county-pa","schuylkill-haven-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"b155b2e85397202214ac4b235e7d0135"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"c1704cddbdb2bf5e9feddc6f8dcd054c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"schuylkill-haven-pa","start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766296800)"}} )	0	3
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.17330169677734,40.628700256347656],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} )	0	50
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.17330169677734,40.628700256347656],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} )	0	58
10	db.events_radius_cache.count( {"_id":"c1704cddbdb2bf5e9feddc6f8dcd054c"} )	0	1
11	db.events_radius_cache.insert( {"_id":"c1704cddbdb2bf5e9feddc6f8dcd054c","radius":25,"modified":"MongoDate(0.96500000 1765696981)","created":"MongoDate(0.96500000 1765696981)"} , true)	0	3
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-76.17330169677734,40.628700256347656],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 )	13	332
13	db.events_cache.count( {"_id":"b155b2e85397202214ac4b235e7d0135"} )	0	1
14	db.events_cache.count( {"_id":"b155b2e85397202214ac4b235e7d0135"} )	0	1
15	db.events_cache.insert( {"_id":"b155b2e85397202214ac4b235e7d0135","town_sef_url":"schuylkill-haven-pa","data_key":["69036adb4389be6be5f5dff3","68a75b5e03a70639b6cf09a6","68a75b5e03a70639b6cf09ad","68a75b5f03a70639b6cf1005","68a75b6103a70639b6cf177b","68a75b6203a70639b6cf20f0","68a75b6203a70639b6cf1fc6","68a75b6703a70639b6cf3f56","69036ae64389be6be5f61f84","68a75b6903a70639b6cf4b35","68a75b6903a70639b6cf49ea","69036ae74389be6be5f6255a","69036ae94389be6be5f62e3e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Schuylkill Haven 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.628700256347656,\"lng\":-76.17330169677734,\"latlng\":\"40.628700256348,-76.173301696777\",\"city\":\"Schuylkill Haven\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.32600000 1765696982)","created":"MongoDate(0.32600000 1765696982)"} , true)	0	2

Schuylkill Haven

Pennsylvania

Schuylkill Haven Featured Events

Holiday Spiritual & Holistic Bazaar with Benefit Basket Raffle

Leesport Farmers Market

Hometown Farmers Market

PA Dutch Farmers Market of Wyomissing

PA Dutch Farmers Market of Wyomissing

PA Dutch Farmers Market of Wyomissing

Mount Carmel Farmers Market

Hometown Farmers Market

Koziar's Christmas Village

PA Dutch Farmers Market of Wyomissing

Mount Carmel Farmers Market

Koziar's Christmas Village

Koziar's Christmas Village

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.

Schuylkill Haven 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.