Nr	Query	Num. rows	Took (ms)
1	db.counties.find( {"sef_url":"piscataquis-county-me"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.counties.find( {"sef_url":"piscataquis-county-me"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"piscataquis-county-me"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
4	db.events_cache.find( {"_id":"b958828ca58c74669611f491e444bf0d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
5	db.events_radius_cache.find( {"_id":"f1745313ad6dc9ca43075e4c9adf7c03"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"piscataquis-county-me","start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768024800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-69.30979919433594,45.31549835205078],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	19
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-69.30979919433594,45.31549835205078],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	17
9	db.events_radius_cache.count( {"_id":"f1745313ad6dc9ca43075e4c9adf7c03"} )	0	1
10	db.events_radius_cache.insert( {"_id":"f1745313ad6dc9ca43075e4c9adf7c03","radius":25,"modified":"MongoDate(0.19600000 1767456237)","created":"MongoDate(0.19600000 1767456237)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767420000)"},"geo":{"$geoWithin":{"$center":[[-69.30979919433594,45.31549835205078],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 )	8	178
12	db.events_cache.count( {"_id":"b958828ca58c74669611f491e444bf0d"} )	0	1
13	db.events_cache.count( {"_id":"b958828ca58c74669611f491e444bf0d"} )	0	1
14	db.events_cache.insert( {"_id":"b958828ca58c74669611f491e444bf0d","town_sef_url":"piscataquis-county-me","data_key":["68a75b6f03a70639b6cf6f39","68a75b7303a70639b6cf8f8e","68a75b7903a70639b6cfc203","69036b064389be6be5f6fade","69036b124389be6be5f749e8","69036b1b4389be6be5f78bd7","69036b244389be6be5f7c70d","69036b2d4389be6be5f7fabd"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Piscataquis County 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\":45.31549835205078,\"lng\":-69.30979919433594,\"latlng\":\"45.315498352051,-69.309799194336\",\"city\":\"Piscataquis County\",\"state\":\"ME\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.39300000 1767456237)","created":"MongoDate(0.39300000 1767456237)"} , true)	0	2

Piscataquis County

Maine

Piscataquis County Featured Events

Bangor Farmers Market

Bangor Farmers Market

Bangor Farmers Market

Bangor Farmers Market

Bangor Farmers Market

Bangor Farmers Market

Bangor Farmers Market

Bangor Farmers Market

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.

Piscataquis County 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.