Skip to main content
pool at 1953 ranch home remodel

Architecturally Speaking: Wondrous Ranch Redo


Written by MEGIN POTTER
Photos by RANDALL PERRY PHOTOGRAPHY

Downsizing without compromising.

A fabulous remodel transforms this 1953 ranch home into a contemporary, open space with lots of light and an outdoor
area that dials up the drama.

STREAMLINING SENTIMENTALITY

As delightful as it was to be returning to retire in a residential Albany neighborhood remembered from childhood, for a couple who wanted a luxurious, comfortable space requiring minimal maintenance, this formally red single-family home with white shutters left much to be desired.

The Saratoga design firm Sensory Six was tasked with the mission of tailoring the property into a modern high-end masterpiece.

“It is rare in the Capital Region to find residential clients that truly have a contemporary design style, so it was fun to work with them.

I love working with the design aesthetic of clean lines, contemporary lighting and modern eclectic artwork. This was also a renovation in which the interior was gutted, and the exterior completely overhauled. So, in many ways, it was like starting from scratch (although renovations have their own challenges versus a new build). We love a good challenge and developing solutions to make something work,” said Sensory Six Founder and President Sandra Fox.

THE FUTURE IS NOW

To introduce the exterior of this home to the future, the roof was replaced, coordinating siding, stone and custom-designed entry doors and garage doors were added.

Working within a white, black and gray color palette, more substantial front columns, distinctive double-doors, glass panes and recessed soffit lights come together to form a statement-making entranceway.

There’s no sign now of the low ceilings and closed-off rooms that once sectioned-off this home’s dated interior.

PASSION PROJECT

It seems as if almost every inch of this home’s 2,800 square feet has been completely redone. This already huge renovation took longer than expected because the team lost their contractor part-way through. With their passion for the project undeterred, the owners and Sensory Six took over the job of general contracting together.

“This challenge did not change the final product because it was a labor of love, and we were all passionate about detail and quality,” said Fox.


REACHING GREAT HEIGHTS

To change the feel of the house and open everything up, modifying the ceilings became a key component of the renovations. Vaulted ceilings in the great room make the house feel larger, provide beautiful sight-lines and give it that “wow” factor. Here, the eye is instantly drawn toward the towering fireplace of stacked white marble and a fantastic oversized modern light fixture. Walls were removed from the previously enclosed staircase to make room for its modern replacement. Beefy wood treads have been placed down the length of the staircase’s metal stringer (which was fabricated by the homeowners’ daughter) and its glass and stainless handrails allow it to blend seamlessly into the overall design.

SOPHISTICATION THAT SPEAKS FOR ITSELF

Common elements in the furnishings, lighting, and accessories give this home a cohesive feel that appeals to the senses. Artwork and furnishings with touches of gold were chosen from the homeowners’ collection to unify the interior design. Unique recessed and decorative light fixtures in every room showcase the extensive art collection and add visual interest to the sleek interior. Highlighting what you want to see and cleverly hiding what you don’t is another hallmark of this design – just take a look at the built-in floating media cabinet and hidden bar in the den.

SPOTLIGHT A GOURMET KITCHEN

When there is a passion and a talent for cooking, having a highly-functional but beautiful gourmet kitchen is a top priority. Light shines in from the skylight overhead onto the meticulously-selected counter tops and finishes in this high-end kitchen. Custom cabinetry reduces clutter while offering appealing storage solutions and a clean look. The upper cabinets are lit underneath and linear vertical lights illuminate the glass cabinets from within.

The Kitchen and Living Room
Kitchen through Staircase
Living Room
Kitchen

BEAUTIFUL BEDROOMS

One of the most appealing features of this home are the oversized windows that extend through the great room and into the master bedroom.

There, a long tray opens up the ceiling to emphasize the natural light pouring in from the backyard through the glass.

Soffit lights are integrated into the ceiling and a modern fireplace has been added.

Locating the master bedroom and bath on the first floor also allows for the couple’s two adult daughters (and a very adorable dog!) to enjoy the expanse of the second floor privately at their leisure.

Master Bedroom
Bedroom and Patio

Luxurious Bathroom

CRAFTING LUXURIOUS BATHROOMS

Despite its small size, the master bathroom is a shining example of how to create a smart, luxurious spa retreat.

To achieve a look that is simultaneously airy and functional, there is a skylight above the double floating vanities (with undercabinet lighting), a wall-mounted toilet and a curbless shower with frameless glass door.

Large format tile (24”x 48”) was used to cover the heated floor and vertical lines of glamorous mosaic glass tile was used to accentuate the bathroom’s other-worldly plumbing fixtures. The tiling here mimics what is used extensively throughout the house to pull together the design’s contemporary aesthetic. A favorite material of Sensory Six, tile is easily customized and cared for.

Its versatility is also utilized in the laundry room, where a unique layout creates a functional area for linen storage and a stacked washer and dryer.

AN OUTSTANDING OUTDOOR AREA

When you love four-season entertaining, making use of outdoor space is of vital importance. Because of the large wall of windows in the back of the house, the outdoor area has to be both beautiful and fun.

Working in collaboration with the Gallivan Corporation, Sensory Six has created a backyard that feels like a resort. Just steps from the back door is a rectangular modern pool by Concord Pools surrounded by chaise lounge chairs for sunbathing.

A covered living area off of the pool house offers the choice to sit out in the sun or enjoy the shade. There’s a large outdoor television in the ample conversation area, as well as outdoor dining, grilling, and kitchen areas. Beautiful landscaping, square stepping stones and a waterfall with fire features on each side add stunning drama to the space.

From the inside out, this ranch has undergone a complete transformation worthy of a standing ovation.

Pool House
Glass Wall
8.331MBMemory Usage253msRequest 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" => "9" "id" => "91" "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" => 1749642914 "last" => 1749642914...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (4.26ms)
  • afterInitialise (1.96MB) (35.81ms)
  • afterRoute (375.98KB) (5.97ms)
  • beforeRenderComponent com_content (49.15KB) (934μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.82ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.66ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (21μs)
  • After Access::preloadPermissions (com_content) (516.75KB) (1.45ms)
  • Before Access::getAssetRules (id:244 name:com_content.article.91) (18.65KB) (27μs)
  • After Access::getAssetRules (id:244 name:com_content.article.91) (7.38KB) (96μs)
  • afterRenderComponent com_content (1.94MB) (153ms)
  • afterDispatch (21.42KB) (1.19ms)
  • beforeRenderRawModule mod_finder () (384.74KB) (29.06ms)
  • afterRenderRawModule mod_finder () (1.95MB) (6.85ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (1.44KB) (191μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (203μs)
  • afterRenderRawModule mod_menu () (56.48KB) (1.31ms)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (108μs)
  • beforeRenderRawModule mod_custom () (920B) (68μs)
  • afterRenderRawModule mod_custom () (319.76KB) (1.24ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (60μs)
  • beforeRenderRawModule mod_menu () (24B) (77μs)
  • afterRenderRawModule mod_menu () (552B) (419μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (62μs)
  • beforeRenderRawModule mod_custom () (920B) (59μs)
  • afterRenderRawModule mod_custom () (1.03KB) (136μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (58μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (90μs)
  • afterRenderRawModule mod_menu () (4.45KB) (405μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (80μs)
  • beforeRenderRawModule mod_finder () (96B) (9μs)
  • afterRenderRawModule mod_finder () (7.28KB) (552μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (78μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (134μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (4.23KB) (169μs)
  • afterRenderRawModule mod_custom () (1008B) (132μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (472B) (59μs)
  • afterRenderRawModule mod_custom () (1008B) (113μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (41μs)
  • afterRender (314.9KB) (3.67ms)
  • 1 x afterRenderComponent com_content (1.94MB) (60.41%)
    153.04ms
    1 x afterInitialise (1.96MB) (14.14%)
    35.81ms
    1 x beforeRenderRawModule mod_finder () (384.74KB) (11.47%)
    29.06ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (2.7%)
    6.85ms
    1 x afterRoute (375.98KB) (2.36%)
    5.97ms
    1 x afterLoad (444.73KB) (1.68%)
    4.26ms
    1 x afterRender (314.9KB) (1.45%)
    3.67ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (0.72%)
    1.82ms
    1 x After Access::preloadComponents (all components) (116.7KB) (0.65%)
    1.66ms
    1 x After Access::preloadPermissions (com_content) (516.75KB) (0.57%)
    1.45ms
    1 x afterRenderRawModule mod_menu () (56.48KB) (0.52%)
    1.31ms
    1 x afterRenderRawModule mod_custom () (319.76KB) (0.49%)
    1.24ms
    1 x afterDispatch (21.42KB) (0.47%)
    1.19ms
    1 x beforeRenderComponent com_content (49.15KB) (0.37%)
    934μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.22%)
    552μs
    1 x afterRenderRawModule mod_menu () (552B) (0.17%)
    419μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.16%)
    405μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.1%)
    245μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.08%)
    203μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.08%)
    191μs
    1 x beforeRenderRawModule mod_custom () (4.23KB) (0.07%)
    169μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.05%)
    136μs
    1 x afterRenderRawModule mod_custom () (912B) (0.05%)
    134μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.05%)
    127μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.04%)
    113μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.04%)
    108μs
    1 x After Access::getAssetRules (id:244 name:com_content.article.91) (7.38KB) (0.04%)
    96μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.04%)
    90μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.03%)
    80μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.03%)
    78μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.03%)
    77μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.02%)
    62μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.02%)
    60μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.02%)
    59μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.02%)
    45μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.02%)
    41μs
    1 x Before Access::getAssetRules (id:244 name:com_content.article.91) (18.65KB) (0.01%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    21μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    14μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    11μs
    3 x beforeRenderModule mod_menu () (696B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (96B) (0%)
    9μs
    1 x beforeRenderRawModule mod_custom () (288B) (0%)
    9μs
54 statements were executed, 5 of which were duplicates, 49 unique16.54ms921.34KB
  • SELECT @@SESSION.sql_mode;149μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?243μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1107μ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)235μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`193μ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` = :guest336μ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"220μ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"75μ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"71μ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"73μ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"55μ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"59μ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"105μ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"82μ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"61μ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"63μ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"65μ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"66μ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"57μ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"60μ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"62μ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"58μ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"69μ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"178μ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"67μ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"55μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`814μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'93μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1231μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'143μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1140μ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)545μ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` = 0562μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.15ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '91'337μ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)573μs78.12KBParams/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`321μ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)268μ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 ASC357μ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 DESC2ms21.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`332μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`979μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 122 AND `component_type` = "menu"1.54ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 91 AND `component_type` = "content"1.11ms536B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1267μ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)182μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1457μ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 ASC328μ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)130μ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` = 1158μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?100μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?233μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy