General View of the Link@Langley Roof
General View of the Link@Langley Roof

Large ETFE Structure - 2024DA - Link at Langley Atrium

2024 LSAA Design Awards Entry #4866 Link at Langley 

Entrant: MakMax Australia
Category: Large Fabric Structures
Entrant Role: Designer / Engineer / Fabricator / Installer
Project Name: The Link at Langley Atrium

Application of the Link at Langley is a Clear ETFE "glazed" Atrium Roof over a Commercial Development.

  

Citation Large Link at Langley

PROJECT DESCRIPTION:

The Link@Langley ETFE Atrium not only enhances the visual appeal of the riverside redevelopment but also demonstrates the successful fusion of modern lightweight glazed roof design with practical engineering solutions.

The result is a harmonious blend of form and function and a symbol of innovation, seamlessly integrating into its surroundings while offering a captivating architectural aesthetic.

This project exemplifies the power of clever design and cutting-edge materials in shaping the future of urban architecture. Massive in size and scope, the Link@Langley ETFE Atrium structure is 65 meters long and 40 metres wide and sits atop a former office building between seven and eight storeys above the atrium floor.

THE PROJECT

Nestled along the picturesque Perth riverside, the Link@Langley ETFE Atrium stands as a testament to lightweight structure innovation and design excellence. This custom-designed, 1665m2 single-layer ETFE canopy crowns the central atrium of a revitalised shopping, dining, and entertainment district, transforming the former Fortescue Metals HQ into a contemporary urban hub.

The architectural vision for the Link@Langley ETFE Atrium was clear (in more ways than one). The clear purpose was to create a visually striking, yet functional feature glazed skylight element to enhance the appeal of the riverside redevelopment. The aesthetic vision was to have a visually clear atrium roof, to create a sense of open sky, while still protecting patrons and visitors from the elements.

We worked closely with the project architect to design the Link@Langley ETFE Atrium, a structure that truly reflects the aspirations of Lightweight Structures. The innovative use of lightweight ETFE film as the glazing materials helps to minimise the amount of supporting steel, even over the large unsupported central spans. The ultra-light material has also allowed for greater design freedom, with the undulating shape of the canopy mimicking the fluidity of a breaking wave.

STRUCTURAL SYSTEMS

Massive in size and scope, the Link@Langley ETFE Atrium structure is 65 meters long and 40 metres wide and sits between seven and eight storeys above the atrium floor.

Our initial design challenge was to seamlessly integrate the canopy structure with the existing buildings, providing a light, transparent and waterproof atrium for the new entertainment precinct. We were extremely limited in locations where support columns and braces could be fixed back to the original structures, which dictated some of the design and geometry decisions.

Even with the ultra-lightweight ETFE cladding, the massive area covered by the atrium structure uses 74 tonnes of structural steel. Fixing steel to existing structures required detailed loading analysis to avoid damaging the buildings.

Using parametric modelling software, we designed a full 3D model of the ETFE structure, including the surrounding buildings, to test the loading on anchor locations and to confirm the HD bolt set-out points. The fixing points were an interesting design and install challenge, with 80% of the canopy affixed to the roof (floating slab) of the former Fortescue Metals HQ, while the other 20% of connections required vertical fixing points to the adjoining Hyatt hotel.

MATERIALS

ETFE is durable, highly transparent, and extremely lightweight in comparison to glass structures (upto 20x lighter than a glazed roof). This modern membrane is quickly becoming the material of choice for large, glazed atrium applications.

ETFE is not only a lightweight and durable material but also an environmentally friendly choice. This incredibly lightweight material requires far less supporting steelwork than a more traditional glazed roof. This translates into an overall embodied carbon saving for the building, due to greatly reduced usage of construction materials. The high transparency of ETFE allows for natural light penetration, reducing the need for artificial lighting and thereby lowering the energy consumption of the atrium. In addition to low material weight and high light transmission benefits, the production of ETFE film has a low environmental impact, and the material is fully recyclable, aligning with modern sustainability standards.

For the Link@Langley, we proposed a single layer ETFE printed with a 16mm silver-dot frit pattern (P46D16) on the underside. Print and shade factor was carefully evaluated to both provide thermal comfort to the atrium but also to ensure guests in the hotel rooms above would still have good visibility down into the space below.

Fabricating the unique shape of the Link@Langley required detailed plotting and welding plans. The 3D shape of the ETFE atrium was achieved by welding 72 individual panels into seven separate sections of ETFE.

The seven ETFE sections range in size from 99m2 to an enormous 355msection across the widest part of the canopy.

The structure was finished with custom-designed Zincalume steel gutters around the entire perimeter and downpipes connecting into exiting stormwater drains.

INSTALLATION

A tower crane was used to raise the prefabricated steel sections to the Level Seven rooftop. Once the steel skeletal formwork was installed, we progressed to ETFE installation. The ETFE panels are supported by almost 200 stainless steel cables, threaded through specially designed and fabricated cable pockets welded to the underside of the ETFE. The cables are attached to the steel rafters and then tensioned to create a solid exoskeleton to support the membrane.

Installing tensioned membrane panels eight storeys in the air over an open void required a highly experienced rigging and installation crew. 

THE RESULT

The ETFE Atrium will enhance the overall visitor experience to the Link@Langley development by creating an inviting and comfortable environment. The transparent canopy allows for an abundance of natural light, making the space feel open and airy while providing protection from the elements. Visitors can enjoy the beauty of the riverside setting in a controlled climate, adding to the appeal of the shopping, dining, and entertainment district.

The completed Link@Langley ETFE Atrium is a stunning addition to the Perth riverside, exemplifying the principles of lightweight structures by employing modern new materials in traditional architectural applications. By replacing glass with ETFE film, this project optimises construction material usage and stands as a model of modern architectural and engineering excellence.

COSTS

Confidential

COLOUR IMAGES

  • 4866_Link@Langley_01_aerial.jpg
  • 4866_Link@Langley_02_interior.jpg
  • 4866_Link@Langley_03_aerial.jpg
  • 4866_Link@Langley_04_exterior.jpg
  • 4866_Link@Langley_05_exterior.jpg
  • 4866_Link@Langley_06_interior.jpg
  • 4866_Link@Langley_07_interior.jpg
  • 4866_Link@Langley_08_installation.jpg
  • 4866_Link@Langley_09_installation.jpg
  • 4866_Link@Langley_10_installation.jpg
  • 4866_Link@Langley_11_Closeup.jpg
  • 4866_Link@Langley_12_Closeup.jpg

PKNote: DPID 418

OTHER INFORMATION AND SUBMISSION


Settings26.521MBMemory Usage241msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.2
PHP Version8.2.29
Identityguest
Response200
Templateflex
Database
Server
mysql
Version
10.6.22-MariaDB-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "USER" => "lsaa" "HOME" => "/home/lsaa" "SCRIPT_NAME" => "/index.php" "REQUEST_UR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1753875139 "last" => 1753875139...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.63MB) (22.48ms)
  • afterInitialise (7.75MB) (53.54ms)
  • afterRoute (1.12MB) (11.78ms)
  • beforeRenderComponent com_content (1.11MB) (7.92ms)
  • Before Access::preloadComponents (all components) (419.96KB) (3.27ms)
  • After Access::preloadComponents (all components) (113.07KB) (921μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (20μs)
  • After Access::preloadPermissions (com_content) (624.42KB) (1.05ms)
  • Before Access::getAssetRules (id:1684 name:com_content.article.889) (18.65KB) (39μs)
  • After Access::getAssetRules (id:1684 name:com_content.article.889) (87.28KB) (309μs)
  • afterRenderComponent com_content (4.66MB) (51.92ms)
  • afterDispatch (19.13KB) (622μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.5MB) (32.78ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (196.55KB) (9.49ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (11μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (384μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (60μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (7.14ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (12μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (172μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (54μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (78.03KB) (544μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (7μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (149μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (58μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (286.93KB) (7.29ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (8μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (191μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (49μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (88.02KB) (5.54ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (8μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (207μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (55μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (49.31KB) (3.22ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (6μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (166μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (96μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (1.05ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (176μs)
  • afterRender (804.24KB) (17.22ms)
  • 1 x afterInitialise (7.75MB) (22.23%)
    53.54ms
    1 x afterRenderComponent com_content (4.66MB) (21.56%)
    51.92ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.5MB) (13.61%)
    32.78ms
    1 x afterLoad (3.63MB) (9.34%)
    22.48ms
    1 x afterRender (804.24KB) (7.15%)
    17.22ms
    1 x afterRoute (1.12MB) (4.89%)
    11.78ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (196.55KB) (3.94%)
    9.49ms
    1 x beforeRenderComponent com_content (1.11MB) (3.29%)
    7.92ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (286.93KB) (3.03%)
    7.29ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.97%)
    7.14ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (88.02KB) (2.3%)
    5.54ms
    1 x Before Access::preloadComponents (all components) (419.96KB) (1.36%)
    3.27ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (49.31KB) (1.34%)
    3.22ms
    1 x After Access::preloadPermissions (com_content) (624.42KB) (0.44%)
    1.05ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (0.43%)
    1.05ms
    1 x After Access::preloadComponents (all components) (113.07KB) (0.38%)
    921μs
    1 x afterDispatch (19.13KB) (0.26%)
    622μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (78.03KB) (0.23%)
    544μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (0.16%)
    384μs
    1 x After Access::getAssetRules (id:1684 name:com_content.article.889) (87.28KB) (0.13%)
    309μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (0.09%)
    207μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (0.08%)
    191μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.07%)
    176μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.07%)
    172μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (0.07%)
    166μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.06%)
    149μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    96μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.02%)
    60μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    58μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.02%)
    55μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.02%)
    54μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    49μs
    1 x Before Access::getAssetRules (id:1684 name:com_content.article.889) (18.65KB) (0.02%)
    39μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_articles_latest (Latest Articles) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_articles_latest (Recent Projects) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    6μs
54 statements were executed, 8 of which were duplicates, 46 unique24.76ms586.73KB
  • SELECT @@SESSION.sql_mode;72μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?504μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 194μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `evapj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)512μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `evapj_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 176μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`47μs736B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `evapj_usergroups` AS `a` LEFT JOIN `evapj_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest57μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `evapj_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`73μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 187μs1.15KB/plugins/system/helix3/helix3.php:247Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `evapj_menu` AS `m` LEFT JOIN `evapj_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.87ms180.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`792μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `evapj_content` WHERE `id` = :id147μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC84μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `evapj_template_styles` AS `s` LEFT JOIN `evapj_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 193μs16.89KB/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `evapj_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,:preparedArray42)136μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `evapj_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0142μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`644μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '889'589μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `evapj_content` AS `a` INNER JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_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)509μs22.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 `evapj_categories` AS `s` INNER JOIN `evapj_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`839μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `evapj_contentitem_tag_map` AS `m` INNER JOIN `evapj_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)1.16ms3.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 `evapj_categories` AS `s` INNER JOIN `evapj_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`120μs3.92KBParams/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 evapj_fields AS a LEFT JOIN `evapj_languages` AS l ON l.lang_code = a.language LEFT JOIN evapj_users AS uc ON uc.id=a.checked_out LEFT JOIN evapj_viewlevels AS ag ON ag.id = a.access LEFT JOIN evapj_users AS ua ON ua.id = a.created_user_id LEFT JOIN evapj_fields_groups AS g ON g.id = a.group_id LEFT JOIN `evapj_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC1.14ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `folderid`, `foldertime`, `entitytag` FROM `evapj_sigplus_folder` WHERE `folderurl` = '/home/lsaa/public_html/images/DP_SIG_Folders/DPID_418'150μs656B/plugins/content/sigplus/core/core.php:3119Copy
  • SELECT viewid FROM evapj_sigplus_view WHERE folderid = 70 AND hash = 0xa560913726d044259a8067d9d00c9ba7228μs536B/plugins/content/sigplus/core/core.php:1229Copy
  • SELECT i.`fileurl`, i.`imageid` FROM `evapj_sigplus_image` AS i INNER JOIN `evapj_sigplus_folder` AS f ON i.`folderid` = f.`folderid` INNER JOIN `evapj_sigplus_hierarchy` AS h ON f.`folderid` = h.`descendantid` WHERE h.`ancestorid` = 70 AND NOT EXISTS (SELECT * FROM `evapj_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 118) AND depthnum <= 0541μs576B/plugins/content/sigplus/core/core.php:1845Copy
  • SELECT `langid` FROM `evapj_sigplus_language` WHERE `lang` = 'en'36μs536B/plugins/content/sigplus/core/core.php:329Copy
  • SELECT `countryid` FROM `evapj_sigplus_country` WHERE `country` = 'GB'41μs536B/plugins/content/sigplus/core/core.php:344Copy
  • SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue` FROM `evapj_sigplus_property` AS mp INNER JOIN `evapj_sigplus_data` AS md ON mp.`propertyid` = md.`propertyid` WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid` LIMIT 1 ), ( SELECT md.`textvalue` FROM `evapj_sigplus_property` AS mp INNER JOIN `evapj_sigplus_data` AS md ON mp.`propertyid` = md.`propertyid` WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid` LIMIT 1 ), ( SELECT p.`title` FROM `evapj_sigplus_foldercaption` AS p WHERE p.`langid` = 38 AND p.`countryid` = 67 AND i.`filename` LIKE p.`pattern` AND i.`folderid` = p.`folderid` ORDER BY p.`priority` LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue` FROM `evapj_sigplus_property` AS mp INNER JOIN `evapj_sigplus_data` AS md ON mp.`propertyid` = md.`propertyid` WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid` LIMIT 1 ), ( SELECT p.`summary` FROM `evapj_sigplus_foldercaption` AS p WHERE p.`langid` = 38 AND p.`countryid` = 67 AND i.`filename` LIKE p.`pattern` AND i.`folderid` = p.`folderid` ORDER BY p.`priority` LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl` FROM `evapj_sigplus_image` AS i INNER JOIN `evapj_sigplus_folder` AS f ON i.`folderid` = f.`folderid` INNER JOIN `evapj_sigplus_hierarchy` AS h ON f.`folderid` = h.`descendantid` INNER JOIN `evapj_sigplus_folder` AS a ON a.`folderid` = h.`ancestorid` INNER JOIN `evapj_sigplus_imageview` AS v ON i.`imageid` = v.`imageid` LEFT JOIN `evapj_sigplus_caption` AS c ON c.`imageid` = i.`imageid` AND c.`langid` = 38 AND c.`countryid` = 67 WHERE a.`folderurl` = '/home/lsaa/public_html/images/DP_SIG_Folders/DPID_418' AND `viewid` = 118 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC1.6ms2.55KB/plugins/content/sigplus/core/core.php:3368Copy
  • SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue` FROM `evapj_sigplus_property` AS mp INNER JOIN `evapj_sigplus_data` AS md ON mp.`propertyid` = md.`propertyid` WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid` LIMIT 1 ), ( SELECT md.`textvalue` FROM `evapj_sigplus_property` AS mp INNER JOIN `evapj_sigplus_data` AS md ON mp.`propertyid` = md.`propertyid` WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid` LIMIT 1 ), ( SELECT p.`title` FROM `evapj_sigplus_foldercaption` AS p WHERE p.`langid` = 38 AND p.`countryid` = 67 AND i.`filename` LIKE p.`pattern` AND i.`folderid` = p.`folderid` ORDER BY p.`priority` LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue` FROM `evapj_sigplus_property` AS mp INNER JOIN `evapj_sigplus_data` AS md ON mp.`propertyid` = md.`propertyid` WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid` LIMIT 1 ), ( SELECT p.`summary` FROM `evapj_sigplus_foldercaption` AS p WHERE p.`langid` = 38 AND p.`countryid` = 67 AND i.`filename` LIKE p.`pattern` AND i.`folderid` = p.`folderid` ORDER BY p.`priority` LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl` FROM `evapj_sigplus_image` AS i INNER JOIN `evapj_sigplus_folder` AS f ON i.`folderid` = f.`folderid` INNER JOIN `evapj_sigplus_hierarchy` AS h ON f.`folderid` = h.`descendantid` INNER JOIN `evapj_sigplus_folder` AS a ON a.`folderid` = h.`ancestorid` INNER JOIN `evapj_sigplus_imageview` AS v ON i.`imageid` = v.`imageid` LEFT JOIN `evapj_sigplus_caption` AS c ON c.`imageid` = i.`imageid` AND c.`langid` = 38 AND c.`countryid` = 67 WHERE a.`folderurl` = '/home/lsaa/public_html/images/DP_SIG_Folders/DPID_418' AND `viewid` = 118 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC86μs0B/plugins/content/sigplus/core/core.php:3375Copy
  • 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 `evapj_content` AS `a` LEFT JOIN `evapj_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 `a`.`ordering`828μs2.47KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`107μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'71μs19.41KB/plugins/system/helix3/helix3.php:79Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `evapj_modules` AS `m` LEFT JOIN `evapj_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `evapj_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`584μs2.13KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.hits DESC LIMIT 42.43ms22.41KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`101μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`80μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`89μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`91μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.publish_up DESC LIMIT 42.71ms22.41KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`117μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`79μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.modified DESC, a.created DESC LIMIT 31.25ms24.7KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `evapj_categories` AS `s` INNER JOIN `evapj_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`121μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context741μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `evapj_content` AS `a` INNER JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_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)148μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `evapj_content` AS `a` INNER JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_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)150μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://lsaa.org/projects/large-fabric-structures/889-2024-lsaa-design-awards-entry-4866-link-at-langley-2' AND `published` = 1849μs912B/plugins/system/jmap/jmap.php:849Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://lsaa.org/projects/large-fabric-structures/889-2024-lsaa-design-awards-entry-4866-link-at-langley-2'324μs640B/plugins/system/jmap/jmap.php:979Copy
  • 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 `evapj_scheduler_tasks` AS `a` WHERE `a`.`state` = 1162μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT * FROM evapj_jmap_headings WHERE `linkurl` = 'https://lsaa.org/projects/large-fabric-structures/889-2024-lsaa-design-awards-entry-4866-link-at-langley-2'156μs752B/plugins/system/jmap/jmap.php:1203Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `evapj_jmap_text_replacements` WHERE `published` = 138μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?166μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?903μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy