(mongo) 77 queries took 582 ms
Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"pilot-rock-or"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.ttd_towns.find( {"town_sef_url":"pilot-rock-or","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
3	db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.articles.find( {"aggregate":[{"$geoNear":{"near":[-118.83499908447266,45.48099899291992],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"OR"}}},{"$project":{"title":1,"homepage_title":1,"tags":1,"image_url":1,"distance":1,"page_path":1,"path":1,"article_hostname":1,"text":1,"publish_date":1,"site_canonical":1,"sections.title":1,"sections.geo":1,"sections.text":1}},{"$addFields":{"days_since":{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761786956163)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761786956163)","$publish_date"]},86400000]}]}}},{"$sort":{"relevance_score":1,"_id":1}},{"$skip":0},{"$limit":11}]}, ["article_id","title","homepage_title","tags","image_url","path","article_hostname","sef_tail","page_path","text","publish_date","site_canonical","sections.title","sections.text"] ).sort( {"relevance_score":1,"_id":1} ).limit( 11 ).skip( 0 )	11	63
5	db.ttd_towns.find( {"town_sef_url":"pilot-rock-or","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 )	0	2
6	db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
7	db.events_cache.find( {"_id":"77d0dde9ce14c5f83abe935bbaca76d0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 2 ).skip( 0 )	0	3
9	db.events_cache.count( {"_id":"77d0dde9ce14c5f83abe935bbaca76d0"} )	0	1
10	db.events_cache.insert( {"_id":"77d0dde9ce14c5f83abe935bbaca76d0","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.27000000 1761786956)","created":"MongoDate(0.27000000 1761786956)"} , true)	0	2
11	db.events_cache.find( {"_id":"93dcb8a1ef8a7e5f42c1fb6e34c3a2d0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 2 ).skip( 0 )	0	3
13	db.events_cache.count( {"_id":"93dcb8a1ef8a7e5f42c1fb6e34c3a2d0"} )	0	1
14	db.events_cache.insert( {"_id":"93dcb8a1ef8a7e5f42c1fb6e34c3a2d0","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"10\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.29100000 1761786956)","created":"MongoDate(0.29100000 1761786956)"} , true)	0	2
15	db.events_cache.find( {"_id":"8624e7ce3948ac05fb11e04765f4e87e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
16	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 2 ).skip( 0 )	0	4
17	db.events_cache.count( {"_id":"8624e7ce3948ac05fb11e04765f4e87e"} )	0	2
18	db.events_cache.insert( {"_id":"8624e7ce3948ac05fb11e04765f4e87e","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"30\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.32100000 1761786956)","created":"MongoDate(0.32100000 1761786956)"} , true)	0	2
19	db.events_cache.find( {"_id":"71e15ff60a70aa3bbcdb2636e8b0de83"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
20	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.14492753623188406]}}}, ["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( 2 ).skip( 0 )	0	3
21	db.events_cache.count( {"_id":"71e15ff60a70aa3bbcdb2636e8b0de83"} )	0	2
22	db.events_cache.insert( {"_id":"71e15ff60a70aa3bbcdb2636e8b0de83","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.34600000 1761786956)","created":"MongoDate(0.34600000 1761786956)"} , true)	0	2
23	db.events_cache.find( {"_id":"e370f4c86b364c10cc8d7002afd7a1d6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
24	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 2 ).skip( 0 )	0	4
25	db.events_cache.count( {"_id":"e370f4c86b364c10cc8d7002afd7a1d6"} )	0	1
26	db.events_cache.insert( {"_id":"e370f4c86b364c10cc8d7002afd7a1d6","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.37000000 1761786956)","created":"MongoDate(0.37000000 1761786956)"} , true)	0	2
27	db.events_cache.find( {"_id":"bf9a55c41cce08136b64949de305fca4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
28	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 2 ).skip( 0 )	0	3
29	db.events_cache.count( {"_id":"bf9a55c41cce08136b64949de305fca4"} )	0	3
30	db.events_cache.insert( {"_id":"bf9a55c41cce08136b64949de305fca4","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.39500000 1761786956)","created":"MongoDate(0.39500000 1761786956)"} , true)	0	1
31	db.events_cache.find( {"_id":"b715419835328eac16be55a1176c80da"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	17
32	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.8695652173913043]}}}, ["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( 2 ).skip( 0 )	0	21
33	db.events_cache.count( {"_id":"b715419835328eac16be55a1176c80da"} )	0	2
34	db.events_cache.insert( {"_id":"b715419835328eac16be55a1176c80da","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.47000000 1761786956)","created":"MongoDate(0.47000000 1761786956)"} , true)	0	1
35	db.events_cache.find( {"_id":"ff5ff47c0d18a747be931c922df52b7e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	5
36	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.14492753623188406]}}}, ["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( 2 ).skip( 0 )	0	4
37	db.events_cache.count( {"_id":"ff5ff47c0d18a747be931c922df52b7e"} )	0	1
38	db.events_cache.insert( {"_id":"ff5ff47c0d18a747be931c922df52b7e","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.49700000 1761786956)","created":"MongoDate(0.49700000 1761786956)"} , true)	0	2
39	db.events_cache.find( {"_id":"aa7737d933715efaf9ed7827da7454f6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	24
40	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 2 ).skip( 0 )	0	3
41	db.events_cache.count( {"_id":"aa7737d933715efaf9ed7827da7454f6"} )	0	1
42	db.events_cache.insert( {"_id":"aa7737d933715efaf9ed7827da7454f6","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.54500000 1761786956)","created":"MongoDate(0.54500000 1761786956)"} , true)	0	1
43	db.events_cache.find( {"_id":"d0d9be5927cef0d127b5b296e4f03104"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
44	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.43478260869565216]}}}, ["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( 2 ).skip( 0 )	0	3
45	db.events_cache.count( {"_id":"d0d9be5927cef0d127b5b296e4f03104"} )	0	1
46	db.events_cache.insert( {"_id":"d0d9be5927cef0d127b5b296e4f03104","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"30\",\"days\":\"15\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.56900000 1761786956)","created":"MongoDate(0.56900000 1761786956)"} , true)	0	2
47	db.events_cache.find( {"_id":"966a785ac9e92e876062f316f609e9ab"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
48	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.6521739130434783]}}}, ["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( 2 ).skip( 0 )	0	16
49	db.events_cache.count( {"_id":"966a785ac9e92e876062f316f609e9ab"} )	0	2
50	db.events_cache.insert( {"_id":"966a785ac9e92e876062f316f609e9ab","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"45\",\"days\":\"15\",\"show\":1,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.62100000 1761786956)","created":"MongoDate(0.62100000 1761786956)"} , true)	0	2
51	db.events.find( {"_id":{"$in":[ObjectId ("68278e08fb5e4bed1fc4b472")]}}, [] ).sort( {"start":1} ).limit( 2 ).skip( 0 )	1	2
52	db.events_cache.find( {"_id":"46b7c62ea44467d968c2cf7e8eacd13d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	17
53	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75524373]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],1.4492753623188406]}}}, ["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( 51 ).skip( 0 )	46	48
54	db.events_cache.count( {"_id":"46b7c62ea44467d968c2cf7e8eacd13d"} )	0	2
55	db.events_cache.insert( {"_id":"46b7c62ea44467d968c2cf7e8eacd13d","town_sef_url":"pilot-rock-or","data_key":["68a3f1bffb5e4bed1fd62c48","68a3f1c0fb5e4bed1fd62d86","68a3f1c0fb5e4bed1fd631d5","68a3f1c0fb5e4bed1fd63331","68a3f1c1fb5e4bed1fd635e5","68a3f1c1fb5e4bed1fd637dd","689ffd42fb5e4bed1f9552d8","689ffd42fb5e4bed1f9553a9","68a3f1c1fb5e4bed1fd63beb","68a3f1c2fb5e4bed1fd63c46","687f4f7bfb5e4bed1f73b0ae","68a3f1c2fb5e4bed1fd63df0","68a3f1c2fb5e4bed1fd63ee7","68d74abcc3af739f25e1dcae","68a3f1c2fb5e4bed1fd64227","68a3f1c2fb5e4bed1fd642ef","68a3f1c3fb5e4bed1fd64612","68a3f1c3fb5e4bed1fd646c7","68a3f1c3fb5e4bed1fd64841","68a3f1c4fb5e4bed1fd64aba","68a3f1c4fb5e4bed1fd64b44","68a3f1c4fb5e4bed1fd64c43","68a3f1c4fb5e4bed1fd64c6f","68a3f1c4fb5e4bed1fd64d87","68a3f1c4fb5e4bed1fd65187","68acfb09c3af739f25c89e97","68b0ef89c3af739f25a4e054","68e479a0c3af739f25a9e907","68b4e409c3af739f25278e1c","68b6358ac3af739f259e2cc7","68ba2a0ac3af739f2552e1d0","68be1e85c3af739f25e3d5f6","683eb60afb5e4bed1f457adb","68c8aa84c3af739f25e36767","68d0938cc3af739f252f005c","68e1b706c3af739f2549d519","68e30881c3af739f25769168","68e459fdc3af739f258c57db","68e459fdc3af739f258c5993","68f03780c3af739f25706c7a","68f188ffc3af739f25bbe0a2","68f2da7dc3af739f250d6b79","68f42c00c3af739f258f7a16","68f57d7fc3af739f25039ad1","68f6cefcc3af739f255e655a","6902ac7b3394d74e78f27eb5"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.97700000 1761786956)","created":"MongoDate(0.97700000 1761786956)"} , true)	0	2
56	db.events_cache.find( {"_id":"e2886d7e7eaea640677fb79ced6bf917"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
57	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75524373,75702811]},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],1.4492753623188406]}}}, ["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( 51 ).skip( 0 )	2	47
58	db.events_cache.count( {"_id":"e2886d7e7eaea640677fb79ced6bf917"} )	0	1
59	db.events_cache.insert( {"_id":"e2886d7e7eaea640677fb79ced6bf917","town_sef_url":"pilot-rock-or","data_key":["68c65f64c3af739f25e1e093","68ddc27fc3af739f25a3dfd6"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-118.83499908447266,45.48099899291992],\"has_next_page\":false}","modified":"MongoDate(0.09800000 1761786957)","created":"MongoDate(0.09800000 1761786957)"} , true)	0	2
60	db.places.find( {"geo":{"$near":[-118.83499908447266,45.48099899291992],"$maxDistance":0.14492753623188406},"tags":"arts-and-entertainment"}, [] ).sort( [] ).limit( 51 ).skip( 0 )	0	3
61	db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai Restaurants in Oregon!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/thai-restaurants\/\" target=\"_blank\">Thai Crystal, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">When you take your appetite to Thai Crystal, it’s crystal clear that this Pendleton restaurant is at the top of its game. Indulge in a taste of Thai at this local favorite where you can… <a href=\"https:\/\/bestthingsor.com\/thai-restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-hair-salons-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/hair-salons\/\" target=\"_blank\">10 Best Hair Salons in Oregon<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/hair-salons\/\" target=\"_blank\">The Speakeasy Salon and Spa, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Let loose and have a great time when you book your next hair appointment at The Speakeasy Salon and Spa. This crew of expert stylists and spa professionals will give you the personal attention you… <a href=\"https:\/\/bestthingsor.com\/hair-salons\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-museums-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/museums\/\" target=\"_blank\">The 8 Best Museums in Oregon!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/museums\/\" target=\"_blank\">Tamastslikt Cultural Institute, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\">Opened in 1998, the Tamastslikt Cultural Institute lets you immerse yourself in the history and culture of the people who inhabited this land for more than 10,000 years. Celebrating the traditions of… <a href=\"https:\/\/bestthingsor.com\/museums\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-steakhouse-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/steakhouses\/\" target=\"_blank\">The 10 Best Steakhouses in Oregon!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/steakhouses\/\" target=\"_blank\">Hamley Steakhouse, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Hamley Steakhouse exists on the opposite end of the spectrum from Mackey’s. Hamley also embraces its roots as part of the old west tradition, but is a bit more upscale. Steaks include the prime… <a href=\"https:\/\/bestthingsor.com\/steakhouses\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-pubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/pubs\/\" target=\"_blank\">9 Best Pubs in Oregon!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/pubs\/\" target=\"_blank\">The Prodigal Son, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The Prodigal Son is Pendleton, Oregon’s first craft brewery, bringing the hippest trend in beer to this small agricultural town. They've been recognized as one of the top 10 bars outside of… <a href=\"https:\/\/bestthingsor.com\/pubs\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-buffets-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/buffets\/\" target=\"_blank\">10 Best Buffets in Oregon<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/buffets\/\" target=\"_blank\">Big John\u2019s Hometown Pizza, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Is there anything better than a small town pizza joint? If you’re in the Pendleton area and you want simply fantastic pizza, head to Big John’s Hometown Pizza. For the best experience, go… <a href=\"https:\/\/bestthingsor.com\/buffets\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-omelet-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/omelets\/\" target=\"_blank\">7 Best Omelet Places in Oregon!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/omelets\/\" target=\"_blank\">The Saddle Restaurant and Lounge, Pendleton, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\"><p>Since 1975, The Saddle Restaurant and Lounge has welcome families for breakfast, lunch, and dinner. Breakfast is served all day, and includes fantastic omelet options.<\/p> <a href=\"https:\/\/bestthingsor.com\/omelets\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-smoothies-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/smoothies\/\" target=\"_blank\">9 Best Smoothie Places in Oregon!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/smoothies\/\" target=\"_blank\">S\u016bnn Juice and Decor, Baker City, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Treat yourself to something that’s both healthy and tasty at Baker City’s S\u016bnn Juice and Decor. This friendly neighborhood spot serves up wonderful smoothies and more, and you can browse… <a href=\"https:\/\/bestthingsor.com\/smoothies\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-furniture-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/furniture-stores\/\" target=\"_blank\">10 Best Furniture Stores in Oregon<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/furniture-stores\/\" target=\"_blank\">Courtesy Home Furnishings, Baker City, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Courtesy Home Furnishings is part of the Elegant Interiors family, and “elegant” is surely an apt name for these furniture shops. Courtesy Home Furnishings is the place to go in Baker… <a href=\"https:\/\/bestthingsor.com\/furniture-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/or-diners-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsor.com\/diners\/\" target=\"_blank\">10 Best Diners in Oregon<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsor.com\/diners\/\" target=\"_blank\">Inland Cafe, Baker City, OR<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">The Inland Cafe is Baker City’s top diner. Enjoy breakfast at any time of the day, including gluten-free options, or check out signature dishes like the Malibu chicken sandwich or the Inland… <a href=\"https:\/\/bestthingsor.com\/diners\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n\n\n","town_sef_url":"pilot-rock-or","title":"Hiking!","subtitle":"Maps, directions and reviews for hiking around {local_city_state}!","image_url":"{\"0\":{\"content_type\":\"movie\",\"movie\":\"\/movie\/black-panther-wakanda-forever-297863\/\",\"title\":\"Black Panther: Wakanda Forever\",\"thumbnail\":\"https:\/\/www.movienewsletters.net\/photos\/297863R4.jpg\"},\"1\":{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster","url":"\/{town_sef_url}\/hiking\/","slots":[{"rule":"{\"content_type\":\"event_category\",\"radius\":\"75\",\"days\":\"30\",\"ttl\":\"8\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1761815756,"type":"Event","id":75524373,"title":"Joe Hertler & The Rainbow Seekers","url":"\/event\/joe-hertler-the-rainbow-seekers-2025-11-08-jb-iron-mountain-mi.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2019\/10\/joe-hertler-the-rainbow-seekers-ticketmaster-ram-980x551.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1761801356,"type":"Event","id":75702811,"title":"Luis Angel \"El Flaco\" & Julio Preciado","url":"\/event\/luis-angel-el-flaco-julio-preciado-2026-03-13-tm-kennewick-wa.html","image_url":"https:\/\/s1.ticketm.net\/dam\/e\/0b0\/171be351-ce1c-4326-8d12-e5997fcbc0b0_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1761801356,"type":"Event","id":76157656,"title":"Mannheim Steamroller","url":"\/event\/mannheim-steamroller-2025-11-30-jb-1-kennewick-wa.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2021\/08\/jambase-default-band-image-bw-980x551.png"}],"modified":"MongoDate(0.11200000 1761786957)","created":"MongoDate(0.11200000 1761786957)","_id":ObjectId ("6902bc4d912222169d0f9ad8")} , true)	0	2
62	db.events_cache.find( {"_id":"f7debcb36aea006c24ebd83350b67e02"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
63	db.events_radius_cache.find( {"_id":"b05b21a62583dd611ff5947b8a776e79"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
64	db.events.count( {"address.town_sef_url":"pilot-rock-or","start":{"$gte":"MongoDate(0.00000000 1761714000)","$lt":"MongoDate(0.00000000 1762322400)"}} )	0	3
65	db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1761714000)","$lt":"MongoDate(0.00000000 1762581600)"}} )	0	98
66	db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1761714000)","$lt":"MongoDate(0.00000000 1762581600)"}} )	0	83
67	db.events_radius_cache.count( {"_id":"b05b21a62583dd611ff5947b8a776e79"} )	0	2
68	db.events_radius_cache.insert( {"_id":"b05b21a62583dd611ff5947b8a776e79","radius":25,"modified":"MongoDate(0.33500000 1761786957)","created":"MongoDate(0.33500000 1761786957)"} , true)	0	2
69	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761714000)"},"event_id":{"$nin":[75524373,75702811,76157656]},"geo":{"$geoWithin":{"$center":[[-118.83499908447266,45.48099899291992],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( 6 ).skip( 0 )	0	4
70	db.events_cache.count( {"_id":"f7debcb36aea006c24ebd83350b67e02"} )	0	2
71	db.events_cache.count( {"_id":"f7debcb36aea006c24ebd83350b67e02"} )	0	1
72	db.events_cache.insert( {"_id":"f7debcb36aea006c24ebd83350b67e02","town_sef_url":"pilot-rock-or","data_key":[],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Pilot Rock\",\"keyword\":\"\",\"radius\":25,\"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\":45.48099899291992,\"lng\":-118.83499908447266,\"latlng\":\"45.48099899292,-118.83499908447\",\"city\":\"Pilot Rock\",\"state\":\"OR\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.35900000 1761786957)","created":"MongoDate(0.35900000 1761786957)"} , true)	0	1
73	db.news.find( {"broadcast":{"$in":["usa","pilot-rock-or","or","umatilla-county-or"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 )	6	4
74	db.places.find( {"address.town_sef_url":"pilot-rock-or","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 )	5	4
75	db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 )	0	2
76	db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 )	40	1
77	db.tokens.find( {"sef_url":{"$in":["usa","or","umatilla-county-or","pilot-rock-or"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2

HTTP_HOST: www.devel1.americantowns.com

SERVER_NAME: www.devel1.americantowns.com

Pilot Rock Featured Events

Local News Feed

RESTAURANTS

Organizations around Pilot Rock

Pilot Rock Town Facts

School Closings View our updated school closings list.

Local Schools Find education near you.

Local Groups View all the organizations in your community.

Businesses VFind popular businesses near you.

Jobs Looking to work locally? Try these listings we found.

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.

School Closings
View our updated school closings list.

Local Schools
Find education near you.

Local Groups
View all the organizations in your community.

Businesses
VFind popular businesses near you.

Jobs
Looking to work locally? Try these listings we found.

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