Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/clubs-and-organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"gettysburg-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","adams-county-pa","gettysburg-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"722cf8292763d34a121b2f836150414c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"d7cfc67a1edc89405e73cfa6e6927981"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"gettysburg-pa","start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1765778400)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}} )	0	44
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765173600)","$lt":"MongoDate(0.00000000 1766037600)"}} )	2	46
10	db.events_radius_cache.count( {"_id":"d7cfc67a1edc89405e73cfa6e6927981"} )	0	1
11	db.events_radius_cache.insert( {"_id":"d7cfc67a1edc89405e73cfa6e6927981","radius":25,"modified":"MongoDate(0.94800000 1765214126)","created":"MongoDate(0.94800000 1765214126)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765173600)"},"tags":"clubs-and-organizations","geo":{"$geoWithin":{"$center":[[-77.2332992553711,39.83089828491211],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	11
13	db.events_cache.count( {"_id":"722cf8292763d34a121b2f836150414c"} )	0	1
14	db.events_cache.count( {"_id":"722cf8292763d34a121b2f836150414c"} )	0	1
15	db.events_cache.insert( {"_id":"722cf8292763d34a121b2f836150414c","town_sef_url":"gettysburg-pa","data_key":["68a75b5803a70639b6cee656","68a75b5d03a70639b6cf06ff","68a75b6203a70639b6cf1ed4","68a75b6903a70639b6cf492d","68a75b7403a70639b6cf95bb","69036b014389be6be5f6e16e","69036b194389be6be5f77a24","69036b2f4389be6be5f80667","693321384389be6be566c608"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Gettysburg Featured Events<br>Clubs And Organizations\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"clubs-and-organizations\",\"tags\":\"clubs-and-organizations\",\"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\":39.83089828491211,\"lng\":-77.2332992553711,\"latlng\":\"39.830898284912,-77.233299255371\",\"city\":\"Gettysburg\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.98400000 1765214126)","created":"MongoDate(0.98400000 1765214126)"} , true)	0	2

Gettysburg

Pennsylvania

Gettysburg Featured Events
Clubs And Organizations

Hanover Farmers' Market

NAMI Family Support Group

Hanover Farmers' Market

Hanover Farmers' Market

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

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.

Gettysburg Featured EventsClubs And Organizations

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.

Gettysburg Featured Events
Clubs And Organizations

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