Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"middletown-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.towns.find( {"sef_url":"capshaw-al"}, [] ).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	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":"7f6437070675c31046883519c4fbbf7b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"e0e5e046ef768203307f0ca75aa0bff4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"capshaw-al","start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770271200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-86.7926025390625,34.77299880981445],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	0	29
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-86.7926025390625,34.77299880981445],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	21	21
11	db.events_radius_cache.count( {"_id":"e0e5e046ef768203307f0ca75aa0bff4"} )	0	1
12	db.events_radius_cache.count( {"_id":"e0e5e046ef768203307f0ca75aa0bff4"} )	0	1
13	db.events_radius_cache.insert( {"_id":"e0e5e046ef768203307f0ca75aa0bff4","radius":15,"modified":"MongoDate(0.92200000 1769703646)","created":"MongoDate(0.92200000 1769703646)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"geo":{"$geoWithin":{"$center":[[-86.7926025390625,34.77299880981445],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( 16 ).skip( 0 )	16	104
15	db.events_cache.count( {"_id":"7f6437070675c31046883519c4fbbf7b"} )	0	1
16	db.events_cache.count( {"_id":"7f6437070675c31046883519c4fbbf7b"} )	0	1
17	db.events_cache.insert( {"_id":"7f6437070675c31046883519c4fbbf7b","town_sef_url":"capshaw-al","data_key":["68911579fb5e4bed1fbe47c6","689ffd44fb5e4bed1f956821","691bd895de4ae56f5a7c0e3c","68911579fb5e4bed1fbe4ca5","691bd895de4ae56f5a7c0e72","68917cc1fb5e4bed1f59006b","691bd895de4ae56f5a7c0eb7","689ffd44fb5e4bed1f956879","68917cc1fb5e4bed1f5903bb","691bd895de4ae56f5a7c0ef3","6892ce41fb5e4bed1f90b38e","691bd895de4ae56f5a7c0f34","6892ce41fb5e4bed1f90b5e6","68f6ee9cc3af739f25829cc1","691bd895de4ae56f5a7c0ff8"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Capshaw Featured Events\",\"keyword\":\"\",\"radius\":15,\"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\":34.77299880981445,\"lng\":-86.7926025390625,\"latlng\":\"34.772998809814,-86.792602539062\",\"city\":\"Capshaw\",\"state\":\"AL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.06000000 1769703647)","created":"MongoDate(0.06000000 1769703647)"} , true)	0	1
18	db.towns.find( {"sef_url":"capshaw-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","al","limestone-county-al","capshaw-al"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Capshaw

Alabama

Capshaw Featured Events

The Sound of Music (Touring)

Huntsville Havoc vs. Peoria Riverman

Kountry Wayne

The Sound of Music (Touring)

Kountry Wayne

The Sound of Music (Touring)

Kountry Wayne

Huntsville Havoc vs. Peoria Riverman

The Sound of Music (Touring)

Kountry Wayne

The Sound of Music (Touring)

Kountry Wayne

The Sound of Music (Touring)

An All-Star Salute 90's Country - Honky Tonk Time Machine

Jim Parkers Songwriters Series

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.

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