Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"jackson-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.counties.find( {"sef_url":"pickens-county-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.counties.find( {"sef_url":"pickens-county-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
6	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
7	db.events_cache.find( {"_id":"5c0454924c60c6b88bc77b5fd60cf41b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"6dd18aae64bab0a75be35b3e58f36d1a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
9	db.events.count( {"address.town_sef_url":"pickens-county-sc","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	1
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-82.74909973144531,34.78089904785156],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	19
11	db.events.count( {"geo":{"$geoWithin":{"$center":[[-82.74909973144531,34.78089904785156],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	0	29
12	db.events_radius_cache.count( {"_id":"6dd18aae64bab0a75be35b3e58f36d1a"} )	0	1
13	db.events_radius_cache.count( {"_id":"6dd18aae64bab0a75be35b3e58f36d1a"} )	0	1
14	db.events_radius_cache.insert( {"_id":"6dd18aae64bab0a75be35b3e58f36d1a","radius":25,"modified":"MongoDate(0.21200000 1766576378)","created":"MongoDate(0.21200000 1766576378)"} , true)	0	1
15	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-82.74909973144531,34.78089904785156],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	119
16	db.events_cache.count( {"_id":"5c0454924c60c6b88bc77b5fd60cf41b"} )	0	1
17	db.events_cache.count( {"_id":"5c0454924c60c6b88bc77b5fd60cf41b"} )	0	1
18	db.events_cache.insert( {"_id":"5c0454924c60c6b88bc77b5fd60cf41b","town_sef_url":"pickens-county-sc","data_key":["68fd0d4e24609126960d89b3","68fd101f3af6aa547c083994","68911578fb5e4bed1fbe386d","68639fdffb5e4bed1fa5bc77","68fd0d4e24609126960d89b4","68fd104fda3e0489fb06703b","68911578fb5e4bed1fbe3938","6864f18cfb5e4bed1f3a1b8d","68fd105e8248d952cc0d23dc","68fd0d681838ffc2f0001e9e","68911578fb5e4bed1fbe3a0c","68911578fb5e4bed1fbe3b0a","68edb41cc3af739f2514c02e","68911578fb5e4bed1fbe3c05","692e4d92de4ae56f5ae92de3"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Pickens County 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.78089904785156,\"lng\":-82.74909973144531,\"latlng\":\"34.780899047852,-82.749099731445\",\"city\":\"Pickens County\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.37500000 1766576378)","created":"MongoDate(0.37500000 1766576378)"} , true)	0	1
19	db.towns.find( {"sef_url":"pickens-county-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Pickens County

South Carolina

Pickens County Featured Events

The Quilter's Night Before Christmas

Greenville Christmas Market

Greenville Swamp Rabbits vs. Atlanta Gladiators

Anderson Jockey Lot and Farmers' Market

The Quilter's Night Before Christmas

Greenville Christmas Market

Greenville Swamp Rabbits vs. Jacksonville Icemen

Anderson Jockey Lot and Farmers' Market

Greenville Christmas Market

The Quilter's Night Before Christmas

Greenville Swamp Rabbits vs. Jacksonville Icemen

Greenville Swamp Rabbits vs. South Carolina Stingrays

Fool House - The Ultimate 90's Party: The Millennium Tour

Greenville Swamp Rabbits vs. Atlanta Gladiators

Clemson University Tigers Women's Gymnastics vs. Towson Gymnastics

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.

Pickens County 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.