Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"spicer-mn"}, [] ).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":"charleston-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.places.find( {"address.town_sef_url":"charleston-sc","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	17	4
7	db.events_cache.find( {"_id":"b0c86ac6b33e899edcb783cbb049ff42"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"e63b7801c04dd7d7bd5a9cd7f4498cb6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"address.town_sef_url":"charleston-sc"}, ["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( 11 ).skip( 0 )	11	1
10	db.events_cache.count( {"_id":"b0c86ac6b33e899edcb783cbb049ff42"} )	0	1
11	db.events_cache.count( {"_id":"b0c86ac6b33e899edcb783cbb049ff42"} )	0	1
12	db.events_cache.insert( {"_id":"b0c86ac6b33e899edcb783cbb049ff42","town_sef_url":"charleston-sc","data_key":["68c321b6c3af739f2538cd28","6853cdf9fb5e4bed1f55d5ad","68c321b6c3af739f2538cd2b","68551f40fb5e4bed1fd106de","68551f41fb5e4bed1fd1078f","68c321b6c3af739f2538cd33","685670d1fb5e4bed1f3b1dc2","685670d4fb5e4bed1f3b26a1","68f1a89dc3af739f25dd6a7b","68c321b6c3af739f2538cd80"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":0,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":32.79309844970703,\"lng\":-79.94129943847656,\"latlng\":\"32.793098449707,-79.941299438477\",\"city\":\"Charleston\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.78800000 1765822930)","created":"MongoDate(0.78800000 1765822930)"} , true)	0	2
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.towns.find( {"sef_url":"charleston-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
18	db.tokens.find( {"sef_url":{"$in":["usa","sc","charleston-county-sc","charleston-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Charleston

South Carolina

Charleston Groups and Organizations

Charleston County Public Library

Charleston County Public Library - John L. Dart Branch

Charleston County School District

Charleston County School District

Charleston School Of Law

Charleston Southern University

College Of Charleston

Cooper River Memorial Library

James Island Branch Library

John's Island Regional Library

New Life Chirstian Academy

Saint Andrews Regional Branch Library

The Class Acting Studios

Trident Technical College

Trident Technical College - Palmer Campus

Virginia College - North Charleston Campus

West Ashley Branch Library

Local Events

Charleston Christmas Special

Exhibition - Reimagined Fashion: Creations of the Future Past

Charleston Christmas Special

Exhibition - Reimagined Fashion: Creations of the Future Past

The Charleston Christmas Special

Charleston Christmas Special

Exhibition - Reimagined Fashion: Creations of the Future Past

The Charleston Christmas Special - KIDS FREE NIGHT

Charleston Cougars Mens Basketball vs. Citadel Bulldogs Basketball

Charleston Christmas Special