Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"red-oak-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.towns.find( {"sef_url":"red-oak-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","tx","ellis-county-tx","red-oak-tx"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"a1a5ffacf219933c684b3ba7b71cbe63"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"cefc3db480839ebb13d775bad463cdca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	4
6	db.events.count( {"address.town_sef_url":"red-oak-tx","start":{"$gte":"MongoDate(0.00000000 1767592800)","$lt":"MongoDate(0.00000000 1768197600)"}} )	0	6
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-96.8219985961914,32.51919937133789],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767592800)","$lt":"MongoDate(0.00000000 1768456800)"}} )	0	18
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-96.8219985961914,32.51919937133789],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767592800)","$lt":"MongoDate(0.00000000 1768456800)"}} )	1	30
9	db.events_radius_cache.count( {"_id":"cefc3db480839ebb13d775bad463cdca"} )	0	8
10	db.events_radius_cache.insert( {"_id":"cefc3db480839ebb13d775bad463cdca","radius":25,"modified":"MongoDate(0.04100000 1767657972)","created":"MongoDate(0.04100000 1767657972)"} , true)	0	3
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767592800)"},"geo":{"$geoWithin":{"$center":[[-96.8219985961914,32.51919937133789],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	16
12	db.events_cache.count( {"_id":"a1a5ffacf219933c684b3ba7b71cbe63"} )	0	1
13	db.events_cache.count( {"_id":"a1a5ffacf219933c684b3ba7b71cbe63"} )	0	1
14	db.events_cache.insert( {"_id":"a1a5ffacf219933c684b3ba7b71cbe63","town_sef_url":"red-oak-tx","data_key":["69036aee4389be6be5f64a36","69036aee4389be6be5f64b02","68a75b7003a70639b6cf7651","69036aee4389be6be5f64c31","68a75b7003a70639b6cf7854","69036aee4389be6be5f64e36","68a75b7003a70639b6cf7a60","6933210a4389be6be5656e1e","69036aef4389be6be5f65086","6933210a4389be6be5656f97","68a75b7003a70639b6cf7d1b","69036aef4389be6be5f65300","6933210a4389be6be5657089","6933210a4389be6be56570e1","69036aef4389be6be5f65432"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Red Oak Featured Events\",\"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,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":32.51919937133789,\"lng\":-96.8219985961914,\"latlng\":\"32.519199371338,-96.821998596191\",\"city\":\"Red Oak\",\"state\":\"TX\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.12000000 1767657972)","created":"MongoDate(0.12000000 1767657972)"} , true)	0	1

Red Oak

Texas

Red Oak Featured Events

Tianyu Lights Festival

Tianyu Lights Festival

Kimberly Akimbo (Touring)

Tianyu Lights Festival

Kimberly Akimbo (Touring)

Tianyu Lights Festival

Kimberly Akimbo (Touring)

An Evening At the Improv W/ Dexter Givens Jr.

Tianyu Lights Festival

Josh Abbott

Kimberly Akimbo (Touring)

Dallas Comedy Club Presents: Dan St. Germain

Electronic Orchestra

Tommy Davidson

TIWANA PHILLIPS JOHNSON AND FRIENDS

COVID-19 Resources

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.

Red Oak Featured Events

COVID-19 Resources

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.