Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"biddle-mt"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"sproul-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	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"840cbbb827120677f26fee053915fdf1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a8125d965dc05fbc14472e5df248b271"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"sproul-pa","start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770357600)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.46040344238281,40.27239990234375],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} )	0	29
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.46040344238281,40.27239990234375],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} )	0	19
11	db.events_radius_cache.count( {"_id":"a8125d965dc05fbc14472e5df248b271"} )	0	1
12	db.events_radius_cache.count( {"_id":"a8125d965dc05fbc14472e5df248b271"} )	0	1
13	db.events_radius_cache.insert( {"_id":"a8125d965dc05fbc14472e5df248b271","radius":25,"modified":"MongoDate(0.23600000 1769788738)","created":"MongoDate(0.23600000 1769788738)"} , true)	0	2
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)"},"geo":{"$geoWithin":{"$center":[[-78.46040344238281,40.27239990234375],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	169
15	db.events_cache.count( {"_id":"840cbbb827120677f26fee053915fdf1"} )	0	1
16	db.events_cache.count( {"_id":"840cbbb827120677f26fee053915fdf1"} )	0	1
17	db.events_cache.insert( {"_id":"840cbbb827120677f26fee053915fdf1","town_sef_url":"sproul-pa","data_key":["69757e9cb1faf7c56a25fa25","69757e9cb1faf7c56a25fa5b","69757e9cb1faf7c56a25faa7","69757e9cb1faf7c56a25fd79","69757e9cb1faf7c56a25fdbc","69757e9cb1faf7c56a25fdfc","69757e9cb1faf7c56a25fe3a","69757e9cb1faf7c56a25feb0","69757e9db1faf7c56a25ff18","69757e9db1faf7c56a2600a8","69757e9db1faf7c56a2600d0","69757e9db1faf7c56a2600e9","69757e9db1faf7c56a26013e","69757e9db1faf7c56a260193","69757e9db1faf7c56a2601c9"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Sproul 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.27239990234375,\"lng\":-78.46040344238281,\"latlng\":\"40.272399902344,-78.460403442383\",\"city\":\"Sproul\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.56200000 1769788738)","created":"MongoDate(0.56200000 1769788738)"} , true)	0	1
18	db.towns.find( {"sef_url":"sproul-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","pa","blair-county-pa","sproul-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Sproul

Pennsylvania

Sproul Featured Events

Altoona Curve vs. Harrisburg Senators

Altoona Curve vs. Harrisburg Senators

Altoona Curve vs. Harrisburg Senators

Altoona Curve vs. Portland Sea Dogs

Altoona Curve vs. Portland Sea Dogs

Altoona Curve vs. Portland Sea Dogs

Altoona Curve vs. Portland Sea Dogs

Altoona Curve vs. Portland Sea Dogs

Altoona Curve vs. Portland Sea Dogs

Altoona Curve vs. Richmond Flying Squirrels

Altoona Curve vs. Richmond Flying Squirrels

Altoona Curve vs. Richmond Flying Squirrels

Altoona Curve vs. Richmond Flying Squirrels

Altoona Curve vs. Richmond Flying Squirrels

Altoona Curve vs. Richmond Flying Squirrels

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.

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