Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"madison-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"madison-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","westmoreland-county-pa","madison-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"8150bc99370de8aa7eccba7a48eeb21a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767765600)"},"geo":{"$geoWithin":{"$center":[[-79.67759704589844,40.247398376464844],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	24
7	db.events_cache.count( {"_id":"8150bc99370de8aa7eccba7a48eeb21a"} )	0	1
8	db.events_cache.insert( {"_id":"8150bc99370de8aa7eccba7a48eeb21a","town_sef_url":"madison-pa","data_key":["68a75b7003a70639b6cf7857","68a75b7003a70639b6cf79a3","69036aef4389be6be5f65042","68a75b7003a70639b6cf7bc8","6933210a4389be6be56570d2","68a75b7103a70639b6cf7d7c","69036aef4389be6be5f65588","68a75b7103a70639b6cf7fa5","68a75b7103a70639b6cf820f","68a75b7203a70639b6cf84ec","6933210c4389be6be5657bc6","68a75b7203a70639b6cf899d","6933210c4389be6be5657d32","6933210c4389be6be5657d85","6933210c4389be6be565800c"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Madison 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.247398376464844,\"lng\":-79.67759704589844,\"latlng\":\"40.247398376465,-79.677597045898\",\"city\":\"Madison\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.99400000 1767815509)","created":"MongoDate(0.99400000 1767815509)"} , true)	0	2

Madison

Pennsylvania

Madison Featured Events

Karaoke with Big Al

Akaash Singh

J.S. Ondara

Akaash Singh

The Fab Four

Akaash Singh

Pittsburgh Panthers Mens Basketball vs. Syracuse University Mens Basketball

Akaash Singh

Akaash Singh

Karaoke with Big Al

Gary Owen

Karaoke with Big Al

Tantric

Gary Owen

Godfrey

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.

Madison Featured Events

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.

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