Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"grand-marais-mn"}, [] ).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":"costa-mesa-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":"costa-mesa-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	13	2
7	db.events_cache.find( {"_id":"98a3a7c61b8669f18b25d225f2108eb4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	12
8	db.events_radius_cache.find( {"_id":"f8f44b8811c2979725bbc77517aff367"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766124000)"},"geo":{"$geoWithin":{"$center":[[-117.91899871826172,33.65250015258789],0.10144927536231885]}}}, ["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	149
10	db.events_cache.count( {"_id":"98a3a7c61b8669f18b25d225f2108eb4"} )	0	1
11	db.events_cache.count( {"_id":"98a3a7c61b8669f18b25d225f2108eb4"} )	0	1
12	db.events_cache.insert( {"_id":"98a3a7c61b8669f18b25d225f2108eb4","town_sef_url":"costa-mesa-ca","data_key":["685913a8fb5e4bed1fd99b57","68a5433dfb5e4bed1febc0d7","68fdbe5fc3af739f2586f5f2","693a2b10de4ae56f5a8aff9b","68957149fb5e4bed1fd76db2","69324210de4ae56f5af02afe","685a65a5fb5e4bed1f65823b","685a65a5fb5e4bed1f658258","68fdbe5fc3af739f2586f63b","6892ce40fb5e4bed1f90ab5a"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":7,\"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.65250015258789,\"lng\":-117.91899871826172,\"latlng\":\"33.652500152588,-117.91899871826\",\"city\":\"Costa Mesa\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.65300000 1766171340)","created":"MongoDate(0.65300000 1766171340)"} , 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

Costa Mesa

California

Costa Mesa Groups and Organizations

CMHS Foundation

Costa Mesa High School

Costa Mesa/Donald Dungan Branch Library

Early College High School

Mesa Verde Branch Library

Newport - Mesa Unified School District

Orange Coast College

Portal Languages

The Orange County Brazilian Portuguese Meetup Group

The Orange County Francophonic Meetup Group

The Orange County German Language Meetup Group

The Orange County Italian Language Meetup group

Vanguard University

Local Events

Mile Square Park Certified Farmers Market

Enjoy & Puzzle

Pacific Symphony

TAN CRESSIDA PRESENTS: 3LW HOLIDAY SHOW

A Rat Pack Christmas with Tony DeSare

Trey Songz

Corona Del Mar Farmers' Market

SoCo Farmers' Market

Pacific Symphony

The Academy Is - Almost Here. 20th Anniversary Tour