Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"west-hatfield-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.towns.find( {"sef_url":"tempe-az"}, [] ).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	2
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":"e53752c152e0a32488788a27615a4efc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a089bbf4fd78b32477ec66e14959a081"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766210400)"},"geo":{"$geoWithin":{"$center":[[-111.94000244140625,33.42190170288086],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( 16 ).skip( 0 )	16	89
9	db.events_cache.count( {"_id":"e53752c152e0a32488788a27615a4efc"} )	0	1
10	db.events_cache.count( {"_id":"e53752c152e0a32488788a27615a4efc"} )	0	1
11	db.events_cache.insert( {"_id":"e53752c152e0a32488788a27615a4efc","town_sef_url":"tempe-az","data_key":["69262c53de4ae56f5a5d1f58","6866a8b17573f132502798dc","69262c53de4ae56f5a5d1f5a","693c5703de4ae56f5addb895","69033dc6da3e0489fb067070","68776668fb5e4bed1fb4c9a6","68afbdaec3af739f253698f3","6933cbd6de4ae56f5a4a6374","68f84020c3af739f25dfe89a","68afbdaec3af739f2536992a","68db3f20c3af739f25853e78","69033dc6da3e0489fb067071","68eb111dc3af739f259a4681","6866a8b17573f132502798dd","692641e5de4ae56f5a8a98ab"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Tempe Featured Events\",\"keyword\":\"\",\"radius\":7,\"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.42190170288086,\"lng\":-111.94000244140625,\"latlng\":\"33.421901702881,-111.94000244141\",\"city\":\"Tempe\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.45800000 1766214192)","created":"MongoDate(0.45800000 1766214192)"} , true)	0	1
12	db.towns.find( {"sef_url":"tempe-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","az","maricopa-county-az","tempe-az"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9

Tempe

Arizona

Tempe Featured Events

Crane Dance Gentle Tai chi

Exhibition - Dry Surf: Local Skateboarding History

1-Wall Line Dance

Macayo’s Mexican Food Announces Return of Tamalada Classes for the Holidays DEC. 20

ZooLights at Phoenix Zoo

Shine On Floyd (Pink Floyd Tribute)

Christmas With Reba And Dolly!

Best Intentions – Motown Acts Experience

Sun Devils Men's Basketball v Oregon State

Christmas With Reba And Dolly!

Sun Devil Women's Basketball v Colorado

ZooLights at Phoenix Zoo

The music of Hans Zimmer and Others

Exhibition - Dry Surf: Local Skateboarding History

Gentle Tai Chi Sequences

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.

Tempe 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.