Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"houston-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"houston-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","washington-county-pa","houston-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"houston-pa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	8	3
6	db.events_cache.find( {"_id":"3a9dd2f5021e839b324885f7f102981c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a58ddbc5d1e6fc5ebd94306826f2a5d6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"houston-pa","start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767506400)"}} )	0	3
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.2114028930664,40.2495002746582],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	0	22
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.2114028930664,40.2495002746582],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	1	21
11	db.events_radius_cache.count( {"_id":"a58ddbc5d1e6fc5ebd94306826f2a5d6"} )	0	1
12	db.events_radius_cache.insert( {"_id":"a58ddbc5d1e6fc5ebd94306826f2a5d6","radius":25,"modified":"MongoDate(0.31400000 1766905258)","created":"MongoDate(0.31400000 1766905258)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766901600)"},"geo":{"$geoWithin":{"$center":[[-80.2114028930664,40.2495002746582],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( 11 ).skip( 0 )	11	92
14	db.events_cache.count( {"_id":"3a9dd2f5021e839b324885f7f102981c"} )	0	1
15	db.events_cache.count( {"_id":"3a9dd2f5021e839b324885f7f102981c"} )	0	1
16	db.events_cache.insert( {"_id":"3a9dd2f5021e839b324885f7f102981c","town_sef_url":"houston-pa","data_key":["68a75b6c03a70639b6cf5bad","69036ae94389be6be5f63174","69036ae94389be6be5f6320c","69036aea4389be6be5f63474","69036aec4389be6be5f63e51","68a75b6f03a70639b6cf6e42","69036aed4389be6be5f64394","693321094389be6be565652b","68a75b6f03a70639b6cf7040","69036aee4389be6be5f64ec3"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":40.2495002746582,\"lng\":-80.2114028930664,\"latlng\":\"40.249500274658,-80.211402893066\",\"city\":\"Houston\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.44400000 1766905258)","created":"MongoDate(0.44400000 1766905258)"} , true)	0	2

Houston

Pennsylvania

Houston Groups and Organizations

Allison Park Elementary School

Central Assembly of God Church

Chartiers-Houston Community Library

Chartiers-Houston Junior/Senior High School

Chartiers-Houston School District

Houston Pumpkin Festival

James Sulkowski Fine Art Gallery

Voodoo Brewing Company

Local Events

Craig Shoemaker

Robert Morris University Colonials Womens Basketball vs. Oakland University Golden Grizzlies Womens Basketball

Robert Morris University Colonials Mens Basketball vs. Northern Kentucky Norse Mens Basketball

Pittsburgh Penguins vs. Carolina Hurricanes

Pittsburgh Penguins vs. Detroit Red Wings

Pink Talking Fish and Steely Dead

Pittsburgh Panthers Mens Basketball vs. Clemson Tigers Mens Basketball

Auditions for Sleeping Beauty Children's Theatre

Robert Morris University Colonials Mens Hockey vs. Sacred Heart Pioneers Men's Ice Hockey

Robert Morris University Colonials Womens Basketball vs. Indiana-Purdue Fort Wayne Womens Basketball

COVID-19 Resources