Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"scipio-center-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"jerome-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":"a89774f8975d97d00eea63fe4a249276"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	10
7	db.events_radius_cache.find( {"_id":"fea99bda8aa9d217d519eb7eaf305340"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	7
8	db.events.count( {"address.town_sef_url":"jerome-pa","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.9823989868164,40.20859909057617],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	127
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-78.9823989868164,40.20859909057617],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	3	130
11	db.events_radius_cache.count( {"_id":"fea99bda8aa9d217d519eb7eaf305340"} )	0	1
12	db.events_radius_cache.count( {"_id":"fea99bda8aa9d217d519eb7eaf305340"} )	0	1
13	db.events_radius_cache.insert( {"_id":"fea99bda8aa9d217d519eb7eaf305340","radius":25,"modified":"MongoDate(0.45600000 1765806779)","created":"MongoDate(0.45600000 1765806779)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-78.9823989868164,40.20859909057617],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	651
15	db.events_cache.count( {"_id":"a89774f8975d97d00eea63fe4a249276"} )	0	1
16	db.events_cache.count( {"_id":"a89774f8975d97d00eea63fe4a249276"} )	0	1
17	db.events_cache.insert( {"_id":"a89774f8975d97d00eea63fe4a249276","town_sef_url":"jerome-pa","data_key":["68ae6c28c3af739f25a98958","68917cc0fb5e4bed1f58f6f9","68917cc0fb5e4bed1f58f777","68917cc0fb5e4bed1f58f9f9","68917cc0fb5e4bed1f58fa34","68917cc0fb5e4bed1f58fd5e","68917cc0fb5e4bed1f58fdd2","68917cc0fb5e4bed1f58fe98","68917cc1fb5e4bed1f5902ee","68a2a04dfb5e4bed1fbe5ba3","68a3f1c4fb5e4bed1fd65206","68be1e85c3af739f25e3d6c9","68bf7003c3af739f256e7eae","68c75905c3af739f25044ddc","68c8aa84c3af739f25e36887"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Jerome 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.20859909057617,\"lng\":-78.9823989868164,\"latlng\":\"40.208599090576,-78.982398986816\",\"city\":\"Jerome\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.56800000 1765806780)","created":"MongoDate(0.56800000 1765806780)"} , true)	0	1
18	db.towns.find( {"sef_url":"jerome-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","pa","somerset-county-pa","jerome-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
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	8
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	14
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	9
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Jerome

Pennsylvania

Jerome Featured Events

Aaron Lewis and The Stateliners: American As It Gets Tour

Johnstown Tomahawks vs. New Hampshire Mountain Kings

Johnstown Tomahawks vs. New Hampshire Mountain Kings

Johnstown Tomahawks vs. Northeast Generals

Johnstown Tomahawks vs. Northeast Generals

Johnstown Tomahawks vs. Rochester Jr. Americans

Johnstown Tomahawks vs. Rochester Jr. Americans

Johnstown Tomahawks vs. New Jersey Titans

Johnstown Tomahawks vs. New Jersey Titans

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

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.

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