| 1 | db.towns.find( {"sef_url":"orono-me"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"south-pasadena-ca"}, [] ).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":"south-pasadena-ca","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 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 | 2 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-118.15699768066406,34.111900329589844],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"CA"}}},{"$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(1769855229472)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769855229472)","$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 | 30 |
| 11 | db.ttd_towns.find( {"town_sef_url":"south-pasadena-ca","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"6d276c3aa7e6b0cd8d3eb4c589f2e311"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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 | 34 |
| 15 | db.events_cache.count( {"_id":"6d276c3aa7e6b0cd8d3eb4c589f2e311"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"6d276c3aa7e6b0cd8d3eb4c589f2e311"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"6d276c3aa7e6b0cd8d3eb4c589f2e311","town_sef_url":"south-pasadena-ca","data_key":["69757e98b1faf7c56a25e9bb"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-118.15699768066406,34.111900329589844],\"has_next_page\":true}","modified":"MongoDate(0.56900000 1769855229)","created":"MongoDate(0.56900000 1769855229)"} , true) | | 0 | 0 | 1 |
| 18 | db.events_cache.find( {"_id":"96d24a220b9a203192b959d9694cb91c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"event_id":{"$nin":[76469075]},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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 | 4 |
| 20 | db.events_cache.count( {"_id":"96d24a220b9a203192b959d9694cb91c"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"96d24a220b9a203192b959d9694cb91c"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"96d24a220b9a203192b959d9694cb91c","town_sef_url":"south-pasadena-ca","data_key":["6922a856de4ae56f5af6a01e"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-118.15699768066406,34.111900329589844],\"has_next_page\":true}","modified":"MongoDate(0.58900000 1769855229)","created":"MongoDate(0.58900000 1769855229)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"790705262d104d5e0e72997296e5e334"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770184799)"},"event_id":{"$nin":[76469075,76367601]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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 | 1 |
| 25 | db.events_cache.count( {"_id":"790705262d104d5e0e72997296e5e334"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"790705262d104d5e0e72997296e5e334"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"790705262d104d5e0e72997296e5e334","town_sef_url":"south-pasadena-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-118.15699768066406,34.111900329589844],\"has_next_page\":false}","modified":"MongoDate(0.60600000 1769855229)","created":"MongoDate(0.60600000 1769855229)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"c9d47e3f34a794465cfc7abc62456705"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1772517599)"},"event_id":{"$nin":[76469075,76367601]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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 | 0 | 1 |
| 30 | db.events_cache.count( {"_id":"c9d47e3f34a794465cfc7abc62456705"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"c9d47e3f34a794465cfc7abc62456705"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"c9d47e3f34a794465cfc7abc62456705","town_sef_url":"south-pasadena-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-118.15699768066406,34.111900329589844],\"has_next_page\":false}","modified":"MongoDate(0.62200000 1769855229)","created":"MongoDate(0.62200000 1769855229)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"2be92bba83a83aaeae623f30caac0282"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770357599)"},"event_id":{"$nin":[76469075,76367601]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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 | 10 |
| 35 | db.events_cache.count( {"_id":"2be92bba83a83aaeae623f30caac0282"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"2be92bba83a83aaeae623f30caac0282"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"2be92bba83a83aaeae623f30caac0282","town_sef_url":"south-pasadena-ca","data_key":["68f6ee9cc3af739f25829ba1"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-118.15699768066406,34.111900329589844],\"has_next_page\":true}","modified":"MongoDate(0.64700000 1769855229)","created":"MongoDate(0.64700000 1769855229)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"7433ab35e89abc55a0cb87ad312556b0"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[76469075,76367601,76258132]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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 | 6 |
| 40 | db.events_cache.count( {"_id":"7433ab35e89abc55a0cb87ad312556b0"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"7433ab35e89abc55a0cb87ad312556b0"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"7433ab35e89abc55a0cb87ad312556b0","town_sef_url":"south-pasadena-ca","data_key":["68911579fb5e4bed1fbe4e2e","694b4e8fde4ae56f5a55a231","690c0699de4ae56f5a9c11c4","68ca1ba4c3af739f25d82223","694b4e8fde4ae56f5a55a237","68e5cb20c3af739f25c785c0","691bd895de4ae56f5a7c0ea9","694b4e8fde4ae56f5a55a23d","6902cc1c3394d74e7810c5aa","69339393de4ae56f5aea2f62","68bf8fa6c3af739f25b38190","695c720ede4ae56f5a66514e","68b7a6abc3af739f2571f79c","68917cc1fb5e4bed1f5901af","6938d995de4ae56f5aaaa1c9","68917cc1fb5e4bed1f59023e","68917cc1fb5e4bed1f5902cf","68ec62a5c3af739f25df9f80","69081219de4ae56f5af7c703","691fcd1ade4ae56f5a67f633","69378813de4ae56f5aecead5","693a2b13de4ae56f5a8b0c73","69509491de4ae56f5a6f4c91","69684f9ab1faf7c56a24a71e","69718d9eb1faf7c56a497d29","6979769db1faf7c56a2a042c","68917cc1fb5e4bed1f59031b","68d89c25c3af739f2531a21e","68bb9b27c3af739f2533ab09","68d4a7a5c3af739f25451cb6","68edb41dc3af739f2514c7fb","68ef05a0c3af739f254c08df","68f84021c3af739f25e005f1","68fc34a1c3af739f25227011","6909639ade4ae56f5a1c0de6","690ab51fde4ae56f5a841809","690d581bde4ae56f5ac125c9","69266495de4ae56f5ae4902f","69363696de4ae56f5a26aebe","69421412de4ae56f5ac6abd7","68917cc1fb5e4bed1f59054b","69017a9cc3af739f25e3ff28","6967019cb1faf7c56a6c9a17","6969a117b1faf7c56adbece5","68917cc1fb5e4bed1f590574","68e08523c3af739f25467ad0","691d2a16de4ae56f5a437c7d","693cce12de4ae56f5ae98358","6961b80eb1faf7c56a229a61","68f991a1c3af739f2535ae31"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-118.15699768066406,34.111900329589844],\"has_next_page\":true}","modified":"MongoDate(0.67300000 1769855229)","created":"MongoDate(0.67300000 1769855229)"} , true) | | 0 | 0 | 1 |
| 43 | 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\/ca-big-food-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/big-food\/\" target=\"_blank\">8 Best Places for BIG Food in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/big-food\/\" target=\"_blank\">Fair Oaks Pharmacy, South Pasadena, CA<\/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\">Fair Oaks Pharmacy is a landmark old-school soda fountain that packs a generous portion into the entire menu. Go beyond the pint of ice cream found in the shakes and malts and head straight for the… <a href=\"https:\/\/bestthingsca.com\/big-food\/\" 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\/ca-burger-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/burgers\/\" target=\"_blank\">10 Best Burgers in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/burgers\/\" target=\"_blank\">Pie N\u2019 Burger, Pasadena, CA<\/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\">Pasadena claims to be the birthplace of the cheeseburger. The spot known for the creation is no longer around, but you can get an approximation at Pie N’ Burger, a local secret that is poorly… <a href=\"https:\/\/bestthingsca.com\/burgers\/\" 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\/ca-furniture-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/furniture-stores\/\" target=\"_blank\">The 10 Best Furniture Stores in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/furniture-stores\/\" target=\"_blank\">Gold Bug, Pasadena, CA<\/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\">Gold Bug in Pasadena isn’t your average antiques mall. The shop if filled with curious finds from days of yore including everything from jewelry to furniture and creative ways to display it.… <a href=\"https:\/\/bestthingsca.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\/ca-antique-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/antique-stores\/\" target=\"_blank\">5 Best Antique Stores in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/antique-stores\/\" target=\"_blank\">Pasadena Antique Mall, Pasadena, CA<\/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 Pasadena Antique Mall is a vast place where you can find everything from crazy paintings to Polaroid cameras. Typewriters, odds and ends, entire dishware collections and bigger pieces fill every… <a href=\"https:\/\/bestthingsca.com\/antique-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\/ca-milkshake-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/milkshakes\/\" target=\"_blank\">8 Best Milkshakes in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/milkshakes\/\" target=\"_blank\">Fair Oaks Pharmacy & Soda Fountain, South Pasadena, CA<\/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\">Fair Oaks Pharmacy & Soda Fountain is an homage to a simpler time with counter seating, a few tables and some of the best milkshakes around, with no less than a pint of the good stuff in each… <a href=\"https:\/\/bestthingsca.com\/milkshakes\/\" 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\/ca-sports-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/sports-bars\/\" target=\"_blank\">The 9 Best Sports Bars in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/sports-bars\/\" target=\"_blank\">T. Boyle\u2019s Tavern, Pasadena, CA<\/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\">T. Boyle’s Tavern is kind of like a hidden gem that everyone knows about. Just off of Colorado Boulevard, T. Boyle’s Tavern has cold beers and the kind of special events that only a… <a href=\"https:\/\/bestthingsca.com\/sports-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\/ca-pubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/pubs\/\" target=\"_blank\">8 Best Pubs in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/pubs\/\" target=\"_blank\">Lucky Baldwins, Pasadena, CA<\/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\">Transformed from a run-down business into a thriving and living pub and haven for English beer lovers, Lucky Baldwin Pubs are conveniently located in Pasadena and Sierra Madre, California. This is a… <a href=\"https:\/\/bestthingsca.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\/ca-museums-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/museums\/\" target=\"_blank\">The 10 Best Museums in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/museums\/\" target=\"_blank\">The Huntington, San Marino, CA<\/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\"><p>The Huntington is a vast estate just outside of Pasadena that features a historic home, art collections, library and vast gardens that are artfully arranged.<\/p> <a href=\"https:\/\/bestthingsca.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\/ca-shopping-outlet-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/shopping-outlets\/\" target=\"_blank\">The 10 Best Shopping Malls and Outlets in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/shopping-outlets\/\" target=\"_blank\">Glendale Galleria, Glendale, CA<\/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\">Located next to the new luxe Americana at Brand, the Glendale Galleria is still worth checking out for an old-school mall experience. The place has been renovated and includes all your favorite mall… <a href=\"https:\/\/bestthingsca.com\/shopping-outlets\/\" 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\/ca-sporting-goods-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/sporting-goods-stores\/\" target=\"_blank\">The 9 Best Sporting Goods Stores in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/sporting-goods-stores\/\" target=\"_blank\">Sportie LA, Los Angeles, CA<\/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\">Sportie LA has everything you need to get in on the athleisure lifestyle, including shoes and apparel. The whole family from the kids on up can find the latest sneaker styles and other sporty… <a href=\"https:\/\/bestthingsca.com\/sporting-goods-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<\/div>\n<\/div>\n\n\n","town_sef_url":"south-pasadena-ca","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":1769858829,"type":"Event","id":76469075,"title":"Los Angeles Dodgers Fanfest","url":"\/event\/los-angeles-dodgers-fanfest-2026-01-31-tm-los-angeles-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/093\/c74cfd95-af21-4e64-9f85-47677b951093_105651_TABLET_LANDSCAPE_LARGE_16_9.jpg"},{"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":1769858829,"type":"Event","id":76367601,"title":"The Album Leaf","url":"\/event\/the-album-leaf-2026-01-31-jb-los-angeles-ca.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2017\/04\/the-album-leaf-the-album-leaf-2312add8-22d5-421c-b0fb-0a6e49fed05f_204811_TABLET_LANDSCAPE_16_9-980x551.jpg"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"10\",\"days\":\"5\",\"ttl\":\"1\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1769858829,"type":"Event","id":76258132,"title":"Cate","url":"\/event\/cate-2026-01-31-tm-los-angeles-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/e\/0a7\/ef21e683-46e0-40e4-a2c0-8b63f25d50a7_SOURCE"},{"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":1769869629,"type":"Event","id":76186655,"title":"An Evening With Black Flag","url":"\/event\/an-evening-with-black-flag-2026-01-31-tm-fontana-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/841\/6b6a4179-2b86-43e2-a823-f4c59b2fb841_SOURCE"}],"modified":"MongoDate(0.67700000 1769855229)","created":"MongoDate(0.67700000 1769855229)","_id":ObjectId ("697dd8fddf8cff024e00c0f4")} , true) | | 0 | 0 | 1 |
| 44 | db.events_cache.find( {"_id":"f11afb24823c0ef32fc99568e5bbf97c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 45 | db.events_radius_cache.find( {"_id":"d186f1037e65c6005d3570ff330ddddb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 46 | db.events.count( {"address.town_sef_url":"south-pasadena-ca","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} ) | | 0 | 0 | 1 |
| 47 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 15 | 16 |
| 48 | db.events_radius_cache.count( {"_id":"d186f1037e65c6005d3570ff330ddddb"} ) | | 0 | 0 | 1 |
| 49 | db.events_radius_cache.count( {"_id":"d186f1037e65c6005d3570ff330ddddb"} ) | | 0 | 0 | 1 |
| 50 | db.events_radius_cache.insert( {"_id":"d186f1037e65c6005d3570ff330ddddb","radius":7,"modified":"MongoDate(0.71300000 1769855229)","created":"MongoDate(0.71300000 1769855229)"} , true) | | 0 | 0 | 1 |
| 51 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"event_id":{"$nin":[76469075,76367601,76258132,76186655]},"geo":{"$geoWithin":{"$center":[[-118.15699768066406,34.111900329589844],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( 6 ).skip( 0 ) | | 0 | 6 | 51 |
| 52 | db.events_cache.count( {"_id":"f11afb24823c0ef32fc99568e5bbf97c"} ) | | 0 | 0 | 1 |
| 53 | db.events_cache.count( {"_id":"f11afb24823c0ef32fc99568e5bbf97c"} ) | | 0 | 0 | 1 |
| 54 | db.events_cache.insert( {"_id":"f11afb24823c0ef32fc99568e5bbf97c","town_sef_url":"south-pasadena-ca","data_key":["68f991a1c3af739f2535ae31","69718d9eb1faf7c56a497e55","690ee1d9de4ae56f5a2912c7","695dc38eb1faf7c56a6c0caf","690c3edade4ae56f5afb9fbb"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around South Pasadena\",\"keyword\":\"\",\"radius\":7,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":34.111900329589844,\"lng\":-118.15699768066406,\"latlng\":\"34.11190032959,-118.15699768066\",\"city\":\"South Pasadena\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.78500000 1769855229)","created":"MongoDate(0.78500000 1769855229)"} , true) | | 0 | 0 | 1 |
| 55 | db.news.find( {"broadcast":{"$in":["usa","south-pasadena-ca","ca","los-angeles-county-ca"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 56 | db.places.find( {"address.town_sef_url":"south-pasadena-ca","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 57 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 58 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 59 | db.towns.find( {"sef_url":"south-pasadena-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 60 | db.tokens.find( {"sef_url":{"$in":["usa","ca","los-angeles-county-ca","south-pasadena-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 61 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 62 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 63 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 64 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 65 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 66 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 67 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
