Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sherrodsville-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"summerhill-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"6cdd8a616b66fa5ad9024004fb92a49c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"42147bf03f837780d484a641734523d3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"summerhill-pa","start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770616800)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.75759887695312,40.3739013671875],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	0	34
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.75759887695312,40.3739013671875],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	0	32
11	db.events_radius_cache.count( {"_id":"42147bf03f837780d484a641734523d3"} )	0	1
12	db.events_radius_cache.count( {"_id":"42147bf03f837780d484a641734523d3"} )	0	1
13	db.events_radius_cache.insert( {"_id":"42147bf03f837780d484a641734523d3","radius":25,"modified":"MongoDate(0.61400000 1770039880)","created":"MongoDate(0.61400000 1770039880)"} , true)	0	3
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1770012000)"},"geo":{"$geoWithin":{"$center":[[-78.75759887695312,40.3739013671875],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	9
15	db.events_cache.count( {"_id":"6cdd8a616b66fa5ad9024004fb92a49c"} )	0	1
16	db.events_cache.count( {"_id":"6cdd8a616b66fa5ad9024004fb92a49c"} )	0	2
17	db.events_cache.insert( {"_id":"6cdd8a616b66fa5ad9024004fb92a49c","town_sef_url":"summerhill-pa","data_key":["68a2a04dfb5e4bed1fbe5ba3","68a3f1c4fb5e4bed1fd65206","68be1e85c3af739f25e3d6c9","68bf7003c3af739f256e7eae","68c75905c3af739f25044ddc","68c8aa84c3af739f25e36887","68e71ca2c3af739f25e5adea","68d1e503c3af739f25b6cff5","68d33682c3af739f25c72f98","68db3f23c3af739f25855818","68e30880c3af739f25768e97","68e459fdc3af739f258c54f0","68ef05a2c3af739f254c1d5e","69757e9db1faf7c56a260293","69127e76de4ae56f5a6863ea"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Summerhill 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.3739013671875,\"lng\":-78.75759887695312,\"latlng\":\"40.373901367188,-78.757598876953\",\"city\":\"Summerhill\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.65300000 1770039880)","created":"MongoDate(0.65300000 1770039880)"} , true)	0	2
18	db.towns.find( {"sef_url":"summerhill-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","pa","cambria-county-pa","summerhill-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Summerhill

Pennsylvania

Summerhill Featured Events

Johnstown Tomahawks vs. Elmira Aviators

Johnstown Tomahawks vs. Elmira Aviators

Johnstown Tomahawks vs. Danbury Jr. Hat Tricks

Johnstown Tomahawks vs. Danbury Jr. Hat Tricks

Johnstown Tomahawks vs. Maryland Black Bears

Johnstown Tomahawks vs. Maryland Black Bears

Mercy Me: Wonder + Awe Tour

Johnstown Tomahawks vs. New Hampshire Mountain Kings

Johnstown Tomahawks vs. New Hampshire Mountain Kings

Brit Floyd: The Moon, The Wall & Beyond

Johnstown Tomahawks vs. Philadelphia Rebels

Johnstown Tomahawks vs. Philadelphia Rebels

Riverdance

World Ballet Company: Swan Lake wtih a LIVE Orchestra

World Ballet Company: Swan Lake with a LIVE orchestra

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.

Summerhill Featured Events

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.