Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gratz-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"gratz-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","dauphin-county-pa","gratz-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	6
4	db.events_cache.find( {"_id":"26cf8fa4f6506801e77cad2845c5814d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"8bab1d55bd397013fe785e909f7cd76e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"gratz-pa","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.71540069580078,40.611900329589844],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	22
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.71540069580078,40.611900329589844],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	24
9	db.events_radius_cache.count( {"_id":"8bab1d55bd397013fe785e909f7cd76e"} )	0	1
10	db.events_radius_cache.insert( {"_id":"8bab1d55bd397013fe785e909f7cd76e","radius":25,"modified":"MongoDate(0.95100000 1766594480)","created":"MongoDate(0.95100000 1766594480)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-76.71540069580078,40.611900329589844],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	186
12	db.events_cache.count( {"_id":"26cf8fa4f6506801e77cad2845c5814d"} )	0	1
13	db.events_cache.count( {"_id":"26cf8fa4f6506801e77cad2845c5814d"} )	0	1
14	db.events_cache.insert( {"_id":"26cf8fa4f6506801e77cad2845c5814d","town_sef_url":"gratz-pa","data_key":["68a75b6803a70639b6cf43cc","68a75b6803a70639b6cf43c3","68a75b6903a70639b6cf49ff","68a75b6903a70639b6cf49ea","68a75b6903a70639b6cf49ee","69036ae94389be6be5f62e04","68a75b6d03a70639b6cf6018","69036aed4389be6be5f64547","69036aee4389be6be5f64920","69036af04389be6be5f65784","69036af04389be6be5f65c42","69036af14389be6be5f66112","69036af44389be6be5f67794","69036af54389be6be5f68092","69036af74389be6be5f68f81"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Gratz 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.611900329589844,\"lng\":-76.71540069580078,\"latlng\":\"40.61190032959,-76.715400695801\",\"city\":\"Gratz\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.16000000 1766594481)","created":"MongoDate(0.16000000 1766594481)"} , true)	0	1

Gratz

Pennsylvania

Gratz Featured Events

Sunbury Market House

Farmstead Farmers Market

Sunbury Market House

Mount Carmel Farmers Market

Farmstead Farmers Market

Hershey Bears vs. Charlotte Checkers

Middleburg Farmers and Flea Market

Hershey Bears vs. Rockford IceHogs

Hershey Bears vs. Rockford IceHogs

Hershey Bears vs. Cleveland Monsters

Hershey Bears vs. Cleveland Monsters

Hershey Bears vs. Hartford Wolf Pack

Hershey Bears vs. Hartford Wolf Pack

Hershey Bears vs. Wilkes Barre Scranton Penguins

Hershey Bears vs. Charlotte Checkers

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.

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