| 1 | db.towns.find( {"sef_url":"greendell-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 3 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"colmar-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"colmar-pa","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-75.25430297851562,40.266998291015625],"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(1765702847534)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1765702847534)","$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 | 144 |
| 11 | db.ttd_towns.find( {"town_sef_url":"colmar-pa","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 9 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"270558a4fb058a9b16e69d12aa3427b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766383199)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],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 | 21 |
| 15 | db.events_cache.count( {"_id":"270558a4fb058a9b16e69d12aa3427b1"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"270558a4fb058a9b16e69d12aa3427b1"} ) | | 0 | 0 | 2 |
| 17 | db.events_cache.insert( {"_id":"270558a4fb058a9b16e69d12aa3427b1","town_sef_url":"colmar-pa","data_key":["68527ca2fb5e4bed1f029bf7"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-75.25430297851562,40.266998291015625],\"has_next_page\":true}","modified":"MongoDate(0.77500000 1765702847)","created":"MongoDate(0.77500000 1765702847)"} , true) | | 0 | 0 | 5 |
| 18 | db.events_cache.find( {"_id":"cb3916cdf9d5f9f372c7abf47348fac8"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766383199)"},"event_id":{"$nin":[75561373]},"tags":"music","geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],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 | 11 |
| 20 | db.events_cache.count( {"_id":"cb3916cdf9d5f9f372c7abf47348fac8"} ) | | 0 | 0 | 2 |
| 21 | db.events_cache.count( {"_id":"cb3916cdf9d5f9f372c7abf47348fac8"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"cb3916cdf9d5f9f372c7abf47348fac8","town_sef_url":"colmar-pa","data_key":["68ef3ddcc3af739f2585a876"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-75.25430297851562,40.266998291015625],\"has_next_page\":true}","modified":"MongoDate(0.80900000 1765702847)","created":"MongoDate(0.80900000 1765702847)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"f162abcf317870cffe40032d1f205bd3"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766037599)"},"event_id":{"$nin":[75561373,76239951]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],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 | 0 | 15 |
| 25 | db.events_cache.count( {"_id":"f162abcf317870cffe40032d1f205bd3"} ) | | 0 | 0 | 10 |
| 26 | db.events_cache.count( {"_id":"f162abcf317870cffe40032d1f205bd3"} ) | | 0 | 0 | 10 |
| 27 | db.events_cache.insert( {"_id":"f162abcf317870cffe40032d1f205bd3","town_sef_url":"colmar-pa","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-75.25430297851562,40.266998291015625],\"has_next_page\":false}","modified":"MongoDate(0.89300000 1765702847)","created":"MongoDate(0.89300000 1765702847)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"a3d06fff41bad8fa1270da50732e347e"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1768370399)"},"event_id":{"$nin":[75561373,76239951]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],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 | 2 | 2 |
| 30 | db.events_cache.count( {"_id":"a3d06fff41bad8fa1270da50732e347e"} ) | | 0 | 0 | 11 |
| 31 | db.events_cache.count( {"_id":"a3d06fff41bad8fa1270da50732e347e"} ) | | 0 | 0 | 10 |
| 32 | db.events_cache.insert( {"_id":"a3d06fff41bad8fa1270da50732e347e","town_sef_url":"colmar-pa","data_key":["68f22757315a2fa2aa0b3e37"],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-75.25430297851562,40.266998291015625],\"has_next_page\":true}","modified":"MongoDate(0.96500000 1765702847)","created":"MongoDate(0.96500000 1765702847)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"c343b0648f8f395d1b8f7fd88c25e214"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1767592799)"},"event_id":{"$nin":[75561373,76239951,76252457]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],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 | 5 |
| 35 | db.events_cache.count( {"_id":"c343b0648f8f395d1b8f7fd88c25e214"} ) | | 0 | 0 | 9 |
| 36 | db.events_cache.count( {"_id":"c343b0648f8f395d1b8f7fd88c25e214"} ) | | 0 | 0 | 2 |
| 37 | db.events_cache.insert( {"_id":"c343b0648f8f395d1b8f7fd88c25e214","town_sef_url":"colmar-pa","data_key":["68f1a89dc3af739f25dd690f","68527c8dfb5e4bed1f0278b2","68957149fb5e4bed1fd76afc","68527c8efb5e4bed1f0279ec","68761540fb5e4bed1f7ba75d","69041d9cde4ae56f5ae0e5a4","69129e15de4ae56f5aa3103e","68527c8efb5e4bed1f027a61","6878b7e8fb5e4bed1fd9837d","68527c8ffb5e4bed1f027abc","68527c8ffb5e4bed1f027ad4","68527c8ffb5e4bed1f027ae0","68527c8ffb5e4bed1f027b54","68527c8ffb5e4bed1f027bc7","68527c90fb5e4bed1f027cd7","68527c90fb5e4bed1f027ce6","68527c90fb5e4bed1f027d5b","68776664fb5e4bed1fb4c4be","68c232a5c3af739f256ada9a","68c8ca21c3af739f25290e0b","68c8ca21c3af739f25290e11","68d204a4c3af739f25f51842","6932420fde4ae56f5af028bf","68527c91fb5e4bed1f027e50","68527c91fb5e4bed1f027eda","68ae6c28c3af739f25a9879e","69041d9cde4ae56f5ae0e5b2","68527c91fb5e4bed1f027f67","68527c92fb5e4bed1f027fcd","68527c92fb5e4bed1f028086","68527c93fb5e4bed1f02817e","68527c93fb5e4bed1f0281ca","68527c93fb5e4bed1f0281d8","68527c93fb5e4bed1f0281e4","68527c94fb5e4bed1f028385","68527c94fb5e4bed1f0283a9","68527c95fb5e4bed1f0284bc","68527c95fb5e4bed1f0285dc","6853cdf8fb5e4bed1f55d3c7","68722056fb5e4bed1f26da6d","68761540fb5e4bed1f7ba7b4","68917cbffb5e4bed1f58f55e","689d5a3dfb5e4bed1f4aff58","68a5433dfb5e4bed1febbf50","68d5f926c3af739f259335fe","68e5cb1ec3af739f25c7753d","68e86e1dc3af739f25218816","68f2fa1ec3af739f2533ceea","6913ef94de4ae56f5a16b0b6","69154115de4ae56f5aadf699"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-75.25430297851562,40.266998291015625],\"has_next_page\":true}","modified":"MongoDate(0.00900000 1765702848)","created":"MongoDate(0.00900000 1765702848)"} , true) | | 0 | 0 | 1 |
| 38 | 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-hair-salons-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/hair-salons\/\" target=\"_blank\">10 Best Hair Salons 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\/hair-salons\/\" target=\"_blank\">Rapunzels Salon & Spa, Lansdale, 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\">Since 1987, Rapunzels Salon & Spa has been offering a full range of services to suit every client’s needs. Located in the Philadelphia suburbs, the salon caters to clients in Blue Bell,… <a href=\"https:\/\/bestthingspa.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\/pa-noodle-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\/noodles\/\" target=\"_blank\">9 Best Noodle 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\/noodles\/\" target=\"_blank\">Noodle Eighty Eight, Souderton, 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\">While Noodle Eighty Eight serves up a lot more to Souderton area residents than just noodles, they're what this restaurant does best. No matter what noodle dish you decide on, don't leave without… <a href=\"https:\/\/bestthingspa.com\/noodles\/\" 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-catering-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/caterers\/\" target=\"_blank\">The 8 Best Caterers 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\/caterers\/\" target=\"_blank\">All About Catering, Lansdale, 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\">If you seek a high quality, low maintenance group to work with on your event, search no further than All About Catering. From corporate events to a casual pig roast, All About Catering is a premier… <a href=\"https:\/\/bestthingspa.com\/caterers\/\" 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-bloody-marys-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/bloody-marys\/\" target=\"_blank\">8 Best Places for a Bloody Mary 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\/bloody-marys\/\" target=\"_blank\">The Butcher & Barkeep, Harleysville, 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\">No matter what month it is, you'll find them looking forward to Sunday brunch at The Butcher & Barkeep all year long. Their diverse, seasonal menu is home to a few Southern-inspired dishes, but… <a href=\"https:\/\/bestthingspa.com\/bloody-marys\/\" 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-comedy-clubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/comedy-clubs\/\" target=\"_blank\">9 Best Comedy Spots 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\/comedy-clubs\/\" target=\"_blank\">Comedy Cabaret, Doylestown, PA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\"><p>With a solid roster of seriously funny acts, Comedy Cabaret is one of the best stand-bys in Pennsylvania humor. Catch a show or take a class at this Doylestown locale! <\/p> <a href=\"https:\/\/bestthingspa.com\/comedy-clubs\/\" 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-wedding-locations-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/wedding-locations\/\" target=\"_blank\">The 9 Best Wedding Locations 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\/wedding-locations\/\" target=\"_blank\">The Lake House Inn, Perkasie, 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\">With a breathtaking backdrop of Lake Nockamixon and setting in a historic renovated building that was formerly a general store and post office, one can’t help but feel like this is the ideal… <a href=\"https:\/\/bestthingspa.com\/wedding-locations\/\" 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-kids-playcenter-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/kids-play-centers\/\" target=\"_blank\">9 Best Kids\u2019 Play Centers 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\/kids-play-centers\/\" target=\"_blank\">Jumpin Jacks, Hatfield, 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\">Jumpin Jacks is, as you might have guessed, an inflatable playland that’s fun for children of all ages. (And adults, too, because let’s be honest...who doesn’t love to bounce… <a href=\"https:\/\/bestthingspa.com\/kids-play-centers\/\" 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-dive-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/neighborhood-bars\/\" target=\"_blank\">The 9 Best Neighborhood Bars 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\/neighborhood-bars\/\" target=\"_blank\">Butcher and Barkeep, Harleysville, 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\">Butcher and Barkeep is Harleysville's favorite bar. It's always packed with a diverse crowd, because their extensive beer list, craft cocktails, and delicious bar bites appeal to everyone—from… <a href=\"https:\/\/bestthingspa.com\/neighborhood-bars\/\" 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-holistic-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingspa.com\/holistic-health-food-stores\/\" target=\"_blank\">9 Best Holistic and Health Food Stores 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\/holistic-health-food-stores\/\" target=\"_blank\">Holly Hill Health Foods, North Wales, PA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">In the suburbs of Philadelphia, Holly Hill Health Foods offers an array of vitamins, supplements, health and beauty supplies, grocery items, and health merchandise like salt lamps. In addition to the… <a href=\"https:\/\/bestthingspa.com\/holistic-health-food-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\/pa-french-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\/french-restaurants\/\" target=\"_blank\">5 Best French 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\/french-restaurants\/\" target=\"_blank\">Slate Bleu, Doylestown, PA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-shannen,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Authentically French with a menu that spans the simple to the sublime. Whether you’re looking for an involved meal, or a late night cocktail and small plate, Slate Bleu is a rave-worthy… <a href=\"https:\/\/bestthingspa.com\/french-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<\/div>\n<\/div>\n\n\n","town_sef_url":"colmar-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":1765706447,"type":"Event","id":75561373,"title":"The Temptations & Four Tops - All Ages (under 16 with adult)","url":"\/event\/the-temptations-four-tops-all-ages-under-16-with-adult-2025-12-14-tm-glenside-pa.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/e73\/f038f370-be0d-4dbd-aa29-f5a967b28e73_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":1765706447,"type":"Event","id":76239951,"title":"Anthony Nunziata","url":"\/event\/anthony-nunziata-2025-12-14-jb-sellersville-pa.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2021\/08\/jambase-default-band-image-bw-980x551.png"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1765710047,"type":"Event","id":76252457,"title":"Festival of Lights at Delaware Park Casino","url":"\/event\/festival-of-lights-at-delaware-park-casino-2025-12-19-wilmington-de.html","image_url":"https:\/\/cdn-taco.americantowns.com\/content-img\/lexe-craft-fair-show-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":1765717247,"type":"Event","id":75937924,"title":"The Gazillion Bubble Show","url":"\/event\/the-gazillion-bubble-show-2025-12-14-tm-new-york-ny.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/6f1\/1f9b3d55-c1c0-49f7-a23e-08abfeb3a6f1_SOURCE"}],"modified":"MongoDate(0.01200000 1765702848)","created":"MongoDate(0.01200000 1765702848)","_id":ObjectId ("693e7cc0a1f0db410b01ec7c")} , true) | | 0 | 0 | 1 |
| 39 | db.events_cache.find( {"_id":"95e6774a7e889d80a6425619a44c3634"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 40 | db.events_radius_cache.find( {"_id":"a122af0b1d94d3a7f8180fdf3e849bcc"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 41 | db.events.count( {"address.town_sef_url":"colmar-pa","start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766296800)"}} ) | | 0 | 0 | 1 |
| 42 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} ) | | 0 | 1 | 49 |
| 43 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} ) | | 0 | 20 | 45 |
| 44 | db.events_radius_cache.count( {"_id":"a122af0b1d94d3a7f8180fdf3e849bcc"} ) | | 0 | 0 | 1 |
| 45 | db.events_radius_cache.count( {"_id":"a122af0b1d94d3a7f8180fdf3e849bcc"} ) | | 0 | 0 | 1 |
| 46 | db.events_radius_cache.insert( {"_id":"a122af0b1d94d3a7f8180fdf3e849bcc","radius":15,"modified":"MongoDate(0.13500000 1765702848)","created":"MongoDate(0.13500000 1765702848)"} , true) | | 0 | 0 | 1 |
| 47 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"event_id":{"$nin":[75561373,76239951,76252457,75937924]},"geo":{"$geoWithin":{"$center":[[-75.25430297851562,40.266998291015625],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 | 289 |
| 48 | db.events_cache.count( {"_id":"95e6774a7e889d80a6425619a44c3634"} ) | | 0 | 0 | 1 |
| 49 | db.events_cache.count( {"_id":"95e6774a7e889d80a6425619a44c3634"} ) | | 0 | 0 | 1 |
| 50 | db.events_cache.insert( {"_id":"95e6774a7e889d80a6425619a44c3634","town_sef_url":"colmar-pa","data_key":["68527c9dfb5e4bed1f0291cd","68527ca5fb5e4bed1f02a0c9","68f3325cc3af739f25770ee1","687925aafb5e4bed1f2552ef","6896c2c3fb5e4bed1f1b4bfa"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Colmar\",\"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\":40.266998291015625,\"lng\":-75.25430297851562,\"latlng\":\"40.266998291016,-75.254302978516\",\"city\":\"Colmar\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.48800000 1765702848)","created":"MongoDate(0.48800000 1765702848)"} , true) | | 0 | 0 | 1 |
| 51 | db.news.find( {"broadcast":{"$in":["usa","colmar-pa","pa","montgomery-county-pa"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
| 52 | db.places.find( {"address.town_sef_url":"colmar-pa","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 53 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 54 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 55 | db.towns.find( {"sef_url":"colmar-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 56 | db.tokens.find( {"sef_url":{"$in":["usa","pa","montgomery-county-pa","colmar-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 57 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 58 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 59 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 60 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 61 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 62 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 63 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
