Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"saint-rose-la"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.towns.find( {"sef_url":"saint-rose-la"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.tokens.find( {"sef_url":{"$in":["usa","la","saint-charles-county-la","saint-rose-la"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"00b49c0d722f31fea123518e8ba93f16"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767852000)"},"geo":{"$geoWithin":{"$center":[[-90.30729675292969,29.95639991760254],0.14492753623188406]}}}, ["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
6	db.events_cache.count( {"_id":"00b49c0d722f31fea123518e8ba93f16"} )	0	1
7	db.events_cache.insert( {"_id":"00b49c0d722f31fea123518e8ba93f16","town_sef_url":"saint-rose-la","data_key":["69036af14389be6be5f65f94","69036af14389be6be5f65f98","69036af14389be6be5f6621e","69036af14389be6be5f66223","69036af54389be6be5f682cb","69036af64389be6be5f68b38","68a75b7703a70639b6cfacb4","69036b114389be6be5f7455b","69036b124389be6be5f74df1","69036b134389be6be5f75390","69036b164389be6be5f7676d","69036b174389be6be5f76f74","69036b184389be6be5f773db","69036b234389be6be5f7bfd7","69036b234389be6be5f7bfbd"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Saint Rose Featured Events\",\"keyword\":\"\",\"radius\":10,\"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\":29.95639991760254,\"lng\":-90.30729675292969,\"latlng\":\"29.956399917603,-90.30729675293\",\"city\":\"Saint Rose\",\"state\":\"LA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.43200000 1767914104)","created":"MongoDate(0.43200000 1767914104)"} , true)	0	3

Saint Rose

Louisiana

Saint Rose Featured Events

SHEN YUN 2026 in Metairie - 7:30PM Jan 13, 2026

Shen Yun

SHEN YUN 2026 in Metairie - 7:30PM Jan 14, 2026

Shen Yun

The Black Jacket Symphony Presents Pink Floyd's 'The Wall'

Liverpool Legends "The Complete Beatles Experience"

2026 New Orleans Stamp Fest

Disney's Frozen the Musical

Disney's Frozen the Musical

Disney's Frozen the Musical

Disney's Frozen the Musical

Disney's Frozen the Musical

Disney's Frozen the Musical

Swan Lake: International Ballet Stars in Metairie, LA!

Swan Lake by International Ballet Stars

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.

Saint Rose 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.