Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hansford-wv"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"saint-louis-mo"}, [] ).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":"saint-louis-mo","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	5
7	db.events_cache.find( {"_id":"cc3b79747e5aba663ae670ce08dc08d9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"e8b47cba3385a7d0f9b1381dff865174"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"address.town_sef_url":"saint-louis-mo"}, ["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":"cc3b79747e5aba663ae670ce08dc08d9"} )	0	1
11	db.events_cache.count( {"_id":"cc3b79747e5aba663ae670ce08dc08d9"} )	0	1
12	db.events_cache.insert( {"_id":"cc3b79747e5aba663ae670ce08dc08d9","town_sef_url":"saint-louis-mo","data_key":["685a658bfb5e4bed1f655598","68ae6c28c3af739f25a9888e","69200554de4ae56f5af2c5dc","685670cffb5e4bed1f3b1897","68ef059ec3af739f254bf867","68a6f9a3c3af739f2569d31e","68c0e124c3af739f253dc273","68ef059ec3af739f254bf879","69200554de4ae56f5af2c671","69324210de4ae56f5af0299c"],"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\":38.627498626708984,\"lng\":-90.19840240478516,\"latlng\":\"38.627498626709,-90.198402404785\",\"city\":\"St. Louis\",\"state\":\"MO\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.00800000 1765868485)","created":"MongoDate(0.00800000 1765868485)"} , 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

St. Louis

Missouri

St. Louis Groups and Organizations

Ames Visual and Performing Arts Elementary School

Baden Branch Library

Barr Branch Library

Buder Branch Library

Buder Elementary School

Carondelet Branch Library

Christ Community Lutheran School

Cliff Cave Branch Library

Columbia College - Saint Louis Campus

Concordia Seminary

Covenant Theological Seminary

De la Salle Middle School

Dewey International Studies

Divoll Branch Library

Fontbonne University

Forsyth School

Gateway Middle School

Hancock Place School District

Harris-Stowe State University

Jefferson Elementary School

Local Events

The Lemonheads: Love Chant World Tour

Mrs. Doubtfire

Straight No Chaser

Soulard Farmers Market

Saint Louis Billikens Women's Basketball vs. Jacksonville State Gamecocks Womens Basketball

Preservation Hall Jazz Band

St. Louis Blues Vs. Winnipeg Jets

Saint Louis Billiken Mens Basketball vs. Bethune-Cookman Wildcats Men's Basketball

Jody Nardone Trio

Voodoo Led Zeppelin