Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"andalusia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"andalusia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","pa","bucks-county-pa","andalusia-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	3	1
5	db.events_cache.find( {"_id":"7624477491f11ac2f70bc80e78ad11ae"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"dd550377bbf10c3413645717cbb60c17"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"andalusia-pa","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.9293441772461,40.10279846191406],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	12	22
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.9293441772461,40.10279846191406],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	19	20
10	db.events_radius_cache.count( {"_id":"dd550377bbf10c3413645717cbb60c17"} )	0	1
11	db.events_radius_cache.insert( {"_id":"dd550377bbf10c3413645717cbb60c17","radius":15,"modified":"MongoDate(0.24600000 1766846602)","created":"MongoDate(0.24600000 1766846602)"} , true)	0	1
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"geo":{"$geoWithin":{"$center":[[-74.9293441772461,40.10279846191406],0.21739130434782608]}}}, ["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	122
13	db.events_cache.count( {"_id":"7624477491f11ac2f70bc80e78ad11ae"} )	0	1
14	db.events_cache.count( {"_id":"7624477491f11ac2f70bc80e78ad11ae"} )	0	1
15	db.events_cache.insert( {"_id":"7624477491f11ac2f70bc80e78ad11ae","town_sef_url":"andalusia-pa","data_key":["68a75b6903a70639b6cf4c19","68a75b6a03a70639b6cf4eda","68a75b6a03a70639b6cf4edd","68a75b6a03a70639b6cf5086","69036ae74389be6be5f62564","68a75b6b03a70639b6cf58d2","69036ae94389be6be5f62e46","69036ae94389be6be5f63081","68a75b6c03a70639b6cf5d3d","693321074389be6be5655845","68a75b6d03a70639b6cf60a3","68a75b6d03a70639b6cf617c","693321074389be6be5655a2e","693321084389be6be5655d47","693321084389be6be5656204"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Andalusia Featured Events\",\"keyword\":\"\",\"radius\":15,\"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.10279846191406,\"lng\":-74.9293441772461,\"latlng\":\"40.102798461914,-74.929344177246\",\"city\":\"Andalusia\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.40900000 1766846602)","created":"MongoDate(0.40900000 1766846602)"} , true)	0	1

Andalusia

Pennsylvania

Andalusia Featured Events

Fitler Square Farmers Market

Clark Park Farmers Market

Northern Liberties Farmers Market

Company Town Walking Tour

Holiday Light Show

Headhouse Farmers' Market

Holiday Light Show

Jacquees

Meditation

Diggerland USA Holiday Light Show!

Rittenhouse Farmers Market

Frankfort Transportation Center Farmers Market

Diggerland USA Holiday Light Show!

Diggerland USA Holiday Light Show!

Diggerland USA Holiday Light Show!

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.

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