| 1 | db.towns.find( {"sef_url":"york-new-salem-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 6 |
| 2 | db.ttd_towns.find( {"town_sef_url":"york-new-salem-pa","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 3 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 4 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-76.78929901123047,39.9015007019043],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"PA"}}},{"$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(1761839407938)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1761839407938)","$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 ) | | 0 | 11 | 223 |
| 5 | db.ttd_towns.find( {"town_sef_url":"york-new-salem-pa","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 3 |
| 6 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 7 | db.events_cache.find( {"_id":"1f05b4fbbdf9dcb7c66d234c6a876b62"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 8 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],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 | 2 | 42 |
| 9 | db.events_cache.count( {"_id":"1f05b4fbbdf9dcb7c66d234c6a876b62"} ) | | 0 | 0 | 2 |
| 10 | db.events_cache.insert( {"_id":"1f05b4fbbdf9dcb7c66d234c6a876b62","town_sef_url":"york-new-salem-pa","data_key":["682c4133fb5e4bed1f5d0b55"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-76.78929901123047,39.9015007019043],\"has_next_page\":true}","modified":"MongoDate(0.28100000 1761839408)","created":"MongoDate(0.28100000 1761839408)"} , true) | | 0 | 0 | 3 |
| 11 | db.events_cache.find( {"_id":"8ef7100ed4b4ac2f38b752c07b7e71e5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 12 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[75312400]},"tags":"music","geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],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 | 2 | 31 |
| 13 | db.events_cache.count( {"_id":"8ef7100ed4b4ac2f38b752c07b7e71e5"} ) | | 0 | 0 | 1 |
| 14 | db.events_cache.insert( {"_id":"8ef7100ed4b4ac2f38b752c07b7e71e5","town_sef_url":"york-new-salem-pa","data_key":["6855cb76fb5e4bed1f76dbd4"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-76.78929901123047,39.9015007019043],\"has_next_page\":true}","modified":"MongoDate(0.36000000 1761839408)","created":"MongoDate(0.36000000 1761839408)"} , true) | | 0 | 0 | 2 |
| 15 | db.events_cache.find( {"_id":"12cbd3a4ab76840c544c0268e120fb69"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 16 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[75312400,75830550]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],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 | 2 | 26 |
| 17 | db.events_cache.count( {"_id":"12cbd3a4ab76840c544c0268e120fb69"} ) | | 0 | 0 | 2 |
| 18 | db.events_cache.insert( {"_id":"12cbd3a4ab76840c544c0268e120fb69","town_sef_url":"york-new-salem-pa","data_key":["68cde71d302db3bbce02ae2b"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-76.78929901123047,39.9015007019043],\"has_next_page\":true}","modified":"MongoDate(0.41300000 1761839408)","created":"MongoDate(0.41300000 1761839408)"} , true) | | 0 | 0 | 2 |
| 19 | db.events_cache.find( {"_id":"bf8b34b0ba33543f1425ff5031ef4515"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 20 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[75312400,75830550,76170035]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],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 ) | | 0 | 51 | 36 |
| 21 | db.events_cache.count( {"_id":"bf8b34b0ba33543f1425ff5031ef4515"} ) | | 0 | 0 | 3 |
| 22 | db.events_cache.insert( {"_id":"bf8b34b0ba33543f1425ff5031ef4515","town_sef_url":"york-new-salem-pa","data_key":["681728edfb5e4bed1f848d25","68512ab2fb5e4bed1fa75c13","681728edfb5e4bed1f848d79","6836cde7fb5e4bed1f74a6a9","6847f064fb5e4bed1f02ac41","684d3679fb5e4bed1f596350","682457fefb5e4bed1ffa173c","68ae6c24c3af739f25a966bc","68c232a1c3af739f256a9aa1","68c8ca1dc3af739f2528e675","681728f3fb5e4bed1f849d12","684941f7fb5e4bed1faad855","688889a4fb5e4bed1f8cbbd8","68c232a1c3af739f256a9ad2","6847f064fb5e4bed1f02ac6f","684a932afb5e4bed1fe173c0","685fab52fb5e4bed1fb525db","6880a0f3fb5e4bed1f94dc6b","688b9b12fb5e4bed1f673cac","6878b7b6fb5e4bed1fd94532","685670b1fb5e4bed1f3ae924","6878b7b7fb5e4bed1fd94546","68c232a1c3af739f256a9ba8","68187a80fb5e4bed1ffaa991","68776634fb5e4bed1fb4780f","6878b7b7fb5e4bed1fd945e7","6880a0f4fb5e4bed1f94dd90","6896c2bffb5e4bed1f1b2bfc","689ffd40fb5e4bed1f953f2f","68b10f24c3af739f25c59eb2","68c8ca1dc3af739f2528e75d","682457fffb5e4bed1ffa18ed","687a0945fb5e4bed1ff14196","6892ce3cfb5e4bed1f908cc9","68187a87fb5e4bed1ffab3f3","6826faf2fb5e4bed1fdd663e","686e2bd1fb5e4bed1fcf6472","68db3f1cc3af739f258517aa","68fc3499c3af739f252237aa","68ae6c24c3af739f25a967fa","68415948fb5e4bed1fba86ac","686f7d3dfb5e4bed1fecfba5","6881f246fb5e4bed1fd3a764","6878b7b8fb5e4bed1fd946ef","68187a8dfb5e4bed1ffabdb8","68c232a1c3af739f256a9e2d","68c4d5a3c3af739f2596bbd9","6819cc2afb5e4bed1f9a5892","68396fcdfb5e4bed1f804454","68761506fb5e4bed1f7b5a4c"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-76.78929901123047,39.9015007019043],\"has_next_page\":true}","modified":"MongoDate(0.49000000 1761839408)","created":"MongoDate(0.49000000 1761839408)"} , true) | | 0 | 0 | 2 |
| 23 | 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\/pa-dessert-spots-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/desserts\/\" target=\"_blank\">The 9 Best Places for Dessert in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/desserts\/\" target=\"_blank\">Janina\u2019s Bakery & Caf\u00e9, York, PA<\/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\">Janina’s Bakery & Café in York, Pennsylvania, is a family-owned establishment with a secret. That secret is pastry chef, Janina Turziak. With a love of baking that spans over 20… <a href=\"https:\/\/bestthingspa.com\/desserts\/\" 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\/pa-thai-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/thai-restaurants\/\" target=\"_blank\">10 Best Thai Restaurants in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/thai-restaurants\/\" target=\"_blank\">District Thai Restaurant, York, PA<\/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\">Feeling creative? District Thai Restaurant is a unique Thai fusion restaurant that blends Thai traditional cuisine with other cuisines and flavors to develop inventive and fun dishes. Try adventurous… <a href=\"https:\/\/bestthingspa.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\/pa-piercing-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/piercing-shops\/\" target=\"_blank\">9 Best Piercing Places in Pennsylvania<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/piercing-shops\/\" target=\"_blank\">York Ink Tattoos and Body Piercing, York, PA<\/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\">If you're looking for one of the best deals in piercing, you've come to the right place. They usually have piercing specials that can help you stretch your budget. But more importantly, they are true… <a href=\"https:\/\/bestthingspa.com\/piercing-shops\/\" 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\/pa-fries-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/fries\/\" target=\"_blank\">The 8 Best French Fries in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/fries\/\" target=\"_blank\">J.R.\u2019s Fresh Cut Fries, York, PA<\/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\">J.R.’s Fresh Cut Fries does serve other food, but their take on the classic potato perfection is so great, it’s worth naming a business after. Fresh cut to order, from fresh potatoes,… <a href=\"https:\/\/bestthingspa.com\/fries\/\" 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\/pa-historic-theaters-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/historic-theaters\/\" target=\"_blank\">The 9 Best Historic Theaters in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/historic-theaters\/\" target=\"_blank\">The Appell Center for the Performing Arts, York, PA<\/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\">Containing two distinct theatres, the Strand and the Capitol, the Appell Center is decidedly different. The Capitol Theatre opened in 1906, primarily as an opera house and dance hall. The Strand… <a href=\"https:\/\/bestthingspa.com\/historic-theaters\/\" 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\/pa-bike-shops-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/bike-shops\/\" target=\"_blank\">7 Best Bike Shops in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/bike-shops\/\" target=\"_blank\">Gung Ho Bikes, York, PA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">The motto at Gung Ho is “just ride,” and a visit to their York location is designed to help you do just that. Whether you like a casual outing with the kids, or you hit the pavement and… <a href=\"https:\/\/bestthingspa.com\/bike-shops\/\" 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\/pa-oyster-places-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/oysters\/\" target=\"_blank\">10 Best Oyster Places in Pennsylvania<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/oysters\/\" target=\"_blank\">Rockfish Public House, York, PA<\/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\">They’re bringing the freshest flavors of the Atlantic and Gulf of Mexico straight to PA. They’re concerned about sustainability and ethical practices, so you can rest assured their… <a href=\"https:\/\/bestthingspa.com\/oysters\/\" 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\/pa-state-parks-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/state-parks\/\" target=\"_blank\">The 10 Best State Parks in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/state-parks\/\" target=\"_blank\">Codorus State Park, Hanover, PA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">In southern York County, Codorus State Park is a popular destination for fans of fishing, picnicking, swimming, and camping. Lake Marburg’s 26 miles of shoreline attracts shorebirds and… <a href=\"https:\/\/bestthingspa.com\/state-parks\/\" 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\/pa-educational-activities-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/educational-activities-for-kids\/\" target=\"_blank\">The 8 Best Educational Activities for Children in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/educational-activities-for-kids\/\" target=\"_blank\">Turkey Hill Experience, Columbia, PA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,community-life-bt,community-life-p300,at-bt-articles-home,at-bt-articles-community<\/div>\n\t\t\t\t<p class=\"small\">Learn about science, animals, and even marketing through the joy of ice cream at the Turkey Hill Experience! Learn about the process behind the sweet treat, milk a mechanical cow, and even brainstorm… <a href=\"https:\/\/bestthingspa.com\/educational-activities-for-kids\/\" 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\/pa-pubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/pubs\/\" target=\"_blank\">10 Best Pubs in Pennsylvania!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingspa.com\/pubs\/\" target=\"_blank\">McCleary\u2019s Public House, Marietta, PA<\/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\">With nightly live music and weekday, late night happy hours, McCleary’s is one of the best times to be had in Marietta. McCleary’s also boasts one of the most beautiful event spaces in… <a href=\"https:\/\/bestthingspa.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<\/div>\n<\/div>\n\n\n","town_sef_url":"york-new-salem-pa","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_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1761843008,"type":"Event","id":75312400,"title":"Rend Collective Folk! Tour","url":"\/event\/rend-collective-folk-tour-2025-11-15-tm-shrewsbury-pa.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/427\/3954f286-1ced-4948-b98b-4847bbcf9427_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1761843008,"type":"Event","id":75830550,"title":"Joanne Shaw Taylor","url":"\/event\/joanne-shaw-taylor-2025-11-03-jb-york-pa.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2015\/06\/joanne-shaw-taylor-profile-980x551.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1761843008,"type":"Event","id":76170035,"title":"717 Vintage Fest","url":"\/event\/717-vintage-fest-2025-11-08-york-pa.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-other-festival-2.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":1761853808,"type":"Event","id":76140852,"title":"Aida w\/ Washington National Opera","url":"\/event\/aida-w-washington-national-opera-2025-10-30-tm-washington-dc.html","image_url":"https:\/\/s1.ticketm.net\/dbimages\/87417a.jpg"}],"modified":"MongoDate(0.49600000 1761839408)","created":"MongoDate(0.49600000 1761839408)","_id":ObjectId ("69038930ed13ffc906083020")} , true) | | 0 | 0 | 2 |
| 24 | db.events_cache.find( {"_id":"cfb4f06027068c95283c2a069a6dc30a"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 25 | db.events_radius_cache.find( {"_id":"e4ee47f9f51901f9cf51e0851d6d3fa7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 26 | db.events.count( {"address.town_sef_url":"york-new-salem-pa","start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762408800)"}} ) | | 0 | 0 | 2 |
| 27 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762668000)"}} ) | | 0 | 14 | 91 |
| 28 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1761800400)","$lt":"MongoDate(0.00000000 1762668000)"}} ) | | 0 | 15 | 86 |
| 29 | db.events_radius_cache.count( {"_id":"e4ee47f9f51901f9cf51e0851d6d3fa7"} ) | | 0 | 0 | 1 |
| 30 | db.events_radius_cache.insert( {"_id":"e4ee47f9f51901f9cf51e0851d6d3fa7","radius":15,"modified":"MongoDate(0.72000000 1761839408)","created":"MongoDate(0.72000000 1761839408)"} , true) | | 0 | 0 | 2 |
| 31 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1761800400)"},"event_id":{"$nin":[75312400,75830550,76170035,76140852]},"geo":{"$geoWithin":{"$center":[[-76.78929901123047,39.9015007019043],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( 6 ).skip( 0 ) | | 0 | 6 | 37 |
| 32 | db.events_cache.count( {"_id":"cfb4f06027068c95283c2a069a6dc30a"} ) | | 0 | 0 | 2 |
| 33 | db.events_cache.count( {"_id":"cfb4f06027068c95283c2a069a6dc30a"} ) | | 0 | 0 | 8 |
| 34 | db.events_cache.insert( {"_id":"cfb4f06027068c95283c2a069a6dc30a","town_sef_url":"york-new-salem-pa","data_key":["681728fffb5e4bed1f84af58","68187a90fb5e4bed1ffac179","68187a91fb5e4bed1ffac1b5","6819cc3dfb5e4bed1f9a7f4f","6819cc5dfb5e4bed1f9abdca"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around York New Salem\",\"keyword\":\"\",\"radius\":15,\"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\":39.9015007019043,\"lng\":-76.78929901123047,\"latlng\":\"39.901500701904,-76.78929901123\",\"city\":\"York New Salem\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.81500000 1761839408)","created":"MongoDate(0.81500000 1761839408)"} , true) | | 0 | 0 | 2 |
| 35 | db.news.find( {"broadcast":{"$in":["usa","york-new-salem-pa","pa","york-county-pa"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 11 |
| 36 | db.places.find( {"address.town_sef_url":"york-new-salem-pa","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 1 | 2 |
| 37 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 2 |
| 38 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 6 |
| 39 | db.tokens.find( {"sef_url":{"$in":["usa","pa","york-county-pa","york-new-salem-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 3 |
