Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"clarkdale-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"philadelphia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/hijinx-official-after-party-illenium-21-event-2025-12-27-tm-philadelphia-pa.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"98f73c38e36f653b0e226973ace78793"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	3
7	db.events_radius_cache.find( {"_id":"f368538760e4e17e52088a0754e1f46c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"address.town_sef_url":"philadelphia-pa"}, ["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	1
9	db.events_cache.count( {"_id":"98f73c38e36f653b0e226973ace78793"} )	0	1
10	db.events_cache.count( {"_id":"98f73c38e36f653b0e226973ace78793"} )	0	1
11	db.events_cache.insert( {"_id":"98f73c38e36f653b0e226973ace78793","town_sef_url":"philadelphia-pa","data_key":["685e5a14fb5e4bed1f6218af","689c543ff957a70c3306db5d","689c5c58c4766aed420de8ed","685e5a17fb5e4bed1f621f28","690cf933de4ae56f5a29ac1a","685e5a1afb5e4bed1f622517","689eabbdfb5e4bed1f7b3474","685fab7cfb5e4bed1fb55af3","689c5444da3e0489fb066de7","689c5c5269adceb60507b4d5","690cf934de4ae56f5a29ac40","690cf934de4ae56f5a29ac48","689c5441302db3bbce02aca1","68624e8ffb5e4bed1f2f7313","690cf934de4ae56f5a29ac56"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Philadelphia Featured Events\",\"keyword\":\"\",\"radius\":0,\"limit\":15,\"page\":1,\"sef\":\"hijinx-official-after-party-illenium-21-event-2025-12-27-tm-philadelphia-pa.html\",\"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.95159912109375,\"lng\":-75.16380310058594,\"latlng\":\"39.951599121094,-75.163803100586\",\"city\":\"Philadelphia\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.17600000 1766548196)","created":"MongoDate(0.17600000 1766548196)"} , true)	0	1
12	db.towns.find( {"sef_url":"philadelphia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","pa","philadelphia-county-pa","philadelphia-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Philadelphia

Pennsylvania

Philadelphia Featured Events

Rittenhouse Farmers Market

Made in Philadelphia Holiday Market

Christmas Village in Philadelphia

Frankfort Transportation Center Farmers Market

Diggerland USA Holiday Light Show!

A Christmas Story, the Musical

Philadelphia 76ers vs. Brooklyn Nets

Mill Creek Farm Farmers Market

Made in Philadelphia Holiday Market

Christmas Village in Philadelphia

Diggerland USA Holiday Light Show!

Diggerland USA Holiday Light Show!

Made in Philadelphia Holiday Market

A Christmas Story, the Musical

Diggerland USA Holiday Light Show!

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.

Philadelphia Featured Events

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.