Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"san-tan-valley-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"san-tan-valley-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","az","maricopa-county-az","san-tan-valley-az"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"945c9bd456b0d9f26fcd37c4365db222"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
5	db.events_radius_cache.find( {"_id":"6abce67810f0fd493bc165ab117a05e5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"san-tan-valley-az","start":{"$gte":"MongoDate(0.00000000 1767160800)","$lt":"MongoDate(0.00000000 1767765600)"}} )	0	1
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-111.63800048828125,33.22800064086914],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767160800)","$lt":"MongoDate(0.00000000 1768024800)"}} )	0	18
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-111.63800048828125,33.22800064086914],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767160800)","$lt":"MongoDate(0.00000000 1768024800)"}} )	14	18
9	db.events_radius_cache.count( {"_id":"6abce67810f0fd493bc165ab117a05e5"} )	0	1
10	db.events_radius_cache.insert( {"_id":"6abce67810f0fd493bc165ab117a05e5","radius":25,"modified":"MongoDate(0.59800000 1767240583)","created":"MongoDate(0.59800000 1767240583)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767160800)"},"geo":{"$geoWithin":{"$center":[[-111.63800048828125,33.22800064086914],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	44
12	db.events_cache.count( {"_id":"945c9bd456b0d9f26fcd37c4365db222"} )	0	1
13	db.events_cache.count( {"_id":"945c9bd456b0d9f26fcd37c4365db222"} )	0	1
14	db.events_cache.insert( {"_id":"945c9bd456b0d9f26fcd37c4365db222","town_sef_url":"san-tan-valley-az","data_key":["693321074389be6be5655c46","68a75b6e03a70639b6cf662d","68a75b6e03a70639b6cf664f","693321084389be6be5655d68","68a75b6e03a70639b6cf6888","68a75b6e03a70639b6cf68b4","693321084389be6be5655f02","68a75b6e03a70639b6cf6ad6","68a75b6e03a70639b6cf6b6e","68a75b6e03a70639b6cf6b92","68a75b6e03a70639b6cf6c71","68a75b6e03a70639b6cf6d15","68a75b6e03a70639b6cf6dbd","69036aec4389be6be5f64170","693321094389be6be565638d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"San Tan Valley 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\":33.22800064086914,\"lng\":-111.63800048828125,\"latlng\":\"33.228000640869,-111.63800048828\",\"city\":\"San Tan Valley\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.70300000 1767240583)","created":"MongoDate(0.70300000 1767240583)"} , true)	0	1

San Tan Valley

Arizona

San Tan Valley Featured Events

Barrio Bagel & Slice Raises a Glass to the Holidays with Festive New Drinks for the Season NOW AVAILABLE

Exhibition - Gaman: Enduring Japanese American Internment at Gila River

Exhibition - Dry Surf: Local Skateboarding History

Prairie Lights

Beau Jest

All About Broadway - A New Year's Eve Celebration

Bee Gees Gold

Beau Jest

Exhibition - Gaman: Enduring Japanese American Internment at Gila River

Exhibition - Dry Surf: Local Skateboarding History

Desert Hockey Classic (Air Force, Alaska Anchorage, Michigan Tech)

Desert Hockey Classic (Air Force, Alaska Anchorage, Michigan Tech)

Beau Jest

Tribute to the Bee Gees

Ronstadt Revival

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.

San Tan Valley 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.