Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gap-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"gap-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","lancaster-county-pa","gap-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"1606175e225cf7ef6e8a1e698d2595f4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"7ca045554df01260e527388a388a2caf"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"gap-pa","start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767506400)"}} )	0	1
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.0250015258789,39.992698669433594],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	0	16
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.0250015258789,39.992698669433594],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766901600)","$lt":"MongoDate(0.00000000 1767765600)"}} )	0	20
9	db.events_radius_cache.count( {"_id":"7ca045554df01260e527388a388a2caf"} )	0	1
10	db.events_radius_cache.insert( {"_id":"7ca045554df01260e527388a388a2caf","radius":25,"modified":"MongoDate(0.83700000 1766951450)","created":"MongoDate(0.83700000 1766951450)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766901600)"},"geo":{"$geoWithin":{"$center":[[-76.0250015258789,39.992698669433594],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	117
12	db.events_cache.count( {"_id":"1606175e225cf7ef6e8a1e698d2595f4"} )	0	1
13	db.events_cache.count( {"_id":"1606175e225cf7ef6e8a1e698d2595f4"} )	0	1
14	db.events_cache.insert( {"_id":"1606175e225cf7ef6e8a1e698d2595f4","town_sef_url":"gap-pa","data_key":["69036ae84389be6be5f62b9d","69036ae94389be6be5f62cbb","68a75b6c03a70639b6cf5c8e","69036ae94389be6be5f62fee","693321074389be6be5655827","68a75b6d03a70639b6cf6001","693321074389be6be5655a0a","69036aeb4389be6be5f63852","693321084389be6be5655d1f","69036aeb4389be6be5f63875","68a75b6e03a70639b6cf688c","693321084389be6be56561f1","693321084389be6be56562cc","69036aed4389be6be5f6465e","69036aef4389be6be5f6515a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Gap 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\":39.992698669433594,\"lng\":-76.0250015258789,\"latlng\":\"39.992698669434,-76.025001525879\",\"city\":\"Gap\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.99100000 1766951450)","created":"MongoDate(0.99100000 1766951450)"} , true)	0	1

Gap

Pennsylvania

Gap Featured Events

A Longwood Christmas

Elf - The Musical

Stephen Kellogg

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Lancaster Central Market

Refreshing Mountain Christmas Light Adventures

Reading Royals vs. Norfolk Admirals

Refreshing Mountain Christmas Light Adventures

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

Reading Symphony Orchestra - Music of James Bond (NYE Special)

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

World Championship Ice Racing: Crazy Train Tour

Reading Royals vs. Maine Mariners

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.

Gap 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.