50 Martin Place - Glass Roof
50 Martin Place - Glass Roof

50 Martin Place - Glass Roof

 

This Project was entered into the 2016 LSAA Design Awards (5047)

Entrant: Taylor Thomson Whitting (Engineer)

Location: 50 Martin Place, Sydney.   Completed: Unknown   Client: Macquarie
Team: Johnson Pilton Walker, Taylor Thomson Whitting, Brookfield Multiplex, Sharvain Pacific Steel

Application: Glazed Roof over an Atrium.

Description: 

50 Martin Place was refurbished to provide a communal office from a very important heritage building. To increase light into the Atrium, the Atrium was increased in size by removing the perimeter slab, leaving the beams and columns. To provide maximum light, the roof was fabricated from glass. The final design incorporated a dome on steel trapezoid section suspending triple layer glazed panels, some of which were adjustable.

504701
504705
504706
504704
504703
504702
504701
504705

Design Brief

The client brief was to provide a unique glazed roof over an enlarged Atrium with minimum support system and dome roof that houses a range of staff and client functions and facilities over two additional levels, high speed glass lifts for client use from the banking chamber to the roof top facilities and a large light-filled central atrium incorporating interconnecting stairs between floors.

The project faced many challenge with regards to heritage requirements - building height limit, maintenance of Banking Chamber and Vault operations, a tight program, overall budget, structural framing and detailing to meet high quality visual and architectural requirements, fabrication processes and systems and safe construction techniques. These issues led to a unique and ambitious structural design, ultimately resolved through close collaboration between the engineer, architect, fabricator and head contractor.

Structural Systems

Roof Structure – Aesthetics and Originality

A fine and light steel structure constructed of fabricated sections is an expressed and celebrated feature of the 50 Martin Place rooftop addition and one of its central and significant architectural characteristics.

The design brief demanded a long span glass roof on an existing support structure that avoided any transfer structure beams, together with a requirement for a fine and unobtrusive glass support structure to maximize natural light. The building height restriction also required minimization of structural depth.

All structural elements were designed to efficient minimize structural sizes and for their visual impact. Each exposed steel connection was creatively designed and detailed to a high level of quality.

A range of roof options were considered with the architect during concept design taking into account aesthetics, structural scheme, heritage fabric, ESD, ventilation and consistency with the client brief.

The Beaux-Arts tradition of steel and glass domes and canopies formed the basis for an expressed steel structure solution being adopted. Visual lightness and the potential to celebrate the craft for fabrication and connections also confirmed steel’s suitability over other materials.

Roof Structure – Innovative Design

The curvature of the rook in both directions provides structural efficiency in terms of strength, serviceability and stability. The curved rafters allow axial compression to develop rather than pure bending, leading to design efficiency.

The smooth curves of the arched roof solution also resulted in much lower wind pressures, compared with the sharp edges of a traditional roof, with a wind tunnel test providing accurate wind pressures that also increased design efficiencies.

Generally, the steel arched rafters are spaced at 2.3m centres, aligning with the existing building’s module and grids. These rafters are supported by ring beams at the top and Level 11 with loads transmitted back to the existing building column grid at Level 10 via the internal raking columns and the external tri columns, eliminating transfer structure. The lateral force at the bottom of the raking column is supported by existing Level 10 diaphragm floor.

Visual lightness is enhanced with a tapering trapezoidal rafter cross section, and by eliminating a hierarchy of primary and secondary members with a 2.3 structural intervals. Tri-columns collect groups of rafters to transfer loads to existing structure.

The introduction of the internal raking columns reduced the span and provided a better balance to the spans. These break the spans into 12.4m, 11.6m and 12.4m spans, By introducing pins at the top of the raking column and a bolted joint at the natural inflection point, bending moments in the rafters and deflections are significantly reduced.

Lightness of the structure was particularly important in the longer central span, the appearance of such a structure ruling out traditional techniques for restraining long spans against buckling, such as “fly-bracing”.

Showcasing the craftsmanship of the steel had been vigorously pursued by the entire design team. Overcoming the architectural implications, passive fire protection to the steelwork was dealt with in the following ways:

  • Structural analysis – In demonstrating structural principles and fire engineering we were able to reduce the number of elements requiring protection, Furthermore, we were able to reduce the fire rating to 60 minutes which enabled a wider variety of products to be utilized.
  • Intumescent coatings in lieu of overcladding – in consultation with our coatings specialist and the market, we concluded that a site-applied, water based intumescent coating was the most appropriate product for the project.

We utilized a Promat acrylic intumescent which was able to be site-applied due its low toxicity and fumes and ability to be sanded and prepared for application of the finished top cat.

Roof Structure – Efficient Use of Materials

A total of 200 tonnes of Australia-made steel that was utilized for the whole project with the roof compromising of 27 tonnes of exposed steelwork. All rafters were fabricated into box sections using laser-cut profile plates.

A collaborative and holistic design process produced a highly efficient structural design. The arched and domed form capitalizes on the strength of steel and its ability to minimize and efficiently resolve loads.

The use of high strength steelwork and innovative structural designs allowed the total steel quantity to be reduced by over 30% in comparison to a conventional design.

Comfort of roof structure

The roof comprises a triple glazed unit with a metalized mesh with micro shades inbuilt into the glazing cavity. This arrangement is the first of its kind in Australia. The curved roof was triple glazed mesh ensured that a uniform appearance was achieved for views while also responding to sun movement. Micro shades create the visual effect of high transparency, while also being a highly effective shaded element – a portion of the roof is always blocking solar radiation coming into the building.

Extensive thermal modelling was conducted to inform the roof and ensure appropriate material performance for the roof elements. The design achieves optimal thermal comfort and code compliance for energy efficiency. Thermal comfort modelling demonstrated that under worst case conditions a 90% level of satisfaction (Predicted Mean Vote – 0.5 to 0.5) would be achieved. The thermal comfort conditions were successfully achieved in design, despite the initial challenges of having a fully glazed structure highly exposed to solar radiation.

Environmentally Sustainable Design, Engineering and Construction

A key requirement of Macquarie’s brief was to achieve a 6 star Green rating, representing ‘World Leadership’ in sustainability. The structural design met this requirement with a maximum Green Star Rating awarded for the steelwork including dematerialization points for the efficient design of the new roof.

Innovative sustainability is evident throughout the project with many initiatives including building services and façade. The historic building has been truly transformed as a completely modernized building which will support the building for decades to come.

Materials

The two basic materials were structural steel and glazing, chosen to provide maximum light into the enlarged atrium. The steelwork was fabricated and erected by Pacific Steel and the glazing was supplied by Sharvain,

Fabrication

The curved roof structure was designed to be prefabricated as much as possible. This is not only improved the program and safety, but reduced the extent of site connections improving the aesthetics of the exposed structural elements. All site connections are bolted connections using high strength pins where posed and standard bolts were hidden.

Due to tight tolerance in the design, maximizing offsite fabrication not only provided a high level of accuracy for the shape and curvature required for the roof but it also ensured all exposed connections and welds could be carried out in a controlled environment.

Collaboration, Construction and Maintenance

Engagement of Design and Construction Teams

Early involvement of the builder, and engagement of a structural steel draftsman to commence work, mitigated delay and flushed out all set out and construction issues. Section lengths, fabrication sizes, transport and erection sequencing were discussed and carefully managed to minimize joints in the exposed steelwork, to cope with tight tolerances, and ensure the curvature of the roof was maintained. The erection sequence of the glass over the steelwork was also carefully managed to minimize deformation of the dome shape.

Effective use of BIM

3D surveying of the existing building was carried out at the early stage of the project to enable much needed accuracy in the 3D modelling, fabrication and to ensure a tidy and clean connection at the interface with the heritage fabric.

The roof dome was analyzed using Strand7, a 3D finite element program. Applied loads from glass and wind were applied in patches to suit the wind tunnel modelling and installation sequencing. The structural steel was modelled and detailed using Revit.

The overall design used physical modelling, CAD modelling and documentation incorporating the ASI AESS Guide.

Working with the Fabricator/Erector

From the onset, a collaborative approach was adopted by all team members, including the structural engineer, architect, head contractor, draftsman and fabricator.

Whilst the detailing discussions could be robust, it was the passion for the Project amongst all members that made the communication so effective. Weekly face-to-face workshops were held with all team members throughout the design development.

With the in-depth understanding of the building, its requirements and the design intent there were far fewer RFIs issued than would normally be expected for a building of this nature.

Ref: sliders/DA2016/Cat5/5047 DP ID 242


27.52MBMemory Usage313msRequest Duration
Joomla! Version5.2.5
PHP Version8.2.28
Identityguest
Response200
Templateflex
Database
Server
mysql
Version
10.6.21-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:59 [ "USER" => "lsaa" "HOME" => "/home/lsaa" "SCRIPT_NAME" => "/index.php" "REQUEST_UR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743874614 "last" => 1743874614...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.75MB) (25.37ms)
  • afterInitialise (7.79MB) (83.94ms)
  • afterRoute (1.16MB) (25.03ms)
  • beforeRenderComponent com_content (1.04MB) (12.89ms)
  • Before Access::preloadComponents (all components) (484.09KB) (5.14ms)
  • After Access::preloadComponents (all components) (118.48KB) (1.05ms)
  • Before Access::preloadPermissions (com_content) (1.73KB) (25μs)
  • After Access::preloadPermissions (com_content) (570.84KB) (1.7ms)
  • Before Access::getAssetRules (id:448 name:com_content.article.347) (18.65KB) (56μs)
  • After Access::getAssetRules (id:448 name:com_content.article.347) (25.43KB) (496μs)
  • afterRenderComponent com_content (5.53MB) (61.73ms)
  • afterDispatch (78.72KB) (927μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.01MB) (34.07ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (188.3KB) (10.07ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (10μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (31.55KB) (441μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (70μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (6.84ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (9μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (143μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (52μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.08KB) (607μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (7μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (144μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (50μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (273.94KB) (7.87ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (9μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (231μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (52μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (239.57KB) (6.19ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (10μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (200μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (52μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (70.29KB) (4.91ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (22μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (7.34KB) (176μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (94μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.59KB) (1.15ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (148μs)
  • afterRender (1MB) (19.29ms)
  • 1 x afterInitialise (7.79MB) (26.81%)
    83.94ms
    1 x afterRenderComponent com_content (5.53MB) (19.72%)
    61.73ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.01MB) (10.88%)
    34.07ms
    1 x afterLoad (3.75MB) (8.1%)
    25.37ms
    1 x afterRoute (1.16MB) (8%)
    25.03ms
    1 x afterRender (1MB) (6.16%)
    19.29ms
    1 x beforeRenderComponent com_content (1.04MB) (4.12%)
    12.89ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (188.3KB) (3.22%)
    10.07ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (273.94KB) (2.52%)
    7.87ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.18%)
    6.84ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (239.57KB) (1.98%)
    6.19ms
    1 x Before Access::preloadComponents (all components) (484.09KB) (1.64%)
    5.14ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (70.29KB) (1.57%)
    4.91ms
    1 x After Access::preloadPermissions (com_content) (570.84KB) (0.54%)
    1.70ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.59KB) (0.37%)
    1.15ms
    1 x After Access::preloadComponents (all components) (118.48KB) (0.34%)
    1.05ms
    1 x afterDispatch (78.72KB) (0.3%)
    927μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.08KB) (0.19%)
    607μs
    1 x After Access::getAssetRules (id:448 name:com_content.article.347) (25.43KB) (0.16%)
    496μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (31.55KB) (0.14%)
    441μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (0.07%)
    231μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (0.06%)
    200μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (7.34KB) (0.06%)
    176μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.05%)
    148μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.05%)
    144μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.05%)
    143μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.03%)
    94μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.02%)
    70μs
    1 x Before Access::getAssetRules (id:448 name:com_content.article.347) (18.65KB) (0.02%)
    56μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.02%)
    52μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    52μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.02%)
    52μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    50μs
    1 x Before Access::preloadPermissions (com_content) (1.73KB) (0.01%)
    25μs
    1 x beforeRenderModule mod_articles_latest (Recent Projects) (720B) (0.01%)
    22μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_articles_latest (Latest Articles) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (0%)
    7μs
65 statements were executed, 24 of which were duplicates, 41 unique45.35ms818.92KB
  • SELECT @@SESSION.sql_mode;100μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?1.4ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 11.43ms1.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)5.51ms944BParams/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` = 1125μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`441μ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` = :guest498μ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`133μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 195μ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`11.4ms164.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`384μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC298μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • 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` = 1107μs16.89KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • 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,:preparedArray43,:preparedArray44)264μs7.81KBParams/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` = 0213μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`440μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '347'1.38ms1.3KB/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)962μs46.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`138μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `evapj_contentitem_tag_map` AS `m` INNER JOIN `evapj_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)1.13ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`124μ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 ASC88μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 24271μs520B/components/com_droppics/models/frontcategories.php:143Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 24263μs0B/components/com_droppics/models/frontcategories.php:144Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 24277μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 24239μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 22780μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 22752μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT theme FROM evapj_droppics WHERE id='242'47μs536B/administrator/components/com_droppics/models/gallery.php:212Copy
  • SELECT theme FROM evapj_droppics WHERE id='242'27μs0B/administrator/components/com_droppics/models/gallery.php:213Copy
  • SELECT params FROM evapj_droppics WHERE id='242'56μs536B/administrator/components/com_droppics/models/gallery.php:230Copy
  • SELECT p.id,p.file,concat(p.file,"") as filever,p.position,p.alt,p.title,p.params as picture_params,g.theme,g.params,g.id AS id_gallery FROM evapj_droppics AS g RIGHT JOIN evapj_droppics_pictures as p ON g.id=p.id_gallery WHERE g.id='242' ORDER BY position ASC949μs1.42KB/administrator/components/com_droppics/models/gallery.php:172Copy
  • SELECT p.id,p.file,concat(p.file,"") as filever,p.position,p.alt,p.title,p.params as picture_params,g.theme,g.params,g.id AS id_gallery FROM evapj_droppics AS g RIGHT JOIN evapj_droppics_pictures as p ON g.id=p.id_gallery WHERE g.id='242' ORDER BY position ASC48μs2.5KB/administrator/components/com_droppics/models/gallery.php:173Copy
  • SELECT c.id as id_category,c.title as category_title FROM evapj_categories as c WHERE c.parent_id=242 AND c.extension="com_droppics" ORDER BY c.lft ASC37μs576B/components/com_droppics/models/frontcategories.php:51Copy
  • SELECT c.id as id_category,c.title as category_title FROM evapj_categories as c WHERE c.parent_id=242 AND c.extension="com_droppics" ORDER BY c.lft ASC30μs0B/components/com_droppics/models/frontcategories.php:54Copy
  • SELECT c.id as id_category,c.title as category_title,p.id as id_picture,p.file as picture_file,concat(p.file,"") as picture_ver,p.title as picture_title,p.alt as picture_alt FROM evapj_categories as c LEFT JOIN evapj_droppics_pictures as p ON p.id_gallery = c.id WHERE c.id = (SELECT x.parent_id FROM evapj_categories as x WHERE x.id=242) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC42μs896B/components/com_droppics/models/frontcategories.php:118Copy
  • SELECT c.id as id_category,c.title as category_title,p.id as id_picture,p.file as picture_file,concat(p.file,"") as picture_ver,p.title as picture_title,p.alt as picture_alt FROM evapj_categories as c LEFT JOIN evapj_droppics_pictures as p ON p.id_gallery = c.id WHERE c.id = (SELECT x.parent_id FROM evapj_categories as x WHERE x.id=242) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC30μs0B/components/com_droppics/models/frontcategories.php:121Copy
  • 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 DESC1.72ms2.09KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `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`104μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'91μs16.91KB/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`3.15ms2.19KBParams/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 43.22ms22.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`112μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`89μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `evapj_categories` AS `s` INNER JOIN `evapj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`96μ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.45ms62.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`120μs84.25KBParams/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`88μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `evapj_content` AS `a` LEFT JOIN `evapj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `evapj_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `evapj_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `evapj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `evapj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `evapj_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.modified DESC, a.created DESC LIMIT 31.74ms68.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`113μ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`509μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context216μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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)188μs46.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)161μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://mail.lsaa.org/projects/other-structures/347-50-martin-place-glass-roof' AND `published` = 1661μs912B/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://mail.lsaa.org/projects/other-structures/347-50-martin-place-glass-roof'117μs640B/plugins/system/jmap/jmap.php:968Copy
  • 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` = 1159μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'56μs536B/components/com_baforms/src/Helper/BaformsHelper.php:731Copy
  • SELECT `key` FROM evapj_baforms_api WHERE service = 'balbooa_activation'49μs536B/components/com_baforms/src/Helper/BaformsHelper.php:716Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'53μs536B/components/com_baforms/src/Helper/BaformsHelper.php:731Copy
  • SELECT `key` FROM evapj_baforms_api WHERE service = 'balbooa_activation'40μs536B/components/com_baforms/src/Helper/BaformsHelper.php:716Copy
  • SELECT * FROM evapj_jmap_headings WHERE `linkurl` = 'https://mail.lsaa.org/projects/other-structures/347-50-martin-place-glass-roof'164μs752B/plugins/system/jmap/jmap.php:1192Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `evapj_jmap_text_replacements` WHERE `published` = 152μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?585μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?949μs11.58KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy