Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"jacksboro-tn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"joshua-tree-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"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":"joshua-tree-ca","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	3	11
7	db.events_cache.find( {"_id":"edb3d5c20ab0c54dfe55a279511daa8e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
8	db.events_radius_cache.find( {"_id":"e2e3493b8731df0b2a91fa427511c2e3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-116.31500244140625,34.12689971923828],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	231
10	db.events_cache.count( {"_id":"edb3d5c20ab0c54dfe55a279511daa8e"} )	0	1
11	db.events_cache.count( {"_id":"edb3d5c20ab0c54dfe55a279511daa8e"} )	0	1
12	db.events_cache.insert( {"_id":"edb3d5c20ab0c54dfe55a279511daa8e","town_sef_url":"joshua-tree-ca","data_key":["68c194291e2cec194a046566","68a5d7d9c3af739f256e8199","690455d7de4ae56f5a345cce","68cba569c3af739f25f71241","68761544fb5e4bed1f7bae63","685a6596fb5e4bed1f656711","687fca74fb5e4bed1fcbd3c3","68c194291e2cec194a046567","68639fe4fb5e4bed1fa5c5ea","68a6f9a4c3af739f2569d4f1"],"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\":34.12689971923828,\"lng\":-116.31500244140625,\"latlng\":\"34.126899719238,-116.31500244141\",\"city\":\"Joshua Tree\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.10900000 1765722528)","created":"MongoDate(0.10900000 1765722528)"} , true)	0	2
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Joshua Tree

California

Joshua Tree Groups and Organizations

Boston School

Copper Mountain College

Joshua Tree Branch Library

Local Events

Yucca Valley Certified Farmers Market

Young Gun Silver Fox and MT Jones

Karma Dealers and The LEDNECKS

SunSquabi (Under 18 must be accompanied by an adult at all times)

The Dustbowl Revival (Under 18 must be accompanied by an adult)

Joshua Tree Certified Farmers' Market

Jerry's Middle Finger - Under 18 must be accompanied by an adult at all times

Yucca Valley Certified Farmers Market

Joshua Tree Certified Farmers' Market

Big Sandy and His Fly-Rite Boys - Under 18 must be accompanied by an adult at all times