Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"westfield-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"cincinnati-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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":"cincinnati-oh","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	14
7	db.events_cache.find( {"_id":"10cfea7f0a0c4903c535a39f343bc666"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	13
8	db.events_radius_cache.find( {"_id":"c468f05349a5b7fa4b49df6f21305bff"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"address.town_sef_url":"cincinnati-oh"}, ["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	3
10	db.events_cache.count( {"_id":"10cfea7f0a0c4903c535a39f343bc666"} )	0	8
11	db.events_cache.count( {"_id":"10cfea7f0a0c4903c535a39f343bc666"} )	0	10
12	db.events_cache.insert( {"_id":"10cfea7f0a0c4903c535a39f343bc666","town_sef_url":"cincinnati-oh","data_key":["68e86e1dc3af739f252188da","68f2fa1ec3af739f2533d076","6883c78a7573f16cf43c13a4","68edb41bc3af739f2514ba0b","68e71ca0c3af739f25e593ef","685670d9fb5e4bed1f3b3087","68f2fa1ec3af739f2533d0e2","68aff5ecc3af739f257584ac","6883c78a7573f16cf43c13a5","6857c260fb5e4bed1f8704c0"],"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\":39.09920120239258,\"lng\":-84.51750183105469,\"latlng\":\"39.099201202393,-84.517501831055\",\"city\":\"Cincinnati\",\"state\":\"OH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.82300000 1765928220)","created":"MongoDate(0.82300000 1765928220)"} , true)	0	6
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	4
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	3
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Cincinnati

Ohio

Cincinnati Groups and Organizations

Adopt a Book

Anderson Branch Library

Art Academy of Cincinnati

Art Academy of Cincinnati

Avondale Branch Library

Blue Ash Branch Library

Bond Hill Branch Library

Carpe Diem-Aiken

Cheviot Branch Library

Cincinnati Christian University

Cincinnati College of Mortuary Science

Cincinnati Public Schools

Cincinnati State Technical and Community College

Clifton Branch Library

College Hill Branch Library

College of Mount Saint Joseph

Corryville Branch Library

Covedale Branch Library

Deer Park Branch Library

Deer Park Community City Schools

Local Events

Cincinnati Bearcats Women's Basketball vs. Howard Bison Women's Basketball

Hamilton (Touring)

Ornament Blow

Xavier Musketeers Mens Basketball vs. Creighton Blue Jays Mens Basketball

Cincinnati Bearcats Mens Basketball vs. Alabama State Hornets Mens Basketball

Irish Christmas in America

Hamilton (Touring)

Cursive

Ornament Blow

Dailey & Vincent