Model of the HOTA Stage and Sound Shell
Model of the HOTA Stage and Sound Shell

HOTA Home of the Arts Outdoor Stage Project (2018)

LSAA 2018 Design Awards AWARD OF EXCELLENCE - Category 6 Collaboration (6123)

Application: Outdoor Stage Canopy

Home of the Arts Outdoor Stage Project Description

As the first project to be delivered from the HOTA masterplan, the Outdoor Stage welcomes people 24/7. It is a highly versatile venue – a black-box theatre with a back wall that folds away completely, opening the box out onto an amphitheatre with seating and lawn space for 5,000 people.

The shade canopy of the Outdoor Stage is a striking steel structure featuring the distinctive HOTA masterplan design motif: the Voronoi – a dynamic, cellular geometric structure that unifies the precinct visually. The overall form of the canopy is defined by the surface of a sphere bounded by two arcs. The canopy’s tubular members are joined to one another with rigid connections, forming a stiff ‘Vierendeel grid shell’ system which resists vertical loads though a combination of bending and axial forces.



Images (c) John Gollings and/or City of the Gold Coast 

The Voronoi pattern contained within the canopy appears in the final product as a visually complex form but is actually composed of very simple, fundamental geometries and rules which simplified the design of the steel shell connections and the whole of the construction process. The complex geometry necessary to achieve such a memorable structure came about through exceptional collaboration between the client, contractor, design team, shop detailer and steel fabricator, a construction led approach to design, and innovative structural engineering.

Extensive use of parametric design techniques and shared models allowed rapid development and assessment of large numbers of framing options to drive optimisation of the selected form. The project was designed with construction in mind which resulted in a safe, speedy and economical build. 

DESIGN / FABRICATION / INSTALLATION BRIEF

The initial brief was launched by the City of the Gold Coast as an international design competition to masterplan a new cultural precinct at the Gold Coast. The successful masterplan proposed by ARM Architecture, landscape architect TOPTEKI and multidisciplinary engineer ARUP transforms the Nerang River site from a government precinct of ageing cultural infrastructure and redundant commercial buildings into a thriving community hub aptly named ‘Home of the Arts’ (HOTA).

The brief for the canopy specifically came about as a second stage to the HOTA outdoor stage that was under construction at the time, which entailed a reinforced concrete building that is enveloped by the landscaped mound and front facade.

This brief entailed a canopy that is to be 600m2 in area, was structurally independent of the as-built theater, did not impede the sightlines of the front façade with no column to be placed in front of the façade, clearance for trucks to have access to stage to allow for bespoke rigging for concerts, maximise shade and tie into the architectural language of the precinct.

Please refer to Figure 1 that shows the initial architectural intent for the canopy.

STRUCTURAL SYSTEMS

The geometry of this canopy is simply defined by the surface of a sphere (refer to Figure 2). The primary 20m cantilevering fabricated steel box is defined by two arcs that meet at the two common “knuckles” on this surface that are adjacent to the forestay support. This meant that the boxes are singularly curved for ease of fabrication.

Where these arcs pass through the “knuckle” the curvature of the member has been increased so that the structure is not climbable from the landscaped mound. The forestay and backstay at the surface of the landscaped mound are supported by a reinforced structural capping beam that is in turn supported by piles. The centre of mass of the structure lies between the just behind the forestay so there was no net tension during construction. The span between forestay supports is 50m. 

The primary arcs support a Voronoi tubular shell structure that is projected onto the surface of the sphere. Because this Voronoi shell is not triangulated in plane like a typical diagrid there are significant veirendeel moments to account for in the design. The governing structural load case is wind combined with weight of the structure.

The tubular Voronoi shell steel in turn supports the perforated PVC cladding that is aligned on the centre of the tube to highlight the structure from all angles.

MATERIALS

The roof superstructure is of steel construction which was chosen because it is a compression/tension shell form. Also, the ‘lightness’ of the roof could not have been achieved with another material. Australian steel was specified, reducing the carbon footprint of the project, and transport and construction processes were reduced through careful design of the structural steel elements.

The fabric cladding was Serge Ferrari’s Solis FT381. This material was chosen for it shade qualities and available range of colours.  It also had the ability to span between the veirendeel shell without any additional secondary structure.

FABRICATION, CONSTRUCTION AND MAINTENANCE

The steel superstructure connections are all welded and the structure was broken down into modules for ease of lifting. The fabricator preferred site welded lap plate splice connections which were incorporated into the design.

The primary arcs were also broken down into three modules with a halving joint detail for ease of placement for site welding.

The design team worked with local steel fabricator BSF to develop a design which was compatible with their procurement, skill set and resources. Local industry participation was critical to reducing the transportation impacts.

COLLABORATION

Due to the quite challenging brief many conceptual ideas were parametrically developed between the engineer and architect that were refined over time. This geometry was primarily coordinated through Rhino and Grasshopper which were shared on occasions a few times a day. An example of this was the coordinated design constraint of sightlines to the front façade being provided as a surface by ARM, which Arup used as a geometric design constraint in the refinement of the form.

Due to all parties of the design team being in different cities there were only a few opportunities to communicate in workshops and design meetings. Effective coordination and collaboration lead to the final solution seamlessly tying into the landscaped mound and the architecture of the precinct.

Fabrictecture was involved early in the design process, advising on all types and forms of cladding ranging from aluminum that was cable supported through to the as-built membrane solution. Their input was integral in steering the design to the as-built solution on budget.

COSTS

The project was completed on time and within the $37.5M budget and has provided the Gold Coast with a highly successful first stage of the HOTA Precinct.

A key focus of the shade canopy design was containment of overall project costs. The design was driven by the need to remove risk through early adoption of a design based on ease, speed and safety of construction. Arup worked closely with the design and client team, contractor, steel fabricator and shop detailer to ensure buy-in from all parties to the canopy construction sequence and methodology upon which the design was based. The detailed member and connection designs were then developed collaboratively with input from all to ensure the challenging budget requirements were satisfied.

With overall project costs in mind, specifically ongoing costs associated with maintenance of the asset, the project team undertook numerous studies for the steelwork coating system. By taking a full lifecycle approach, the team was able to assess fading of colours, maintenance and corrosion protection against a number of solutions to optimise the overall design and coatings selection. The outcome was a coating system able to provide a cost effective solution during construction whilst minimising long term maintenance requirements for the structure.

Costs were minimised in the following ways:

The design was refined to deliver an elegant and extremely efficient use of steel.

The steelwork elements were designed to maximise the pieces that could be transported to site – reducing the number of trips required and associated transport costs.

The cradle connections were designed to support the structure as it was built, reducing the requirement for propping the structure and reducing time on site.

OTHER INFORMATION

Figure 1

Figure 1: Initial Architectural Intent

Figure 2

Figure 2: Geometry

 

Credits:

Entrant:  Arup
Role played by Entrant:  Engineer

Location:  Gold Coast, QLD 
Completed:   December 2017

Client:  ADCO Constructions for the City of Gold Coast

Architect:  ARM Architecture
Engineer:  Arup
Specialists:  Fabritecture
Other Consultants: Wade Engineering (Fabric design)
Builder:  ADCO Constructions
Fabricator:  Beenleigh Steel
Photo Credits: John Gollings and City of the Gold Coast

Ref Gallery: 2018_Images/Award_Entries/6123_HOTA_Stage  DPID 268



Settings26.55MBMemory Usage316msRequest 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.23-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/i...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1755079795 "last" => 1755079795...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.63MB) (36.39ms)
  • afterInitialise (7.74MB) (87.07ms)
  • afterRoute (1.1MB) (16.07ms)
  • beforeRenderComponent com_content (1.11MB) (9.25ms)
  • Before Access::preloadComponents (all components) (419.96KB) (3.73ms)
  • After Access::preloadComponents (all components) (113.07KB) (1.01ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (23μs)
  • After Access::preloadPermissions (com_content) (623.41KB) (1.12ms)
  • Before Access::getAssetRules (id:797 name:com_content.article.518) (18.65KB) (42μs)
  • After Access::getAssetRules (id:797 name:com_content.article.518) (87.28KB) (400μs)
  • afterRenderComponent com_content (4.73MB) (59.14ms)
  • afterDispatch (19.13KB) (697μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.35MB) (37.28ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (189.05KB) (15.53ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (17μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (703μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (76μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (6.95ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (11μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (177μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (63μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.03KB) (638μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (7μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (142μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (51μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (350.66KB) (7.61ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (10μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (218μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (56μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (121.54KB) (6.6ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (9μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (196μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (58μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (70.41KB) (3.36ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (8μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (174μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (115μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.74KB) (1.08ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (141μs)
  • afterRender (800.94KB) (18.13ms)
  • 1 x afterInitialise (7.74MB) (27.55%)
    87.07ms
    1 x afterRenderComponent com_content (4.73MB) (18.71%)
    59.14ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.35MB) (11.8%)
    37.28ms
    1 x afterLoad (3.63MB) (11.51%)
    36.39ms
    1 x afterRender (800.94KB) (5.74%)
    18.13ms
    1 x afterRoute (1.1MB) (5.08%)
    16.07ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (189.05KB) (4.91%)
    15.53ms
    1 x beforeRenderComponent com_content (1.11MB) (2.93%)
    9.25ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (350.66KB) (2.41%)
    7.61ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.2%)
    6.95ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (121.54KB) (2.09%)
    6.60ms
    1 x Before Access::preloadComponents (all components) (419.96KB) (1.18%)
    3.73ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (70.41KB) (1.06%)
    3.36ms
    1 x After Access::preloadPermissions (com_content) (623.41KB) (0.35%)
    1.12ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.74KB) (0.34%)
    1.08ms
    1 x After Access::preloadComponents (all components) (113.07KB) (0.32%)
    1.01ms
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (23.55KB) (0.22%)
    703μs
    1 x afterDispatch (19.13KB) (0.22%)
    697μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.03KB) (0.2%)
    638μs
    1 x After Access::getAssetRules (id:797 name:com_content.article.518) (87.28KB) (0.13%)
    400μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.74KB) (0.07%)
    218μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (0.06%)
    196μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.06%)
    177μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (6.34KB) (0.06%)
    174μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.04%)
    142μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.04%)
    141μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    115μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.02%)
    76μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.02%)
    63μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.02%)
    58μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    56μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    51μs
    1 x Before Access::getAssetRules (id:797 name:com_content.article.518) (18.65KB) (0.01%)
    42μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    23μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0.01%)
    17μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_articles_latest (Latest Articles) (720B) (0%)
    9μ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%)
    6μs
56 statements were executed, 8 of which were duplicates, 48 unique23.76ms578.08KB
  • SELECT @@SESSION.sql_mode;582μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?281μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 1123μ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)582μ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` = 1122μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`78μ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` = :guest64μ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`101μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 165μs1.15KB/plugins/system/helix3/helix3.php:247Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `evapj_menu` AS `m` LEFT JOIN `evapj_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.36ms164.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`718μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `evapj_content` WHERE `id` = :id186μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC68μ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` = 179μ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)134μ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` = 0151μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`496μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '518'954μs48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `evapj_content` AS `a` INNER JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)430μ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`109μ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)749μs4.05KBParams/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`221μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM evapj_fields AS a LEFT JOIN `evapj_languages` AS l ON l.lang_code = a.language LEFT JOIN evapj_users AS uc ON uc.id=a.checked_out LEFT JOIN evapj_viewlevels AS ag ON ag.id = a.access LEFT JOIN evapj_users AS ua ON ua.id = a.created_user_id LEFT JOIN evapj_fields_groups AS g ON g.id = a.group_id LEFT JOIN `evapj_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.41ms4.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_268'199μs656B/plugins/content/sigplus/core/core.php:3119Copy
  • SELECT viewid FROM evapj_sigplus_view WHERE folderid = 224 AND hash = 0x1c333218d1dfec570eb1bfee4a29f30b170μ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` = 224 AND NOT EXISTS (SELECT * FROM `evapj_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 267) AND depthnum <= 0468μs576B/plugins/content/sigplus/core/core.php:1845Copy
  • SELECT `langid` FROM `evapj_sigplus_language` WHERE `lang` = 'en'42μs536B/plugins/content/sigplus/core/core.php:329Copy
  • SELECT `countryid` FROM `evapj_sigplus_country` WHERE `country` = 'GB'35μ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_268' AND `viewid` = 267 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC1.29ms2.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_268' AND `viewid` = 267 AND `depthnum` <= 0 ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC74μ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 DESC360μs1.77KBParams/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`117μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'67μ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`759μ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.66ms22.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`106μ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`84μ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`80μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`79μ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.94ms22.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`139μ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`83μ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`76μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.modified DESC, a.created DESC LIMIT 31.33ms24.7KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`95μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`89μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context188μ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)161μ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)165μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://lsaa.org/index.php/projects/iconic-structures/518-hota-home-of-the-arts-outdoor-stage-2' AND `published` = 1837μs912B/plugins/system/jmap/jmap.php:849Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://lsaa.org/index.php/projects/iconic-structures/518-hota-home-of-the-arts-outdoor-stage-2'90μ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` = 1157μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT * FROM evapj_jmap_headings WHERE `linkurl` = 'https://lsaa.org/index.php/projects/iconic-structures/518-hota-home-of-the-arts-outdoor-stage-2'130μ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` = 141μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?401μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.19ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy