Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"jeddo-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
3	db.towns.find( {"sef_url":"chino-hills-ca"}, [] ).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":"chino-hills-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	8	2
7	db.events_cache.find( {"_id":"b9d5717833defa7b0d85eda0ec9f13f4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"c72f75c547043d9abb37260a9b540a4b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-117.71499633789062,33.95869827270508],0.21739130434782608]}}}, ["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	65
10	db.events_cache.count( {"_id":"b9d5717833defa7b0d85eda0ec9f13f4"} )	0	1
11	db.events_cache.count( {"_id":"b9d5717833defa7b0d85eda0ec9f13f4"} )	0	1
12	db.events_cache.insert( {"_id":"b9d5717833defa7b0d85eda0ec9f13f4","town_sef_url":"chino-hills-ca","data_key":["685fab79fb5e4bed1fb55572","6930dbf2de4ae56f5a80dd45","6930dbf2de4ae56f5a80dd4f","6930dbf2de4ae56f5a80dd75","68624e95fb5e4bed1f2f7ed2","68624e95fb5e4bed1f2f7eee","68d5f927c3af739f25933a5f","68624e98fb5e4bed1f2f841d","68624e98fb5e4bed1f2f842b","68d5f927c3af739f25933a6b"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"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.95869827270508,\"lng\":-117.71499633789062,\"latlng\":\"33.958698272705,-117.71499633789\",\"city\":\"Chino Hills\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.16600000 1766563212)","created":"MongoDate(0.16600000 1766563212)"} , 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

Chino Hills

California

Chino Hills Groups and Organizations

Canyon Hills Junior High School

Chaparral Elementary School

Chino Hills Branch Library

Chino Hills Christian School

Chino Hills High School

Chino Hills James S. Thalman Branch Library

Loving Savior Of The Hills Lutheran Church

Rolling Ridge Elementary School

Local Events

Fullerton Certified Community Market

Imaginarium “Land of Oz” at Fairplex in Pomona

Imaginarium “Land of Oz” at Fairplex in Pomona

Imaginarium “Land of Oz” at Fairplex in Pomona

Chris D'Elia

Tim Dillon

Willie Barcena

Chris D'Elia

Tim Dillon

Willie Barcena