Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"langston-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	13
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"san-gabriel-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":"san-gabriel-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	1
7	db.events_cache.find( {"_id":"2918898faf187ab10c203147e4a0c39d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"c51717b953a868593eb4e06f1c9b7e41"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],0.10144927536231885]}}}, ["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	127
10	db.events_cache.count( {"_id":"2918898faf187ab10c203147e4a0c39d"} )	0	1
11	db.events_cache.count( {"_id":"2918898faf187ab10c203147e4a0c39d"} )	0	1
12	db.events_cache.insert( {"_id":"2918898faf187ab10c203147e4a0c39d","town_sef_url":"san-gabriel-ca","data_key":["685a659ffb5e4bed1f657842","68c65f66c3af739f25e1ea1c","685bb75bfb5e4bed1fb6a9a8","685bb75cfb5e4bed1fb6ab78","685e5a11fb5e4bed1f62145f","690c0697de4ae56f5a9c0b12","6903603dde4ae56f5ae90cb1","68639fecfb5e4bed1fa5d746","690c0697de4ae56f5a9c0b64","6903603dde4ae56f5ae90cd8"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":7,\"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.094200134277344,\"lng\":-118.0999984741211,\"latlng\":\"34.094200134277,-118.09999847412\",\"city\":\"San Gabriel\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.48100000 1766231851)","created":"MongoDate(0.48100000 1766231851)"} , 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

San Gabriel

California

San Gabriel Groups and Organizations

Emperor Elementary School

Gabrielino High School

Roosevelt Elementary School

San Gabriel Community Church

San Gabriel Library

San Gabriel Unified School District

Local Events

Pasadena Victory Park Farmers Market

Sorry

Temple City Farmers Market

Alhambra Certified Farmers' Market

Pasadena Villa Parke Farmers Market

Live Racing at Santa Anita Park

Enchant LA Feat. The World’s Largest Christmas Light Maze

Pasadena Victory Park Farmers Market

Live Racing at Santa Anita Park

Enchant LA Feat. The World’s Largest Christmas Light Maze