Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"la-canada-flintridge-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"la-canada-flintridge-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ca","los-angeles-county-ca","la-canada-flintridge-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"la-canada-flintridge-ca"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"80170e30c0ee97f0d593850db0c89e28"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"215c07887b9ee4e4d4637efe2f5d3186"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"la-canada-flintridge-ca","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	1	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.19999694824219,34.2067985534668],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	9	25
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.19999694824219,34.2067985534668],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	131	26
11	db.events_radius_cache.count( {"_id":"215c07887b9ee4e4d4637efe2f5d3186"} )	0	1
12	db.events_radius_cache.insert( {"_id":"215c07887b9ee4e4d4637efe2f5d3186","radius":15,"modified":"MongoDate(0.89200000 1766817590)","created":"MongoDate(0.89200000 1766817590)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"geo":{"$geoWithin":{"$center":[[-118.19999694824219,34.2067985534668],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	19
14	db.events_cache.count( {"_id":"80170e30c0ee97f0d593850db0c89e28"} )	0	1
15	db.events_cache.count( {"_id":"80170e30c0ee97f0d593850db0c89e28"} )	0	1
16	db.events_cache.insert( {"_id":"80170e30c0ee97f0d593850db0c89e28","town_sef_url":"la-canada-flintridge-ca","data_key":["68a75b6903a70639b6cf4a32","68a75b6903a70639b6cf4bb1","68a75b6a03a70639b6cf4caf","68a75b6a03a70639b6cf4cc0","68a75b6a03a70639b6cf4e98","68a75b6a03a70639b6cf4f40","68a75b6a03a70639b6cf5034","693321064389be6be56550ce","68a75b6a03a70639b6cf5097","68a75b6a03a70639b6cf5188"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"\",\"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\":34.2067985534668,\"lng\":-118.19999694824219,\"latlng\":\"34.206798553467,-118.19999694824\",\"city\":\"La Canada Flintridge\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.93000000 1766817590)","created":"MongoDate(0.93000000 1766817590)"} , true)	0	1

La Canada Flintridge

California

La Canada Flintridge Groups and Organizations

Assistance League Of Flintridge

Boy Scouts of America Troop 501

City of La CaÃ±ada Flintridge

County of Los Angeles Public Library - La Canada Flintridge Library

Crescenta-Canada Family YMCA

Crescenta-CaÃ±ada Family YMCA

Crestview Preparatory School

Descanso Gardens

Dikcson Podley Realtors

Enchanted Forest of Light

Flintridge Sacred Heart Academy

Gelson's Market

Job's Daughters

Kiwanis Club of La Canada

La Canada Flintridge Chamber of Commerce

La Canada Flintridge Farmers Market

La Canada High School

La Canada Skate Park

La CaÃ±ada Presbyterian Church

La CaÃ±ada Unified School District

Local Events

Burbank Certified Farmers' Market

Pasadena Victory Park Farmers Market

La Canada Flintridge Farmers Market

Monrovia Certified Farmers' Market

North Hollywood Farmers Market

Exhibition - Zheng Chongbin: Golden State

Drag Show: “Saturday Drag Brunch” at Hamburger Mary's West Hollywood

Live Racing at Santa Anita Park

Drag Show: “Saturday Drag Brunch” at Hamburger Mary's West Hollywood

Dungeons & Dragons: The Twenty-Sided Tavern

COVID-19 Resources