Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"cache-junction-ut"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"effingham-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
6	db.events_cache.find( {"_id":"b4bebda3c1d1cef5fb84b5ad7f695464"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"09c8065f8ca444c96aa30869aaf60737"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-79.75659942626953,34.05730056762695],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	297
9	db.events_cache.count( {"_id":"b4bebda3c1d1cef5fb84b5ad7f695464"} )	0	1
10	db.events_cache.count( {"_id":"b4bebda3c1d1cef5fb84b5ad7f695464"} )	0	1
11	db.events_cache.insert( {"_id":"b4bebda3c1d1cef5fb84b5ad7f695464","town_sef_url":"effingham-sc","data_key":["6857c25dfb5e4bed1f870003","68d4a7a4c3af739f2545124b","685a658efb5e4bed1f655a61","68d4a7a4c3af739f254514b9","68639fddfb5e4bed1fa5b935","68d4a7a4c3af739f25451659","68d4a7a4c3af739f254516e4","68d4a7a4c3af739f25451759","68d4a7a5c3af739f2545195e","68d4a7a5c3af739f254519e8","6933cbd8de4ae56f5a4a73ef","68ff0fe2c3af739f25a57e6e","68c0e125c3af739f253dd067","68c0e125c3af739f253dd134","69154118de4ae56f5aae0186"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Effingham 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\":34.05730056762695,\"lng\":-79.75659942626953,\"latlng\":\"34.057300567627,-79.75659942627\",\"city\":\"Effingham\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.84900000 1765989430)","created":"MongoDate(0.84900000 1765989430)"} , true)	0	3
12	db.towns.find( {"sef_url":"effingham-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	16
13	db.tokens.find( {"sef_url":{"$in":["usa","sc","florence-county-sc","effingham-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
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	4
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Effingham

South Carolina

Effingham Featured Events

Darlington Farmers Market

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

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.

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