Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rincon-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	13
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"indio-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.places.find( {"address.town_sef_url":"indio-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	12	10
7	db.events_cache.find( {"_id":"e9d467182225c0e2547aedb8eeb8cb83"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
8	db.events_radius_cache.find( {"_id":"06ca50f23bb2ed07173ac32ac49b21c7"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
9	db.events.count( {"address.town_sef_url":"indio-ca","start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770616800)"}} )	2	1
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-116.23400115966797,33.724300384521484],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	3	32
11	db.events.count( {"geo":{"$geoWithin":{"$center":[[-116.23400115966797,33.724300384521484],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	5	34
12	db.events_radius_cache.count( {"_id":"06ca50f23bb2ed07173ac32ac49b21c7"} )	0	1
13	db.events_radius_cache.count( {"_id":"06ca50f23bb2ed07173ac32ac49b21c7"} )	0	1
14	db.events_radius_cache.insert( {"_id":"06ca50f23bb2ed07173ac32ac49b21c7","radius":25,"modified":"MongoDate(0.12900000 1770047049)","created":"MongoDate(0.12900000 1770047049)"} , true)	0	3
15	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1770012000)"},"geo":{"$geoWithin":{"$center":[[-116.23400115966797,33.724300384521484],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( 11 ).skip( 0 )	11	8
16	db.events_cache.count( {"_id":"e9d467182225c0e2547aedb8eeb8cb83"} )	0	1
17	db.events_cache.count( {"_id":"e9d467182225c0e2547aedb8eeb8cb83"} )	0	1
18	db.events_cache.insert( {"_id":"e9d467182225c0e2547aedb8eeb8cb83","town_sef_url":"indio-ca","data_key":["69362501de4ae56f5a03215f","6896c2c5fb5e4bed1f1b55ce","6902cc1c3394d74e7810c748","6902cc1c3394d74e7810c787","6902cc1c3394d74e7810c7c3","68d74abec3af739f25e1f173","68d38e65c3af739f25654d99","689c08befb5e4bed1f1f98ef","689c08bffb5e4bed1f1f9cd2","689d5a3ffb5e4bed1f4b0dd3"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"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\":33.724300384521484,\"lng\":-116.23400115966797,\"latlng\":\"33.724300384521,-116.23400115967\",\"city\":\"Indio\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.16800000 1770047049)","created":"MongoDate(0.16800000 1770047049)"} , true)	0	2
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2

Indio

California

Indio Groups and Organizations

Amelia Earhart Elementary School

Andrew Jackson Elementary School

Carrillo Ranch Elementary School

Dr. Reynaldo J. Carreon Junior Academy

Eisenhower Elementary School

Herbert Hoover Elementary School

Indio Branch Library

Indio High School

James Madison Elementary School

John Glenn Middle School

Martin Van Buren Elementary School

Theodore Roosevelt Elementary School

Local Events

Cocktails & Cabaret with Francesca Amari & Jeff Lantz

Piaf! The Show

REPLAY: THE IMPORTANCE OF BEING EARNEST IN NEW YORK

REPLAY: THE IMPORTANCE OF BEING EARNEST IN NEW YORK

REPLAY: THE IMPORTANCE OF BEING EARNEST IN NEW YORK

Ernest

ERNEST

La Quinta Certified Farmers Market

MANIA: The ABBA Tribute

Joss Stone