Skip to main content

Hollywood, History & Glamour Come to Life in Hadley, New York

[From the Fall 2023 Showcase of Homes Magazine]

Written By Theresa St. John  |  Photos by Theresa St. John

The McCarthy Farmhouse sits back from the road, peeking out from the end of a long driveway marked by white fencing and a sign that welcomes guests to The Mountain Airstrip Farm. It’s been recently painted a snappy white with black trim and offers a warm invitation to come inside and sit a while, one I happily accept as I walk up the old stone staircase. At the moment, I only know the property was purchased in 1933 by Joseph McCarthy, a Hall of Fame lyricist and founder of ASCAP, who enjoyed entertaining family and friends from NYC’s Broadway at his sprawling summer home in Hadley, New York. 

I’ve taken a leisurely morning drive from Saratoga to write a story about this fantastic wedding venue (to read more about that and how you can rent the farmhouse and enjoy all it has to offer, please see the 2023 Fall Issue of Saratoga Bride.) When I learned that the famed Florenz Ziegfeld, silent actress Billie Burke, and the dancing Ziegfeld Girls often spent time here, I was intrigued by the home’s history and wanted to know more. 

Son Joseph A McCarthy was also a successful lyricist. He’s the man who penned the words to ‘Ramblin’ Rose’ for Frank Sinatra – one of my all-time favorite singers. Joseph eventually inherited the farm from his father and married the legendary Hollywood silver-screen movie actress Veronica Lake.

A few weeks ago, I went to visit a WWII vet friend of mine. He follows my travels, reads my stories and his eyes lit up when I told him I would be writing this for Simply Saratoga. “Veronica Lake!” he exclaimed. “She was my dream girl when I was a teenager! Her acting was so intense – with her golden tresses over one eye and cherry-red lips – she was hard to resist,” he laughs. “Did you know she was in, I think, 28 movies? They started in 1939 and ended in the 70s. I watched every single one of them – even though it made my wife mad.”    

It’s surreal to imagine what the farmhouse must have been like when people like Marlon Brando, Debbie Reynolds, Perry Como, Nat King Cole, Mickey Rooney, and others stayed and played here. I stand momentarily in front of the long table on the home’s sunny wrap-around porch and notice the engraved name tags in front of each chair. “These are some of the guests who ate here with Veronica and Joseph,” owner Chandler Atkins tells me. I smile, thinking about the conversations that must have happened over dinner. “Even the international chess figure, Bobby Fischer, stayed with the couple for a time.”   

We sit together at a table near the ‘speakeasy’ bar. I’m impressed to learn that it’s been restored, and it’s interesting to wonder who sat and enjoyed a drink there, chatting about this and that with their famous hosts. 

There are several photos of the actress on the walls around me, a print magazine with her face on the cover sits on a side table in the living room, and her penned autobiography is displayed on the dresser in a bedroom named after her, as she’d slept there when residing in the spacious home. When I notice a vase filled with 13 bright red roses, then a stuffed panda bear resting in a big comfy chair in the corner of her room, Chandler tells me he’s been busy picking up things for the house that will somehow honor her life. “Her mother knew how much she loved panda bears and roses,” he says. “After every movie, she’d present Veronica with a bear, 13 roses, and even pennies to celebrate her daughter’s success.” 

Chandler tells me he feels he’s not the owner of the property but the caretaker. He feels his responsibility is to honor the couple and their sometimes-volatile life together. “Joe was her third husband, and they divorced after only four years together.” I can feel their deep love for each other as I wander through each room in the house. Everything Chandler has done to bring the property back to life seems to hum with emotion. 

“Veronica graduated from St. Bernard’s Catholic School in 1938. Later, when she lived here with Joe, people remember her driving through town in her convertible, waving to them.” When I ask why the sign reads ‘Mountain Airstrip Farm,’ Chandler chuckles. “Believe it or not, she was often flown here – eventually, she became a pilot herself and would land on that strip whenever she could take time away from Hollywood. She loved it here.” 

Lake was honest and never sugar-coated her flaws. She suffered from alcoholism and schizophrenia, eventually succumbing to acute renal failure in a Vermont hospital on July 7th, 1973. She was only 50. She was both humble and critical of her talents on and off screen. For a time, after leaving the bright lights of Hollywood, she was a cocktail waitress – a job she states in her autobiography that she genuinely enjoyed. People said she was on a downward spiral and broke – some even sent her money. She never cashed their checks; she was too proud. “I took the job because I like people, I like to talk to them, not because I had nowhere else to turn.” When Marlon Brando sent her a check, she kept it, framing it as a memento of her Hollywood glory days, hanging it in her home to show friends who came to visit.

Although her ashes were scattered over the Atlantic Ocean off New York City by her son Michael so many years ago, you can still feel her larger-than-life presence here in the town of Hadley, in the memories of those who knew her, and on the farm where she found so much solace – the place where she could - be.  

“My hair kept falling over one eye, and I kept brushing it back. I thought I had ruined my chances for the role. But Hornblow was jubilant about that eye-hiding trick. An experienced showman, he knew that the hairstyle was something people would talk about. He had a big picture, and lots of talk would bring people to see it.” 

— Veronica Lake

7.988MBMemory Usage147msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.21
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.42
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "11" "id" => "580" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:74 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749336419 "last" => 1749336419...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (2.52ms)
  • afterInitialise (1.96MB) (23.66ms)
  • afterRoute (375.98KB) (4.53ms)
  • beforeRenderComponent com_content (49.15KB) (803μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.45ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.1ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (16μs)
  • After Access::preloadPermissions (com_content) (514.33KB) (1ms)
  • Before Access::getAssetRules (id:751 name:com_content.article.580) (18.65KB) (27μs)
  • After Access::getAssetRules (id:751 name:com_content.article.580) (7.38KB) (82μs)
  • afterRenderComponent com_content (1.62MB) (90.08ms)
  • afterDispatch (29.42KB) (923μs)
  • beforeRenderRawModule mod_finder () (375.98KB) (8.21ms)
  • afterRenderRawModule mod_finder () (1.95MB) (4.7ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.44KB) (143μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (127μs)
  • afterRenderRawModule mod_menu () (12.64KB) (630μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.69KB) (93μs)
  • beforeRenderRawModule mod_custom () (920B) (63μs)
  • afterRenderRawModule mod_custom () (320.1KB) (957μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (53μs)
  • beforeRenderRawModule mod_menu () (24B) (70μs)
  • afterRenderRawModule mod_menu () (552B) (352μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (58μs)
  • beforeRenderRawModule mod_custom () (920B) (54μs)
  • afterRenderRawModule mod_custom () (1.03KB) (142μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (74μs)
  • afterRenderRawModule mod_menu () (4.45KB) (375μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (64μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (7.28KB) (440μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (69μs)
  • beforeRenderRawModule mod_custom () (288B) (7μs)
  • afterRenderRawModule mod_custom () (912B) (124μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (142μs)
  • afterRenderRawModule mod_custom () (1008B) (120μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.77KB) (44μs)
  • beforeRenderRawModule mod_custom () (472B) (55μs)
  • afterRenderRawModule mod_custom () (1008B) (166μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (44μs)
  • afterRender (314.95KB) (2.47ms)
  • 1 x afterRenderComponent com_content (1.62MB) (61.41%)
    90.08ms
    1 x afterInitialise (1.96MB) (16.13%)
    23.66ms
    1 x beforeRenderRawModule mod_finder () (375.98KB) (5.6%)
    8.21ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (3.2%)
    4.70ms
    1 x afterRoute (375.98KB) (3.09%)
    4.53ms
    1 x afterLoad (444.73KB) (1.72%)
    2.52ms
    1 x afterRender (314.95KB) (1.68%)
    2.47ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (0.99%)
    1.45ms
    1 x After Access::preloadComponents (all components) (116.7KB) (0.75%)
    1.10ms
    1 x After Access::preloadPermissions (com_content) (514.33KB) (0.68%)
    1.00ms
    1 x afterRenderRawModule mod_custom () (320.1KB) (0.65%)
    957μs
    1 x afterDispatch (29.42KB) (0.63%)
    923μs
    1 x beforeRenderComponent com_content (49.15KB) (0.55%)
    803μs
    1 x afterRenderRawModule mod_menu () (12.64KB) (0.43%)
    630μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.3%)
    440μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.26%)
    375μs
    1 x afterRenderRawModule mod_menu () (552B) (0.24%)
    352μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.19%)
    286μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.1%)
    143μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.1%)
    142μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.1%)
    142μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.09%)
    127μs
    1 x afterRenderRawModule mod_custom () (912B) (0.08%)
    124μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.08%)
    117μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.07%)
    109μs
    1 x afterRenderModule mod_menu () (3.69KB) (0.06%)
    93μs
    1 x After Access::getAssetRules (id:751 name:com_content.article.580) (7.38KB) (0.06%)
    82μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.05%)
    74μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.05%)
    70μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.05%)
    69μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.04%)
    64μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.04%)
    58μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.04%)
    55μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.04%)
    53μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    44μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    44μs
    1 x Before Access::getAssetRules (id:751 name:com_content.article.580) (18.65KB) (0.02%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    16μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0%)
    7μs
    1 x beforeRenderRawModule mod_custom () (288B) (0%)
    7μs
53 statements were executed, 5 of which were duplicates, 48 unique11.43ms906.27KB
  • SELECT @@SESSION.sql_mode;100μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?175μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 162μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)279μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`114μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest198μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_k2" AND e.type = "component"141μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_virtuemart" AND e.type = "component"69μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_easyblog" AND e.type = "component"56μs1.13KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jomclassifieds" AND e.type = "component"71μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_hikashop" AND e.type = "component"58μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rseventspro" AND e.type = "component"60μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_zoo" AND e.type = "component"79μs536B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jticketing" AND e.type = "component"63μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_icagenda" AND e.type = "component"59μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eventbooking" AND e.type = "component"57μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eshop" AND e.type = "component"55μs1.76KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rsblog" AND e.type = "component"56μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_mijovideos" AND e.type = "component"59μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_opencart" AND e.type = "component"54μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jcart" AND e.type = "component"58μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_djclassifieds" AND e.type = "component"55μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"56μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_phocacart" AND e.type = "component"56μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jshopping" AND e.type = "component"56μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_igallery" AND e.type = "component"55μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_dpcalendar" AND e.type = "component"54μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`689μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'91μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1148μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'109μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 197μs536B/plugins/system/yooessentials/modules/platform-joomla/src/Database.php:52Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41)426μs9.94KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0509μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`847μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '580'355μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)438μs62.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`301μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)254μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`257μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC335μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `jos_content` AS `a` LEFT JOIN `jos_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC2.15ms41.72KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`324μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 123 AND `component_type` = "menu"234μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 580 AND `component_type` = "content"126μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1154μs592B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)130μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1352μs688.52KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC283μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)115μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1136μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?85μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?231μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy