Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bancroft-ne"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.towns.find( {"sef_url":"norman-ok"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
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	4
6	db.places.find( {"address.town_sef_url":"norman-ok","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	7	2
7	db.events_cache.find( {"_id":"cb9e0d3330289e541fc8e91e485dc9f9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"46e9b71966e0b1dee12e366f49e57093"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-97.44129943847656,35.191200256347656],0.36231884057971014]}}}, ["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	137
10	db.events_cache.count( {"_id":"cb9e0d3330289e541fc8e91e485dc9f9"} )	0	1
11	db.events_cache.count( {"_id":"cb9e0d3330289e541fc8e91e485dc9f9"} )	0	1
12	db.events_cache.insert( {"_id":"cb9e0d3330289e541fc8e91e485dc9f9","town_sef_url":"norman-ok","data_key":["693bed0ede4ae56f5a38f4d0","68df339fc3af739f2509e49f","69200554de4ae56f5af2c610","689eabbdfb5e4bed1f7b3167","68ccf6e6c3af739f259f6428","687fca73fb5e4bed1fcbd295","68f9353169adceb60507b8c8","69363693de4ae56f5a26a635","68ca53e4c3af739f254ff083","68ce1028c3af739f25eb3081"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"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.191200256347656,\"lng\":-97.44129943847656,\"latlng\":\"35.191200256348,-97.441299438477\",\"city\":\"Norman\",\"state\":\"OK\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.23500000 1765807373)","created":"MongoDate(0.23500000 1765807373)"} , true)	0	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	10
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	18
17	db.towns.find( {"sef_url":"norman-ok"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
18	db.tokens.find( {"sef_url":{"$in":["usa","ok","cleveland-county-ok","norman-ok"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	11
19	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	16
20	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
21	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2

Norman

Oklahoma

Norman Groups and Organizations

Little Axe Public Schools

Norman Public Library

Norman Public Schools

Pioneer Library System

Robin Hill Public School

The University of Oklahoma

University Libraries

Local Events

Pet Care Service Oklahoma City

Oklahoma Sooners Mens Basketball vs. Kansas City Roos Mens Basketball

Teethe

Oklahoma City Thunder vs. LA Clippers

Andy Frasco & The U.N. and Candi Jenkins

Arkansauce

Holiday Pop-Up Shops

CFP First Round: Oklahoma vs Alabama

Treaty Oak Revival, Gannon Fremin & CCREV and more

Treaty Oak Revival w/ Gannon Fremin and CCREV