Overall View of Pacific Fair Resort Roof
Overall View of Pacific Fair Resort Roof

Pacific Fair Resort Roof

 

Pacific Fair Resort Roof - Entered into the LSAA 2016 Design Awards (Cat 4, Large Fabric Structures #4114)

Entrant: Fabritecture (Designer and Installer)

Location: The Esplanade.   Completed: 2016

Client: Scentre Group (Westfield)

Team:  Scentre Group (Westfield), Wade Design, Textile Fabrication Services, Fabritecture 

 Application

Statement architectural fabric structure with complex steel geometry and state-of-the-art LED lighting system as part of a $670 million redevelopment of Pacific Fair Shopping Centre on the Gold Coast.

Description

The project was part of a $670 million redevelopment of the Pacific Fair Shopping Centre. Our project scope involved the complete design and construct (steel and fabric) of an architectural feature roof to cover the resort area of the shopping centre.

The project was designed to be a key architectural feature for the resort area of the Pacific Fair upgrade. The resort roof provides a functional weatherproof aesthetic feature that covers the first level promenade while leaving the ground level centre open creating a bright and airy space. 

The structure is located at the Pacific Fair Shopping Centre in Broadbeach on the Gold Coast.

Design Brief

The purpose of the project was to develop Pacific Fair as the ‘crown’ shopping centre on the Gold Coast. Pacific Fair is now home to the most uniquely innovative architectural fabric structure on the Gold Coast.

The client requested the fabric structure to be a statement feature to the resort area with a dia-grid style roof and lots of curvature as the main design principles. Angled Y columns required specific locations relating to shop fronts. The latest paint system, Quantum FX was also applied to the columns

The fabric was required to be highly translucent, as the area below needed to have a bright, airy ambiance whilst still providing shade and weather protection and longevity with low maintenance.

Structural System

Geometry: We were involved in the design of this project in the concept stage in 2013. From the outset, the Westfield Creative wanted to push the boundaries of the geometry. To explore different options, the geometry was modelled using Grasshopper Parametric 3D modelling software. Two options were finalised, being the Wave Orthogonal and the Wave Diagonal. Fabritecture completed preliminary engineering on the fabric and provided advice on the build-ability of each design. The Wave Diagonal was deemed to be beyond the boundaries of steel fabrication possibilities and the Wave Orthogonal was selected. This design comprised of the following:

  • Outer Perimeter 3D curved edge beam - 363m long
  • Outer Edge 3D curved edge beam - 265m long
  • 80 curved rafters spanning from inner to outer edge
  • 316 Struts connecting the rafters in 4 rings
  • 198 Diagonal struts to create the dia-grid
  • 18 Full height Y columns supporting the inner and outer edges
  • 19 other support points around the outer edge comprising of 1-3 support struts

By far the most complex challenge geometry wise is the inner and outer edge. These are created using a large number of tangential curves (40 for outer edge and 41 for the inner edge) which, when connected together, create the undulating curved geometry required. The entire structure was modelled in Teklar and AutoCAD and then fed back into the clients master revit model to do a final check for geometry and clashes. Fabricating the steelwork for the roof posed a major risk for the project. To overcome this challenge, the entire roof - excluding column - was trial assembled during fabrication in sections. Each section was surveyed after trial assembly, and cross-checked against the theoretical geometry using the 3D model.  After fabrication, the steelwork was painted and then loaded into purpose-built cradles for freight to site. The 200 tonne of steel was delivered to site to match the installation sequence in 27 cradles.

  • Patterning: The architect required that the seams in the roof match with the steelwork ring beams. To achieve this we used 9 concentric seams lines that were aligned parallel with the struts connecting the rafters. This resulted in 10 patterns per bay with a total of 790 different patterns.
  • Details: The architect did not want to see any connections in the steelwork throughout the roof. The only allowed visible connections were pinned connections at the base of some outer struts. To meet this requirement all connections were designed to fit within the overall shape of the member and then sheet metal cover plates were installed to conceal the connections. Approximately 1,400 cover plates were installed in total.
  • Drainage and Guttering: 300 half round gutters were to be installed on the inner and outer. This posed a challenge because 300 half round sheet metal cannot be rolled. To overcome this, the gutter was fabricated in approximately 900mm lengths that join of a gutter bracket, creating a faceted gutter. A best fit method was used and each gutter section was 3D modelled and shop detailed. Each section is a wedge shape in plan to allow for the change in angle at each bracket. The gutter feed water into downpipes which are fabricated and concealed within the columns that are plumbed directly into the stormwater drainage system.
  • Installation Method: Particular emphasis was placed on the installation being perfect due to the resort roof being a ribbon ring structure. There was a highly technical process followed during the installation of the steelwork to ensure that structure met at the join accurately to complete the ring. To achieve this, all lifts, connection points and landing points (i.e. columns and base plates and primary lifts) were carefully surveyed prior to being put into place. The edge beam was also surveyed throughout the whole build to ensure a successful join. The install team were very particular to be sure the process was followed throughout the install. The end result was very satisfying with only 2 struts being half a bolt hole out. An intricate temporary bracing system was provided as an engineering solution to assist the install. This was required for all of the columns to control where the structure was positioned during installation, but before completion. This limited the dynamic movement of the structure during installation.
  • There were a lot of other trades sharing the same site with limited access as the site was basically enclosed by the existing infrastructure of the shopping centre. This made an already complex installation methodology even more complicated.

Materials

Chukoh FGT-600 PTFE was the chosen fabric for the resort roof. PTFE was the preferred fabric as it offered the necessary translucency and longevity, and paired well with the LED lighting system. Tensile strength and a 20 year manufacturer’s warranty were also factors.

Fabrication

A complete trial assembly of sections was provided in the factory prior to installation. This was primarily due to the extreme complexity of the technical geometry of the steel.

The paint system on the steel is a Dulux Quantum FX protective coating, providing a metallic finish with a semi-gloss coating.

  • Diablo connections and cover plates
  • Lighting system and hydraulics

Collaboration

An integrated fall arrest system has been incorporated into the design of the roof structure for inspections and maintenance systems as required.

The resort roof is 5,400m2 and took approximately 11,000 man hours to complete.

Cost and Conclusion

The Pacific Fair Resort Roof project is valued at AUD$4,000,000

The final steel link-up was almost perfect at only 7mm out, which was an incredible success for the installation! The client was very happy with the outcome. The project exceeded the needs of the brief, and resulted in being awarded another million-dollar shopping centre redevelopment project with the client.

The resort roof incorporates a state-of-the-art LED system capable of illuminating the structure in both solid and alternating colours. There is also a flowing gutter system to the edge beam that follows the system on both sides. The project exceeded the needs of the brief, and resulted in being awarded another million-dollar shopping centre redevelopment project with the client.

Ref: sliders/DA2016/Cat4/4114 DP ID 231


Settings26.542MBMemory Usage247msRequest 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" => 1753213816 "last" => 1753213816...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.63MB) (23.68ms)
  • afterInitialise (7.75MB) (55.29ms)
  • afterRoute (1.12MB) (9.56ms)
  • beforeRenderComponent com_content (1.11MB) (7.91ms)
  • Before Access::preloadComponents (all components) (419.96KB) (3.43ms)
  • After Access::preloadComponents (all components) (113.07KB) (939μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (23μs)
  • After Access::preloadPermissions (com_content) (624.65KB) (1.03ms)
  • Before Access::getAssetRules (id:446 name:com_content.article.345) (18.65KB) (40μs)
  • After Access::getAssetRules (id:446 name:com_content.article.345) (87.28KB) (338μs)
  • afterRenderComponent com_content (4.69MB) (54.96ms)
  • afterDispatch (19.13KB) (598μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.49MB) (39.89ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (194.68KB) (9.59ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (12μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (432μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (74μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (8.48ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (13μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (163μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (69μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (78.03KB) (616μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (8μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (146μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (60μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (286.93KB) (6.35ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (19μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (252μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (69μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (88.02KB) (2.84ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (7μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (196μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (57μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (48.7KB) (1.73ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (7μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (181μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (96μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.59KB) (1.07ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (135μs)
  • afterRender (816.66KB) (15.75ms)
  • 1 x afterInitialise (7.75MB) (22.39%)
    55.29ms
    1 x afterRenderComponent com_content (4.69MB) (22.25%)
    54.96ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.49MB) (16.15%)
    39.89ms
    1 x afterLoad (3.63MB) (9.59%)
    23.68ms
    1 x afterRender (816.66KB) (6.38%)
    15.75ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (194.68KB) (3.88%)
    9.59ms
    1 x afterRoute (1.12MB) (3.87%)
    9.56ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (3.43%)
    8.48ms
    1 x beforeRenderComponent com_content (1.11MB) (3.2%)
    7.91ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (286.93KB) (2.57%)
    6.35ms
    1 x Before Access::preloadComponents (all components) (419.96KB) (1.39%)
    3.43ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (88.02KB) (1.15%)
    2.84ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (48.7KB) (0.7%)
    1.73ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.59KB) (0.43%)
    1.07ms
    1 x After Access::preloadPermissions (com_content) (624.65KB) (0.42%)
    1.03ms
    1 x After Access::preloadComponents (all components) (113.07KB) (0.38%)
    939μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (78.03KB) (0.25%)
    616μs
    1 x afterDispatch (19.13KB) (0.24%)
    598μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (0.17%)
    432μs
    1 x After Access::getAssetRules (id:446 name:com_content.article.345) (87.28KB) (0.14%)
    338μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (0.1%)
    252μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (6.22KB) (0.08%)
    196μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (0.07%)
    181μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.07%)
    163μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.06%)
    146μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.05%)
    135μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    96μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.03%)
    74μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.03%)
    69μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.03%)
    69μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    60μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.02%)
    57μs
    1 x Before Access::getAssetRules (id:446 name:com_content.article.345) (18.65KB) (0.02%)
    40μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    23μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0.01%)
    19μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0.01%)
    13μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_articles_latest (Latest Articles) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_articles_latest (Recent Projects) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    6μs
54 statements were executed, 8 of which were duplicates, 46 unique14.11ms642.8KB
  • SELECT @@SESSION.sql_mode;89μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?242μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 1153μ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)827μ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` = 1124μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`62μ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` = :guest71μ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`80μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 166μ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`169μs164.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`150μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `evapj_content` WHERE `id` = :id162μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC62μ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` = 165μ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)179μ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` = 0153μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`588μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '345'1.76ms48B/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)532μ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`129μ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)683μs4.02KBParams/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`139μ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 ASC126μ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_231'179μs656B/plugins/content/sigplus/core/core.php:3119Copy
  • SELECT viewid FROM evapj_sigplus_view WHERE folderid = 138 AND hash = 0x74a56b68556a2d5cb4f4a90b3dc9b8c1110μ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` = 138 AND NOT EXISTS (SELECT * FROM `evapj_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 186) AND depthnum <= 0493μs576B/plugins/content/sigplus/core/core.php:1845Copy
  • SELECT `langid` FROM `evapj_sigplus_language` WHERE `lang` = 'en'34μs536B/plugins/content/sigplus/core/core.php:329Copy
  • SELECT `countryid` FROM `evapj_sigplus_country` WHERE `country` = 'GB'31μ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_231' AND `viewid` = 186 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC1.3ms2.67KB/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_231' AND `viewid` = 186 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC90μ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 DESC667μ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`191μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'62μ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`704μ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 4193μs22.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`129μ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`146μ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`107μ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`93μ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 4124μs22.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`86μ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`78μ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 3168μs96.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`86μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context170μ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)136μ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)124μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://lsaa.org/projects/large-fabric-structures/345-pacific-fair-resort-roof' AND `published` = 1700μs928B/plugins/system/jmap/jmap.php:849Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://lsaa.org/projects/large-fabric-structures/345-pacific-fair-resort-roof'118μ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` = 1207μ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/345-pacific-fair-resort-roof'144μ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` = 142μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?168μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?621μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy