Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bradford-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
3	db.towns.find( {"sef_url":"broomfield-co"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/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.places.find( {"address.town_sef_url":"broomfield-co","tags":"arts-and-entertainment"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
7	db.events_cache.find( {"_id":"227e094fac8754a5b2d25b632680efad"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"7527c563f47d10b3fd96d16bc93356d9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-105.03700256347656,39.95349884033203],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( 11 ).skip( 0 )	11	138
10	db.events_cache.count( {"_id":"227e094fac8754a5b2d25b632680efad"} )	0	17
11	db.events_cache.count( {"_id":"227e094fac8754a5b2d25b632680efad"} )	0	14
12	db.events_cache.insert( {"_id":"227e094fac8754a5b2d25b632680efad","town_sef_url":"broomfield-co","data_key":["685e5a14fb5e4bed1f621887","685e5a1afb5e4bed1f622419","685fab7afb5e4bed1fb5578a","68851d8c7573f1329179753b","69314874de4ae56f5a3f1849","68624e8efb5e4bed1f2f7148","6930282ede4ae56f5a59e15d","6903603dde4ae56f5ae90cc2","692156d3de4ae56f5a9ca29f","688b9b37fb5e4bed1f676e0d"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":39.95349884033203,\"lng\":-105.03700256347656,\"latlng\":\"39.953498840332,-105.03700256348\",\"city\":\"Broomfield\",\"state\":\"CO\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.46100000 1766520821)","created":"MongoDate(0.46100000 1766520821)"} , true)	0	13
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	21
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	21
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2

Broomfield

Colorado

Broomfield Groups and Organizations

1STBank Center

Artworks Taxidermy

Bees and Blossoms Festival

BrewHaHa Summer Festival

Broomfield Brew Fest

Broomfield Days

Broomfield Plaza Harvest Festival

Butterfly Pavillion

Car Show and Family Fun Fest

Colorado Conservatory of Dance

Dance Arts Studio

Denver Wine Festival

Drink Pink Vino International Rose Wine Festival

Elite Dance Academy

FlashDance Studios

Flatiron Crossing Mall

Grace Studios

GrowThru In Harmony Festival

Holiday Market

International Rose Wine Festival

Local Events

Exhibition - The Honest Eye: Camille Pissarro's Impressionism

Elf in Concert

Exhibition - The Honest Eye: Camille Pissarro's Impressionism

Dance Together-A class for parents and kids on Thursday!

The 5 Points Nutcracker: A Holiday Jazz Experience

Exhibition - The Honest Eye: Camille Pissarro's Impressionism

The 5 Points Nutcracker: A Holiday Jazz Experience

A Christmas Carol

CHUCK, Bobby Guard and more

Armnhmr (18 and Over)