Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"southampton-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"chandler-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/comedy-john-datoy-and-paula-kosienski-2026-01-24-midway-ky.html"]},"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":"afe8fd63e209694eebd930f060b3f429"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-111.84100341796875,33.30609893798828],0.07246376811594203]}}}, ["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	111
8	db.events_cache.count( {"_id":"afe8fd63e209694eebd930f060b3f429"} )	0	1
9	db.events_cache.count( {"_id":"afe8fd63e209694eebd930f060b3f429"} )	0	1
10	db.events_cache.insert( {"_id":"afe8fd63e209694eebd930f060b3f429","town_sef_url":"chandler-az","data_key":["686591337573f16d53707f97","686591337573f16d53707f98","686591337573f16d53707f99","68963d06fb5e4bed1f99b479","6868e5b4fb5e4bed1f644dc4","6868e5b5fb5e4bed1f644e7c","686a3733fb5e4bed1fc0159a","686b88c5fb5e4bed1fee51fa","68ed3d0ec3af739f25ae3aba","68963d06fb5e4bed1f99b530","686cda3afb5e4bed1f722613","68ed3d0ec3af739f25ae3aca","68722062fb5e4bed1f26e997","68ed3d0ec3af739f25ae3adb","687371b7fb5e4bed1f4b6b8e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Chandler Featured Events\",\"keyword\":\"\",\"radius\":5,\"limit\":15,\"page\":1,\"sef\":\"comedy-john-datoy-and-paula-kosienski-2026-01-24-midway-ky.html\",\"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.30609893798828,\"lng\":-111.84100341796875,\"latlng\":\"33.306098937988,-111.84100341797\",\"city\":\"Chandler\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.19400000 1766385820)","created":"MongoDate(0.19400000 1766385820)"} , true)	0	1
11	db.towns.find( {"sef_url":"chandler-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.tokens.find( {"sef_url":{"$in":["usa","az","maricopa-county-az","chandler-az"]}}, [] ).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

Chandler

Arizona

Chandler Featured Events

A Christmas Carol

A Christmas Carol

A Christmas Carol

Gilbert Farmers Market

Beau Jest

All About Broadway - A New Year's Eve Celebration

Beau Jest

Beau Jest

Tribute to the Bee Gees

Gilbert Farmers Market

Beau Jest

Tribute to the Bee Gees

Beau Jest

Tribute to the Bee Gees

Beau Jest

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.

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