Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"redding-ridge-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	17
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"harmony-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/arts-and-entertainment"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	3
6	db.places.find( {"address.town_sef_url":"harmony-pa","tags":"arts-and-entertainment"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	3	2
7	db.events_cache.find( {"_id":"5c90f5cb730097df13c7aab493b2ca95"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"088b4f906e014799474944d38e0d2546"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
9	db.events.count( {"address.town_sef_url":"harmony-pa","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	5
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.12539672851562,40.80139923095703],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	0	30
11	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.12539672851562,40.80139923095703],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	0	31
12	db.events_radius_cache.count( {"_id":"088b4f906e014799474944d38e0d2546"} )	0	1
13	db.events_radius_cache.count( {"_id":"088b4f906e014799474944d38e0d2546"} )	0	1
14	db.events_radius_cache.insert( {"_id":"088b4f906e014799474944d38e0d2546","radius":25,"modified":"MongoDate(0.61400000 1766407901)","created":"MongoDate(0.61400000 1766407901)"} , true)	0	1
15	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-80.12539672851562,40.80139923095703],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	206
16	db.events_cache.count( {"_id":"5c90f5cb730097df13c7aab493b2ca95"} )	0	1
17	db.events_cache.count( {"_id":"5c90f5cb730097df13c7aab493b2ca95"} )	0	1
18	db.events_cache.insert( {"_id":"5c90f5cb730097df13c7aab493b2ca95","town_sef_url":"harmony-pa","data_key":["68c232a6c3af739f256ae8c0","68c232a6c3af739f256ae90c","686cda38fb5e4bed1f7221e3","68c232a6c3af739f256aecf8","687371b8fb5e4bed1f4b6db8","69056f1cde4ae56f5ad83b81","68c232a6c3af739f256aed74","6874c342fb5e4bed1f570b38","6917e415de4ae56f5a8ffd6e","68c232a6c3af739f256aed80"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"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.80139923095703,\"lng\":-80.12539672851562,\"latlng\":\"40.801399230957,-80.125396728516\",\"city\":\"Harmony\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.90100000 1766407901)","created":"MongoDate(0.90100000 1766407901)"} , true)	0	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Harmony

Pennsylvania

Harmony Groups and Organizations

Seneca Valley School District Planetarium

Shindig Music Festival

The Harmony Museum

Local Events

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

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

Robert Morris University Colonials Womens Hockey vs. Syracuse Orange Women's Ice Hockey

Connor Parente Album Release Party

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

Robert Morris University Colonials Womens Hockey vs. Syracuse Orange Women's Ice Hockey

Thë Nërd Hërdërs

Robert Morris University Colonials Mens Basketball vs. Purdue Fort Wayne Mastodons