Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"canyon-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"canyon-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","ca","contra-costa-county-ca","canyon-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"8e90d7985500a4b0e23138a5d0537925"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"5ce36ad8884e3a1f096144e4b37c9960"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"canyon-ca","start":{"$gte":"MongoDate(0.00000000 1767247200)","$lt":"MongoDate(0.00000000 1767852000)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-122.18199920654297,37.83449935913086],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767247200)","$lt":"MongoDate(0.00000000 1768111200)"}} )	14	18
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-122.18199920654297,37.83449935913086],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767247200)","$lt":"MongoDate(0.00000000 1768111200)"}} )	36	15
9	db.events_radius_cache.count( {"_id":"5ce36ad8884e3a1f096144e4b37c9960"} )	0	1
10	db.events_radius_cache.insert( {"_id":"5ce36ad8884e3a1f096144e4b37c9960","radius":15,"modified":"MongoDate(0.29500000 1767293094)","created":"MongoDate(0.29500000 1767293094)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767247200)"},"geo":{"$geoWithin":{"$center":[[-122.18199920654297,37.83449935913086],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( 16 ).skip( 0 )	16	58
12	db.events_cache.count( {"_id":"8e90d7985500a4b0e23138a5d0537925"} )	0	1
13	db.events_cache.count( {"_id":"8e90d7985500a4b0e23138a5d0537925"} )	0	1
14	db.events_cache.insert( {"_id":"8e90d7985500a4b0e23138a5d0537925","town_sef_url":"canyon-ca","data_key":["68a75b6e03a70639b6cf6d47","68a75b6f03a70639b6cf6ddb","69036aec4389be6be5f64206","69036aec4389be6be5f642bc","68a75b6f03a70639b6cf7055","68a75b6f03a70639b6cf70ed","69036aed4389be6be5f64681","693321094389be6be5656718","69036aed4389be6be5f647cb","68a75b6f03a70639b6cf7302","693321094389be6be56568df","693321094389be6be5656974","68a75b6f03a70639b6cf7445","68a75b7003a70639b6cf746c","693321094389be6be5656a5b"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Canyon Featured Events\",\"keyword\":\"\",\"radius\":15,\"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.39600000 1767293094)","created":"MongoDate(0.39600000 1767293094)"} , true)	0	2

Canyon

California

Canyon Featured Events

Golden State Warriors vs. Oklahoma City Thunder

Cleveland Cavaliers vs. Denver Nuggets

Pacific Mambo Orchestra

Pacific Mambo Orchestra

Cleveland Monsters vs. Charlotte Checkers

Golden State Warriors vs. Utah Jazz

Pacific Mambo Orchestra

Angel Bat Dawid and 9MAGICFOREVER1

Pacific Mambo Orchestra

Cleveland Cavaliers vs. Detroit Pistons

Day26

Day26

Seeds I class: Winter - Disney's Frozen Kids

Cleveland Monsters vs. Charlotte Checkers

Not for Radio - winter in the garden - 1/5

COVID-19 Resources

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

COVID-19 Resources

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.