Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"litchfield-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"scottsdale-az"}, [] ).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":"scottsdale-az","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	10
7	db.events_cache.find( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"ba7a4b79e14c2a68590f642c885915a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"address.town_sef_url":"scottsdale-az"}, ["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":"6b41d1df0ee6d5279f7f2ad21072f0e8"} )	0	1
11	db.events_cache.count( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8"} )	0	6
12	db.events_cache.insert( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8","town_sef_url":"scottsdale-az","data_key":["690a193e4e26b3fc080ad4c5","688b2cc8fb5e4bed1f074dbe","690a193e4e26b3fc080ad4c6","690a193e4e26b3fc080ad4c7","691f9151de4ae56f5ac572e6","685670d8fb5e4bed1f3b2c23","690a193e4e26b3fc080ad4c8","6857c262fb5e4bed1f8707d3","68c0e124c3af739f253dc2e1","690a193e4e26b3fc080ad4c9"],"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\":33.58140182495117,\"lng\":-111.89299774169922,\"latlng\":\"33.581401824951,-111.8929977417\",\"city\":\"Scottsdale\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.43100000 1765821523)","created":"MongoDate(0.43100000 1765821523)"} , 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	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	31
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Scottsdale

Arizona

Scottsdale Groups and Organizations

Appaloosa Library

Arabian Library

Arcadia Neighborhood Learning Center

Aztec Elementary School

Camelback Desert School

Cave Creek Unified School District #93

Civic Center Library

Civic Center Library

Cocopah Middle School

Coronado High School

Desert Canyon Elementary School

Evans Newton Incorporated

Evans Newton Incorporated

Laguna Elementary School

Little Sunshine's Playhouse and Preschool of Scottsdale

Mustang Library

Northcentral University

Paradise Valley Community College at Black Mountain

Scottsdale Community College

Sequoya Elementary School

Local Events

Miracle Bar

ASU Kerr Tuesday Morning Music & Tea

Miracle Bar

Miracle Bar

Honor Hanukkah at Scottsdazzle’s Public Menorah Lighting and Public Hanukkah Celebration DEC. 17 and DEC. 21

Performance - It's A Wonderful Life

Miracle Bar

Performance - It's A Wonderful Life

A Winter's Eve with David Arkenstone and Friends

Miracle Bar