Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mifflin-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
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":"mifflin-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","juniata-county-pa","mifflin-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"23b875529be19e688c54efebab78ddad"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
6	db.events_radius_cache.find( {"_id":"104999bd015c681a0d169377759baab6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"mifflin-pa","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.40470123291016,40.569698333740234],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	42
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.40470123291016,40.569698333740234],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	40
10	db.events_radius_cache.count( {"_id":"104999bd015c681a0d169377759baab6"} )	0	1
11	db.events_radius_cache.insert( {"_id":"104999bd015c681a0d169377759baab6","radius":25,"modified":"MongoDate(0.19800000 1765921376)","created":"MongoDate(0.19800000 1765921376)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-77.40470123291016,40.569698333740234],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 )	9	309
13	db.events_cache.count( {"_id":"23b875529be19e688c54efebab78ddad"} )	0	1
14	db.events_cache.count( {"_id":"23b875529be19e688c54efebab78ddad"} )	0	1
15	db.events_cache.insert( {"_id":"23b875529be19e688c54efebab78ddad","town_sef_url":"mifflin-pa","data_key":["68a75b5f03a70639b6cf0c42","68a75b6603a70639b6cf381a","68a75b7003a70639b6cf7949","68a75b7903a70639b6cfba3a","69036b034389be6be5f6eada","69036b1e4389be6be5f79d3c","69036b234389be6be5f7bf52","693321344389be6be566b18f","693321354389be6be566b481"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Mifflin 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.569698333740234,\"lng\":-77.40470123291016,\"latlng\":\"40.56969833374,-77.40470123291\",\"city\":\"Mifflin\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.53100000 1765921376)","created":"MongoDate(0.53100000 1765921376)"} , true)	0	2

Mifflin

Pennsylvania

Mifflin Featured Events

Country Line Dancing

Open Cornhole

Winter Basketball League 2024

Country Line Dancing

Winter Basketball League 2024

Country Line Dancing

Winter Basketball League 2024

Country Line Dancing

Winter Basketball League 2024

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.

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