Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bannock-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"charleston-afb-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":"b88723d328f0aac3c63ba653f9f5bc5e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-80.0521011352539,32.9025993347168],0.07246376811594203]}}}, ["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	229
8	db.events_cache.count( {"_id":"b88723d328f0aac3c63ba653f9f5bc5e"} )	0	1
9	db.events_cache.count( {"_id":"b88723d328f0aac3c63ba653f9f5bc5e"} )	0	1
10	db.events_cache.insert( {"_id":"b88723d328f0aac3c63ba653f9f5bc5e","town_sef_url":"charleston-afb-sc","data_key":["691fcd18de4ae56f5a67e7f0","691fcd18de4ae56f5a67e7fe","68a7d4adc3af739f25823aa9","68a7d4aec3af739f25823c8a","68c8ca22c3af739f25291943","68c8ca22c3af739f2529199e","68c8ca22c3af739f252919e2","68a7d4aec3af739f25823e1e","68a7d4aec3af739f25823e5f","6900291cc3af739f259bb26b","68a7d4aec3af739f25823f75","68c8ca22c3af739f25291d13","68a7d4aec3af739f25823fc5","68a7d4aec3af739f2582400d","68a7d4aec3af739f2582409e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Charleston AFB Featured Events\",\"keyword\":\"\",\"radius\":5,\"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\":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.24600000 1766543126)","created":"MongoDate(0.24600000 1766543126)"} , true)	0	2
11	db.towns.find( {"sef_url":"charleston-afb-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.tokens.find( {"sef_url":{"$in":["usa","sc","charleston-county-sc","charleston-afb-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Charleston AFB

South Carolina

Charleston AFB Featured Events

NUTCRACKER! Magical Christmas Ballet

NUTCRACKER! Magical Christmas Ballet

South Carolina Stingrays vs. Orlando Solar Bears

South Carolina Stingrays vs. Greensboro Gargoyles

PBR Two-Day Package - Ticket Includes Access to all days

PBR Pendleton Whisky Velocity Tour

PBR Pendleton Whisky Velocity Tour

South Carolina Stingrays vs. Savannah Ghost Pirates

South Carolina Stingrays vs. Savannah Ghost Pirates

An Evening With Larry The Cable Guy

South Carolina Stingrays vs. Atlanta Gladiators

WILD KRATTS LIVE! 2.0 - Activate Creature Power!

South Carolina Stingrays vs. Florida Everblades

South Carolina Stingrays vs. Florida Everblades

South Carolina Stingrays vs. Jacksonville Icemen

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

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.