Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"upland-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	23
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
3	db.towns.find( {"sef_url":"huntington-beach-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	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	28
6	db.places.find( {"address.town_sef_url":"huntington-beach-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	9	2
7	db.events_cache.find( {"_id":"a775916bca074db914fb02c7602d9732"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"1291b8293e386c934104240b8e5e3f80"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-118.01300048828125,33.66469955444336],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	75
10	db.events_cache.count( {"_id":"a775916bca074db914fb02c7602d9732"} )	0	1
11	db.events_cache.count( {"_id":"a775916bca074db914fb02c7602d9732"} )	0	1
12	db.events_cache.insert( {"_id":"a775916bca074db914fb02c7602d9732","town_sef_url":"huntington-beach-ca","data_key":["685e5a12fb5e4bed1f6215af","685e5a14fb5e4bed1f6219c9","685e5a18fb5e4bed1f622115","685e5a19fb5e4bed1f6222f9","685e5a1bfb5e4bed1f6225ac","687fca75fb5e4bed1fcbd4eb","69375353de4ae56f5a724aa2","685fab7ffb5e4bed1fb56142","68be3e2ac3af739f25263375","68624e8dfb5e4bed1f2f7094"],"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.66469955444336,\"lng\":-118.01300048828125,\"latlng\":\"33.664699554443,-118.01300048828\",\"city\":\"Huntington Beach\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.49200000 1766532814)","created":"MongoDate(0.49200000 1766532814)"} , true)	0	2
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	14
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
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	4

Huntington Beach

California

Huntington Beach Groups and Organizations

AYUSA Student Exchange

Apollos University

California Child Search

Golden West College

Huntington Beach City School District

Huntington Beach Public Library - Banning Branch

Huntington Beach Public Library - Central Library

Huntington Beach Union High School District

Ocean View School District

Local Events

Seal Beach Village Certified Farmer's Market

Long Beach State Farmers Market

Bixby Park Farmers Market

Downtown Santa Ana Farmers' Market

Surf City Certified Farmers Market

Mariachi Los Camperos

Holiday Dinner Special at Hilton Anaheim’s Poppy’s Restaurant

Drag Show: "Wild Wednesdays" at Mary's Long Beach Location

Drag Show: “Dee-licious Thursday” at Mary’s Long Beach Location

Mile Square Park Certified Farmers Market