Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"benton-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"campbell-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"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.events_cache.find( {"_id":"0e78b30123a25fc006c1dda9862988e8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"1d9fc484401d7934d6d3fa6b52b94237"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"campbell-ca","start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770271200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-121.95600128173828,37.27909851074219],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769666400)","$lt":"MongoDate(0.00000000 1770530400)"}} )	26	20
10	db.events_radius_cache.count( {"_id":"1d9fc484401d7934d6d3fa6b52b94237"} )	0	1
11	db.events_radius_cache.count( {"_id":"1d9fc484401d7934d6d3fa6b52b94237"} )	0	1
12	db.events_radius_cache.insert( {"_id":"1d9fc484401d7934d6d3fa6b52b94237","radius":7,"modified":"MongoDate(0.47100000 1769741169)","created":"MongoDate(0.47100000 1769741169)"} , true)	0	1
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769666400)"},"geo":{"$geoWithin":{"$center":[[-121.95600128173828,37.27909851074219],0.10144927536231885]}}}, ["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	86
14	db.events_cache.count( {"_id":"0e78b30123a25fc006c1dda9862988e8"} )	0	1
15	db.events_cache.count( {"_id":"0e78b30123a25fc006c1dda9862988e8"} )	0	1
16	db.events_cache.insert( {"_id":"0e78b30123a25fc006c1dda9862988e8","town_sef_url":"campbell-ca","data_key":["695f150db1faf7c56aac1258","68ad1aaac3af739f25f0af47","68c232a7c3af739f256af34f","689ab73ffb5e4bed1fdedd21","68ad1aaac3af739f25f0af62","68c232a7c3af739f256af3b1","69421412de4ae56f5ac6ab7b","68c232a7c3af739f256af3e7","6945ada2de4ae56f5a170694","68ad1aaac3af739f25f0af98","689ab73ffb5e4bed1fdedd67","68c232a7c3af739f256af423","68ad1aaac3af739f25f0afbe","6967019cb1faf7c56a6c9a2d","68c232a7c3af739f256af4a1"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Campbell Featured Events\",\"keyword\":\"\",\"radius\":7,\"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\":37.27909851074219,\"lng\":-121.95600128173828,\"latlng\":\"37.279098510742,-121.95600128174\",\"city\":\"Campbell\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.58200000 1769741169)","created":"MongoDate(0.58200000 1769741169)"} , true)	0	1
17	db.towns.find( {"sef_url":"campbell-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.tokens.find( {"sef_url":{"$in":["usa","ca","santa-clara-county-ca","campbell-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
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	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1

Campbell

California

Campbell Featured Events

Manos De Fierro, DMIZE, Leave No Doubt, Bad World, Opposing Force

The Wiz (Touring)

Martin Amini

San Jose Barracuda vs. Calgary Wranglers

The Wiz (Touring)

Martin Amini

It's A 2000's Party

Martin Amini

The Festival of Undiscovered Grapes

The Wiz (Touring)

San Jose Barracuda vs. Calgary Wranglers

Martin Amini

The Wiz (Touring)

Heated Rivalry Night

Martin Amini

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.

Campbell Featured Events

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.