Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bird-in-hand-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"bird-in-hand-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","pa","lancaster-county-pa","bird-in-hand-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"ba67530d8c1ae7e234c281b247e469a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"29e5860ec7eed48a5cacb0711e5c4540"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"bird-in-hand-pa","start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767592800)"}} )	0	1
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.17890167236328,40.03960037231445],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	0	18
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.17890167236328,40.03960037231445],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	7	16
9	db.events_radius_cache.count( {"_id":"29e5860ec7eed48a5cacb0711e5c4540"} )	0	1
10	db.events_radius_cache.insert( {"_id":"29e5860ec7eed48a5cacb0711e5c4540","radius":25,"modified":"MongoDate(0.23200000 1767069194)","created":"MongoDate(0.23200000 1767069194)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766988000)"},"geo":{"$geoWithin":{"$center":[[-76.17890167236328,40.03960037231445],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	165
12	db.events_cache.count( {"_id":"ba67530d8c1ae7e234c281b247e469a1"} )	0	1
13	db.events_cache.count( {"_id":"ba67530d8c1ae7e234c281b247e469a1"} )	0	1
14	db.events_cache.insert( {"_id":"ba67530d8c1ae7e234c281b247e469a1","town_sef_url":"bird-in-hand-pa","data_key":["693321074389be6be5655827","68a75b6d03a70639b6cf6001","693321074389be6be5655a0a","693321084389be6be5655d1f","69036aeb4389be6be5f63875","693321084389be6be56561f1","693321084389be6be56562cc","69036aef4389be6be5f6564b","6933210b4389be6be56576c3","69036af54389be6be5f682c4","68a75b7503a70639b6cf9f2d","68a75b7503a70639b6cfa01f","693321104389be6be5659d08","693321104389be6be5659f35","68a75b7703a70639b6cfb1dc"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Bird in Hand 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\":40.03960037231445,\"lng\":-76.17890167236328,\"latlng\":\"40.039600372314,-76.178901672363\",\"city\":\"Bird in Hand\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.42600000 1767069194)","created":"MongoDate(0.42600000 1767069194)"} , true)	0	1

Bird in Hand

Pennsylvania

Bird in Hand Featured Events

Refreshing Mountain Christmas Light Adventures

Lancaster Central Market

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

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

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

50's Dance Party

Willy Blaze and the Bad News Crew

The Menzingers

Elvis Birthday Bash with Mike Albert & Scot Bruce

Elvis Birthday Bash with Mike Albert & Scot Bruce

Josh Ritter

G. Love & Special Sauce

Best Friends Girl

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.

Bird in Hand 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.