Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"seven-springs-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"vista-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":"vista-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	13	2
7	db.events_cache.find( {"_id":"ac876e0e705ffcfacb7192c1f7566da3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"5ea478a27e02b3c6fbac56d404f44c23"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-117.24299621582031,33.20159912109375],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	102
10	db.events_cache.count( {"_id":"ac876e0e705ffcfacb7192c1f7566da3"} )	0	1
11	db.events_cache.count( {"_id":"ac876e0e705ffcfacb7192c1f7566da3"} )	0	1
12	db.events_cache.insert( {"_id":"ac876e0e705ffcfacb7192c1f7566da3","town_sef_url":"vista-ca","data_key":["68bf8fa5c3af739f25b373e7","6899dce2b6b14fe14e04deb6","691fcd18de4ae56f5a67e83a","68639fe6fb5e4bed1fa5cadb","68639ff5fb5e4bed1fa5eadb","68639ffefb5e4bed1fa5fb87","68f2047cc3af739f253e3174","68df33a0c3af739f2509ea90","6933cbd7de4ae56f5a4a675e","6864f192fb5e4bed1f3a29e3"],"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.20159912109375,\"lng\":-117.24299621582031,\"latlng\":\"33.201599121094,-117.24299621582\",\"city\":\"Vista\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.62000000 1766529471)","created":"MongoDate(0.62000000 1766529471)"} , 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	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Vista

California

Vista Groups and Organizations

California Child Search

Casita Center for Technology

Faith Lutheran Schools

Guajome Park Academy

Lambs of Faith Lutheran Early Childhood Center

National University Academy

National University Academy of Health Science

Rancho Buena Vista High School

Rancho Buena Vista High School

San Diego County Public Law Library

Stepping Out Preschool and Memorial Christian School

Vista Branch Library

Vista Unified School District

Local Events

Abbey Road Christmas Show

San Marcos Farmers Market

Full Strength

Vista Farmers Market

Fallbrook Main Avenue Farmers and Artisan Market

Cardiff Farmer’s Market

Tantra Speed Date® - San Diego! (Oceanside) Meet Singles Speed Dating

Betamaxx's 80s Holiday After-Party w/ Hot Lava

Betamaxx

Hidden Certified Farmers' Market