Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"windsor-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	26
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.towns.find( {"sef_url":"scranton-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"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	2
6	db.events_cache.find( {"_id":"1787c8dbaeb96c28a460033b9f930dd3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"5bcaa45853397dc7cbcc4463ea3569b9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-79.74569702148438,33.91699981689453],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	401
9	db.events_cache.count( {"_id":"1787c8dbaeb96c28a460033b9f930dd3"} )	0	11
10	db.events_cache.count( {"_id":"1787c8dbaeb96c28a460033b9f930dd3"} )	0	9
11	db.events_cache.insert( {"_id":"1787c8dbaeb96c28a460033b9f930dd3","town_sef_url":"scranton-sc","data_key":["68d4a7a4c3af739f2545124b","685a658efb5e4bed1f655a61","68d4a7a4c3af739f254514b9","68639fddfb5e4bed1fa5b935","68d4a7a4c3af739f25451659","68d4a7a4c3af739f254516e4","68d4a7a4c3af739f25451759","68d4a7a5c3af739f2545195e","68d4a7a5c3af739f254519e8","6933cbd8de4ae56f5a4a73ef","68ff0fe2c3af739f25a57e6e","68c0e125c3af739f253dd067","68c0e125c3af739f253dd134","69154118de4ae56f5aae0186","69154118de4ae56f5aae01d9"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Scranton 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\":33.91699981689453,\"lng\":-79.74569702148438,\"latlng\":\"33.916999816895,-79.745697021484\",\"city\":\"Scranton\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.07100000 1765739039)","created":"MongoDate(0.07100000 1765739039)"} , true)	0	9
12	db.towns.find( {"sef_url":"scranton-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
13	db.tokens.find( {"sef_url":{"$in":["usa","sc","florence-county-sc","scranton-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	19
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	8

Scranton

South Carolina

Scranton Featured Events

Pee Dee Icecats

City Center Farmers Market

Pee Dee Icecats vs. Athens Rock Lobsters

City Center Farmers Market

Pee Dee Icecats vs. Danbury Hat Tricks

Pee Dee Icecats vs. Danbury Hat Tricks

Pee Dee Icecats vs. Danbury Hat Tricks

Pee Dee Icecats vs. Athens Rock Lobsters

Pee Dee Icecats vs. Athens Rock Lobsters

Billy Martin

A Taste of Ireland - The Irish Music and Dance Sensation

AMA Partzilla Arenacross Series

AMA Partzilla Arenacross Series

Florence Stampede & Pro Rodeo

Florence Stampede & Pro Rodeo

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.

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