Westfield Chermside Redevelopment Urchin Project
Westfield Chermside Redevelopment Urchin Project

Westfield Chermside Redevelopment Urchin Project (2018)

 

LSAA 2018 Design Awards AWARD OF EXCELLENCE - Category 7 Special Applications (7235)

APPLICATION OF PROJECT

Custom Lightweight Architectural Structure with aluminium cladding

PROJECT DESCRIPTION:

As part of the Westfield Chermside AUD$355 million redevelopment, we were contracted for the fabrication and construction of a large scale custom aluminium retail structure, and subsequently, a porte cochère entry structure. The aluminium structure is called the ‘Urchin’ as the distinctive shape resembles the round, jagged edges of a sea urchin. The design intent behind the structure was to create a main focal area for the redevelopment and a “meeting point” for the centre. The area below the Urchin is used for events and entertainment, thanks to its amazing programable LED lighting system integration. The Urchin is our first large architectural structure that does not include any fabric.


Images Copyright Steve Ryan, Rix Ryan Photography


Westfield Chermside received an AUD$355million redevelopment, finishing in 2017, that would create an extra 33,000m2 of retail space and become home to just under 100 new stores. The centre caters to a population of over 780,000 consumers which is approximately 32% of the population of Brisbane. Some of Australia’s best known retailers are at Chermside, including Myer, David Jones, Gib W, Coles, Woolworths, Apple and Target.

DESIGN / FABRICATION / INSTALLATION BRIEF

The Westfield Chermside Urchin project is a large, iconic architectural structure situated in middle of the alfresco dining area of the centre. The structure was originally named the ‘bird cage’ due to its arching shape but was renamed to the ‘urchin’ after the design changed to include a series of aluminium cladding panels. The outline of the structure appears spikey due to the jutting corners of the structure. The Urchin was designed to provide shade for the lower levels while also standing as a sculpture/landmark for the shopping centre.

Each layer of cladding has a different geometry as it moves up towards the peak of the structure. There is a different folding pattern which makes the structure extremely dynamic. The open spaces between each panel create a captivating ambience beneath the structure that changes as the sun moves throughout the day.

The lower steel ring beam was custom folded plate running in two different curvatures. The primary steelwork of the structure was very architectural, spiralling around with double-curvature as it works its way up towards the top. The secondary steel was designed to accompany and hide the lighting system, as well as connect the panels. The integrated LED lighting has been incorporated around the steel that reflects magnificently off the white panels at night. The lights can be programmed in a variety of different colours, patterns and speeds to suit any occasion.

STRUCTURAL SYSTEMS

The structure had to be designed to be lightweight as its weight and loads were very limited be the capacity of the thin tensioned-concrete-slab where the structure connects to.

Additionally, it was quite a challenge to design the secondary steel to accommodate about 3,000 cleats for the 677 aluminium panels and conceal all the electrical reticulation and LED lights.

MATERIALS

The PVDF coated aluminium panels were chosen not only because they were a lightweight option that suited the installation requirements, but also because their unique patterning, grooves, and shapes could create the design shape required.

FABRICATION

The 5,005 aluminium cladding panels are from a specialist fabricator. They are 3mm, 4mm, and 5mm thick with a PVDF paint system on both sides of the cladding.

Every single panel was modelled, flattened, and fabricated using CNC equipment to achieve the design geometry with millimetric accuracy.

COLLABORATION, CONSTRUCTION AND MAINTENANCE

There was a specific requirement in the way the Urchin structure was connected to the second story slab and the supports below. There is a car park underneath with columns coming up, so the base of the structure had to land on the columns. As you can imagine, this meant there was a lot of coordination involved with this.

The ring beam geometry was designed around these joints, which meant lots of coordination with the client and their consultants as well.

Credits:

Entrant:  Fabritecture
Role played by Entrant:  Designer / installer

Location:  Chermside, QLD 
Completed:   November 2016

Client:  Scentre Group Design

Architect:  Armada Architecture; Urbis Design
Engineer:  Fabritecture; Wade Design Engineers
Builder:  Scentre Group Design
Fabricator:  Confidential
Photo Credits: Steve Ryan, Rix Ryan Photography

Ref Gallery: 2018_Images/Award_Entries/7235_Chermside  DPID 270



Settings26.63MBMemory 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:54 [ "USER" => "lsaa" "HOME" => "/home/lsaa" "PATH_TRANSLATED" => "redirect:/index.php/s...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1753634915 "last" => 1753634915...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.63MB) (20.9ms)
  • afterInitialise (7.75MB) (54.48ms)
  • afterRoute (1.12MB) (10.81ms)
  • beforeRenderComponent com_content (1.11MB) (8.32ms)
  • Before Access::preloadComponents (all components) (419.96KB) (3.47ms)
  • After Access::preloadComponents (all components) (113.07KB) (948μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (19μs)
  • After Access::preloadPermissions (com_content) (625.08KB) (1.31ms)
  • Before Access::getAssetRules (id:803 name:com_content.article.521) (18.65KB) (66μs)
  • After Access::getAssetRules (id:803 name:com_content.article.521) (87.28KB) (299μs)
  • afterRenderComponent com_content (4.78MB) (51.78ms)
  • afterDispatch (19.13KB) (623μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.5MB) (32.82ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (260.55KB) (10.56ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (11μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (426μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (68μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (7.17ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (9μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (150μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (98μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.03KB) (824μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (7μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (170μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (58μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (286.93KB) (7.42ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (8μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (201μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (54μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (88.02KB) (5.94ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (8μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (183μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (86μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (68.23KB) (3.41ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (8μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (171μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (97μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (1.06ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (147μs)
  • afterRender (854.93KB) (15.76ms)
  • 1 x afterInitialise (7.75MB) (22.62%)
    54.48ms
    1 x afterRenderComponent com_content (4.78MB) (21.5%)
    51.78ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.5MB) (13.62%)
    32.82ms
    1 x afterLoad (3.63MB) (8.68%)
    20.90ms
    1 x afterRender (854.93KB) (6.54%)
    15.76ms
    1 x afterRoute (1.12MB) (4.49%)
    10.81ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (260.55KB) (4.39%)
    10.56ms
    1 x beforeRenderComponent com_content (1.11MB) (3.45%)
    8.32ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (286.93KB) (3.08%)
    7.42ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.98%)
    7.17ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (88.02KB) (2.47%)
    5.94ms
    1 x Before Access::preloadComponents (all components) (419.96KB) (1.44%)
    3.47ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (68.23KB) (1.41%)
    3.41ms
    1 x After Access::preloadPermissions (com_content) (625.08KB) (0.54%)
    1.31ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (0.44%)
    1.06ms
    1 x After Access::preloadComponents (all components) (113.07KB) (0.39%)
    948μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.03KB) (0.34%)
    824μs
    1 x afterDispatch (19.13KB) (0.26%)
    623μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (0.18%)
    426μs
    1 x After Access::getAssetRules (id:803 name:com_content.article.521) (87.28KB) (0.12%)
    299μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (0.08%)
    201μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (0.08%)
    183μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (0.07%)
    171μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.07%)
    170μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.06%)
    150μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.06%)
    147μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.04%)
    98μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    97μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.04%)
    86μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.03%)
    68μs
    1 x Before Access::getAssetRules (id:803 name:com_content.article.521) (18.65KB) (0.03%)
    66μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    58μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    54μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    9μ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_articles_latest (Recent Projects) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
54 statements were executed, 7 of which were duplicates, 47 unique22.05ms583.92KB
  • SELECT @@SESSION.sql_mode;82μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?1.98ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 1126μ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)508μ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` = 1110μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`58μ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` = :guest90μ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` = 1112μ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`929μs180.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`870μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `evapj_content` WHERE `id` = :id120μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC102μ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` = 178μ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)139μ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` = 0158μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`468μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '521'1.28ms48B/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)403μ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`118μ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)745μs4.03KBParams/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`121μ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 ASC944μs4.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_270'198μs656B/plugins/content/sigplus/core/core.php:3119Copy
  • SELECT viewid FROM evapj_sigplus_view WHERE folderid = 229 AND hash = 0x5c60c8c31991f11a7382ca680e9a27be196μ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` = 229 AND NOT EXISTS (SELECT * FROM `evapj_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 272) AND depthnum <= 0555μs576B/plugins/content/sigplus/core/core.php:1845Copy
  • SELECT `langid` FROM `evapj_sigplus_language` WHERE `lang` = 'en'35μs536B/plugins/content/sigplus/core/core.php:329Copy
  • SELECT `countryid` FROM `evapj_sigplus_country` WHERE `country` = 'GB'38μ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_270' AND `viewid` = 272 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC1.39ms2.61KB/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_270' AND `viewid` = 272 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC65μ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 CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC376μs1.91KBParams/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`99μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'59μ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`708μ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.01ms22.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`111μ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`87μ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`81μ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`84μ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.15ms22.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`140μ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`128μ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) 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.22ms40.58KBParams/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`96μ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`117μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context172μ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)186μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://lsaa.org/index.php/projects/special-applications/521-westfield-chermside-redevelopment-urchin-2' AND `published` = 1759μs912B/plugins/system/jmap/jmap.php:849Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://lsaa.org/index.php/projects/special-applications/521-westfield-chermside-redevelopment-urchin-2'100μ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` = 1171μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT * FROM evapj_jmap_headings WHERE `linkurl` = 'https://lsaa.org/index.php/projects/special-applications/521-westfield-chermside-redevelopment-urchin-2'192μ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` = 149μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?234μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?629μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy