Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"white-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"051ad7d57d731d0b6309774beca5969c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"1ddf2c86c42c4983b906a4a65e723c94"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"white-pa","start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770271200)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.43769836425781,40.06990051269531],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	0	20
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.43769836425781,40.06990051269531],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	0	29
10	db.events_radius_cache.count( {"_id":"1ddf2c86c42c4983b906a4a65e723c94"} )	0	1
11	db.events_radius_cache.count( {"_id":"1ddf2c86c42c4983b906a4a65e723c94"} )	0	1
12	db.events_radius_cache.insert( {"_id":"1ddf2c86c42c4983b906a4a65e723c94","radius":25,"modified":"MongoDate(0.29300000 1769741088)","created":"MongoDate(0.29300000 1769741088)"} , true)	0	1
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"geo":{"$geoWithin":{"$center":[[-79.43769836425781,40.06990051269531],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	185
14	db.events_cache.count( {"_id":"051ad7d57d731d0b6309774beca5969c"} )	0	1
15	db.events_cache.count( {"_id":"051ad7d57d731d0b6309774beca5969c"} )	0	1
16	db.events_cache.insert( {"_id":"051ad7d57d731d0b6309774beca5969c","town_sef_url":"white-pa","data_key":["6933cbd9de4ae56f5a4a7a68","6896c2c5fb5e4bed1f1b5678","689ffd45fb5e4bed1f956cf2","68a9068ac3af739f250a4aae","68b24109c3af739f2526f11f","68bb7b85c3af739f25f922c5","68c4b52bc3af739f2551f58f","68cdf084c3af739f25a44ec0","68d72b04c3af739f25a31c3b","68e06582c3af739f25278b16","68e99ffec3af739f254af5b0","68f2da7dc3af739f250d69ab","68f8207dc3af739f25c1ed31","68f8207dc3af739f25c1ed3d","693bb4d9de4ae56f5ad9d19a"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"White 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.06990051269531,\"lng\":-79.43769836425781,\"latlng\":\"40.069900512695,-79.437698364258\",\"city\":\"White\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.67300000 1769741088)","created":"MongoDate(0.67300000 1769741088)"} , true)	0	1
17	db.towns.find( {"sef_url":"white-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.tokens.find( {"sef_url":{"$in":["usa","pa","fayette-county-pa","white-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

White

Pennsylvania

White Featured Events

Lee Brice

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Kenny Wayne Shepherd

Kenny Wayne Shepherd

ZZ Top

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.

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