Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"saint-helena-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"ontario-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/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.events_cache.find( {"_id":"356c48959e4fb43ba5688a93b381181d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"4012625169a9ddeae46b41c3ea158a4f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767938400)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-117.60600280761719,34.05440139770508],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	10
9	db.events_cache.count( {"_id":"356c48959e4fb43ba5688a93b381181d"} )	0	1
10	db.events_cache.count( {"_id":"356c48959e4fb43ba5688a93b381181d"} )	0	1
11	db.events_cache.insert( {"_id":"356c48959e4fb43ba5688a93b381181d","town_sef_url":"ontario-ca","data_key":["691d2a15de4ae56f5a4375e0","691d2a15de4ae56f5a43760f","691d2a15de4ae56f5a437634","691d2a15de4ae56f5a43766f","691d2a15de4ae56f5a4376a7","693b7ca1de4ae56f5a5abe37","6930f092de4ae56f5aa6eca2","693b7ca1de4ae56f5a5abe73","693b7ca1de4ae56f5a5abed6","6930f092de4ae56f5aa6ecf4","693b7ca1de4ae56f5a5abf0e","6930f093de4ae56f5aa6edc7","68f2fa1fc3af739f2533df38","6930f093de4ae56f5aa6ee49","689ffd44fb5e4bed1f9567e6"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Ontario Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":7,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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\":34.05440139770508,\"lng\":-117.60600280761719,\"latlng\":\"34.054401397705,-117.60600280762\",\"city\":\"Ontario\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.85100000 1767944059)","created":"MongoDate(0.85100000 1767944059)"} , true)	0	1
12	db.towns.find( {"sef_url":"ontario-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ca","san-bernardino-county-ca","ontario-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Ontario

California

Ontario Featured Events
Arts And Entertainment

Desi Banks: Your Favorite Cousin Tour

Desi Banks: Your Favorite Cousin Tour

Desi Banks: Your Favorite Cousin Tour

Desi Banks: Your Favorite Cousin Tour

Desi Banks: Your Favorite Cousin Tour

Pablo Francisco

Tom Petty, The Doors, Linda Ronstadt tributes

Pablo Francisco

Pablo Francisco

No Doubt, Sublime, Green Day tributes

Pablo Francisco

Metallica, Iron Maiden, Ozzy Osbourne tributes

Katt Williams: The Golden Age Tour

Depeche Mode, The Cure, Pet Shop Boys Tributes

Gene Pompa

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.

Ontario Featured EventsArts And Entertainment

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.

Ontario Featured Events
Arts And Entertainment

20 million people
rely on AmericanTowns each year to find & share local information.