Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sweet-grass-mt"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"san-juan-capistrano-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	4
6	db.places.find( {"address.town_sef_url":"san-juan-capistrano-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	7	2
7	db.events_cache.find( {"_id":"f6676ad986b1285fa6a6e926fa0591ea"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"26f97f31ba798c54647c7657c9958c62"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766037600)"},"geo":{"$geoWithin":{"$center":[[-117.66200256347656,33.61280059814453],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	243
10	db.events_cache.count( {"_id":"f6676ad986b1285fa6a6e926fa0591ea"} )	0	1
11	db.events_cache.count( {"_id":"f6676ad986b1285fa6a6e926fa0591ea"} )	0	2
12	db.events_cache.insert( {"_id":"f6676ad986b1285fa6a6e926fa0591ea","town_sef_url":"san-juan-capistrano-ca","data_key":["6857c25efb5e4bed1f870113","685913a8fb5e4bed1fd99b41","685913b1fb5e4bed1fd9a86f","685913b6fb5e4bed1fd9afa3","685a65a9fb5e4bed1f658851","685a65b1fb5e4bed1f6597a6","685a65b3fb5e4bed1f659b8e","685a65a3fb5e4bed1f657df0","685a65b3fb5e4bed1f659b11","685bb766fb5e4bed1fb6bdd1"],"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.61280059814453,\"lng\":-117.66200256347656,\"latlng\":\"33.612800598145,-117.66200256348\",\"city\":\"San Juan Capistrano\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.21800000 1766117281)","created":"MongoDate(0.21800000 1766117281)"} , 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	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	5
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

San Juan Capistrano

California

San Juan Capistrano Groups and Organizations

California School of English

Capistrano Adult and Community Education

Capistrano Unified School District

Grace Classical Academy

JSerra Catholic High School

Mission Basilica School

San Juan Capistrano Regional Library

Local Events

Big Jay Oakerson

Laguna Hills Certified Farmers' Market

Big Jay Oakerson

Big Jay Oakerson

Mission Viejo Certified Farmers' Market

Farmers Market on The Ranch

Aliso Viejo Certified Farmers Market

Big Jay Oakerson

Big Jay Oakerson

Ladera Ranch Farmers' Market