Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"ledgewood-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"avant-ok"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/arts-and-entertainment"]},"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":"c727499afab019fe78055e3ed172d7d3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"20a31aba7a8e5941f894cfbf57df39c8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"avant-ok","start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-96.05960083007812,36.49209976196289],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	0	15
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-96.05960083007812,36.49209976196289],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	0	16
11	db.events_radius_cache.count( {"_id":"20a31aba7a8e5941f894cfbf57df39c8"} )	0	1
12	db.events_radius_cache.count( {"_id":"20a31aba7a8e5941f894cfbf57df39c8"} )	0	1
13	db.events_radius_cache.insert( {"_id":"20a31aba7a8e5941f894cfbf57df39c8","radius":25,"modified":"MongoDate(0.74400000 1767713608)","created":"MongoDate(0.74400000 1767713608)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767679200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-96.05960083007812,36.49209976196289],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	10
15	db.events_cache.count( {"_id":"c727499afab019fe78055e3ed172d7d3"} )	0	1
16	db.events_cache.count( {"_id":"c727499afab019fe78055e3ed172d7d3"} )	0	1
17	db.events_cache.insert( {"_id":"c727499afab019fe78055e3ed172d7d3","town_sef_url":"avant-ok","data_key":["68c0e125c3af739f253dcbfb","68c0e125c3af739f253dcc44","68d4dfe7c3af739f258d95f5","68a5d7dac3af739f256e869b","68f991a1c3af739f2535ac8a","68f991a1c3af739f2535acc5","68f991a1c3af739f2535acd7","68f991a1c3af739f2535ad75","690ea993de4ae56f5ac27343","68f991a1c3af739f2535adba","690ea993de4ae56f5ac27403","68f991a1c3af739f2535ae20","68f991a1c3af739f2535ae38","68f991a1c3af739f2535ae50","6896c2c5fb5e4bed1f1b56e7"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Avant Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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\":36.49209976196289,\"lng\":-96.05960083007812,\"latlng\":\"36.492099761963,-96.059600830078\",\"city\":\"Avant\",\"state\":\"OK\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.78600000 1767713608)","created":"MongoDate(0.78600000 1767713608)"} , true)	0	1
18	db.towns.find( {"sef_url":"avant-ok"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","ok","osage-county-ok","avant-ok"]}}, [] ).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

Avant

Oklahoma

Avant Featured Events
Arts And Entertainment

Hadestown (Touring)

Hadestown (Touring)

Shenandoah

Clay Walker

Disney's Beauty and the Beast (Touring)

Disney's Beauty and the Beast (Touring)

Disney's Beauty and the Beast (Touring)

Disney's Beauty and the Beast (Touring)

Magic Of Motown

Disney's Beauty and the Beast (Touring)

Magic Of Motown

Disney's Beauty and the Beast (Touring)

Disney's Beauty and the Beast (Touring)

Disney's Beauty and the Beast (Touring)

Stardew Valley: Symphony of Seasons

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.

Avant Featured EventsArts And Entertainment

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.

Avant Featured Events
Arts And Entertainment

20 million people
rely on AmericanTowns each year to find & share local information.