Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"marquette-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"claremont-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":"claremont-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	11	1
7	db.events_cache.find( {"_id":"a548e1de8a60de35997f94165ebf0b19"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"ac957f9ccf85479292bcf98b9bf668de"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-117.71600341796875,34.12160110473633],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	140
10	db.events_cache.count( {"_id":"a548e1de8a60de35997f94165ebf0b19"} )	0	1
11	db.events_cache.count( {"_id":"a548e1de8a60de35997f94165ebf0b19"} )	0	1
12	db.events_cache.insert( {"_id":"a548e1de8a60de35997f94165ebf0b19","town_sef_url":"claremont-ca","data_key":["685bb75cfb5e4bed1fb6aba2","68afbdaec3af739f25369932","68d0b32ec3af739f2576113b","69460891de4ae56f5aeccd00","6930dbf2de4ae56f5a80dd02","6930dbf2de4ae56f5a80dd07","6930dbf2de4ae56f5a80dd45","6930dbf2de4ae56f5a80dd4f","68624e91fb5e4bed1f2f76b3","6930dbf2de4ae56f5a80dd75"],"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\":34.12160110473633,\"lng\":-117.71600341796875,\"latlng\":\"34.121601104736,-117.71600341797\",\"city\":\"Claremont\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.05300000 1766359211)","created":"MongoDate(0.05300000 1766359211)"} , 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	11
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

Claremont

California

Claremont Groups and Organizations

Avalon Benefit 50 Mile Run

Claremont Community School of Music

Claremont Graduate University

Claremont High School

Claremont Library

Claremont McKenna College

Claremont Unified School District

Harvey Mudd College

Pitzer College

Pomona College

Scripps College

Local Events

Claremont Farmers And Artisans Market

Ontario Reign vs. San Jose Barracuda

Marlon Wayans

Marlon Wayans

Imaginarium “Land of Oz” at Fairplex in Pomona

Imaginarium “Land of Oz” at Fairplex in Pomona

Imaginarium “Land of Oz” at Fairplex in Pomona

Imaginarium “Land of Oz” at Fairplex in Pomona

Covina Farmers Market

Imaginarium “Land of Oz” at Fairplex in Pomona