Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"lakehead-ca"}, [] ).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":"hayward-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":"hayward-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	19	2
7	db.events_cache.find( {"_id":"34b9dd802d2e3934f0e19b7941bc4b4d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"db12612f4476f34df3d8c94b451cfe45"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-122.11000061035156,37.632301330566406],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	81
10	db.events_cache.count( {"_id":"34b9dd802d2e3934f0e19b7941bc4b4d"} )	0	1
11	db.events_cache.count( {"_id":"34b9dd802d2e3934f0e19b7941bc4b4d"} )	0	1
12	db.events_cache.insert( {"_id":"34b9dd802d2e3934f0e19b7941bc4b4d","town_sef_url":"hayward-ca","data_key":["68551f40fb5e4bed1fd10653","6883b1a1fb5e4bed1f8a762e","685e90ab7573f1bc43451385","68551f45fb5e4bed1fd10cad","685670d2fb5e4bed1f3b20b6","685670d6fb5e4bed1f3b2954","68c50de3c3af739f2502eef8","6857c252fb5e4bed1f86ec96","6857c25afb5e4bed1f86fc1a","68f08f60c3af739f25cf27bc"],"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\":37.632301330566406,\"lng\":-122.11000061035156,\"latlng\":\"37.632301330566,-122.11000061035\",\"city\":\"Hayward\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.76400000 1765834576)","created":"MongoDate(0.76400000 1765834576)"} , 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

Hayward

California

Hayward Groups and Organizations

All Saints School

California State University East Bay - Hayward Campus

Chabot College

Colonial Acres Elementary School

East Avenue Elementary School

East Bay Arts College Prep

Eldridge Elementary School

Friends of the Hayward Library

Hayward Adult School

Hayward High School

Hayward Public Library

Hayward Public Library - Weekes Branch

Hayward Unified School District

Life Chiropractic College West

Moreau Catholic High School

Park Elementary School

Park Elementay School

St. Bede Catholic School

St. Joachim School

Local Events

Alameda Farmers Market

Foster City Community Center Farmers Market

Kaiser San Leandro Farmers Market

Fruitvale Farmers Market

Kaiser Union City Farmers' Market

Menlo Park Certified Farmers' Market

Nargiz

Kaiser Fremont Farmers' Market

Fruitvale Farmers Market

Smokey Robinson