Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"van-lear-ky"}, [] ).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":"clayton-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events-next-weekend"]},"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":"146cfc94d0dbf9c3684ef482750a1dd9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"3568f4958144a7e875e974d900a454f5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"clayton-ca","start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-121.93399810791016,37.94129943847656],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	1	32
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-121.93399810791016,37.94129943847656],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766556000)","$lt":"MongoDate(0.00000000 1767420000)"}} )	7	31
11	db.events_radius_cache.count( {"_id":"3568f4958144a7e875e974d900a454f5"} )	0	1
12	db.events_radius_cache.count( {"_id":"3568f4958144a7e875e974d900a454f5"} )	0	1
13	db.events_radius_cache.insert( {"_id":"3568f4958144a7e875e974d900a454f5","radius":25,"modified":"MongoDate(0.99800000 1766562523)","created":"MongoDate(0.99800000 1766562523)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767333600)","$lt":"MongoDate(0.00000000 1767592799)"},"geo":{"$geoWithin":{"$center":[[-121.93399810791016,37.94129943847656],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	12
15	db.events_cache.count( {"_id":"146cfc94d0dbf9c3684ef482750a1dd9"} )	0	1
16	db.events_cache.count( {"_id":"146cfc94d0dbf9c3684ef482750a1dd9"} )	0	1
17	db.events_cache.insert( {"_id":"146cfc94d0dbf9c3684ef482750a1dd9","town_sef_url":"clayton-ca","data_key":["69161081de4ae56f5a997cc2","689eabbefb5e4bed1f7b3830","693a66d5de4ae56f5a168ca8","68c65f66c3af739f25e1ec26","693b7c9fde4ae56f5a5ab496","69161081de4ae56f5a997d16","6876154efb5e4bed1f7bb87c","6933cbd7de4ae56f5a4a6b40","691eb3dade4ae56f5a229145","69391556de4ae56f5a2dc44e","693ba030de4ae56f5aadc5c2","693b7c9fde4ae56f5a5ab54f","69161081de4ae56f5a997d64","689eabbefb5e4bed1f7b38b6","69337ef7de4ae56f5abd3b07"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"next-weekend\",\"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,\"title\":\"{local_city} Events for 1\\\/2\\\/2026 to 1\\\/4\\\/2026\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2026-01-02\",\"searchenddate\":\"2026-01-04\",\"lat\":37.94129943847656,\"lng\":-121.93399810791016,\"latlng\":\"37.941299438477,-121.93399810791\",\"city\":\"Clayton\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.03400000 1766562524)","created":"MongoDate(0.03400000 1766562524)"} , true)	0	1
18	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
19	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
22	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
23	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Clayton

California

Clayton Events for 1/2/2026 to 1/4/2026

"Our Members" Art Show

Cleveland Cavaliers vs. Denver Nuggets

Comedy Oakland at The Lumpia Company Fri Jan 2 7:30pm

Andy McKee

LIFE OF THE PARTY - Oakland First Friday w/ DJ Slappy + DJ Mousetwat + Thow Wow

"Our Members" Art Show

Cleveland Monsters vs. Charlotte Checkers

Delta Wires

Angel Bat Dawid and 9MAGICFOREVER1

Comedy Oakland at Calabash Sat Jan 3rd 8pm

Comedy Oakland at Quinn's Lighthouse Sat Jan 3 9pm

DESMADRE w/ DJ Late Bloomer + Digital Kitkat & PATIO TAKEOVER by Cumbia Maracuya

"Our Members" Art Show

Cleveland Cavaliers vs. Detroit Pistons

Dry January Party for Single Professionals, 40+

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.

Clayton Events for 1/2/2026 to 1/4/2026

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.