Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"lancaster-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.towns.find( {"sef_url":"lancaster-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","lancaster-county-pa","lancaster-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	4
4	db.places.find( {"address.town_sef_url":"lancaster-pa","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	47
5	db.events_cache.find( {"_id":"d02b69bb9d67ae2d32533afc0d84688b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
6	db.events_radius_cache.find( {"_id":"1a2431ba62aac53555d2a209c0ea07fb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
7	db.events.count( {"address.town_sef_url":"lancaster-pa","start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766815200)"}} )	11	14
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.29989624023438,40.04180145263672],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	18	37
9	db.events_radius_cache.count( {"_id":"1a2431ba62aac53555d2a209c0ea07fb"} )	0	1
10	db.events_radius_cache.insert( {"_id":"1a2431ba62aac53555d2a209c0ea07fb","radius":7,"modified":"MongoDate(0.17600000 1766243585)","created":"MongoDate(0.17600000 1766243585)"} , true)	0	3
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-76.29989624023438,40.04180145263672],0.10144927536231885]}}}, ["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	222
12	db.events_cache.count( {"_id":"d02b69bb9d67ae2d32533afc0d84688b"} )	0	2
13	db.events_cache.count( {"_id":"d02b69bb9d67ae2d32533afc0d84688b"} )	0	1
14	db.events_cache.insert( {"_id":"d02b69bb9d67ae2d32533afc0d84688b","town_sef_url":"lancaster-pa","data_key":["68a75b6203a70639b6cf1ed2","68a75b6403a70639b6cf26b1","69036ae14389be6be5f6050d","68a75b6403a70639b6cf28d0","69036ae24389be6be5f60a39","69036ae34389be6be5f611e4","68a75b6703a70639b6cf39f0","69036ae54389be6be5f618a2","69036ae54389be6be5f619ea","68a75b6803a70639b6cf43a3"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":7,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"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.04180145263672,\"lng\":-76.29989624023438,\"latlng\":\"40.041801452637,-76.299896240234\",\"city\":\"Lancaster\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.44000000 1766243585)","created":"MongoDate(0.44000000 1766243585)"} , true)	0	2

Lancaster

Pennsylvania

Lancaster Groups and Organizations

32nd Degree Masonic Learning Centers for Children, Inc.

Conestoga Valley High School

Conestoga Valley School District

Franklin and Marshall College

Hamilton Elementary Recycling Program

Harrisburg Area Community College - Lancaster Campus

J.P. McCaskey High School

Lampeter-Strasburg High School

Lampeter-Strasburg School District

Lancaster Bible College

Lancaster General College of Nursing and Health Sciences

Lancaster Mennonite High School

Lancaster Public Library

Lancaster Theological Seminary

Manheim Township High School

Penn Manor School District

Pennsylvania College of Art and Design

Schaeffer Elementary School

School District Of Lancaster

Smoketown Elementary School

Local Events

Lancaster Central Market

Deck the Halls

Elf - The Musical

Deck the Halls

Elf - The Musical

Elf - The Musical

Lancaster Central Market

Elf - The Musical

Elf - The Musical

Lancaster Central Market

COVID-19 Resources