SKIPPS Retractable Shade Structure
SKIPPS Shade Structure

SKIPPS Shade Structure

 

APPLICATION OF PROJECT:

To provide a retractable shade structure to an existing exposed school quadrangle courtyard in St Kilda, Victoria, that offered flexibility to a highly utilized space. Without detracting from the existing heritage school built in 1873 and working with a 1970’s addition, the project needed to remain respectful of the surrounds whilst providing a vibrant new design proposition and considered functionality. The brief was to provide shade and weather protection to a large external quadrangle, central to major school operations, assemblies, concerts, play area and general shelter.

LSAA2011DA179105
LSAA2011DA179104
LSAA2011DA179103
LSAA2011DA179102
LSAA2011DA179101
LSAA2011DA179100
LSAA2011DA179111
LSAA2011DA179110
LSAA2011DA179109
LSAA2011DA179108
LSAA2011DA179106
LSAA2011DA179107

PROJECT DESCRIPTION:

Carefully inserted into the existing courtyard, the new structure engages with the existing conditions on a number of levels. Spatially the area is now framed and defined yet remains light and open. The sense of space is not compromised yet is enhanced by a flexible shelter that can retract back to a simple steel butterfly shaped frame almost as if it has gently landed in the quadrangle.

The existing chromatic range of brick colours of the old school and safety concerns led to the utilization of known St. Kilda colours of red, white and black for the steel frame. To further enliven the project, the retracted fabric utilizes colours reminiscent of beach towels, deck chairs, colour swatches and op-art.

The retractable roof structure provides a much needed amenity to the main assembly area quadrangle. Students, staff, parents and the general public are all beneficiaries of the new system providing weather protection, better seating, landscaping and site lines as well as becoming a central focus for the school.

We attempted to design the project with the children’s point of view in mind. The steelwork is painted in the St. Kilda football team colours, to give the children a sense of their locality but also as a safety measure: the white strip is at eye level and discourages accidents. When the roof is retracted the colour palette of a rainbow pattern (warm tones) is revealed amongst other metaphors.

Essentially, the structure is an efficient, light weight, cost effective solution that melds the many design parameters involved into a considered aesthetic proposal that unifies but not dominates the central core outdoor space of the primary school. It is a system that can be extended if required and works to the full extent of simple retractable shade systems currently available.

The lightweight steel frame with its retractable roof has allowed the installation to have a strong visual and operational effect when enclosed yet when retracted, almost disappears, allowing the heritage building to be still fully appreciated.

DESIGN / FABRICATION / INSTALLATION BRIEF

The brief was two fold: one to enable assemblies and concerts to take place regardless of rain and two, to provide a large external area that is shaded from the sun on hot days. The outdoor space that was to be roofed, is between the 19th century historic school building and the 1970’s additions. The new roof had to compliment the 19th century buildings and add some life to the plainer brown brick more recent additions. We also did not want to cover or conceal these building rather provide an open legible and light framework to enhance the overall architectural paradigm.

The school council initially were considering covering the area with a permanent structure that would have ruined the space. We presented our design ideas and methodology that emphasized a retractable roof operated by remote control so as to allow maximum flexibility of the space, allowing the area to remain open to the sky, partially open or completely closed if required. The column spacing of the support structure was critical to work within the functions of the various building operations, level changes, service locations and water drainage. This was also achieved to maximize the span available for a retractable shade of 8.0m. The butterfly form enabled air and light to still enter the area even when the roof is fully enclosed. Landscape modifications and formed concrete seating (to be mosaic tiled by the students) where added to the periphery of the structure to enhance site lines and complete the ensemble.

STRUCTURAL SYSTEMS

The structural system is a simple post and beam steel structure to house the retractable coloured PVC roof driven by  small concealed motors. The placement of the columns, relative to the span of the roof system and the existing steps of the quadrangle, fitted well into the existing space as a double wing or butterfly shape. The collection of rainwater is emphasized by the central v shaped gutter which deposits water back to the existing building roof.  Steel rib supports were simply expressed in the custom formed , black painted gutter. The pitch of the roof also met with design requirements of drainage, self cleaning and operation.

MATERIALS 

Steel frame structure for lightweight , strength and ease of erection.

Concrete footings and base seats which re used existing bluestone blocks for planters and walling

Coloured PVC translucent shade material for range of warm glowing light quality.

FABRICATION

The steel frame itself became a design object whereby all the single column locations were doubled up to form narrow twin columns with small bracing plates. This avoided the traditional heavier in appearance I beam or square column, allowing the play of light through columns and roof over to float. Approximately 1.0m cubic concrete footings were poured below the blacktop surface and the columns secured by plates and bolts according to design wind loads and engineering requirements.

The entire steel frame was bolted together in place after careful sizing, cutting and assembly for ease of installation and no on site welding. It was also factory painted in red and black before delivery and the white strips added post assembly. The multi coloured retractable shade system was then installed with its ribs and runners neatly fitting into the steel frame for a smooth operation.

COLLABORATION, CONSTRUCTION AND MAINTENANCE

The project involved many aspects of a design and construct project in a sensitive heritage and public location. It required approval of the School Council and funding by the BER scheme of government stimulus package and had to meet strict budget requirements. It gained local Council approval and met BCA requirements and importantly the St.Kilda colours had to be (reluctantly) approved by the Collingwood supporting school principal! The construction and methodology was a team effort of the steel fabricators, shade structure installers, landscape consultants, structural engineers and overall design and project management by the architects.

Awarded Architecture Award for best Small Project Architecture, Australian Institute of Architects 2010, Victorian Chapter.

Finalist in the National Architecture Awards, AIA 2010.

Published Monument magazine Jan 2010.

CREDITS

Project Number: 1791

Title: SKIPPS SHADE STRUCTURE

Location: St. Kilda

Entrant:  Grant Amon Architects P/L + Nervegna Reed Architecture

Role:  project management

Client:  St.Kilda Park Primary School

Architect: Grant Amon & Toby Reed

Structural Engineer: Design 79 Building & Pool Consultants P/L

Spec Consultant: Melbourne Shade Systems (Retractable  Shade Consultant)

Others:  Anthony Middling & Assoc. Building Surveyors Naturelinks Landscape Management P/L

Builder:  Big Red Shade Products

Fabricator:  Big Red Shade Products & Melbourne Shade

Steelwork etc:


27.529MBMemory Usage321msRequest 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" => 1743860003 "last" => 1743860003...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.75MB) (55.51ms)
  • afterInitialise (7.79MB) (70.55ms)
  • afterRoute (1.16MB) (12.12ms)
  • beforeRenderComponent com_content (1.04MB) (9.88ms)
  • Before Access::preloadComponents (all components) (484.09KB) (4.13ms)
  • After Access::preloadComponents (all components) (118.48KB) (613μs)
  • Before Access::preloadPermissions (com_content) (1.73KB) (17μs)
  • After Access::preloadPermissions (com_content) (570.84KB) (1.28ms)
  • Before Access::getAssetRules (id:332 name:com_content.article.247) (18.65KB) (60μs)
  • After Access::getAssetRules (id:332 name:com_content.article.247) (25.43KB) (380μs)
  • afterRenderComponent com_content (5.54MB) (67.05ms)
  • afterDispatch (78.72KB) (904μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.01MB) (34.73ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (188.3KB) (10.81ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (12μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (31.55KB) (495μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (77μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (7.26ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (10μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (173μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (70μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.08KB) (665μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (8μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (154μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (57μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (273.94KB) (8.33ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (11μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (258μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (63μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (239.57KB) (6.63ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (9μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (222μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (64μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (70.29KB) (4.3ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (8μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (7.34KB) (208μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (139μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (1.32ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (152μs)
  • afterRender (1MB) (19.15ms)
  • 1 x afterInitialise (7.79MB) (21.97%)
    70.55ms
    1 x afterRenderComponent com_content (5.54MB) (20.88%)
    67.05ms
    1 x afterLoad (3.75MB) (17.28%)
    55.51ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (2.01MB) (10.81%)
    34.73ms
    1 x afterRender (1MB) (5.96%)
    19.15ms
    1 x afterRoute (1.16MB) (3.78%)
    12.12ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (188.3KB) (3.37%)
    10.81ms
    1 x beforeRenderComponent com_content (1.04MB) (3.08%)
    9.88ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (273.94KB) (2.59%)
    8.33ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.26%)
    7.26ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (239.57KB) (2.06%)
    6.63ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (70.29KB) (1.34%)
    4.30ms
    1 x Before Access::preloadComponents (all components) (484.09KB) (1.29%)
    4.13ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (0.41%)
    1.32ms
    1 x After Access::preloadPermissions (com_content) (570.84KB) (0.4%)
    1.28ms
    1 x afterDispatch (78.72KB) (0.28%)
    904μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.08KB) (0.21%)
    665μs
    1 x After Access::preloadComponents (all components) (118.48KB) (0.19%)
    613μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (31.55KB) (0.15%)
    495μs
    1 x After Access::getAssetRules (id:332 name:com_content.article.247) (25.43KB) (0.12%)
    380μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (0.08%)
    258μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (0.07%)
    222μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (7.34KB) (0.06%)
    208μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.05%)
    173μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.05%)
    154μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.05%)
    152μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    139μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.02%)
    77μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.02%)
    70μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.02%)
    64μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    63μs
    1 x Before Access::getAssetRules (id:332 name:com_content.article.247) (18.65KB) (0.02%)
    60μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    57μs
    1 x Before Access::preloadPermissions (com_content) (1.73KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_articles_latest (Latest Articles) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_articles_latest (Recent Projects) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
65 statements were executed, 24 of which were duplicates, 41 unique32.42ms819.27KB
  • SELECT @@SESSION.sql_mode;116μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?1.6ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 1160μ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)1.74ms944BParams/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` = 1150μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`64μ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` = :guest54μ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`77μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 154μ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.06ms164.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`750μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC89μ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` = 198μ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)125μ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` = 0139μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`499μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '247'5.49ms1.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)454μ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`773μ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)658μs3.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`156μ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.08ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 1761.07ms520B/components/com_droppics/models/frontcategories.php:143Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 17654μs0B/components/com_droppics/models/frontcategories.php:144Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 17637μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 17661μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 173636μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 17355μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT theme FROM evapj_droppics WHERE id='176'38μs536B/administrator/components/com_droppics/models/gallery.php:212Copy
  • SELECT theme FROM evapj_droppics WHERE id='176'28μs0B/administrator/components/com_droppics/models/gallery.php:213Copy
  • SELECT params FROM evapj_droppics WHERE id='176'330μ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='176' ORDER BY position ASC786μs1.52KB/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='176' ORDER BY position ASC56μ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=176 AND c.extension="com_droppics" ORDER BY c.lft ASC42μ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=176 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=176) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC46μ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=176) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC32μ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 DESC641μs2.34KBParams/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`123μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'70μ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`1.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.45ms22.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`138μ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`100μ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`92μ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.74ms62.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`156μ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`108μ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.32ms68.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`118μ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`104μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context424μ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)157μ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)126μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://mail.lsaa.org/projects/small-fabric-structures/247-skipps-shade-structure' AND `published` = 1792μs912B/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://mail.lsaa.org/projects/small-fabric-structures/247-skipps-shade-structure'83μ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` = 1180μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'54μs536B/components/com_baforms/src/Helper/BaformsHelper.php:731Copy
  • SELECT `key` FROM evapj_baforms_api WHERE service = 'balbooa_activation'42μs536B/components/com_baforms/src/Helper/BaformsHelper.php:716Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'34μs536B/components/com_baforms/src/Helper/BaformsHelper.php:731Copy
  • SELECT `key` FROM evapj_baforms_api WHERE service = 'balbooa_activation'32μs536B/components/com_baforms/src/Helper/BaformsHelper.php:716Copy
  • SELECT * FROM evapj_jmap_headings WHERE `linkurl` = 'https://mail.lsaa.org/projects/small-fabric-structures/247-skipps-shade-structure'135μ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` = 175μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?197μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.09ms11.58KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy