Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"south-pasadena-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"south-pasadena-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ca","los-angeles-county-ca","south-pasadena-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.places.find( {"address.town_sef_url":"south-pasadena-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	8	129
5	db.events_cache.find( {"_id":"923a5ea6b1eb407109643721bab32b4f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"d186f1037e65c6005d3570ff330ddddb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
7	db.events.count( {"address.town_sef_url":"south-pasadena-ca","start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767592800)"}} )	0	8
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	12	18
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766988000)","$lt":"MongoDate(0.00000000 1767852000)"}} )	99	18
10	db.events_radius_cache.count( {"_id":"d186f1037e65c6005d3570ff330ddddb"} )	0	1
11	db.events_radius_cache.insert( {"_id":"d186f1037e65c6005d3570ff330ddddb","radius":15,"modified":"MongoDate(0.40900000 1767061180)","created":"MongoDate(0.40900000 1767061180)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766988000)"},"geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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	22
13	db.events_cache.count( {"_id":"923a5ea6b1eb407109643721bab32b4f"} )	0	1
14	db.events_cache.count( {"_id":"923a5ea6b1eb407109643721bab32b4f"} )	0	1
15	db.events_cache.insert( {"_id":"923a5ea6b1eb407109643721bab32b4f","town_sef_url":"south-pasadena-ca","data_key":["68a75b6c03a70639b6cf5d74","68a75b6c03a70639b6cf5dca","68a75b6c03a70639b6cf5e12","693321074389be6be56558e1","69036ae94389be6be5f63274","693321074389be6be5655943","69036aea4389be6be5f6331e","693321074389be6be565597b","68a75b6d03a70639b6cf6045","68a75b6d03a70639b6cf60b7"],"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\":34.111900329589844,\"lng\":-118.15699768066406,\"latlng\":\"34.11190032959,-118.15699768066\",\"city\":\"South Pasadena\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.45300000 1767061180)","created":"MongoDate(0.45300000 1767061180)"} , true)	0	1

South Pasadena

California

South Pasadena Groups and Organizations

Arroyo Vista Elementary School

Calvary Preschool

Marengo Elementary School

Monterey Hills Elementary School

South Pasadena High School

South Pasadena Middle School

South Pasadena Public Library

South Pasadena Unified School District

Local Events

South Gate Farmers Market

Exhibition - Zheng Chongbin: Golden State

East Hollywood Certified Farmers Market

Kenneth Whalum

Stereophonic (Touring)

Deon Cole: Does This Work?

Improv Presents: MONDERAYS with Deray Davis & more

Kenneth Whalum

Pasadena Villa Parke Farmers Market

Glendale Gateway Certified Farmer's Market

COVID-19 Resources