Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"reynolds-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.towns.find( {"sef_url":"avonmore-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	13
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	7
6	db.events_cache.find( {"_id":"687e7727d5f0ace37926d69def0a6f9d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
7	db.events_radius_cache.find( {"_id":"fa1125014589207509060f2ed8f1f3ef"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-79.470703125,40.527198791503906],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	394
9	db.events_cache.count( {"_id":"687e7727d5f0ace37926d69def0a6f9d"} )	0	13
10	db.events_cache.count( {"_id":"687e7727d5f0ace37926d69def0a6f9d"} )	0	9
11	db.events_cache.insert( {"_id":"687e7727d5f0ace37926d69def0a6f9d","town_sef_url":"avonmore-pa","data_key":["68981447fb5e4bed1f560a0f","691c7ac3de4ae56f5aba06d1","68527ca5fb5e4bed1f02a06b","685670d9fb5e4bed1f3b31ea","685bb76ffb5e4bed1fb6d084","685fab7ffb5e4bed1fb56160","6864f195fb5e4bed1f3a3026","6868e5b4fb5e4bed1f644de0","686e2c05fb5e4bed1fcfb262","68722063fb5e4bed1f26e9ea","6933cbd8de4ae56f5a4a6e9e","68776672fb5e4bed1fb4d819","687e27a4fb5e4bed1f727a5c","6880a14afb5e4bed1f955fe4","68849587fb5e4bed1f7e61f3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Avonmore 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.527198791503906,\"lng\":-79.470703125,\"latlng\":\"40.527198791504,-79.470703125\",\"city\":\"Avonmore\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.87700000 1765723642)","created":"MongoDate(0.87700000 1765723642)"} , true)	0	10
12	db.towns.find( {"sef_url":"avonmore-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
13	db.tokens.find( {"sef_url":{"$in":["usa","pa","westmoreland-county-pa","avonmore-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	11
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Avonmore

Pennsylvania

Avonmore Featured Events

Shai Hulud and Holder

George Dvorsky's "Home for the Holidays, Too" with Victoria Stubbs and Mon Yough Chorale

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

New York Bee Gees

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

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.

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