Skip to main content

[From the Fall 2023 Showcase of Homes Magazine]

Written By WENDY HOBDAY HAUGH
Photos by WENDY HOBDAY HAUGH AND MARILYN SARGENT

Constance A. Dodge is a figurative artist, renowned for capturing the fluctuating moods of the Adirondack Mountains and the Sacandaga Valley. Her lakeside home studio in Edinburg, a stone’s throw away from the Batchellerville Bridge, is filled with oil paintings and pastel scenes reflecting the region’s haunting history, rugged residents, and picturesque landscape. 

Dodge always knew she wanted to be an artist. “At age 10,” she recalls with a smile, “when I declared to my grandfather that I wanted to be an artist, he replied, ‘No, you don’t want to do that! There’s no money in that.’” 

Undeterred, Dodge earned a BS in Art Education from Nazareth College, Rochester, and an MFA with distinction in oil painting from Catholic University of America, Washington, D.C. She studied art history for two post-graduate years at SUNY Albany and, later, studied pastel painting with several noted artists. Dodge pursued a teaching career for 31years, 23 of them as the high school art teacher at Schodack Central Schools. At the collegiate level, she taught full-time at Adirondack Community College for several years and part-time at the College of Saint Rose, Empire State College, and Goddard College. 

Welcome to The Dodge House Lakeside Gallery in Edinburg
One of the artist's earlier sculptures
The artist captures the essence of her grandfather
The Edwards' sugar shack, Maple Hill Farm, Edinburg

Like many creatives, Constance Dodge’s artistic journey has been marked by experimentation and innovation, her guiding principle: Never be afraid to change. Dodge’s work is largely figurative today, focused on real-world figures and objects. But much of her earlier, post-MFA work was more abstract in nature. During the turbulent ‘60s, she combined diverse materials, everyday objects, and paints to express her political and social beliefs. “I was drawn to the idea and feel of collage to express my views on the world around me. I was interested in pushing painting to sculpture by combining painting and sculpture in collage or assemblage-like form.”   

In 1969, a two-month art history study tour of Europe, Russia, Hungary, and Austria dramatically fueled Dodge’s artistic vision. “Seeing the great monuments of Europe and the Russian icons, and studying the artists’ use of symbolism, was a very powerful experience,” she explains. “It enriched me both as a teacher and an artist.” 

Inspired by the icons and symbolism she’d observed overseas, Dodge began working from personal photographs of family members, incorporating their images with objects of intrinsic importance to them. “Renaissance and Baroque artists used symbolism to express how volatile we are—how short, truly fleeting our lives are. I began using collage elements in my paintings to create a story for the viewer.” 

Since the 1980s, Dodge has worked extensively with insets: smaller, separate scenes inserted within larger paintings to convey additional detail. These intriguing paintings-within-paintings enable the artist to express a deeper understanding of the person or scene portrayed. For example, one painting shows Dodge’s once-strong mechanic grandfather, with whom she lived for several years, stooped with age, his deeply-etched face reflecting the weight of time. Inset within this painting are nostalgic objects reminiscent of the man, including his beloved Victrola with “Nipper” listening intently to the music.

Fascinated by the interplay of light and shadow, Dodge frequently employs underpainting in her oil and pastel work. In a scene depicting a dinghy, she begins by painting the vessel an eye-popping yellow and, then, successively adds darker layers. Although the dinghy ultimately appears dark in color, an arresting glow shines through, adding great depth to the scene. 

The Dodge House Gallery's lakeside view.

LAKESIDE GARDEN, a pastel painting
Constance Dodge creates Adirondack paintings, archival prints, and notecards

PEACE TIME

Interacting with other artists is vitally important to Dodge. She has been a member of the Guild of Adirondack Artists—an assembly of juried artists from the Southern Adirondack region—and the Oak Room Artists, a juried, by-invitation-only group of 24 artists based in Schenectady. In 1997, Dodge was instrumental in the formation of the Sacandaga Valley Arts Network (SVAN), a group that encourages cultural growth by offering year-round art exhibits and classes, theater presentations, and musical events. 

Constance Dodge has exhibited extensively and garnered numerous grants, awards and honors. For 23 years, she exhibited at the Amos Eno Gallery in NYC, and her work can be found in private and public collections both here and abroad, including the National Museum of Women in the Arts, Washington, D.C., and Artpool in Budapest, Hungary. During the pandemic, Dodge spent 15 months illustrating a children’s book, REGARDS, WALTER. Written by her friend and former Schodack English teacher, Warren Applegate, the book was published in 2022.

Visiting an artist’s home studio/gallery is always an adventure, affording an up-close glimpse of the environment in which much of the artist’s creativity takes place. On a recent visit to THE DODGE HOUSE, Constance’s lakeside gallery, I was impressed by the many shoe-box-to-sofa-sized oil and pastel paintings adorning the home and by the warmth and interest shown me by Dodge and her partner, Marilyn Sargent. 

Sargent pointed out that the entire house is Dodge’s gallery, indicative not only of the artist’s painting prowess but of her visionary architectural sensibilities as well. Dodge, Sargent insists, sees the beauty in everything—even derelict old buildings. In 1987, Dodge purchased her home—then a long-neglected “hellhole,” according to Sargent—for $39,000. Although the home, purportedly, had once been the finest in the community, years of rentals and landlord neglect had rendered the place a nightmare. 

“I thought she should just plow it under, it was so far gone,” Sargent states emphatically, “but Connie insisted the house had ‘good lines.’ When she said that, I grabbed a sledge hammer and drove it into a wall—that’s what I thought of those good lines!” 

After gutting the farmhouse themselves, the women hired contractors to reconfigure the rooms according to Dodge’s detailed vision, restoring its old-time history and charm while, simultaneously, making the space more conducive to its new role as home, art studio, and gallery. This wasn’t Dodge’s first rodeo in the renovation arena. Previously, she’d gutted and restored a four-story townhouse in Albany, with stunning results. But their lakeside home presented the more daunting challenge, and as it evolved into a place of beauty, Sargent was blown away by Dodge’s amazing insight. The home did, indeed, have good lines.  

This fall, as you head out on a leaf-peeping excursion around Great Sacandaga Lake, consider visiting The Dodge House Lakeside Gallery, meeting Constance, and perusing her exquisite scenes of mountains and valleys, Adirondack chairs and rowboats, waterfalls, lakes, and flowers. It’s best to call ahead, but if you happen to be in the area, do stop in. As the artist’s welcoming roadside shingle reads: BY APPOINTMENT . . . OR BY CHANCE. 

The Dodge House, 936 South Shore Rd., Edinburg; 518-863-2201; cdodgeart@gmail.com 

MANDALLA by Constance Dodge
The now-defunct leaning Mechanic St. barn, Galway, NY
THE OLD MAN AND THE SEA, painted on Dodge's grad school paint box
SACANDAGA STORY 1, the flooding of family farms
Plein air painter, Constance Dodge
Artwork by Constance Dodge: Dorothy Edwards, friend to all.
8.063MBMemory Usage112msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.22
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" => "576" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749859152 "last" => 1749859152...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.76KB) (3.17ms)
  • afterInitialise (1.96MB) (25.2ms)
  • afterRoute (375.69KB) (5.01ms)
  • beforeRenderComponent com_content (50.26KB) (905μs)
  • Before Access::preloadComponents (all components) (43.72KB) (1.66ms)
  • After Access::preloadComponents (all components) (119.86KB) (862μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (11μs)
  • After Access::preloadPermissions (com_content) (526.66KB) (1.44ms)
  • Before Access::getAssetRules (id:747 name:com_content.article.576) (18.65KB) (25μs)
  • After Access::getAssetRules (id:747 name:com_content.article.576) (11.38KB) (90μs)
  • afterRenderComponent com_content (1.87MB) (50.14ms)
  • afterDispatch (21.42KB) (1.03ms)
  • beforeRenderRawModule mod_finder () (376.55KB) (8.26ms)
  • afterRenderRawModule mod_finder () (1.77MB) (5.17ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.44KB) (158μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (210μs)
  • afterRenderRawModule mod_menu () (12.58KB) (766μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (120μs)
  • beforeRenderRawModule mod_custom () (920B) (68μs)
  • afterRenderRawModule mod_custom () (319KB) (1.09ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (58μs)
  • beforeRenderRawModule mod_menu () (24B) (86μs)
  • afterRenderRawModule mod_menu () (552B) (369μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (61μs)
  • beforeRenderRawModule mod_custom () (920B) (57μs)
  • afterRenderRawModule mod_custom () (1.03KB) (159μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (63μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (80μs)
  • afterRenderRawModule mod_menu () (4.45KB) (443μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (71μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (6.91KB) (512μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (76μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (150μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (151μs)
  • afterRenderRawModule mod_custom () (1008B) (128μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (46μs)
  • beforeRenderRawModule mod_custom () (472B) (59μs)
  • afterRenderRawModule mod_custom () (1008B) (132μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.43KB) (46μs)
  • afterRender (315.17KB) (3.06ms)
  • 1 x afterRenderComponent com_content (1.87MB) (44.58%)
    50.14ms
    1 x afterInitialise (1.96MB) (22.41%)
    25.20ms
    1 x beforeRenderRawModule mod_finder () (376.55KB) (7.34%)
    8.26ms
    1 x afterRenderRawModule mod_finder () (1.77MB) (4.6%)
    5.17ms
    1 x afterRoute (375.69KB) (4.46%)
    5.01ms
    1 x afterLoad (444.76KB) (2.82%)
    3.17ms
    1 x afterRender (315.17KB) (2.72%)
    3.06ms
    1 x Before Access::preloadComponents (all components) (43.72KB) (1.48%)
    1.66ms
    1 x After Access::preloadPermissions (com_content) (526.66KB) (1.28%)
    1.44ms
    1 x afterRenderRawModule mod_custom () (319KB) (0.97%)
    1.09ms
    1 x afterDispatch (21.42KB) (0.92%)
    1.03ms
    1 x beforeRenderComponent com_content (50.26KB) (0.8%)
    905μs
    1 x After Access::preloadComponents (all components) (119.86KB) (0.77%)
    862μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.68%)
    766μs
    1 x afterRenderRawModule mod_finder () (6.91KB) (0.46%)
    512μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.39%)
    443μs
    1 x afterRenderRawModule mod_menu () (552B) (0.33%)
    369μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.23%)
    260μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.19%)
    210μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.14%)
    159μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.14%)
    158μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.13%)
    151μs
    1 x afterRenderRawModule mod_custom () (912B) (0.13%)
    150μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.11%)
    125μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.11%)
    120μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.11%)
    119μs
    1 x After Access::getAssetRules (id:747 name:com_content.article.576) (11.38KB) (0.08%)
    90μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.08%)
    86μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.07%)
    80μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    76μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    71μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    61μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    59μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    58μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    46μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    46μs
    1 x Before Access::getAssetRules (id:747 name:com_content.article.576) (18.65KB) (0.02%)
    25μs
    5 x beforeRenderModule mod_custom () (704B) (0.02%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    11μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
53 statements were executed, 5 of which were duplicates, 48 unique12.15ms914.27KB
  • SELECT @@SESSION.sql_mode;101μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?209μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 174μ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)209μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`134μ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` = :guest202μ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"168μ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"71μ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"66μ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"59μ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"83μ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"63μ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"99μ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"72μ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"64μ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"60μ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"60μ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"62μ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"63μ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"67μ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"59μ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"64μ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"66μ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"70μ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"60μ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"68μ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"64μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`484μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'114μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1181μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'101μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 194μ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)509μ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` = 0570μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`581μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '576'297μ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)504μs70.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`337μ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)243μ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`269μ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 ASC337μ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.47ms41.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`313μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 119 AND `component_type` = "menu"299μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 576 AND `component_type` = "content"129μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1177μ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)184μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1655μ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 ASC291μ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)131μ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` = 1135μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?75μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?235μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy