Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"alto-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"charlotte-nc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"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.places.find( {"address.town_sef_url":"charlotte-nc","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	5
7	db.events_cache.find( {"_id":"b5f7747f43dfef00133d82cba5bb6840"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"c5a80b255f2b2ad7cb69aba5d6f0030a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"address.town_sef_url":"charlotte-nc"}, ["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":"b5f7747f43dfef00133d82cba5bb6840"} )	0	1
11	db.events_cache.count( {"_id":"b5f7747f43dfef00133d82cba5bb6840"} )	0	1
12	db.events_cache.insert( {"_id":"b5f7747f43dfef00133d82cba5bb6840","town_sef_url":"charlotte-nc","data_key":["68cd2fd91f575976390b76c2","6904b84bde4ae56f5ab7f21a","68cd2fd91f575976390b76c3","68fa9aaa695f30aa8809bc11","6904b84bde4ae56f5ab7f21d","68fa99da34c9e7cdf6042e60","689eabbdfb5e4bed1f7b347a","68cd2fd91f575976390b76c4","68fa9aaa695f30aa8809bc12","68cd2fd91f575976390b76c5"],"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\":35.23139953613281,\"lng\":-80.8458023071289,\"latlng\":\"35.231399536133,-80.845802307129\",\"city\":\"Charlotte\",\"state\":\"NC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.67600000 1766440724)","created":"MongoDate(0.67600000 1766440724)"} , true)	0	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

Charlotte

North Carolina

Charlotte Groups and Organizations

Allegra Westbrooks Regional Library

Back Creek Christian Academy

Bain Elementary School

Billy Graham Library

Carmel Middle School

Central Piedmont Community College

Charlotte Mecklenburg Library

Charlotte-Mecklenburg Schools

E. E. Waddell High School

Freedom Regional Branch Library

Hickory Grove Branch Library

Independence Regional Branch Library

Johnson And Wales University - Charlotte

Johnson C. Smith University

Kiddie Kare Learning Center

Lambs of Grace Child Devlopment Center

Montreat College - Charlotte Campus

Morrison Regional Branch Library

Mountain Island Branch Library

Myers Park Branch Library

Local Events

Exhibition: Above and Beyond

Christmas at the Library

Exhibition: Above and Beyond

Dr. Seuss' How The Grinch Stole Christmas

Christmas at the Library

Dr. Seuss' How The Grinch Stole Christmas

Charlotte Hornets vs. Washington Wizards

Exhibition: Above and Beyond

Dr. Seuss' How The Grinch Stole Christmas

Exhibition: Above and Beyond