Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"scottsdale-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"scottsdale-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","az","maricopa-county-az","scottsdale-az"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.places.find( {"address.town_sef_url":"scottsdale-az","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	53
6	db.events_cache.find( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"ba7a4b79e14c2a68590f642c885915a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"scottsdale-az","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	13	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-111.89299774169922,33.58140182495117],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	12	27
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-111.89299774169922,33.58140182495117],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	47	28
11	db.events_radius_cache.count( {"_id":"ba7a4b79e14c2a68590f642c885915a1"} )	0	1
12	db.events_radius_cache.insert( {"_id":"ba7a4b79e14c2a68590f642c885915a1","radius":15,"modified":"MongoDate(0.96800000 1766361950)","created":"MongoDate(0.96800000 1766361950)"} , true)	0	2
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-111.89299774169922,33.58140182495117],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	40
14	db.events_cache.count( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8"} )	0	1
15	db.events_cache.count( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8"} )	0	1
16	db.events_cache.insert( {"_id":"6b41d1df0ee6d5279f7f2ad21072f0e8","town_sef_url":"scottsdale-az","data_key":["693321044389be6be5654500","69036ae34389be6be5f6115a","69036ae34389be6be5f61193","69036ae34389be6be5f61285","693321044389be6be565461c","69036ae34389be6be5f60e88","69036ae44389be6be5f613f6","69036ae44389be6be5f61423","693321044389be6be565477c","68a75b6603a70639b6cf364a"],"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\":33.58140182495117,\"lng\":-111.89299774169922,\"latlng\":\"33.581401824951,-111.8929977417\",\"city\":\"Scottsdale\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.04200000 1766361951)","created":"MongoDate(0.04200000 1766361951)"} , true)	0	2

Scottsdale

Arizona

Scottsdale Groups and Organizations

Appaloosa Library

Arabian Library

Arcadia Neighborhood Learning Center

Aztec Elementary School

Camelback Desert School

Cave Creek Unified School District #93

Civic Center Library

Civic Center Library

Cocopah Middle School

Coronado High School

Desert Canyon Elementary School

Evans Newton Incorporated

Evans Newton Incorporated

Laguna Elementary School

Little Sunshine's Playhouse and Preschool of Scottsdale

Mustang Library

Northcentral University

Paradise Valley Community College at Black Mountain

Scottsdale Community College

Sequoya Elementary School

Local Events

City of Scottsdale’s Scottsdazzle Extravaganza features two new events on Sunday, Dec. 21

Sun Devils Men's Basketball v Oregon State

'Tis the Season with Shana Bousard and Brian Runbeck

Christmas With Reba And Dolly!

Miracle Bar

Sun Devil Women's Basketball v Colorado

Mesa Temple Christmas Lights

ZooLights at Phoenix Zoo

The Shadow Self, Opaic and more

LeAnn Rimes

COVID-19 Resources