Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"columbia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
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":"columbia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","lancaster-county-pa","columbia-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.places.find( {"address.town_sef_url":"columbia-pa"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"daa6bb4cca74b608efb5d9fa09ba6fa3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"b2a287099f10efeea3eaf082ab067d8a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766901600)"},"geo":{"$geoWithin":{"$center":[[-76.49500274658203,40.03239822387695],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	195
9	db.events_cache.count( {"_id":"daa6bb4cca74b608efb5d9fa09ba6fa3"} )	0	1
10	db.events_cache.insert( {"_id":"daa6bb4cca74b608efb5d9fa09ba6fa3","town_sef_url":"columbia-pa","data_key":["68a75b6c03a70639b6cf59d1","69036ae94389be6be5f62cbb","69036ae94389be6be5f62e04","68a75b6c03a70639b6cf5c8e","69036ae94389be6be5f62fee","68a75b6d03a70639b6cf6001","68a75b6d03a70639b6cf600b","69036aeb4389be6be5f63875","69036aed4389be6be5f64547","69036aee4389be6be5f64920"],"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.03239822387695,\"lng\":-76.49500274658203,\"latlng\":\"40.032398223877,-76.495002746582\",\"city\":\"Columbia\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.39800000 1766918122)","created":"MongoDate(0.39800000 1766918122)"} , true)	0	2

Columbia

Pennsylvania

Columbia Groups and Organizations

AJ's Surplus Grocery

BluesFest

Borough of Columbia

Clockwork Festival

Columbia Borough School District

Columbia Kettle Works

Columbia Market House

Columbia Presbyterian Church

Columbia Public Library

Concordia Evangelical Lutheran Church

Fall Fest

Fish Mechanical, LLC

Garth Gallery And Custom Frame Shop

Hermansader's Victorian Mansion B&B

Holy Trinity Catholic Church

Kinderhook EC Church

National Watch And Clock Museum

Oswego Drive Community Baptist Church

Our Lady Of The Angels School

Rotary Club of Columbia 5336

Local Events

Masonic Village Farm Market

Elf - The Musical

Hershey Bears vs. Charlotte Checkers

Stephen Kellogg

Elf - The Musical

Lancaster Central Market

Penn Market

4th Annual New Year's Eve of Destruction and Car Drop

Hershey Bears vs. Rockford IceHogs

Hershey Bears vs. Rockford IceHogs

COVID-19 Resources