Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"alpine-ut"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	15
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"phoenix-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
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":"phoenix-az","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	14
7	db.events_cache.find( {"_id":"8e070f54ec404f0f31e848f6bc7344ea"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"a3bc05fc4e3322fc2bd7c6e8a0417540"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"address.town_sef_url":"phoenix-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":"8e070f54ec404f0f31e848f6bc7344ea"} )	0	1
11	db.events_cache.count( {"_id":"8e070f54ec404f0f31e848f6bc7344ea"} )	0	1
12	db.events_cache.insert( {"_id":"8e070f54ec404f0f31e848f6bc7344ea","town_sef_url":"phoenix-az","data_key":["691ce575b6ea19e0860bfc68","68963d05fb5e4bed1f99b25a","691cd9653f2415a02e0afb20","68f79eddc3af739f25447e4c","690ea996de4ae56f5ac27eec","686cda2cfb5e4bed1f720ccc","68f6ee9ac3af739f25828947","68f6ee9ac3af739f25828951","68c11965c3af739f259e2d47","686cda2cfb5e4bed1f720d12"],"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.448299407958984,\"lng\":-112.0739974975586,\"latlng\":\"33.448299407959,-112.07399749756\",\"city\":\"Phoenix\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.46100000 1765709280)","created":"MongoDate(0.46100000 1765709280)"} , 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

Phoenix

Arizona

Phoenix Groups and Organizations

Acacia Branch Library

Alhambra Elementary School District 68

American Indian College

Arizona Centers for Comprehensive Education and Life-Skills

Arizona Christian University

Arizona State Library, Archives And Public Records

Arizona State University at the Downtown Phoenix Campus

Arizona State University at the West Campus

Balsz School District #31

Barry Goldwater High School

Burton Barr Central Library

Cartwright School District No.83

Century Branch Library

Cholla Library

CollegeAmerica - Phoenix Campus

Collins College

Constitution Elementary School

Cortez High School

Creighton School District

DeVry University - Phoenix Campus

Local Events

14th Annual Phoenix Festival of the Arts

Ahwatukee Farmers Market

48th Annual S'edav Va'aki Museum Indian Market

3rd Annual Art at Anthem

Torohiki No Sonogo

Phoenix Ballet The Nutcracker

Ballet Arizona w/ The Nutcracker

Grand Canyon University Lopes Womens Basketball vs. Santa Clara Broncos Womens Basketball

Marmalade Skies

Phoenix Ballet The Nutcracker