Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"cedarhurst-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
3	db.towns.find( {"sef_url":"tracy-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":"tracy-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	19	2
7	db.events_cache.find( {"_id":"a4d09162332fac727afb1af748810a95"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"bb0088583143efe7c577cf866f35a8cc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
9	db.events.count( {"address.town_sef_url":"tracy-ca","start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766469600)"}} )	1	1
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-121.24600219726562,37.61970138549805],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	0	29
11	db.events.count( {"geo":{"$geoWithin":{"$center":[[-121.24600219726562,37.61970138549805],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765864800)","$lt":"MongoDate(0.00000000 1766728800)"}} )	1	32
12	db.events_radius_cache.count( {"_id":"bb0088583143efe7c577cf866f35a8cc"} )	0	1
13	db.events_radius_cache.count( {"_id":"bb0088583143efe7c577cf866f35a8cc"} )	0	1
14	db.events_radius_cache.insert( {"_id":"bb0088583143efe7c577cf866f35a8cc","radius":25,"modified":"MongoDate(0.22700000 1765864982)","created":"MongoDate(0.22700000 1765864982)"} , true)	0	1
15	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"geo":{"$geoWithin":{"$center":[[-121.24600219726562,37.61970138549805],0.36231884057971014]}}}, ["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	274
16	db.events_cache.count( {"_id":"a4d09162332fac727afb1af748810a95"} )	0	1
17	db.events_cache.count( {"_id":"a4d09162332fac727afb1af748810a95"} )	0	1
18	db.events_cache.insert( {"_id":"a4d09162332fac727afb1af748810a95","town_sef_url":"tracy-ca","data_key":["68849575fb5e4bed1f7e40c1","69200555de4ae56f5af2c76e","685a658dfb5e4bed1f655831","685a658dfb5e4bed1f65584d","685a6598fb5e4bed1f656aaf","685a6598fb5e4bed1f656b55","685a65b2fb5e4bed1f6598b0","6933cbd7de4ae56f5a4a64b9","685d0873fb5e4bed1f1a077c","6933cbd7de4ae56f5a4a6550"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"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\":37.61970138549805,\"lng\":-121.24600219726562,\"latlng\":\"37.619701385498,-121.24600219727\",\"city\":\"Tracy\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.56300000 1765864982)","created":"MongoDate(0.56300000 1765864982)"} , true)	0	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Tracy

California

Tracy Groups and Organizations

Anthony Traina Elementary School

Art Freiler School

Banta Elementary School District

Central Elementary School

Discovery Charter School

George Kelly Elementary School

Gladys Poet Christian Magnet School

H. A. Clover Middle School

Jefferson School

Jefferson School District

Louis Bohn Elementary School

Monticello Elementary School

Tom Hawkins Elementary School

Tracy Adult School

Tracy Branch Library

Tracy High School

Tracy Unified School District

Villalovoz Panda Pride

Williams Middle School

Local Events

A Charlie Brown Christmas Tour Live On Stage

Stela Cole

Golden Villa Farmers Market

Modesto Certified Farmers Market

Weberstown Farmers' Market

Tracy Farmers' Market

Kaiser Permanente - Stockton Farmer's Market

Time for Three

Kaiser Modesto Farmers Market

Dave Koz