Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"charleston-afb-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/tyler-braden-vip-upgrade-2026-02-07-tm-lincoln-ne.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"charleston-afb-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","sc","charleston-county-sc","charleston-afb-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"d4e7a3079215ddbc79050f7381b384cc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"a200dea610a3aeac1e1643b073b97f6d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events.count( {"address.town_sef_url":"charleston-afb-sc","start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.0521011352539,32.9025993347168],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	9	31
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.0521011352539,32.9025993347168],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766210400)","$lt":"MongoDate(0.00000000 1767074400)"}} )	41	26
10	db.events_radius_cache.count( {"_id":"a200dea610a3aeac1e1643b073b97f6d"} )	0	1
11	db.events_radius_cache.insert( {"_id":"a200dea610a3aeac1e1643b073b97f6d","radius":15,"modified":"MongoDate(0.76100000 1766286266)","created":"MongoDate(0.76100000 1766286266)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-80.0521011352539,32.9025993347168],0.21739130434782608]}}}, ["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	57
13	db.events_cache.count( {"_id":"d4e7a3079215ddbc79050f7381b384cc"} )	0	1
14	db.events_cache.count( {"_id":"d4e7a3079215ddbc79050f7381b384cc"} )	0	1
15	db.events_cache.insert( {"_id":"d4e7a3079215ddbc79050f7381b384cc","town_sef_url":"charleston-afb-sc","data_key":["68a75b6303a70639b6cf238c","68a75b6303a70639b6cf2485","68a75b6303a70639b6cf253c","69036ae14389be6be5f60306","69036ae14389be6be5f603e4","69036ae14389be6be5f603e6","69036ae14389be6be5f60430","69036ae14389be6be5f6043e","68a75b6403a70639b6cf27a2","69036ae14389be6be5f60743","68a75b6403a70639b6cf29f3","69036ae24389be6be5f608f7","69036ae24389be6be5f609c8","69036ae24389be6be5f609e8","69036ae24389be6be5f609ff"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Charleston AFB Featured Events\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"tyler-braden-vip-upgrade-2026-02-07-tm-lincoln-ne.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\":32.9025993347168,\"lng\":-80.0521011352539,\"latlng\":\"32.902599334717,-80.052101135254\",\"city\":\"Charleston AFB\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.84100000 1766286266)","created":"MongoDate(0.84100000 1766286266)"} , true)	0	1

Charleston AFB

South Carolina

Charleston AFB Featured Events

Exhibition - Reimagined Fashion: Creations of the Future Past

Goose Creek Farmers and Artisans Market

Sea Island Farmers Market

Holy City Holiday Market

Charleston Symphony Orchestra: Holiday Pops!

Charleston Symphony Orchestra

Christmas at Drayton Hall

Charleston's Nutcracker by Palmetto City Ballet

The Charleston Christmas Special

South Carolina Stingrays vs. Orlando Solar Bears

The Charleston Christmas Special

Charleston's Nutcracker by Palmetto City Ballet

North Charleston Pops! Sounds of the Season

Charleston Symphony Orchestra: Holiday Pops!

Charleston Symphony Orchestra

COVID-19 Resources

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.

Charleston AFB Featured Events

COVID-19 Resources

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.