Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"tuscaloosa-al"}, [] ).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":"canyon-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"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.events_cache.find( {"_id":"9aeb15b035516b50c6658eb366987440"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767333600)"},"geo":{"$geoWithin":{"$center":[[-122.18199920654297,37.83449935913086],0.36231884057971014]}}}, ["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( 16 ).skip( 0 )	16	12
8	db.events_cache.count( {"_id":"9aeb15b035516b50c6658eb366987440"} )	0	1
9	db.events_cache.count( {"_id":"9aeb15b035516b50c6658eb366987440"} )	0	5
10	db.events_cache.insert( {"_id":"9aeb15b035516b50c6658eb366987440","town_sef_url":"canyon-ca","data_key":["69161081de4ae56f5a997cc2","686c121a7573f132667120a0","68e6b6dcbe1965690609e4c2","69313e61de4ae56f5a2e6ae7","689eabbefb5e4bed1f7b37e4","68d35625c3af739f25020917","68d4a7a4c3af739f254516db","689eabbefb5e4bed1f7b3830","68e71ca0c3af739f25e59966","6933cbd7de4ae56f5a4a6ab7","693a66d5de4ae56f5a168ca8","68eb495cc3af739f25ce192d","69056f1cde4ae56f5ad83a92","694b8e4ede4ae56f5ad81408","68d4a7a4c3af739f2545172f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Canyon Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"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\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":37.83449935913086,\"lng\":-122.18199920654297,\"latlng\":\"37.834499359131,-122.18199920654\",\"city\":\"Canyon\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.76000000 1767347979)","created":"MongoDate(0.76000000 1767347979)"} , true)	0	1
11	db.towns.find( {"sef_url":"canyon-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.tokens.find( {"sef_url":{"$in":["usa","ca","contra-costa-county-ca","canyon-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	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	2
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

Canyon

California

Canyon Featured Events

"Our Members" Art Show

Exhibition - Gurjeet Singh: When Words Hurt

Exhibition - Catherine Wagner: Blue Reverie

An Evening with a Mentalist: Jay Alexander's Mind Tricks Live

Golden State Warriors vs. Oklahoma City Thunder

Shen Yun

Irene Tu

Cleveland Cavaliers vs. Denver Nuggets

Yannis Pappas

Missing Persons, able machines and more

Comedy Oakland at The Lumpia Company Fri Jan 2 7:30pm

Pacific Mambo Orchestra

Xavier Mortimer: Master of Magic

Comedy Oakland at The Elbo Room Fri Jan 2 8:30pm

Irene Tu

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Canyon Featured Events

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.