St Margaret’s Velarium Variable Shade - Final
St Margaret's Velarium Retractable Shade System, Ascot, QLD (DA 2022 Entry by MakMax)

St Margaret's Velarium Retractable Shade System, Ascot, QLD (DA 2022 Entry by MakMax)

LSAA 2022 Plaques 0002APPLICATION OF PROJECT:       

Swimming pool retractable shade cover         

PROJECT DESCRIPTION:

Challenged to create an innovative retractable roof for the swimming pool in the new sports precinct development for St Margaret’s Anglican School in Brisbane, Australia, we designed, engineered, developed, tested, fabricated and installed the Velarium Variable Shade System.

The Velarium shade system developed for St Margaret’s is an advanced motorised retractable shade system. This variable shade system is created using opposing sets of architectural-grade PVC mesh shade panels, supported on a cable grid that spans freely across the width of a pool. The Velarium system allows for large spans to be covered with minimal visible structural elements above the pool.

The system can be operated directly from a master control panel or a remote hand control. Each Velarium shade section is retracted and deployed by an independent motor, giving the operator the flexibility to open or close individual panel sections to suit their requirements. This clever design allows for panels to be deployed in almost any position between fully open and fully closed, and can be controlled by a single person.

DESIGN / FABRICATION / INSTALLATION BRIEF

Blight Rayner Architects initially approached us with a challenge to design and develop a retractable roof concept for the swimming pool in the new sports precinct development at St Margaret’s Anglican School in Brisbane.

713301-factory-mockup-testingjpg
713302-installation-steelworkjpg
713304-installation-first-paneljpg
713303-installation-steelwork-2
713306-installation-support-cable
713305-installation-shade-panel-detailjpg
713307-cable-motor-unit-detailjpg
713308-installation-leading-battensJPG
713309-installation-fabric-panelsjpg
713310-FINAL-1jpg
713311-FINAL-Aerial-1jpg
713312-FINAL-Aerial-2jpg
713314-FINAL-Hero-2
713313-FINAL-Herojpg

Well known for our extensive portfolio of tensile membrane fabric structures for schools, universities and learning centres, we generally work in fixed lightweight tensile structures. The brief for the shade cover over the pool at St Margaret’s was to optimise the operational costs and seasonal flexibility of the pool by controlling the levels of sunshine onto the pool’s surface. This was to be achieved with a series of motorised mesh fabric panels that could open and close at the push of a button.

Our engineering team relish design challenges like this. Being designer-builders, we had the ability to design, test, check and refine our ideas to ensure what came to site would work as intended. Complexities of high cable loads, precambering of steelwork and specific erection sequences were all coordinated with the head contractor and our partner subbies. Our extensive education industry experience means the design always progressed to best meet the school’s needs and operational requirements.

STRUCTURAL SYSTEMS

Intended to be used as sun protection while students are using the pool, the 40m x 30m space is covered by a structural grid of cables spaced 2.5m apart, which in turn support 4 opposing pairs of fully motorised fabric shade sections. The 150m2 opposing panels close from the outside, meeting in the centre. A drive cable tensioning system, including a self-balancing stainless-steel drive cable with pulley system, is incorporated into each panel section.

The roof support-system is designed for minimal maintenance by combining corrosion resistant aluminium battens with a robust stainless-steel cable-supported operating system.

We provided detailed reaction loads to supporting steel work structure to inform the structural design and required prechamber of cantilever steel truss members.

With safety at the forefront of our design for education sector projects, the St Margaret’s pool roof has been engineered to withstand sudden wind gusts of up to 125km/hr while closed, however it features a fail-safe function of automatically retracting when wind speeds rise about 27km/hr, protecting the fabric and the cabling.

MATERIALS

Soltis FT381 from Serge Ferrari was chosen for the retracting roof panels. Lightweight, durable and flexible, Soltis FT381 is a high translucency PVC mesh material that allows natural light to enter, while protecting swimmers and spectators against harmful UV rays.

The premium look, as well as the high thermal and solar protection required to shade the pool area were the main reasons Soltis FT381 was chosen for this project. Normally installed in tensioned applications, such as facades or static shade sails, a number of innovative components were engineered and incorporated into the membrane fabrication stage of the St Margaret’s project in order for the shade panels to behave in their designed manor during opening, closing and in windy conditions.

A number of innovative proprietary components were incorporated into the fabric panels to stabilise the fabric folds as the individual sections concertina in and out. Particular attention was paid to leading-edge extrusions and the fabric fixing systems to avoid the slack panel sections fouling the cables while under motion, allowing them to run smoothly along the cable grid, even in high-wind conditions.

Aluminium extrusions, which supported the leading edge of the fabric panels, were threaded onto the structural cables using bespoke nylon blocks to allow them to slide with minimal friction. The roof support-system is designed for minimal maintenance by combining corrosion resistant aluminium battens with a robust stainless-steel cable-supported operating system.

Completing the project’s low-impact visuals, the roof retraction is made possible by four 0.75kW (IP55) Electric Motors which are hidden in the upper steel structure.

FABRICATION

Key to the development of these innovative components was the construction of a full-size mock-up of one set of opposing fabric panels in the carpark of our fabrication facility. Extensive testing of each component and how they effected the behaviour of the fabric under motion ensured that the new system was proven in a practical way prior to the systems initial installation at St Margaret’s. A solid white PVC of similar flexibility and strength was used for testing to help us see the folding behaviour.

The membrane panels were fabricated in our Brisbane factory, with other structural elements, such as cables, extrusions and battens outsourced local manufactures.

COLLABORATION, CONSTRUCTION AND MAINTENANCE

With almost 700m of cables to install across a 30m open span, maintaining extremely tight tolerance in the erection of the steel structure system was vital in order to ensure the cables were perfectly straight. A few millimeters offline at one end of the structure would mean slipping or snagging cables at the other end.

A great deal of hands-on work was conducted onsite by the whole team, with our lead engineers frequently visiting site during construction phase, surveying each section to ensure structural integrity, followed by rigorous onsite testing of the moving components

For such a new, innovative application, we provided as part of the contract a series of inspections, including a close-out testing phase, a one-month full engineering inspection and a follow-up 3-month inspection top ensure the moving system was still function as expected. 

COLOUR IMAGES

  • 7133_01-factory-mockup-testing.jpg
  • 7133_02-installation-steelwork
  • 7133_04-installation-steelwork-2.jpg
  • 7133_03-installation-first-panel.jpg
  • 7133_05-installation-shade-panel-detail.jpg
  • 7133_06-installation-support cable
  • 7133_07-cable-motor-unit-detail.jpg
  • 7133_08-installation-leading-battens.JPG
  • 7133_09-installation-fabric-panels.jpg
  • 7133_10-FINAL-1.jpg
  • 7133_11-FINAL-Aerial-1.jpg
  • 7133_12-FINAL-Aerial-2.jpg
  • 7133_13-FINAL-Hero.jpg
  • 7133_14-FINAL-Hero-2

 

OTHER INFORMATION

  • 7133-Testing-the-Retraction-Cycle.mp4
  • 7133_St Margarets Velarium Video.mp4

 
PROJECT CREDITS

Project ID Number   7133
Project Name St Margaret's Velarium Variable Shade
Project Location      11 Petrie Street
City / Suburb Ascot
State  QLD
Country        AUS
Postcode      4007
GPS Location          -27.43059,153.0474413,1026m
Completion Date     Sep-20
Preferred Category  7. Special Applications & Innovations
         
Entrant Name         MakMax Australia
Address        133 Lavarack Ave
City / Suburb Eagle Farm
State  QLD
Country        AUS
Postcode      4009
Contact Phone Number      736335900
Mobile Number       
Email Address         alastairM@makmax.com.au
Website Address     www.makmax.com.au
Entrant Type / Role Designer / Engineer / Fabricator / Installer
Project Client Tomkins Commercial & Industrial Builder Pty Ltd
Project Architect     Blight Rayner Architects
Structural Engineer  Keagan Leamy - MakMax Australia
Building Contractor Tomkins Commercial & Industrial Builder Pty Ltd
Fabricator(s) MakMax Australia
Others OzRig


 


27.658MBMemory Usage334msRequest 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" => 1743277484 "last" => 1743277484...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.75MB) (31.65ms)
  • afterInitialise (7.79MB) (62.71ms)
  • afterRoute (1.16MB) (17.76ms)
  • beforeRenderComponent com_content (1.04MB) (8.97ms)
  • Before Access::preloadComponents (all components) (484.09KB) (6.73ms)
  • After Access::preloadComponents (all components) (118.48KB) (574μs)
  • Before Access::preloadPermissions (com_content) (1.73KB) (19μs)
  • After Access::preloadPermissions (com_content) (570.84KB) (1.28ms)
  • Before Access::getAssetRules (id:1322 name:com_content.article.690) (18.65KB) (58μs)
  • After Access::getAssetRules (id:1322 name:com_content.article.690) (25.43KB) (332μs)
  • afterRenderComponent com_content (5.73MB) (77.36ms)
  • afterDispatch (14.72KB) (611μs)
  • beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (1.9MB) (30.8ms)
  • afterRenderRawModule mod_menu (Main Menu - Off Canvas) (188.3KB) (10.46ms)
  • beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (9μs)
  • afterRenderModule mod_menu (Main Menu - Off Canvas) (31.55KB) (361μs)
  • beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (63μs)
  • afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (6.86ms)
  • beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (9μs)
  • afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (181μs)
  • beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (59μs)
  • afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.08KB) (541μs)
  • beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (7μs)
  • afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (134μs)
  • beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (52μs)
  • afterRenderRawModule mod_articles_popular (Popular Articles) (273.94KB) (8.29ms)
  • beforeRenderModule mod_articles_popular (Popular Articles) (720B) (12μs)
  • afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (331μs)
  • beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (83μs)
  • afterRenderRawModule mod_articles_latest (Latest Articles) (239.57KB) (6.25ms)
  • beforeRenderModule mod_articles_latest (Latest Articles) (720B) (11μs)
  • afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (278μs)
  • beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (101μs)
  • afterRenderRawModule mod_articles_latest (Recent Projects) (51.14KB) (4.01ms)
  • beforeRenderModule mod_articles_latest (Recent Projects) (720B) (11μs)
  • afterRenderModule mod_articles_latest (Recent Projects) (7.34KB) (249μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (140μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (1.37ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (172μs)
  • afterRender (1.01MB) (54.17ms)
  • 1 x afterRenderComponent com_content (5.73MB) (23.16%)
    77.36ms
    1 x afterInitialise (7.79MB) (18.77%)
    62.71ms
    1 x afterRender (1.01MB) (16.22%)
    54.17ms
    1 x afterLoad (3.75MB) (9.47%)
    31.65ms
    1 x beforeRenderRawModule mod_menu (Main Menu - Off Canvas) (1.9MB) (9.22%)
    30.80ms
    1 x afterRoute (1.16MB) (5.32%)
    17.76ms
    1 x afterRenderRawModule mod_menu (Main Menu - Off Canvas) (188.3KB) (3.13%)
    10.46ms
    1 x beforeRenderComponent com_content (1.04MB) (2.69%)
    8.97ms
    1 x afterRenderRawModule mod_articles_popular (Popular Articles) (273.94KB) (2.48%)
    8.29ms
    1 x afterRenderRawModule mod_menu (PK_Footer_Menu) (9.23KB) (2.05%)
    6.86ms
    1 x Before Access::preloadComponents (all components) (484.09KB) (2.01%)
    6.73ms
    1 x afterRenderRawModule mod_articles_latest (Latest Articles) (239.57KB) (1.87%)
    6.25ms
    1 x afterRenderRawModule mod_articles_latest (Recent Projects) (51.14KB) (1.2%)
    4.01ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (29.71KB) (0.41%)
    1.37ms
    1 x After Access::preloadPermissions (com_content) (570.84KB) (0.38%)
    1.28ms
    1 x afterDispatch (14.72KB) (0.18%)
    611μs
    1 x After Access::preloadComponents (all components) (118.48KB) (0.17%)
    574μs
    1 x afterRenderRawModule mod_custom (LSAA_Logo_Only) (14.08KB) (0.16%)
    541μs
    1 x afterRenderModule mod_menu (Main Menu - Off Canvas) (31.55KB) (0.11%)
    361μs
    1 x After Access::getAssetRules (id:1322 name:com_content.article.690) (25.43KB) (0.1%)
    332μs
    1 x afterRenderModule mod_articles_popular (Popular Articles) (5.99KB) (0.1%)
    331μs
    1 x afterRenderModule mod_articles_latest (Latest Articles) (5.72KB) (0.08%)
    278μs
    1 x afterRenderModule mod_articles_latest (Recent Projects) (7.34KB) (0.07%)
    249μs
    1 x afterRenderModule mod_menu (PK_Footer_Menu) (10.72KB) (0.05%)
    181μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.13KB) (0.05%)
    172μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (24B) (0.04%)
    140μs
    1 x afterRenderModule mod_custom (LSAA_Logo_Only) (2.73KB) (0.04%)
    134μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Projects) (424B) (0.03%)
    101μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Articles) (2.74KB) (0.02%)
    83μs
    1 x beforeRenderRawModule mod_menu (PK_Footer_Menu) (632B) (0.02%)
    63μs
    1 x beforeRenderRawModule mod_custom (LSAA_Logo_Only) (2.24KB) (0.02%)
    59μs
    1 x Before Access::getAssetRules (id:1322 name:com_content.article.690) (18.65KB) (0.02%)
    58μs
    1 x beforeRenderRawModule mod_articles_popular (Popular Articles) (1.34KB) (0.02%)
    52μs
    1 x Before Access::preloadPermissions (com_content) (1.73KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_articles_popular (Popular Articles) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_articles_latest (Latest Articles) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_articles_latest (Recent Projects) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_menu (Main Menu - Off Canvas) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (PK_Footer_Menu) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (LSAA_Logo_Only) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
64 statements were executed, 24 of which were duplicates, 40 unique40.08ms819.97KB
  • SELECT @@SESSION.sql_mode;69μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `evapj_session` WHERE `session_id` = ?3.93ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = :session_id LIMIT 1147μ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)4.09ms944BParams/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` = 191μs57.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `evapj_viewlevels`51μ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` = :guest45μ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`64μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `evapj_template_styles` WHERE `client_id` = 0 AND `home` = 156μ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`6.67ms164.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`1.76ms3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC66μ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` = 188μ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)130μ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` = 0173μs81.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `evapj_content`383μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `evapj_content` SET `hits` = (`hits` + 1) WHERE `id` = '690'2.61ms1.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)438μ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`194μ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)775μ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`226μ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 ASC143μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 345362μs520B/components/com_droppics/models/frontcategories.php:143Copy
  • SELECT id FROM evapj_categories as c WHERE c.parent_id = 34564μs0B/components/com_droppics/models/frontcategories.php:144Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 345120μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 34537μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 36387μs536B/components/com_droppics/models/frontcategories.php:156Copy
  • SELECT parent_id FROM evapj_categories as c WHERE c.id = 36335μs0B/components/com_droppics/models/frontcategories.php:157Copy
  • SELECT theme FROM evapj_droppics WHERE id='345'423μs536B/administrator/components/com_droppics/models/gallery.php:212Copy
  • SELECT theme FROM evapj_droppics WHERE id='345'53μs0B/administrator/components/com_droppics/models/gallery.php:213Copy
  • SELECT params FROM evapj_droppics WHERE id='345'138μ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='345' ORDER BY position ASC3.59ms17.58KB/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='345' ORDER BY position ASC66μ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=345 AND c.extension="com_droppics" ORDER BY c.lft ASC364μ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=345 AND c.extension="com_droppics" ORDER BY c.lft ASC52μ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=345) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC515μ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=345) AND c.extension="com_droppics" GROUP BY p.id_gallery ORDER BY c.lft ASC,p.position ASC51μ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 DESC583μs1.91KBParams/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`132μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_template_styles` WHERE `client_id` = 0 AND `id` = '28'94μ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`667μs2.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 42.74ms22.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`175μ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`141μ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`126μ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 41.86ms62.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`235μ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`123μ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.63ms68.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`143μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `evapj_schemaorg` WHERE `itemId` = :itemId AND `context` = :context447μ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)175μ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)129μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT * FROM evapj_jmap_metainfo WHERE `linkurl` = 'https://lsaa.org/projects/special-applications/690-st-margaret-s-velarium-retractable-shade-system,-ascot,-qld-da-2021-entry' AND `published` = 1837μs912B/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM evapj_jmap_canonicals WHERE `linkurl` = 'https://lsaa.org/projects/special-applications/690-st-margaret-s-velarium-retractable-shade-system,-ascot,-qld-da-2021-entry'95μ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` = 1157μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT manifest_cache FROM evapj_extensions WHERE type='component' AND element='com_baforms'46μ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'35μs536B/components/com_baforms/src/Helper/BaformsHelper.php:731Copy
  • SELECT `key` FROM evapj_baforms_api WHERE service = 'balbooa_activation'30μs536B/components/com_baforms/src/Helper/BaformsHelper.php:716Copy
  • SELECT * FROM evapj_jmap_headings WHERE `linkurl` = 'https://lsaa.org/projects/special-applications/690-st-margaret-s-velarium-retractable-shade-system,-ascot,-qld-da-2021-entry'144μ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` = 143μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `evapj_session` WHERE `session_id` = ?210μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `evapj_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?873μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy